Difference between revisions of "Dbo.ufnGetAccountingStartDate (function)"

From dbscript Online Help
Jump to: navigation, search
Line 16: Line 16:
 
END;
 
END;
 
</pre>
 
</pre>
 
 
== automatically generated ==
 
== automatically generated ==
  
Line 23: Line 22:
 
| '''function
 
| '''function
 
| dbo.ufnGetAccountingStartDate
 
| dbo.ufnGetAccountingStartDate
|-
+
|- 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 06:26, 30 November 2009

wikibot

function dbo.ufnGetAccountingStartDate
CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN CONVERT(datetime, '20030701', 112);
END;

automatically generated

function dbo.ufnGetAccountingStartDate
Description Scalar function used in the uSalesOrderHeader trigger to set the ending account date.

CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN CONVERT(datetime, '20030701', 112);
END;


Referencing Object Object Type Reference Type
Sales.SalesOrderHeader Table Execute Trigger uSalesOrderHeader