dbo.ufnGetStock

Procedure/Function: 'dbo.ufnGetStock', Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.

Procedure Name Description Parameters

dbo.ufnGetStock Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. @RETURN_VALUE int(10) [RETURN VALUE], @ProductID int(10) [INPUT]

Procedure Name	Description	Parameters
dbo.ufnGetStock	Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.	@RETURN_VALUE int(10) [RETURN VALUE], @ProductID int(10) [INPUT]

Dependencies for Procedure/Function 'dbo.ufnGetStock', 3 items

Object Name Type Field Name

Production.ProductInventory user table ProductID

Production.ProductInventory user table LocationID

Production.ProductInventory user table Quantity

Object Name	Type	Field Name
Production.ProductInventory	user table	ProductID
Production.ProductInventory	user table	LocationID
Production.ProductInventory	user table	Quantity