Difference between revisions of "Dbo.ufnGetAccountingEndDate (function)"
| Line 33: | Line 33: | ||
| Execute | | Execute | ||
| Table | | Table | ||
| − | | [[Sales.SalesOrderHeader_ | + | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] |
| Trigger | | Trigger | ||
Latest revision as of 23:15, 23 June 2010
wikibot[edit]
| Function | dbo.ufnGetAccountingEndDate |
| Description | Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
Source[edit]
CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime]
AS
BEGIN
RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;
Dependencies[edit]
| Reference Type | Object Type | Referencing Object | Child Type | Child Object |
| Execute | Table | Sales.SalesOrderHeader | Trigger | uSalesOrderHeader |
automatically generated[edit]
| function | dbo.ufnGetAccountingEndDate |
| Description | Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime]
AS
BEGIN
RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;
| Reference Type | Object Type | Referencing Object | Child Type | Child Object |
| Execute | Table | Sales.SalesOrderHeader | Trigger | uSalesOrderHeader |
