Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

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.



Filter by Category


This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 4 results.

Production BillOfMaterials (table) — 54.5%

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

dbo uspGetWhereUsedProductID (procedure) — 18.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], [...]

dbo uspGetBillOfMaterials (procedure) — 18.2%

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

WikiMarkup — 9.1%

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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.