ECTRANSGROUPDTL(SQL Table) |
Index Back |
|---|---|
EC Audit Information - GroupThe Group Level is equivalent to the GS Group Control Level |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EC_TRANS_GROUP_NBR |
Character(18) | VARCHAR2(18) NOT NULL | EC Transaction Group Cntl Nbr |
| 2 | EC_TRANS_GROUP_VER |
Character(6) | VARCHAR2(6) NOT NULL | EC Transaction Group 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 | EC_APP_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| 10 | EC_APP_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| 11 | EC_APP_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | EC Application Defined Field |