DP_IPPMASS_OPER(SQL Table) |
Index Back |
---|---|
Mass Maint Spec OperatorsMass Maintenance Specification Operators |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DP_POLICYSET | Character(10) | VARCHAR2(10) NOT NULL |
DP_POLICYSET
Prompt Table: DP_SI_PS1USR_VW |
2 | DP_IPP_MASSSPEC | Character(20) | VARCHAR2(20) NOT NULL | Mass Maintenance Specification |
3 | DP_ROWNUMBER | Number(5,0) | INTEGER NOT NULL | DP_ROWNUMBER |
4 | 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 |
5 | 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 |
6 | DP_OPERANDS | Character(30) | VARCHAR2(30) NOT NULL | DP_OPERANDS |
7 | DP_TARGETFIELD | Character(20) | VARCHAR2(20) NOT NULL |
DP_TARGETFIELD
Prompt Table: DP_IPPFLDSEL_VW |
8 | DP_IPP_SOURCEFIELD | Character(23) | VARCHAR2(23) NOT NULL |
Date Initials Reference # Description
121907 MP F-MILIZ-85E75_IPP New Functionality/Field
Prompt Table: DP_IPPFLDSEL_VW |