<?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>