OMEC_NOTESS_VW

(SQL View)
 Index Back

OMEC Order Notes Schedule

This view is based on the order notes and is used in app engine OM_EC Date Initials Issue # Description -------- ---------- ------------------------------- -------------------------------------------------- 010505 sfc F-KNANN-V59N4 Created

SELECT A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.SEQ_NUM , A.NOTE_TYPE , A.STD_NOTE_CD , A.TEXT254 , ' ' FROM %Table(ORD_NOTE) A WHERE A.ORDER_INT_LINE_NO <> 0 AND A.SCHED_LINE_NBR <> 0

  • Related Language Record: OMEC_NOTESS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_OM

    2 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

    Prompt Table: ORD_HEADER

    3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

    Prompt Table: ORD_LINE

    4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

    Prompt Table: ORD_SCHEDULE

    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type

    Prompt Table: NOTE_TYPE

    7 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

    Prompt Table: STD_NOTE

    8 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    9 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