| # |
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 |
PL_SEQ_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
01/09/02 EGS (CN#PL900-1): Added
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
PL_PLNPOBU_VW
|
| 4 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 5 |
PL_PLAN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
|
| 6 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
PL_PLNPOITEM_VW
|
| 7 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
PL_PURCHOPT1_VW
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
PL_PLNPOVDR_VW
|
| 9 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
PL_PURCHOPT3_VW
|
| 10 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 11 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table:
PL_BU_CFG_VW
|
| 12 |
PLAN_RELEASE_DTTM |
DateTime(26) |
TIMESTAMP |
Plan Release Date Time
|
| 13 |
DUE_DTTM |
DateTime(26) |
TIMESTAMP NOT NULL |
Due Datetime
|
| 14 |
PL_PO_LEAD_TIME |
Number(10,0) |
DECIMAL(10) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
|
| 15 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 16 |
REMAINING_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 17 |
PLAN_FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
Y/N Table Edit
|
| 18 |
INCL_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Quantity
B=Both
N=No
Y=Yes
Y/N Table Edit
|
| 19 |
APPROVED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved by Auditor
D=Denied
N=Not Approved
Y=Approved
Y/N Table Edit
Default Value: N
|
| 20 |
SPOT_BUY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/24/02 EGS (CN#PL880-1): Added
Y/N Table Edit
|
| 21 |
PL_AUC_SOURCING_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Sourcing Business Unit
|
| 22 |
AUC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Event ID
|
| 23 |
AUC_ROUND |
Number(5,0) |
INTEGER NOT NULL |
Event Round
|
| 24 |
AUC_VERSION |
Number(5,0) |
INTEGER NOT NULL |
Event Version
|
| 25 |
PL_ORDER_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
RAG# Added filed for Planning Phoneix.
BA=Buying Agreement
NFC=Net Forecast
PDN=Production Order
PLN=Planned Order
PPO=Planned Purchase Order
PPR=Planned Production
PSS=Strategic Sourcing Event
PTR=Planned Transfer
PUR=Purchase Order
SO=Sales Order
SOH=Starting On Hand Qty
SR=Material Stock Request
TFR=Transfer
XD=Extra Demand
|
| 26 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Default Value: 0
|
| 27 |
LOAD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Flag
Default Value: Y
|
| 28 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|