RUN_CNTL_PL3000(SQL Table) |
Index Back |
|---|---|
Planning Inconsistency Report09/10/02 EGS (CN#PL880): Added. 11/14/02 MP Probinst field added. |
| # | 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 | BU_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
08/16/01 EGS (CN#PL880-1.0): Added
Prompt Table: PL_GROUP_IN_VW |
| 4 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 5 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table: INV_ITEM_GROUP |
| 6 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL |
Family
Prompt Table: INV_ITEM_FAM |
| 7 | 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 |
| 8 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL |
Planner Code
Prompt Table: PLANNER_TBL |
| 9 | UTILIZ_CD | Character(4) | VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table: UTILIZ_TYPE_INV |
| 10 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |