Copy Code Trigger Definition

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