PL_ORD_HEADER(SQL Table) |
Index Back |
|---|---|
PL Sales Header Optimization08/16/01 JNW (CN#PL900-1.0): Added |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
|
| 2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 3 | 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 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 5 | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID | |
| 6 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 7 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 8 | ORDER_DATE | Date(10) | DATE | Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 9 | START_DT | Date(10) | DATE | Start Date |
| 10 | GRACE_END_DT | Date(10) | DATE | Grace End Date |
| 11 | ORDER_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Order Status
C=Closed O=Open P=Pending X=Canceled |
| 12 | ORDER_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Order Type
QUO=Sales Quote SO=Sales Order |
| 13 | QUOTE_DUE_DATE | Date(10) | DATE | Quote Due Date |
| 14 | QUOTE_EXPIRE_DT | Date(10) | DATE | Quote Expiration Date |
| 15 | SUCCESS_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Success Percent |
| 16 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |