Editing Production.ProductCostHistory (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 146: | Line 146: | ||
| not null | | not null | ||
| | | | ||
− | | Product identification number. Foreign key to Product. | + | | Product identification number. Foreign key to Product.ProductIDPK_ProductCostHistory_ProductID_StartDate |
|- valign="top" | |- valign="top" | ||
| StartDate | | StartDate | ||
Line 152: | Line 152: | ||
| not null | | not null | ||
| | | | ||
− | | Product cost start date. | + | | Product cost start date.PK_ProductCostHistory_ProductID_StartDate |
|- valign="top" | |- valign="top" | ||
| EndDate | | EndDate | ||
Line 158: | Line 158: | ||
| null | | null | ||
| | | | ||
− | | Product cost end date. | + | | Product cost end date. |
|- valign="top" | |- valign="top" | ||
| StandardCost | | StandardCost | ||
Line 164: | Line 164: | ||
| not null | | not null | ||
| | | | ||
− | | Standard cost of the product. | + | | Standard cost of the product. |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 170: | Line 170: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
− | | Date and time the record was last updated. | + | | Date and time the record was last updated. |
|} | |} | ||