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.BillOfMaterials_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | 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. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | BillOfMaterialsID | int | not null | | Primary key for BillOfMaterials records. |- valign="top" | ProductAssemblyID | int | null | | Parent product identification number. Foreign key to Product.ProductID. |- valign="top" | ComponentID | int | not null | | Component identification number. Foreign key to Product.ProductID. |- valign="top" | StartDate | datetime | not null | (getdate()) | Date the component started being used in the assembly item. |- valign="top" | EndDate | datetime | null | | Date the component stopped being used in the assembly item. |- valign="top" | UnitMeasureCode | nchar(3) | not null | | Standard code identifying the unit of measure for the quantity. |- valign="top" | BOMLevel | smallint | not null | | Indicates the depth the component is from its parent (AssemblyID). |- valign="top" | PerAssemblyQty | decimal(8, 2) | not null | ((1.00)) | Quantity of the component needed to create the assembly. |- 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_BillOfMaterials_BillOfMaterialsID | BillOfMaterialsID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate | Unique | ProductAssemblyID, ComponentID, StartDate |- valign="top" | IX_BillOfMaterials_UnitMeasureCode | | UnitMeasureCode |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''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]) | Check constraint [ProductAssemblyID] <> [ComponentID] |} === 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]] | ComponentID | ProductID |- valign="top" | [[Production.Product_(table)|Production.Product]] | ProductAssemblyID | ProductID |- valign="top" | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | UnitMeasureCode | UnitMeasureCode |} === 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 | Procedure | [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]] |- valign="top" | Select | Procedure | [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | 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. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | BillOfMaterialsID | int | not null | | Primary key for BillOfMaterials records.<br />PK_BillOfMaterials_BillOfMaterialsID |- | ProductAssemblyID | int | null | | Parent product identification number. Foreign key to Product.ProductID.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |- | ComponentID | int | not null | | Component identification number. Foreign key to Product.ProductID.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |- | StartDate | datetime | not null | (GETDATE()) | Date the component started being used in the assembly item.<br />AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate |- | EndDate | datetime | null | | Date the component stopped being used in the assembly item.<br /> |- | UnitMeasureCode | nchar(3) | not null | | Standard code identifying the unit of measure for the quantity.<br />IX_BillOfMaterials_UnitMeasureCode |- | BOMLevel | smallint | not null | | Indicates the depth the component is from its parent (AssemblyID).<br /> |- | PerAssemblyQty | decimal(8, 2) | not null | (1.00) | Quantity of the component needed to create the assembly.<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]] | ComponentID | ProductID |- | [[Production.Product_(table)|Production.Product]] | ProductAssemblyID | ProductID |- | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | UnitMeasureCode | UnitMeasureCode |} {| 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 | Procedure | [[dbo.uspGetBillOfMaterials_(procedure)|dbo.uspGetBillOfMaterials]] |- | Select | Procedure | [[dbo.uspGetWhereUsedProductID_(procedure)|dbo.uspGetWhereUsedProductID]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.