ScrewTurn Wiki

Edit

wikibot

Functiondbo.ufnGetAccountingEndDate
DescriptionScalar function used in the uSalesOrderHeader trigger to set the starting account date.

Edit

Source

CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;

Edit

Dependencies

Reference TypeObject TypeReferencing ObjectChild TypeChild Object
ExecuteTableSales.SalesOrderHeaderTriggeruSalesOrderHeader

Edit

automatically generated

function dbo.ufnGetAccountingEndDate
DescriptionScalar 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 TypeObject TypeReferencing ObjectChild TypeChild Object
ExecuteTableSales.SalesOrderHeaderTriggeruSalesOrderHeader

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.