This documentation is archived and is not being maintained.

ProductListPriceHistory Table (AdventureWorks)

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

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.

Show: