Difference between revisions of "Production.BillOfMaterials (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.BillOfMaterials |- |} {| border="1" cellpadding="5" cellspacing="...) |
|||
| Line 55: | Line 55: | ||
|- | |- | ||
| UnitMeasureCode | | UnitMeasureCode | ||
| − | | nchar( | + | | nchar(3) |
| not null | | not null | ||
| | | | ||
Revision as of 15:30, 3 January 2009
wikibot
| Table | Production.BillOfMaterials |
| Column | Data Type | Nullable | Default | PK | Index |
| BillOfMaterialsID | int | not null | PK_BillOfMaterials_BillOfMaterialsID | ||
| ProductAssemblyID | int | null | AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate | ||
| ComponentID | int | not null | AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate | ||
| StartDate | datetime | not null | (getdate()) | AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate | |
| EndDate | datetime | null | |||
| UnitMeasureCode | nchar(3) | not null | IX_BillOfMaterials_UnitMeasureCode | ||
| BOMLevel | smallint | not null | |||
| PerAssemblyQty | decimal(8, 2) | not null | ((1.00)) | ||
| ModifiedDate | datetime | not null | (getdate()) |
| Relation | Column | Referenced Column |
| Production.Product | ComponentID | ProductID |
| Production.Product | ProductAssemblyID | ProductID |
| Production.UnitMeasure | UnitMeasureCode | UnitMeasureCode |
