ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Production.ProductCostHistory_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Production.ProductCostHistory |- valign="top" | '''Description''' | Changes in the cost of a product over time. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID |- valign="top" | StartDate | datetime | not null | | Product cost start date. |- valign="top" | EndDate | datetime | null | | Product cost end date. |- valign="top" | StandardCost | money | not null | | Standard cost of the product. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_ProductCostHistory_ProductID_StartDate | ProductID, StartDate |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | CK_ProductCostHistory_EndDate | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) | Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL |- valign="top" | CK_ProductCostHistory_StandardCost | ([StandardCost]>=(0.00)) | Check constraint [StandardCost] >= (0.00) |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[Production.Product_(table)|Production.Product]] | ProductID | ProductID |} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Schema | Schema | [[Production_(schema)|Production]] |} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- valign="top" | Select | Function | [[dbo.ufnGetProductStandardCost_(function)|dbo.ufnGetProductStandardCost]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Production.ProductCostHistory |- valign="top" | '''Description''' | Changes in the cost of a product over time. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID<br />PK_ProductCostHistory_ProductID_StartDate |- | StartDate | datetime | not null | | Product cost start date.<br />PK_ProductCostHistory_ProductID_StartDate |- | EndDate | datetime | null | | Product cost end date.<br /> |- | StandardCost | money | not null | | Standard cost of the product.<br /> |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- | [[Production.Product_(table)|Production.Product]] | ProductID | ProductID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Production_(schema)|Production]] |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- | Select | Function | [[dbo.ufnGetProductStandardCost_(function)|dbo.ufnGetProductStandardCost]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.