OMEC_ORDHCD_LVW

(SQL View)
 Index Back

Customer's Internal data-Hdr

This record contains the customer's internal system data. The data stored in this table is passed in from the customer. There is no processing against the data stored in this record. It is used primarily as 'pass-thru' data only. Date Initials Issue Description 031501 dms SP2 (DI-EDWONG-14) CRM Integration

SELECT B.SOURCE_CD , A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.SEQ_NUM , A.LANGUAGE_CD , A.TEXT80 FROM PS_OMEC_ORD_CDATA B , PS_OMEC_CDATA_LANG A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.ORDER_NO AND A.ORDER_INT_LINE_NO = B.ORDER_INT_LINE_NO AND A.SCHED_LINE_NBR = B.SCHED_LINE_NBR AND A.SEQ_NUM = B.SEQ_NUM AND B.ORDER_INT_LINE_NO = 0 AND B.SCHED_LINE_NBR = 0

  • Related Language Record for OMEC_ORDHCDT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 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
    4 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    5 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 TEXT80 Character(80) VARCHAR2(80) NOT NULL 80 Char text field