TR_FINANCIALTRANSACTION_INSERT_UPDATE (Trigger)

         
        CREATE trigger TR_FINANCIALTRANSACTION_INSERT_UPDATE on dbo.FINANCIALTRANSACTION for insert, update not for replication
        as begin
          -- Make sure the transaction currency is an allowed one.

          if update(TRANSACTIONCURRENCYID) and exists(
              select I.ID
              from inserted as I
              left outer join dbo.PDACCOUNTSYSTEM as PD on PD.ID = I.PDACCOUNTSYSTEMID
              left outer join dbo.CURRENCYSETTRANSACTIONCURRENCY as CSTC on CSTC.CURRENCYSETID = PD.CURRENCYSETID and CSTC.CURRENCYID = I.TRANSACTIONCURRENCYID
              where CSTC.ID is null
              )
            raiserror ('ERR_FINANCIALTRANSACTION_INVALIDTRANSACTIONCURRENCYID',16,1);
        end