Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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