ECBUSDOCIDI=Inbound
O=Outbound
0=Logged
1=Pre-Loaded
2=Error
3=Loaded
4=File Not Found
Default Value: 0
ECBUSDOCHDR(SQL Table) |
Index Back |
|---|---|
EC Bus Doc Data Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECBUSDOCID |
Number(9,0) | DECIMAL(9) NOT NULL | EC Business Document ID |
| 2 | ECTRANSINOUTSW | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
| 3 | ECBUSDOCSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
0=Logged 1=Pre-Loaded 2=Error 3=Loaded 4=File Not Found Default Value: 0 |
| 4 | ECBUSDOCFILENAME | Character(100) | VARCHAR2(100) NOT NULL | EC Inbound File Name |
| 5 | ECERRORTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Error Total |
| 6 | ECLOADTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Load Total |