<?xml version="1.0" encoding="UTF-8"?>

<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
select price_list,
       column_name,
       prompt,
       data_type,
       display_flag,
       input_mode,
       validation_type,
       lov_return_vcode,
       percent,
       default_value,
       upper_limit,
       lower_limit,
       validation_sql
  from hls_fin_calc_config
 where PRICE_LIST = ${@price_list}
   and LAYOUT_AREA_SEQ = 'H'
   and (COLUMN_NAME = 'LEASE_ITEM_AMOUNT' or
       COLUMN_NAME = 'DOWN_PAYMENT_RATIO' or COLUMN_NAME = 'DOWN_PAYMENT' or COLUMN_NAME = 'INT_RATE' or
       COLUMN_NAME = 'ANNUAL_PAY_TIMES' or COLUMN_NAME = 'LEASE_TIMES' or
       COLUMN_NAME = 'BALLOON_RATIO' or COLUMN_NAME = 'BALLOON' or COLUMN_NAME = 'PAY_TYPE')
   order by COLUMN_NAME asc
]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="price_list" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRICE_LIST"/>
        <bm:field name="column_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLUMN_NAME"/>
        <bm:field name="prompt" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROMPT"/>
        <bm:field name="data_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DATA_NAME"/>
        <bm:field name="display_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISPLAY_FLAG"/>    
        <bm:field name="input_mode" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INPUT_MODE"/> 
        <bm:field name="validation_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VALIDATION_TYPE"/>  
        <bm:field name="lov_return_vcode" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOV_RETURN_VCODE"/>   
        <bm:field name="percent" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PERCENT"/>         
        <bm:field name="default_value" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEFAULT_VALUE"/>     
        <bm:field name="upper_limit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UPPER_LIMIT"/>   
        <bm:field name="lower_limit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOWER_LIMIT"/>
        <bm:field name="validation_sql" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VALIDATION_SQL"/>                                                                       
    </bm:fields>
</bm:model>
