DP_IPINHER_AET

(SQL Table)
Index Back

IP Inherit Policy AE Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
4 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
7 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
8 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE
9 DP_INHERIT_ONLYALL Character(1) VARCHAR2(1) NOT NULL DP_INHERIT_ONLYALL
0=Inherit All
1=Inherit Only
10 DP_COUNTER Number(5,0) INTEGER NOT NULL DP_COUNTER
11 DP_POLICYCONTROL Character(20) VARCHAR2(20) NOT NULL DP_POLICYCONTROL
12 DP_POLICYSTARTPD Number(3,0) SMALLINT NOT NULL DP_POLICYSTARTPD
13 DP_POLICYSTARTYR Number(4,0) SMALLINT NOT NULL DP_POLICYSTARTYR
14 DP_ORDER_POLICY Character(1) VARCHAR2(1) NOT NULL DP_ORDER_POLICY
15 DP_SAFETY_STOCK Character(1) VARCHAR2(1) NOT NULL DP_SAFETY_STOCK

Y/N Table Edit

16 DP_REORDER_POINT Character(1) VARCHAR2(1) NOT NULL DP_REORDER_POINT

Y/N Table Edit

17 DP_MINMAX_POLICY Character(1) VARCHAR2(1) NOT NULL DP_MINMAX_POLICY
18 DP_COST_DETAILS Character(1) VARCHAR2(1) NOT NULL Cost Details
19 DP_LEADTIME_FLG Character(1) VARCHAR2(1) NOT NULL Lead Time
20 DP_ORDER_MULTIPLE Character(1) VARCHAR2(1) NOT NULL Order Multiple
21 DP_USAGE_METHOD Character(1) VARCHAR2(1) NOT NULL Usage Method
22 DP_STATCALC_POLICY Character(1) VARCHAR2(1) NOT NULL Static Method
23 DP_TEMP_FIELD Character(1) VARCHAR2(1) NOT NULL DP_TEMP_FIELD