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