Fields Imported and Published by PeopleSoft Inventory Policy Planning

Appendix: Fields Imported and Published by PeopleSoft Inventory Policy Planning

This appendix describes fields published from PeopleSoft Inventory Policy Planning and discusses:

Fields imported into PeopleSoft Inventory Policy Planning.
Fields loaded during external data import.
Inventory policy fields published to PeopleSoft Inventory.
Inventory policy fields that are published to internal sources.

Fields Imported Into PeopleSoft Inventory Policy Planning

When you run the Populate Policy Items process (DP_IPPOPULAT) or the Policy Item Refresh process (DP_IPREFRESH), the data that is placed into PeopleSoft Inventory Policy Planning fields is from PeopleSoft Inventory.

The tables' Description columns in this section provide data selection and usage criteria, as well as how the default control group might affect related field values. The system loads user-defined fields according to how you map the fields.

This section discusses:

Policy fields that are populated from the BU_ITEMS_INV record.
Policy fields that are populated from the MASTER_ITEM_TBL record.
Policy fields that are populated from the BU_ITEM_UTIL_CD record.
Policy fields that are populated from the REPL_SETUP_INV record.
Policy fields that are refreshed from inventory master values.
Policy fields that are refreshed based on user selection.

Policy Fields That Are Populated From the BU_ITEMS_INV Record

This table list fields that are available for population from the PeopleSoft Inventory BU_ITEMS_INV record:

PeopleSoft Inventory Fields PS_BU_ITEMS_INV	Inventory Policy Planning Fields PS_DP_IPMASTER	Description
IP_PLANNING_FLG	This field is used as selection criteria for determining which records will be read from BU_ITEMS_INV. There is no corresponding field in IP.	Value must be Y to populate the record. Set the value using the PeopleSoft Inventory item maintenance feature for items for which you want to create an inventory policy. This setting determines how the system creates items during policy generation and if it publishes replenishment information back to PeopleSoft Inventory. Note. For previous version user, this flag will be loaded from the value in the BU_ITEMS_INV(FORECAST_ITEM_FLAG).
ITM_STATUS_CURRENT	This field is used as selection criteria for determining which records will be read from BU_ITEMS_INV. There is no corresponding field in IP.	Value must be 1 or 5 to populate the record. You can select 1, 5, or both.
DP_POLICYSET	DP_POLICYSET	Defines the key value and determines which policy set to populate.
INV_ITEM_ID	DP_ITEMCODE	Defines the key value.
BUSINESS_UNIT	DP_LOCATION	Defines the key value.
REORDER_POINT	DP_REORDERPOINT	If the value < > 0, then DP_REORDERPOINT = REORDER_POINT. If the value = 0, then DP_REORDERPOINT = 0.
REORDER_POINT	DP_ROPMETHOD	If the value < > 0, then DP_ROPMETHOD = 2. If the value = 0, then DP_ROPMETHOD = DP_ROPMETHOD from the default policy control.
REORDER_POINT	DP_ROPARGUMENT	If the value < > 0, then DP_ROPARGUMENT = REORDER_POINT. If the value = 0, then DP_ROPARGUMENT = DP_ROPARGUMENT from the default policy control.
QTY_MAXIMUM	DP_MAXIMUM	If the value < > 0, then DP_MAXIMUM = QTY_MAXIMUM. If the value = 0 and DP_MAXMETHOD <> 2, then DP_MAXIMUM = 0. If value = 0 and DP_MAXMETHOD = 2, then DP_MAXIMUM = DP_MAXARGUMENT from the policy control.
QTY_MAXIMUM	DP_MAXMETHOD	If the value < > 0, then DP_MAXMETHOD = 2. If the value = 0, then DP_MAXMETHOD= DP_MAXMETHOD from the default policy control.
QTY_MAXIMUM	DP_MAXARGUMENT	If the value < > 0, then DP_MAXARGUMENT = QTY_MAXIMUM. If the value = 0, then DP_MAXARGUMENT = DP_MAXARGUMENT from the default policy control.
System assigned.	DP_MINIMUM	If DP_MINMETHOD from policy control <> 2, then DP_MINIMUM = 0. If DP_MINMETHOD from the default policy control = 2, then DP_MINIMUM = DP_MINARGUMENT from policy control
System assigned.	DP_MINMETHOD	DP_MINMETHOD = DP_MINMETHOD from the policy control.
System assigned.	DP_MINARGUMENT	DP_MINARGUMENT = DP_MINARGUMENT from the policy control.
SAFETY_STOCK	DP_SAFETYSTOCK	If the value < > 0, then DP_SAFETYSTOCK = SAFETY_STOCK. If the value = 0 and DP_SSMETHOD <> 2, then DP_SAFETYSTOCK = 0. If value = 0 and DP_SSMETHOD = 2, then DP_SAFETYSTOCK = DP_SSARGUMENT from policy control
SAFETY_STOCK	.DP_SSMETHOD	If the value < > 0, then DP_SSMETHOD = 2. If the value = 0, then DP_SSMETHOD = DP_SSMETHOD from the default policy control.
SAFETY_STOCK	DP_SSARGUMENT	If the value < > 0, then DP_SSARGUMENT = SAFETY_STOCK. If the value = 0, then DP_SSARGUMENT = DP_SSARGUMENT from the default policy control.
STOCKOUT_RATE	DP_SSMETHOD	If the value < > 0, then DP_SSMETHOD = 3. If the value = 0, then do not change the field.
STOCKOUT_RATE	DP_SSARGUMENT	If the value < > 0, then DP_SSARGUMENT = STOCKOUT_RATE. If the value = 0, then do not change the field.
REPLENISH_LEAD	DP_LEADTIME	If the value < > 0, then DP_LEADTIME = REPLENISH_LEAD. If the value = 0, then DP_LEADTIME = DP_LEADTIME from the default policy control. The value represents the days from which the system recognizes the need of the receipt of purchased or transfer items, and days of cycle time for manufacturing items.
REPLENISH_LEAD	DP_LEADTIMEUOM	The default value is DAY.
REORDER_QTY	DP_ORDERQUANTITY	If the value < > 0, then DP_ORDERQUANTITY = REORDER_QTY. If the value = 0 and DP_OQMETHOD <> 2, then DP_ORDERQUANTITY = 0. If value = 0 and DP_OQMETHOD = 2, then DP_ORDERQUANTITY = DP_OQARGUMENT from the policy control.
REORDER_QTY	DP_OQMETHOD	If the value < > 0, then DP_OQMETHOD = 2. If the value = 0, then DP_OQMETHOD = DP_OQMETHOD from the default policy control.
REORDER_QTY	DP_OQARGUMENT	If the value < > 0, then DP_OQARGUMENT = REORDER_QTY. If the value = 0, then DP_OQARGUMENT = DP_OQARGUMENT from the default policy control.
EOQ	DP_ORDERQUANTITY	If the value < > 0, then DP_ORDERQUANTITY = EOQ, DP_OQMETHOD = 3, and DP_OQARGUMENT = 0. If the value = 0, then do not change the.
EOQ	DP_OQMETHOD	If the value < > 0, then DP_OQMETHOD = 3 If the value = 0, then do not change the field.
EOQ	DP_OQARGUMENT	If the value < > 0, then DP_OQARGUMENT = 0. If the value = 0, then do not change the field.
ORDER_MULTIPLE	DP_ORDERMULT	If the value < > 0, then DP_ORDERMULT = ORDER_MULTIPLE. If the value = 0, then DP_ORDERMULT = DP_ORDERMULT from the default policy control.
DP_POLICYCONTROL	DP_POLICYCONTROL	The system doesn't use the field during populate. It picks up the default policy control from the policy set when it populates the set.
DP_POLICYSET	DP_POLICYSET	The system doesn't use the field when it populates the set.
DP_PUBLISH_DATE	DP_PUBLISH_DATE	The system doesn't use the field when it populates the set.
CONSIGNED_FLAG	Map as user-defined field.	None.
COST_ELEMENT	Map as user-defined field.	None.
COST_GROUP_CD	Map as user-defined field.	None.
EXCESS_INVENTORY	Map as user-defined field.	None.
INV_ITEM_ID	Map as user-defined field.	None.
INV_STOCK_TYPE	Map as user-defined field.	None.
NO_REPLENISH_FLG	Map as user-defined field.	None.
PLANNER_CD	Map as user-defined field.	None.
RELATED_ITEM_ID	Map as user-defined field.	None.
REPLENISH_CLASS	Map as user-defined field.	None.
.SOURCE_CODE	Map as user-defined field.	None.
USE_UP_QOH	Map as user-defined field.	None.
QTY_AVAILABLE	Map as user-defined field.	None.
HISTORICAL_LEAD	Map as user-defined field.	None.
SHELF_LIFE	Map as user-defined field.	None.

Policy Fields That Are Populated From the MASTER_ITEM_TBL Record

This table lists fields that are available for population from the PeopleSoft Inventory MASTER_ITEM_TBL record:

PeopleSoft Inventory Fields PS_MASTER_ITEM_TBL	Inventory Policy Planning Fields PS_DP_IPMASTER	Description
UNIT_MEASURE_STD	DP_INVENTORYUOM	This is the PeopleSoft Inventory master standard unit of measure (UOM). When the system creates items from PeopleSoft Inventory, it sets the UOM to this value automatically. When publishing replenishment information, the quantities can often be required to be in the inventory standard UOM.
INVENTORY_ITEM	This field is used as selection criteria for determining which records will be read from BU_ITEMS_INV. There is no corresponding field in IP.	Field value must be Y or N to populate the record. You can select Y, N, or Both.
CM_METHOD from the CM_ITEM_LED_VW	DP_STANDARDCOST	Represents the typical unit cost of the item. If value = 1, then DP_STANDARDCOST = Sum(CM_UNIT_COST) from PS_CM_ACTUAL_COST If value = 6, then DP_STANDARDCOST = Sum(CM_UNIT_COST) from PS_CM_PERDAVG_COST for the maximum effective date when it is less or equal to currant date if value = 7, then DP_STANDARDCOST = CM_UNIT_COST from PS_CM_PERPAVG for the maximum sequence number if value = 8, then DP_STANDARDCOST = Sum(TL_COST + LL_COST) from PS_CM_PRODCOST for Maximum Effective Date when it is less than or equal to current date if value is distinct from the previous one, the DP_STANDARCCOST = 0
DESCR	Maps to user-defined field.	None.

Policy Fields That Are Populated From the BU_ITEM_UTIL_CD Record

This table lists fields that are available for population from the PeopleSoft Inventory BU_ITEM_UTIL_CD record:

PeopleSoft Inventory Fields PS_BU_ITEM_UTIL_CD	Inventory Policy Planning Fields PS_DP_IPMASTER	Description
UTILIZ_CD	UTILIZ_CD C1	If the value < > ' ', then UTILIZ_CD = UTILIZ_CD. If the value = ' ', then UTILIZ_CD = UTILIZ_CD from the default policy control.
UTILIZ_GROUP	UTILIZ_GROUP	If the value < > ' ', then UTILIZ_GROUP = UTILIZ_GROUP. If the value = ' ', then UTILIZ_GROUP = UTILIZ_GROUP from the default policy control.

PeopleSoft Inventory Fields

PS_BU_ITEM_UTIL_CD

Inventory Policy Planning Fields

PS_DP_IPMASTER

Description

UTILIZ_CD

UTILIZ_CD C1

If the value < > ' ', then UTILIZ_CD = UTILIZ_CD.

If the value = ' ', then UTILIZ_CD = UTILIZ_CD from the default policy control.

UTILIZ_GROUP

If the value < > ' ', then UTILIZ_GROUP = UTILIZ_GROUP.

If the value = ' ', then UTILIZ_GROUP = UTILIZ_GROUP from the default policy control.

Policy Fields That Are Populated From the REPL_SETUP_INV Record

This table list fields that are available for population from the PeopleSoft Inventory PS_REPL_SETUP_INV record:

PeopleSoft Inventory Fields PS_REPL_SETUP_INV	Inventory Policy Planning Fields PS_DP_IPMASTER	Description
ORDER_PREP_COST	DP_ORDERCOST D1	If the value < > 0, then DP_ORDERCOST = ORDER_PREP_COST. If the value = 0, then DP_ORDERCOST = DP_ORDERCOST from the default policy control.
CARRYING_RATE	DP_CARRYINGCOST	If the value < > 0, then DP_CARRYINGCOST = CARRYING_RATE. If the value = 0, then DP_CARRYINGCOST = DP_CARRYINGCOST from the default policy control.

PeopleSoft Inventory Fields

PS_REPL_SETUP_INV

Inventory Policy Planning Fields

PS_DP_IPMASTER

Description

ORDER_PREP_COST

DP_ORDERCOST D1

If the value < > 0, then DP_ORDERCOST = ORDER_PREP_COST.

If the value = 0, then DP_ORDERCOST = DP_ORDERCOST from the default policy control.

CARRYING_RATE

DP_CARRYINGCOST

If the value < > 0, then DP_CARRYINGCOST = CARRYING_RATE.

If the value = 0, then DP_CARRYINGCOST = DP_CARRYINGCOST from the default policy control.

Policy Fields That Are Refreshed From Inventory Master Values

This table list the fields for which the system uses default values when refreshing policy items from PeopleSoft Inventory records.

Note. All fields are from the BU_ITEMS_INV record unless otherwise indicated.

PeopleSoft Inventory Fields	Inventory Policy Planning Fields PS_DP_IPMASTER	Description
IP_PLANNING_FLG	This field is used as selection criteria for determining which records will be read from BU_ITEMS_INV. There is no corresponding field in IP.	Value must be Y to update the record. You set the value using the PeopleSoft Inventory item maintenance feature for items for which you want to create an inventory policy. This setting determines how items are created during policy generation and if replenishment information is published back to PeopleSoft Inventory.
ITM_STATUS_CURRENT	This field is used as selection criteria for determining which records will be read from BU_ITEMS_INV. There is no corresponding field in IP.	Value must be 1 or 5 to update the record. You can select 1, 5, or Both.
INVENTORY_ITEM from the PS_MASTER_ITEM_TBL record	This field is used as selection criteria for determining which records will be read from BU_ITEMS_INV. There is no corresponding field in IP.	Value must be Y or N to populate the record. You can select Y, N, or Both.
DP_POLICYSET	DP_POLICYSET	Defines the key value and determines which policy set to update.
DP_POLICYCONTROL	DP_POLICYCONTROL	The system doesn't use during populate. Instead, it retrieves the default policy control from the policy set.
ITEM_ID	DP_ITEMCODE	Defines the key value.
BUSINESS_UNIT	DP_LOCATION	Defines the key value.
UNIT_MEASURE_STD from the PS_MASTER_ITEM_TBL record	DP_INVENTORYUOM	None.
CM_METHOD from the CM_ITEM_LED_VW	DP_STANDARDCOST	Represents the typical cost of the item. If value = 1, then DP_STANDARDCOST = Sum(CM_UNIT_COST) from PS_CM_ACTUAL_COST If value = 6, then DP_STANDARDCOST = Sum(CM_UNIT_COST) from PS_CM_PERDAVG_COST for the maximum effective date when it is less or equal to currant date if value = 7, then DP_STANDARDCOST = CM_UNIT_COST from PS_CM_PERPAVG for the maximum sequence number if value = 8, then DP_STANDARDCOST = Sum(TL_COST + LL_COST) from PS_CM_PRODCOST for Maximum Effective Date when it is less than or equal to current date if value is distinct from the previous one, the DP_STANDARCCOST = 0

Policy Fields That Are Refreshed Based on User Selection

This table lists fields that are refreshed based on user selection.

Note. All fields are from the BU_ITEMS_INV record unless indicated otherwise.

PeopleSoft Inventory Fields	Inventory Policy Planning Fields PS_DP_IPMASTER	Description
REORDER_QTY	DP_ORDERQUANTITY	If the value < > 0, then DP_ORDERQUANTITY = REORDER_QTY.
REORDER_QTY	DP_OQMETHOD	If the value < > 0, then DP_OQMETHOD = 2 (fixed quantity).
REORDER_QTY	DP_OQARGUMENT	If the value < > 0, then DP_OQARGUMENT = REORDER_QTY.
EOQ	DP_ORDERQUANTITY	If the value < > 0, then DP_ORDERQUANTITY = EOQ. You can override the settings that the REORDER_QTY calculation set in the PeopleSoft Inventory record.
EOQ	DP_OQMETHO	If the value < > 0, then DP_OQMETHOD = 3 (EOQ).
EOQ	DP_OQARGUMENT	If the value < > 0, then DP_OQARGUMENT = 0.
SAFETY_STOCK	DP_SAFETYSTOCK	If the value < > 0, then DP_SAFETYSTOCK = SAFETY_STOCK.
SAFETY_STOCK	DP_SSMETHOD	If the value < > 0, then DP_SSMETHOD = 2.
SAFETY_STOCK	DP_SSARGUMENT	If the value < > 0, then DP_SSARGUMENT = B1.SAFETY_STOCK.
STOCKOUT_RATE	DP_SSMETHOD	If the value < > 0, then DP_SSMETHOD = 3. You can override the settings that the PeopleSoft Inventory SAFETY_STOCK calculation creates.
STOCKOUT_RATE	DP_SSARGUMENT	If the value < > 0, then DP_SSARGUMENT = STOCKOUT_RATE.
REORDER_POINT	DP_REORDERPOINT	If the value < > 0, then DP_REORDERPOINT = REORDER_POINT.
REORDER_POINT	DP_ROPMETHOD	If the value < > 0, then DP_ROPMETHOD = 2.
REORDER_POINT	DP_ROPARGUMENT	If the value < > 0, then DP_ROPARGUMENT = REORDER_POINT.
QTY_MAXIMUM	DP_MAXIMUM	If the value < > 0, then DP_MAXIMUM = B1.QTY_MAXIMUM.
QTY_MAXIMUM	DP_MAXMETHOD	If the value < > 0, then DP_MAXMETHOD = 2.
QTY_MAXIMUM	DP_MAXARGUMENT	If the value < > 0, then DP_MAXARGUMENT = QTY_MAXIMUM.
REPLENISH_LEAD	DP_LEADTIME	If the value < > 0, then DP_LEADTIME = B1.REPLENISH_LEAD. Note. For purchased items, the system can provide an option to retrieve longest or average lead time of existing item or vendor records.
ORDER_PREP_COST from the PS_REPL_SETUP_INV record	DP_ORDERCOST	If the value < > 0, then DP_ORDERCOST = ORDER_PREP_COST. Note. The key for this record can include the business unit level detail.
CARRYING_RATE from the PS_REPL_SETUP_INV record	DP_CARRYINGCOST	If value < > 0 then DP_CARRYINGCOST = CARRYING_RATE. Note. The key for this record may include business unit-level detail in this version.
ORDER_MULTIPLE	DP_ORDERMULT	If the value < > 0, then DP_ORDERMULT = ORDER_MULTIPLE.
UTILIZ_CD from the PS_BU_ITEM_UTIL_CD record	UTILIZ_CD	If the value < > ' ' No, then UTILIZ_CD = UTILIZ_CD.
UTILIZ_GROUP from the PS_BU_ITEM_UTIL_CD record	UTILIZ_GROUP	If the value < > ' ', then UTILIZ_GROUP = UTILIZ_GROUP.

Fields Loaded During External Data Import

This section discusses IP Master data fields loaded from external files.

Note. All file layouts require a record ID of 100, except XML files. The first column should always be 100 in order to be processed by PeopleSoft Demand Planning.

This table describes the fields and their processing order for IP Master record data for all layout types:

Field Loaded	Field Description	Field Seq.	Field Start	Field Length	Field Type	Decimal	Required
RECORD IDENTIFIER (Always 100)	Record ID	0	1	3	Number	0	Y
DP_ITEMCODE	Item	1	4	18	Character	0	Y
DP_LOCATION	Location	2	22	5	Character	0	Y
DP_INVENTORYUOM	Inventory UOM	3	27	3	Character	0	N
DP_ORDERQUANTITY	Order Quantity	4	30	15	Number	4	N
DP_SAFETYSTOCK	Safety Stock	5	45	15	Number	4	N
DP_LEADTIME	Lead Time	6	60	4	Number	0	N
DP_STANDARDPRICE	Standard Price	7	64	15	Number	4	N
DP_STANDARDCOST	Standard Cost	8	79	15	Number	4	N
DP_ORDERCOST	Order Cost	9	94	15	Number	4	N
DP_CARRYINGCOST	Carrying Cost	10	109	15	Number	4	N
DP_MINIMUM	Minimum	11	124	15	Number	4	N
DP_MAXIMUM	Maximum	12	139	15	Number	4	N
DP_REORDERPOINT	Reorder Point	13	154	15	Number	4	N
DP_ORDERMULT	Order Multiple	14	169	15	Number	4	N
UTILIZ_CD	Utilization Code	15	184	4	Character	0	N
UTILIZ_GROUP	Utilization Group	16	188	4	Character	0	N
DP_VOLUME	Volume	17	192	13	Number	2	N
DP_VOLUMEUOM	Volume UOM	18	205	3	Character	0	N
DP_WEIGHT	Weight	19	208	13	Number	2	N
DP_WEIGHTUOM	Weight UOM	20	221	3	Character	0	N
DP_UD01	User Data	21	224	30	Character	0	N
DP_UD02	User Data	22	254	30	Character	0	N
DP_UD03	User Data	23	284	30	Character	0	N
DP_UD04	User Data	24	314	30	Character	0	N
DP_UD05	User Data	25	344	30	Character	0	N
DP_UD06	User Data	26	374	30	Character	0	N
DP_UD07	User Data	27	404	30	Character	0	N
DP_UD08	User Data	28	434	30	Character	0	N
DP_UD09	User Data	29	464	30	Character	0	N
DP_UD10	User Data	30	494	30	Character	0	N
DP_UD11	User Data	31	524	20	Character	0	N
DP_UD12	User Data	32	544	20	Character	0	N
DP_UD13	User Data	33	564	20	Character	0	N
DP_UD14	User Data	34	584	20	Character	0	N
DP_UD15	User Data	35	604	20	Character	0	N
DP_UD16	User Data	36	624	20	Character	0	N
DP_UD17	User Data	37	644	20	Character	0	N
DP_UD18	User Data	38	664	20	Character	0	N
DP_UD19	User Data	39	684	20	Character	0	N
DP_UD20	User Data	40	704	20	Character	0	N
DP_UD21	User Data	41	724	10	Character	0	N
DP_UD22	User Data	42	734	10	Character	0	N
DP_UD23	User Data	43	744	10	Character	0	N
DP_UD24	User Data	44	754	10	Character	0	N
DP_UD25	User Data	45	764	10	Character	0	N
DP_UD26	User Data	46	774	10	Character	0	N
DP_UD27	User Data	47	784	10	Character	0	N
DP_UD28	User Data	48	794	10	Character	0	N
DP_UD29	User Data	49	804	10	Character	0	N
DP_UD30	User Data	50	814	10	Character	0	N
DP_UD31	User Data	51	824	10	Character	0	N
DP_UD32	User Data	52	834	10	Character	0	N
DP_UD33	User Data	53	844	10	Character	0	N
DP_UD34	User Data	54	854	10	Character	0	N
DP_UD35	User Data	55	864	10	Character	0	N
DP_UD36	User Data	56	874	10	Character	0	N
DP_UD37	User Data	57	884	10	Character	0	N
DP_UD38	User Data	58	894	10	Character	0	N
DP_UD39	User Data	59	904	10	Character	0	N
DP_UD40	User Data	60	914	10	Character	0	N
DP_UD41	User Data	61	924	21	Number	4	N
DP_UD42	User Data	62	945	21	Number	4	N
DP_UD43	User Data	63	966	21	Number	4	N
DP_UD44	User Data	64	987	21	Number	4	N
DP_UD45	User Data	65	1008	21	Number	4	N
DP_UD46	User Data	66	1029	21	Number	4	N
DP_UD47	User Data	67	1050	21	Number	4	N
DP_UD48	User Data	68	1071	21	Number	4	N
DP_UD49	User Data	79	1092	21	Number	4	N
DP_UD50	User Data	70	1113	21	Number	4	N

Inventory Policy Fields Published to PeopleSoft Inventory

This section discusses:

Fields that are published to the STOCK_PERIOD_IN record.
Fields that are published to the BU_ITEM_INV record.
Fields that are published to the PL_ITEM_ATTRIB record.

Fields That Are Published to the STOCK_PERIOD_IN Record

This table lists time-based data fields that are published to the STOCK_PERIOD_IN record in PeopleSoft Inventory:

PeopleSoft Inventory Field Name	DP_IPMAST_LINES Record Name	Description
BUSINESS_UNIT	User entered.	Lookup match to DP_LOCATION.
INV_ITEM_ID	User entered.	Lookup match to DP_ITEMCODE.
START_DT	CalendarPeriods.StartDate	Start date of calendar ID from policy set that matches the DP_YEAR and DP_PERIOD on the record.
END_DT	CalendarPeriods.EndDate	End date of calendar ID from policy set that matches the DP_YEAR and DP_PERIOD on the record.
SAFETY_LIMIT	DP_SAFETYSTOCK	Period-based safety stock.
EXCESS_LIMIT	DP_MAXIMUM	If Period-Based DP_MAXIMUM = 0, then EXCESS_LIMIT = Period-based(DP_SAFETY + DP_ORDERQUANTITY) * InvUomConvFactor. If Period-based DP_MAXIMUM <> 0 and Period-based DP_MAXIMUM < Period-based(DP_SAFETY + DP_ORDERQUANTITY), then EXCESS_LIMIT = Period-based(DP_SAFETY + DP_ORDERQUANTITY) * InvUomConvFactor otherwise EXCESS_LIMIT = Period-based DP_MAXIMUM * InvUomConvFactor
DP_REORDER_QTY	DP_ORDERQUANTITY	DP_ORDERQUANTITY Period-based DP_ORDERQUANTITY * InvUomConvFactor
DP_SAFETYSTOCK	DP_SAFETYSTOCK	Period_based DP_SAFETYSTOCK * InvUomConvFactor
DP_MAXIMUM	DP_MAXIMUM	Period_based DP_MAXIMUM * InvUomConvFactor
PUBLISH_DATE	System assigned.	Current DateTime of PublishNEW field for Stock_Period_IN. This field will not be updated prior to the next PeopleSoft SCM release.

Fields That Are Published to the BU_ITEMS_INV Record

This table displays time-based data fields that are published to the BU_ITEM_INV record in PeopleSoft Inventory:

PeopleSoft Inventory Field Name	DP_IPMAST_LINES Record Name	Description
INV_ITEM_ID	ITEMCODE	Used with Location to determine the unique key on the DP_IPMASTER
BUSINESS_UNIT	LOCATION	Used with Location to determine the unique key on the DP_IPMASTER
EOQ	DP_ORDER_QUANTITY	EOQ = DP_ORDERQUANTITY * InvUomConvFcator Else EOQ = 0
AOQ	If OrderQuantity <> 0 then OrderQuantity Else 1End If	AOQ = DP_ORDERQUANTITY * InvUomConvFcator Else AOQ = 1 '
QTY_MAXIMUM	DP_MAXIMUM	Period_based DP_MAXIMUM * InvUomConvFactor
REORDER_POINT	DP_REORDERPOINT	REORDER_POINT = DP_REORDERPOINT * InvUomConvFactor
REORDER_QTY	DP_ORDERQUANTITY	Period-based DP_ORDERQUANTITY * InvUomConvFactor
SAFETY_STOCK	DP_SAFETYSTOCK	Period_based DP_SAFETYSTOCK * InvUomConvFactor
STOCKOUT_RATE	DP_SSARGUMENT	STOCKOUT_RATE = DP_SSARGUMENT
PUBLISH_DATE	System assigned.	Current DateTime of Publish.
DP_POLICYSET	DP_POLICYSET	NEW field for BU_Items_Inv.
DP_POLICYCONTROL	DP_POLICYCONTROL	NEW field for BU_Items_Inv.

Fields That Are Published to the PL_ITEM_ATTRIB Record

This table displays time-based data fields that are published to the PL_ITEM_ATTRIB record in PeopleSoft Inventory:

PeopleSoft Inventory Field Name	DP_IPMASTER Record Name	Description
INV_ITEM_ID	ITEMCODE	Extracted from policy data.
BUSINESS_UNIT	LOCATION	Extracted from policy data.
SAFETY_LEVEL	DP_SAFETYSTOCK	DP_SAFETYSTOCK * InvUomConFavtor
EXCESS_LEVEL	DP_SAFETYSTOCK + DP_ORDERQUANTITY	Period-based DP_SAFETYSTOCK * InvUomConFavtor
PL_FIXED_PERIOD	DP_OQARGUMENT	If DP_OQMETHOD = 1 then PL_FIXED_PERIOD = DP_OQARGUMENT Else PL_FIXED_PERIOD = 0.
OQ_METHOD	DP_OQMETHOD	DP_OQMETHOD from PL_ITEM_ATTRIB = DP_OQMETHOD from DP_IPMASTER.
TRANSFER_MIN_ORDER	DP_ORDERQUANTITY	If TRANS_ORD_MOD = Y TRANSFER_MIN_ORDER = DP_ORDERQUANTITY * InvUomConvFactor
TRANSFER_ORD_MULTIPLE	DP_ORDER_MULT	If TRANS_ORD_MOD = Y. TRANS_ORD_MULTIPLE = DP_ORDERMULT * InvUomConvFactor
TRANSFER_MAX_ORDER	DP_ORDERQUANTITY	If TRANS_ORD_MOD =Y. TRANS_MAX_ORDER = DP_ORDERQUANTITY * InvUomConvFactor
PUR_MIN_ORDER	DP_ORDERQUANTITY	If PUR_ORDER_MOD = Y. PUR_MIN_ORDER = DP_ORDERQUANTITY * InvUomConvFactor
PUR_ORDER_MULTIPLE	DP_ORDER_MULT	If PUR_ORDER_MOD = Y.DP_ORDER_MULT * InvUomConvFactor
PUR_MAX_ORDER	DP_ORDERQUANTITY	If PUR_ORDER_MOD =Y. PUR_MAX_ORDER = DP_ORDERQUANTITY * InvUomConvFactor
MFG_MIN_ORDER	DP_ORDERQUANTITY	If MFG_ORDER_MOD =Y. MFG_MIN_ORDER = DP_ORDERQUANTITY * InvUomConvFactor
MFG_ORDER_MULTIPLE	DP_ORDER_MULT	If MFG_ORDER_MOD = Y. MFG_ORD_MULTIPLE = DP_ORDERMULT * InvUomConvFactor
MFG_MAX_ORDER	DP_ORDERQUANTITY	If MRG_ORDER_MOD = Y. MFG_MAX_ORDER = DP_ORDERQUANTITY * InvUomConvFactor

Fields That Are Published to the BU_ITEM_UTIL Record

This table lists data fields that are published to the Utilization record in PeopleSoft Inventory.

BU_ITEM_UTIL	DP_IPMASTER Record Name	Description
INV_ITEM_ID	ITEMCODE	Lookup match on DP_ITEMCODE
BUSINESS_UNIT	LOCATION	Lookup match on DP_LOCATION
UTILIZ_GROUP	UTILZ_GROUP	UTILIZ_GROUP from DP_BU_ITEM_UTIL = UTILIZ_GROUP from DP_IPMASTER
UTILIZ_CD	UTILZ_CD	UTILIZ_CD from DP_BU_ITEM_UTIL = UTILIZ_CD from DP_IPMASTER
DP_PUBLISH_DATE	System assigned.	Current DateTime of Publish.

Inventory Policy Fields That Are Published to Internal Sources

This section discusses:

Fields that are published to the DP_PUB_INVPOL record.
Fields that are published to the DP_PUB_IPMAST record.
Fields that are published to the DP_PUB_IPMSTLIN record.

Fields That Are Published To the DP_PUB_INVPOL Record

This table displays fields that are published from the PeopleSoft Inventory Policy Planning DP_PUB_INVPOL record:

Field Name	Populated From	Description
Publish Name	User entered.	Entered by the user during publish.
Publish Date	User entered.	Entered by the user during publish.
Description	User entered.	Entered by the user during publish.
DP_POLICYSET	DP_POLICYSET	Selected by the user on publish.
DP_CALENDARID	DP_CALENDARID	The Calendar ID from the DP_POLICYSETS for the selected Policy Set.
DP_TIMEPERIODCODE	DP_TIMEPERIODCODE	The time period code from the DP_POLICYSETS for the selected Policy Set.
DP_PUBLISHUOM	DP_PUBLISHUOM	Selected by the user when the publish is run.
DP_CONVTOINVUOM	System assigned.	Y = The system can convert inventory policy quantities to PeopleSoft Inventory UOMs using the policy item conversion factor. N = The system cannot convert inventory policy quantities to the PeopleSoft Inventory standard UOM.
DP_LASTUPDATED	System assigned.	Date of the publish.

Fields That Are Published to the DP_PUB_IPMAST Record

This table displays fields that are published from PeopleSoft Inventory Policy Planning to the DP_PUB_IPMAST record.

Field Name	Populated From DP_IPMASTER	Description
DP_PUBLISHNAME	User entered.	Entered by the user during publish.
DP_PUBLISH_DATE	User entered.	Entered by the user during publish.
DP_ITEMCODE	DP_ITEMCODE	Extracted from policy data.
DP_LOCATION	DP_LOCATION	A key field.
DP_POLICYCONTROL	DP_POLICYCONTROL	Extracted from policy data.
DP_INVENTORYUOM	DP_INVENTORYUOM	This is the inventory standard UOM that is converted to if standard UOM conversion is found.
DP_PUBLISHUOM	DP_PUBLISHUOM	Selected by the user on the publish specification.
DP_CONVFACTOR	System assigned.	Conversion factor used to convert from item's base UOM to publish UOM.
DP_STDUOMCONVFACTOR	System assigned.	Conversion factor that can be used to convert form the published UOM to the inventory standard UOM.
DP_LEAD	DP_LEAD	Extracted from policy data.
DP_LEADTIMEUOM	DP_LEADTIMEUOM	Extracted from policy data.
DP_WEIGHT	DP_WEIGHT	Extracted from policy data.
DP_WEIGHTUOM	DP_WEIGHTUOM	Extracted from policy data.
DP_VOLUME	DP_VOLUME	Extracted from policy data.
DP_INHERITCONTROLS	DP_INHERITCONTROLS	Extracted from policy data.
DP_RUNOUTDATE	DP_RUNOUTDATE	Converted to publish UOM if this differs from base UOM.
DP_SAFETYSTOCK	DP_SAFETYSTOCK	Converted to publish UOM if this differs from base UOM.
DP_REORDERPOINT	DP_REORDERPOINT	Converted to publish UOM if this differs from base UOM.
DP_ORDERQUANTITY	DP_ORDERQUANTITY	Converted to publish UOM if this differs from base UOM.
DP_MINIMUM	DP_MINIMUM	Converted to publish UOM if this differs from base UOM.
DP_MAXIMUM	DP_MAXIMUM	Converted to publish UOM if this differs from base UOM.
DP_AVGINVENTORY	DP_AVGINVENTORY	Converted to publish UOM if this differs from base UOM.
DP_SERVICEFILL	DP_SERVICEFILL	Extracted from policy data.
DP_TURNRATE	DP_TURNRATE	Extracted from policy data.
DP_OQMETHOD	DP_OQMETHOD	Extracted from policy data.
DP_OQARGUMENT	DP_OQARGUMENT	Extracted from policy data.
DP_OQLIMITMETHOD	DP_OQLIMITMETHOD	Extracted from policy data.
DP_OQLOWERLIMIT	DP_OQLOWERIMIT	Extracted from policy data.
DP_OQUPPERLIMIT	DP_OQUPPERLIMIT	Extracted from policy data.
DP_SSMETHOD	DP_SSMETHOD	Extracted from policy data.
DP_SSARGUMENT	DP_SSARGUMENT	Extracted from policy data.
DP_SSLIMITMETHOD	DP_SSLIMITMETHOD	Extracted from policy data.
DP_SSLOWERLIMIT	DP_SSLOWERLIMIT	Extracted from policy data.
DP_ROPMETHOD	DP_ROPMETHOD	Extracted from policy data.
DP_ROPARGUMENT	DP_ROPARGUMENT	Extracted from policy data.
DP_MINMETHOD	DP_MINMETHOD	Extracted from policy data.
DP_MINARGUMENT	DP_MINARGUMENT	Extracted from policy data.
DP_MAXMETHOD	DP_MAXMETHOD	Extracted from policy data.
DP_MAXARGUMENT	DP_MAXARGUMENT	Extracted from policy data.
DP_ORDERCOST	DP_ORDERCOST	Extracted from policy data.
DP_CARRYINGCOST	DP_CARRYINGCOST	Extracted from policy data.
DP_STANDARDPRICE	DP_STANDARDPRICE	Extracted from policy data.
DP_STANDARDCOST	DP_STANDARDCOST	Extracted from policy data.
DP_ANNUALCOST	DP_ANNUALCOST	Extracted from policy data.
DP_ANNUALINVESTMENT	DP_ANNUALINVESTMENT	Extracted from policy data.
DP_ORDERMULT	DP_ORDERMULT	Extracted from policy data.
DP_STATICCALCFLG	DP_STATICCALCFLG	Extracted from policy data.
DP_STATICCALCARG	DP_STATICCALCARG	Extracted from policy data.
DP_MAXLTUSAGEMETH	DP_MASLTUSAGEMETH	Extracted from policy data.
DP_HISTMAXLTUSAGE	DP_HISTMAXLTUSAGE	Extracted from policy data.
DP_FCPERIODS	DP_FCPERIODS	Extracted from policy data.
DP_FCSTDDEV	DP_FCSTDDEV	Extracted from policy data.
DP_SIMFCSTDDEV	DP_SIMFCSTDDEV	Extracted from policy data.
DP_EFFDEMANDPDS	DP_EFFDEMANDPDS	Extracted from policy data.
DP_EXPLODEDITEM	DP_EXPLODEDITEM	Extracted from policy data.
DP_ORDERCOUNT	DP_ORDERCOUNT	Extracted from policy data.
UTILIZ_CD	UTILIZ_CD	Extracted from policy data.
UTILIZ_GROUP	UTILIZ_GROUP	Extracted from policy data.
DP_UD01 ? DP_UD1O	DP_UD01 – DP_UD10	Extracted from policy data.
DP_UD11 ? DP_UD20	DP_UD11 – DP_UD20	Extracted from policy data.
DP_UD21 ? DP_UD40	DP_UD21 – DP_UD40	Extracted from policy data.
DP_UD41 ? DP_UD50	DP_UD41 – DP_UD50	Extracted from policy data.
CONSIGNED_FLAG	System assigned from a User Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
COST_ELEMENT	System assigned from a User Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
COST_GROUP_CD	System assigned from a User Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
DESCR	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
EXCESS_INVENTORY	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
INV_STOCK_TYPE	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
ITM_STATUS_FUTURE	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
NO_REPLENISH_FLAG	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
REPLENISH_CLASS	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
PLANNER_CD	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
RELATED_ITEM_ID	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
SOURCE_CD	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
SOURCE_CODE	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
USES_UP_QOH	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
QTY_AVAILABLE	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
HISTORICAL_LEAD	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
SHELF_LIFE	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
ITEM_FIELD_C1 A-D	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
ITEM_FIELD_C10 A - D	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
ITEM_FIELD_ C2 - C8	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user-defined field must be mapped to it.
ITEM_FIELD_ C30 A - D	System assigned from a User-Defined Field.	Publish looks up the field that the user-defined field is mapped to, and publishes into that field. For this field to be loaded, a user- defined field must be mapped to it.

