TR_OPPORTUNITYDESIGNATION_T2BDELETE

Trigger Definition

                
    CREATE trigger TR_OPPORTUNITYDESIGNATION_T2BDELETE on dbo.OPPORTUNITYDESIGNATION 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 = 'OPPORTUNITYDESIGNATION'

      -- intentionally leaving off UFN_B2T_CONTEXTISSYNC condition, even deletes from sync need to trigger update
	    -- force re-sync of the parent row
	    update dbo.B2TROWS
	    set FORCEUPDATE = 1
	    where BBECID in(select OPPORTUNITYID from DELETED)
	    and BBECTABLE = 'OPPORTUNITY'
		and TATABLE = 'BBEC_OPPORTUNITY'
    end