UFN_GLACCOUNTTYPEMAPPING

Returns the GL codes from the GLPAYMENTMETHODREVENUETYPEMAPPING table with credits and debits separated into two rows.

Return

Return Type
table

Definition

Copy



            create function DBO.UFN_GLACCOUNTTYPEMAPPING()
            returns table
            as
            return
            (
                SELECT  MAP.PAYMENTMETHODCODE, MAP.REVENUETYPECODE, 'C' as DEBITCREDIT, MAP.CREDITGLACCOUNTTYPEMAPPINGID  as ACCOUNTID FROM dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP

                    UNION ALL

                SELECT MAP.PAYMENTMETHODCODE, MAP.REVENUETYPECODE, 'D' as DEBITCREDIT, MAP.DEBITGLACCOUNTTYPEMAPPINGID as ACCOUNTID FROM dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP
            )