TR_BANKACCOUNT_PDACCOUNTSYSTEMID_DEFAULT

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