UFN_ACCOUNTSYSTEM_SITEID_MAPFROM_REVENUESPLIT_BULK

            CREATE function dbo.UFN_ACCOUNTSYSTEM_SITEID_MAPFROM_REVENUESPLIT_BULK()
            returns table as
            return(
                /* A single row is returned when revenuesplit is in the default account system. */
                /* For a revenue split in a non-default account system, a row is returned for each site in that system. */

                select
                    REVENUESPLIT.ID, PDACCOUNTSYSTEMSITE.SITEID
                from dbo.PDACCOUNTSYSTEMSITE as PDACCOUNTSYSTEMSITE
                inner join dbo.PDACCOUNTSYSTEMFORREVENUE on PDACCOUNTSYSTEMSITE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEMFORREVENUE.PDACCOUNTSYSTEMID
                inner join dbo.FINANCIALTRANSACTIONLINEITEM on PDACCOUNTSYSTEMFORREVENUE.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                inner join dbo.REVENUESPLIT_EXT as REVENUESPLIT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT.ID
                inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTSYSTEM.ID = PDACCOUNTSYSTEMFORREVENUE.PDACCOUNTSYSTEMID
                where
                    PDACCOUNTSYSTEM.ISDEFAULT = 0
                union all
                select
                    REVENUESPLIT.ID, null
                from dbo.FINANCIALTRANSACTIONLINEITEM  
                    inner join dbo.REVENUESPLIT_EXT as REVENUESPLIT on REVENUESPLIT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                where
                    exists (select 1 from PDACCOUNTSYSTEMFORREVENUE
                            where ID=FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                            and
                            exists (select 1 from PDACCOUNTSYSTEM where ISDEFAULT = 1 and ID = PDACCOUNTSYSTEMID)
                            )
            )