ItemInventory

Entity Definition

Logical Name : ItemInventory
Physical Name : LE_INV_ITM

A unit record of a particular StockItem, held in a particular InventoryLocation, in a particular InventoryState and controlled or managed by a particular RevenueCenter

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) StockItem(AS_ITM_STK)
LocationID (FK)(PK) A unique system assigned identifier for the Location. ID_LCN Identity integer InventoryLocation(LO_LCN_INV)
ItemInventoryStateID (FK)(PK) A unique retailer assigned identifier for ItemInventoryStates. ID_ST_INV Identity integer InventoryState(CO_ST_INV)
RevenueCostCenterID (FK)(PK) A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. ID_CTR_RVN_CST Identity integer RevenueCostCenter(CO_CTR_RVN_CST)
BeginningUnitCount The number of units present at the beginning of the current ReportingPeriod. QU_BGN Quantity DECIMAL(9,3)
GrossSalesUnitCount The number of units of the nominated Item sold from the nominated InventoryLocation since the beginning of the current ReportingPeriod, excluding any returns. QU_SLS Quantity DECIMAL(9,3)
ReturnUnitCount The number of units of the nominated Item returned to the nominated InventoryLocation since the beginning of the current ReportingPeriod. QU_RTN Quantity DECIMAL(9,3)
ReceivedUnitCount The number of units of the nominated Item received to the nominated InventoryLocation since the beginning of the current ReportingPeriod, excluding any returns. QU_RCV Quantity DECIMAL(9,3)
ReturnToVendorUnitCount The number of units of the nominated Item returned to Vendor from the nominated InventoryLocation since the beginning of the current ReportingPeriod. QU_RTV Quantity DECIMAL(9,3)
TransferInUnitCount The number of units of the nominated Item transferred into the nominated InventoryLocation since the beginning of the current ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. QU_TSF_IN Quantity DECIMAL(9,3)
TransferOutUnitCount The number of units of the nominated Item transferred from the nominated InventoryLocation since the beginning of the current ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. QU_TSF_OT Quantity DECIMAL(9,3)
AdjustmentUnitCount The number of units of the nominated Item for which InventoryAdjustments were made in the nominated InventoryLocation since the beginning of the current ReportingPeriod. QU_ADJT Quantity DECIMAL(9,3)
CurrentUnitCount The number of units of the nominated Item currently present in the nominated InventoryLocation. QU_CUR Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
InventoryState defines ItemInventory
StockItem is tracked in ItemInventory
InventoryLocation holds ItemInventory
RevenueCostCenter defines accounting disposition of ItemInventory
ItemInventory is tracked by ItemInventoryHistory
ItemInventory is updated by ItemInventoryJournalEntry

Logical Views containing ItemInventory

Logical View
Logical 01010 - Item Description - Subtype View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02020 - Item Inventory - Selling View
Logical 02100 - Item Inventory - Macro View
Logical 02130 - Item Inventory - Receiving View
Logical 02316 - Distributed Order Management View
Logical 02600 - Inventory Control Transaction View
Logical 03300 - Reporting - Stock Ledger View
Logical 04000 - Financial Ledger - Macro View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 04300 - Financial Ledger - Inventory Control View
Logical 10200 - Enterprise - Merchandise View