-- 机动车票修改为可抵扣
UPDATE T_ER_INVOICETYPE SET
    FISOFFSET='1'
 WHERE FID=1327558123443004416;

UPDATE T_ER_INVOICETYPE SET
    FUDRDISPLAY='发票日期 大于等于 2019-04-01 并且 (旅客 不为空  或者 身份证 不为空 ) 并且 地域 不等于国际 并且 (签注 不包含 退票费 并且 签注 不包含 改签费) ',
    FUSERDEFINERULE = '{"filterRow":[{"id":"3RGI16L0TRW9","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"3RGI16L0XY41","value":"2019-04-01"}],"baseDataIds":[]},{"id":"3RGI16L0TRW=","leftBracket":"(","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"3RGI16L0XY42","value":""}],"baseDataIds":[]},{"id":"3RGI16L0TRWA","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":")","logic":"0","value":[{"id":"3RGI16L0XY43","value":""}],"baseDataIds":[]},{"id":"3RGI16L0TRWB","leftBracket":"","compareType":"106","fieldName":"region","rightBracket":"","logic":"0","value":[{"id":"3RGI16L0XY44","value":"2"}],"baseDataIds":[]},{"id":"3RGI16L0TRWC","leftBracket":"(","compareType":"58","fieldName":"endorsement","rightBracket":"","logic":"0","value":[{"id":"3RGI16L0XY45","value":"退票费"}],"baseDataIds":[]},{"id":"3RGI16L0TRWD","leftBracket":"","compareType":"58","fieldName":"endorsement","rightBracket":")","logic":"0","value":[{"id":"3RGI16L0XY46","value":"改签费"}],"baseDataIds":[]}],"forList":false}',
    FJS = 'invoicedate >= ''2019-04-01'' && (passengername != '''' ||idcard != '''') && region != ''2'' && (endorsement.search(''退票费'') < 0 && endorsement.search(''改签费'') < 0) '
WHERE FID=1327557913929185280;
