PL_ORD_HEADER

(SQL Table)
Index Back

PL Sales Header Optimization

08/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