<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: chenlingfeng $Date: 2017-6-2 10:50:39 $Revision: 1.0 $Purpose: --> <bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="HN_FND_BASE_RATE" defaultOrderBy="MONTHS_FROM desc"> <bm:fields> <bm:field name="base_rate_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BASE_RATE_ID"/> <bm:field name="batch_hd_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BATCH_HD_ID"/> <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="HLS.CURRENCY"/> <bm:field name="base_rate" databaseType="NUMBER" datatype="java.lang.Double" expression="(t1.base_rate*100)" insertExpression="(${@base_rate}/100)" physicalName="BASE_RATE" prompt="FND251.FND_BASE_RATE.BASE_RATE"/> <bm:field name="months_from" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MONTHS_FROM" prompt="FND251.FND_BASE_RATE.MONTHS_FROM"/> <bm:field name="months_to" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MONTHS_TO" prompt="FND251.FND_BASE_RATE.MONTHS_TO"/> <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="HLS.DESCRIPTION"/> </bm:fields> <bm:features> <f:standard-who/> <o:sequence-pk/> </bm:features> <bm:primary-key> <bm:pk-field name="base_rate_id"/> </bm:primary-key> <bm:data-filters> <bm:data-filter name="batch_hd_id" enforceOperations="query" expression="t1.batch_hd_id=${@batch_hd_id}"/> </bm:data-filters> </bm:model>