dbo.ufnGetProductListPrice

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

Procedure Name	Description	Parameters
dbo.ufnGetProductListPrice	Scalar function returning the list 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.ufnGetProductListPrice', 5 items

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