Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production BillOfMaterials (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:00


wikibot

TableProduction.BillOfMaterials
DescriptionItems required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.

ColumnData TypeNullableDefaultDescription / PK / Index
BillOfMaterialsIDintnot null Primary key for BillOfMaterials records.
PK_BillOfMaterials_BillOfMaterialsID
ProductAssemblyIDintnull Parent product identification number. Foreign key to Product.ProductID.
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
ComponentIDintnot null Component identification number. Foreign key to Product.ProductID.
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
StartDatedatetimenot null(getdate())Date the component started being used in the assembly item.
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
EndDatedatetimenull Date the component stopped being used in the assembly item.
UnitMeasureCodenchar(3)not null Standard code identifying the unit of measure for the quantity.
IX_BillOfMaterials_UnitMeasureCode
BOMLevelsmallintnot null Indicates the depth the component is from its parent (AssemblyID).
PerAssemblyQtydecimal(8, 2)not null((1.00))Quantity of the component needed to create the assembly.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.ProductComponentIDProductID
Production.ProductProductAssemblyIDProductID
Production.UnitMeasureUnitMeasureCodeUnitMeasureCode

Reference TypeObject TypeReferencing Object
SelectProceduredbo.uspGetBillOfMaterials
SelectProceduredbo.uspGetWhereUsedProductID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.