<?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 h.irr irr,
h.lease_charge,
h.deposit,
h.lease_item_amount,
h.down_payment,
h.hd_user_col_n06*100 hd_user_col_n06,
h.financing_cost,
    T.times times,
       t.rental rental,
       t.due_date,
       t.principal principal,
       t.interest interest,
       T.outstanding_rental_tax_incld
  from hls_fin_calculator_ln_lv T,hls_fin_calculator_hd h 
  where h.calc_session_id = T.calc_session_id
  and h.calc_session_id = ${@calc_session_id}
  order by times
  
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="down_payment"/>
        <bm:field name="irr"/>
        <bm:field name="lease_charge"/>
        <bm:field name="deposit"/>
        <bm:field name="lease_item_amount"/>
        <bm:field name="hd_user_col_n06"/>
        <bm:field name="financing_cost"/>
        <bm:field name="times"/>
        <bm:field name="due_date"/>
        <bm:field name="principal"/>
        <bm:field name="interest"/>
        <bm:field name="outstanding_rental_tax_incld"/>
        <bm:field name="rental"/>
    </bm:fields>
</bm:model>
