UFN_REVENUE_GENERATEGLACCOUNT

Generates general ledger Account Code from the Account code mappings defined in the system.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@REVENUESPLITID	uniqueidentifier	IN
@REVENUETRANSACTIONTYPECODE	tinyint	IN
@REVENUESPLITTYPECODE	tinyint	IN
@APPLICATIONCODE	tinyint	IN
@PAYMENTMETHODCODE	tinyint	IN
@DESIGNATIONID	uniqueidentifier	IN

Definition

Copy



CREATE function [dbo].[UFN_REVENUE_GENERATEGLACCOUNT]
(
    @REVENUESPLITID as uniqueidentifier,
    @REVENUETRANSACTIONTYPECODE tinyint,
    @REVENUESPLITTYPECODE tinyint,
    @APPLICATIONCODE tinyint,
    @PAYMENTMETHODCODE tinyint,
    @DESIGNATIONID uniqueidentifier
)
returns 
@DATA table (ACCOUNTSTRING nvarchar(255), PROJECTCODE nvarchar(255), TRANSACTIONTYPECODE tinyint, ACCOUNTID uniqueidentifier, ERRORMESSAGE nvarchar(max), MAPPEDVALUES xml)
as
    begin

        if dbo.UFN_VALID_BASICGL_INSTALLED() != 0
        begin
            declare @REVENUEID uniqueidentifier;
            select @REVENUEID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
            from dbo.FINANCIALTRANSACTIONLINEITEM
            where FINANCIALTRANSACTIONLINEITEM.ID = @REVENUESPLITID;

            declare @REVENUEINFORMATION xml = dbo.UFN_REVENUEINFORMATION_TOITEMLISTXML(@REVENUEID, 0, null);
            declare @REVENUESPLITINFORMATION xml = dbo.UFN_REVENUESPLITINFORMATION_TOITEMLISTXML(@REVENUEID, @REVENUESPLITID, 0, null);

            select 
                @REVENUEINFORMATION = OVERRIDE.REVENUEINFORMATION,
                @REVENUESPLITINFORMATION = OVERRIDE.REVENUESPLITINFORMATION
            from dbo.UFN_REVENUE_GENERATEGLACCOUNT_APPLYOVERRIDES(@REVENUEINFORMATION, @REVENUESPLITINFORMATION, @REVENUETRANSACTIONTYPECODE, @REVENUESPLITTYPECODE, @APPLICATIONCODE, @PAYMENTMETHODCODE, @DESIGNATIONID) OVERRIDE

            insert into @DATA (ACCOUNTSTRING,PROJECTCODE,TRANSACTIONTYPECODE,ACCOUNTID,ERRORMESSAGE, MAPPEDVALUES)
            select
                ACCOUNTSTRING,
                PROJECTCODE,
                TRANSACTIONTYPECODE,
                ACCOUNTID,
                ERRORMESSAGE,
                MAPPEDVALUES
            from dbo.UFN_REVENUE_GENERATEGLACCOUNT_STANDARD_5(@REVENUEINFORMATION, @REVENUESPLITINFORMATION , 0, null)
        end
        else
            insert into @DATA (ACCOUNTSTRING,PROJECTCODE,TRANSACTIONTYPECODE,ACCOUNTID,ERRORMESSAGE)
            select ACCOUNTSTRING, PROJECTCODE, TRANSACTIONTYPECODE,ACCOUNTID,ERRORMESSAGE 
            from dbo.UFN_REVENUE_GENERATEGLACCOUNT_STANDARD(@REVENUESPLITID, @REVENUETRANSACTIONTYPECODE, 
            @REVENUESPLITTYPECODE, @APPLICATIONCODE, @PAYMENTMETHODCODE,@DESIGNATIONID)

        return;
    end