# List of Functions

| Name | Schema | Description | Is Schema Bound | Deterministic | Encrypted | Creation Date
--- | --- | --- | --- | --- | --- | --- | ---
| aaa | dbo | mobi |  |  |  | 12/21/2010 5:37:50 AM
| bbb | dbo |  |  |  |  | 12/21/2010 5:50:02 AM
| fn_diagramobjects | dbo |  |  |  |  | 6/20/2011 3:16:00 PM
| ufnGetAccountingEndDate | dbo | Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetAccountingStartDate | dbo | Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetContactInformation | dbo | Table value function returning the first name, last name, job title and contact type for a given contact. - mobi |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetDocumentStatusText | dbo | Scalar function returning the text representation of the Status column in the Document table. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetProductDealerPrice | dbo | Scalar function returning the dealer price for a given product on a particular order date. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetProductListPrice | dbo | Scalar function returning the list price for a given product on a particular order date. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetProductStandardCost | dbo | Scalar function returning the standard cost for a given product on a particular order date. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetPurchaseOrderStatusText | dbo | Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetSalesOrderStatusText | dbo | Scalar function returning the text representation of the Status column in the SalesOrderHeader table. |  |  |  | 8/8/2010 5:23:46 PM
| ufnGetStock | dbo | Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. |  |  |  | 8/8/2010 5:23:46 PM
| ufnLeadingZeros | dbo | Scalar function used by the Sales.Customer table to help set the account number. |  |  |  | 8/8/2010 5:21:43 PM
| ufn_SalesByStore | Sales | aggregate function - mobi mobi czwartek |  |  |  | 12/21/2010 5:27:26 AM