ECTRANSSET_EC

index back

EC Trans Set Audit Log


  • Parent record: ECBUSDOCHDR
  • PeopleSoft Field NameField TypeColumn TypeDescription
    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)
    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.
    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
    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
    EC_QUEUE_CNTL_NBRCharacter(32)VARCHAR2(32) NOT NULLEC Queue Control Number
    ECRELATEDTRANSIDCharacter(15)VARCHAR2(15) NOT NULLEC Related Transaction ID
    ECRELATEDINOUTSWCharacter(1)VARCHAR2(1) NOT NULLEC Related In/Out Switch
    ECCUSTVNDRVALCharacter(15)VARCHAR2(15) NOT NULLPS Customer/Vendor Number
    ECENTITYCD_EXTCharacter(8)VARCHAR2(8) NOT NULLEc Entity Code for External ID

    Prompt Table: ECENTITYCDS

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19