ECTRANSGROUPDTL

index back

EC Audit Information - Group

The Group Level is equivalent to the GS Group Control Level

PeopleSoft Field NameField TypeColumn TypeDescription
EC_TRANS_GROUP_NBRCharacter(18)VARCHAR2(18) NOT NULLEC Transaction Group Cntl Nbr
EC_TRANS_GROUP_VERCharacter(6)VARCHAR2(6) NOT NULLEC Transaction Group Version
ECTRANSINOUTSWCharacter(1)VARCHAR2(1) NOT NULLElectronic 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_NBRNumber(2,0)SMALLINT NOT NULLSequence Number
ECAUDITCDCharacter(4)VARCHAR2(4) NOT NULLEC Audit Code
FA=Functional Acknowledgement
TPTR=Trading Partner Transmission
TRNS=EDI Translator Reported
VAN=Reported from VAN
STATS_STARTDateTime(26)TIMESTAMPStart Time For Stats Gathering
STATS_STOPDateTime(26)TIMESTAMPStop Time For Stats Gathering
ECCOMPLETIONSTATUSCharacter(4)VARCHAR2(4) NOT NULLEC Completion Status
FAIL=Transaction Failed Process
PASS=Transaction Passed Process
EC_APP_FIELD_1Character(40)VARCHAR2(40) NOT NULLEC Applicartion Defined Field
EC_APP_FIELD_2Character(40)VARCHAR2(40) NOT NULLEC Applicartion Defined Field
EC_APP_FIELD_3Character(40)VARCHAR2(40) NOT NULLEC Application Defined Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19