DP_RUN_CNTL_IP(SQL Table) |
Index Back |
|---|---|
Demand Planning Run Control |
| # | 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 | DP_POLICYSET |
Character(10) | VARCHAR2(10) NOT NULL |
DP_POLICYSET
Prompt Table: DP_POLS2USER_VW |
| 4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DP_INHERIT_ONLYALL | Character(1) | VARCHAR2(1) NOT NULL |
DP_INHERIT_ONLYALL
0=Inherit All 1=Inherit Only Default Value: 0 |
| 6 | DP_ORDER_POLICY | Character(1) | VARCHAR2(1) NOT NULL |
DP_ORDER_POLICY
Y/N Table Edit Default Value: N |
| 7 | DP_SAFETY_STOCK | Character(1) | VARCHAR2(1) NOT NULL |
DP_SAFETY_STOCK
Y/N Table Edit Default Value: N |
| 8 | DP_REORDER_POINT | Character(1) | VARCHAR2(1) NOT NULL |
DP_REORDER_POINT
Y/N Table Edit Default Value: N |
| 9 | DP_MINMAX_POLICY | Character(1) | VARCHAR2(1) NOT NULL |
DP_MINMAX_POLICY
Y/N Table Edit Default Value: N |
| 10 | DP_COST_DETAILS | Character(1) | VARCHAR2(1) NOT NULL |
Cost Details
Y/N Table Edit Default Value: N |
| 11 | DP_LEADTIME_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Lead Time
Y/N Table Edit Default Value: N |
| 12 | DP_ORDER_MULTIPLE | Character(1) | VARCHAR2(1) NOT NULL |
Order Multiple
Y/N Table Edit Default Value: N |
| 13 | DP_USAGE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Usage Method
Y/N Table Edit Default Value: N |
| 14 | DP_STATCALC_POLICY | Character(1) | VARCHAR2(1) NOT NULL |
Static Method
Y/N Table Edit Default Value: N |