USP_DATALIST_BANKACCOUNTDISBURSEMENT_HISTORY

Lists the history of actions taken for a specific bank account disbursement.

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

    select H.ID
        ,CASE WHEN H.CHANGEDNUMBER > 0 THEN CAST(H.CHANGEDNUMBER As nvarchar) ELSE CAST(H.ORIGINALNUMBER as nvarchar) END NUMBER
        ,H.ACTION
        ,A.USERNAME
        ,H.DATEADDED
        ,CASE H.ACTIONCODE
            WHEN 3 THEN (select TOP 1 T.FINANCIALTRANSACTIONID  from dbo.DISBURSEMENTHISTORY T 
                    where T.FUTUREFINANCIALTRANSACTIONID = H.FINANCIALTRANSACTIONID)
            WHEN 1 THEN H.FUTUREFINANCIALTRANSACTIONID
            ELSE NULL
        END [BANKACCOUNTTRANSACTIONID]
        ,H.ACTIONCODE
    from dbo.DISBURSEMENTHISTORY H
    inner join dbo.CHANGEAGENT as A on H.ADDEDBYID = A.ID
    where H.FINANCIALTRANSACTIONID = @ID
    order by H.DATEADDED