ORD_CUST_DATA

(SQL Table)
Index Back

Customer's Internal data

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.

  • Related Language Record: ORD_CDATA_LANG
  • # 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