DP_IPPMASS_OPER

(SQL Table)
Index Back

Mass Maint Spec Operators

Mass 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