Production ProductCostHistory (table)

wikibot

TableProduction.ProductCostHistory
DescriptionChanges in the cost of a product over time.

Columns

ColumnData TypeNullableDefaultDescription
ProductIDintnot null Product identification number. Foreign key to Product.ProductID
StartDatedatetimenot null Product cost start date.
EndDatedatetimenull Product cost end date.
StandardCostmoneynot null Standard cost of the product.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ProductCostHistory_ProductID_StartDateProductID, StartDate

Check Constraints

Check ConstraintExpressionDescription
CK_ProductCostHistory_EndDate(EndDate>=StartDate OR EndDate IS NULL)Check constraint EndDate >= StartDate OR EndDate IS NULL
CK_ProductCostHistory_StandardCost(StandardCost>=(0.00))Check constraint StandardCost >= (0.00)

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Dependencies

Reference TypeObject TypeReferencing Object
SelectFunctiondbo.ufnGetProductStandardCost