Search Engine
Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 5 results.
[...] 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). [...]
[...] 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] [...]
[...] 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] [...]
[...] SickLeaveHours VacationHours EndDate StartDate PayFrequency Rate (table) EmailPromotion BOMLevel ComponentID PerAssemblyQty ProductAssemblyID Status [...]
[...] Detail Tables Detail Table Column Referencing Column Production.BillOfMaterials ProductID ComponentID Production.BillOfMaterials ProductID ProductAssemblyID [...]