| Procedure Name | Description | Parameters |
|---|---|---|
| dbo.ufnGetProductStandardCost | Scalar function returning the standard cost 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.ProductCostHistory | user table | ProductID |
| Production.ProductCostHistory | user table | StartDate |
| Production.ProductCostHistory | user table | EndDate |
| Production.ProductCostHistory | user table | StandardCost |