Production.ProductCostHistory (table)

From dbscript Online Help
Jump to: navigation, search

wikibot

Table Production.ProductCostHistory
Description Changes in the cost of a product over time.

Columns

Column Data Type Nullable Default Description
ProductID int not null Product identification number. Foreign key to Product.ProductID
StartDate datetime not null Product cost start date.
EndDate datetime null Product cost end date.
StandardCost money not null Standard cost of the product.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key

Primary Key Columns
PK_ProductCostHistory_ProductID_StartDate ProductID, StartDate

Check Constraints

Check Constraint Expression Description
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

Relation Column Referenced Column
Production.Product ProductID ProductID

References

Dependency Type Object Type Referenced Object
Schema Schema Production

Dependencies

Reference Type Object Type Referencing Object
Select Function dbo.ufnGetProductStandardCost


automatically generated

Table Production.ProductCostHistory
Description Changes in the cost of a product over time.


Column Data Type Nullable Default Description / PK / Index
ProductID int not null Product identification number. Foreign key to Product.ProductID
PK_ProductCostHistory_ProductID_StartDate
StartDate datetime not null Product cost start date.
PK_ProductCostHistory_ProductID_StartDate
EndDate datetime null Product cost end date.
StandardCost money not null Standard cost of the product.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Product ProductID ProductID


Dependency Type Object Type Referenced Object
Schema Schema Production


Reference Type Object Type Referencing Object
Select Function dbo.ufnGetProductStandardCost