DP_IPMACALC_AET(SQL Table) |
Index Back |
|---|---|
DP_MASSCALC_AETDP_MASSCALC_AET |
| # | 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 | DP_POLICYSET | Character(10) | VARCHAR2(10) NOT NULL | DP_POLICYSET |
| 5 | DP_IPP_MASSSPEC | Character(20) | VARCHAR2(20) NOT NULL | Mass Maintenance Specification |
| 6 | DP_STATCALC_POLICY | Character(1) | VARCHAR2(1) NOT NULL | Static Method |
| 7 | DP_BUILDCAPDESC | Character(1) | VARCHAR2(1) NOT NULL |
DP_BUILDCAPDESC
B=Build Caption and Description C=Build Caption Only D=Build Description Only |
| 8 | DP_OQLIMITMETHOD | Character(4) | VARCHAR2(4) NOT NULL |
DP_OQLIMITMETHOD
0=None 1=Days Supply 2=Fixed Quantity |
| 9 | DP_ORDER_MULTIPLE | Character(1) | VARCHAR2(1) NOT NULL | Order Multiple |
| 10 | DP_ORDER_POLICY | Character(1) | VARCHAR2(1) NOT NULL | DP_ORDER_POLICY |
| 11 | DP_SAFETY_STOCK | Character(1) | VARCHAR2(1) NOT NULL | DP_SAFETY_STOCK |
| 12 | DP_SSLIMITMETHOD | Character(4) | VARCHAR2(4) NOT NULL |
DP_SSLIMITMETHOD
0=None 1=Days Supply 2=Fixed Quantity |
| 13 | DP_REORDER_POINT | Character(1) | VARCHAR2(1) NOT NULL | DP_REORDER_POINT |
| 14 | DP_MINMETHOD | Character(4) | VARCHAR2(4) NOT NULL |
4 & 5 Translate values not used as they were not used in old system
0=None 1=Days Supply 2=Fixed Quantity 3=Safety Stock |
| 15 | DP_MAXMETHOD | Character(4) | VARCHAR2(4) NOT NULL |
DP_MAXMETHOD
0=None 1=Days Supply 2=Fixed Quantity 3=Safety Stock + Order Quantity |
| 16 | DP_ERRORMESSAGE | Character(254) | VARCHAR2(254) NOT NULL | DP_ERRORMESSAGE |
| 17 | DP_MAXPERIODS | Number(3,0) | SMALLINT NOT NULL | DP_MAXPERIODS |