ECTRANSGROUPDTL

index back

EC Audit Information - Group

The Group Level is equivalent to the GS Group Control Level

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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19