ORD_CDATA_EC

(SQL Table)
 Index Back

OM Ord Cdata Staging

OM Ord Customer Internal Data Staging

  • Related Language Record: ORD_CDATA_EC_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
    601=Consumer Sync
    701=BOM Sync
    801=Item Revision
    901=Item Bus Unit Sync
    902=Item Sync
    2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_OM_NONVW

    7 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    8 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID
    9 TEXT80 Character(80) VARCHAR2(80) NOT NULL 80 Char text field
    10 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
    0=New
    1=Error
    2=Complete
    3=In Process
    4=Reprocess
    5=Incomplete
    6=Cancelled
    7=Hold
    11 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance