| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table:
SP_PRBINS_NONVW
|
| 4 |
DBR_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Type
N=Net Change
R=Regenerative
S=Regenerative Select
Default Value: R
|
| 5 |
CURRENT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
08/07/02 EGS (CN#PL880-1): Added.
10/18/02 JC (CN#PL880-1):Added FROM label
1=Date
2=Offset
Default Value: 2
|
| 6 |
CURRENT_DATE1 |
Date(10) |
DATE |
12/20/01 EGS (CN#PL900-1): Added
10/07/02 JC (CN#PL880-1): Added FROM_DATE label
|
| 7 |
CURRENT_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
09/05/01 EGS (CN#PL900-1): Added.
10/07/02 JC (CN#PL880-1): Added FROM_OFFSET label
|
| 8 |
START_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Start Fence
|
| 9 |
END_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
End Fence
Default Value: 365
|
| 10 |
EARLY_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Early Fence
|
| 11 |
LATE_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Late Fence
Default Value: 365
|
| 12 |
CAP_FENCE_OFF |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Capacity Fence
Default Value: 365
|
| 13 |
FCST_FULFILL_OFF |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Forecast Fulfillment Fence
|
| 14 |
PLAN_ITEM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
1=Distribution and Master
2=Master and Material
3=All
4=Distribution Only
5=Master Only
6=Material Only
Default Value: 3
|
| 15 |
SPL_FREEZE_PEGGED |
Character(1) |
VARCHAR2(1) NOT NULL |
11/02/2004 NRA: Added
Y/N Table Edit
Default Value: Y
|
| 16 |
INCL_SALES_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 17 |
INCL_QUOTES |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 18 |
INCL_BUYING_AGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
05/02/02 JNW (CN#PL900-1): Added
Y/N Table Edit
Default Value: Y
|
| 19 |
INCL_STOCK_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 20 |
INCL_TFR_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 21 |
INCL_TFR_PL_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 22 |
INCL_FORECAST |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 23 |
INCL_PURCH_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 24 |
INCL_PURCH_CLOSED |
Character(1) |
VARCHAR2(1) NOT NULL |
INCL_PURCH_CLOSED
Y/N Table Edit
Default Value: Y
|
| 25 |
INCL_PROD_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on
Y/N Table Edit
Default Value: Y
|
| 26 |
INCL_TFR_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 27 |
INCL_PL_PURCH_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 28 |
INCL_PL_PROD_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 29 |
INCL_TFR_PL_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: Y
|
| 30 |
INCL_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
09/03/01 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: Y
|
| 31 |
NET_CHANGE_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
02/11/02 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: N
|
| 32 |
INCL_PRIORITIES |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Demand Priorities
Y/N Table Edit
Default Value: Y
|
| 33 |
INCL_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
09/17/01 EGS (CN#PL900-1): Added
Y/N Table Edit
Default Value: Y
|
| 34 |
FIRM_PLAN_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
09/23/02 EGS (CN#PL880-1): Added.
Y/N Table Edit
Default Value: Y
|
| 35 |
AUTO_MASS_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Mass Maintenance
Y/N Table Edit
Default Value: Y
|
| 36 |
POST_LOAD_SOLVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Solver after Load
1=Material Solver
2=Feasible Solver
3=Enterprise Feasible Solver
|
| 37 |
QUOTE_PERCENT |
Number(3,0) |
SMALLINT NOT NULL |
Acceptance Percentage
Default Value: 100
|
| 38 |
FORECAST_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added
1=Inventory
2=Demand Planning
Default Value: 1
|
| 39 |
FORECAST_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
Forecast Set
Prompt Table:
FORECAST_SET
|
| 40 |
PL_CONS_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/1/99 cn# mg800-12 created field
jaa 10/20/00 (cn# v080-Planning Phoenix). The consumption method is used in both the forecast consumption and within the solvers. Added the label Sales Order Demand Date for the PL_GENERATE_PLAN project.
P=Schedule Date
R=Request Date
Default Value: P
|
| 41 |
PLAN_BUCKET |
Character(1) |
VARCHAR2(1) NOT NULL |
08/03/99 MACN (CN#PL800-33.0) Changed the translate values from D, W, M to 0, 1, 2
0=Daily
1=Weekly
2=Monthly
Default Value: 1
|
| 42 |
FORECAST_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Load
B=Back Load
F=Front Load
Default Value: F
|
| 43 |
ALLOW_FCST_CONSUME |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Forecast Consumption
Y/N Table Edit
Default Value: Y
|
| 44 |
FCST_CONS_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1.0): Added
1=Before Proration
2=After Proration
Default Value: 2
|
| 45 |
PL_DDD_FCST_CNSMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Explode Demand for Consumption
Y/N Table Edit
Default Value: N
|
| 46 |
INCL_SO_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn#mg800-12) added field
Y/N Table Edit
Default Value: Y
|
| 47 |
INCL_MSR_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn# mg800-12) added field
Y/N Table Edit
Default Value: Y
|
| 48 |
INCL_TFR_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn# mg800-12) added field
Y/N Table Edit
Default Value: Y
|
| 49 |
PL_NET_CHG_FCST |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Change Forecast
Y/N Table Edit
Default Value: Y
|
| 50 |
PLANNING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Planning Mode
N=Net Change
R=Regenerative
Default Value: R
|
| 51 |
SOLVER_ITEM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added
1=Distribution
2=Master
3=Material
4=All
Default Value: 4
|
| 52 |
SOLVER_LEVEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: N
|
| 53 |
LOW_LEVEL_CD |
Number(3,0) |
SMALLINT NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 54 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 55 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 56 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 57 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 58 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 59 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
|
| 60 |
SOLVER_LOWER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: N
|
| 61 |
LP_DMD_RUNOVER |
Number(3,0) |
SMALLINT NOT NULL |
Demand Runover
|
| 62 |
LP_LTSHIPPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Late Ship Penalty
|
| 63 |
LP_NEGINVPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Negative Invetory Penalty
|
| 64 |
LP_PRIMSRCPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Primary Sourcing Incentive
|
| 65 |
LP_SUBSTPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Substitution Penalty
|
| 66 |
LP_UNSFSTKPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Unsafe Stock Penalty
|
| 67 |
LP_RESOLVETHRESH |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Enterprise Solver Resolve
|
| 68 |
LP_DEMANDTHRESH |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Enterprise Solver Demand
|
| 69 |
LP_INVHOLDPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Inventory Holding Penalty
|
| 70 |
LP_INVCARRYPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Inventory Carry Over Penalty
|
| 71 |
REGEN_TEMPLATES |
Character(1) |
VARCHAR2(1) NOT NULL |
Regenerate Sourcing Templates
Y/N Table Edit
Default Value: N
|
| 72 |
PL_SEARCH_DEPTH |
Number(2,0) |
SMALLINT NOT NULL |
Search Depth
Default Value: 0
|
| 73 |
PL_ITEM_PREC |
Number(3,0) |
SMALLINT NOT NULL |
10/08/01 EGS (CN#PL900-1): Added.
Default Value: 4
|
| 74 |
PL_COMP_PREC |
Number(3,0) |
SMALLINT NOT NULL |
10/08/01 EGS (CN#PL900-1): Added.
Default Value: 10
|
| 75 |
PL_FORECAST_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
PL_FORECAST_SOURCE
N=No Forecast
P=Published Forecasts
S=Forecast Sets
Default Value: S
|
| 76 |
PL_USE_FC_SETS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Forecast Sets
Y/N Table Edit
Default Value: Y
|
| 77 |
PL_USE_PUB_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Published Forecasts
Y/N Table Edit
Default Value: N
|
| 78 |
DP_PUBLISH_DATE |
Date(10) |
DATE |
DP_PUBLISH_DATE
Prompt Table:
PL_DP_PUB_DT_VW
|
| 79 |
DP_PUB_DATE_LAST |
Character(1) |
VARCHAR2(1) NOT NULL |
03/27/02 PCL (CN#PL900-1.0): Added
Y/N Table Edit
Default Value: Y
|
| 80 |
DP_WEIGHTPROFILE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_WEIGHTPROFILE
|
| 81 |
DP_PUBLISHNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Publish Name
Prompt Table:
PL_DP_PUBNM_VW
|
| 82 |
PL_DP_ARRAY_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
Array Name
Default Value: DP_FORECAST01
Prompt Table:
PL_DP_ARRFLD_VW
|
| 83 |
PL_DP_BU_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
Business Unit Field
Default Value: DP_LOCATION
Prompt Table:
PL_DP_BUFLD_VW
|
| 84 |
PL_DP_FCST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Type
I=Item Based
P=Product Based
|
| 85 |
PL_DP_ITEM_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
Item/Product Field
Default Value: DP_ITEMCODE
Prompt Table:
PL_DP_ITMFLD_VW
|
| 86 |
PL_IP_BU_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
01/07/03 EGS (CN#PL880-1): Added
Default Value: DP_LOCATION
Prompt Table:
PL_IP_BUFLD_VW
|
| 87 |
PL_IP_ITEM_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
01/07/03 EGS (CN#PL880-1): Added
Default Value: DP_ITEMCODE
Prompt Table:
PL_IP_ITMFLD_VW
|
| 88 |
DEL_EXTRA_DMD |
Character(1) |
VARCHAR2(1) NOT NULL |
02/28/02 EGS (CN#PL900-1): Added
Y/N Table Edit
Default Value: Y
|
| 89 |
MULTI_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
06/11/02 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: N
|
| 90 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table:
PL_GROUP_CUR_VW
|
| 91 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
PL_RT_TYPE_VW
|
| 92 |
INV_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
11/25/02 EGS (CN#PL880-1): Added
1=Standard
2=Published
3=Published Override Standard
Default Value: 1
|
| 93 |
PL_IP_PUBLISHNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
11/25/02 EGS (CN#PL880-1): Added
Prompt Table:
PL_IP_PUBNM_VW
|
| 94 |
PL_IP_PUBLISH_DATE |
Date(10) |
DATE |
11/25/02 EGS (CN#PL880-1): Added
Prompt Table:
PL_IP_PUB_DT_VW
|
| 95 |
SHUTDOWN_PI_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
01/29/03 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 96 |
STARTUP_PI_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
01/29/03 EGS (CN#PL880-1): Added.
Y/N Table Edit
Default Value: N
|
| 97 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
Prompt Table:
SPL_DOMN_URL_VW
|
| 98 |
MAPID |
Character(3) |
VARCHAR2(3) NOT NULL |
Map ID
Prompt Table:
FINT_FLDMAP_HD
|