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 |