Production.ProductCostHistory

Table: 'Production.ProductCostHistory'

5 fields. 73 bytes.

Changes in the cost of a product over time.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ProductIDint   Not nullProduct identification number. Foreign key to Product.ProductID 
StartDatedatetime   Not nullProduct cost start date. 
EndDatedatetime   NullProduct cost end date. 
StandardCostmoney19,4decimal(19,4) Not nullStandard cost of the product.([StandardCost]>=(0.00))
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductCostHistory'

Primary Key NameField Names
PK_ProductCostHistory_ProductID_StartDateProductID, StartDate

Foreign keys for table 'Production.ProductCostHistory', 1 item

ForeignPrimaryKey Name
ProductCostHistory.ProductIDProduct.ProductIDFK_ProductCostHistory_Product_ProductID

Indexes for table 'Production.ProductCostHistory', 1 item

Index NameDescriptionClusteredUniqueFields
PK_ProductCostHistory_ProductID_StartDateClustered index created by a primary key constraint.YesYesProductID, StartDate

Triggers for table 'Production.ProductCostHistory', 1 item

NameDescriptionTypeEnabled
uProductCostHistoryAFTER UPDATE trigger setting the ModifiedDate column in the ProductCostHistory table to the current date.after Update Yes

Dependencies for table 'Production.ProductCostHistory', 4 items

Object NameTypeField Name
dbo.ufnGetProductStandardCostscalar functionN/A
Production.CK_ProductCostHistory_EndDatecheck cnsN/A
Production.CK_ProductCostHistory_StandardCostcheck cnsN/A
Production.uProductCostHistorytriggerN/A