Difference between revisions of "Dbo.ufnGetAccountingEndDate (function)"
| Line 16: | Line 16: | ||
END; | END; | ||
</pre> | </pre> | ||
| − | |||
== automatically generated == | == automatically generated == | ||
| Line 23: | Line 22: | ||
| '''function | | '''function | ||
| dbo.ufnGetAccountingEndDate | | dbo.ufnGetAccountingEndDate | ||
| − | |- | + | |- valign="top" |
| '''Description | | '''Description | ||
| Line 47: | Line 46: | ||
| '''Object Type | | '''Object Type | ||
| '''Reference Type | | '''Reference Type | ||
| − | + | ||
|- | |- | ||
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ||
| Table | | Table | ||
| Execute | | Execute | ||
| + | | Trigger | ||
| + | | uSalesOrderHeader | ||
|} | |} | ||
Revision as of 07:26, 30 November 2009
wikibot
| function | dbo.ufnGetAccountingEndDate |
CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime]
AS
BEGIN
RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;
automatically generated
| 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;
| Referencing Object | Object Type | Reference Type | ||
| Sales.SalesOrderHeader | Table | Execute | Trigger | uSalesOrderHeader |
