TR_REVENUEPAYMENTMETHOD_UPDATE (Trigger)

                
                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