Share via


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.