ECPACKAGEDETAIL(SQL Table) |
Index Back |
|---|---|
EC Audit Information - PackageThe Package Level is equivalent to the ISA Envelope Control Level |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EC_PACKAGE_CNTL_NB |
Character(10) | VARCHAR2(10) NOT NULL | EC Package Control ID |
| 2 | EC_PACKAGE_VER |
Character(6) | VARCHAR2(6) NOT NULL | EC Package Version |
| 3 | 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 |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | ECAUDITCD | Character(4) | VARCHAR2(4) NOT NULL |
EC Audit Code
FA=Functional Acknowledgement TPTR=Trading Partner Transmission TRNS=EDI Translator Reported VAN=Reported from VAN |
| 6 | STATS_START | DateTime(26) | TIMESTAMP | Start Time For Stats Gathering |
| 7 | STATS_STOP | DateTime(26) | TIMESTAMP | Stop Time For Stats Gathering |
| 8 | ECCOMPLETIONSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
EC Completion Status
FAIL=Transaction Failed Process PASS=Transaction Passed Process |
| 9 | ECLOADTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Load Total |
| 10 | ECERRORTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Error Total |
| 11 | EC_APP_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| 12 | EC_APP_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| 13 | EC_APP_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | EC Application Defined Field |