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
|
Trigger Definition
