BANKACCOUNTDEPOSITCORRECTION

CREATE view dbo.BANKACCOUNTDEPOSITCORRECTION with schemabinding 
as
 select 
  FT.ID
  ,isnull(cast(FT.[DATE] as datetime), '') as [DATE]
  ,isnull(cast(left(FT.DESCRIPTION,100) as nvarchar(100)),'') as REFERENCE
  ,BADCE.PAYMENTMETHODCODE
  ,isnull(cast(FT.BASEAMOUNT as decimal(19,4)),0) as AMOUNT
  ,isnull(FT.PARENTID, '00000000-0000-0000-0000-000000000000') as DEPOSITID  
  ,BADCE.ADDEDBYID
  ,BADCE.CHANGEDBYID
  ,BADCE.DATEADDED
  ,BADCE.DATECHANGED
  ,BADCE.TS
  ,BADCE.TSLONG
  ,isnull(cast(FT.TYPECODE - 24 + 2 * BADCE.CORRECTIONTYPECODE as tinyint),'') as CORRECTIONTYPECODE
  ,BADCE.PAYMENTMETHOD
  ,case cast(FT.TYPECODE - 24 + 2 * BADCE.CORRECTIONTYPECODE as tinyint) 
      when (0) then N'Sales - Short' 
      when (1) then N'Sales - Over' 
      when (2) then N'Treasury - Short' 
      when (3) then N'Treasury - Over' else null end as CORRECTIONTYPE
  ,FT.TRANSACTIONAMOUNT as TRANSACTIONAMOUNT
  ,FT.ORGAMOUNT ORGANIZATIONAMOUNT
  ,case CS.BASECURRENCYID
  when '00000000-0000-0000-0000-000000000000' then null
  else CS.BASECURRENCYID end as BASECURRENCYID  
  ,FT.ORGEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID
  ,FT.BASEEXCHANGERATEID
  ,cast((case when FT.TYPECODE=24 then -FT.BASEAMOUNT else FT.BASEAMOUNT end) as decimal(21,4)) SIGNEDAMOUNT
  ,(case when FT.TYPECODE=24 then -FT.TRANSACTIONAMOUNT else FT.TRANSACTIONAMOUNT end) SIGNEDTRANSACTIONAMOUNT  
  ,(case when FT.TYPECODE=24 then -FT.ORGAMOUNT else FT.ORGAMOUNT end) SIGNEDORGANIZATIONAMOUNT
 from dbo.FINANCIALTRANSACTION as FT
 inner join dbo.BANKACCOUNTDEPOSITCORRECTION_EXT as BADCE on BADCE.ID = FT.ID
 inner join dbo.PDACCOUNTSYSTEM as PAS on PAS.ID = FT.PDACCOUNTSYSTEMID
 inner join dbo.CURRENCYSET as CS on PAS.CURRENCYSETID = CS.ID
 where
  FT.TYPECODE in (24,25) -- Deposit Correction Short and Deposit Correction Over