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 6 results.
[...] StartDate datetime not null Product cost start date. EndDate datetime null Product cost end date. StandardCost money not null Standard cost of the product. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ProductCostHistory_ProductID_StartDate ProductID, StartDate Check Constraints Check Constraint Expression Description CK_ProductCostHistory_EndDate ( EndDate >= StartDate OR EndDate IS NULL) Check constraint EndDate >= StartDate OR EndDate IS NULL CK_ProductCostHistory_StandardCost [...]
[...] [money]
AS
-- Returns the standard cost for the product on a specific date.
BEGIN
DECLARE @StandardCost money;
SELECT @StandardCost = pch.[StandardCost]
FROM [Production].[Product] p
INNER JOIN [Production].[ProductCostHistory] pch
ON p.[ProductID] = pch.[ProductID]
AND p.[ProductID] = @ProductID
AND @OrderDate BETWEEN pch.[StartDate] AND COALESCE(pch.[EndDate], [...]
[...] ReorderPoint smallint not null Inventory level that triggers a purchase order or work order. StandardCost money not null Standard cost of the product. ListPrice money not null Selling price. Size nvarchar(5) null Product size. SizeUnitMeasureCode nchar(3) null Unit of measure for Size column. WeightUnitMeasureCode nchar(3) null Unit of measure for Weight column. Weight decimal(8, 2) null Product weight. DaysToManufacture int not null Number of days required to manufacture the product. ProductLine nchar(2) null R = Road, M = Mountain, T [...]
[...] 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], [...]
[...] 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], [...]
[...] DaysToManufacture ListPrice ProductLine ReorderPoint SafetyStockLevel SellEndDate SellStartDate StandardCost Style Weight A-Za-z Bin Shelf Rating [...]