OMEC_CDATAL_VW

(SQL View)
Index Back

OMEC Order Cust Data Line

This view is based on the order customer data 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.REFERENCE_ID , A.TEXT80 , ' ' FROM PS_ORD_CUST_DATA A WHERE A.ORDER_INT_LINE_NO <> 0 AND A.SCHED_LINE_NBR = 0

  • Related Language Record: OMEC_CDATAL_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    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
    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 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID
    7 TEXT80 Character(80) VARCHAR2(80) NOT NULL 80 Char text field
    8 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