| # |
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 |
CAPACITY_FEASIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Make Plan Capacity Feasible
Y/N Table Edit
Default Value: Y
|
| 5 |
MATRL_REALLOCATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Material Reallocation
Y/N Table Edit
Default Value: N
|
| 6 |
ALTERNATE_ROUTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Alternate Routing
Y/N Table Edit
Default Value: N
|
| 7 |
ITEM_SUBSTITUTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Item Substitution
Y/N Table Edit
Default Value: N
|
| 8 |
RUN_LATE_PHASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Lateness Phase
Y/N Table Edit
Default Value: N
|
| 9 |
RUN_EXCESS_PHASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Excess Inventory Phase
Y/N Table Edit
Default Value: N
|
| 10 |
FP_IGNORE_SAFETY |
Character(1) |
VARCHAR2(1) NOT NULL |
FP_IGNORE_SAFETY
1=Ignore Prior to First Demand
2=Ignore
3=Fulfill
Default Value: 3
|
| 11 |
FP_PLANNING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
FP_PLANNING_MODE
N=Net Change
R=Regenerative
Default Value: R
|
| 12 |
RESCHEDULE_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Rescheduling
Y/N Table Edit
Default Value: N
|
| 13 |
FP_CALC_LLC |
Character(1) |
VARCHAR2(1) NOT NULL |
FP_CALC_LLC
Y/N Table Edit
Default Value: N
|
| 14 |
REGEN_FORECAST |
Character(1) |
VARCHAR2(1) NOT NULL |
07/17/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 15 |
USE_XFER_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used for feasible solver run control.
Y/N Table Edit
Default Value: N
|
| 16 |
START_PLUGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
START_PLUGIN
Y/N Table Edit
Default Value: N
|
| 17 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
Prompt Table:
SPL_DOMN_URL_VW
|
| 18 |
COLLECT_FINISH_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Post-Solver Violations
Y/N Table Edit
|
| 19 |
COLLECT_START_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-Solver Violations
Y/N Table Edit
|
| 20 |
CANCEL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Status field
Y/N Table Edit
Default Value: Y
|
| 21 |
CANCEL_ENTERED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Entered Production
Y/N Table Edit
Default Value: Y
|
| 22 |
CANCEL_FIRMED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Production
Y/N Table Edit
Default Value: Y
|
| 23 |
CANCEL_INPRCS_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel In-Process Production
Y/N Table Edit
Default Value: Y
|
| 24 |
CANCEL_RELEASED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Released Production
Y/N Table Edit
Default Value: Y
|
| 25 |
CANCEL_TRANSFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Order
Y/N Table Edit
Default Value: Y
|
| 26 |
CANCEL_FIRM_PLPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Production
Y/N Table Edit
Default Value: Y
|
| 27 |
CANCEL_FIRM_PLTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Transfer
Y/N Table Edit
Default Value: Y
|
| 28 |
CANCEL_FIRM_PLPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Purchase Order
Y/N Table Edit
Default Value: Y
|
| 29 |
CANCEL_PID |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Order
Y/N Table Edit
Default Value: Y
|