DP_IPMAST_LINES

(SQL Table)
Index Back

IP Master Lines - Period Data

IP Master Lines - Period Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
2 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE
3 DP_LOCATION Character(5) VARCHAR2(5) NOT NULL DP_LOCATION
4 DP_YEAR Number(4,0) SMALLINT NOT NULL DP_YEAR
5 DP_PERIOD Number(3,0) SMALLINT NOT NULL DP_PERIOD
6 DP_COST Number(15,4) DECIMAL(14,4) NOT NULL DP_COST
7 DP_FORECASTVALUE Number(15,4) DECIMAL(14,4) NOT NULL DP_FORECASTVALUE
8 DP_INDIRECTDEMAND Number(15,4) DECIMAL(14,4) NOT NULL DP_INDIRECTDEMAND
9 DP_ORDERQUANTITY Number(15,4) DECIMAL(14,4) NOT NULL DP_ORDERQUANTITY
10 DP_SAFETYSTOCK Number(15,4) DECIMAL(14,4) NOT NULL DP_SAFETYSTOCK
11 DP_REORDERPOINT Number(15,4) DECIMAL(14,4) NOT NULL DP_REORDERPOINT
12 DP_SERVICEFILL Number(13,2) DECIMAL(12,2) NOT NULL DP_SERVICEFILL
13 DP_AVGINVENTORY Number(15,4) DECIMAL(14,4) NOT NULL DP_AVGINVENTORY
14 DP_TURNRATE Number(13,2) DECIMAL(12,2) NOT NULL DP_TURNRATE
15 DP_MINIMUM Number(15,4) DECIMAL(14,4) NOT NULL DP_MINIMUM
16 DP_MAXIMUM Number(15,4) DECIMAL(14,4) NOT NULL DP_MAXIMUM