Procedure Name | Description | Parameters |
---|---|---|
dbo.ufnGetProductDealerPrice | Scalar 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] |
Object Name | Type | Field Name |
---|---|---|
Production.Product | user table | ProductID |
Production.ProductListPriceHistory | user table | ProductID |
Production.ProductListPriceHistory | user table | StartDate |
Production.ProductListPriceHistory | user table | EndDate |
Production.ProductListPriceHistory | user table | ListPrice |