| Column | Data Type | Nullable | Default | Description / PK / Index |
| ProductID | int | not null | | Primary key for Product records.
PK_Product_ProductID |
| Name | dbo.Name | not null | | Name of the product.
AK_Product_Name |
| ProductNumber | nvarchar(25) | not null | | Unique product identification number.
AK_Product_ProductNumber |
| MakeFlag | dbo.Flag | not null | ((1)) | 0 = Product is purchased, 1 = Product is manufactured in-house.
|
| FinishedGoodsFlag | dbo.Flag | not null | ((1)) | 0 = Product is not a salable item. 1 = Product is salable.
|
| Color | nvarchar(15) | null | | Product color.
|
| SafetyStockLevel | smallint | not null | | Minimum inventory quantity.
|
| ReorderPoint | smallint | not null | | Inventory level that triggers a purchase order or work order.
|
| StandardCost | money | not null | | Standard cost of the product.
|
| ListPrice | money | not null | | Selling price.
|
| Size | nvarchar(5) | null | | Product size.
|
| SizeUnitMeasureCode | nchar(3) | null | | Unit of measure for Size column.
|
| WeightUnitMeasureCode | nchar(3) | null | | Unit of measure for Weight column.
|
| Weight | decimal(8, 2) | null | | Product weight.
|
| DaysToManufacture | int | not null | | Number of days required to manufacture the product.
|
| ProductLine | nchar(2) | null | | R = Road, M = Mountain, T = Touring, S = Standard
|
| Class | nchar(2) | null | | H = High, M = Medium, L = Low
|
| Style | nchar(2) | null | | W = Womens, M = Mens, U = Universal
|
| ProductSubcategoryID | int | null | | Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
|
| ProductModelID | int | null | | Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
|
| SellStartDate | datetime | not null | | Date the product was available for sale.
|
| SellEndDate | datetime | null | | Date the product was no longer available for sale.
|
| DiscontinuedDate | datetime | null | | Date the product was discontinued.
|
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Product_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|