| # |
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 |
MRP_INCL_DISTRIB |
Character(1) |
VARCHAR2(1) NOT NULL |
MRP_INCL_DISTRIB
Y/N Table Edit
Default Value: Y
|
| 5 |
MRP_INCL_MASTER |
Character(1) |
VARCHAR2(1) NOT NULL |
MRP_INCL_MASTER
Y/N Table Edit
Default Value: Y
|
| 6 |
MRP_INCL_MAT |
Character(1) |
VARCHAR2(1) NOT NULL |
MRP_INCL_MAT
Y/N Table Edit
Default Value: Y
|
| 7 |
CALC_LLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Low Level Codes
Y/N Table Edit
Default Value: Y
|
| 8 |
DEFER_SUPPLIES |
Character(1) |
VARCHAR2(1) NOT NULL |
Defer Supplies
Y/N Table Edit
Default Value: N
|
| 9 |
PLANNING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Planning Mode
N=Net Change
R=Regenerative
Default Value: R
|
| 10 |
IGNORE_SAFETY |
Character(1) |
VARCHAR2(1) NOT NULL |
Ignore Safety Stock
1=Ignore Prior to First Demand
2=Ignore
3=Fulfill
Default Value: 3
|
| 11 |
REGEN_FORECAST |
Character(1) |
VARCHAR2(1) NOT NULL |
07/17/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 12 |
START_PLUGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
START_PLUGIN
Y/N Table Edit
Default Value: N
|
| 13 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
Prompt Table:
SPL_DOMN_URL_VW
|
| 14 |
COLLECT_FINISH_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Post-Solver Violations
Y/N Table Edit
Default Value: N
|
| 15 |
COLLECT_START_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-Solver Violations
Y/N Table Edit
Default Value: N
|
| 16 |
CANCEL_FIRM_PLPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Purchase Order
Y/N Table Edit
Default Value: Y
|
| 17 |
CANCEL_FIRM_PLPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Production
Y/N Table Edit
Default Value: Y
|
| 18 |
CANCEL_ENTERED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Entered Production
Y/N Table Edit
Default Value: Y
|
| 19 |
CANCEL_FIRMED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Production
Y/N Table Edit
Default Value: Y
|
| 20 |
CANCEL_INPRCS_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel In-Process Production
Y/N Table Edit
Default Value: Y
|
| 21 |
CANCEL_RELEASED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Released Production
Y/N Table Edit
Default Value: Y
|
| 22 |
CANCEL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Status field
Y/N Table Edit
Default Value: Y
|
| 23 |
CANCEL_TRANSFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Order
Y/N Table Edit
Default Value: Y
|
| 24 |
CANCEL_FIRM_PLTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Transfer
Y/N Table Edit
Default Value: Y
|
| 25 |
CANCEL_PID |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Order
Y/N Table Edit
Default Value: Y
|