ECAUDIT_03_VW

index back

EC Business Document Links

Associative table between ECQUEUE, ECTRANSGROUPLOG, and ECPACKAGELOG
select distinct ebd.ec_package_cntl_nb, ebd.ec_package_ver, ebd.ec_trans_group_nbr, ebd.ec_trans_group_ver, ebd.ecqueueinstance, ebd.ectransid, ebd.ectransinoutsw, ebd.ecbusdocid, ecq.ecqueuestatus, ecq.ecdriverdttm, ecq.ecappdttm, ecq.ec_queue_cntl_nbr from ps_ecbusdoclink ebd, ps_ecqueue ecq where ebd.ecbusdocid = ecq.ecbusdocid and ebd.ectransid = ecq.ectransid and ebd.ecqueueinstance = ecq.ecqueueinstance and ebd.ectransinoutsw = ecq.ectransinoutsw

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
ECQUEUESTATUSCharacter(1)VARCHAR2(1) NOT NULLEC Queue Status
E=Error
L=Loaded
P=Processed
ECDRIVERDTTMDateTime(26)TIMESTAMPEC Driver Datetime
ECAPPDTTMDateTime(26)TIMESTAMPEC Application Dttm
EC_QUEUE_CNTL_NBRCharacter(32)VARCHAR2(32) NOT NULLEC Queue Control Number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19