UFN_REVENUE_GETSPLITS_LISTINCURRENCY_BULK

Returns a list of splits for a given revenue record and translates the amounts in a currency.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@CURRENCYID	uniqueidentifier	IN
@ORGANIZATIONCURRENCYID	uniqueidentifier	IN
@DECIMALDIGITS	tinyint	IN
@ROUNDINGTYPECODE	tinyint	IN
@ORIGINCODE	tinyint	IN

Definition

Copy



            create function dbo.UFN_REVENUE_GETSPLITS_LISTINCURRENCY_BULK
            (
                @REVENUEID uniqueidentifier,
                @CURRENCYID uniqueidentifier = null,
                @ORGANIZATIONCURRENCYID uniqueidentifier,
                @DECIMALDIGITS tinyint,
                @ROUNDINGTYPECODE tinyint,
                @ORIGINCODE tinyint
            )
            returns table            
            as            
            return 
                (
                    select
                        RDS.ID,
                        RDS.AMOUNTINCURRENCY - sum(coalesce(WO.AMOUNT,0)) AMOUNT,
                        dbo.UFN_DESIGNATION_BUILDNAME(RDS.DESIGNATIONID) PURPOSE
                    from
                        dbo.UFN_REVENUESPLIT_GETAMOUNTINCURRENCY_BULK(@CURRENCYID, @ORGANIZATIONCURRENCYID, @DECIMALDIGITS, @ROUNDINGTYPECODE) RDS
                    outer apply dbo.UFN_WRITEOFF_GETLOGICALSPLITSINCURRENCY_BULK(RDS.ID, @CURRENCYID, @ORGANIZATIONCURRENCYID, @DECIMALDIGITS, @ROUNDINGTYPECODE, @ORIGINCODE) as WO
                    where
                        RDS.REVENUEID = @REVENUEID
                    group by
                        RDS.ID, RDS.AMOUNTINCURRENCY, dbo.UFN_DESIGNATION_BUILDNAME(RDS.DESIGNATIONID)
                );