ProductListPriceHistory Table (AdventureWorks)

Contains the changes to the list price of a product over time.

ProductListPriceHistory Table Definition

The ProductListPriceHistory 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

List price start date.

EndDate

datetime

Null

List price end date

ListPrice

money

Not null

Product list price.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Product Table (AdventureWorks)
ProductCostHistory Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance