| # |
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
Prompt Table:
PL_PI_BU_IN_VW
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
PL_PI_BU_ITM_VW
|
| 4 |
CFG_CODE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both
N=No
Y=Yes
Y/N Table Edit
|
| 5 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
Y/N Table Edit
|
| 6 |
PHANTOM_ITEM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Phantom Item
Y/N Table Edit
|
| 7 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 8 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 9 |
ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down
N=Natural Round
U=Round Up
|
| 10 |
PL_ITEM_PREC |
Number(3,0) |
SMALLINT NOT NULL |
10/08/01 EGS (CN#PL900-1): Added.
|
| 11 |
PLANNED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
|
| 12 |
DEMAND_FENCE_DATE |
Date(10) |
DATE |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 13 |
FCST_PRI_RANK |
Number(3,0) |
SMALLINT NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 14 |
SAFETY_PRI_RANK |
Number(3,0) |
SMALLINT NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 15 |
SALES_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Consumption
Y/N Table Edit
Default Value: N
|
| 16 |
PROD_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Consumption
Y/N Table Edit
Default Value: N
|
| 17 |
TRANS_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Consumption
Y/N Table Edit
Default Value: N
|
| 18 |
MSR_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
10/12/01 EGS (CN#PL900-1): Added
Y/N Table Edit
Default Value: N
|
| 19 |
EXTRA_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
09/30/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 20 |
PL_AGG_DMD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Aggregate Demand
Y/N Table Edit
|
| 21 |
PL_ITEM_EXPL |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/1/99 (cn# mg800-12) created field
|
| 22 |
FCST_FULFILL_SIZE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Forecast Fulfillment Size
|
| 23 |
FCST_ADJ_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
02/28/02 EBN (CN#PL900-1.0): Added.
1=No Adjustment
2=Allocate to Next Bucket
3=Allocate to Last Bucket
4=Allocate Evenly Across Buckets
5=Allocate Using Calendar Weight
|
| 24 |
PL_FIXED_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Fixed Period (days)
|
| 25 |
ITEM_EARLY_DATE |
Date(10) |
DATE |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 26 |
PL_SEARCH_DEPTH |
Number(2,0) |
SMALLINT NOT NULL |
Search Depth
|
| 27 |
PL_SHIFT_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reschedule Early Limit
|
| 28 |
LOW_LEVEL_CD |
Number(3,0) |
SMALLINT NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 29 |
INV_QTY_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 30 |
INV_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 31 |
QTY_AVAIL |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Available
|
| 32 |
QTY_RESERVED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Reserved
|
| 33 |
STAGED_INF_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 34 |
STAGED_ITEM_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 35 |
QUAR_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 36 |
SHIP_NOT_DEPL_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 37 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 38 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 39 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 40 |
PHASE_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
Y/N Table Edit
|
| 41 |
ITM_STATUS_EFFDT |
Date(10) |
DATE |
Item Status Date
|
| 42 |
PL_PROJ_USE_DT |
Date(10) |
DATE |
11/04/02 JC (CN#PL880-1): Added USEUP_DATE label
|
| 43 |
PL_PROJ_USE_QOH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
11/03/02 JC (CN#PL880-1): Added QOH_USEUP label
12/18/02 EGS (CN#PL880-1): Changed to 11.4.
|
| 44 |
REF_ROUTING_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
Reference Routing Item
|
| 45 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 46 |
NET_CHANGE_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
02/11/02 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: N
|
| 47 |
LOT_FOR_LOT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
05/06/02 EGS (CN#PL900-1): Added
|
| 48 |
DP_WEIGHTPROFILE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_WEIGHTPROFILE
|
| 49 |
UTILIZ_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count
|
| 50 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
|
| 51 |
SOURCE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
|
| 52 |
PL_UNIT_COST |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
09/27/02 EGS (CN#PL880-1): Changed to 13.4
|
| 53 |
SPOT_BUY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/24/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 54 |
AOQ |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Average Order Qty
|
| 55 |
PL_RESCHEDULE_TOL |
Number(3,0) |
SMALLINT NOT NULL |
Reschedule Tolerance(In days)
Default Value: 0
|
| 56 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|