BalanceStdExample.java

package pwc.taxtech.atms.vat.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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

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

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

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

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

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

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

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

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

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

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT.BALANCE_STD
     *
     * @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 TAX_PROJECT.BALANCE_STD
     *
     * @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 TAX_PROJECT.BALANCE_STD
     *
     * @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 TAX_PROJECT.BALANCE_STD
     *
     * @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 TAX_PROJECT.BALANCE_STD
     *
     * @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 andBalanceIdIsNull() {
            addCriterion("BALANCE_ID is null");
            return (Criteria) this;
        }

        public Criteria andBalanceIdIsNotNull() {
            addCriterion("BALANCE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBalanceIdEqualTo(String value) {
            addCriterion("BALANCE_ID =", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdNotEqualTo(String value) {
            addCriterion("BALANCE_ID <>", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdGreaterThan(String value) {
            addCriterion("BALANCE_ID >", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdGreaterThanOrEqualTo(String value) {
            addCriterion("BALANCE_ID >=", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdLessThan(String value) {
            addCriterion("BALANCE_ID <", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdLessThanOrEqualTo(String value) {
            addCriterion("BALANCE_ID <=", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdLike(String value) {
            addCriterion("BALANCE_ID like", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdNotLike(String value) {
            addCriterion("BALANCE_ID not like", value, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdIn(List<String> values) {
            addCriterion("BALANCE_ID in", values, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdNotIn(List<String> values) {
            addCriterion("BALANCE_ID not in", values, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdBetween(String value1, String value2) {
            addCriterion("BALANCE_ID between", value1, value2, "balanceId");
            return (Criteria) this;
        }

        public Criteria andBalanceIdNotBetween(String value1, String value2) {
            addCriterion("BALANCE_ID not between", value1, value2, "balanceId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdIsNull() {
            addCriterion("PERIOD_ID is null");
            return (Criteria) this;
        }

        public Criteria andPeriodIdIsNotNull() {
            addCriterion("PERIOD_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPeriodIdEqualTo(Integer value) {
            addCriterion("PERIOD_ID =", value, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdNotEqualTo(Integer value) {
            addCriterion("PERIOD_ID <>", value, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdGreaterThan(Integer value) {
            addCriterion("PERIOD_ID >", value, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("PERIOD_ID >=", value, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdLessThan(Integer value) {
            addCriterion("PERIOD_ID <", value, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdLessThanOrEqualTo(Integer value) {
            addCriterion("PERIOD_ID <=", value, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdIn(List<Integer> values) {
            addCriterion("PERIOD_ID in", values, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdNotIn(List<Integer> values) {
            addCriterion("PERIOD_ID not in", values, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdBetween(Integer value1, Integer value2) {
            addCriterion("PERIOD_ID between", value1, value2, "periodId");
            return (Criteria) this;
        }

        public Criteria andPeriodIdNotBetween(Integer value1, Integer value2) {
            addCriterion("PERIOD_ID not between", value1, value2, "periodId");
            return (Criteria) this;
        }

        public Criteria andAcctCodeIsNull() {
            addCriterion("ACCT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andAcctCodeIsNotNull() {
            addCriterion("ACCT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andAcctCodeEqualTo(String value) {
            addCriterion("ACCT_CODE =", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeNotEqualTo(String value) {
            addCriterion("ACCT_CODE <>", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeGreaterThan(String value) {
            addCriterion("ACCT_CODE >", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ACCT_CODE >=", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeLessThan(String value) {
            addCriterion("ACCT_CODE <", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeLessThanOrEqualTo(String value) {
            addCriterion("ACCT_CODE <=", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeLike(String value) {
            addCriterion("ACCT_CODE like", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeNotLike(String value) {
            addCriterion("ACCT_CODE not like", value, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeIn(List<String> values) {
            addCriterion("ACCT_CODE in", values, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeNotIn(List<String> values) {
            addCriterion("ACCT_CODE not in", values, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeBetween(String value1, String value2) {
            addCriterion("ACCT_CODE between", value1, value2, "acctCode");
            return (Criteria) this;
        }

        public Criteria andAcctCodeNotBetween(String value1, String value2) {
            addCriterion("ACCT_CODE not between", value1, value2, "acctCode");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalIsNull() {
            addCriterion("BEG_DEBIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalIsNotNull() {
            addCriterion("BEG_DEBIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalEqualTo(BigDecimal value) {
            addCriterion("BEG_DEBIT_BAL =", value, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalNotEqualTo(BigDecimal value) {
            addCriterion("BEG_DEBIT_BAL <>", value, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalGreaterThan(BigDecimal value) {
            addCriterion("BEG_DEBIT_BAL >", value, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BEG_DEBIT_BAL >=", value, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalLessThan(BigDecimal value) {
            addCriterion("BEG_DEBIT_BAL <", value, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BEG_DEBIT_BAL <=", value, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalIn(List<BigDecimal> values) {
            addCriterion("BEG_DEBIT_BAL in", values, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalNotIn(List<BigDecimal> values) {
            addCriterion("BEG_DEBIT_BAL not in", values, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEG_DEBIT_BAL between", value1, value2, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegDebitBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEG_DEBIT_BAL not between", value1, value2, "begDebitBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalIsNull() {
            addCriterion("BEG_CREDIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalIsNotNull() {
            addCriterion("BEG_CREDIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalEqualTo(BigDecimal value) {
            addCriterion("BEG_CREDIT_BAL =", value, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalNotEqualTo(BigDecimal value) {
            addCriterion("BEG_CREDIT_BAL <>", value, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalGreaterThan(BigDecimal value) {
            addCriterion("BEG_CREDIT_BAL >", value, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BEG_CREDIT_BAL >=", value, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalLessThan(BigDecimal value) {
            addCriterion("BEG_CREDIT_BAL <", value, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BEG_CREDIT_BAL <=", value, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalIn(List<BigDecimal> values) {
            addCriterion("BEG_CREDIT_BAL in", values, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalNotIn(List<BigDecimal> values) {
            addCriterion("BEG_CREDIT_BAL not in", values, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEG_CREDIT_BAL between", value1, value2, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegCreditBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEG_CREDIT_BAL not between", value1, value2, "begCreditBal");
            return (Criteria) this;
        }

        public Criteria andBegBalIsNull() {
            addCriterion("BEG_BAL is null");
            return (Criteria) this;
        }

        public Criteria andBegBalIsNotNull() {
            addCriterion("BEG_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andBegBalEqualTo(BigDecimal value) {
            addCriterion("BEG_BAL =", value, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalNotEqualTo(BigDecimal value) {
            addCriterion("BEG_BAL <>", value, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalGreaterThan(BigDecimal value) {
            addCriterion("BEG_BAL >", value, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BEG_BAL >=", value, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalLessThan(BigDecimal value) {
            addCriterion("BEG_BAL <", value, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BEG_BAL <=", value, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalIn(List<BigDecimal> values) {
            addCriterion("BEG_BAL in", values, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalNotIn(List<BigDecimal> values) {
            addCriterion("BEG_BAL not in", values, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEG_BAL between", value1, value2, "begBal");
            return (Criteria) this;
        }

        public Criteria andBegBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEG_BAL not between", value1, value2, "begBal");
            return (Criteria) this;
        }

        public Criteria andEndBalIsNull() {
            addCriterion("END_BAL is null");
            return (Criteria) this;
        }

        public Criteria andEndBalIsNotNull() {
            addCriterion("END_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andEndBalEqualTo(BigDecimal value) {
            addCriterion("END_BAL =", value, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalNotEqualTo(BigDecimal value) {
            addCriterion("END_BAL <>", value, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalGreaterThan(BigDecimal value) {
            addCriterion("END_BAL >", value, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("END_BAL >=", value, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalLessThan(BigDecimal value) {
            addCriterion("END_BAL <", value, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("END_BAL <=", value, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalIn(List<BigDecimal> values) {
            addCriterion("END_BAL in", values, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalNotIn(List<BigDecimal> values) {
            addCriterion("END_BAL not in", values, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_BAL between", value1, value2, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_BAL not between", value1, value2, "endBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalIsNull() {
            addCriterion("END_DEBIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalIsNotNull() {
            addCriterion("END_DEBIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalEqualTo(BigDecimal value) {
            addCriterion("END_DEBIT_BAL =", value, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalNotEqualTo(BigDecimal value) {
            addCriterion("END_DEBIT_BAL <>", value, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalGreaterThan(BigDecimal value) {
            addCriterion("END_DEBIT_BAL >", value, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("END_DEBIT_BAL >=", value, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalLessThan(BigDecimal value) {
            addCriterion("END_DEBIT_BAL <", value, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("END_DEBIT_BAL <=", value, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalIn(List<BigDecimal> values) {
            addCriterion("END_DEBIT_BAL in", values, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalNotIn(List<BigDecimal> values) {
            addCriterion("END_DEBIT_BAL not in", values, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_DEBIT_BAL between", value1, value2, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndDebitBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_DEBIT_BAL not between", value1, value2, "endDebitBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalIsNull() {
            addCriterion("END_CREDIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalIsNotNull() {
            addCriterion("END_CREDIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalEqualTo(BigDecimal value) {
            addCriterion("END_CREDIT_BAL =", value, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalNotEqualTo(BigDecimal value) {
            addCriterion("END_CREDIT_BAL <>", value, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalGreaterThan(BigDecimal value) {
            addCriterion("END_CREDIT_BAL >", value, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("END_CREDIT_BAL >=", value, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalLessThan(BigDecimal value) {
            addCriterion("END_CREDIT_BAL <", value, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("END_CREDIT_BAL <=", value, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalIn(List<BigDecimal> values) {
            addCriterion("END_CREDIT_BAL in", values, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalNotIn(List<BigDecimal> values) {
            addCriterion("END_CREDIT_BAL not in", values, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_CREDIT_BAL between", value1, value2, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andEndCreditBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_CREDIT_BAL not between", value1, value2, "endCreditBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalIsNull() {
            addCriterion("DEBIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andDebitBalIsNotNull() {
            addCriterion("DEBIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andDebitBalEqualTo(BigDecimal value) {
            addCriterion("DEBIT_BAL =", value, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalNotEqualTo(BigDecimal value) {
            addCriterion("DEBIT_BAL <>", value, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalGreaterThan(BigDecimal value) {
            addCriterion("DEBIT_BAL >", value, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DEBIT_BAL >=", value, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalLessThan(BigDecimal value) {
            addCriterion("DEBIT_BAL <", value, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DEBIT_BAL <=", value, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalIn(List<BigDecimal> values) {
            addCriterion("DEBIT_BAL in", values, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalNotIn(List<BigDecimal> values) {
            addCriterion("DEBIT_BAL not in", values, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEBIT_BAL between", value1, value2, "debitBal");
            return (Criteria) this;
        }

        public Criteria andDebitBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEBIT_BAL not between", value1, value2, "debitBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalIsNull() {
            addCriterion("CREDIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andCreditBalIsNotNull() {
            addCriterion("CREDIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andCreditBalEqualTo(BigDecimal value) {
            addCriterion("CREDIT_BAL =", value, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalNotEqualTo(BigDecimal value) {
            addCriterion("CREDIT_BAL <>", value, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalGreaterThan(BigDecimal value) {
            addCriterion("CREDIT_BAL >", value, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CREDIT_BAL >=", value, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalLessThan(BigDecimal value) {
            addCriterion("CREDIT_BAL <", value, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CREDIT_BAL <=", value, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalIn(List<BigDecimal> values) {
            addCriterion("CREDIT_BAL in", values, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalNotIn(List<BigDecimal> values) {
            addCriterion("CREDIT_BAL not in", values, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CREDIT_BAL between", value1, value2, "creditBal");
            return (Criteria) this;
        }

        public Criteria andCreditBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CREDIT_BAL not between", value1, value2, "creditBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalIsNull() {
            addCriterion("YEAR_DEBIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalIsNotNull() {
            addCriterion("YEAR_DEBIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_BAL =", value, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalNotEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_BAL <>", value, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalGreaterThan(BigDecimal value) {
            addCriterion("YEAR_DEBIT_BAL >", value, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_BAL >=", value, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalLessThan(BigDecimal value) {
            addCriterion("YEAR_DEBIT_BAL <", value, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_BAL <=", value, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalIn(List<BigDecimal> values) {
            addCriterion("YEAR_DEBIT_BAL in", values, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalNotIn(List<BigDecimal> values) {
            addCriterion("YEAR_DEBIT_BAL not in", values, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_DEBIT_BAL between", value1, value2, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearDebitBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_DEBIT_BAL not between", value1, value2, "yearDebitBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalIsNull() {
            addCriterion("YEAR_CREDIT_BAL is null");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalIsNotNull() {
            addCriterion("YEAR_CREDIT_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_BAL =", value, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalNotEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_BAL <>", value, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalGreaterThan(BigDecimal value) {
            addCriterion("YEAR_CREDIT_BAL >", value, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_BAL >=", value, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalLessThan(BigDecimal value) {
            addCriterion("YEAR_CREDIT_BAL <", value, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_BAL <=", value, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalIn(List<BigDecimal> values) {
            addCriterion("YEAR_CREDIT_BAL in", values, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalNotIn(List<BigDecimal> values) {
            addCriterion("YEAR_CREDIT_BAL not in", values, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CREDIT_BAL between", value1, value2, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andYearCreditBalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CREDIT_BAL not between", value1, value2, "yearCreditBal");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitIsNull() {
            addCriterion("CARRYOVER_DEBIT is null");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitIsNotNull() {
            addCriterion("CARRYOVER_DEBIT is not null");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_DEBIT =", value, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitNotEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_DEBIT <>", value, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitGreaterThan(BigDecimal value) {
            addCriterion("CARRYOVER_DEBIT >", value, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_DEBIT >=", value, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitLessThan(BigDecimal value) {
            addCriterion("CARRYOVER_DEBIT <", value, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_DEBIT <=", value, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitIn(List<BigDecimal> values) {
            addCriterion("CARRYOVER_DEBIT in", values, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitNotIn(List<BigDecimal> values) {
            addCriterion("CARRYOVER_DEBIT not in", values, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYOVER_DEBIT between", value1, value2, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverDebitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYOVER_DEBIT not between", value1, value2, "carryoverDebit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditIsNull() {
            addCriterion("CARRYOVER_CREDIT is null");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditIsNotNull() {
            addCriterion("CARRYOVER_CREDIT is not null");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_CREDIT =", value, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditNotEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_CREDIT <>", value, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditGreaterThan(BigDecimal value) {
            addCriterion("CARRYOVER_CREDIT >", value, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_CREDIT >=", value, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditLessThan(BigDecimal value) {
            addCriterion("CARRYOVER_CREDIT <", value, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYOVER_CREDIT <=", value, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditIn(List<BigDecimal> values) {
            addCriterion("CARRYOVER_CREDIT in", values, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditNotIn(List<BigDecimal> values) {
            addCriterion("CARRYOVER_CREDIT not in", values, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYOVER_CREDIT between", value1, value2, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andCarryoverCreditNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYOVER_CREDIT not between", value1, value2, "carryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitIsNull() {
            addCriterion("YEAR_CARRYOVER_DEBIT is null");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitIsNotNull() {
            addCriterion("YEAR_CARRYOVER_DEBIT is not null");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_DEBIT =", value, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitNotEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_DEBIT <>", value, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitGreaterThan(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_DEBIT >", value, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_DEBIT >=", value, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitLessThan(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_DEBIT <", value, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_DEBIT <=", value, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitIn(List<BigDecimal> values) {
            addCriterion("YEAR_CARRYOVER_DEBIT in", values, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitNotIn(List<BigDecimal> values) {
            addCriterion("YEAR_CARRYOVER_DEBIT not in", values, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CARRYOVER_DEBIT between", value1, value2, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverDebitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CARRYOVER_DEBIT not between", value1, value2, "yearCarryoverDebit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditIsNull() {
            addCriterion("YEAR_CARRYOVER_CREDIT is null");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditIsNotNull() {
            addCriterion("YEAR_CARRYOVER_CREDIT is not null");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_CREDIT =", value, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditNotEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_CREDIT <>", value, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditGreaterThan(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_CREDIT >", value, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_CREDIT >=", value, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditLessThan(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_CREDIT <", value, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CARRYOVER_CREDIT <=", value, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditIn(List<BigDecimal> values) {
            addCriterion("YEAR_CARRYOVER_CREDIT in", values, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditNotIn(List<BigDecimal> values) {
            addCriterion("YEAR_CARRYOVER_CREDIT not in", values, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CARRYOVER_CREDIT between", value1, value2, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andYearCarryoverCreditNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CARRYOVER_CREDIT not between", value1, value2, "yearCarryoverCredit");
            return (Criteria) this;
        }

        public Criteria andDebitNetIsNull() {
            addCriterion("DEBIT_NET is null");
            return (Criteria) this;
        }

        public Criteria andDebitNetIsNotNull() {
            addCriterion("DEBIT_NET is not null");
            return (Criteria) this;
        }

        public Criteria andDebitNetEqualTo(BigDecimal value) {
            addCriterion("DEBIT_NET =", value, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetNotEqualTo(BigDecimal value) {
            addCriterion("DEBIT_NET <>", value, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetGreaterThan(BigDecimal value) {
            addCriterion("DEBIT_NET >", value, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DEBIT_NET >=", value, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetLessThan(BigDecimal value) {
            addCriterion("DEBIT_NET <", value, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DEBIT_NET <=", value, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetIn(List<BigDecimal> values) {
            addCriterion("DEBIT_NET in", values, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetNotIn(List<BigDecimal> values) {
            addCriterion("DEBIT_NET not in", values, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEBIT_NET between", value1, value2, "debitNet");
            return (Criteria) this;
        }

        public Criteria andDebitNetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEBIT_NET not between", value1, value2, "debitNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetIsNull() {
            addCriterion("CREDIT_NET is null");
            return (Criteria) this;
        }

        public Criteria andCreditNetIsNotNull() {
            addCriterion("CREDIT_NET is not null");
            return (Criteria) this;
        }

        public Criteria andCreditNetEqualTo(BigDecimal value) {
            addCriterion("CREDIT_NET =", value, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetNotEqualTo(BigDecimal value) {
            addCriterion("CREDIT_NET <>", value, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetGreaterThan(BigDecimal value) {
            addCriterion("CREDIT_NET >", value, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CREDIT_NET >=", value, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetLessThan(BigDecimal value) {
            addCriterion("CREDIT_NET <", value, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CREDIT_NET <=", value, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetIn(List<BigDecimal> values) {
            addCriterion("CREDIT_NET in", values, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetNotIn(List<BigDecimal> values) {
            addCriterion("CREDIT_NET not in", values, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CREDIT_NET between", value1, value2, "creditNet");
            return (Criteria) this;
        }

        public Criteria andCreditNetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CREDIT_NET not between", value1, value2, "creditNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetIsNull() {
            addCriterion("YEAR_DEBIT_NET is null");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetIsNotNull() {
            addCriterion("YEAR_DEBIT_NET is not null");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_NET =", value, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetNotEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_NET <>", value, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetGreaterThan(BigDecimal value) {
            addCriterion("YEAR_DEBIT_NET >", value, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_NET >=", value, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetLessThan(BigDecimal value) {
            addCriterion("YEAR_DEBIT_NET <", value, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_DEBIT_NET <=", value, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetIn(List<BigDecimal> values) {
            addCriterion("YEAR_DEBIT_NET in", values, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetNotIn(List<BigDecimal> values) {
            addCriterion("YEAR_DEBIT_NET not in", values, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_DEBIT_NET between", value1, value2, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearDebitNetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_DEBIT_NET not between", value1, value2, "yearDebitNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetIsNull() {
            addCriterion("YEAR_CREDIT_NET is null");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetIsNotNull() {
            addCriterion("YEAR_CREDIT_NET is not null");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_NET =", value, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetNotEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_NET <>", value, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetGreaterThan(BigDecimal value) {
            addCriterion("YEAR_CREDIT_NET >", value, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_NET >=", value, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetLessThan(BigDecimal value) {
            addCriterion("YEAR_CREDIT_NET <", value, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YEAR_CREDIT_NET <=", value, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetIn(List<BigDecimal> values) {
            addCriterion("YEAR_CREDIT_NET in", values, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetNotIn(List<BigDecimal> values) {
            addCriterion("YEAR_CREDIT_NET not in", values, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CREDIT_NET between", value1, value2, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andYearCreditNetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YEAR_CREDIT_NET not between", value1, value2, "yearCreditNet");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andSubPropIsNull() {
            addCriterion("SUB_PROP is null");
            return (Criteria) this;
        }

        public Criteria andSubPropIsNotNull() {
            addCriterion("SUB_PROP is not null");
            return (Criteria) this;
        }

        public Criteria andSubPropEqualTo(Integer value) {
            addCriterion("SUB_PROP =", value, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropNotEqualTo(Integer value) {
            addCriterion("SUB_PROP <>", value, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropGreaterThan(Integer value) {
            addCriterion("SUB_PROP >", value, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropGreaterThanOrEqualTo(Integer value) {
            addCriterion("SUB_PROP >=", value, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropLessThan(Integer value) {
            addCriterion("SUB_PROP <", value, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropLessThanOrEqualTo(Integer value) {
            addCriterion("SUB_PROP <=", value, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropIn(List<Integer> values) {
            addCriterion("SUB_PROP in", values, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropNotIn(List<Integer> values) {
            addCriterion("SUB_PROP not in", values, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropBetween(Integer value1, Integer value2) {
            addCriterion("SUB_PROP between", value1, value2, "subProp");
            return (Criteria) this;
        }

        public Criteria andSubPropNotBetween(Integer value1, Integer value2) {
            addCriterion("SUB_PROP not between", value1, value2, "subProp");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table TAX_PROJECT.BALANCE_STD
     *
     * @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 TAX_PROJECT.BALANCE_STD
     *
     * @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);
        }
    }
}