| Column | Data Type | Nullable | Default | Description |
| ProductID | int | not null | | Primary key for Product records. |
| Name | dbo.Name | not null | | Name of the product. |
| ProductNumber | nvarchar(25) | not null | | Unique product identification number. |
| 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. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |