TR_JOURNALENTRY_T2BDELETE (Trigger)

        
          create trigger dbo.TR_JOURNALENTRY_T2BDELETE on dbo.JOURNALENTRY for delete not for replication
          as
          begin
          set nocount on
          --TR_REVENUEGLDISTRIBUTION_T2BDELETE

          if (select object_id('UFN_B2T_CONTEXTISSYNC')) > 0
            begin
        if dbo.UFN_B2T_CONTEXTISSYNC() = 1
          begin 
            update dbo.B2TROWS
            set SYNCSTATUSCODE = 11
            where BBECID in(select ID from DELETED)
            and BBECTABLE = 'REVENUEGLDISTRIBUTION' 
            
            update dbo.B2TROWS
            set SYNCSTATUSCODE = 11
            where BBECID in(select ID from DELETED)
            and BBECTABLE = 'GIFTFEEGLDISTRIBUTION'                        
          end
            end
          end