ORD_NOTE_EC

(SQL Table)
 Index Back

OM Ord Note Staging

OM Ord Note Staging Date Initials Issue Description 030806 deg 1475314001 Added std_note_cd

  • Related Language Record: ORD_NOTE_EC_LNG

    • # 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 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type

    Prompt Table: NOTE_TYPE

    9 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    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 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

    Prompt Table: STD_NOTE

    12 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
    13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance