CREATE trigger dbo.TR_BANKACCOUNT_PDACCOUNTSYSTEMID_DEFAULT on BANKACCOUNT instead of INSERT not for replication as
begin
set nocount on;
declare @DEFAULTCURRENCY uniqueidentifier;
select @DEFAULTCURRENCY = ID from dbo.CURRENCY where ISORGANIZATIONCURRENCY = 1;
insert into BANKACCOUNT (ID,BANKID,ACCOUNTNUMBER,ROUTINGNUMBER,ACCOUNTTYPECODE,STATUSCODE,MINIMUMBALANCE,DEFAULTPRINTER,RECONCILED, DATELASTRECONCILED,RECONCILEDBALANCE,PRINTCONTACTPOSITION, LASTDEPOSITNUM, ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,ACCOUNTNAME, DEFAULTCASHACCOUNTTYPECODE, GLACCOUNTID,PDACCOUNTSEGMENTVALUEID,CLIENTNAME,USERNUMBER,SORTCODE,PDACCOUNTSYSTEMID,TRANSACTIONCURRENCYID,BANKINGSYSTEMID,BIC,BANKCODE)
select ID,BANKID,ACCOUNTNUMBER,ROUTINGNUMBER,ACCOUNTTYPECODE,STATUSCODE,MINIMUMBALANCE,DEFAULTPRINTER,RECONCILED, DATELASTRECONCILED,RECONCILEDBALANCE,PRINTCONTACTPOSITION, LASTDEPOSITNUM, ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,ACCOUNTNAME, DEFAULTCASHACCOUNTTYPECODE, GLACCOUNTID,PDACCOUNTSEGMENTVALUEID,CLIENTNAME,USERNUMBER,SORTCODE,isnull(PDACCOUNTSYSTEMID,'4B121C2C-CCE6-440D-894C-EA0DEF80D50B'),isnull(TRANSACTIONCURRENCYID,@DEFAULTCURRENCY),BANKINGSYSTEMID,BIC,BANKCODE
from inserted
end
|
Trigger Definition
