TR_FINANCIALTRANSACTIONLINEITEM_T2BDELETE (Trigger)

          
          CREATE trigger dbo.TR_FINANCIALTRANSACTIONLINEITEM_T2BDELETE on dbo.FINANCIALTRANSACTIONLINEITEM for delete not for replication
          as
          begin
          set nocount on
          --TR_REVENUESPLIT_T2BDELETE

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