Entity Definition

Logical Name : InventoryState
Physical Name : CO_ST_INV

A state that StockItems are kept in the retail enterprise item inventory records. Suggested values include: OnHand, OnOrder, OnLayaway, Damaged, ToBeReturned etc....

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemInventoryStateID (PK) A unique retailer assigned identifier for ItemInventoryStates. ID_ST_INV Identity integer
InventoryStateName The common name for ItemInventoryStates. NM_ST_INV Name varchar(40)


Parent Entity Verb Phrase Child Entity
InventoryState defines condition of InventoryFact
InventoryState defines ItemInventory
InventoryState is permitted via InventoryStatePermissions

Logical Views containing InventoryState

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02316 - Distributed Order Management View
Logical 03300 - Reporting - Stock Ledger View