<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Clocc  
    $Date: 2015-8-24 上午10:56:15  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="CUS_RPT_CON640_O_LV">
    <bm:fields>
        <bm:field name="control_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTROL_ID" prompt="CUS_RPT_CON640_O_LV.CONTROL_ID"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="CUS_RPT_CON640_O_LV.CONTRACT_ID"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="CUS_RPT_CON640_O_LV.CONTRACT_NUMBER"/>
        <bm:field name="contract_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NAME" prompt="CUS_RPT_CON640_O_LV.CONTRACT_NAME"/>
        <bm:field name="search_term_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEARCH_TERM_1" prompt="CUS_RPT_CON640_O_LV.SEARCH_TERM_1"/>
        <bm:field name="bp_id_tenant" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_TENANT" prompt="CUS_RPT_CON640_O_LV.BP_ID_TENANT"/>
        <bm:field name="bp_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_TENANT_N" prompt="CUS_RPT_CON640_O_LV.BP_ID_TENANT_N"/>
        <bm:field name="division" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION" prompt="CUS_RPT_CON640_O_LV.DIVISION"/>
        <bm:field name="division_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION_N" prompt="CUS_RPT_CON640_O_LV.DIVISION_N"/>
        <bm:field name="serial_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SERIAL_NUMBER" prompt="CUS_RPT_CON640_O_LV.SERIAL_NUMBER"/>
        <bm:field name="direct_debit_bank_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIRECT_DEBIT_BANK_ID_N" prompt="CUS_RPT_CON640_O_LV.DIRECT_DEBIT_BANK_ID_N"/>
        <bm:field name="dd_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_ACCOUNT_NUM" prompt="CUS_RPT_CON640_O_LV.DD_BANK_ACCOUNT_NUM"/>
        <bm:field name="inception_of_lease" databaseType="DATE" datatype="java.util.Date" physicalName="INCEPTION_OF_LEASE" prompt="CUS_RPT_CON640_O_LV.INCEPTION_OF_LEASE"/>
        <bm:field name="cf_end_date" databaseType="DATE" datatype="java.util.Date" physicalName="CF_END_DATE" prompt="CUS_RPT_CON640_O_LV.CF_END_DATE"/>
        <bm:field name="due_amount_all" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DUE_AMOUNT_ALL" prompt="CUS_RPT_CON640_O_LV.DUE_AMOUNT_ALL"/>
        <bm:field name="due_amount_current" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT_CURRENT" prompt="CUS_RPT_CON640_O_LV.DUE_AMOUNT_CURRENT"/>
        <bm:field name="due_amount_old" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT_OLD" prompt="CUS_RPT_CON640_O_LV.DUE_AMOUNT_OLD"/>
        <bm:field name="due_amount_now" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT_NOW" prompt="CUS_RPT_CON640_O_LV.DUE_AMOUNT_NOW"/>
        <bm:field name="penalty_1" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PENALTY_1" prompt="CUS_RPT_CON640_O_LV.PENALTY_1"/>
        <bm:field name="penalty_sum" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PENALTY_SUM" prompt="CUS_RPT_CON640_O_LV.PENALTY_SUM"/>
        <bm:field name="lease_mgt_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_MGT_FEE" prompt="CUS_RPT_CON640_O_LV.LEASE_MGT_FEE"/>
        <bm:field name="lease_charge" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_CHARGE" prompt="CUS_RPT_CON640_O_LV.LEASE_CHARGE"/>
        <bm:field name="deposit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DEPOSIT" prompt="CUS_RPT_CON640_O_LV.DEPOSIT"/>
        <bm:field name="insurance_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INSURANCE_FEE" prompt="CUS_RPT_CON640_O_LV.INSURANCE_FEE"/>
        <bm:field name="notarial_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NOTARIAL_FEE" prompt="CUS_RPT_CON640_O_LV.NOTARIAL_FEE"/>
        <bm:field name="legal_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEGAL_FEE" prompt="CUS_RPT_CON640_O_LV.LEGAL_FEE"/>
        <bm:field name="contract_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_STATUS_N" prompt="CUS_RPT_CON640_O_LV.CONTRACT_STATUS_N"/>
        <bm:field name="ar_description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AR_DESCRIPTION" prompt="CUS_RPT_CON640_O_LV.AR_DESCRIPTION"/>
        <bm:field name="due_date" databaseType="DATE" datatype="java.util.Date" physicalName="DUE_DATE" prompt="CUS_RPT_CON640_O_LV.DUE_DATE"/>
        <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="CUS_RPT_CON640_O_LV.COMPANY_ID"/>
        <bm:field name="company_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_ID_N" prompt="CUS_RPT_CON640_O_LV.COMPANY_ID_N"/>
        <bm:field name="contract_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_STATUS" prompt="CUS_RPT_CON640_O_LV.CONTRACT_STATUS"/>
        <bm:field name="legal_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEGAL_STATUS" prompt="CUS_RPT_CON640_O_LV.LEGAL_STATUS"/>
        <bm:field name="legal_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEGAL_STATUS_N" prompt="CUS_RPT_CON640_O_LV.LEGAL_STATUS_N"/>
        <bm:field name="collector_user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COLLECTOR_USER_ID" prompt="CUS_RPT_CON640_O_LV.COLLECTOR_USER_ID"/>
        <bm:field name="collector_user_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLLECTOR_USER_ID_N" prompt="CUS_RPT_CON640_O_LV.COLLECTOR_USER_ID_N"/>
        <bm:field name="reschedule_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESCHEDULE_FLAG" prompt="CUS_RPT_CON640_O_LV.RESCHEDULE_FLAG"/>
        <bm:field name="et_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ET_FLAG" prompt="CUS_RPT_CON640_O_LV.ET_FLAG"/>
        <bm:field name="tenant_change_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TENANT_CHANGE_FLAG" prompt="CUS_RPT_CON640_O_LV.TENANT_CHANGE_FLAG"/>
        <bm:field name="bank_acc_change_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_ACC_CHANGE_FLAG" prompt="CUS_RPT_CON640_O_LV.BANK_ACC_CHANGE_FLAG"/>
        <bm:field name="lease_item_change_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_ITEM_CHANGE_FLAG" prompt="CUS_RPT_CON640_O_LV.LEASE_ITEM_CHANGE_FLAG"/>
        <bm:field name="mortgage_change_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_CHANGE_FLAG" prompt="CUS_RPT_CON640_O_LV.MORTGAGE_CHANGE_FLAG"/>
        <bm:field name="guarantor_change_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTOR_CHANGE_FLAG" prompt="CUS_RPT_CON640_O_LV.GUARANTOR_CHANGE_FLAG"/>
        <bm:field name="contract_cancel_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_CANCEL_FLAG" prompt="CUS_RPT_CON640_O_LV.CONTRACT_CANCEL_FLAG"/>
        <bm:field name="cashflow_change_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CASHFLOW_CHANGE_FLAG" prompt="CUS_RPT_CON640_O_LV.CASHFLOW_CHANGE_FLAG"/>
        <bm:field name="machine_law_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="MACHINE_LAW_FEE" prompt="CUS_RPT_CON640_O_LV.MACHINE_LAW_FEE"/>
        <bm:field name="third_lease_mgt_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="THIRD_LEASE_MGT_FEE" prompt="CUS_RPT_CON640_O_LV.THIRD_LEASE_MGT_FEE"/>
        <bm:field name="contract_change_counter_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="CONTRACT_CHANGE_COUNTER_FEE" prompt="CUS_RPT_CON640_O_LV.CONTRACT_CHANGE_COUNTER_FEE"/>
        <bm:field name="specification" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SPECIFICATION" prompt="CUS_RPT_CON640_O_LV.SPECIFICATION"/>
        <bm:field name="with_holding_bank_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITH_HOLDING_BANK_NAME" prompt="CUS_RPT_CON640_O_LV.WITH_HOLDING_BANK_NAME"/>
        <bm:field name="due_amount_month" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT_MONTH" prompt="CUS_RPT_CON640_O_LV.DUE_AMOUNT_MONTH"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:query-fields>
        <bm:query-field field="contract_number" queryOperator="like"/>
        <bm:query-field field="division_n" queryOperator="like"/>
        <bm:query-field field="contract_name" queryOperator="like"/>
        <bm:query-field field="search_term_1" queryOperator="like"/>
        <bm:query-field field="serial_number" queryOperator="like"/>
        <bm:query-field field="contract_status_n" queryOperator="like"/>
        <bm:query-field field="legal_status" queryOperator="like"/>
        <bm:query-field field="collector_user_id_n" queryOperator="like"/>
        <bm:query-field field="company_id_n" queryOperator="like"/>
        <bm:query-field name="due_date_from" queryExpression="t1.due_date &gt;= to_date(${@due_date},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="due_date_to" queryExpression="t1.due_date &lt;= to_date(${@due_date},&apos;yyyy-mm-dd&apos;)"/>
    </bm:query-fields>
    <bm:data-filters>
        <bm:data-filter name="init" enforceOperations="query" expression="t1.control_id=${@control_id}"/>
    </bm:data-filters>
</bm:model>
