Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Filter by Category

Production BillOfMaterials (table) — 57.9%

[...] Default Description BillOfMaterialsID int not null Primary key for BillOfMaterials records. ProductAssemblyID int null Parent product identification number. Foreign key to Product.ProductID. ComponentID int not null Component identification number. Foreign key to Product.ProductID. StartDate datetime not null (getdate()) Date the component started being used in the assembly item. EndDate datetime null Date the component stopped being used in the assembly item. UnitMeasureCode nchar(3) not null Standard code identifying the unit of measure for the [...]

dbo uspGetBillOfMaterials (procedure) — 15.8%

[...] CheckDate eliminates any components that are no longer used in the product on this date. WITH [BOM_cte]([ProductAssemblyID], [ComponentID], [ComponentDesc], [PerAssemblyQty], [StandardCost], [ListPrice], [BOMLevel], [RecursionLevel]) -- CTE name and columns AS ( SELECT b.[ProductAssemblyID], b.[ComponentID], p.[Name], b.[PerAssemblyQty], p.[StandardCost], p.[ListPrice], b.[BOMLevel], 0 -- Get the initial list of components for the bike assembly FROM [Production].[BillOfMaterials] b INNER JOIN [Production].[Product] p [...]

dbo uspGetWhereUsedProductID (procedure) — 15.8%

[...] components of a level 0 assembly, all level 2 components of a level 1 assembly) WITH [BOM_cte]([ProductAssemblyID], [ComponentID], [ComponentDesc], [PerAssemblyQty], [StandardCost], [ListPrice], [BOMLevel], [RecursionLevel]) -- CTE name and columns AS ( SELECT b.[ProductAssemblyID], b.[ComponentID], p.[Name], b.[PerAssemblyQty], p.[StandardCost], p.[ListPrice], b.[BOMLevel], 0 -- Get the initial list of components for the bike assembly FROM [Production].[BillOfMaterials] b INNER JOIN [Production].[Product] [...]

WikiMarkup — 5.3%

[...] EndDate StartDate PayFrequency Rate (table) EmailPromotion BOMLevel ComponentID PerAssemblyQty ProductAssemblyID Status Availability CostRate Class DaysToManufacture [...]

Production Product (table) — 5.3%

[...] Column Production.BillOfMaterials ProductID ComponentID Production.BillOfMaterials ProductID ProductAssemblyID Production.ProductCostHistory ProductID [...]