Item Warehouse Dim

Created by Robert Cross, Modified on Wed, 9 Jul, 2025 at 7:53 AM by Robert Cross

Item Warehouse Dim

The Item Warehouse Dimension serves as a foundational element in tracking inventory details specific to each warehouse location. It consolidates key attributes related to items and their costs, enabling an understanding of inventory status, cost components, and modifications over time for enhanced operational insight and financial planning.

Output Column	Database Logic	Description
Item Warehouse Key	Unique identifier for each item record within a warehouse.	This uniquely identifies each item as it is stored or managed within a specific warehouse location.
Item Key	Unique identifier for each individual item.	This identifies the specific product or item tracked in the warehouse.
Warehouse Key	Unique identifier for the warehouse location.	This indicates which warehouse location holds or manages the item.
Last Modified Datetime	Timestamp indicating when the item warehouse record was last updated.	This shows the most recent date and time when any changes were made to this item's warehouse information.
Item Deleted	Flag indicating if the item has been marked as deleted or inactive.	This tells if the item is no longer active or has been removed from inventory tracking.
Warehouse Deleted	Flag indicating if the warehouse record has been marked as deleted or inactive.	This indicates whether the warehouse location is no longer active or valid for operations.
Cost Deleted	Flag indicating if the cost information has been deleted or invalidated.	This signifies whether the cost details associated with the item have been removed or are no longer considered valid.
Cost Currency	Currency type used for the cost values.	This specifies the currency in which the item's cost is recorded, important for financial reporting.
Estimated Standard Cost	Estimated standard cost of the item.	This reflects the typical or expected cost to produce or procure the item under normal conditions.
Estimated Material Cost	Estimated cost for materials related to the item.	This provides an estimate of the material expenses involved in producing the item.
Estimated Operational Cost	Estimated operational costs allocated to the item.	This shows the estimated indirect costs such as labor or overhead associated with the item.
Estimated General Costs	Estimated general costs related to the item.	This includes broader costs such as administrative or facility expenses allocated to the item.
Estimated Surcharges	Additional estimated charges applied to the item.	This represents any extra fees or surcharges factored into the total cost of the item.
Costing Type	Classification of how the cost is calculated or applied.	This defines the methodology or category used to calculate the item’s costs.
Costing Source	Source or origin of the cost data.	This indicates where the cost information is derived from, ensuring traceability and accuracy.