TR_REVENUEPAYMENTMETHOD_UPDATE

        CREATE trigger [dbo].[TR_REVENUEPAYMENTMETHOD_UPDATE] ON [dbo].REVENUEPAYMENTMETHOD FOR UPDATE NOT FOR REPLICATION AS
        BEGIN
          SET NOCOUNT ON
            --see if the payment method is invalid for the linked deposit - if so, raise an error


            if exists(select DEPOSITID from dbo.BANKACCOUNTDEPOSITPAYMENT inner join INSERTED ON
              INSERTED.REVENUEID=BANKACCOUNTDEPOSITPAYMENT.ID where [dbo].[UFN_BANKACCOUNTDEPOSIT_VALIDPAYMENTTYPE](DEPOSITID, INSERTED.REVENUEID)=0) 
            BEGIN
              RAISERROR ('The selected payment method is not allowed for the deposit linked to this payment.', 16, 1)
            END
        END