DP_IPRDOUPD_RUN(SQL Table) |
Index Back |
---|---|
DPIP RDO Update RuncntlDPIP RDO Update 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). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | DP_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL |
Publish Name
Prompt Table: %EDITTABLE2 |
4 | FORECAST_SET | Character(20) | VARCHAR2(20) NOT NULL | Forecast Set |
5 | DP_IP_SELECTION | Character(2) | VARCHAR2(2) NOT NULL |
DP_IP_SELECTION
DP=Demand Planning IP=Inventory Policy |
6 | DP_FCIP_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
DP_FCIP_OPTION
I=Item Forecast P=Product Forecast Default Value: I |
7 | DP_IPUPD_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Update Method
C=Complete Replacement R=Replace only found |
8 | BUS_UNIT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Option
A=All S=Specific |
9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: %EDITTABLE |
10 | DP_STOCK_UPD | Character(1) | VARCHAR2(1) NOT NULL |
Safety Stock Update
Y/N Table Edit |
11 | DP_UTILATTRIB_UPD | Character(1) | VARCHAR2(1) NOT NULL |
Uitilization Attrib Update
Y/N Table Edit |
12 | DP_REPLATTRIB_UPD | Character(1) | VARCHAR2(1) NOT NULL |
Replenishment Attrib Update
Y/N Table Edit |
13 | DP_PLANATTRIB_UPD | Character(1) | VARCHAR2(1) NOT NULL |
Planning Attributes Update
Y/N Table Edit |
14 | TRANSFER_ORD_MOD | Character(1) | VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit |
15 | PUR_ORDER_MOD | Character(1) | VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit |
16 | MFG_ORDER_MOD | Character(1) | VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit |
17 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |