About the Inventory Item Master File

The Inventory Item Master file includes fixed, static columns. You cannot add or remove columns from this file. If you do not have a value for a column, type (unused) as the value.

Note: You cannot type (unused) in some cells of a column and values in other cells in the same column. If (unused) is used, then all cells in the column must have a value of (unused).

Inventory Item Master File

Some column names in this file may differ by customer. Common examples are as follows.

Inventory Item Master File Elements

Name Description Data Type
Item Item identifier This property creates a unique ID for Wolters Kluwer records. Alphanumeric and "_" Less than 63 characters
Customer Customer identifier This property creates a unique ID for Wolters Kluwer records. Alphanumeric and "_" Less than 63 characters
Warehouse Warehouse identifier This property creates a unique ID for Wolters Kluwer records. Alphanumeric and "_" Less than 63 characters
On hand Total number of units in possession Number
On order Number of units on order (not yet on hand) Number
Order lead time Number of days between placing and receiving an order Number
Minimum order quantity Lowest quantity of a certain product a supplier is willing to sell Number
Ship pack quantity The smallest package the supplier is willing to ship Number
Strategy CCH Tagetik Supply Chain Planning strategy to use for this item [blank]
Supplier With whom the orders are placed String Can include alphanumeric and "_" characters; no character limit
Lead time stdev Days of uncertainty of lead time Number
Cost to process an order Includes all costs to process an order (for example, creating a purchase order, sending it to the supplier, fixed shipping costs, and receiving costs) Number