USP_DATALIST_REVENUEPLEDGE_SPLIT

This datalist returns a list of splits for a pledge within a revenue transaction context.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REVENUEPLEDGE_SPLIT (@ID uniqueidentifier)
                as 
                    set nocount on;

                    select
                        [SPLITS].ID,
                        dbo.UFN_DESIGNATION_BUILDNAME([SPLITS].DESIGNATIONID) as 'Designation',
                        FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT,
                        dbo.UFN_PLEDGE_GETDESIGNATIONBALANCE(FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID, [SPLITS].DESIGNATIONID) [BALANCE],
                        GLREVENUECATEGORYMAPPING.REVENUECATEGORYNAME,
                        FINANCIALTRANSACTION.TRANSACTIONCURRENCYID
                    from dbo.FINANCIALTRANSACTIONLINEITEM
                    inner join dbo.REVENUESPLIT_EXT as [SPLITS] on FINANCIALTRANSACTIONLINEITEM.ID = [SPLITS].ID
                    inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                    left outer join dbo.REVENUECATEGORY on [SPLITS].ID = REVENUECATEGORY.ID
                    left outer join dbo.GLREVENUECATEGORYMAPPING on REVENUECATEGORY.GLREVENUECATEGORYMAPPINGID = GLREVENUECATEGORYMAPPING.ID
                    where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @ID and [SPLITS].DESIGNATIONID is not null
                        and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
                    order by dbo.UFN_DESIGNATION_BUILDNAME([SPLITS].DESIGNATIONID);