USP_DISBURSEMENTSFORTRANSACTION

Returns a list of disbursements (showing information as it relates to the financial transaction not the entire disbursement) for a financial transaction.

Parameters

Parameter	Parameter Type	Mode	Description
@FINANCIALTRANSACTIONID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DISBURSEMENTSFORTRANSACTION
(
  @FINANCIALTRANSACTIONID uniqueidentifier
)
as
begin
        select
            BAT.ID                                                    as CHECKID
            ,MAX(BAT.TRANSACTIONDATE)                as CHECKDATE
            ,MAX(BAT.TRANSACTIONTYPE)                as CHECKTYPE
            ,MAX(BAT.TRANSACTIONTYPECODE)        as CHECKTYPECODE
            ,MAX(BAT.TRANSACTIONNUMBER)            as CHECKNUMBER
            ,SUM
             (
                case FTA.TYPECODE
                    when 1 then FTA.AMOUNT
                    else 0
                end
             )                                                            as CHECKDISCOUNT
            ,SUM
             (
                case FTA.TYPECODE
                    when 0 then FTA.AMOUNT
                    else 0
                end
             )                                                            as CHECKAMOUNT
             ,BAT.STATUS as STATUS
       ,BAT.DELETED
        from
            dbo.FINANCIALTRANSACTIONSCHEDULE as FTS
            inner join dbo.FINANCIALTRANSACTIONAPPLICATION AS FTA on FTS.ID = FTA.FINANCIALTRANSACTIONSCHEDULEID
            inner join dbo.FINANCIALTRANSACTION as FTD on FTA.FINANCIALTRANSACTIONID = FTD.ID
            inner join dbo.BANKACCOUNTTRANSACTION as BAT on FTD.ID = BAT.ID
        where
            FTS.FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID
        group by
            BAT.ID, BAT.STATUS, BAT.DELETED
end