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.
[...] 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). 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 [...]
[...] [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], [...]
[...] [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], [...]
[...] MaritalStatus SickLeaveHours VacationHours EndDate StartDate PayFrequency Rate (table) EmailPromotion BOMLevel ComponentID PerAssemblyQty ProductAssemblyID [...]