dbo.ufnGetProductDealerPrice

Procedure/Function: 'dbo.ufnGetProductDealerPrice', Scalar function returning the dealer price for a given product on a particular order date.

Procedure NameDescriptionParameters
dbo.ufnGetProductDealerPriceScalar function returning the dealer price for a given product on a particular order date.@RETURN_VALUE money(19) [RETURN VALUE], @ProductID int(10) [INPUT], @OrderDate datetime(23) [INPUT]

Dependencies for Procedure/Function 'dbo.ufnGetProductDealerPrice', 5 items

Object NameTypeField Name
Production.Productuser tableProductID
Production.ProductListPriceHistoryuser tableProductID
Production.ProductListPriceHistoryuser tableStartDate
Production.ProductListPriceHistoryuser tableEndDate
Production.ProductListPriceHistoryuser tableListPrice