Inventory Levels

An inventory level is a grouping of products that have the same Availability field value (for example, On Hand, On Order, and Reserved) and the same Status field value (for example, Good and Defective). The following table shows some examples of inventory levels for a product.

Availability Field	Status Field
On Order	Good
On Hand	Good
Reserved	Good
In Transit	Defective

You do not have to manually create products and associated inventory levels in the Product Inventory view of the Inventory screen. When an inventory transaction occurs, products and associated inventory levels are automatically created in the Siebel database if they do not exist. However, such products are not assigned minimum amounts, maximum amounts, safety amounts, an ABC class for cycle counting, and an XYZ class for cycle counting. You might have to navigate to the Product Inventory view of the Inventory screen and update these newly created records.

You can create or update inventory levels by loading the levels through the EIM_PRODINVLOC table. You can also create or update inventory transactions by loading the transactions through the EIM_INV_TXN table.