ECNAMES

index back

EC TP Names Staging Area


  • Parent record: ECQUEUE
  • PeopleSoft Field Name Field Type Column Type Description
    ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
    ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic 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)
    ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic 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_LINE_NO Number(3,0) SMALLINT NOT NULL EC Document Line Number
    EC_DTL_LINE_NO Number(3,0) SMALLINT NOT NULL EC Detail Line Number
    ECENTITYCD Character(8) VARCHAR2(8) NOT NULL PeopleSoft Entity Code

    Prompt Table: ECENTITYCDS

    EC_ID_TYPE Character(4) VARCHAR2(4) NOT NULL EC Entity Identifier Type
    EC_INTERNAL_ID Character(15) VARCHAR2(15) NOT NULL EC Internal ID
    EC_NAME Character(20) VARCHAR2(20) NOT NULL EC Business Name
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19