ProductCostHistory Table (AdventureWorks)

Contains the cost of a product over time.

ProductCostHistory Table Definition

The ProductCostHistory table is contained in the Production schema.

Column Data type Nullability Description

ProductID

int

Not null

Product identification number. Foreign key to Product.ProductID.

StartDate

datetime

Not null

Product cost beginning date.

EndDate

datetime

Null

Product cost end date.

StandardCost

money

Not null

Standard cost of the product.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Product Table (AdventureWorks)
ProductListPriceHistory Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance