ORD_CUST_DATA(SQL Table) |
Index Back |
---|---|
Customer's Internal dataThis 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. |
# | 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 |