Production.ProductCostHistory (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:39Z

2010-02-02T22:06:17Z

2009-12-28T21:54:47Z

2009-11-30T05:59:31Z

2009-11-30T05:34:53Z

2009-11-30T05:32:11Z

2009-11-30T05:25:05Z

2009-11-26T23:13:00Z

2009-11-26T23:10:23Z

2009-11-26T22:57:34Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.ProductCostHistory
@@ Line 8: / Line 8: @@
 | '''Description
 | Changes in the cost of a product over time.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ProductID
@@ Line 58: / Line 56: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ProductCostHistory_ProductID_StartDate
 | ProductID, StartDate
@@ Line 69: / Line 67: @@
 | '''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))
@@ Line 86: / Line 84: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductID
@@ Line 100: / Line 98: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 114: / Line 112: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | Function

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Product identification number. Foreign key to Product.ProductID<br />PK_ProductCostHistory_ProductID_StartDate
+| Product identification number. Foreign key to Product.ProductID
 |- valign="top"
 | StartDate
@@ Line 31: / Line 32: @@
 | not null
+|
-| Product cost start date.<br />PK_ProductCostHistory_ProductID_StartDate
+| Product cost start date.
 |- valign="top"
 | EndDate
@@ Line 37: / Line 38: @@
 | null
+|
-| Product cost end date.<br />
+| Product cost end date.
 |- valign="top"
 | StandardCost
@@ Line 43: / Line 44: @@
 | not null
+|
-| Standard cost of the product.<br />
+| Standard cost of the product.
 |- valign="top"
 | ModifiedDate
@@ Line 49: / Line 50: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 66: / Line 93: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 79: / Line 120: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.ProductCostHistory
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | ProductID
 | int
 | not null
+|
-| PK_ProductCostHistory_ProductID_StartDate
+| Product identification number. Foreign key to Product.ProductID<br />PK_ProductCostHistory_ProductID_StartDate
+|- valign="top"
 | StartDate
 | datetime
 | not null
+|
-| PK_ProductCostHistory_ProductID_StartDate
+| Product cost start date.<br />PK_ProductCostHistory_ProductID_StartDate
+|- valign="top"
 | EndDate
 | datetime
 | null
+|
+| Product cost end date.<br />
+|- valign="top"
 | StandardCost
 | money
 | not null
+|
+| Standard cost of the product.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 68: / Line 65: @@
 | ProductID
 |}
 == automatically generated ==

@@ Line 75: / Line 75: @@
 | Production.ProductCostHistory
 |- valign="top"
 | '''Description
 | Changes in the cost of a product over time.
 |-
 |}

@@ Line 147: / Line 147: @@
 | Schema
 | Schema
-| [[Production_(schema)|.Production]]
+| [[Production_(schema)|Production]]
 |}

@@ Line 135: / Line 135: @@
 | ProductID
 | ProductID
 |}
@@ Line 143: / Line 156: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[dbo.ufnGetProductStandardCost_(function)|dbo.ufnGetProductStandardCost]]