TR_BANKACCOUNTDEPOSIT_ADD_DEFAULT

CREATE trigger dbo.TR_BANKACCOUNTDEPOSIT_ADD_DEFAULT on dbo.BANKACCOUNTDEPOSIT instead of INSERT not for replication as
BEGIN
  set nocount on;

  insert into dbo.BANKACCOUNTDEPOSIT
    (ID, DEFAULTPAYMENTDATE, DEFAULTPAYMENTAMOUNT, DEFAULTALLOWEDPAYMENTMETHODS, PROJECTEDNUMBEROFPAYMENTS, DEFAULTPAYMENTMETHODCODE, STATUSCODE, PROJECTEDAMOUNT, OTHERPAYMENTMETHODCODEID, CREDITTYPECODEID, TRANSACTIONCURRENCYID, TRANSACTIONEXCHANGERATEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  select i.ID, i.DEFAULTPAYMENTDATE, i.DEFAULTPAYMENTAMOUNT, i.DEFAULTALLOWEDPAYMENTMETHODS, i.PROJECTEDNUMBEROFPAYMENTS, i.DEFAULTPAYMENTMETHODCODE, i.STATUSCODE, i.PROJECTEDAMOUNT, i.OTHERPAYMENTMETHODCODEID, i.CREDITTYPECODEID, isnull(i.TRANSACTIONCURRENCYID, BA.TRANSACTIONCURRENCYID), i.TRANSACTIONEXCHANGERATEID, i.ADDEDBYID, i.CHANGEDBYID, i.DATEADDED, i.DATECHANGED
  from inserted i
  inner join dbo.BANKACCOUNTTRANSACTION_EXT EXT on EXT.ID = i.ID
  inner join dbo.BANKACCOUNT BA on BA.ID = EXT.BANKACCOUNTID
END