ECNAMES

index back

EC TP Names Staging Area


  • Parent record: ECQUEUE
  • PeopleSoft Field NameField TypeColumn TypeDescription
    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
    EC_LINE_NONumber(3,0)SMALLINT NOT NULLEC Document Line Number
    EC_DTL_LINE_NONumber(3,0)SMALLINT NOT NULLEC Detail Line Number
    ECENTITYCDCharacter(8)VARCHAR2(8) NOT NULLPeopleSoft Entity Code

    Prompt Table: ECENTITYCDS

    EC_ID_TYPECharacter(4)VARCHAR2(4) NOT NULLEC Entity Identifier Type
    EC_INTERNAL_IDCharacter(15)VARCHAR2(15) NOT NULLEC Internal ID
    EC_NAMECharacter(20)VARCHAR2(20) NOT NULLEC Business Name
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19