ECBUSDOCID0=Logged
1=Pre-Loaded
2=Error
3=Loaded
4=File Not Found
Default Value: 0
ECBUSHDR_IN_VW(SQL View) |
Index Back |
|---|---|
EC Bus Doc Data Header Inbound |
| select distinct ps_ecbusdochdr.ecbusdocid, ecbusdocstatus from ps_ecbusdochdr, PS_ECBUSDOCLN where ps_ecbusdochdr.ecbusdocid = PS_ECBUSDOCLN.ecbusdocid and ps_ecbusdochdr.ectransinoutsw = 'I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECBUSDOCID |
Number(9,0) | DECIMAL(9) NOT NULL | EC Business Document ID |
| 2 | ECBUSDOCSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
0=Logged 1=Pre-Loaded 2=Error 3=Loaded 4=File Not Found Default Value: 0 |