USP_DATALIST_BANKACCOUNTTRANSACTIONGLDISTRIBUTION

A datalist of bank account transaction GL Distribution.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_BANKACCOUNTTRANSACTIONGLDISTRIBUTION
    (@ID uniqueidentifier
    ,@SYSTEMDISTRIBUTION bit = 0)
as
    set nocount on;
    select 
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.BANKACCOUNTTRANSACTIONID as ID,
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.ID as BANKACCOUNTTRANSACTIONGLDISTRIBUTIONID,
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONTYPE,                        
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.ACCOUNT,
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.PROJECT,
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.AMOUNT,
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.REFERENCE
    ,case when BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONAMOUNT, 0) else BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONAMOUNT end [TRANSACTIONAMOUNT]
    ,case when BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(BANKACCOUNTTRANSACTIONGLDISTRIBUTION.AMOUNT, 0) else BANKACCOUNTTRANSACTIONGLDISTRIBUTION.AMOUNT end [BASEAMOUNT]
    ,case when BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID is null then nullif(BANKACCOUNTTRANSACTIONGLDISTRIBUTION.ORGANIZATIONAMOUNT, 0) else BANKACCOUNTTRANSACTIONGLDISTRIBUTION.ORGANIZATIONAMOUNT end [ORGANIZATIONAMOUNT]
    ,BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONCURRENCYID
    ,BANKACCOUNTTRANSACTIONGLDISTRIBUTION.BASECURRENCYID
    from dbo.BANKACCOUNTTRANSACTION BAT
    left outer join dbo.BANKACCOUNTADJUSTMENT A on BAT.ID = A.ID
    inner join dbo.BANKACCOUNTTRANSACTIONGLDISTRIBUTION on BANKACCOUNTTRANSACTIONGLDISTRIBUTION.BANKACCOUNTTRANSACTIONID = BAT.ID
    inner join dbo.GLTRANSACTION on GLTRANSACTION.ID = BANKACCOUNTTRANSACTIONGLDISTRIBUTION.GLTRANSACTIONID
    where 
        BAT.ID = @ID
        and GLTRANSACTION.SYSTEMDISTRIBUTION = @SYSTEMDISTRIBUTION
    order by
        BANKACCOUNTTRANSACTIONGLDISTRIBUTION.TRANSACTIONTYPE desc;