DP_IPRDOUPD_RUN

(SQL Table)
Index Back

DPIP RDO Update Runcntl

DPIP 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