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 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
5 | CNTRCT_ID | 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 |