TR_BANKACCOUNTDEPOSIT_ADD_DEFAULT (Trigger)

        
CREATE trigger dbo.TR_BANKACCOUNTDEPOSIT_ADD_DEFAULT on dbo.BANKACCOUNTDEPOSIT instead of INSERT not for replication as
BEGIN
  set nocount on;
  
  declare @TRANSACTIONCURRENCYID uniqueidentifier;
  select @TRANSACTIONCURRENCYID = BA.TRANSACTIONCURRENCYID from dbo.BANKACCOUNT BA;
  
  insert into dbo.BANKACCOUNTDEPOSIT
    (ID, DEFAULTPAYMENTDATE, DEFAULTPAYMENTAMOUNT, DEFAULTALLOWEDPAYMENTMETHODS, PROJECTEDNUMBEROFPAYMENTS, DEFAULTPAYMENTMETHODCODE, STATUSCODE, PROJECTEDAMOUNT, OTHERPAYMENTMETHODCODEID, CREDITTYPECODEID, TRANSACTIONCURRENCYID, TRANSACTIONEXCHANGERATEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    select ID, DEFAULTPAYMENTDATE, DEFAULTPAYMENTAMOUNT, DEFAULTALLOWEDPAYMENTMETHODS, PROJECTEDNUMBEROFPAYMENTS, DEFAULTPAYMENTMETHODCODE, STATUSCODE, PROJECTEDAMOUNT, OTHERPAYMENTMETHODCODEID, CREDITTYPECODEID, isnull(TRANSACTIONCURRENCYID, @TRANSACTIONCURRENCYID), TRANSACTIONEXCHANGERATEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
    from inserted 
END