TR_REVENUESPLITGIFTFEE_D

                    CREATE trigger [dbo].[TR_REVENUESPLITGIFTFEE_D] on [dbo].[REVENUESPLITGIFTFEE] 
                    after delete 
                    not for replication
                    as
                    begin
                        set nocount on;

                            update L set L.SOURCELINEITEMID = 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.REVENUESPLITGIFTFEEID = T2.ID 
                                where T1.TABLENAMECODE = 8 and  L.POSTSTATUSCODE != 2;      

                            update T1  set  T1.REVENUESPLITGIFTFEEID = 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.REVENUESPLITGIFTFEEID = T2.ID 
                                where T1.TABLENAMECODE = 8 and  L.POSTSTATUSCODE != 2;

                    end