DP_IPRDOUPD_AET

(SQL Table)
Index Back

DPIP RDO Update Runcntl

DPIP RDO Update Run control

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
5 FORECAST_SET Character(20) VARCHAR2(20) NOT NULL Forecast Set
6 DP_IP_SELECTION Character(2) VARCHAR2(2) NOT NULL DP_IP_SELECTION
DP=Demand Planning
IP=Inventory Policy
7 DP_FCIP_OPTION Character(1) VARCHAR2(1) NOT NULL DP_FCIP_OPTION
I=Item Forecast
P=Product Forecast
8 DP_IPUPD_METHOD Character(1) VARCHAR2(1) NOT NULL Forecast Update Method
C=Complete Replacement
R=Replace only found
9 BUS_UNIT_OPTION Character(1) VARCHAR2(1) NOT NULL Business Unit Option
A=All
S=Specific
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 DP_STOCK_UPD Character(1) VARCHAR2(1) NOT NULL Safety Stock Update

Y/N Table Edit

12 DP_UTILATTRIB_UPD Character(1) VARCHAR2(1) NOT NULL Uitilization Attrib Update

Y/N Table Edit

13 DP_REPLATTRIB_UPD Character(1) VARCHAR2(1) NOT NULL Replenishment Attrib Update
14 DP_PLANATTRIB_UPD Character(1) VARCHAR2(1) NOT NULL Planning Attributes Update

Y/N Table Edit

15 TRANSFER_ORD_MOD Character(1) VARCHAR2(1) NOT NULL Order Modifier

Y/N Table Edit

16 PUR_ORDER_MOD Character(1) VARCHAR2(1) NOT NULL Order Modifier

Y/N Table Edit

17 MFG_ORDER_MOD Character(1) VARCHAR2(1) NOT NULL Order Modifier

Y/N Table Edit