ECQUEUE

Return to Index

Table: PS_ECQUEUE

Electronic Commerce Queue

  • Parent record: ECBUSDOCHDR

    • PeopleSoft Field NameDescription
    ECTRANSIDElectronic 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)
    ECQUEUEINSTANCEElectronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
    ECTRANSINOUTSWElectronic 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
    ECBUSDOCIDEC Business Document ID
    ECQUEUESTATUSEC Queue Status
    E=Error
    L=Loaded
    P=Processed
    ECACTIONCDEC Action Code
    ECDRIVERDTTMEC Driver Datetime
    ECAPPDTTMEC Application Dttm
    BUSINESS_UNITBusiness Unit
    ECENTITYCD_BUEC Entity Code for Bus Unit

    Prompt Table: ECENTITYCDS

    ECCUSTVNDRVALPS Customer/Vendor Number
    ECENTITYCD_EXTEc Entity Code for External ID

    Prompt Table: ECENTITYCDS

    EC_QUEUE_CNTL_NBREC Queue Control Number

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010