MDWT_AdventureWorksDW.DimProduct

Attributes in DimProduct

Column Name	Data Type	Is Key	Short description
ProductKey	int		Surrogate primary key
BKProductID	int		ProductID, Natural key from source system
ProductSKU	varchar		SKU, also known as Product Number
ProductName	varchar		Product name
ProductDescr	varchar		Product English description
ProductModelID	int		Product model ID from source system
Model	varchar		Model name
ProductSubcategoryID	int		Product subcategory ID from the source system
ProductSubcategory	varchar		Product subcategory
ProductCategoryID	int		Product category ID from the source system
ProductCategory	varchar		Product category
ProductLine	char		Product line
Color	varchar		Product color
Class	char		Product class (H/M/L)
Style	char		Product style (Men/Women/Unisex)
IsFinishedGood	char		Is the product classified as a finished good?
Size	char		Item size
SizeRange	varchar		Grouping of item sizes for bikes, eg 38-40 cm
SizeUnitOfMeasureCode	char		How is size measured
Weight	decimal		Item weight
WeightUnitOfMeasureCode	char		How is weight measured?
DaysToManufacture	int		Average days to manufacture
StandardCost	money		Current standard cost of production
ListPrice	money		Current suggested list price
DealerPrice	money		Current price to dealers
SafetyStockLevel	smallint		For AW warehouse, comfortable level of inventory
ReorderPoint	smallint		For AW warehouse, reorder when stock falls below this point
SellStartDate	datetime		Date product first available
SellEndDate	datetime		Date product last available
ProductCurrentStatus	char		Product current status
AuditKey	int		What process loaded this row?

Column Name

Data Type