Difference between revisions of "Dbo.ufnGetAccountingStartDate (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.ufnGetAccountingStartDate |
| Description | Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |
Source[edit]
CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
RETURNS [datetime]
AS
BEGIN
RETURN CONVERT(datetime, '20030701', 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.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;
| Reference Type | Object Type | Referencing Object | Child Type | Child Object |
| Execute | Table | Sales.SalesOrderHeader | Trigger | uSalesOrderHeader |