ECBUSDOCLINK

index back

EC Business Document Links

Associative table between ECQUEUE, ECTRANSGROUPLOG, and ECPACKAGELOG

PeopleSoft Field NameField TypeColumn TypeDescription
EC_PACKAGE_CNTL_NBCharacter(10)VARCHAR2(10) NOT NULLEC Package Control ID
EC_PACKAGE_VERCharacter(6)VARCHAR2(6) NOT NULLEC Package Version
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
ECQUEUEINSTANCENumber(9,0)DECIMAL(9) NOT NULLElectronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
ECTRANSIDCharacter(15)VARCHAR2(15) NOT NULLElectronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
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
ECBUSDOCIDNumber(9,0)DECIMAL(9) NOT NULLEC Business Document ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19