| name | created | modified | code length | dependents | depends on | inline | deterministic | schema bound | comment |
|---|---|---|---|---|---|---|---|---|---|
| ufnGetAccountingEndDate | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 166 | 0 | 0 | no | no | no | Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
| ufnGetAccountingStartDate | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 142 | 0 | 0 | no | no | no | Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |
| ufnGetContactInformation | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 2,851 | 0 | 7 | no | no | no | Table value function returning the first name, last name, job title and contact type for a given contact. |
| ufnGetDocumentStatusText | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 457 | 0 | 0 | no | no | no | Scalar function returning the text representation of the Status column in the Document table. |
| ufnGetProductDealerPrice | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 763 | 0 | 2 | no | no | no | Scalar function returning the dealer price for a given product on a particular order date. |
| ufnGetProductListPrice | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 576 | 0 | 2 | no | no | no | Scalar function returning the list price for a given product on a particular order date. |
| ufnGetProductStandardCost | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 647 | 0 | 2 | no | no | no | Scalar function returning the standard cost for a given product on a particular order date. |
| ufnGetPurchaseOrderStatusText | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 485 | 0 | 0 | no | no | no | Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. |
| ufnGetSalesOrderStatusText | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 560 | 0 | 0 | no | no | no | Scalar function returning the text representation of the Status column in the SalesOrderHeader table. |
| ufnGetStock | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | 481 | 0 | 1 | no | no | no | Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. |
| ufnLeadingZeros | Mar 19 2009 9:09PM | Mar 19 2009 9:09PM | 332 | 1 | 0 | no | yes | yes | Scalar function used by the Sales.Customer table to help set the account number. |