dbo ufnGetAccountingEndDate (function)

Modified on 2011/08/27 11:16 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Function'''
| dbo.ufnGetAccountingEndDate
|- valign="top"
| '''Description'''
| Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
|}

=== Source ===
{{{{<nowiki>
CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;
</nowiki>}}}}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type'''
| '''Object Type'''
| '''Referencing Object'''

| '''Child Type'''
| '''Child Object'''

|- valign="top"
| Execute
| Table
| [[Sales SalesOrderHeader (table)|Sales.SalesOrderHeader]]

| Trigger
| uSalesOrderHeader
|}

devio dbscript ScrewTurn Wiki

Navigation¶

dbo ufnGetAccountingEndDate (function)