UFN_REVENUE_GENERATEGLACCOUNT_STANDARD_4

Generates GL Account Code and account from the account code mappings defined in the system.

Return

Return Type
table

Parameters

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

Definition

Copy



            CREATE function dbo.UFN_REVENUE_GENERATEGLACCOUNT_STANDARD_4
            (
                @REVENUEID uniqueidentifier, 
                @REVENUESPLITID uniqueidentifier, 
                @INFORMATIONSOURCECODE tinyint, -- 0 revenue tables, 1 revenue batch tables

                @REVENUETRANSACTIONTYPECODE tinyint, 
                @REVENUESPLITTYPECODE tinyint, 
                @APPLICATIONCODE tinyint, 
                @PAYMENTMETHODCODE tinyint, 
                @DESIGNATIONID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier = null
            )
            returns @AccountNumbers table 
                (
                    AccountString nvarchar(100), 
                    ProjectCode varchar(255), 
                    TransactionTypeCode tinyint, 
                    AccountID uniqueidentifier, 
                    ErrorMessage varchar(max),
                    MappedValues xml
                )
            as
            begin

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

            ----------------------------------------------------------------------------------

            -- Backwards Compatibility: Allowing the caller to override the value returned 

            -- from UFN_REVENUEINFORMATION and UFN_REVENUESPLITINFORMATION functions

            ----------------------------------------------------------------------------------            

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

            insert into @AccountNumbers (AccountString, ProjectCode, TransactionTypeCode, AccountID ,ErrorMessage, MappedValues)
            select AccountString, ProjectCode, TransactionTypeCode, AccountID ,ErrorMessage, MappedValues 
            from dbo.UFN_REVENUE_GENERATEGLACCOUNT_STANDARD_5(@REVENUEINFORMATION, @REVENUESPLITINFORMATION , @INFORMATIONSOURCECODE, @CURRENTAPPUSERID)

          return
        end