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