TR_REVENUESPLITGIFTAID_D (Trigger)

                
                    create trigger [dbo].[TR_REVENUESPLITGIFTAID_D] on [dbo].[REVENUESPLITGIFTAID] 
                    after delete 
                    not for replication
                    as
                    begin
                        set nocount on;

                            update T1  set  T1.REVENUESPLITGIFTAIDID = null
                                from  dbo.FINANCIALTRANSACTIONLINEITEM L 
                                    join JOURNALENTRY J on J.FINANCIALTRANSACTIONLINEITEMID = L.ID
                                    join JOURNALENTRY_EXT T1  on J.ID = T1.ID 
                                    join deleted T2 on T1.REVENUESPLITGIFTAIDID = T2.ID 
                                where T1.TABLENAMECODE = 7 and  L.POSTSTATUSCODE != 2
            
                    end