ProductListPriceHistory Table (AdventureWorks)
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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:
© 2016 Microsoft