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) — 42.9%

[...] 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 quantity. BOMLevel smallint not null Indicates the depth the component is from its parent (AssemblyID). [...]

dbo uspGetBillOfMaterials (procedure) — 21.4%

[...] 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] [...]

dbo uspGetWhereUsedProductID (procedure) — 21.4%

[...] 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] p ON b.[ProductAssemblyID] [...]

WikiMarkup — 7.1%

[...] SickLeaveHours VacationHours EndDate StartDate PayFrequency Rate (table) EmailPromotion BOMLevel ComponentID PerAssemblyQty ProductAssemblyID Status [...]

Production Product (table) — 7.1%

[...] Detail Tables Detail Table Column Referencing Column Production.BillOfMaterials ProductID ComponentID Production.BillOfMaterials ProductID ProductAssemblyID [...]