Fields That Are Published From the DP_PUB_IPMSTLIN Record

This table displays fields that are published from the PeopleSoft Inventory Policy Planning DP_PUB_IPMSTLIN record:

Field Name	Populated From DP_IPMAST_LINES	Description
DP_PUBLISHNAME	User entered.	User entered at publish.
DP_PUBLISH_DATE	User entered.	User entered at publish
DP_ITEMCODE	DP_ITEMCODE	Extracted from policy data.
DP_LOCATION	DP_LOCATION	Extracted from policy data.
DP_STARTDATE	DP_STARTDATE	Extracted from policy data.
DP_ENDDATE	DP_ENDDATE	Extracted from policy data.
DP_YEAR	DP_YEAR	Extracted from policy data.
DP_PERIOD	DP_PERIOD	Extracted from policy data.
DP_COST	DP_COST	Extracted from policy data.
DP_FORECASTVALUE	DP_FORECASTVALUE	Extracted from policy data.
DP_INDIRECTDEMAND	DP_INDIRECTDEMAND	Converted to publish UOM if this differs from base UOM.
DP_ORDERQUANTITY	DP_ORDERQUANTITY	Converted to publish UOM if this differs from base UOM.
DP_SAFETYSTOCK	DP_SAFETYSTOCK	Converted to publish UOM if this differs from base UOM.
DP_REORDERPOINT	DP_REORDERPOINT	Converted to publish UOM if this differs from base UOM.
DP_SERVICEFILL	DP_SERVICEFILL	Extracted from policy data.
DP_AVGINVENTORY	DP_AVGINVENTORY	Converted to publish UOM if this differs from base UOM.
DP_TURNRATE	DP_TURNRATE	Extracted from policy data.
DP_MINIMUM	DP_MINIMUM	Converted to publish UOM if this differs from base UOM.
DP_MAXIMUM	DP_MAXIMUM	Converted to publish UOM if this differs from base UOM.

The system converts data values to an alternate UOM only for fields that are described as convertible.