USP_DATALIST_REVENUESPLITDETAILS

This datalists returns a list of split amount and designation for a revenue record.

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_REVENUESPLITDETAILS(@ID uniqueidentifier)
      as
          set nocount on;

          select [splits].ID, [splits].TRANSACTIONAMOUNT as Amount, [splits].DESIGNATIONID, dbo.ufn_designation_buildname([splits].DESIGNATIONID) as 'designation', [splits].TRANSACTIONCURRENCYID
        from dbo.revenuesplit as [splits]
        where [splits].revenueid = @ID
        order by [splits].ID;