<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="CON_CONTRACT_MORTGAGE">
    <bm:fields>
        <bm:field name="con_mortgage_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CON_MORTGAGE_ID" prompt="CON_CONTRACT_MORTGAGE.CON_MORTGAGE_ID"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="CON_CONTRACT_MORTGAGE.CONTRACT_ID"/>
        <bm:field name="mortgage_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MORTGAGE_ID" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_ID"/>
        <bm:field name="mortgage_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_CODE" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_CODE"/>
        <bm:field name="mortgage_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_NAME" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_NAME"/>
        <bm:field name="mortgage_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_TYPE" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_TYPE"/>
        <bm:field name="mortgage_type_n" expression="(select v.code_value_name from sys_code_values_v v where v.code = &apos;HLS209_MORTGAGE_TYPE&apos; and v.code_value = t1.MORTGAGE_TYPE and v.code_enabled_flag = &apos;Y&apos; AND v.code_value_enabled_flag = &apos;Y&apos; )" forInsert="false" forUpdate="false"/>
        <bm:field name="mortgage_ast_classfication" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_AST_CLASSFICATION" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_AST_CLASSFICATION"/>
        <bm:field name="mortgage_ast_classfication_n" expression="(select v.code_value_name from sys_code_values_v v where v.code in (&apos;HLS209_ASSET_MORTGAGE&apos;,&apos;HLS209_ASSET_PLEDGE&apos;) and v.code_value=t1.mortgage_ast_classfication and v.code_enabled_flag=&apos;Y&apos;)" forInsert="false" forUpdate="false"/>
        <bm:field name="mortgage_asset_detail" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_ASSET_DETAIL" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_ASSET_DETAIL"/>
        <bm:field name="mortgage_asset_detail_n" expression="(select v.code_value_name from sys_code_values_v v where v.code =&apos;CON_CONTRACT_ASSET_DETAIL&apos; and v.code_value=t1.mortgage_asset_detail and v.code_enabled_flag=&apos;Y&apos;)" forInsert="false" forUpdate="false"/>
        <bm:field name="mortgage_contract_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_CONTRACT_NO" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_CONTRACT_NO"/>
        <bm:field name="mortgage_register_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_REGISTER_NO" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_REGISTER_NO"/>
        <bm:field name="mortgage_registed_dept" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_REGISTED_DEPT" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_REGISTED_DEPT"/>
        <bm:field name="bp_id_mortgagor" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_MORTGAGOR" prompt="CON_CONTRACT_MORTGAGE.BP_ID_MORTGAGOR"/>
        <bm:field name="mortgagor_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGOR_NAME" prompt="CON_CONTRACT_MORTGAGE.MORTGAGOR_NAME"/>
        <bm:field name="value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VALUE" prompt="CON_CONTRACT_MORTGAGE.VALUE"/>
        <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="CON_CONTRACT_MORTGAGE.CURRENCY"/>
        <bm:field name="uom" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UOM" prompt="CON_CONTRACT_MORTGAGE.UOM"/>
        <bm:field name="quantity" databaseType="NUMBER" datatype="java.lang.Long" physicalName="QUANTITY" prompt="CON_CONTRACT_MORTGAGE.QUANTITY"/>
        <bm:field name="start_date" databaseType="DATE" datatype="java.util.Date" physicalName="START_DATE" prompt="CON_CONTRACT_MORTGAGE.START_DATE"/>
        <bm:field name="end_date" databaseType="DATE" datatype="java.util.Date" physicalName="END_DATE" prompt="CON_CONTRACT_MORTGAGE.END_DATE"/>
        <bm:field name="bp_id_evaluator" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_EVALUATOR" prompt="CON_CONTRACT_MORTGAGE.BP_ID_EVALUATOR"/>
        <bm:field name="bp_id_mortgagor_n" expression="(select hbm.bp_name from hls_bp_master hbm where hbm.bp_id=t1.bp_id_mortgagor and hbm.enabled_flag=&apos;Y&apos;)" forInsert="false" forUpdate="false"/>
        <bm:field name="evaluator_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EVALUATOR_NAME" prompt="CON_CONTRACT_MORTGAGE.EVALUATOR_NAME"/>
        <bm:field name="ownership" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNERSHIP" prompt="CON_CONTRACT_MORTGAGE.OWNERSHIP"/>
        <bm:field name="occupied" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OCCUPIED" prompt="CON_CONTRACT_MORTGAGE.OCCUPIED"/>
        <bm:field name="location" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOCATION" prompt="CON_CONTRACT_MORTGAGE.LOCATION"/>
        <bm:field name="estate_license_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ESTATE_LICENSE_CODE" prompt="CON_CONTRACT_MORTGAGE.ESTATE_LICENSE_CODE"/>
        <bm:field name="housing_area" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HOUSING_AREA" prompt="CON_CONTRACT_MORTGAGE.HOUSING_AREA"/>
        <bm:field name="use" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USE" prompt="CON_CONTRACT_MORTGAGE.USE"/>
        <bm:field name="construction_date" databaseType="DATE" datatype="java.util.Date" physicalName="CONSTRUCTION_DATE" prompt="CON_CONTRACT_MORTGAGE.CONSTRUCTION_DATE"/>
        <bm:field name="building_structure" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUILDING_STRUCTURE" prompt="CON_CONTRACT_MORTGAGE.BUILDING_STRUCTURE"/>
        <bm:field name="land_certificate_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_CERTIFICATE_CODE" prompt="CON_CONTRACT_MORTGAGE.LAND_CERTIFICATE_CODE"/>
        <bm:field name="land_area" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAND_AREA" prompt="CON_CONTRACT_MORTGAGE.LAND_AREA"/>
        <bm:field name="land_use_rights_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_USE_RIGHTS_TYPE" prompt="CON_CONTRACT_MORTGAGE.LAND_USE_RIGHTS_TYPE"/>
        <bm:field name="land_use_rights_start_date" databaseType="DATE" datatype="java.util.Date" physicalName="LAND_USE_RIGHTS_START_DATE" prompt="CON_CONTRACT_MORTGAGE.LAND_USE_RIGHTS_START_DATE"/>
        <bm:field name="usable_period" databaseType="NUMBER" datatype="java.lang.Long" physicalName="USABLE_PERIOD" prompt="CON_CONTRACT_MORTGAGE.USABLE_PERIOD"/>
        <bm:field name="construction_area" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONSTRUCTION_AREA" prompt="CON_CONTRACT_MORTGAGE.CONSTRUCTION_AREA"/>
        <bm:field name="status_of_land_use" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STATUS_OF_LAND_USE" prompt="CON_CONTRACT_MORTGAGE.STATUS_OF_LAND_USE"/>
        <bm:field name="company_name_stock" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_NAME_STOCK" prompt="CON_CONTRACT_MORTGAGE.COMPANY_NAME_STOCK"/>
        <bm:field name="stock_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_NAME" prompt="CON_CONTRACT_MORTGAGE.STOCK_NAME"/>
        <bm:field name="stock_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_CODE" prompt="CON_CONTRACT_MORTGAGE.STOCK_CODE"/>
        <bm:field name="stock_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STOCK_AMOUNT" prompt="CON_CONTRACT_MORTGAGE.STOCK_AMOUNT"/>
        <bm:field name="stock_ratio" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STOCK_RATIO" prompt="CON_CONTRACT_MORTGAGE.STOCK_RATIO"/>
        <bm:field name="fair_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FAIR_VALUE" prompt="CON_CONTRACT_MORTGAGE.FAIR_VALUE"/>
        <bm:field name="appraise_date" databaseType="DATE" datatype="java.util.Date" physicalName="APPRAISE_DATE" prompt="CON_CONTRACT_MORTGAGE.APPRAISE_DATE"/>
        <bm:field name="total_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TOTAL_VALUE" prompt="CON_CONTRACT_MORTGAGE.TOTAL_VALUE"/>
        <bm:field name="bvps" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BVPS" prompt="CON_CONTRACT_MORTGAGE.BVPS"/>
        <bm:field name="equipment_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EQUIPMENT_TYPE" prompt="CON_CONTRACT_MORTGAGE.EQUIPMENT_TYPE"/>
        <bm:field name="pattern" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PATTERN" prompt="CON_CONTRACT_MORTGAGE.PATTERN"/>
        <bm:field name="specification" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SPECIFICATION" prompt="CON_CONTRACT_MORTGAGE.SPECIFICATION"/>
        <bm:field name="note" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTE" prompt="CON_CONTRACT_MORTGAGE.NOTE"/>
        <bm:field name="fund_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUND_NAME" prompt="CON_CONTRACT_MORTGAGE.FUND_NAME"/>
        <bm:field name="fund_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUND_TYPE" prompt="CON_CONTRACT_MORTGAGE.FUND_TYPE"/>
        <bm:field name="fund_shares" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FUND_SHARES" prompt="CON_CONTRACT_MORTGAGE.FUND_SHARES"/>
        <bm:field name="repurchase_fund" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REPURCHASE_FUND" prompt="CON_CONTRACT_MORTGAGE.REPURCHASE_FUND"/>
        <bm:field name="net_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="NET_VALUE" prompt="CON_CONTRACT_MORTGAGE.NET_VALUE"/>
        <bm:field name="earnings_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EARNINGS_RATE" prompt="CON_CONTRACT_MORTGAGE.EARNINGS_RATE"/>
        <bm:field name="note_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTE_TYPE" prompt="CON_CONTRACT_MORTGAGE.NOTE_TYPE"/>
        <bm:field name="drawer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DRAWER" prompt="CON_CONTRACT_MORTGAGE.DRAWER"/>
        <bm:field name="opening_bank" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OPENING_BANK" prompt="CON_CONTRACT_MORTGAGE.OPENING_BANK"/>
        <bm:field name="negotiating_bank" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NEGOTIATING_BANK" prompt="CON_CONTRACT_MORTGAGE.NEGOTIATING_BANK"/>
        <bm:field name="due_date" databaseType="DATE" datatype="java.util.Date" physicalName="DUE_DATE" prompt="CON_CONTRACT_MORTGAGE.DUE_DATE"/>
        <bm:field name="payee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PAYEE" prompt="CON_CONTRACT_MORTGAGE.PAYEE"/>
        <bm:field name="denomination_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DENOMINATION_VALUE" prompt="CON_CONTRACT_MORTGAGE.DENOMINATION_VALUE"/>
        <bm:field name="bill_of_lading" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BILL_OF_LADING" prompt="CON_CONTRACT_MORTGAGE.BILL_OF_LADING"/>
        <bm:field name="shipper" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIPPER" prompt="CON_CONTRACT_MORTGAGE.SHIPPER"/>
        <bm:field name="consignee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONSIGNEE" prompt="CON_CONTRACT_MORTGAGE.CONSIGNEE"/>
        <bm:field name="date_of_issue" databaseType="DATE" datatype="java.util.Date" physicalName="DATE_OF_ISSUE" prompt="CON_CONTRACT_MORTGAGE.DATE_OF_ISSUE"/>
        <bm:field name="place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PLACE" prompt="CON_CONTRACT_MORTGAGE.PLACE"/>
        <bm:field name="ships_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIPS_NAME" prompt="CON_CONTRACT_MORTGAGE.SHIPS_NAME"/>
        <bm:field name="loading_port" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOADING_PORT" prompt="CON_CONTRACT_MORTGAGE.LOADING_PORT"/>
        <bm:field name="discharging_port" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISCHARGING_PORT" prompt="CON_CONTRACT_MORTGAGE.DISCHARGING_PORT"/>
        <bm:field name="notifier" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTIFIER" prompt="CON_CONTRACT_MORTGAGE.NOTIFIER"/>
        <bm:field name="desc_of_goods" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESC_OF_GOODS" prompt="CON_CONTRACT_MORTGAGE.DESC_OF_GOODS"/>
        <bm:field name="shipping_mark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIPPING_MARK" prompt="CON_CONTRACT_MORTGAGE.SHIPPING_MARK"/>
        <bm:field name="depositor_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSITOR_NAME" prompt="CON_CONTRACT_MORTGAGE.DEPOSITOR_NAME"/>
        <bm:field name="depositor_domicile" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSITOR_DOMICILE" prompt="CON_CONTRACT_MORTGAGE.DEPOSITOR_DOMICILE"/>
        <bm:field name="stock_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_TYPE" prompt="CON_CONTRACT_MORTGAGE.STOCK_TYPE"/>
        <bm:field name="stock_quality" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_QUALITY" prompt="CON_CONTRACT_MORTGAGE.STOCK_QUALITY"/>
        <bm:field name="stock_pack" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_PACK" prompt="CON_CONTRACT_MORTGAGE.STOCK_PACK"/>
        <bm:field name="stock_quantity" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STOCK_QUANTITY" prompt="CON_CONTRACT_MORTGAGE.STOCK_QUANTITY"/>
        <bm:field name="stock_tab" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_TAB" prompt="CON_CONTRACT_MORTGAGE.STOCK_TAB"/>
        <bm:field name="stock_loss_standar" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_LOSS_STANDAR" prompt="CON_CONTRACT_MORTGAGE.STOCK_LOSS_STANDAR"/>
        <bm:field name="storage_sites" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_SITES" prompt="CON_CONTRACT_MORTGAGE.STORAGE_SITES"/>
        <bm:field name="storage_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_PERIOD" prompt="CON_CONTRACT_MORTGAGE.STORAGE_PERIOD"/>
        <bm:field name="storage_fee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_FEE" prompt="CON_CONTRACT_MORTGAGE.STORAGE_FEE"/>
        <bm:field name="storage_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_INSURANCE" prompt="CON_CONTRACT_MORTGAGE.STORAGE_INSURANCE"/>
        <bm:field name="storage_issuer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_ISSUER" prompt="CON_CONTRACT_MORTGAGE.STORAGE_ISSUER"/>
        <bm:field name="fill_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FILL_TIME" prompt="CON_CONTRACT_MORTGAGE.FILL_TIME"/>
        <bm:field name="fill_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FILL_PLACE" prompt="CON_CONTRACT_MORTGAGE.FILL_PLACE"/>
        <bm:field name="trademark_lic_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRADEMARK_LIC_NO" prompt="CON_CONTRACT_MORTGAGE.TRADEMARK_LIC_NO"/>
        <bm:field name="trademark_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRADEMARK_TYPE" prompt="CON_CONTRACT_MORTGAGE.TRADEMARK_TYPE"/>
        <bm:field name="apply_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="APPLY_PERIOD" prompt="CON_CONTRACT_MORTGAGE.APPLY_PERIOD"/>
        <bm:field name="patent_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PATENT_NAME" prompt="CON_CONTRACT_MORTGAGE.PATENT_NAME"/>
        <bm:field name="patent_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PATENT_NO" prompt="CON_CONTRACT_MORTGAGE.PATENT_NO"/>
        <bm:field name="apply_date" databaseType="DATE" datatype="java.util.Date" physicalName="APPLY_DATE" prompt="CON_CONTRACT_MORTGAGE.APPLY_DATE"/>
        <bm:field name="auth_proc_date" databaseType="DATE" datatype="java.util.Date" physicalName="AUTH_PROC_DATE" prompt="CON_CONTRACT_MORTGAGE.AUTH_PROC_DATE"/>
        <bm:field name="copyright_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COPYRIGHT_TYPE" prompt="CON_CONTRACT_MORTGAGE.COPYRIGHT_TYPE"/>
        <bm:field name="purview" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PURVIEW" prompt="CON_CONTRACT_MORTGAGE.PURVIEW"/>
        <bm:field name="protection_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROTECTION_PERIOD" prompt="CON_CONTRACT_MORTGAGE.PROTECTION_PERIOD"/>
        <bm:field name="authorized_use" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AUTHORIZED_USE" prompt="CON_CONTRACT_MORTGAGE.AUTHORIZED_USE"/>
        <bm:field name="accounts_receivable_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNTS_RECEIVABLE_TYPE" prompt="CON_CONTRACT_MORTGAGE.ACCOUNTS_RECEIVABLE_TYPE"/>
        <bm:field name="book_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BOOK_VALUE" prompt="CON_CONTRACT_MORTGAGE.BOOK_VALUE"/>
        <bm:field name="credit_risk" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREDIT_RISK" prompt="CON_CONTRACT_MORTGAGE.CREDIT_RISK"/>
        <bm:field name="bond_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BOND_NAME" prompt="CON_CONTRACT_MORTGAGE.BOND_NAME"/>
        <bm:field name="denomination_value_b" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DENOMINATION_VALUE_B" prompt="CON_CONTRACT_MORTGAGE.DENOMINATION_VALUE_B"/>
        <bm:field name="date_of_maturity" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DATE_OF_MATURITY" prompt="CON_CONTRACT_MORTGAGE.DATE_OF_MATURITY"/>
        <bm:field name="in_pay_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="IN_PAY_PERIOD" prompt="CON_CONTRACT_MORTGAGE.IN_PAY_PERIOD"/>
        <bm:field name="stated_int_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STATED_INT_RATE" prompt="CON_CONTRACT_MORTGAGE.STATED_INT_RATE"/>
        <bm:field name="issuer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ISSUER" prompt="CON_CONTRACT_MORTGAGE.ISSUER"/>
        <bm:field name="mortgage_speciality" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_SPECIALITY" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_SPECIALITY"/>
        <bm:field name="serial_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SERIAL_NUMBER" prompt="CON_CONTRACT_MORTGAGE.SERIAL_NUMBER"/>
        <bm:field name="engine_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENGINE_NUMBER" prompt="CON_CONTRACT_MORTGAGE.ENGINE_NUMBER"/>
        <bm:field name="vehicle_frame_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_FRAME_NO" prompt="CON_CONTRACT_MORTGAGE.VEHICLE_FRAME_NO"/>
        <bm:field name="material" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MATERIAL" prompt="CON_CONTRACT_MORTGAGE.MATERIAL"/>
        <bm:field name="cancellation_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CANCELLATION_FLAG" prompt="CON_CONTRACT_MORTGAGE.CANCELLATION_FLAG"/>
        <bm:field name="id_card_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_CARD_NO" prompt="CON_CONTRACT_MORTGAGE.ID_CARD_NO"/>
        <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="CON_CONTRACT_MORTGAGE.REF_V01"/>
        <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="CON_CONTRACT_MORTGAGE.REF_V02"/>
        <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="CON_CONTRACT_MORTGAGE.REF_V03"/>
        <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="CON_CONTRACT_MORTGAGE.REF_V04"/>
        <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="CON_CONTRACT_MORTGAGE.REF_V05"/>
        <bm:field name="ref_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N01" prompt="CON_CONTRACT_MORTGAGE.REF_N01"/>
        <bm:field name="ref_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N02" prompt="CON_CONTRACT_MORTGAGE.REF_N02"/>
        <bm:field name="ref_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N03" prompt="CON_CONTRACT_MORTGAGE.REF_N03"/>
        <bm:field name="ref_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N04" prompt="CON_CONTRACT_MORTGAGE.REF_N04"/>
        <bm:field name="ref_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N05" prompt="CON_CONTRACT_MORTGAGE.REF_N05"/>
        <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="CON_CONTRACT_MORTGAGE.REF_D01"/>
        <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="CON_CONTRACT_MORTGAGE.REF_D02"/>
        <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="CON_CONTRACT_MORTGAGE.REF_D03"/>
        <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="CON_CONTRACT_MORTGAGE.REF_D04"/>
        <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="CON_CONTRACT_MORTGAGE.REF_D05"/>
        <bm:field name="mortgagor_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGOR_CLASS" prompt="CON_CONTRACT_MORTGAGE.MORTGAGOR_CLASS"/>
        <bm:field name="mortgage_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_FLAG" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_FLAG"/>
        <bm:field name="contract_seq" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_SEQ" prompt="CON_CONTRACT_MORTGAGE.CONTRACT_SEQ"/>
        <bm:field name="release_note" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RELEASE_NOTE" prompt="CON_CONTRACT_MORTGAGE.RELEASE_NOTE"/>
        <bm:field name="manufacturer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MANUFACTURER" prompt="CON_CONTRACT_MORTGAGE.MANUFACTURER"/>
        <bm:field name="in_use_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="IN_USE_PLACE" prompt="CON_CONTRACT_MORTGAGE.IN_USE_PLACE"/>
        <bm:field name="product_qualified_card" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRODUCT_QUALIFIED_CARD" prompt="CON_CONTRACT_MORTGAGE.PRODUCT_QUALIFIED_CARD"/>
        <bm:field name="land_location" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_LOCATION" prompt="CON_CONTRACT_MORTGAGE.LAND_LOCATION"/>
        <bm:field name="land_use_right_owner" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_USE_RIGHT_OWNER" prompt="CON_CONTRACT_MORTGAGE.LAND_USE_RIGHT_OWNER"/>
        <bm:field name="house_location" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HOUSE_LOCATION" prompt="CON_CONTRACT_MORTGAGE.HOUSE_LOCATION"/>
        <bm:field name="house_owner" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HOUSE_OWNER" prompt="CON_CONTRACT_MORTGAGE.HOUSE_OWNER"/>
        <bm:field name="pledge_month" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PLEDGE_MONTH" prompt="CON_CONTRACT_MORTGAGE.PLEDGE_MONTH"/>
        <bm:field name="mortgage_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_INSURANCE" prompt="CON_CONTRACT_MORTGAGE.MORTGAGE_INSURANCE"/>
        <bm:field name="evaluator_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EVALUATOR_NUMBER" prompt="CON_CONTRACT_MORTGAGE.EVALUATOR_NUMBER"/>
        <bm:field name="invoice_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_NUMBER" prompt="CON_CONTRACT_MORTGAGE.INVOICE_NUMBER"/>
        <bm:field name="land_building_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_BUILDING_TYPE" prompt="CON_CONTRACT_MORTGAGE.LAND_BUILDING_TYPE"/>
        <bm:field name="land_building_location" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_BUILDING_LOCATION" prompt="CON_CONTRACT_MORTGAGE.LAND_BUILDING_LOCATION"/>
        <bm:field name="land_building_area" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAND_BUILDING_AREA" prompt="CON_CONTRACT_MORTGAGE.LAND_BUILDING_AREA"/>
        <bm:field name="land_building_structure" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_BUILDING_STRUCTURE" prompt="CON_CONTRACT_MORTGAGE.LAND_BUILDING_STRUCTURE"/>
        <bm:field name="land_building_floor" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAND_BUILDING_FLOOR" prompt="CON_CONTRACT_MORTGAGE.LAND_BUILDING_FLOOR"/>
        <bm:field name="land_building_floor_total" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAND_BUILDING_FLOOR_TOTAL" prompt="CON_CONTRACT_MORTGAGE.LAND_BUILDING_FLOOR_TOTAL"/>
        <bm:field name="land_building_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAND_BUILDING_VALUE" prompt="CON_CONTRACT_MORTGAGE.LAND_BUILDING_VALUE"/>
        <bm:field name="stock_registered_capital" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STOCK_REGISTERED_CAPITAL" prompt="CON_CONTRACT_MORTGAGE.STOCK_REGISTERED_CAPITAL"/>
        <bm:field name="accounts_debetor_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNTS_DEBETOR_NAME" prompt="CON_CONTRACT_MORTGAGE.ACCOUNTS_DEBETOR_NAME"/>
        <bm:field name="accounts_contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNTS_CONTRACT_NUMBER" prompt="CON_CONTRACT_MORTGAGE.ACCOUNTS_CONTRACT_NUMBER"/>
        <bm:field name="accounts_contract_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNTS_CONTRACT_NAME" prompt="CON_CONTRACT_MORTGAGE.ACCOUNTS_CONTRACT_NAME"/>
        <bm:field name="acc_bank_branch_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACC_BANK_BRANCH_NAME" prompt="CON_CONTRACT_MORTGAGE.ACC_BANK_BRANCH_NAME"/>
        <bm:field name="acc_bank_account_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACC_BANK_ACCOUNT_NUMBER" prompt="CON_CONTRACT_MORTGAGE.ACC_BANK_ACCOUNT_NUMBER"/>
        <bm:field name="acc_bank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACC_BANK_ACCOUNT_NAME" prompt="CON_CONTRACT_MORTGAGE.ACC_BANK_ACCOUNT_NAME"/>
        <bm:field name="acc_bank_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACC_BANK_NAME" prompt="CON_CONTRACT_MORTGAGE.ACC_BANK_NAME"/>
        <bm:field name="accounts_debetor_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNTS_DEBETOR_ADDRESS" prompt="CON_CONTRACT_MORTGAGE.ACCOUNTS_DEBETOR_ADDRESS"/>
        <bm:field name="data_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DATA_TYPE" prompt="CON_CONTRACT_MORTGAGE.DATA_TYPE"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="t1.con_mortgage_id=${@con_mortgage_id}"/>
        <bm:data-filter enforceOperations="update" expression="t1.con_mortgage_id=${@con_mortgage_id}"/>
    </bm:data-filters>
</bm:model>
