<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="HLS_BP_MASTER_MORTGAGE_HOUSE_V">
    <bm:fields>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.CONTRACT_ID"/>
        <!-- <bm:field name="mortgage_seq" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MORTGAGE_SEQ" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.MORTGAGE_SEQ"/> -->
        <bm:field name="mortgage_seq" expression="(rownum)"/>
        <bm:field name="mortgage_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_NAME" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.MORTGAGE_NAME"/>
        <bm:field name="estate_license_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ESTATE_LICENSE_CODE" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.ESTATE_LICENSE_CODE"/>
        <bm:field name="construction_area" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONSTRUCTION_AREA" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.CONSTRUCTION_AREA"/>
        <bm:field name="building_structure" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUILDING_STRUCTURE" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.BUILDING_STRUCTURE"/>
        <!-- <bm:field name="total_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TOTAL_VALUE" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.TOTAL_VALUE"/> -->
        <bm:field name="mortgage_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_INSURANCE" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.MORTGAGE_INSURANCE"/>
        <bm:field name="house_location" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HOUSE_LOCATION" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.HOUSE_LOCATION"/>
        <bm:field name="mortgagor_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGOR_NAME" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.MORTGAGOR_NAME"/>
        <bm:field name="evaluator_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EVALUATOR_NAME" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.EVALUATOR_NAME"/>
        <bm:field name="evaluator_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EVALUATOR_NUMBER" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.EVALUATOR_NUMBER"/>
        <bm:field name="total_value" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TOTAL_VALUE" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.TOTAL_VALUE"/>
        <bm:field name="total_value_rmb" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TOTAL_VALUE_RMB" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.TOTAL_VALUE_RMB"/>
        <bm:field name="fair_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FAIR_VALUE" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.FAIR_VALUE"/>
        <bm:field name="value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VALUE" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.VALUE"/>
        <bm:field name="company_name_stock" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_NAME_STOCK" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.COMPANY_NAME_STOCK"/>
        <bm:field name="stock_ratio" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STOCK_RATIO" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.STOCK_RATIO"/>
        <bm:field name="value_rmb" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VALUE_RMB" prompt="HLS_BP_MASTER_MORTGAGE_HOUSE_V.VALUE_RMB"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
</bm:model>
