<?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="PRJ_QUOTATION_LV"> <bm:fields> <bm:field name="quotation_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="QUOTATION_ID" prompt="PRJ_QUOTATION_LV.QUOTATION_ID"/> <bm:field name="calc_session_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="CALC_SESSION_ID" prompt="PRJ_QUOTATION_LV.CALC_SESSION_ID"/> <bm:field name="document_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY" prompt="PRJ_QUOTATION_LV.DOCUMENT_CATEGORY"/> <bm:field name="document_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DOCUMENT_ID" prompt="PRJ_QUOTATION_LV.DOCUMENT_ID"/> <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PROJECT_ID" prompt="PRJ_QUOTATION_LV.PROJECT_ID"/> <bm:field name="price_list" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRICE_LIST" prompt="PRJ_QUOTATION_LV.PRICE_LIST"/> <bm:field name="price_list_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRICE_LIST_N" prompt="PRJ_QUOTATION_LV.PRICE_LIST_N"/> <bm:field name="hd_user_col_n12" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_N12" prompt="PRJ_QUOTATION_LV.HD_USER_COL_N12"/> <bm:field name="other_fee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OTHER_FEE" prompt="PRJ_QUOTATION_LV.OTHER_FEE"/> <bm:field name="residual_value" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDUAL_VALUE" prompt="PRJ_QUOTATION_LV.RESIDUAL_VALUE"/> <bm:field name="contract_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_AMOUNT" prompt="PRJ_QUOTATION_LV.CONTRACT_AMOUNT"/> <bm:field name="down_payment_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOWN_PAYMENT_RATIO" prompt="PRJ_QUOTATION_LV.DOWN_PAYMENT_RATIO"/> <bm:field name="down_payment" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOWN_PAYMENT" prompt="PRJ_QUOTATION_LV.DOWN_PAYMENT"/> <bm:field name="deposit_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_RATIO" prompt="PRJ_QUOTATION_LV.DEPOSIT_RATIO"/> <bm:field name="deposit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT" prompt="PRJ_QUOTATION_LV.DEPOSIT"/> <bm:field name="deposit_and_down_payment_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DEPOSIT_AND_DOWN_PAYMENT_RATIO" prompt="PRJ_QUOTATION_LV.DEPOSIT_AND_DOWN_PAYMENT_RATIO"/> <bm:field name="deposit_and_down_payment" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DEPOSIT_AND_DOWN_PAYMENT" prompt="PRJ_QUOTATION_LV.DEPOSIT_AND_DOWN_PAYMENT"/> <bm:field name="lease_term" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_TERM" prompt="PRJ_QUOTATION_LV.LEASE_TERM"/> <bm:field name="value_added_tax" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VALUE_ADDED_TAX" prompt="PRJ_QUOTATION_LV.VALUE_ADDED_TAX"/> <bm:field name="mouth_rental" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MOUTH_RENTAL" prompt="PRJ_QUOTATION_LV.MOUTH_RENTAL"/> <bm:field name="day_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DAY_RENTAL" prompt="PRJ_QUOTATION_LV.DAY_RENTAL"/> <bm:field name="lease_times" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_TIMES" prompt="PRJ_QUOTATION_LV.LEASE_TIMES"/> <bm:field name="first_time_pay" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FIRST_TIME_PAY" prompt="PRJ_QUOTATION_LV.FIRST_TIME_PAY"/> <bm:field name="insurance_fee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_FEE" prompt="PRJ_QUOTATION_LV.INSURANCE_FEE"/> <bm:field name="lease_item_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_ITEM_AMOUNT" prompt="PRJ_QUOTATION_LV.LEASE_ITEM_AMOUNT"/> <bm:field name="finance_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FINANCE_AMOUNT" prompt="PRJ_QUOTATION_LV.FINANCE_AMOUNT"/> <bm:field name="annual_pay_times" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ANNUAL_PAY_TIMES" prompt="PRJ_QUOTATION_LV.ANNUAL_PAY_TIMES"/> <bm:field name="lease_charge_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHARGE_RATIO" prompt="PRJ_QUOTATION_LV.LEASE_CHARGE_RATIO"/> <bm:field name="lease_charge" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHARGE" prompt="PRJ_QUOTATION_LV.LEASE_CHARGE"/> <bm:field name="int_rate_display" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INT_RATE_DISPLAY" prompt="PRJ_QUOTATION_LV.INT_RATE_DISPLAY"/> <bm:field name="return_value" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RETURN_VALUE" prompt="PRJ_QUOTATION_LV.RETURN_VALUE"/> <bm:field name="return_value_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RETURN_VALUE_RATIO" prompt="PRJ_QUOTATION_LV.RETURN_VALUE_RATIO"/> <bm:field name="pay_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PAY_TYPE" prompt="PRJ_QUOTATION_LV.PAY_TYPE"/> <bm:field name="pay_type_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PAY_TYPE_N" prompt="PRJ_QUOTATION_LV.PAY_TYPE_N"/> <bm:field name="other_fee2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OTHER_FEE2" prompt="PRJ_QUOTATION_LV.OTHER_FEE2"/> <bm:field name="hd_user_col_n04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_N04" prompt="PRJ_QUOTATION_LV.HD_USER_COL_N04"/> <bm:field name="finance_income" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FINANCE_INCOME" prompt="PRJ_QUOTATION_LV.FINANCE_INCOME"/> <bm:field name="hd_user_col_n06" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_N06" prompt="PRJ_QUOTATION_LV.HD_USER_COL_N06"/> <bm:field name="balloon" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BALLOON" prompt="PRJ_QUOTATION_LV.BALLOON"/> <bm:field name="irr" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="IRR" prompt="PRJ_QUOTATION_LV.IRR"/> <bm:field name="other_fee3" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OTHER_FEE3" prompt="PRJ_QUOTATION_LV.OTHER_FEE3"/> <bm:field name="hd_user_col_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V04" prompt="PRJ_QUOTATION_LV.HD_USER_COL_V04"/> <bm:field name="total_rental" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TOTAL_RENTAL" prompt="PRJ_QUOTATION_LV.TOTAL_RENTAL"/> </bm:fields> <bm:features> <f:standard-who/> </bm:features> <bm:data-filters> <bm:data-filter name="project_id" enforceOperations="query" expression="t1.project_id=${@project_id}"/> </bm:data-filters> </bm:model>