TR_CONSTITUENTCORRESPONDENCERESPONSE_T2BDELETE (Trigger)

                
    CREATE trigger TR_CONSTITUENTCORRESPONDENCERESPONSE_T2BDELETE on dbo.CONSTITUENTCORRESPONDENCERESPONSE after delete not for replication
    as begin
      -- TAIntegration data sync

      if dbo.UFN_B2T_CONTEXTISSYNC() = 1
        update dbo.B2TROWS
        set SYNCSTATUSCODE = 11
        where BBECID in(select ID from DELETED)
        and BBECTABLE = 'CONSTITUENTCORRESPONDENCERESPONSE'
      else
        -- force re-sync of the parent row

        update dbo.B2TROWS
        set FORCEUPDATE = 1
        where BBECID in(select CONSTITUENTCORRESPONDENCEID from DELETED)
        and BBECTABLE = 'CONSTITUENTCORRESPONDENCE'
    end