DP_IPMMOPER_AET(SQL Table) |
Index Back |
|---|---|
Mass Maint Spec OperatorsMass Maintenance Specification Operators |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DP_POLICYSET |
Character(10) | VARCHAR2(10) NOT NULL | DP_POLICYSET |
| 3 | DP_IPP_MASSSPEC |
Character(20) | VARCHAR2(20) NOT NULL | Mass Maintenance Specification |
| 4 | DP_ROWNUMBER |
Number(5,0) | INTEGER NOT NULL | DP_ROWNUMBER |
| 5 | DP_IPPMASS_GROUP | Character(2) | VARCHAR2(2) NOT NULL |
Mass Maintenance Group
CP=Standard Cost and Price GN=General Policy Item Data MM=Minimum & Maximum OD=Order Details OQ=Order Quantity Policy RO=Reorder Point Policy SS=Safety Stock Policy ST=Static Calculation Policy UF=User Data Fields |
| 6 | DP_OPERATORS | Character(4) | VARCHAR2(4) NOT NULL |
DP_OPERATORS
ADD=Add BLK=Blank CALC=Calculation Code DIV=Divide MOVE=Move MULT=Multiply REPL=Replace SUB=Subtract |
| 7 | DP_OPERANDS | Character(30) | VARCHAR2(30) NOT NULL | DP_OPERANDS |
| 8 | DP_TARGETFIELD | Character(20) | VARCHAR2(20) NOT NULL |
DP_TARGETFIELD
Prompt Table: DP_IPPFLDSEL_VW |
| 9 | DP_SOURCEFIELD | Character(20) | VARCHAR2(20) NOT NULL |
DP_SOURCEFIELD
Prompt Table: DP_IPPFLDSEL_VW |
| 10 | DP_IPP_SOURCEFIELD | Character(23) | VARCHAR2(23) NOT NULL | Date Initials Reference # Description 121907 MP F-MILIZ-85E75_IPP New Functionality/Field |
| 11 | DP_DATATYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_DATATYPE
0=Character 1=Long Character 2=Number 3=Signed Number 4=Date |
| 12 | DP_DYNAMIC_SQL | Character(254) | VARCHAR2(254) NOT NULL | DP_DYNAMIC_SQL |