package pwc.taxtech.atms.vat.entity;

import java.util.ArrayList;
import java.util.List;

public class InputMaterialItemExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public InputMaterialItemExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIDIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIDIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIDEqualTo(String value) {
            addCriterion("ID =", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotEqualTo(String value) {
            addCriterion("ID <>", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDGreaterThan(String value) {
            addCriterion("ID >", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDLessThan(String value) {
            addCriterion("ID <", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDLike(String value) {
            addCriterion("ID like", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotLike(String value) {
            addCriterion("ID not like", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDIn(List<String> values) {
            addCriterion("ID in", values, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotIn(List<String> values) {
            addCriterion("ID not in", values, "ID");
            return (Criteria) this;
        }

        public Criteria andIDBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "ID");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSIsNull() {
            addCriterion("ITEM_DESC_ZHS is null");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSIsNotNull() {
            addCriterion("ITEM_DESC_ZHS is not null");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSEqualTo(String value) {
            addCriterion("ITEM_DESC_ZHS =", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSNotEqualTo(String value) {
            addCriterion("ITEM_DESC_ZHS <>", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSGreaterThan(String value) {
            addCriterion("ITEM_DESC_ZHS >", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_DESC_ZHS >=", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSLessThan(String value) {
            addCriterion("ITEM_DESC_ZHS <", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSLessThanOrEqualTo(String value) {
            addCriterion("ITEM_DESC_ZHS <=", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSLike(String value) {
            addCriterion("ITEM_DESC_ZHS like", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSNotLike(String value) {
            addCriterion("ITEM_DESC_ZHS not like", value, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSIn(List<String> values) {
            addCriterion("ITEM_DESC_ZHS in", values, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSNotIn(List<String> values) {
            addCriterion("ITEM_DESC_ZHS not in", values, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSBetween(String value1, String value2) {
            addCriterion("ITEM_DESC_ZHS between", value1, value2, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_ZHSNotBetween(String value1, String value2) {
            addCriterion("ITEM_DESC_ZHS not between", value1, value2, "ITEM_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERIsNull() {
            addCriterion("ITEM_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERIsNotNull() {
            addCriterion("ITEM_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBEREqualTo(String value) {
            addCriterion("ITEM_NUMBER =", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERNotEqualTo(String value) {
            addCriterion("ITEM_NUMBER <>", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERGreaterThan(String value) {
            addCriterion("ITEM_NUMBER >", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_NUMBER >=", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERLessThan(String value) {
            addCriterion("ITEM_NUMBER <", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERLessThanOrEqualTo(String value) {
            addCriterion("ITEM_NUMBER <=", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERLike(String value) {
            addCriterion("ITEM_NUMBER like", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERNotLike(String value) {
            addCriterion("ITEM_NUMBER not like", value, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERIn(List<String> values) {
            addCriterion("ITEM_NUMBER in", values, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERNotIn(List<String> values) {
            addCriterion("ITEM_NUMBER not in", values, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERBetween(String value1, String value2) {
            addCriterion("ITEM_NUMBER between", value1, value2, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andITEM_NUMBERNotBetween(String value1, String value2) {
            addCriterion("ITEM_NUMBER not between", value1, value2, "ITEM_NUMBER");
            return (Criteria) this;
        }

        public Criteria andSPSMIsNull() {
            addCriterion("SPSM is null");
            return (Criteria) this;
        }

        public Criteria andSPSMIsNotNull() {
            addCriterion("SPSM is not null");
            return (Criteria) this;
        }

        public Criteria andSPSMEqualTo(String value) {
            addCriterion("SPSM =", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMNotEqualTo(String value) {
            addCriterion("SPSM <>", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMGreaterThan(String value) {
            addCriterion("SPSM >", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMGreaterThanOrEqualTo(String value) {
            addCriterion("SPSM >=", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMLessThan(String value) {
            addCriterion("SPSM <", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMLessThanOrEqualTo(String value) {
            addCriterion("SPSM <=", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMLike(String value) {
            addCriterion("SPSM like", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMNotLike(String value) {
            addCriterion("SPSM not like", value, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMIn(List<String> values) {
            addCriterion("SPSM in", values, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMNotIn(List<String> values) {
            addCriterion("SPSM not in", values, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMBetween(String value1, String value2) {
            addCriterion("SPSM between", value1, value2, "SPSM");
            return (Criteria) this;
        }

        public Criteria andSPSMNotBetween(String value1, String value2) {
            addCriterion("SPSM not between", value1, value2, "SPSM");
            return (Criteria) this;
        }

        public Criteria andJMIsNull() {
            addCriterion("JM is null");
            return (Criteria) this;
        }

        public Criteria andJMIsNotNull() {
            addCriterion("JM is not null");
            return (Criteria) this;
        }

        public Criteria andJMEqualTo(String value) {
            addCriterion("JM =", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMNotEqualTo(String value) {
            addCriterion("JM <>", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMGreaterThan(String value) {
            addCriterion("JM >", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMGreaterThanOrEqualTo(String value) {
            addCriterion("JM >=", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMLessThan(String value) {
            addCriterion("JM <", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMLessThanOrEqualTo(String value) {
            addCriterion("JM <=", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMLike(String value) {
            addCriterion("JM like", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMNotLike(String value) {
            addCriterion("JM not like", value, "JM");
            return (Criteria) this;
        }

        public Criteria andJMIn(List<String> values) {
            addCriterion("JM in", values, "JM");
            return (Criteria) this;
        }

        public Criteria andJMNotIn(List<String> values) {
            addCriterion("JM not in", values, "JM");
            return (Criteria) this;
        }

        public Criteria andJMBetween(String value1, String value2) {
            addCriterion("JM between", value1, value2, "JM");
            return (Criteria) this;
        }

        public Criteria andJMNotBetween(String value1, String value2) {
            addCriterion("JM not between", value1, value2, "JM");
            return (Criteria) this;
        }

        public Criteria andSLIsNull() {
            addCriterion("SL is null");
            return (Criteria) this;
        }

        public Criteria andSLIsNotNull() {
            addCriterion("SL is not null");
            return (Criteria) this;
        }

        public Criteria andSLEqualTo(String value) {
            addCriterion("SL =", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLNotEqualTo(String value) {
            addCriterion("SL <>", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLGreaterThan(String value) {
            addCriterion("SL >", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLGreaterThanOrEqualTo(String value) {
            addCriterion("SL >=", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLLessThan(String value) {
            addCriterion("SL <", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLLessThanOrEqualTo(String value) {
            addCriterion("SL <=", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLLike(String value) {
            addCriterion("SL like", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLNotLike(String value) {
            addCriterion("SL not like", value, "SL");
            return (Criteria) this;
        }

        public Criteria andSLIn(List<String> values) {
            addCriterion("SL in", values, "SL");
            return (Criteria) this;
        }

        public Criteria andSLNotIn(List<String> values) {
            addCriterion("SL not in", values, "SL");
            return (Criteria) this;
        }

        public Criteria andSLBetween(String value1, String value2) {
            addCriterion("SL between", value1, value2, "SL");
            return (Criteria) this;
        }

        public Criteria andSLNotBetween(String value1, String value2) {
            addCriterion("SL not between", value1, value2, "SL");
            return (Criteria) this;
        }

        public Criteria andGGXHIsNull() {
            addCriterion("GGXH is null");
            return (Criteria) this;
        }

        public Criteria andGGXHIsNotNull() {
            addCriterion("GGXH is not null");
            return (Criteria) this;
        }

        public Criteria andGGXHEqualTo(String value) {
            addCriterion("GGXH =", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHNotEqualTo(String value) {
            addCriterion("GGXH <>", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHGreaterThan(String value) {
            addCriterion("GGXH >", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHGreaterThanOrEqualTo(String value) {
            addCriterion("GGXH >=", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHLessThan(String value) {
            addCriterion("GGXH <", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHLessThanOrEqualTo(String value) {
            addCriterion("GGXH <=", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHLike(String value) {
            addCriterion("GGXH like", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHNotLike(String value) {
            addCriterion("GGXH not like", value, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHIn(List<String> values) {
            addCriterion("GGXH in", values, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHNotIn(List<String> values) {
            addCriterion("GGXH not in", values, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHBetween(String value1, String value2) {
            addCriterion("GGXH between", value1, value2, "GGXH");
            return (Criteria) this;
        }

        public Criteria andGGXHNotBetween(String value1, String value2) {
            addCriterion("GGXH not between", value1, value2, "GGXH");
            return (Criteria) this;
        }

        public Criteria andDJIsNull() {
            addCriterion("DJ is null");
            return (Criteria) this;
        }

        public Criteria andDJIsNotNull() {
            addCriterion("DJ is not null");
            return (Criteria) this;
        }

        public Criteria andDJEqualTo(String value) {
            addCriterion("DJ =", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJNotEqualTo(String value) {
            addCriterion("DJ <>", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJGreaterThan(String value) {
            addCriterion("DJ >", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJGreaterThanOrEqualTo(String value) {
            addCriterion("DJ >=", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJLessThan(String value) {
            addCriterion("DJ <", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJLessThanOrEqualTo(String value) {
            addCriterion("DJ <=", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJLike(String value) {
            addCriterion("DJ like", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJNotLike(String value) {
            addCriterion("DJ not like", value, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJIn(List<String> values) {
            addCriterion("DJ in", values, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJNotIn(List<String> values) {
            addCriterion("DJ not in", values, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJBetween(String value1, String value2) {
            addCriterion("DJ between", value1, value2, "DJ");
            return (Criteria) this;
        }

        public Criteria andDJNotBetween(String value1, String value2) {
            addCriterion("DJ not between", value1, value2, "DJ");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASUREIsNull() {
            addCriterion("PRIMARY_UNIT_OF_MEASURE is null");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASUREIsNotNull() {
            addCriterion("PRIMARY_UNIT_OF_MEASURE is not null");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASUREEqualTo(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE =", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASURENotEqualTo(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE <>", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASUREGreaterThan(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE >", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASUREGreaterThanOrEqualTo(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE >=", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASURELessThan(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE <", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASURELessThanOrEqualTo(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE <=", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASURELike(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE like", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASURENotLike(String value) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE not like", value, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASUREIn(List<String> values) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE in", values, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASURENotIn(List<String> values) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE not in", values, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASUREBetween(String value1, String value2) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE between", value1, value2, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andPRIMARY_UNIT_OF_MEASURENotBetween(String value1, String value2) {
            addCriterion("PRIMARY_UNIT_OF_MEASURE not between", value1, value2, "PRIMARY_UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andSFHSIsNull() {
            addCriterion("SFHS is null");
            return (Criteria) this;
        }

        public Criteria andSFHSIsNotNull() {
            addCriterion("SFHS is not null");
            return (Criteria) this;
        }

        public Criteria andSFHSEqualTo(String value) {
            addCriterion("SFHS =", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSNotEqualTo(String value) {
            addCriterion("SFHS <>", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSGreaterThan(String value) {
            addCriterion("SFHS >", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSGreaterThanOrEqualTo(String value) {
            addCriterion("SFHS >=", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSLessThan(String value) {
            addCriterion("SFHS <", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSLessThanOrEqualTo(String value) {
            addCriterion("SFHS <=", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSLike(String value) {
            addCriterion("SFHS like", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSNotLike(String value) {
            addCriterion("SFHS not like", value, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSIn(List<String> values) {
            addCriterion("SFHS in", values, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSNotIn(List<String> values) {
            addCriterion("SFHS not in", values, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSBetween(String value1, String value2) {
            addCriterion("SFHS between", value1, value2, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSFHSNotBetween(String value1, String value2) {
            addCriterion("SFHS not between", value1, value2, "SFHS");
            return (Criteria) this;
        }

        public Criteria andSSFLMCIsNull() {
            addCriterion("SSFLMC is null");
            return (Criteria) this;
        }

        public Criteria andSSFLMCIsNotNull() {
            addCriterion("SSFLMC is not null");
            return (Criteria) this;
        }

        public Criteria andSSFLMCEqualTo(String value) {
            addCriterion("SSFLMC =", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCNotEqualTo(String value) {
            addCriterion("SSFLMC <>", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCGreaterThan(String value) {
            addCriterion("SSFLMC >", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCGreaterThanOrEqualTo(String value) {
            addCriterion("SSFLMC >=", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCLessThan(String value) {
            addCriterion("SSFLMC <", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCLessThanOrEqualTo(String value) {
            addCriterion("SSFLMC <=", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCLike(String value) {
            addCriterion("SSFLMC like", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCNotLike(String value) {
            addCriterion("SSFLMC not like", value, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCIn(List<String> values) {
            addCriterion("SSFLMC in", values, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCNotIn(List<String> values) {
            addCriterion("SSFLMC not in", values, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCBetween(String value1, String value2) {
            addCriterion("SSFLMC between", value1, value2, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSSFLMCNotBetween(String value1, String value2) {
            addCriterion("SSFLMC not between", value1, value2, "SSFLMC");
            return (Criteria) this;
        }

        public Criteria andSFLSLIsNull() {
            addCriterion("SFLSL is null");
            return (Criteria) this;
        }

        public Criteria andSFLSLIsNotNull() {
            addCriterion("SFLSL is not null");
            return (Criteria) this;
        }

        public Criteria andSFLSLEqualTo(String value) {
            addCriterion("SFLSL =", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLNotEqualTo(String value) {
            addCriterion("SFLSL <>", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLGreaterThan(String value) {
            addCriterion("SFLSL >", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLGreaterThanOrEqualTo(String value) {
            addCriterion("SFLSL >=", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLLessThan(String value) {
            addCriterion("SFLSL <", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLLessThanOrEqualTo(String value) {
            addCriterion("SFLSL <=", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLLike(String value) {
            addCriterion("SFLSL like", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLNotLike(String value) {
            addCriterion("SFLSL not like", value, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLIn(List<String> values) {
            addCriterion("SFLSL in", values, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLNotIn(List<String> values) {
            addCriterion("SFLSL not in", values, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLBetween(String value1, String value2) {
            addCriterion("SFLSL between", value1, value2, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSFLSLNotBetween(String value1, String value2) {
            addCriterion("SFLSL not between", value1, value2, "SFLSL");
            return (Criteria) this;
        }

        public Criteria andSSFLBMIsNull() {
            addCriterion("SSFLBM is null");
            return (Criteria) this;
        }

        public Criteria andSSFLBMIsNotNull() {
            addCriterion("SSFLBM is not null");
            return (Criteria) this;
        }

        public Criteria andSSFLBMEqualTo(String value) {
            addCriterion("SSFLBM =", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMNotEqualTo(String value) {
            addCriterion("SSFLBM <>", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMGreaterThan(String value) {
            addCriterion("SSFLBM >", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMGreaterThanOrEqualTo(String value) {
            addCriterion("SSFLBM >=", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMLessThan(String value) {
            addCriterion("SSFLBM <", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMLessThanOrEqualTo(String value) {
            addCriterion("SSFLBM <=", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMLike(String value) {
            addCriterion("SSFLBM like", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMNotLike(String value) {
            addCriterion("SSFLBM not like", value, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMIn(List<String> values) {
            addCriterion("SSFLBM in", values, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMNotIn(List<String> values) {
            addCriterion("SSFLBM not in", values, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMBetween(String value1, String value2) {
            addCriterion("SSFLBM between", value1, value2, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andSSFLBMNotBetween(String value1, String value2) {
            addCriterion("SSFLBM not between", value1, value2, "SSFLBM");
            return (Criteria) this;
        }

        public Criteria andMSLXIsNull() {
            addCriterion("MSLX is null");
            return (Criteria) this;
        }

        public Criteria andMSLXIsNotNull() {
            addCriterion("MSLX is not null");
            return (Criteria) this;
        }

        public Criteria andMSLXEqualTo(String value) {
            addCriterion("MSLX =", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXNotEqualTo(String value) {
            addCriterion("MSLX <>", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXGreaterThan(String value) {
            addCriterion("MSLX >", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXGreaterThanOrEqualTo(String value) {
            addCriterion("MSLX >=", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXLessThan(String value) {
            addCriterion("MSLX <", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXLessThanOrEqualTo(String value) {
            addCriterion("MSLX <=", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXLike(String value) {
            addCriterion("MSLX like", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXNotLike(String value) {
            addCriterion("MSLX not like", value, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXIn(List<String> values) {
            addCriterion("MSLX in", values, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXNotIn(List<String> values) {
            addCriterion("MSLX not in", values, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXBetween(String value1, String value2) {
            addCriterion("MSLX between", value1, value2, "MSLX");
            return (Criteria) this;
        }

        public Criteria andMSLXNotBetween(String value1, String value2) {
            addCriterion("MSLX not between", value1, value2, "MSLX");
            return (Criteria) this;
        }

        public Criteria andSFXSYHIsNull() {
            addCriterion("SFXSYH is null");
            return (Criteria) this;
        }

        public Criteria andSFXSYHIsNotNull() {
            addCriterion("SFXSYH is not null");
            return (Criteria) this;
        }

        public Criteria andSFXSYHEqualTo(String value) {
            addCriterion("SFXSYH =", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHNotEqualTo(String value) {
            addCriterion("SFXSYH <>", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHGreaterThan(String value) {
            addCriterion("SFXSYH >", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHGreaterThanOrEqualTo(String value) {
            addCriterion("SFXSYH >=", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHLessThan(String value) {
            addCriterion("SFXSYH <", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHLessThanOrEqualTo(String value) {
            addCriterion("SFXSYH <=", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHLike(String value) {
            addCriterion("SFXSYH like", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHNotLike(String value) {
            addCriterion("SFXSYH not like", value, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHIn(List<String> values) {
            addCriterion("SFXSYH in", values, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHNotIn(List<String> values) {
            addCriterion("SFXSYH not in", values, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHBetween(String value1, String value2) {
            addCriterion("SFXSYH between", value1, value2, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andSFXSYHNotBetween(String value1, String value2) {
            addCriterion("SFXSYH not between", value1, value2, "SFXSYH");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMIsNull() {
            addCriterion("YHZCLXDM is null");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMIsNotNull() {
            addCriterion("YHZCLXDM is not null");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMEqualTo(String value) {
            addCriterion("YHZCLXDM =", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMNotEqualTo(String value) {
            addCriterion("YHZCLXDM <>", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMGreaterThan(String value) {
            addCriterion("YHZCLXDM >", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMGreaterThanOrEqualTo(String value) {
            addCriterion("YHZCLXDM >=", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMLessThan(String value) {
            addCriterion("YHZCLXDM <", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMLessThanOrEqualTo(String value) {
            addCriterion("YHZCLXDM <=", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMLike(String value) {
            addCriterion("YHZCLXDM like", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMNotLike(String value) {
            addCriterion("YHZCLXDM not like", value, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMIn(List<String> values) {
            addCriterion("YHZCLXDM in", values, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMNotIn(List<String> values) {
            addCriterion("YHZCLXDM not in", values, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMBetween(String value1, String value2) {
            addCriterion("YHZCLXDM between", value1, value2, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andYHZCLXDMNotBetween(String value1, String value2) {
            addCriterion("YHZCLXDM not between", value1, value2, "YHZCLXDM");
            return (Criteria) this;
        }

        public Criteria andLRSJIsNull() {
            addCriterion("LRSJ is null");
            return (Criteria) this;
        }

        public Criteria andLRSJIsNotNull() {
            addCriterion("LRSJ is not null");
            return (Criteria) this;
        }

        public Criteria andLRSJEqualTo(String value) {
            addCriterion("LRSJ =", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJNotEqualTo(String value) {
            addCriterion("LRSJ <>", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJGreaterThan(String value) {
            addCriterion("LRSJ >", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJGreaterThanOrEqualTo(String value) {
            addCriterion("LRSJ >=", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJLessThan(String value) {
            addCriterion("LRSJ <", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJLessThanOrEqualTo(String value) {
            addCriterion("LRSJ <=", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJLike(String value) {
            addCriterion("LRSJ like", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJNotLike(String value) {
            addCriterion("LRSJ not like", value, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJIn(List<String> values) {
            addCriterion("LRSJ in", values, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJNotIn(List<String> values) {
            addCriterion("LRSJ not in", values, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJBetween(String value1, String value2) {
            addCriterion("LRSJ between", value1, value2, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andLRSJNotBetween(String value1, String value2) {
            addCriterion("LRSJ not between", value1, value2, "LRSJ");
            return (Criteria) this;
        }

        public Criteria andYXBJIsNull() {
            addCriterion("YXBJ is null");
            return (Criteria) this;
        }

        public Criteria andYXBJIsNotNull() {
            addCriterion("YXBJ is not null");
            return (Criteria) this;
        }

        public Criteria andYXBJEqualTo(String value) {
            addCriterion("YXBJ =", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJNotEqualTo(String value) {
            addCriterion("YXBJ <>", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJGreaterThan(String value) {
            addCriterion("YXBJ >", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJGreaterThanOrEqualTo(String value) {
            addCriterion("YXBJ >=", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJLessThan(String value) {
            addCriterion("YXBJ <", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJLessThanOrEqualTo(String value) {
            addCriterion("YXBJ <=", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJLike(String value) {
            addCriterion("YXBJ like", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJNotLike(String value) {
            addCriterion("YXBJ not like", value, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJIn(List<String> values) {
            addCriterion("YXBJ in", values, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJNotIn(List<String> values) {
            addCriterion("YXBJ not in", values, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJBetween(String value1, String value2) {
            addCriterion("YXBJ between", value1, value2, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andYXBJNotBetween(String value1, String value2) {
            addCriterion("YXBJ not between", value1, value2, "YXBJ");
            return (Criteria) this;
        }

        public Criteria andITEM_IDIsNull() {
            addCriterion("ITEM_ID is null");
            return (Criteria) this;
        }

        public Criteria andITEM_IDIsNotNull() {
            addCriterion("ITEM_ID is not null");
            return (Criteria) this;
        }

        public Criteria andITEM_IDEqualTo(String value) {
            addCriterion("ITEM_ID =", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDNotEqualTo(String value) {
            addCriterion("ITEM_ID <>", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDGreaterThan(String value) {
            addCriterion("ITEM_ID >", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_ID >=", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDLessThan(String value) {
            addCriterion("ITEM_ID <", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDLessThanOrEqualTo(String value) {
            addCriterion("ITEM_ID <=", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDLike(String value) {
            addCriterion("ITEM_ID like", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDNotLike(String value) {
            addCriterion("ITEM_ID not like", value, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDIn(List<String> values) {
            addCriterion("ITEM_ID in", values, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDNotIn(List<String> values) {
            addCriterion("ITEM_ID not in", values, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDBetween(String value1, String value2) {
            addCriterion("ITEM_ID between", value1, value2, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andITEM_IDNotBetween(String value1, String value2) {
            addCriterion("ITEM_ID not between", value1, value2, "ITEM_ID");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSIsNull() {
            addCriterion("SET_VALUE_DESC_ZHS is null");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSIsNotNull() {
            addCriterion("SET_VALUE_DESC_ZHS is not null");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSEqualTo(String value) {
            addCriterion("SET_VALUE_DESC_ZHS =", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSNotEqualTo(String value) {
            addCriterion("SET_VALUE_DESC_ZHS <>", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSGreaterThan(String value) {
            addCriterion("SET_VALUE_DESC_ZHS >", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSGreaterThanOrEqualTo(String value) {
            addCriterion("SET_VALUE_DESC_ZHS >=", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSLessThan(String value) {
            addCriterion("SET_VALUE_DESC_ZHS <", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSLessThanOrEqualTo(String value) {
            addCriterion("SET_VALUE_DESC_ZHS <=", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSLike(String value) {
            addCriterion("SET_VALUE_DESC_ZHS like", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSNotLike(String value) {
            addCriterion("SET_VALUE_DESC_ZHS not like", value, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSIn(List<String> values) {
            addCriterion("SET_VALUE_DESC_ZHS in", values, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSNotIn(List<String> values) {
            addCriterion("SET_VALUE_DESC_ZHS not in", values, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSBetween(String value1, String value2) {
            addCriterion("SET_VALUE_DESC_ZHS between", value1, value2, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andSET_VALUE_DESC_ZHSNotBetween(String value1, String value2) {
            addCriterion("SET_VALUE_DESC_ZHS not between", value1, value2, "SET_VALUE_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andNSRSBHIsNull() {
            addCriterion("NSRSBH is null");
            return (Criteria) this;
        }

        public Criteria andNSRSBHIsNotNull() {
            addCriterion("NSRSBH is not null");
            return (Criteria) this;
        }

        public Criteria andNSRSBHEqualTo(String value) {
            addCriterion("NSRSBH =", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHNotEqualTo(String value) {
            addCriterion("NSRSBH <>", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHGreaterThan(String value) {
            addCriterion("NSRSBH >", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHGreaterThanOrEqualTo(String value) {
            addCriterion("NSRSBH >=", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHLessThan(String value) {
            addCriterion("NSRSBH <", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHLessThanOrEqualTo(String value) {
            addCriterion("NSRSBH <=", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHLike(String value) {
            addCriterion("NSRSBH like", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHNotLike(String value) {
            addCriterion("NSRSBH not like", value, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHIn(List<String> values) {
            addCriterion("NSRSBH in", values, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHNotIn(List<String> values) {
            addCriterion("NSRSBH not in", values, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHBetween(String value1, String value2) {
            addCriterion("NSRSBH between", value1, value2, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andNSRSBHNotBetween(String value1, String value2) {
            addCriterion("NSRSBH not between", value1, value2, "NSRSBH");
            return (Criteria) this;
        }

        public Criteria andLRRIsNull() {
            addCriterion("LRR is null");
            return (Criteria) this;
        }

        public Criteria andLRRIsNotNull() {
            addCriterion("LRR is not null");
            return (Criteria) this;
        }

        public Criteria andLRREqualTo(String value) {
            addCriterion("LRR =", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRNotEqualTo(String value) {
            addCriterion("LRR <>", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRGreaterThan(String value) {
            addCriterion("LRR >", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRGreaterThanOrEqualTo(String value) {
            addCriterion("LRR >=", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRLessThan(String value) {
            addCriterion("LRR <", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRLessThanOrEqualTo(String value) {
            addCriterion("LRR <=", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRLike(String value) {
            addCriterion("LRR like", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRNotLike(String value) {
            addCriterion("LRR not like", value, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRIn(List<String> values) {
            addCriterion("LRR in", values, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRNotIn(List<String> values) {
            addCriterion("LRR not in", values, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRBetween(String value1, String value2) {
            addCriterion("LRR between", value1, value2, "LRR");
            return (Criteria) this;
        }

        public Criteria andLRRNotBetween(String value1, String value2) {
            addCriterion("LRR not between", value1, value2, "LRR");
            return (Criteria) this;
        }

        public Criteria andXGRIsNull() {
            addCriterion("XGR is null");
            return (Criteria) this;
        }

        public Criteria andXGRIsNotNull() {
            addCriterion("XGR is not null");
            return (Criteria) this;
        }

        public Criteria andXGREqualTo(String value) {
            addCriterion("XGR =", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRNotEqualTo(String value) {
            addCriterion("XGR <>", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRGreaterThan(String value) {
            addCriterion("XGR >", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRGreaterThanOrEqualTo(String value) {
            addCriterion("XGR >=", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRLessThan(String value) {
            addCriterion("XGR <", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRLessThanOrEqualTo(String value) {
            addCriterion("XGR <=", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRLike(String value) {
            addCriterion("XGR like", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRNotLike(String value) {
            addCriterion("XGR not like", value, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRIn(List<String> values) {
            addCriterion("XGR in", values, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRNotIn(List<String> values) {
            addCriterion("XGR not in", values, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRBetween(String value1, String value2) {
            addCriterion("XGR between", value1, value2, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGRNotBetween(String value1, String value2) {
            addCriterion("XGR not between", value1, value2, "XGR");
            return (Criteria) this;
        }

        public Criteria andXGSJIsNull() {
            addCriterion("XGSJ is null");
            return (Criteria) this;
        }

        public Criteria andXGSJIsNotNull() {
            addCriterion("XGSJ is not null");
            return (Criteria) this;
        }

        public Criteria andXGSJEqualTo(String value) {
            addCriterion("XGSJ =", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJNotEqualTo(String value) {
            addCriterion("XGSJ <>", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJGreaterThan(String value) {
            addCriterion("XGSJ >", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJGreaterThanOrEqualTo(String value) {
            addCriterion("XGSJ >=", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJLessThan(String value) {
            addCriterion("XGSJ <", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJLessThanOrEqualTo(String value) {
            addCriterion("XGSJ <=", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJLike(String value) {
            addCriterion("XGSJ like", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJNotLike(String value) {
            addCriterion("XGSJ not like", value, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJIn(List<String> values) {
            addCriterion("XGSJ in", values, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJNotIn(List<String> values) {
            addCriterion("XGSJ not in", values, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJBetween(String value1, String value2) {
            addCriterion("XGSJ between", value1, value2, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andXGSJNotBetween(String value1, String value2) {
            addCriterion("XGSJ not between", value1, value2, "XGSJ");
            return (Criteria) this;
        }

        public Criteria andSSJGIsNull() {
            addCriterion("SSJG is null");
            return (Criteria) this;
        }

        public Criteria andSSJGIsNotNull() {
            addCriterion("SSJG is not null");
            return (Criteria) this;
        }

        public Criteria andSSJGEqualTo(String value) {
            addCriterion("SSJG =", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGNotEqualTo(String value) {
            addCriterion("SSJG <>", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGGreaterThan(String value) {
            addCriterion("SSJG >", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGGreaterThanOrEqualTo(String value) {
            addCriterion("SSJG >=", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGLessThan(String value) {
            addCriterion("SSJG <", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGLessThanOrEqualTo(String value) {
            addCriterion("SSJG <=", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGLike(String value) {
            addCriterion("SSJG like", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGNotLike(String value) {
            addCriterion("SSJG not like", value, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGIn(List<String> values) {
            addCriterion("SSJG in", values, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGNotIn(List<String> values) {
            addCriterion("SSJG not in", values, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGBetween(String value1, String value2) {
            addCriterion("SSJG between", value1, value2, "SSJG");
            return (Criteria) this;
        }

        public Criteria andSSJGNotBetween(String value1, String value2) {
            addCriterion("SSJG not between", value1, value2, "SSJG");
            return (Criteria) this;
        }

        public Criteria andKPMCIsNull() {
            addCriterion("KPMC is null");
            return (Criteria) this;
        }

        public Criteria andKPMCIsNotNull() {
            addCriterion("KPMC is not null");
            return (Criteria) this;
        }

        public Criteria andKPMCEqualTo(String value) {
            addCriterion("KPMC =", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCNotEqualTo(String value) {
            addCriterion("KPMC <>", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCGreaterThan(String value) {
            addCriterion("KPMC >", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCGreaterThanOrEqualTo(String value) {
            addCriterion("KPMC >=", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCLessThan(String value) {
            addCriterion("KPMC <", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCLessThanOrEqualTo(String value) {
            addCriterion("KPMC <=", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCLike(String value) {
            addCriterion("KPMC like", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCNotLike(String value) {
            addCriterion("KPMC not like", value, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCIn(List<String> values) {
            addCriterion("KPMC in", values, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCNotIn(List<String> values) {
            addCriterion("KPMC not in", values, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCBetween(String value1, String value2) {
            addCriterion("KPMC between", value1, value2, "KPMC");
            return (Criteria) this;
        }

        public Criteria andKPMCNotBetween(String value1, String value2) {
            addCriterion("KPMC not between", value1, value2, "KPMC");
            return (Criteria) this;
        }

        public Criteria andSFXNWLIsNull() {
            addCriterion("SFXNWL is null");
            return (Criteria) this;
        }

        public Criteria andSFXNWLIsNotNull() {
            addCriterion("SFXNWL is not null");
            return (Criteria) this;
        }

        public Criteria andSFXNWLEqualTo(String value) {
            addCriterion("SFXNWL =", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLNotEqualTo(String value) {
            addCriterion("SFXNWL <>", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLGreaterThan(String value) {
            addCriterion("SFXNWL >", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLGreaterThanOrEqualTo(String value) {
            addCriterion("SFXNWL >=", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLLessThan(String value) {
            addCriterion("SFXNWL <", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLLessThanOrEqualTo(String value) {
            addCriterion("SFXNWL <=", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLLike(String value) {
            addCriterion("SFXNWL like", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLNotLike(String value) {
            addCriterion("SFXNWL not like", value, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLIn(List<String> values) {
            addCriterion("SFXNWL in", values, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLNotIn(List<String> values) {
            addCriterion("SFXNWL not in", values, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLBetween(String value1, String value2) {
            addCriterion("SFXNWL between", value1, value2, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSFXNWLNotBetween(String value1, String value2) {
            addCriterion("SFXNWL not between", value1, value2, "SFXNWL");
            return (Criteria) this;
        }

        public Criteria andSETVALUEIsNull() {
            addCriterion("SETVALUE is null");
            return (Criteria) this;
        }

        public Criteria andSETVALUEIsNotNull() {
            addCriterion("SETVALUE is not null");
            return (Criteria) this;
        }

        public Criteria andSETVALUEEqualTo(String value) {
            addCriterion("SETVALUE =", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUENotEqualTo(String value) {
            addCriterion("SETVALUE <>", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUEGreaterThan(String value) {
            addCriterion("SETVALUE >", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUEGreaterThanOrEqualTo(String value) {
            addCriterion("SETVALUE >=", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUELessThan(String value) {
            addCriterion("SETVALUE <", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUELessThanOrEqualTo(String value) {
            addCriterion("SETVALUE <=", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUELike(String value) {
            addCriterion("SETVALUE like", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUENotLike(String value) {
            addCriterion("SETVALUE not like", value, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUEIn(List<String> values) {
            addCriterion("SETVALUE in", values, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUENotIn(List<String> values) {
            addCriterion("SETVALUE not in", values, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUEBetween(String value1, String value2) {
            addCriterion("SETVALUE between", value1, value2, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andSETVALUENotBetween(String value1, String value2) {
            addCriterion("SETVALUE not between", value1, value2, "SETVALUE");
            return (Criteria) this;
        }

        public Criteria andORG_CODEIsNull() {
            addCriterion("ORG_CODE is null");
            return (Criteria) this;
        }

        public Criteria andORG_CODEIsNotNull() {
            addCriterion("ORG_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andORG_CODEEqualTo(String value) {
            addCriterion("ORG_CODE =", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODENotEqualTo(String value) {
            addCriterion("ORG_CODE <>", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODEGreaterThan(String value) {
            addCriterion("ORG_CODE >", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODEGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CODE >=", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODELessThan(String value) {
            addCriterion("ORG_CODE <", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODELessThanOrEqualTo(String value) {
            addCriterion("ORG_CODE <=", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODELike(String value) {
            addCriterion("ORG_CODE like", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODENotLike(String value) {
            addCriterion("ORG_CODE not like", value, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODEIn(List<String> values) {
            addCriterion("ORG_CODE in", values, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODENotIn(List<String> values) {
            addCriterion("ORG_CODE not in", values, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODEBetween(String value1, String value2) {
            addCriterion("ORG_CODE between", value1, value2, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andORG_CODENotBetween(String value1, String value2) {
            addCriterion("ORG_CODE not between", value1, value2, "ORG_CODE");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USIsNull() {
            addCriterion("ITEM_DESC_US is null");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USIsNotNull() {
            addCriterion("ITEM_DESC_US is not null");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USEqualTo(String value) {
            addCriterion("ITEM_DESC_US =", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USNotEqualTo(String value) {
            addCriterion("ITEM_DESC_US <>", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USGreaterThan(String value) {
            addCriterion("ITEM_DESC_US >", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_DESC_US >=", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USLessThan(String value) {
            addCriterion("ITEM_DESC_US <", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USLessThanOrEqualTo(String value) {
            addCriterion("ITEM_DESC_US <=", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USLike(String value) {
            addCriterion("ITEM_DESC_US like", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USNotLike(String value) {
            addCriterion("ITEM_DESC_US not like", value, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USIn(List<String> values) {
            addCriterion("ITEM_DESC_US in", values, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USNotIn(List<String> values) {
            addCriterion("ITEM_DESC_US not in", values, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USBetween(String value1, String value2) {
            addCriterion("ITEM_DESC_US between", value1, value2, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_DESC_USNotBetween(String value1, String value2) {
            addCriterion("ITEM_DESC_US not between", value1, value2, "ITEM_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSIsNull() {
            addCriterion("ITEM_LONG_DESC_ZHS is null");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSIsNotNull() {
            addCriterion("ITEM_LONG_DESC_ZHS is not null");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS =", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSNotEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS <>", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSGreaterThan(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS >", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS >=", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSLessThan(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS <", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSLessThanOrEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS <=", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSLike(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS like", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSNotLike(String value) {
            addCriterion("ITEM_LONG_DESC_ZHS not like", value, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSIn(List<String> values) {
            addCriterion("ITEM_LONG_DESC_ZHS in", values, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSNotIn(List<String> values) {
            addCriterion("ITEM_LONG_DESC_ZHS not in", values, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSBetween(String value1, String value2) {
            addCriterion("ITEM_LONG_DESC_ZHS between", value1, value2, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_ZHSNotBetween(String value1, String value2) {
            addCriterion("ITEM_LONG_DESC_ZHS not between", value1, value2, "ITEM_LONG_DESC_ZHS");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USIsNull() {
            addCriterion("ITEM_LONG_DESC_US is null");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USIsNotNull() {
            addCriterion("ITEM_LONG_DESC_US is not null");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_US =", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USNotEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_US <>", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USGreaterThan(String value) {
            addCriterion("ITEM_LONG_DESC_US >", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_US >=", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USLessThan(String value) {
            addCriterion("ITEM_LONG_DESC_US <", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USLessThanOrEqualTo(String value) {
            addCriterion("ITEM_LONG_DESC_US <=", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USLike(String value) {
            addCriterion("ITEM_LONG_DESC_US like", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USNotLike(String value) {
            addCriterion("ITEM_LONG_DESC_US not like", value, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USIn(List<String> values) {
            addCriterion("ITEM_LONG_DESC_US in", values, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USNotIn(List<String> values) {
            addCriterion("ITEM_LONG_DESC_US not in", values, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USBetween(String value1, String value2) {
            addCriterion("ITEM_LONG_DESC_US between", value1, value2, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andITEM_LONG_DESC_USNotBetween(String value1, String value2) {
            addCriterion("ITEM_LONG_DESC_US not between", value1, value2, "ITEM_LONG_DESC_US");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASUREIsNull() {
            addCriterion("UNIT_OF_MEASURE is null");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASUREIsNotNull() {
            addCriterion("UNIT_OF_MEASURE is not null");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASUREEqualTo(String value) {
            addCriterion("UNIT_OF_MEASURE =", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASURENotEqualTo(String value) {
            addCriterion("UNIT_OF_MEASURE <>", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASUREGreaterThan(String value) {
            addCriterion("UNIT_OF_MEASURE >", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASUREGreaterThanOrEqualTo(String value) {
            addCriterion("UNIT_OF_MEASURE >=", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASURELessThan(String value) {
            addCriterion("UNIT_OF_MEASURE <", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASURELessThanOrEqualTo(String value) {
            addCriterion("UNIT_OF_MEASURE <=", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASURELike(String value) {
            addCriterion("UNIT_OF_MEASURE like", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASURENotLike(String value) {
            addCriterion("UNIT_OF_MEASURE not like", value, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASUREIn(List<String> values) {
            addCriterion("UNIT_OF_MEASURE in", values, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASURENotIn(List<String> values) {
            addCriterion("UNIT_OF_MEASURE not in", values, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASUREBetween(String value1, String value2) {
            addCriterion("UNIT_OF_MEASURE between", value1, value2, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andUNIT_OF_MEASURENotBetween(String value1, String value2) {
            addCriterion("UNIT_OF_MEASURE not between", value1, value2, "UNIT_OF_MEASURE");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLIsNull() {
            addCriterion("LOT_CONTROL is null");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLIsNotNull() {
            addCriterion("LOT_CONTROL is not null");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLEqualTo(String value) {
            addCriterion("LOT_CONTROL =", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLNotEqualTo(String value) {
            addCriterion("LOT_CONTROL <>", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLGreaterThan(String value) {
            addCriterion("LOT_CONTROL >", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLGreaterThanOrEqualTo(String value) {
            addCriterion("LOT_CONTROL >=", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLLessThan(String value) {
            addCriterion("LOT_CONTROL <", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLLessThanOrEqualTo(String value) {
            addCriterion("LOT_CONTROL <=", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLLike(String value) {
            addCriterion("LOT_CONTROL like", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLNotLike(String value) {
            addCriterion("LOT_CONTROL not like", value, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLIn(List<String> values) {
            addCriterion("LOT_CONTROL in", values, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLNotIn(List<String> values) {
            addCriterion("LOT_CONTROL not in", values, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLBetween(String value1, String value2) {
            addCriterion("LOT_CONTROL between", value1, value2, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andLOT_CONTROLNotBetween(String value1, String value2) {
            addCriterion("LOT_CONTROL not between", value1, value2, "LOT_CONTROL");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSIsNull() {
            addCriterion("SHELFLIFE_DAYS is null");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSIsNotNull() {
            addCriterion("SHELFLIFE_DAYS is not null");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSEqualTo(String value) {
            addCriterion("SHELFLIFE_DAYS =", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSNotEqualTo(String value) {
            addCriterion("SHELFLIFE_DAYS <>", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSGreaterThan(String value) {
            addCriterion("SHELFLIFE_DAYS >", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSGreaterThanOrEqualTo(String value) {
            addCriterion("SHELFLIFE_DAYS >=", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSLessThan(String value) {
            addCriterion("SHELFLIFE_DAYS <", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSLessThanOrEqualTo(String value) {
            addCriterion("SHELFLIFE_DAYS <=", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSLike(String value) {
            addCriterion("SHELFLIFE_DAYS like", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSNotLike(String value) {
            addCriterion("SHELFLIFE_DAYS not like", value, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSIn(List<String> values) {
            addCriterion("SHELFLIFE_DAYS in", values, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSNotIn(List<String> values) {
            addCriterion("SHELFLIFE_DAYS not in", values, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSBetween(String value1, String value2) {
            addCriterion("SHELFLIFE_DAYS between", value1, value2, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andSHELFLIFE_DAYSNotBetween(String value1, String value2) {
            addCriterion("SHELFLIFE_DAYS not between", value1, value2, "SHELFLIFE_DAYS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSIsNull() {
            addCriterion("ITEM_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSIsNotNull() {
            addCriterion("ITEM_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSEqualTo(String value) {
            addCriterion("ITEM_STATUS =", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSNotEqualTo(String value) {
            addCriterion("ITEM_STATUS <>", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSGreaterThan(String value) {
            addCriterion("ITEM_STATUS >", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_STATUS >=", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSLessThan(String value) {
            addCriterion("ITEM_STATUS <", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSLessThanOrEqualTo(String value) {
            addCriterion("ITEM_STATUS <=", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSLike(String value) {
            addCriterion("ITEM_STATUS like", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSNotLike(String value) {
            addCriterion("ITEM_STATUS not like", value, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSIn(List<String> values) {
            addCriterion("ITEM_STATUS in", values, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSNotIn(List<String> values) {
            addCriterion("ITEM_STATUS not in", values, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSBetween(String value1, String value2) {
            addCriterion("ITEM_STATUS between", value1, value2, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andITEM_STATUSNotBetween(String value1, String value2) {
            addCriterion("ITEM_STATUS not between", value1, value2, "ITEM_STATUS");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGIsNull() {
            addCriterion("STOCK_ENABLE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGIsNotNull() {
            addCriterion("STOCK_ENABLE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGEqualTo(String value) {
            addCriterion("STOCK_ENABLE_FLAG =", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGNotEqualTo(String value) {
            addCriterion("STOCK_ENABLE_FLAG <>", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGGreaterThan(String value) {
            addCriterion("STOCK_ENABLE_FLAG >", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("STOCK_ENABLE_FLAG >=", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGLessThan(String value) {
            addCriterion("STOCK_ENABLE_FLAG <", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGLessThanOrEqualTo(String value) {
            addCriterion("STOCK_ENABLE_FLAG <=", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGLike(String value) {
            addCriterion("STOCK_ENABLE_FLAG like", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGNotLike(String value) {
            addCriterion("STOCK_ENABLE_FLAG not like", value, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGIn(List<String> values) {
            addCriterion("STOCK_ENABLE_FLAG in", values, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGNotIn(List<String> values) {
            addCriterion("STOCK_ENABLE_FLAG not in", values, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGBetween(String value1, String value2) {
            addCriterion("STOCK_ENABLE_FLAG between", value1, value2, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andSTOCK_ENABLE_FLAGNotBetween(String value1, String value2) {
            addCriterion("STOCK_ENABLE_FLAG not between", value1, value2, "STOCK_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGIsNull() {
            addCriterion("PURCHASING_ENABLE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGIsNotNull() {
            addCriterion("PURCHASING_ENABLE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGEqualTo(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG =", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGNotEqualTo(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG <>", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGGreaterThan(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG >", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG >=", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGLessThan(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG <", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGLessThanOrEqualTo(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG <=", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGLike(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG like", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGNotLike(String value) {
            addCriterion("PURCHASING_ENABLE_FLAG not like", value, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGIn(List<String> values) {
            addCriterion("PURCHASING_ENABLE_FLAG in", values, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGNotIn(List<String> values) {
            addCriterion("PURCHASING_ENABLE_FLAG not in", values, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGBetween(String value1, String value2) {
            addCriterion("PURCHASING_ENABLE_FLAG between", value1, value2, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andPURCHASING_ENABLE_FLAGNotBetween(String value1, String value2) {
            addCriterion("PURCHASING_ENABLE_FLAG not between", value1, value2, "PURCHASING_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORIsNull() {
            addCriterion("MUST_APPROVE_VENDOR is null");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORIsNotNull() {
            addCriterion("MUST_APPROVE_VENDOR is not null");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDOREqualTo(String value) {
            addCriterion("MUST_APPROVE_VENDOR =", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORNotEqualTo(String value) {
            addCriterion("MUST_APPROVE_VENDOR <>", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORGreaterThan(String value) {
            addCriterion("MUST_APPROVE_VENDOR >", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORGreaterThanOrEqualTo(String value) {
            addCriterion("MUST_APPROVE_VENDOR >=", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORLessThan(String value) {
            addCriterion("MUST_APPROVE_VENDOR <", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORLessThanOrEqualTo(String value) {
            addCriterion("MUST_APPROVE_VENDOR <=", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORLike(String value) {
            addCriterion("MUST_APPROVE_VENDOR like", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORNotLike(String value) {
            addCriterion("MUST_APPROVE_VENDOR not like", value, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORIn(List<String> values) {
            addCriterion("MUST_APPROVE_VENDOR in", values, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORNotIn(List<String> values) {
            addCriterion("MUST_APPROVE_VENDOR not in", values, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORBetween(String value1, String value2) {
            addCriterion("MUST_APPROVE_VENDOR between", value1, value2, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andMUST_APPROVE_VENDORNotBetween(String value1, String value2) {
            addCriterion("MUST_APPROVE_VENDOR not between", value1, value2, "MUST_APPROVE_VENDOR");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMIsNull() {
            addCriterion("DEFAULT_BUYER_NUM is null");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMIsNotNull() {
            addCriterion("DEFAULT_BUYER_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMEqualTo(String value) {
            addCriterion("DEFAULT_BUYER_NUM =", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMNotEqualTo(String value) {
            addCriterion("DEFAULT_BUYER_NUM <>", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMGreaterThan(String value) {
            addCriterion("DEFAULT_BUYER_NUM >", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMGreaterThanOrEqualTo(String value) {
            addCriterion("DEFAULT_BUYER_NUM >=", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMLessThan(String value) {
            addCriterion("DEFAULT_BUYER_NUM <", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMLessThanOrEqualTo(String value) {
            addCriterion("DEFAULT_BUYER_NUM <=", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMLike(String value) {
            addCriterion("DEFAULT_BUYER_NUM like", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMNotLike(String value) {
            addCriterion("DEFAULT_BUYER_NUM not like", value, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMIn(List<String> values) {
            addCriterion("DEFAULT_BUYER_NUM in", values, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMNotIn(List<String> values) {
            addCriterion("DEFAULT_BUYER_NUM not in", values, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMBetween(String value1, String value2) {
            addCriterion("DEFAULT_BUYER_NUM between", value1, value2, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYER_NUMNotBetween(String value1, String value2) {
            addCriterion("DEFAULT_BUYER_NUM not between", value1, value2, "DEFAULT_BUYER_NUM");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERIsNull() {
            addCriterion("DEFAULT_BUYER is null");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERIsNotNull() {
            addCriterion("DEFAULT_BUYER is not null");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYEREqualTo(String value) {
            addCriterion("DEFAULT_BUYER =", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERNotEqualTo(String value) {
            addCriterion("DEFAULT_BUYER <>", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERGreaterThan(String value) {
            addCriterion("DEFAULT_BUYER >", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERGreaterThanOrEqualTo(String value) {
            addCriterion("DEFAULT_BUYER >=", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERLessThan(String value) {
            addCriterion("DEFAULT_BUYER <", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERLessThanOrEqualTo(String value) {
            addCriterion("DEFAULT_BUYER <=", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERLike(String value) {
            addCriterion("DEFAULT_BUYER like", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERNotLike(String value) {
            addCriterion("DEFAULT_BUYER not like", value, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERIn(List<String> values) {
            addCriterion("DEFAULT_BUYER in", values, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERNotIn(List<String> values) {
            addCriterion("DEFAULT_BUYER not in", values, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERBetween(String value1, String value2) {
            addCriterion("DEFAULT_BUYER between", value1, value2, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andDEFAULT_BUYERNotBetween(String value1, String value2) {
            addCriterion("DEFAULT_BUYER not between", value1, value2, "DEFAULT_BUYER");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGIsNull() {
            addCriterion("BOM_ENABLED_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGIsNotNull() {
            addCriterion("BOM_ENABLED_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGEqualTo(String value) {
            addCriterion("BOM_ENABLED_FLAG =", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGNotEqualTo(String value) {
            addCriterion("BOM_ENABLED_FLAG <>", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGGreaterThan(String value) {
            addCriterion("BOM_ENABLED_FLAG >", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("BOM_ENABLED_FLAG >=", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGLessThan(String value) {
            addCriterion("BOM_ENABLED_FLAG <", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGLessThanOrEqualTo(String value) {
            addCriterion("BOM_ENABLED_FLAG <=", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGLike(String value) {
            addCriterion("BOM_ENABLED_FLAG like", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGNotLike(String value) {
            addCriterion("BOM_ENABLED_FLAG not like", value, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGIn(List<String> values) {
            addCriterion("BOM_ENABLED_FLAG in", values, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGNotIn(List<String> values) {
            addCriterion("BOM_ENABLED_FLAG not in", values, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGBetween(String value1, String value2) {
            addCriterion("BOM_ENABLED_FLAG between", value1, value2, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBOM_ENABLED_FLAGNotBetween(String value1, String value2) {
            addCriterion("BOM_ENABLED_FLAG not between", value1, value2, "BOM_ENABLED_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGIsNull() {
            addCriterion("BUILD_IN_WIP_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGIsNotNull() {
            addCriterion("BUILD_IN_WIP_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGEqualTo(String value) {
            addCriterion("BUILD_IN_WIP_FLAG =", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGNotEqualTo(String value) {
            addCriterion("BUILD_IN_WIP_FLAG <>", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGGreaterThan(String value) {
            addCriterion("BUILD_IN_WIP_FLAG >", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("BUILD_IN_WIP_FLAG >=", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGLessThan(String value) {
            addCriterion("BUILD_IN_WIP_FLAG <", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGLessThanOrEqualTo(String value) {
            addCriterion("BUILD_IN_WIP_FLAG <=", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGLike(String value) {
            addCriterion("BUILD_IN_WIP_FLAG like", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGNotLike(String value) {
            addCriterion("BUILD_IN_WIP_FLAG not like", value, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGIn(List<String> values) {
            addCriterion("BUILD_IN_WIP_FLAG in", values, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGNotIn(List<String> values) {
            addCriterion("BUILD_IN_WIP_FLAG not in", values, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGBetween(String value1, String value2) {
            addCriterion("BUILD_IN_WIP_FLAG between", value1, value2, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andBUILD_IN_WIP_FLAGNotBetween(String value1, String value2) {
            addCriterion("BUILD_IN_WIP_FLAG not between", value1, value2, "BUILD_IN_WIP_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGIsNull() {
            addCriterion("CUSTMOER_ORDER_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGIsNotNull() {
            addCriterion("CUSTMOER_ORDER_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGEqualTo(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG =", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGNotEqualTo(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG <>", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGGreaterThan(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG >", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG >=", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGLessThan(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG <", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGLessThanOrEqualTo(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG <=", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGLike(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG like", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGNotLike(String value) {
            addCriterion("CUSTMOER_ORDER_FLAG not like", value, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGIn(List<String> values) {
            addCriterion("CUSTMOER_ORDER_FLAG in", values, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGNotIn(List<String> values) {
            addCriterion("CUSTMOER_ORDER_FLAG not in", values, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGBetween(String value1, String value2) {
            addCriterion("CUSTMOER_ORDER_FLAG between", value1, value2, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andCUSTMOER_ORDER_FLAGNotBetween(String value1, String value2) {
            addCriterion("CUSTMOER_ORDER_FLAG not between", value1, value2, "CUSTMOER_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGIsNull() {
            addCriterion("INTERNAL_ORDER_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGIsNotNull() {
            addCriterion("INTERNAL_ORDER_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGEqualTo(String value) {
            addCriterion("INTERNAL_ORDER_FLAG =", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGNotEqualTo(String value) {
            addCriterion("INTERNAL_ORDER_FLAG <>", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGGreaterThan(String value) {
            addCriterion("INTERNAL_ORDER_FLAG >", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("INTERNAL_ORDER_FLAG >=", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGLessThan(String value) {
            addCriterion("INTERNAL_ORDER_FLAG <", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGLessThanOrEqualTo(String value) {
            addCriterion("INTERNAL_ORDER_FLAG <=", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGLike(String value) {
            addCriterion("INTERNAL_ORDER_FLAG like", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGNotLike(String value) {
            addCriterion("INTERNAL_ORDER_FLAG not like", value, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGIn(List<String> values) {
            addCriterion("INTERNAL_ORDER_FLAG in", values, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGNotIn(List<String> values) {
            addCriterion("INTERNAL_ORDER_FLAG not in", values, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGBetween(String value1, String value2) {
            addCriterion("INTERNAL_ORDER_FLAG between", value1, value2, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINTERNAL_ORDER_FLAGNotBetween(String value1, String value2) {
            addCriterion("INTERNAL_ORDER_FLAG not between", value1, value2, "INTERNAL_ORDER_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGIsNull() {
            addCriterion("INVOICED_ENABLE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGIsNotNull() {
            addCriterion("INVOICED_ENABLE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGEqualTo(String value) {
            addCriterion("INVOICED_ENABLE_FLAG =", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGNotEqualTo(String value) {
            addCriterion("INVOICED_ENABLE_FLAG <>", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGGreaterThan(String value) {
            addCriterion("INVOICED_ENABLE_FLAG >", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("INVOICED_ENABLE_FLAG >=", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGLessThan(String value) {
            addCriterion("INVOICED_ENABLE_FLAG <", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGLessThanOrEqualTo(String value) {
            addCriterion("INVOICED_ENABLE_FLAG <=", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGLike(String value) {
            addCriterion("INVOICED_ENABLE_FLAG like", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGNotLike(String value) {
            addCriterion("INVOICED_ENABLE_FLAG not like", value, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGIn(List<String> values) {
            addCriterion("INVOICED_ENABLE_FLAG in", values, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGNotIn(List<String> values) {
            addCriterion("INVOICED_ENABLE_FLAG not in", values, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGBetween(String value1, String value2) {
            addCriterion("INVOICED_ENABLE_FLAG between", value1, value2, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andINVOICED_ENABLE_FLAGNotBetween(String value1, String value2) {
            addCriterion("INVOICED_ENABLE_FLAG not between", value1, value2, "INVOICED_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGIsNull() {
            addCriterion("TRANSACTION_ENABLE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGIsNotNull() {
            addCriterion("TRANSACTION_ENABLE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGEqualTo(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG =", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGNotEqualTo(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG <>", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGGreaterThan(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG >", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG >=", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGLessThan(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG <", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG <=", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGLike(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG like", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGNotLike(String value) {
            addCriterion("TRANSACTION_ENABLE_FLAG not like", value, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGIn(List<String> values) {
            addCriterion("TRANSACTION_ENABLE_FLAG in", values, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGNotIn(List<String> values) {
            addCriterion("TRANSACTION_ENABLE_FLAG not in", values, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGBetween(String value1, String value2) {
            addCriterion("TRANSACTION_ENABLE_FLAG between", value1, value2, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andTRANSACTION_ENABLE_FLAGNotBetween(String value1, String value2) {
            addCriterion("TRANSACTION_ENABLE_FLAG not between", value1, value2, "TRANSACTION_ENABLE_FLAG");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDIsNull() {
            addCriterion("RECEIVE_ROUTING_ID is null");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDIsNotNull() {
            addCriterion("RECEIVE_ROUTING_ID is not null");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDEqualTo(String value) {
            addCriterion("RECEIVE_ROUTING_ID =", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDNotEqualTo(String value) {
            addCriterion("RECEIVE_ROUTING_ID <>", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDGreaterThan(String value) {
            addCriterion("RECEIVE_ROUTING_ID >", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDGreaterThanOrEqualTo(String value) {
            addCriterion("RECEIVE_ROUTING_ID >=", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDLessThan(String value) {
            addCriterion("RECEIVE_ROUTING_ID <", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDLessThanOrEqualTo(String value) {
            addCriterion("RECEIVE_ROUTING_ID <=", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDLike(String value) {
            addCriterion("RECEIVE_ROUTING_ID like", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDNotLike(String value) {
            addCriterion("RECEIVE_ROUTING_ID not like", value, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDIn(List<String> values) {
            addCriterion("RECEIVE_ROUTING_ID in", values, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDNotIn(List<String> values) {
            addCriterion("RECEIVE_ROUTING_ID not in", values, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDBetween(String value1, String value2) {
            addCriterion("RECEIVE_ROUTING_ID between", value1, value2, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andRECEIVE_ROUTING_IDNotBetween(String value1, String value2) {
            addCriterion("RECEIVE_ROUTING_ID not between", value1, value2, "RECEIVE_ROUTING_ID");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESIsNull() {
            addCriterion("EXTEND_ATTRIBUTES is null");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESIsNotNull() {
            addCriterion("EXTEND_ATTRIBUTES is not null");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESEqualTo(String value) {
            addCriterion("EXTEND_ATTRIBUTES =", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESNotEqualTo(String value) {
            addCriterion("EXTEND_ATTRIBUTES <>", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESGreaterThan(String value) {
            addCriterion("EXTEND_ATTRIBUTES >", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESGreaterThanOrEqualTo(String value) {
            addCriterion("EXTEND_ATTRIBUTES >=", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESLessThan(String value) {
            addCriterion("EXTEND_ATTRIBUTES <", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESLessThanOrEqualTo(String value) {
            addCriterion("EXTEND_ATTRIBUTES <=", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESLike(String value) {
            addCriterion("EXTEND_ATTRIBUTES like", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESNotLike(String value) {
            addCriterion("EXTEND_ATTRIBUTES not like", value, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESIn(List<String> values) {
            addCriterion("EXTEND_ATTRIBUTES in", values, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESNotIn(List<String> values) {
            addCriterion("EXTEND_ATTRIBUTES not in", values, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESBetween(String value1, String value2) {
            addCriterion("EXTEND_ATTRIBUTES between", value1, value2, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andEXTEND_ATTRIBUTESNotBetween(String value1, String value2) {
            addCriterion("EXTEND_ATTRIBUTES not between", value1, value2, "EXTEND_ATTRIBUTES");
            return (Criteria) this;
        }

        public Criteria andATTR1IsNull() {
            addCriterion("ATTR1 is null");
            return (Criteria) this;
        }

        public Criteria andATTR1IsNotNull() {
            addCriterion("ATTR1 is not null");
            return (Criteria) this;
        }

        public Criteria andATTR1EqualTo(String value) {
            addCriterion("ATTR1 =", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1NotEqualTo(String value) {
            addCriterion("ATTR1 <>", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1GreaterThan(String value) {
            addCriterion("ATTR1 >", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1GreaterThanOrEqualTo(String value) {
            addCriterion("ATTR1 >=", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1LessThan(String value) {
            addCriterion("ATTR1 <", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1LessThanOrEqualTo(String value) {
            addCriterion("ATTR1 <=", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1Like(String value) {
            addCriterion("ATTR1 like", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1NotLike(String value) {
            addCriterion("ATTR1 not like", value, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1In(List<String> values) {
            addCriterion("ATTR1 in", values, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1NotIn(List<String> values) {
            addCriterion("ATTR1 not in", values, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1Between(String value1, String value2) {
            addCriterion("ATTR1 between", value1, value2, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR1NotBetween(String value1, String value2) {
            addCriterion("ATTR1 not between", value1, value2, "ATTR1");
            return (Criteria) this;
        }

        public Criteria andATTR2IsNull() {
            addCriterion("ATTR2 is null");
            return (Criteria) this;
        }

        public Criteria andATTR2IsNotNull() {
            addCriterion("ATTR2 is not null");
            return (Criteria) this;
        }

        public Criteria andATTR2EqualTo(String value) {
            addCriterion("ATTR2 =", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2NotEqualTo(String value) {
            addCriterion("ATTR2 <>", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2GreaterThan(String value) {
            addCriterion("ATTR2 >", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2GreaterThanOrEqualTo(String value) {
            addCriterion("ATTR2 >=", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2LessThan(String value) {
            addCriterion("ATTR2 <", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2LessThanOrEqualTo(String value) {
            addCriterion("ATTR2 <=", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2Like(String value) {
            addCriterion("ATTR2 like", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2NotLike(String value) {
            addCriterion("ATTR2 not like", value, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2In(List<String> values) {
            addCriterion("ATTR2 in", values, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2NotIn(List<String> values) {
            addCriterion("ATTR2 not in", values, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2Between(String value1, String value2) {
            addCriterion("ATTR2 between", value1, value2, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR2NotBetween(String value1, String value2) {
            addCriterion("ATTR2 not between", value1, value2, "ATTR2");
            return (Criteria) this;
        }

        public Criteria andATTR3IsNull() {
            addCriterion("ATTR3 is null");
            return (Criteria) this;
        }

        public Criteria andATTR3IsNotNull() {
            addCriterion("ATTR3 is not null");
            return (Criteria) this;
        }

        public Criteria andATTR3EqualTo(String value) {
            addCriterion("ATTR3 =", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3NotEqualTo(String value) {
            addCriterion("ATTR3 <>", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3GreaterThan(String value) {
            addCriterion("ATTR3 >", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3GreaterThanOrEqualTo(String value) {
            addCriterion("ATTR3 >=", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3LessThan(String value) {
            addCriterion("ATTR3 <", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3LessThanOrEqualTo(String value) {
            addCriterion("ATTR3 <=", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3Like(String value) {
            addCriterion("ATTR3 like", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3NotLike(String value) {
            addCriterion("ATTR3 not like", value, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3In(List<String> values) {
            addCriterion("ATTR3 in", values, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3NotIn(List<String> values) {
            addCriterion("ATTR3 not in", values, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3Between(String value1, String value2) {
            addCriterion("ATTR3 between", value1, value2, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR3NotBetween(String value1, String value2) {
            addCriterion("ATTR3 not between", value1, value2, "ATTR3");
            return (Criteria) this;
        }

        public Criteria andATTR4IsNull() {
            addCriterion("ATTR4 is null");
            return (Criteria) this;
        }

        public Criteria andATTR4IsNotNull() {
            addCriterion("ATTR4 is not null");
            return (Criteria) this;
        }

        public Criteria andATTR4EqualTo(String value) {
            addCriterion("ATTR4 =", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4NotEqualTo(String value) {
            addCriterion("ATTR4 <>", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4GreaterThan(String value) {
            addCriterion("ATTR4 >", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4GreaterThanOrEqualTo(String value) {
            addCriterion("ATTR4 >=", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4LessThan(String value) {
            addCriterion("ATTR4 <", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4LessThanOrEqualTo(String value) {
            addCriterion("ATTR4 <=", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4Like(String value) {
            addCriterion("ATTR4 like", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4NotLike(String value) {
            addCriterion("ATTR4 not like", value, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4In(List<String> values) {
            addCriterion("ATTR4 in", values, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4NotIn(List<String> values) {
            addCriterion("ATTR4 not in", values, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4Between(String value1, String value2) {
            addCriterion("ATTR4 between", value1, value2, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR4NotBetween(String value1, String value2) {
            addCriterion("ATTR4 not between", value1, value2, "ATTR4");
            return (Criteria) this;
        }

        public Criteria andATTR5IsNull() {
            addCriterion("ATTR5 is null");
            return (Criteria) this;
        }

        public Criteria andATTR5IsNotNull() {
            addCriterion("ATTR5 is not null");
            return (Criteria) this;
        }

        public Criteria andATTR5EqualTo(String value) {
            addCriterion("ATTR5 =", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5NotEqualTo(String value) {
            addCriterion("ATTR5 <>", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5GreaterThan(String value) {
            addCriterion("ATTR5 >", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5GreaterThanOrEqualTo(String value) {
            addCriterion("ATTR5 >=", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5LessThan(String value) {
            addCriterion("ATTR5 <", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5LessThanOrEqualTo(String value) {
            addCriterion("ATTR5 <=", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5Like(String value) {
            addCriterion("ATTR5 like", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5NotLike(String value) {
            addCriterion("ATTR5 not like", value, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5In(List<String> values) {
            addCriterion("ATTR5 in", values, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5NotIn(List<String> values) {
            addCriterion("ATTR5 not in", values, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5Between(String value1, String value2) {
            addCriterion("ATTR5 between", value1, value2, "ATTR5");
            return (Criteria) this;
        }

        public Criteria andATTR5NotBetween(String value1, String value2) {
            addCriterion("ATTR5 not between", value1, value2, "ATTR5");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table PWC_INVOICE.INPUT_MATERIAL_ITEM
     *
     * @mbg.generated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}