CustBalanceExample.java

package pwc.taxtech.atms.vat.entity;

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

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

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

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

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

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT.CUST_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 TAX_PROJECT.CUST_BALANCE
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT.CUST_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 TAX_PROJECT.CUST_BALANCE
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

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

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT.CUST_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 TAX_PROJECT.CUST_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 TAX_PROJECT.CUST_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 TAX_PROJECT.CUST_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 TAX_PROJECT.CUST_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 TAX_PROJECT.CUST_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("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(Long value) {
            addCriterion("PERIOD_ID =", value, "periodId");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

        public Criteria andPeriodIdNotBetween(Long value1, Long 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 andCustomerCodeIsNull() {
            addCriterion("CUSTOMER_CODE is null");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andCustomerCodeNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_CODE not between", value1, value2, "customerCode");
            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 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 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 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 andMonthIdIsNull() {
            addCriterion("MONTH_ID is null");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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