TR_FINANCIALTRANSACTION_INSERT_UPDATE

        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 and not I.TYPECODE in (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,20,21,22,23,24,25,26,27) -- Allow BBEC records to be corrupted

              )
            raiserror ('ERR_FINANCIALTRANSACTION_INVALIDTRANSACTIONCURRENCYID',16,1);


        end