<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: lgc5900  
    $Date: 2015年12月28日 上午10:55:55  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="CON_VISIT_REPORT_LNS_T_LV">
    <bm:fields>
        <bm:field name="visit_report_ln_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VISIT_REPORT_LN_ID" prompt="CON_VISIT_REPORT_LNS_T_LV.VISIT_REPORT_LN_ID"/>
        <bm:field name="visit_report_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VISIT_REPORT_ID" prompt="CON_VISIT_REPORT_LNS_T_LV.VISIT_REPORT_ID"/>
        <bm:field name="object_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OBJECT_TYPE" prompt="CON_VISIT_REPORT_LNS_T_LV.OBJECT_TYPE"/>
        <bm:field name="object_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OBJECT_ID" prompt="CON_VISIT_REPORT_LNS_T_LV.OBJECT_ID"/>
        <bm:field name="visit_result_desc" databaseType="CLOB" datatype="java.sql.Clob" physicalName="VISIT_RESULT_DESC" prompt="CON_VISIT_REPORT_LNS_T_LV.VISIT_RESULT_DESC"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="CON_VISIT_REPORT_LNS_T_LV.CONTRACT_ID"/>
        <bm:field name="contract_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_ID_N" prompt="CON_VISIT_REPORT_LNS_T_LV.CONTRACT_ID_N"/>
        <bm:field name="guarantee_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="GUARANTEE_AMOUNT" prompt="CON_VISIT_REPORT_LNS_T_LV.GUARANTEE_AMOUNT"/>
        <bm:field name="collection_interest" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COLLECTION_INTEREST" prompt="CON_VISIT_REPORT_LNS_T_LV.COLLECTION_INTEREST"/>
        <bm:field name="other" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OTHER" prompt="CON_VISIT_REPORT_LNS_T_LV.OTHER"/>
        <bm:field name="lease_item_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_ITEM_AMOUNT" prompt="CON_VISIT_REPORT_LNS_T_LV.LEASE_ITEM_AMOUNT"/>
        <bm:field name="lease_term" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_TERM" prompt="CON_VISIT_REPORT_LNS_T_LV.LEASE_TERM"/>
        <bm:field name="overdue_max_days" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OVERDUE_MAX_DAYS" prompt="CON_VISIT_REPORT_LNS_T_LV.OVERDUE_MAX_DAYS"/>
        <bm:field name="overdue_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OVERDUE_AMOUNT" prompt="CON_VISIT_REPORT_LNS_T_LV.OVERDUE_AMOUNT"/>
        <bm:field name="overdue_interest" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OVERDUE_INTEREST" prompt="CON_VISIT_REPORT_LNS_T_LV.OVERDUE_INTEREST"/>
        <bm:field name="tenant_v_amount" databaseType="VARCHAR2" datatype="java.lang.String" expression="to_char(t1.tenant_v_amount,&apos;FM999,999,999,990.00&apos;)" physicalName="TENANT_V_AMOUNT" prompt="CON_VISIT_REPORT_LNS_T_LV.TENANT_V_AMOUNT"/>
        <bm:field name="change_reason_t" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CHANGE_REASON_T" prompt="CON_VISIT_REPORT_LNS_T_LV.CHANGE_REASON_T"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:data-filters>
        <bm:data-filter expression="t1.visit_report_id=${@visit_report_id}"/>
    </bm:data-filters>
</bm:model>
