Skip to content

L
leaf-hlcm
Switch branch/tag
Find file
Normal viewHistoryPermalink
wfl_prj_quotation_lv.lwm 7.25 KB
Newer Older
Spencer Chang's avatar
Initial commit
bfd31bca
 
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 
<?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>