<?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="PRJ_PROJECT_MORTGAGE"> <bm:fields> <bm:field name="prj_mortgage_id" databaseType="NUMBER" physicalName="PRJ_MORTGAGE_ID" prompt="PRJ_PROJECT_MORTGAGE.PRJ_MORTGAGE_ID"/> <bm:field name="project_id" databaseType="NUMBER" physicalName="PROJECT_ID" prompt="PRJ_PROJECT_MORTGAGE.PROJECT_ID"/> <bm:field name="mortgage_id" databaseType="NUMBER" physicalName="MORTGAGE_ID" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_ID"/> <bm:field name="mortgage_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_CODE" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_CODE"/> <bm:field name="creat_mortgage_flg" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREAT_MORTGAGE_FLG" prompt="PRJ_PROJECT_MORTGAGE.CREAT_MORTGAGE_FLG"/> <bm:field name="contract_seq" databaseType="NUMBER" physicalName="CONTRACT_SEQ" prompt="PRJ_PROJECT_MORTGAGE.CONTRACT_SEQ"/> <bm:field name="mortgage_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_NAME" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_NAME"/> <bm:field name="mortgage_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_TYPE" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_TYPE"/> <bm:field name="mortgage_ast_classfication" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_AST_CLASSFICATION" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_AST_CLASSFICATION"/> <bm:field name="mortgage_asset_detail" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_ASSET_DETAIL" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_ASSET_DETAIL"/> <bm:field name="mortgage_contract_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_CONTRACT_NO" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_CONTRACT_NO"/> <bm:field name="mortgage_register_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_REGISTER_NO" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_REGISTER_NO"/> <bm:field name="mortgage_registed_dept" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_REGISTED_DEPT" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_REGISTED_DEPT"/> <bm:field name="bp_id_mortgagor" databaseType="NUMBER" physicalName="BP_ID_MORTGAGOR" prompt="PRJ_PROJECT_MORTGAGE.BP_ID_MORTGAGOR"/> <bm:field name="mortgagor_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGOR_NAME" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGOR_NAME"/> <bm:field name="value" physicalName="VALUE" prompt="PRJ_PROJECT_MORTGAGE.VALUE"/> <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="PRJ_PROJECT_MORTGAGE.CURRENCY"/> <bm:field name="uom" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UOM" prompt="PRJ_PROJECT_MORTGAGE.UOM"/> <bm:field name="quantity" physicalName="QUANTITY" prompt="PRJ_PROJECT_MORTGAGE.QUANTITY"/> <bm:field name="start_date" databaseType="DATE" datatype="java.util.Date" physicalName="START_DATE" prompt="PRJ_PROJECT_MORTGAGE.START_DATE"/> <bm:field name="end_date" databaseType="DATE" datatype="java.util.Date" physicalName="END_DATE" prompt="PRJ_PROJECT_MORTGAGE.END_DATE"/> <bm:field name="bp_id_evaluator" databaseType="NUMBER" physicalName="BP_ID_EVALUATOR" prompt="PRJ_PROJECT_MORTGAGE.BP_ID_EVALUATOR"/> <bm:field name="evaluator_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EVALUATOR_NAME" prompt="PRJ_PROJECT_MORTGAGE.EVALUATOR_NAME"/> <bm:field name="ownership" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNERSHIP" prompt="PRJ_PROJECT_MORTGAGE.OWNERSHIP"/> <bm:field name="occupied" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OCCUPIED" prompt="PRJ_PROJECT_MORTGAGE.OCCUPIED"/> <bm:field name="location" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOCATION" prompt="PRJ_PROJECT_MORTGAGE.LOCATION"/> <bm:field name="estate_license_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ESTATE_LICENSE_CODE" prompt="PRJ_PROJECT_MORTGAGE.ESTATE_LICENSE_CODE"/> <bm:field name="housing_area" databaseType="NUMBER" physicalName="HOUSING_AREA" prompt="PRJ_PROJECT_MORTGAGE.HOUSING_AREA"/> <bm:field name="use" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USE" prompt="PRJ_PROJECT_MORTGAGE.USE"/> <bm:field name="construction_date" databaseType="DATE" datatype="java.util.Date" physicalName="CONSTRUCTION_DATE" prompt="PRJ_PROJECT_MORTGAGE.CONSTRUCTION_DATE"/> <bm:field name="building_structure" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUILDING_STRUCTURE" prompt="PRJ_PROJECT_MORTGAGE.BUILDING_STRUCTURE"/> <bm:field name="land_certificate_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_CERTIFICATE_CODE" prompt="PRJ_PROJECT_MORTGAGE.LAND_CERTIFICATE_CODE"/> <bm:field name="land_area" databaseType="NUMBER" physicalName="LAND_AREA" prompt="PRJ_PROJECT_MORTGAGE.LAND_AREA"/> <bm:field name="land_use_rights_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAND_USE_RIGHTS_TYPE" prompt="PRJ_PROJECT_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="PRJ_PROJECT_MORTGAGE.LAND_USE_RIGHTS_START_DATE"/> <bm:field name="usable_period" databaseType="NUMBER" physicalName="USABLE_PERIOD" prompt="PRJ_PROJECT_MORTGAGE.USABLE_PERIOD"/> <bm:field name="construction_area" databaseType="NUMBER" physicalName="CONSTRUCTION_AREA" prompt="PRJ_PROJECT_MORTGAGE.CONSTRUCTION_AREA"/> <bm:field name="status_of_land_use" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STATUS_OF_LAND_USE" prompt="PRJ_PROJECT_MORTGAGE.STATUS_OF_LAND_USE"/> <bm:field name="company_name_stock" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_NAME_STOCK" prompt="PRJ_PROJECT_MORTGAGE.COMPANY_NAME_STOCK"/> <bm:field name="stock_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_NAME" prompt="PRJ_PROJECT_MORTGAGE.STOCK_NAME"/> <bm:field name="stock_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_CODE" prompt="PRJ_PROJECT_MORTGAGE.STOCK_CODE"/> <bm:field name="stock_amount" databaseType="NUMBER" physicalName="STOCK_AMOUNT" prompt="PRJ_PROJECT_MORTGAGE.STOCK_AMOUNT"/> <bm:field name="stock_ratio" databaseType="NUMBER" physicalName="STOCK_RATIO" prompt="PRJ_PROJECT_MORTGAGE.STOCK_RATIO"/> <bm:field name="fair_value" databaseType="NUMBER" physicalName="FAIR_VALUE" prompt="PRJ_PROJECT_MORTGAGE.FAIR_VALUE"/> <bm:field name="appraise_date" databaseType="DATE" datatype="java.util.Date" physicalName="APPRAISE_DATE" prompt="PRJ_PROJECT_MORTGAGE.APPRAISE_DATE"/> <bm:field name="total_value" databaseType="NUMBER" physicalName="TOTAL_VALUE" prompt="PRJ_PROJECT_MORTGAGE.TOTAL_VALUE"/> <bm:field name="bvps" databaseType="NUMBER" physicalName="BVPS" prompt="PRJ_PROJECT_MORTGAGE.BVPS"/> <bm:field name="equipment_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EQUIPMENT_TYPE" prompt="PRJ_PROJECT_MORTGAGE.EQUIPMENT_TYPE"/> <bm:field name="pattern" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PATTERN" prompt="PRJ_PROJECT_MORTGAGE.PATTERN"/> <bm:field name="specification" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SPECIFICATION" prompt="PRJ_PROJECT_MORTGAGE.SPECIFICATION"/> <bm:field name="note" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTE" prompt="PRJ_PROJECT_MORTGAGE.NOTE"/> <bm:field name="fund_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUND_NAME" prompt="PRJ_PROJECT_MORTGAGE.FUND_NAME"/> <bm:field name="fund_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUND_TYPE" prompt="PRJ_PROJECT_MORTGAGE.FUND_TYPE"/> <bm:field name="fund_shares" databaseType="NUMBER" physicalName="FUND_SHARES" prompt="PRJ_PROJECT_MORTGAGE.FUND_SHARES"/> <bm:field name="repurchase_fund" databaseType="NUMBER" physicalName="REPURCHASE_FUND" prompt="PRJ_PROJECT_MORTGAGE.REPURCHASE_FUND"/> <bm:field name="net_value" databaseType="NUMBER" physicalName="NET_VALUE" prompt="PRJ_PROJECT_MORTGAGE.NET_VALUE"/> <bm:field name="earnings_rate" databaseType="NUMBER" physicalName="EARNINGS_RATE" prompt="PRJ_PROJECT_MORTGAGE.EARNINGS_RATE"/> <bm:field name="note_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTE_TYPE" prompt="PRJ_PROJECT_MORTGAGE.NOTE_TYPE"/> <bm:field name="drawer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DRAWER" prompt="PRJ_PROJECT_MORTGAGE.DRAWER"/> <bm:field name="opening_bank" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OPENING_BANK" prompt="PRJ_PROJECT_MORTGAGE.OPENING_BANK"/> <bm:field name="negotiating_bank" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NEGOTIATING_BANK" prompt="PRJ_PROJECT_MORTGAGE.NEGOTIATING_BANK"/> <bm:field name="due_date" databaseType="DATE" datatype="java.util.Date" physicalName="DUE_DATE" prompt="PRJ_PROJECT_MORTGAGE.DUE_DATE"/> <bm:field name="payee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PAYEE" prompt="PRJ_PROJECT_MORTGAGE.PAYEE"/> <bm:field name="denomination_value" databaseType="NUMBER" physicalName="DENOMINATION_VALUE" prompt="PRJ_PROJECT_MORTGAGE.DENOMINATION_VALUE"/> <bm:field name="bill_of_lading" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BILL_OF_LADING" prompt="PRJ_PROJECT_MORTGAGE.BILL_OF_LADING"/> <bm:field name="shipper" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIPPER" prompt="PRJ_PROJECT_MORTGAGE.SHIPPER"/> <bm:field name="consignee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONSIGNEE" prompt="PRJ_PROJECT_MORTGAGE.CONSIGNEE"/> <bm:field name="date_of_issue" databaseType="DATE" datatype="java.util.Date" physicalName="DATE_OF_ISSUE" prompt="PRJ_PROJECT_MORTGAGE.DATE_OF_ISSUE"/> <bm:field name="place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PLACE" prompt="PRJ_PROJECT_MORTGAGE.PLACE"/> <bm:field name="ships_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIPS_NAME" prompt="PRJ_PROJECT_MORTGAGE.SHIPS_NAME"/> <bm:field name="loading_port" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOADING_PORT" prompt="PRJ_PROJECT_MORTGAGE.LOADING_PORT"/> <bm:field name="discharging_port" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISCHARGING_PORT" prompt="PRJ_PROJECT_MORTGAGE.DISCHARGING_PORT"/> <bm:field name="notifier" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTIFIER" prompt="PRJ_PROJECT_MORTGAGE.NOTIFIER"/> <bm:field name="desc_of_goods" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESC_OF_GOODS" prompt="PRJ_PROJECT_MORTGAGE.DESC_OF_GOODS"/> <bm:field name="shipping_mark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIPPING_MARK" prompt="PRJ_PROJECT_MORTGAGE.SHIPPING_MARK"/> <bm:field name="depositor_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSITOR_NAME" prompt="PRJ_PROJECT_MORTGAGE.DEPOSITOR_NAME"/> <bm:field name="depositor_domicile" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSITOR_DOMICILE" prompt="PRJ_PROJECT_MORTGAGE.DEPOSITOR_DOMICILE"/> <bm:field name="stock_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_TYPE" prompt="PRJ_PROJECT_MORTGAGE.STOCK_TYPE"/> <bm:field name="stock_quality" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_QUALITY" prompt="PRJ_PROJECT_MORTGAGE.STOCK_QUALITY"/> <bm:field name="stock_pack" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_PACK" prompt="PRJ_PROJECT_MORTGAGE.STOCK_PACK"/> <bm:field name="stock_quantity" databaseType="NUMBER" physicalName="STOCK_QUANTITY" prompt="PRJ_PROJECT_MORTGAGE.STOCK_QUANTITY"/> <bm:field name="stock_tab" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_TAB" prompt="PRJ_PROJECT_MORTGAGE.STOCK_TAB"/> <bm:field name="stock_loss_standar" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOCK_LOSS_STANDAR" prompt="PRJ_PROJECT_MORTGAGE.STOCK_LOSS_STANDAR"/> <bm:field name="storage_sites" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_SITES" prompt="PRJ_PROJECT_MORTGAGE.STORAGE_SITES"/> <bm:field name="storage_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_PERIOD" prompt="PRJ_PROJECT_MORTGAGE.STORAGE_PERIOD"/> <bm:field name="storage_fee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_FEE" prompt="PRJ_PROJECT_MORTGAGE.STORAGE_FEE"/> <bm:field name="storage_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_INSURANCE" prompt="PRJ_PROJECT_MORTGAGE.STORAGE_INSURANCE"/> <bm:field name="storage_issuer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_ISSUER" prompt="PRJ_PROJECT_MORTGAGE.STORAGE_ISSUER"/> <bm:field name="fill_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FILL_TIME" prompt="PRJ_PROJECT_MORTGAGE.FILL_TIME"/> <bm:field name="fill_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FILL_PLACE" prompt="PRJ_PROJECT_MORTGAGE.FILL_PLACE"/> <bm:field name="trademark_lic_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRADEMARK_LIC_NO" prompt="PRJ_PROJECT_MORTGAGE.TRADEMARK_LIC_NO"/> <bm:field name="trademark_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRADEMARK_TYPE" prompt="PRJ_PROJECT_MORTGAGE.TRADEMARK_TYPE"/> <bm:field name="apply_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="APPLY_PERIOD" prompt="PRJ_PROJECT_MORTGAGE.APPLY_PERIOD"/> <bm:field name="patent_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PATENT_NAME" prompt="PRJ_PROJECT_MORTGAGE.PATENT_NAME"/> <bm:field name="patent_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PATENT_NO" prompt="PRJ_PROJECT_MORTGAGE.PATENT_NO"/> <bm:field name="apply_date" databaseType="DATE" datatype="java.util.Date" physicalName="APPLY_DATE" prompt="PRJ_PROJECT_MORTGAGE.APPLY_DATE"/> <bm:field name="auth_proc_date" databaseType="DATE" datatype="java.util.Date" physicalName="AUTH_PROC_DATE" prompt="PRJ_PROJECT_MORTGAGE.AUTH_PROC_DATE"/> <bm:field name="copyright_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COPYRIGHT_TYPE" prompt="PRJ_PROJECT_MORTGAGE.COPYRIGHT_TYPE"/> <bm:field name="purview" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PURVIEW" prompt="PRJ_PROJECT_MORTGAGE.PURVIEW"/> <bm:field name="protection_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROTECTION_PERIOD" prompt="PRJ_PROJECT_MORTGAGE.PROTECTION_PERIOD"/> <bm:field name="authorized_use" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AUTHORIZED_USE" prompt="PRJ_PROJECT_MORTGAGE.AUTHORIZED_USE"/> <bm:field name="accounts_receivable_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNTS_RECEIVABLE_TYPE" prompt="PRJ_PROJECT_MORTGAGE.ACCOUNTS_RECEIVABLE_TYPE"/> <bm:field name="book_value" databaseType="NUMBER" physicalName="BOOK_VALUE" prompt="PRJ_PROJECT_MORTGAGE.BOOK_VALUE"/> <bm:field name="credit_risk" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREDIT_RISK" prompt="PRJ_PROJECT_MORTGAGE.CREDIT_RISK"/> <bm:field name="bond_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BOND_NAME" prompt="PRJ_PROJECT_MORTGAGE.BOND_NAME"/> <bm:field name="denomination_value_b" databaseType="NUMBER" physicalName="DENOMINATION_VALUE_B" prompt="PRJ_PROJECT_MORTGAGE.DENOMINATION_VALUE_B"/> <bm:field name="date_of_maturity" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DATE_OF_MATURITY" prompt="PRJ_PROJECT_MORTGAGE.DATE_OF_MATURITY"/> <bm:field name="in_pay_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="IN_PAY_PERIOD" prompt="PRJ_PROJECT_MORTGAGE.IN_PAY_PERIOD"/> <bm:field name="stated_int_rate" databaseType="NUMBER" physicalName="STATED_INT_RATE" prompt="PRJ_PROJECT_MORTGAGE.STATED_INT_RATE"/> <bm:field name="issuer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ISSUER" prompt="PRJ_PROJECT_MORTGAGE.ISSUER"/> <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="PRJ_PROJECT_MORTGAGE.REF_V01"/> <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="PRJ_PROJECT_MORTGAGE.REF_V02"/> <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="PRJ_PROJECT_MORTGAGE.REF_V03"/> <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="PRJ_PROJECT_MORTGAGE.REF_V04"/> <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="PRJ_PROJECT_MORTGAGE.REF_V05"/> <bm:field name="ref_n01" databaseType="NUMBER" physicalName="REF_N01" prompt="PRJ_PROJECT_MORTGAGE.REF_N01"/> <bm:field name="ref_n02" databaseType="NUMBER" physicalName="REF_N02" prompt="PRJ_PROJECT_MORTGAGE.REF_N02"/> <bm:field name="ref_n03" databaseType="NUMBER" physicalName="REF_N03" prompt="PRJ_PROJECT_MORTGAGE.REF_N03"/> <bm:field name="ref_n04" databaseType="NUMBER" physicalName="REF_N04" prompt="PRJ_PROJECT_MORTGAGE.REF_N04"/> <bm:field name="ref_n05" databaseType="NUMBER" physicalName="REF_N05" prompt="PRJ_PROJECT_MORTGAGE.REF_N05"/> <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="PRJ_PROJECT_MORTGAGE.REF_D01"/> <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="PRJ_PROJECT_MORTGAGE.REF_D02"/> <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="PRJ_PROJECT_MORTGAGE.REF_D03"/> <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="PRJ_PROJECT_MORTGAGE.REF_D04"/> <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="PRJ_PROJECT_MORTGAGE.REF_D05"/> <bm:field name="mortgage_speciality" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_SPECIALITY" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_SPECIALITY"/> <bm:field name="serial_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SERIAL_NUMBER" prompt="PRJ_PROJECT_MORTGAGE.SERIAL_NUMBER"/> <bm:field name="engine_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENGINE_NUMBER" prompt="PRJ_PROJECT_MORTGAGE.ENGINE_NUMBER"/> <bm:field name="vehicle_frame_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_FRAME_NO" prompt="PRJ_PROJECT_MORTGAGE.VEHICLE_FRAME_NO"/> <bm:field name="material" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MATERIAL" prompt="PRJ_PROJECT_MORTGAGE.MATERIAL"/> <bm:field name="cancellation_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CANCELLATION_FLAG" prompt="PRJ_PROJECT_MORTGAGE.CANCELLATION_FLAG"/> <bm:field name="id_card_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_CARD_NO" prompt="PRJ_PROJECT_MORTGAGE.ID_CARD_NO"/> <bm:field name="mortgagor_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGOR_CLASS" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGOR_CLASS"/> <bm:field name="mortgage_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_FLAG" prompt="PRJ_PROJECT_MORTGAGE.MORTGAGE_FLAG"/> </bm:fields> <bm:features> <f:standard-who/> <o:sequence-pk/> </bm:features> <bm:primary-key> <bm:pk-field name="prj_mortgage_id"/> </bm:primary-key> <bm:query-fields> <bm:query-field field="project_id" queryOperator="="/> </bm:query-fields> </bm:model>