Functions

	Name	Owner	Type	Description
	ufnGetAccountingEndDate	dbo	SQL scalar function	Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
	ufnGetAccountingStartDate	dbo	SQL scalar function	Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
	ufnGetContactInformation	dbo	SQL table-valued-function	Table value function returning the first name, last name, job title and contact type for a given contact.
	ufnGetDocumentStatusText	dbo	SQL scalar function	Scalar function returning the text representation of the Status column in the Document table.
	ufnGetProductDealerPrice	dbo	SQL scalar function	Scalar function returning the dealer price for a given product on a particular order date.
	ufnGetProductListPrice	dbo	SQL scalar function	Scalar function returning the list price for a given product on a particular order date.
	ufnGetProductStandardCost	dbo	SQL scalar function	Scalar function returning the standard cost for a given product on a particular order date.
	ufnGetPurchaseOrderStatusText	dbo	SQL scalar function	Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table.
	ufnGetSalesOrderStatusText	dbo	SQL scalar function	Scalar function returning the text representation of the Status column in the SalesOrderHeader table.
	ufnGetStock	dbo	SQL scalar function	Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
	ufnLeadingZeros	dbo	SQL scalar function	Scalar function used by the Sales.Customer table to help set the account number.

Total: 11 function(s)

See Also

Database overview