USP_DATALIST_BANKACCOUNTADJUSTMENTCATEGORY

                CREATE procedure dbo.USP_DATALIST_BANKACCOUNTADJUSTMENTCATEGORY(@ID uniqueidentifier)
                as
                    set nocount on;

                    select BAAC.ID,
                           CATEGORY,
                           ADJUSTMENTTYPE,
                           AMOUNT,
                           TRANSFERBANKACCOUNTID,
                           ISNULL((SELECT ACCOUNTNAME FROM BANKACCOUNT WHERE ID = TRANSFERBANKACCOUNTID),'') BANKACCOUNTNAME,
                           DEFAULTREFERENCE,
               TRANSACTIONCURRENCYID
                    from dbo.BANKACCOUNTADJUSTMENTCATEGORY as BAAC
            inner join dbo.BANKACCOUNT as BA on BAAC.BANKACCOUNTID = BA.ID
                    where BANKACCOUNTID = @ID