Copy Code Trigger Definition 

        
          CREATE trigger TR_CONSTITUENTSITE_T2BDELETE on dbo.CONSTITUENTSITE 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 = 'CONSTITUENTSITE'
          end