| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
|
| 2 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 5 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 6 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 7 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
Default Value: 1
|
| 8 |
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
|
| 9 |
PROCESSED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
Y/N Table Edit
Default Value: N
|
| 10 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
|
| 11 |
PL_SEQ_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
01/09/02 EGS (CN#PL900-1): Added
|
| 12 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 13 |
PLANNING_TIMESTAMP |
DateTime(26) |
TIMESTAMP NOT NULL |
Planning Date and Time
|
| 14 |
CANCEL_CHNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Planning Canceled
|
| 15 |
SCHED_CHNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Planning Schedule Change
|
| 16 |
ORIG_DUE_DT |
Date(10) |
DATE |
Original Due Date
|
| 17 |
ORIG_DUE_TIME |
Time(15) |
TIMESTAMP |
Original Time Due
|
| 18 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 19 |
DUE_TIME |
Time(15) |
TIMESTAMP |
Due Time
|
| 20 |
RELEASE_DATE |
Date(10) |
DATE |
Release Date
|
| 21 |
RELEASE_TIME |
Time(15) |
TIMESTAMP |
Release Time
|
| 22 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 23 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
ITM_VENDOR
|
| 24 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VENDOR_LOC_VW
|
| 25 |
PL_PO_LEAD_TIME |
Number(10,0) |
DECIMAL(10) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
|
| 26 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 27 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 28 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 29 |
QTY_PO_STD |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
PO Quantity Standard
|
| 30 |
QTY_CHNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Change Flag for Supply Planning Post Records
Y/N Table Edit
Default Value: N
|
| 31 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 32 |
TOLERANCE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw changed long description for planning phoenix - commit plan
10/18/02 JC (CN#PL880-1): Added TOLERANCE label
|
| 33 |
PL_STATUS_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
08/07/98 SCC CN#APRD-R-SCHEW-8L1TB: Change description for value 10 'Before Planning Time Fence' to 'Expedite'
10=Expedite
20=Accepted Horizon
30=After Cutoff Fence
40=No Time Fence Defined
99=Error/Exception
|
| 34 |
PLAN_FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
|
| 35 |
PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
|
| 36 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 37 |
PL_PO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Type
E=Existing Orders
N=Planned Order
|
| 38 |
CHNG_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor
|
| 39 |
OVERRIDE_SUGG_VNDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Suggested Vendor
Y/N Table Edit
|
| 40 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 41 |
PL_PLAN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
|
| 42 |
CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No indicator
Y/N Table Edit
Default Value: Y
|
| 43 |
SPOT_BUY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/24/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 44 |
PL_AUC_SOURCING_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Sourcing Business Unit
|
| 45 |
AUC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Event ID
|
| 46 |
AUC_ROUND |
Number(5,0) |
INTEGER NOT NULL |
Event Round
|
| 47 |
AUC_VERSION |
Number(5,0) |
INTEGER NOT NULL |
Event Version
|
| 48 |
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
|
| 49 |
SCHED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Flag
|