package pwc.taxtech.atms.vat.entity;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andCustomerCodeIsNull() {
            addCriterion("CustomerCode is null");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIsNotNull() {
            addCriterion("CustomerCode is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeEqualTo(String value) {
            addCriterion("CustomerCode =", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotEqualTo(String value) {
            addCriterion("CustomerCode <>", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeGreaterThan(String value) {
            addCriterion("CustomerCode >", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CustomerCode >=", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLessThan(String value) {
            addCriterion("CustomerCode <", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLessThanOrEqualTo(String value) {
            addCriterion("CustomerCode <=", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLike(String value) {
            addCriterion("CustomerCode like", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotLike(String value) {
            addCriterion("CustomerCode not like", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIn(List<String> values) {
            addCriterion("CustomerCode in", values, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotIn(List<String> values) {
            addCriterion("CustomerCode not in", values, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeBetween(String value1, String value2) {
            addCriterion("CustomerCode between", value1, value2, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotBetween(String value1, String value2) {
            addCriterion("CustomerCode not between", value1, value2, "customerCode");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andMonthIdIsNull() {
            addCriterion("MonthId is null");
            return (Criteria) this;
        }

        public Criteria andMonthIdIsNotNull() {
            addCriterion("MonthId is not null");
            return (Criteria) this;
        }

        public Criteria andMonthIdEqualTo(Integer value) {
            addCriterion("MonthId =", value, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdNotEqualTo(Integer value) {
            addCriterion("MonthId <>", value, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdGreaterThan(Integer value) {
            addCriterion("MonthId >", value, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("MonthId >=", value, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdLessThan(Integer value) {
            addCriterion("MonthId <", value, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdLessThanOrEqualTo(Integer value) {
            addCriterion("MonthId <=", value, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdIn(List<Integer> values) {
            addCriterion("MonthId in", values, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdNotIn(List<Integer> values) {
            addCriterion("MonthId not in", values, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdBetween(Integer value1, Integer value2) {
            addCriterion("MonthId between", value1, value2, "monthId");
            return (Criteria) this;
        }

        public Criteria andMonthIdNotBetween(Integer value1, Integer value2) {
            addCriterion("MonthId not between", value1, value2, "monthId");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andStdCodeIsNull() {
            addCriterion("StdCode is null");
            return (Criteria) this;
        }

        public Criteria andStdCodeIsNotNull() {
            addCriterion("StdCode is not null");
            return (Criteria) this;
        }

        public Criteria andStdCodeEqualTo(String value) {
            addCriterion("StdCode =", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeNotEqualTo(String value) {
            addCriterion("StdCode <>", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeGreaterThan(String value) {
            addCriterion("StdCode >", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeGreaterThanOrEqualTo(String value) {
            addCriterion("StdCode >=", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeLessThan(String value) {
            addCriterion("StdCode <", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeLessThanOrEqualTo(String value) {
            addCriterion("StdCode <=", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeLike(String value) {
            addCriterion("StdCode like", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeNotLike(String value) {
            addCriterion("StdCode not like", value, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeIn(List<String> values) {
            addCriterion("StdCode in", values, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeNotIn(List<String> values) {
            addCriterion("StdCode not in", values, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeBetween(String value1, String value2) {
            addCriterion("StdCode between", value1, value2, "stdCode");
            return (Criteria) this;
        }

        public Criteria andStdCodeNotBetween(String value1, String value2) {
            addCriterion("StdCode not between", value1, value2, "stdCode");
            return (Criteria) this;
        }

        public Criteria andMappingReasonIsNull() {
            addCriterion("MappingReason is null");
            return (Criteria) this;
        }

        public Criteria andMappingReasonIsNotNull() {
            addCriterion("MappingReason is not null");
            return (Criteria) this;
        }

        public Criteria andMappingReasonEqualTo(String value) {
            addCriterion("MappingReason =", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonNotEqualTo(String value) {
            addCriterion("MappingReason <>", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonGreaterThan(String value) {
            addCriterion("MappingReason >", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonGreaterThanOrEqualTo(String value) {
            addCriterion("MappingReason >=", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonLessThan(String value) {
            addCriterion("MappingReason <", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonLessThanOrEqualTo(String value) {
            addCriterion("MappingReason <=", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonLike(String value) {
            addCriterion("MappingReason like", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonNotLike(String value) {
            addCriterion("MappingReason not like", value, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonIn(List<String> values) {
            addCriterion("MappingReason in", values, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonNotIn(List<String> values) {
            addCriterion("MappingReason not in", values, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonBetween(String value1, String value2) {
            addCriterion("MappingReason between", value1, value2, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingReasonNotBetween(String value1, String value2) {
            addCriterion("MappingReason not between", value1, value2, "mappingReason");
            return (Criteria) this;
        }

        public Criteria andMappingUserIsNull() {
            addCriterion("MappingUser is null");
            return (Criteria) this;
        }

        public Criteria andMappingUserIsNotNull() {
            addCriterion("MappingUser is not null");
            return (Criteria) this;
        }

        public Criteria andMappingUserEqualTo(String value) {
            addCriterion("MappingUser =", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserNotEqualTo(String value) {
            addCriterion("MappingUser <>", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserGreaterThan(String value) {
            addCriterion("MappingUser >", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserGreaterThanOrEqualTo(String value) {
            addCriterion("MappingUser >=", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserLessThan(String value) {
            addCriterion("MappingUser <", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserLessThanOrEqualTo(String value) {
            addCriterion("MappingUser <=", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserLike(String value) {
            addCriterion("MappingUser like", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserNotLike(String value) {
            addCriterion("MappingUser not like", value, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserIn(List<String> values) {
            addCriterion("MappingUser in", values, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserNotIn(List<String> values) {
            addCriterion("MappingUser not in", values, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserBetween(String value1, String value2) {
            addCriterion("MappingUser between", value1, value2, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingUserNotBetween(String value1, String value2) {
            addCriterion("MappingUser not between", value1, value2, "mappingUser");
            return (Criteria) this;
        }

        public Criteria andMappingTimeIsNull() {
            addCriterion("MappingTime is null");
            return (Criteria) this;
        }

        public Criteria andMappingTimeIsNotNull() {
            addCriterion("MappingTime is not null");
            return (Criteria) this;
        }

        public Criteria andMappingTimeEqualTo(Date value) {
            addCriterion("MappingTime =", value, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeNotEqualTo(Date value) {
            addCriterion("MappingTime <>", value, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeGreaterThan(Date value) {
            addCriterion("MappingTime >", value, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("MappingTime >=", value, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeLessThan(Date value) {
            addCriterion("MappingTime <", value, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeLessThanOrEqualTo(Date value) {
            addCriterion("MappingTime <=", value, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeIn(List<Date> values) {
            addCriterion("MappingTime in", values, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeNotIn(List<Date> values) {
            addCriterion("MappingTime not in", values, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeBetween(Date value1, Date value2) {
            addCriterion("MappingTime between", value1, value2, "mappingTime");
            return (Criteria) this;
        }

        public Criteria andMappingTimeNotBetween(Date value1, Date value2) {
            addCriterion("MappingTime not between", value1, value2, "mappingTime");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andIsDummyIsNull() {
            addCriterion("IsDummy is null");
            return (Criteria) this;
        }

        public Criteria andIsDummyIsNotNull() {
            addCriterion("IsDummy is not null");
            return (Criteria) this;
        }

        public Criteria andIsDummyEqualTo(Integer value) {
            addCriterion("IsDummy =", value, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyNotEqualTo(Integer value) {
            addCriterion("IsDummy <>", value, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyGreaterThan(Integer value) {
            addCriterion("IsDummy >", value, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyGreaterThanOrEqualTo(Integer value) {
            addCriterion("IsDummy >=", value, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyLessThan(Integer value) {
            addCriterion("IsDummy <", value, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyLessThanOrEqualTo(Integer value) {
            addCriterion("IsDummy <=", value, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyIn(List<Integer> values) {
            addCriterion("IsDummy in", values, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyNotIn(List<Integer> values) {
            addCriterion("IsDummy not in", values, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyBetween(Integer value1, Integer value2) {
            addCriterion("IsDummy between", value1, value2, "isDummy");
            return (Criteria) this;
        }

        public Criteria andIsDummyNotBetween(Integer value1, Integer value2) {
            addCriterion("IsDummy not between", value1, value2, "isDummy");
            return (Criteria) this;
        }
    }

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