ECTRANSGROUPDTL |
index back |
|---|---|
EC Audit Information - Group |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 EC_TRANS_GROUP_NBR |
Character(18) | VARCHAR2(18) NOT NULL | EC Transaction Group Cntl Nbr |
| EC_TRANS_GROUP_VER |
Character(6) | VARCHAR2(6) NOT NULL | EC Transaction Group Version |
| 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 |
| SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 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 |
| STATS_START | DateTime(26) | TIMESTAMP | Start Time For Stats Gathering |
| STATS_STOP | DateTime(26) | TIMESTAMP | Stop Time For Stats Gathering |
| ECCOMPLETIONSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
EC Completion Status
FAIL=Transaction Failed Process PASS=Transaction Passed Process |
| EC_APP_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| EC_APP_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| EC_APP_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | EC Application Defined Field |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |