TR_DISBURSEMENTPROCESSFORMAT_UNIQUETYPEPERDISBURSEMENTPROCESS

                    create trigger dbo.TR_DISBURSEMENTPROCESSFORMAT_UNIQUETYPEPERDISBURSEMENTPROCESS on DISBURSEMENTPROCESSFORMAT for INSERT, UPDATE NOT FOR REPLICATION AS
                        begin
                            set nocount on;

                        if exists
                        (
                            select 
                                DISBURSEMENTFORMAT.ID
                            from INSERTED
                                inner join dbo.DISBURSEMENTPROCESSFORMAT on INSERTED.DISBURSEMENTPROCESSID = DISBURSEMENTPROCESSFORMAT.DISBURSEMENTPROCESSID
                                inner join dbo.DISBURSEMENTFORMAT on DISBURSEMENTFORMAT.ID = DISBURSEMENTPROCESSFORMAT.DISBURSEMENTFORMATID
                            where 
                                DISBURSEMENTPROCESSFORMAT.ID <> INSERTED.ID AND
                                DISBURSEMENTFORMAT.PAYMENTMETHODCODE = 
                                    (select D.PAYMENTMETHODCODE from DISBURSEMENTFORMAT D where D.ID = INSERTED.DISBURSEMENTFORMATID)
                        )

                            BEGIN
                                RAISERROR ('The format payment method must be unique per process.', 16, 1)
                                ROLLBACK
                            END

                        end