USP_DATALIST_REVENUESPLIT_BUSINESSUNITS

Returns all the business units for a revenue split.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_REVENUESPLIT_BUSINESSUNITS(@REVENUESPLITID uniqueidentifier)
as
    set nocount on;
    select 
    FINANCIALTRANSACTIONLINEITEM.ID as REVENUESPLITID,
    BUSINESSUNITCODE.DESCRIPTION as BUSINESSUNIT,
    REVENUESPLITBUSINESSUNIT.AMOUNT,
    REVENUESPLITBUSINESSUNIT.BASECURRENCYID
   from dbo.FINANCIALTRANSACTIONLINEITEM
   inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
   inner join dbo.REVENUESPLITBUSINESSUNIT on REVENUESPLITBUSINESSUNIT.REVENUESPLITID = FINANCIALTRANSACTIONLINEITEM.ID
   inner join dbo.BUSINESSUNITCODE on BUSINESSUNITCODE.ID = REVENUESPLITBUSINESSUNIT.BUSINESSUNITCODEID  
   where FINANCIALTRANSACTIONLINEITEM.ID = @REVENUESPLITID
    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1