.png)
ProductCostHistory Table (AdventureWorks)
SQL Server 2008
Contains the cost of a product over time.
The ProductCostHistory 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 | Product cost beginning date. |
EndDate | datetime | Null | Product cost end date. |
StandardCost | money | Not null | Standard cost of the product. |
ModifiedDate | datetime | Not null | Date and time the row was last updated. |
