<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="CON_CONTRACT_LEASE_ITEM">
    <bm:fields>
        <bm:field name="contract_lease_item_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_LEASE_ITEM_ID" prompt="CON_CONTRACT_LEASE_ITEM.CONTRACT_LEASE_ITEM_ID"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="CON_CONTRACT_LEASE_ITEM.CONTRACT_ID"/>
        <bm:field name="brand_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BRAND_ID" prompt="CON_CONTRACT_LEASE_ITEM.BRAND_ID"/>
        <bm:field name="brand_id_n"/>
        <bm:field name="series_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SERIES_ID" prompt="CON_CONTRACT_LEASE_ITEM.SERIES_ID"/>
        <bm:field name="series_id_n"/>
        <bm:field name="model_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MODEL_ID" prompt="CON_CONTRACT_LEASE_ITEM.MODEL_ID"/>
        <bm:field name="model_id_n"/>
        <bm:field name="manufacturer_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MANUFACTURER_ID" prompt="CON_CONTRACT_LEASE_ITEM.MANUFACTURER_ID"/>
        <bm:field name="manufacturer_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MANUFACTURER_NAME" prompt="CON_CONTRACT_LEASE_ITEM.MANUFACTURER_NAME"/>
        <bm:field name="color_of_apprearance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLOR_OF_APPREARANCE" prompt="CON_CONTRACT_LEASE_ITEM.COLOR_OF_APPREARANCE"/>
        <bm:field name="factory_date" databaseType="DATE" datatype="java.util.Date" physicalName="FACTORY_DATE" prompt="CON_CONTRACT_LEASE_ITEM.FACTORY_DATE"/>
        <bm:field name="item_frame_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ITEM_FRAME_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.ITEM_FRAME_NUMBER"/>
        <bm:field name="car_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_STATUS" prompt="CON_CONTRACT_LEASE_ITEM.CAR_STATUS"/>
        <bm:field name="car_status_n"/>
        <bm:field name="item_engine_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ITEM_ENGINE_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.ITEM_ENGINE_NUMBER"/>
        <bm:field name="guide_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="GUIDE_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.GUIDE_PRICE"/>
        <bm:field name="finance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FINANCE_AMOUNT" prompt="CON_CONTRACT_LEASE_ITEM.FINANCE_AMOUNT"/>
        <bm:field name="invoice_date" databaseType="DATE" datatype="java.util.Date" physicalName="INVOICE_DATE" prompt="CON_CONTRACT_LEASE_ITEM.INVOICE_DATE"/>
        <bm:field name="invoice_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INVOICE_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.INVOICE_PRICE"/>
        <bm:field name="mortgage_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.MORTGAGE_FLAG"/>
        <bm:field name="mortgage_flag_n"/>
        <bm:field name="finance_ratio" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FINANCE_RATIO" prompt="CON_CONTRACT_LEASE_ITEM.FINANCE_RATIO"/>
        <bm:field name="main_finance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAIN_FINANCE" prompt="CON_CONTRACT_LEASE_ITEM.MAIN_FINANCE"/>
        <bm:field name="configure" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFIGURE" prompt="CON_CONTRACT_LEASE_ITEM.CONFIGURE"/>
        <!-- <bm:field name="lease_item_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_ITEM_ID" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_ITEM_ID"/>
        <bm:field name="serial_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SERIAL_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.SERIAL_NUMBER"/>
        <bm:field name="pattern" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PATTERN" prompt="CON_CONTRACT_LEASE_ITEM.PATTERN"/>
        <bm:field name="specification" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SPECIFICATION" prompt="CON_CONTRACT_LEASE_ITEM.SPECIFICATION"/>
        <bm:field name="colour" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLOUR" prompt="CON_CONTRACT_LEASE_ITEM.COLOUR"/>
        <bm:field name="quantity" databaseType="NUMBER" datatype="java.lang.Long" physicalName="QUANTITY" prompt="CON_CONTRACT_LEASE_ITEM.QUANTITY"/>
        <bm:field name="uom" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UOM" prompt="CON_CONTRACT_LEASE_ITEM.UOM"/>
        <bm:field name="tax_included_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TAX_INCLUDED_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.TAX_INCLUDED_FLAG"/>
        <bm:field name="tax_type_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TAX_TYPE_ID" prompt="CON_CONTRACT_LEASE_ITEM.TAX_TYPE_ID"/>
        <bm:field name="tax_type_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TAX_TYPE_RATE" prompt="CON_CONTRACT_LEASE_ITEM.TAX_TYPE_RATE"/>
        <bm:field name="vat_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VAT_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.VAT_FLAG"/>
        <bm:field name="purchase_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PURCHASE_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.PURCHASE_PRICE"/>
        <bm:field name="purchase_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PURCHASE_AMOUNT" prompt="CON_CONTRACT_LEASE_ITEM.PURCHASE_AMOUNT"/>
        <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="CON_CONTRACT_LEASE_ITEM.CURRENCY"/>
        <bm:field name="exchange_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_TYPE" prompt="CON_CONTRACT_LEASE_ITEM.EXCHANGE_RATE_TYPE"/>
        <bm:field name="exchange_rate_quotation" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_QUOTATION" prompt="CON_CONTRACT_LEASE_ITEM.EXCHANGE_RATE_QUOTATION"/>
        <bm:field name="exchange_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EXCHANGE_RATE" prompt="CON_CONTRACT_LEASE_ITEM.EXCHANGE_RATE"/>
        <bm:field name="price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRICE" prompt="CON_CONTRACT_LEASE_ITEM.PRICE"/>
        <bm:field name="customs_and_expense" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CUSTOMS_AND_EXPENSE" prompt="CON_CONTRACT_LEASE_ITEM.CUSTOMS_AND_EXPENSE"/>
        <bm:field name="vat_input" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VAT_INPUT" prompt="CON_CONTRACT_LEASE_ITEM.VAT_INPUT"/>
        <bm:field name="lease_item_cost" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_ITEM_COST" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_ITEM_COST"/>
        <bm:field name="amount_payable" databaseType="NUMBER" datatype="java.lang.Long" physicalName="AMOUNT_PAYABLE" prompt="CON_CONTRACT_LEASE_ITEM.AMOUNT_PAYABLE"/>
        <bm:field name="residual_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RESIDUAL_VALUE" prompt="CON_CONTRACT_LEASE_ITEM.RESIDUAL_VALUE"/>
        <bm:field name="bp_id_vender" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_VENDER" prompt="CON_CONTRACT_LEASE_ITEM.BP_ID_VENDER"/>
        <bm:field name="vender_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VENDER_NAME" prompt="CON_CONTRACT_LEASE_ITEM.VENDER_NAME"/>
        <bm:field name="bp_id_manufacturer" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_MANUFACTURER" prompt="CON_CONTRACT_LEASE_ITEM.BP_ID_MANUFACTURER"/>
        <bm:field name="manufacturing_date" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MANUFACTURING_DATE" prompt="CON_CONTRACT_LEASE_ITEM.MANUFACTURING_DATE"/>
        <bm:field name="delivery_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DELIVERY_ADDRESS" prompt="CON_CONTRACT_LEASE_ITEM.DELIVERY_ADDRESS"/>
        <bm:field name="installation_site" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSTALLATION_SITE" prompt="CON_CONTRACT_LEASE_ITEM.INSTALLATION_SITE"/>
        <bm:field name="fixed_assets_site" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIXED_ASSETS_SITE" prompt="CON_CONTRACT_LEASE_ITEM.FIXED_ASSETS_SITE"/>
        <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="CON_CONTRACT_LEASE_ITEM.DESCRIPTION"/>
        <bm:field name="enabled_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENABLED_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.ENABLED_FLAG"/>
        <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="CON_CONTRACT_LEASE_ITEM.REF_V01"/>
        <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="CON_CONTRACT_LEASE_ITEM.REF_V02"/>
        <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="CON_CONTRACT_LEASE_ITEM.REF_V03"/>
        <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="CON_CONTRACT_LEASE_ITEM.REF_V04"/>
        <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="CON_CONTRACT_LEASE_ITEM.REF_V05"/>
        <bm:field name="ref_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N01" prompt="CON_CONTRACT_LEASE_ITEM.REF_N01"/>
        <bm:field name="ref_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N02" prompt="CON_CONTRACT_LEASE_ITEM.REF_N02"/>
        <bm:field name="ref_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N03" prompt="CON_CONTRACT_LEASE_ITEM.REF_N03"/>
        <bm:field name="ref_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N04" prompt="CON_CONTRACT_LEASE_ITEM.REF_N04"/>
        <bm:field name="ref_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N05" prompt="CON_CONTRACT_LEASE_ITEM.REF_N05"/>
        <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="CON_CONTRACT_LEASE_ITEM.REF_D01"/>
        <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="CON_CONTRACT_LEASE_ITEM.REF_D02"/>
        <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="CON_CONTRACT_LEASE_ITEM.REF_D03"/>
        <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="CON_CONTRACT_LEASE_ITEM.REF_D04"/>
        <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="CON_CONTRACT_LEASE_ITEM.REF_D05"/>
        <bm:field name="invoice_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INVOICE_AMT" prompt="CON_CONTRACT_LEASE_ITEM.INVOICE_AMT"/>
        <bm:field name="invoice_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_NUM" prompt="CON_CONTRACT_LEASE_ITEM.INVOICE_NUM"/>
        <bm:field name="model" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MODEL" prompt="CON_CONTRACT_LEASE_ITEM.MODEL"/>
        <bm:field name="series" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SERIES" prompt="CON_CONTRACT_LEASE_ITEM.SERIES"/>
        <bm:field name="brand" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BRAND" prompt="CON_CONTRACT_LEASE_ITEM.BRAND"/>
        <bm:field name="gps_fee" databaseType="NUMBER" datatype="java.lang.Long" physicalName="GPS_FEE" prompt="CON_CONTRACT_LEASE_ITEM.GPS_FEE"/>
        <bm:field name="badge_fee" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BADGE_FEE" prompt="CON_CONTRACT_LEASE_ITEM.BADGE_FEE"/>
        <bm:field name="insurance_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INSURANCE_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.INSURANCE_PRICE"/>
        <bm:field name="badge_license_fee" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BADGE_LICENSE_FEE" prompt="CON_CONTRACT_LEASE_ITEM.BADGE_LICENSE_FEE"/>
        <bm:field name="badge_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BADGE_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.BADGE_PRICE"/>
        <bm:field name="purchase_fee" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PURCHASE_FEE" prompt="CON_CONTRACT_LEASE_ITEM.PURCHASE_FEE"/>
        <bm:field name="purchase_tax" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PURCHASE_TAX" prompt="CON_CONTRACT_LEASE_ITEM.PURCHASE_TAX"/>
        <bm:field name="color_of_decoration" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLOR_OF_DECORATION" prompt="CON_CONTRACT_LEASE_ITEM.COLOR_OF_DECORATION"/>
        <bm:field name="damage_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DAMAGE_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.DAMAGE_INSURANCE_FLAG"/>
        <bm:field name="damage_nopay_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DAMAGE_NOPAY_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.DAMAGE_NOPAY_INSURANCE_FLAG"/>
        <bm:field name="rot_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ROT_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.ROT_INSURANCE_FLAG"/>
        <bm:field name="glass_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GLASS_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.GLASS_INSURANCE_FLAG"/>
        <bm:field name="person_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PERSON_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.PERSON_INSURANCE_FLAG"/>
        <bm:field name="nick_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NICK_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.NICK_INSURANCE_FLAG"/>
        <bm:field name="travel_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRAVEL_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.TRAVEL_INSURANCE_FLAG"/>
        <bm:field name="third_party_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="THIRD_PARTY_INSURANCE" prompt="CON_CONTRACT_LEASE_ITEM.THIRD_PARTY_INSURANCE"/>
        <bm:field name="model_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MODEL_ID" prompt="CON_CONTRACT_LEASE_ITEM.MODEL_ID"/>
        <bm:field name="financial_range_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FINANCIAL_RANGE_CODE" prompt="CON_CONTRACT_LEASE_ITEM.FINANCIAL_RANGE_CODE"/>
        <bm:field name="invoice_agent_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INVOICE_AGENT_ID" prompt="CON_CONTRACT_LEASE_ITEM.INVOICE_AGENT_ID"/>
        <bm:field name="down_payment_ratio" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DOWN_PAYMENT_RATIO" prompt="CON_CONTRACT_LEASE_ITEM.DOWN_PAYMENT_RATIO"/>
        <bm:field name="preferential_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PREFERENTIAL_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.PREFERENTIAL_PRICE"/>
        <bm:field name="plate_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PLATE_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.PLATE_PRICE"/>
        <bm:field name="plate_resource" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PLATE_RESOURCE" prompt="CON_CONTRACT_LEASE_ITEM.PLATE_RESOURCE"/>
        <bm:field name="nonlocal_plate_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NONLOCAL_PLATE_DESC" prompt="CON_CONTRACT_LEASE_ITEM.NONLOCAL_PLATE_DESC"/>
        <bm:field name="price_list" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRICE_LIST" prompt="CON_CONTRACT_LEASE_ITEM.PRICE_LIST"/>
        <bm:field name="lease_times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_TIMES" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_TIMES"/>
        <bm:field name="annual_pay_times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ANNUAL_PAY_TIMES" prompt="CON_CONTRACT_LEASE_ITEM.ANNUAL_PAY_TIMES"/>
        <bm:field name="accident_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCIDENT_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.ACCIDENT_INSURANCE_FLAG"/>
        <bm:field name="frame_for_prj" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FRAME_FOR_PRJ" prompt="CON_CONTRACT_LEASE_ITEM.FRAME_FOR_PRJ"/>
        <bm:field name="engine_for_prj" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENGINE_FOR_PRJ" prompt="CON_CONTRACT_LEASE_ITEM.ENGINE_FOR_PRJ"/>
        <bm:field name="license_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LICENSE_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.LICENSE_NUMBER"/>
        <bm:field name="added_invoice_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ADDED_INVOICE_AMT" prompt="CON_CONTRACT_LEASE_ITEM.ADDED_INVOICE_AMT"/>
        <bm:field name="added_invoice_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADDED_INVOICE_NUM" prompt="CON_CONTRACT_LEASE_ITEM.ADDED_INVOICE_NUM"/>
        <bm:field name="trn_of_invoice" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRN_OF_INVOICE" prompt="CON_CONTRACT_LEASE_ITEM.TRN_OF_INVOICE"/>
        <bm:field name="bp_name_invoice" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME_INVOICE" prompt="CON_CONTRACT_LEASE_ITEM.BP_NAME_INVOICE"/>
        <bm:field name="pmt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PMT" prompt="CON_CONTRACT_LEASE_ITEM.PMT"/>
        <bm:field name="lease_start_date" databaseType="DATE" datatype="java.util.Date" physicalName="LEASE_START_DATE" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_START_DATE"/>
        <bm:field name="deposit_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_RATIO" prompt="CON_CONTRACT_LEASE_ITEM.DEPOSIT_RATIO"/>
        <bm:field name="balloon" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BALLOON" prompt="CON_CONTRACT_LEASE_ITEM.BALLOON"/>
        <bm:field name="issue_ticket" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ISSUE_TICKET" prompt="CON_CONTRACT_LEASE_ITEM.ISSUE_TICKET"/>
        <bm:field name="remarks" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REMARKS" prompt="CON_CONTRACT_LEASE_ITEM.REMARKS"/>
        <bm:field name="actual_price" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ACTUAL_PRICE" prompt="CON_CONTRACT_LEASE_ITEM.ACTUAL_PRICE"/>
        <bm:field name="future_prices" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FUTURE_PRICES" prompt="CON_CONTRACT_LEASE_ITEM.FUTURE_PRICES"/>
        <bm:field name="travelled_distance" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TRAVELLED_DISTANCE" prompt="CON_CONTRACT_LEASE_ITEM.TRAVELLED_DISTANCE"/>
        <bm:field name="vin_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VIN_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.VIN_NUMBER"/>
        <bm:field name="assessment_company" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ASSESSMENT_COMPANY" prompt="CON_CONTRACT_LEASE_ITEM.ASSESSMENT_COMPANY"/>
        <bm:field name="current_licence" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENT_LICENCE" prompt="CON_CONTRACT_LEASE_ITEM.CURRENT_LICENCE"/>
        <bm:field name="displacement" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISPLACEMENT" prompt="CON_CONTRACT_LEASE_ITEM.DISPLACEMENT"/>
        <bm:field name="first_register_date" databaseType="DATE" datatype="java.util.Date" physicalName="FIRST_REGISTER_DATE" prompt="CON_CONTRACT_LEASE_ITEM.FIRST_REGISTER_DATE"/>
        <bm:field name="car_old" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CAR_OLD" prompt="CON_CONTRACT_LEASE_ITEM.CAR_OLD"/>
        <bm:field name="sit_number" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SIT_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.SIT_NUMBER"/>
        <bm:field name="purchase_tax_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PURCHASE_TAX_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.PURCHASE_TAX_FLAG"/>
        <bm:field name="insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INSURANCE_AMOUNT" prompt="CON_CONTRACT_LEASE_ITEM.INSURANCE_AMOUNT"/>
        <bm:field name="insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.INSURANCE_FLAG"/>
        <bm:field name="travel_tax_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRAVEL_TAX_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.TRAVEL_TAX_FLAG"/>
        <bm:field name="travel_tax" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TRAVEL_TAX" prompt="CON_CONTRACT_LEASE_ITEM.TRAVEL_TAX"/>
        <bm:field name="other_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OTHER_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.OTHER_FLAG"/>
        <bm:field name="other_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OTHER_AMOUNT" prompt="CON_CONTRACT_LEASE_ITEM.OTHER_AMOUNT"/>
        <bm:field name="deferred_premium_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEFERRED_PREMIUM_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.DEFERRED_PREMIUM_FLAG"/>
        <bm:field name="deferred_premium" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DEFERRED_PREMIUM" prompt="CON_CONTRACT_LEASE_ITEM.DEFERRED_PREMIUM"/>
        <bm:field name="charge_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CHARGE_AMOUNT" prompt="CON_CONTRACT_LEASE_ITEM.CHARGE_AMOUNT"/>
        <bm:field name="postage_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POSTAGE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.POSTAGE_FLAG"/>
        <bm:field name="postage" databaseType="NUMBER" datatype="java.lang.Long" physicalName="POSTAGE" prompt="CON_CONTRACT_LEASE_ITEM.POSTAGE"/>
        <bm:field name="gps_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GPS_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.GPS_FLAG"/>
        <bm:field name="gps_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="GPS_AMOUNT" prompt="CON_CONTRACT_LEASE_ITEM.GPS_AMOUNT"/>
        <bm:field name="int_rate_display" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INT_RATE_DISPLAY" prompt="CON_CONTRACT_LEASE_ITEM.INT_RATE_DISPLAY"/>
        <bm:field name="compulsory_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPULSORY_INSURANCE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.COMPULSORY_INSURANCE_FLAG"/>
        <bm:field name="compulsory_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPULSORY_INSURANCE_AMOUNT" prompt="CON_CONTRACT_LEASE_ITEM.COMPULSORY_INSURANCE_AMOUNT"/>
        <bm:field name="charge_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CHARGE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.CHARGE_FLAG"/>
        <bm:field name="producer" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRODUCER" prompt="CON_CONTRACT_LEASE_ITEM.PRODUCER"/>
        <bm:field name="objective_buy_car" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OBJECTIVE_BUY_CAR" prompt="CON_CONTRACT_LEASE_ITEM.OBJECTIVE_BUY_CAR"/>
        <bm:field name="balloon_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BALLOON_RATIO" prompt="CON_CONTRACT_LEASE_ITEM.BALLOON_RATIO"/>
        <bm:field name="lease_charge_ratio" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_CHARGE_RATIO" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_CHARGE_RATIO"/>
        <bm:field name="deposit" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DEPOSIT" prompt="CON_CONTRACT_LEASE_ITEM.DEPOSIT"/>
        <bm:field name="down_payment" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DOWN_PAYMENT" prompt="CON_CONTRACT_LEASE_ITEM.DOWN_PAYMENT"/>
        <bm:field name="invoice_price_exp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INVOICE_PRICE_EXP" prompt="CON_CONTRACT_LEASE_ITEM.INVOICE_PRICE_EXP"/>
        <bm:field name="used_evaluation_amout" databaseType="NUMBER" datatype="java.lang.Long" physicalName="USED_EVALUATION_AMOUT" prompt="CON_CONTRACT_LEASE_ITEM.USED_EVALUATION_AMOUT"/>
        <bm:field name="rating_agency_used_prices" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RATING_AGENCY_USED_PRICES" prompt="CON_CONTRACT_LEASE_ITEM.RATING_AGENCY_USED_PRICES"/>
        <bm:field name="sit_number_new" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SIT_NUMBER_NEW" prompt="CON_CONTRACT_LEASE_ITEM.SIT_NUMBER_NEW"/>
        <bm:field name="lease_charge" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_CHARGE" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_CHARGE"/>
        <bm:field name="car_from" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_FROM" prompt="CON_CONTRACT_LEASE_ITEM.CAR_FROM"/>
        <bm:field name="car_from_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_FROM_ID" prompt="CON_CONTRACT_LEASE_ITEM.CAR_FROM_ID"/>
        <bm:field name="original_asset_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ORIGINAL_ASSET_VALUE" prompt="CON_CONTRACT_LEASE_ITEM.ORIGINAL_ASSET_VALUE"/>
        <bm:field name="net_asset_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="NET_ASSET_VALUE" prompt="CON_CONTRACT_LEASE_ITEM.NET_ASSET_VALUE"/>
        <bm:field name="accumulated_depreciation" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ACCUMULATED_DEPRECIATION" prompt="CON_CONTRACT_LEASE_ITEM.ACCUMULATED_DEPRECIATION"/>
        <bm:field name="ship_model" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIP_MODEL" prompt="CON_CONTRACT_LEASE_ITEM.SHIP_MODEL"/>
        <bm:field name="ship_classification" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHIP_CLASSIFICATION" prompt="CON_CONTRACT_LEASE_ITEM.SHIP_CLASSIFICATION"/>
        <bm:field name="overall_length" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OVERALL_LENGTH" prompt="CON_CONTRACT_LEASE_ITEM.OVERALL_LENGTH"/>
        <bm:field name="designed_draft" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DESIGNED_DRAFT" prompt="CON_CONTRACT_LEASE_ITEM.DESIGNED_DRAFT"/>
        <bm:field name="molded_breadth" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MOLDED_BREADTH" prompt="CON_CONTRACT_LEASE_ITEM.MOLDED_BREADTH"/>
        <bm:field name="molded_depth" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MOLDED_DEPTH" prompt="CON_CONTRACT_LEASE_ITEM.MOLDED_DEPTH"/>
        <bm:field name="main_engine" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAIN_ENGINE" prompt="CON_CONTRACT_LEASE_ITEM.MAIN_ENGINE"/>
        <bm:field name="design_speed" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESIGN_SPEED" prompt="CON_CONTRACT_LEASE_ITEM.DESIGN_SPEED"/>
        <bm:field name="deadweight_capacity" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEADWEIGHT_CAPACITY" prompt="CON_CONTRACT_LEASE_ITEM.DEADWEIGHT_CAPACITY"/>
        <bm:field name="navigating_zone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NAVIGATING_ZONE" prompt="CON_CONTRACT_LEASE_ITEM.NAVIGATING_ZONE"/>
        <bm:field name="ballast_tank" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BALLAST_TANK" prompt="CON_CONTRACT_LEASE_ITEM.BALLAST_TANK"/>
        <bm:field name="hold_capacity" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HOLD_CAPACITY" prompt="CON_CONTRACT_LEASE_ITEM.HOLD_CAPACITY"/>
        <bm:field name="rated_speed" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RATED_SPEED" prompt="CON_CONTRACT_LEASE_ITEM.RATED_SPEED"/>
        <bm:field name="rated_power" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RATED_POWER" prompt="CON_CONTRACT_LEASE_ITEM.RATED_POWER"/>
        <bm:field name="fuel_consumption" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUEL_CONSUMPTION" prompt="CON_CONTRACT_LEASE_ITEM.FUEL_CONSUMPTION"/>
        <bm:field name="nationality" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NATIONALITY" prompt="CON_CONTRACT_LEASE_ITEM.NATIONALITY"/>
        <bm:field name="hull" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HULL" prompt="CON_CONTRACT_LEASE_ITEM.HULL"/>
        <bm:field name="aircraft_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AIRCRAFT_CATEGORY" prompt="CON_CONTRACT_LEASE_ITEM.AIRCRAFT_CATEGORY"/>
        <bm:field name="airplane_model" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AIRPLANE_MODEL" prompt="CON_CONTRACT_LEASE_ITEM.AIRPLANE_MODEL"/>
        <bm:field name="engine" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENGINE" prompt="CON_CONTRACT_LEASE_ITEM.ENGINE"/>
        <bm:field name="mtow" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MTOW" prompt="CON_CONTRACT_LEASE_ITEM.MTOW"/>
        <bm:field name="max_range" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAX_RANGE" prompt="CON_CONTRACT_LEASE_ITEM.MAX_RANGE"/>
        <bm:field name="max_cruising_speed" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAX_CRUISING_SPEED" prompt="CON_CONTRACT_LEASE_ITEM.MAX_CRUISING_SPEED"/>
        <bm:field name="passenger_capacity" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PASSENGER_CAPACITY" prompt="CON_CONTRACT_LEASE_ITEM.PASSENGER_CAPACITY"/>
        <bm:field name="payload" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PAYLOAD" prompt="CON_CONTRACT_LEASE_ITEM.PAYLOAD"/>
        <bm:field name="li_list_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LI_LIST_TYPE" prompt="CON_CONTRACT_LEASE_ITEM.LI_LIST_TYPE"/>
        <bm:field name="industry" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY" prompt="CON_CONTRACT_LEASE_ITEM.INDUSTRY"/>
        <bm:field name="lease_item_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_ITEM_CODE" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_ITEM_CODE"/>
        <bm:field name="creat_item_flg" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREAT_ITEM_FLG" prompt="CON_CONTRACT_LEASE_ITEM.CREAT_ITEM_FLG"/>
        <bm:field name="short_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SHORT_NAME" prompt="CON_CONTRACT_LEASE_ITEM.SHORT_NAME"/>
        <bm:field name="full_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FULL_NAME" prompt="CON_CONTRACT_LEASE_ITEM.FULL_NAME"/>
        <bm:field name="contract_seq" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_SEQ" prompt="CON_CONTRACT_LEASE_ITEM.CONTRACT_SEQ"/>
        <bm:field name="vender_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VENDER_ID" prompt="CON_CONTRACT_LEASE_ITEM.VENDER_ID"/>
        <bm:field name="product_plan_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRODUCT_PLAN_ID" prompt="CON_CONTRACT_LEASE_ITEM.PRODUCT_PLAN_ID"/>
        <bm:field name="mortgage_date" databaseType="DATE" datatype="java.util.Date" physicalName="MORTGAGE_DATE" prompt="CON_CONTRACT_LEASE_ITEM.MORTGAGE_DATE"/>
        <bm:field name="gps_install_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GPS_INSTALL_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.GPS_INSTALL_FLAG"/>
        <bm:field name="max_discount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MAX_DISCOUNT" prompt="CON_CONTRACT_LEASE_ITEM.MAX_DISCOUNT"/>
        <bm:field name="visit_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VISIT_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.VISIT_FLAG"/>
        <bm:field name="insurance_purchase" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_PURCHASE" prompt="CON_CONTRACT_LEASE_ITEM.INSURANCE_PURCHASE"/>
        <bm:field name="license_fee_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LICENSE_FEE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.LICENSE_FEE_FLAG"/>
        <bm:field name="product_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRODUCT_TYPE" prompt="CON_CONTRACT_LEASE_ITEM.PRODUCT_TYPE"/>
        <bm:field name="discount_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DISCOUNT_RATE" prompt="CON_CONTRACT_LEASE_ITEM.DISCOUNT_RATE"/>
        <bm:field name="discount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DISCOUNT" prompt="CON_CONTRACT_LEASE_ITEM.DISCOUNT"/>
        <bm:field name="reg_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REG_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.REG_NUMBER"/>
        <bm:field name="discount_limit_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISCOUNT_LIMIT_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.DISCOUNT_LIMIT_FLAG"/>
        <bm:field name="discount_limit_total" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DISCOUNT_LIMIT_TOTAL" prompt="CON_CONTRACT_LEASE_ITEM.DISCOUNT_LIMIT_TOTAL"/>
        <bm:field name="interim_rental" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTERIM_RENTAL" prompt="CON_CONTRACT_LEASE_ITEM.INTERIM_RENTAL"/>
        <bm:field name="deposit_deduction" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_DEDUCTION" prompt="CON_CONTRACT_LEASE_ITEM.DEPOSIT_DEDUCTION"/>
        <bm:field name="project_lease_item_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_LEASE_ITEM_ID" prompt="CON_CONTRACT_LEASE_ITEM.PROJECT_LEASE_ITEM_ID"/>
        <bm:field name="truck_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRUCK_CLASS" prompt="CON_CONTRACT_LEASE_ITEM.TRUCK_CLASS"/>
        <bm:field name="vehicle_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_CLASS" prompt="CON_CONTRACT_LEASE_ITEM.VEHICLE_CLASS"/>
        <bm:field name="notice_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTICE_NUMBER" prompt="CON_CONTRACT_LEASE_ITEM.NOTICE_NUMBER"/>
        <bm:field name="horsepower" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HORSEPOWER" prompt="CON_CONTRACT_LEASE_ITEM.HORSEPOWER"/>
        <bm:field name="bus_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUS_TYPE" prompt="CON_CONTRACT_LEASE_ITEM.BUS_TYPE"/>
        <bm:field name="energy_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENERGY_TYPE" prompt="CON_CONTRACT_LEASE_ITEM.ENERGY_TYPE"/>
        <bm:field name="usage" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USAGE" prompt="CON_CONTRACT_LEASE_ITEM.USAGE"/>
        <bm:field name="callback_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CALLBACK_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.CALLBACK_FLAG"/>
        <bm:field name="real_callback_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REAL_CALLBACK_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.REAL_CALLBACK_FLAG"/>
        <bm:field name="callback_date" databaseType="DATE" datatype="java.util.Date" physicalName="CALLBACK_DATE" prompt="CON_CONTRACT_LEASE_ITEM.CALLBACK_DATE"/>
        <bm:field name="car_delivery_province" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CAR_DELIVERY_PROVINCE" prompt="CON_CONTRACT_LEASE_ITEM.CAR_DELIVERY_PROVINCE"/>
        <bm:field name="car_delivery_city" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CAR_DELIVERY_CITY" prompt="CON_CONTRACT_LEASE_ITEM.CAR_DELIVERY_CITY"/>
        <bm:field name="key_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="KEY_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.KEY_FLAG"/>
        <bm:field name="handcart_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HANDCART_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.HANDCART_FLAG"/>
        <bm:field name="parking_lot" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PARKING_LOT" prompt="CON_CONTRACT_LEASE_ITEM.PARKING_LOT"/>
        <bm:field name="car_commission" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CAR_COMMISSION" prompt="CON_CONTRACT_LEASE_ITEM.CAR_COMMISSION"/>
        <bm:field name="other_commission" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OTHER_COMMISSION" prompt="CON_CONTRACT_LEASE_ITEM.OTHER_COMMISSION"/>
        <bm:field name="vehicle_appearance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_APPEARANCE" prompt="CON_CONTRACT_LEASE_ITEM.VEHICLE_APPEARANCE"/>
        <bm:field name="personal_item_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PERSONAL_ITEM_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.PERSONAL_ITEM_FLAG"/>
        <bm:field name="goods_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GOODS_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.GOODS_FLAG"/>
        <bm:field name="spare_wheel_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SPARE_WHEEL_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.SPARE_WHEEL_FLAG"/>
        <bm:field name="storage_battery_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STORAGE_BATTERY_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.STORAGE_BATTERY_FLAG"/>
        <bm:field name="lease_item_seq" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_ITEM_SEQ" prompt="CON_CONTRACT_LEASE_ITEM.LEASE_ITEM_SEQ"/>
        <bm:field name="treasury_date" databaseType="DATE" datatype="java.util.Date" physicalName="TREASURY_DATE" prompt="CON_CONTRACT_LEASE_ITEM.TREASURY_DATE"/>
        <bm:field name="vehicle_storage_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_STORAGE_PLACE" prompt="CON_CONTRACT_LEASE_ITEM.VEHICLE_STORAGE_PLACE"/>
        <bm:field name="vehicle_check" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_CHECK" prompt="CON_CONTRACT_LEASE_ITEM.VEHICLE_CHECK"/>
        <bm:field name="license_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LICENSE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.LICENSE_FLAG"/>
        <bm:field name="mention_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MENTION_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.MENTION_FLAG"/>
        <bm:field name="onway_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ONWAY_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.ONWAY_FLAG"/>
        <bm:field name="vehicle_license_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_LICENSE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.VEHICLE_LICENSE_FLAG"/>
        <bm:field name="damage_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DAMAGE_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.DAMAGE_FLAG"/>
        <bm:field name="display_vehicles" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISPLAY_VEHICLES" prompt="CON_CONTRACT_LEASE_ITEM.DISPLAY_VEHICLES"/>
        <bm:field name="vis_major" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VIS_MAJOR" prompt="CON_CONTRACT_LEASE_ITEM.VIS_MAJOR"/>
        <bm:field name="mortgage_third_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_THIRD_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.MORTGAGE_THIRD_FLAG"/>
        <bm:field name="vehicle_others" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_OTHERS" prompt="CON_CONTRACT_LEASE_ITEM.VEHICLE_OTHERS"/>
        <bm:field name="et_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ET_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.ET_FLAG"/>
        <bm:field name="this_time_et_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="THIS_TIME_ET_FLAG" prompt="CON_CONTRACT_LEASE_ITEM.THIS_TIME_ET_FLAG"/>
        <bm:field name="change_req_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CHANGE_REQ_ID" prompt="CON_CONTRACT_LEASE_ITEM.CHANGE_REQ_ID"/>
        <bm:field name="finance_ratio" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FINANCE_RATIO" prompt="CON_CONTRACT_LEASE_ITEM.FINANCE_RATIO"/>
        <bm:field name="main_finance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAIN_FINANCE" prompt="CON_CONTRACT_LEASE_ITEM.MAIN_FINANCE"/>
        <bm:field name="configure" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFIGURE" prompt="CON_CONTRACT_LEASE_ITEM.CONFIGURE"/> -->
    </bm:fields>
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
               select t1.* from ( SELECT
                    t.contract_lease_item_id,
                    t.contract_id,
                    t.brand_id, --品牌
                    (SELECT
                        cb.description
                    FROM
                        hls_car_brands_vl cb
                    WHERE
                        cb.enabled_flag = 'Y' AND
                        cb.brand_id     = t.brand_id
                    ) brand_id_n,
                    t.series_id, --车系
                    (SELECT
                        cs.description
                    FROM
                        hls_car_series_vl cs
                    WHERE
                        cs.enabled_flag = 'Y' AND
                        cs.series_id    = t.series_id
                    ) series_id_n,
                    t.model_id, --车型
                    (SELECT
                        cm.description
                    FROM
                        hls_car_model_vl cm
                    WHERE
                        cm.enabled_flag = 'Y' AND
                        cm.model_id     = t.model_id
                    ) model_id_n,
                    t.manufacturer_id,
                    t.manufacturer_name,    --制造商
                    t.color_of_apprearance, --颜色
                    t.factory_date,         --出厂日期
                    t.item_frame_number,    --车架号
                    t.car_status,           --车辆状态
                    t.item_engine_number,   --发动机号
                    t.guide_price,          --指导价
                    t.finance_amount,       --实际融资额
                    t.invoice_date,         --开票日期
                    t.invoice_price,        --开票金额
                    t.mortgage_flag,        --是否办理抵押
                    t.finance_ratio,        --融资比例
                    t.configure,            --配置
                    t.main_finance,         --融资主体
                    (SELECT
                        scv.code_value_name
                    FROM
                        sys_code_values_v scv
                    WHERE
                        scv.code       = 'KR_CAR_STATUS' AND
                        scv.code_value = t.car_status
                    ) car_status_n,
                    (SELECT
                        scv.code_value_name
                    FROM
                        sys_code_values_v scv
                    WHERE
                        scv.code       = 'YES_NO' AND
                        scv.code_value = t.mortgage_flag
                    ) mortgage_flag_n
                FROM
                    con_contract_lease_item t
                    and t.contract_id = {@/contract_id}) t1
                    #WHERE_CLAUSE#
            ]]></bm:query-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                BEGIN
                    con_dff_car_displace_pkg.check_car_price(p_contract_id => {@/contract_id},p_user_id => ${/session/@user_id} };
                END;
                ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="contract_lease_item_id"/>
    </bm:primary-key>
</bm:model>
