Production.BillOfMaterials (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:27Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:36Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:04Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:43Z

Bot at 05:38, 30 November 2009

2009-11-30T05:38:55Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:22Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:22Z

Bot at 23:09, 26 November 2009

2009-11-26T23:09:45Z

Bot at 22:56, 26 November 2009

2009-11-26T22:56:45Z

Bot at 22:52, 26 November 2009

2009-11-26T22:52:23Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.BillOfMaterials
@@ Line 8: / Line 8: @@
 | '''Description
 | Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | BillOfMaterialsID
@@ Line 82: / Line 80: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_BillOfMaterials_BillOfMaterialsID
 | BillOfMaterialsID
@@ Line 93: / Line 91: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
 | Unique
 | ProductAssemblyID, ComponentID, StartDate
-|-
+|- valign="top"
 | IX_BillOfMaterials_UnitMeasureCode
+|
@@ Line 110: / Line 108: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_BillOfMaterials_BOMLevel
 | ([ProductAssemblyID] IS NULL AND [BOMLevel]=(0) AND [PerAssemblyQty]=(1.00) OR [ProductAssemblyID] IS NOT NULL AND [BOMLevel]>=(1))
 | Check constraint [ProductAssemblyID] IS NULL AND [BOMLevel] = (0) AND [PerAssemblyQty] = (1) OR [ProductAssemblyID] IS NOT NULL AND [BOMLevel] >= (1)
-|-
+|- valign="top"
 | CK_BillOfMaterials_EndDate
 | ([EndDate]>[StartDate] OR [EndDate] IS NULL)
 | Check constraint EndDate] > [StartDate] OR [EndDate] IS NULL
-|-
+|- valign="top"
 | CK_BillOfMaterials_PerAssemblyQty
 | ([PerAssemblyQty]>=(1.00))
 | Check constraint [PerAssemblyQty] >= (1.00)
-|-
+|- valign="top"
 | CK_BillOfMaterials_ProductAssemblyID
 | ([ProductAssemblyID]<>[ComponentID])
@@ Line 135: / Line 133: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ComponentID
 | ProductID
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductAssemblyID
 | ProductID
-|-
+|- valign="top"
 | [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 | UnitMeasureCode
@@ Line 157: / Line 155: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 171: / Line 169: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | Procedure
 | [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]]
-|-
+|- valign="top"
 | Select
 | Procedure

@@ 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
+|
-| Primary key for BillOfMaterials records.<br />PK_BillOfMaterials_BillOfMaterialsID
+| Primary key for BillOfMaterials records.
 |- valign="top"
 | ProductAssemblyID
@@ Line 31: / Line 32: @@
 | null
+|
-| Parent product identification number. Foreign key to Product.ProductID.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
+| Parent product identification number. Foreign key to Product.ProductID.
 |- valign="top"
 | ComponentID
@@ Line 37: / Line 38: @@
 | not null
+|
-| Component identification number. Foreign key to Product.ProductID.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
+| Component identification number. Foreign key to Product.ProductID.
 |- valign="top"
 | StartDate
@@ Line 43: / Line 44: @@
 | not null
 | (getdate())
-| Date the component started being used in the assembly item.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
+| Date the component started being used in the assembly item.
 |- valign="top"
 | EndDate
@@ Line 49: / Line 50: @@
 | null
+|
-| Date the component stopped being used in the assembly item.<br />
+| Date the component stopped being used in the assembly item.
 |- valign="top"
 | UnitMeasureCode
@@ Line 55: / Line 56: @@
 | not null
+|
-| Standard code identifying the unit of measure for the quantity.<br />IX_BillOfMaterials_UnitMeasureCode
+| Standard code identifying the unit of measure for the quantity.
 |- valign="top"
 | BOMLevel
@@ Line 61: / Line 62: @@
 | not null
+|
-| Indicates the depth the component is from its parent (AssemblyID).<br />
+| Indicates the depth the component is from its parent (AssemblyID).
 |- valign="top"
 | PerAssemblyQty
@@ Line 67: / Line 68: @@
 | not null
 | ((1.00))
-| Quantity of the component needed to create the assembly.<br />
+| Quantity of the component needed to create the assembly.
 |- valign="top"
 | ModifiedDate
@@ Line 73: / Line 74: @@
 | 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 98: / Line 150: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 116: / Line 182: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.BillOfMaterials
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | BillOfMaterialsID
 | int
 | not null
+|
-| PK_BillOfMaterials_BillOfMaterialsID
+| Primary key for BillOfMaterials records.<br />PK_BillOfMaterials_BillOfMaterialsID
+|- valign="top"
 | ProductAssemblyID
 | int
 | null
+|
+| Parent product identification number. Foreign key to Product.ProductID.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
-| AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
+|- valign="top"
 | ComponentID
 | int
 | not null
+|
+| Component identification number. Foreign key to Product.ProductID.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
-| AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
+|- valign="top"
 | StartDate
 | datetime
 | not null
 | (getdate())
+| Date the component started being used in the assembly item.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
-| AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
+|- valign="top"
 | EndDate
 | datetime
 | null
+|
+| Date the component stopped being used in the assembly item.<br />
+|- valign="top"
 | UnitMeasureCode
 | nchar(3)
 | not null
+|
+| Standard code identifying the unit of measure for the quantity.<br />IX_BillOfMaterials_UnitMeasureCode
-| IX_BillOfMaterials_UnitMeasureCode
+|- valign="top"
 | BOMLevel
 | smallint
 | not null
+|
+| Indicates the depth the component is from its parent (AssemblyID).<br />
+|- valign="top"
 | PerAssemblyQty
 | decimal(8, 2)
 | not null
 | ((1.00))
+| Quantity of the component needed to create the assembly.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 104: / Line 97: @@
 | UnitMeasureCode
 |}
 == automatically generated ==

@@ Line 111: / Line 111: @@
 | Production.BillOfMaterials
 |- valign="top"
 | '''Description
 | Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
 |-
 |}

@@ Line 208: / Line 208: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}
@@ Line 221: / Line 222: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]]
 | Procedure
 | [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]]
-| Procedure
 |}

@@ Line 203: / Line 203: @@
 | UnitMeasureCode
 | UnitMeasureCode
 |}
@@ Line 211: / Line 224: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]]