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 4 results.
[...] quantity. BOMLevel smallint not null Indicates the depth the component is from its parent (AssemblyID). PerAssemblyQty decimal(8, 2) not null ((1.00)) Quantity of the component needed to create the assembly. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_BillOfMaterials_BillOfMaterialsID BillOfMaterialsID Indexes Index Type Columns AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate Unique ProductAssemblyID, ComponentID, StartDate IX_BillOfMaterials_UnitMeasureCode UnitMeasureCode [...]
[...] 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], [...]
[...] 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], [...]
[...] VacationHours EndDate StartDate PayFrequency Rate (table) EmailPromotion BOMLevel ComponentID PerAssemblyQty ProductAssemblyID Status Availability [...]