rpt5014_result_query.lwm

<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                select null agent_extra_name, --代理店简称
               null null_column,
       (SELECT m.bp_name
          FROM hls_bp_master m
         WHERE m.bp_id = ct.bp_id_tenant) AS bp_tenant_name, --承租人名称
       null branch_company, --分公司
       ct.contract_number, --合同编号
       to_char(ct.lease_start_date, 'yyyy-mm-dd') lease_start_date, --租赁期开始日
       (select to_char(due_date, 'yyyy-mm-dd')
          from con_contract_cashflow
         where contract_id = ct.contract_id
           and cf_item = 8
		   and cf_status='RELEASE') residual_date, -- 合同终了
       to_char(ct.et_date, 'yyyy-mm-dd') terminate_date, --合同到期日
       (SELECT i.machine_number
          FROM con_contract_lease_item i
         WHERE i.contract_id = ct.contract_id
           AND i.equipment_type = 'MAIN') machine_number, --机号
       (SELECT ccli.modelcd
          FROM con_contract_lease_item ccli
         WHERE ccli.contract_id = ct.contract_id) modelcd, --机型

       NVL(ct.total_rental, 0) + NVL(ct.down_payment, 0) +
       NVL(ct.residual_value, 0) contract_amount, --合同金额
       ct.lease_times, --租赁期间
       ct.lease_item_amount as lease_item_amount, --设备款
       NVL(ct.down_payment, 0) down_payment, --首付款
       NVL(ct.residual_value, 0) residual_amount, --留购金


       NVL(ct.down_payment, 0)+nvl((select sum(nvl((SELECT SUM(nvl(cwo.write_off_due_amount, 0))
             FROM csh_write_off cwo, csh_transaction cn
            WHERE nvl(cwo.reversed_flag, 'N') = 'N'
              AND cwo.contract_id = ccw.contract_id
              AND cwo.times = ccw.times
              and cwo.csh_transaction_id = cn.transaction_id
              AND cwo.cf_item = ccw.cf_item
              and trunc(cn.transaction_date) <=
                  trunc(to_date(${@before_end}, 'yyyy-mm-dd'))),
           0))
          from con_contract_cashflow ccw
         where ccw.contract_id = ct.contract_id
           and ccw.cf_status = 'RELEASE'
           and ccw.cf_direction = 'INFLOW'
           and ccw.cf_item in (1,8)
           and trunc(ccw.due_date) <=
               trunc(to_date(${@before_end}, 'yyyy-mm-dd'))) ,0)before_received_amount ,--截至上月底已收的

       (NVL(ct.total_rental, 0) + NVL(ct.residual_value, 0)-nvl( (select sum(nvl((SELECT SUM(nvl(cwo.write_off_due_amount, 0))
             FROM csh_write_off cwo, csh_transaction cn
            WHERE nvl(cwo.reversed_flag, 'N') = 'N'
              AND cwo.contract_id = ccw.contract_id
              AND cwo.times = ccw.times
              and cwo.csh_transaction_id = cn.transaction_id
              AND cwo.cf_item = ccw.cf_item
              and trunc(cn.transaction_date) <=
                  trunc(to_date(${@before_end}, 'yyyy-mm-dd'))),
           0))
          from con_contract_cashflow ccw
         where ccw.contract_id = ct.contract_id
           and ccw.cf_status = 'RELEASE'
           and ccw.cf_direction = 'INFLOW'
           and ccw.cf_item in (1,8)
           and trunc(ccw.due_date) <=
               trunc(to_date(${@before_end}, 'yyyy-mm-dd'))),0)) before_due_left, --上月末应收款余额

       (select ccw.times
          from con_contract_cashflow ccw
         where ccw.contract_id = ct.contract_id
           and ccw.cf_item in (1, 200, 250)
           and ccw.cf_status = 'RELEASE'
           and ccw.cf_direction = 'INFLOW'
           and trunc(ccw.due_date) <=
               trunc(to_date(${@cur_end}, 'yyyy-mm-dd'))
           and trunc(ccw.due_date) >=
               trunc(to_date(${@cur_begin}, 'yyyy-mm-dd'))
           and rownum = 1) times, --当月期次

       (select to_char(ccw.due_date, 'yyyy-mm-dd')
          from con_contract_cashflow ccw
         where ccw.contract_id = ct.contract_id
           and ccw.cf_item in (1, 200, 250)
           and ccw.cf_status = 'RELEASE'
           and ccw.cf_direction = 'INFLOW'
           and trunc(ccw.due_date) <=
               trunc(to_date(${@cur_end}, 'yyyy-mm-dd'))
           and trunc(ccw.due_date) >=
               trunc(to_date(${@cur_begin}, 'yyyy-mm-dd'))
           and rownum = 1) due_date, --当月应收日期

       (select sum(ccw.due_amount)
          from con_contract_cashflow ccw
         where ccw.contract_id = ct.contract_id
           and ccw.cf_item in (1)
           and ccw.cf_status = 'RELEASE'
           and ccw.cf_direction = 'INFLOW'
           and trunc(ccw.due_date) <=
               trunc(to_date(${@cur_end}, 'yyyy-mm-dd'))
           and trunc(ccw.due_date) >=
               trunc(to_date(${@cur_begin}, 'yyyy-mm-dd'))) due_amount, --当月应收租金

       0 advance_received_amount, --截止上月末提前支付

       (select sum(ccw.due_amount - nvl((SELECT SUM(nvl(cwo.write_off_due_amount, 0))
             FROM csh_write_off cwo, csh_transaction cn
            WHERE nvl(cwo.reversed_flag, 'N') = 'N'
              AND cwo.contract_id = ccw.contract_id
              AND cwo.times = ccw.times
              and cwo.csh_transaction_id = cn.transaction_id
              AND cwo.cf_item = ccw.cf_item
              and trunc(cn.transaction_date) <=
                  trunc(to_date(${@before_end}, 'yyyy-mm-dd'))),
           0))
          from con_contract_cashflow ccw
         where ccw.contract_id = ct.contract_id
           and ccw.cf_status = 'RELEASE'
           and ccw.cf_direction = 'INFLOW'
           and ccw.cf_item in (1)
           and trunc(ccw.due_date) <=
               trunc(to_date(${@before_end}, 'yyyy-mm-dd'))) before_overdue_amount, --截止上月末逾期租金

       (nvl((select sum(ccw.due_amount)
              from con_contract_cashflow ccw
             where ccw.contract_id = ct.contract_id
               and ccw.cf_item in (1)
               and ccw.cf_status = 'RELEASE'
               and ccw.cf_direction = 'INFLOW'
               and trunc(ccw.due_date) <=
                   trunc(to_date(${@cur_end}, 'yyyy-mm-dd'))
               and trunc(ccw.due_date) >=
                   trunc(to_date(${@cur_begin}, 'yyyy-mm-dd'))),
            0) +
       nvl((select sum(ccw.due_amount - nvl((SELECT SUM(nvl(cwo.write_off_due_amount, 0))
             FROM csh_write_off cwo, csh_transaction cn
            WHERE nvl(cwo.reversed_flag, 'N') = 'N'
              AND cwo.contract_id = ccw.contract_id
              AND cwo.times = ccw.times
              and cwo.csh_transaction_id = cn.transaction_id
              AND cwo.cf_item = ccw.cf_item
              and trunc(cn.transaction_date) <=
                  trunc(to_date(${@before_end}, 'yyyy-mm-dd'))),
           0))
              from con_contract_cashflow ccw
             where ccw.contract_id = ct.contract_id
               and ccw.cf_status = 'RELEASE'
               and ccw.cf_direction = 'INFLOW'
               and ccw.cf_item in (1)
               and trunc(ccw.due_date) <=
                   trunc(to_date(${@before_end}, 'yyyy-mm-dd'))),
            0)) due_total, --本月合计应收

       con_contract_pkg.get_business_times(p_contract_id => ct.contract_id, p_calc_date => to_date(${@cur_end}, 'yyyy-mm-dd'), p_contract_inception_date => ct.contract_inception_date) over_due_times, --逾期期次

       (SELECT SUM(cwo.write_off_due_amount)
          FROM csh_transaction t, csh_write_off cwo
         WHERE cwo.cf_item in (1, 8, 9)
         and cwo.contract_id=ct.contract_id
           AND t.transaction_id = cwo.csh_transaction_id
           AND NVL(cwo.reversed_flag, 'N') = 'N'
           and nvl(t.reversed_flag, 'N') = 'N'
           AND TRUNC(T.transaction_date) <=
               TRUNC(to_date(${@cur_end}, 'yyyy-mm-dd'))
           AND TRUNC(T.transaction_date) >=
               TRUNC(to_date(${@cur_begin}, 'yyyy-mm-dd'))) cur_real,
       (SELECT SUM(cwo.write_off_due_amount)
          FROM csh_transaction t, csh_write_off cwo
         WHERE cwo.cf_item in (1, 8, 9)
         and cwo.contract_id=ct.contract_id
           AND t.transaction_id = cwo.csh_transaction_id
           AND NVL(cwo.reversed_flag, 'N') = 'N'
           and nvl(t.reversed_flag, 'N') = 'N'
           AND TRUNC(T.transaction_date) <=
               trunc(add_months(to_date(${@month}, 'YYYYMM'), 0)-1)
           AND TRUNC(T.transaction_date) >=
                trunc(add_months(to_date(${@month}, 'YYYYMM'), -1))) before1_real,
       (SELECT SUM(cwo.write_off_due_amount)
          FROM csh_transaction t, csh_write_off cwo
         WHERE cwo.cf_item in (1, 8, 9)
         and cwo.contract_id=ct.contract_id
           AND t.transaction_id = cwo.csh_transaction_id
           AND NVL(cwo.reversed_flag, 'N') = 'N'
           and nvl(t.reversed_flag, 'N') = 'N'
          AND TRUNC(T.transaction_date) <=
               trunc(add_months(to_date(${@month}, 'YYYYMM'), -1)-1)
           AND TRUNC(T.transaction_date) >=
                trunc(add_months(to_date(${@month}, 'YYYYMM'), -2))) before2_real,
       (SELECT SUM(cwo.write_off_due_amount)
          FROM csh_transaction t, csh_write_off cwo
         WHERE cwo.cf_item in (1, 8, 9)
         and cwo.contract_id=ct.contract_id
           AND t.transaction_id = cwo.csh_transaction_id
           AND NVL(cwo.reversed_flag, 'N') = 'N'
           and nvl(t.reversed_flag, 'N') = 'N'
           AND TRUNC(T.transaction_date) <=
               trunc(add_months(to_date(${@month}, 'YYYYMM'), -2)-1)
           AND TRUNC(T.transaction_date) >=
                trunc(add_months(to_date(${@month}, 'YYYYMM'), -3))) before3_real,
       (SELECT SUM(cwo.write_off_due_amount)
          FROM csh_transaction t, csh_write_off cwo
         WHERE cwo.cf_item in (1, 8, 9)
         and cwo.contract_id=ct.contract_id
           AND t.transaction_id = cwo.csh_transaction_id
           AND NVL(cwo.reversed_flag, 'N') = 'N'
           and nvl(t.reversed_flag, 'N') = 'N'
           AND TRUNC(T.transaction_date) <=
               trunc(add_months(to_date(${@month}, 'YYYYMM'), -3)-1)
           AND TRUNC(T.transaction_date) >=
                trunc(add_months(to_date(${@month}, 'YYYYMM'), -4))) before4_real,
       (SELECT SUM(cwo.write_off_due_amount)
          FROM csh_transaction t, csh_write_off cwo
         WHERE cwo.cf_item in (1, 8, 9)
         and cwo.contract_id=ct.contract_id
           AND t.transaction_id = cwo.csh_transaction_id
           AND NVL(cwo.reversed_flag, 'N') = 'N'
           and nvl(t.reversed_flag, 'N') = 'N'
          AND TRUNC(T.transaction_date) <=
               trunc(add_months(to_date(${@month}, 'YYYYMM'), -4)-1)
           AND TRUNC(T.transaction_date) >=
                trunc(add_months(to_date(${@month}, 'YYYYMM'), -5))) before5_real

  from con_contract ct
 where ct.contract_status = 'INCEPT'
 and ct.data_class='NORMAL'
   and con_contract_pkg.get_business_times(p_contract_id => ct.contract_id,
                                                p_calc_date   => to_date(${@cur_end},
                                                                         'yyyy-mm-dd'),
                                                p_contract_inception_date        => ct.contract_inception_date) >= 3
 order by ct.bp_id_agent_level1
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <!--   <bm:fields>
        <bm:field name="record_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECORD_ID" prompt="RPT5010_DAY_REPORT.RECORD_ID"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="RPT5010_DAY_REPORT.CONTRACT_ID"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="RPT5010_DAY_REPORT.CONTRACT_NUMBER"/>
        <bm:field name="tenant_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TENANT_NAME" prompt="RPT5010_DAY_REPORT.TENANT"/>
        <bm:field name="amount_1" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_1" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_1"/>
        <bm:field name="principal_1" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_1" prompt="RPT5010_DAY_REPORT.PRINCIPAL_1"/>
        <bm:field name="interest_1" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_1" prompt="RPT5010_DAY_REPORT.INTEREST_1"/>
        <bm:field name="amount_2" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_2" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_2"/>
        <bm:field name="principal_2" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_2" prompt="RPT5010_DAY_REPORT.PRINCIPAL_2"/>
        <bm:field name="interest_2" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_2" prompt="RPT5010_DAY_REPORT.INTEREST_2"/>
        <bm:field name="amount_3" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_3" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_3"/>
        <bm:field name="principal_3" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_3" prompt="RPT5010_DAY_REPORT.PRINCIPAL_3"/>
        <bm:field name="interest_3" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_3" prompt="RPT5010_DAY_REPORT.INTEREST_3"/>
        <bm:field name="amount_4" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_4" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_4"/>
        <bm:field name="principal_4" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_4" prompt="RPT5010_DAY_REPORT.PRINCIPAL_4"/>
        <bm:field name="interest_4" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_4" prompt="RPT5010_DAY_REPORT.INTEREST_4"/>
        <bm:field name="amount_5" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_5" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_5"/>
        <bm:field name="principal_5" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_5" prompt="RPT5010_DAY_REPORT.PRINCIPAL_5"/>
        <bm:field name="interest_5" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_5" prompt="RPT5010_DAY_REPORT.INTEREST_5"/>
        <bm:field name="amount_6" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_6" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_6"/>
        <bm:field name="principal_6" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_6" prompt="RPT5010_DAY_REPORT.PRINCIPAL_6"/>
        <bm:field name="interest_6" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_6" prompt="RPT5010_DAY_REPORT.INTEREST_6"/>
        <bm:field name="amount_7" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_7" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_7"/>
        <bm:field name="principal_7" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_7" prompt="RPT5010_DAY_REPORT.PRINCIPAL_7"/>
        <bm:field name="interest_7" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_7" prompt="RPT5010_DAY_REPORT.INTEREST_7"/>
        <bm:field name="amount_8" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_8" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_8"/>
        <bm:field name="principal_8" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_8" prompt="RPT5010_DAY_REPORT.PRINCIPAL_8"/>
        <bm:field name="interest_8" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_8" prompt="RPT5010_DAY_REPORT.INTEREST_8"/>
        <bm:field name="amount_9" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_9" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_9"/>
        <bm:field name="principal_9" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_9" prompt="RPT5010_DAY_REPORT.PRINCIPAL_9"/>
        <bm:field name="interest_9" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_9" prompt="RPT5010_DAY_REPORT.INTEREST_9"/>
        <bm:field name="amount_10" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_10" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_10"/>
        <bm:field name="principal_10" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_10" prompt="RPT5010_DAY_REPORT.PRINCIPAL_10"/>
        <bm:field name="interest_10" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_10" prompt="RPT5010_DAY_REPORT.INTEREST_10"/>
        <bm:field name="amount_11" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_11" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_11"/>
        <bm:field name="principal_11" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_11" prompt="RPT5010_DAY_REPORT.PRINCIPAL_11"/>
        <bm:field name="interest_11" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_11" prompt="RPT5010_DAY_REPORT.INTEREST_11"/>
        <bm:field name="amount_12" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_12" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_12"/>
        <bm:field name="principal_12" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_12" prompt="RPT5010_DAY_REPORT.PRINCIPAL_12"/>
        <bm:field name="interest_12" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_12" prompt="RPT5010_DAY_REPORT.INTEREST_12"/>
        <bm:field name="amount_13" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_13" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_13"/>
        <bm:field name="principal_13" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_13" prompt="RPT5010_DAY_REPORT.PRINCIPAL_13"/>
        <bm:field name="interest_13" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_13" prompt="RPT5010_DAY_REPORT.INTEREST_13"/>
        <bm:field name="amount_14" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_14" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_14"/>
        <bm:field name="principal_14" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_14" prompt="RPT5010_DAY_REPORT.PRINCIPAL_14"/>
        <bm:field name="interest_14" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_14" prompt="RPT5010_DAY_REPORT.INTEREST_14"/>
        <bm:field name="amount_15" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_15" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_15"/>
        <bm:field name="principal_15" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_15" prompt="RPT5010_DAY_REPORT.PRINCIPAL_15"/>
        <bm:field name="interest_15" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_15" prompt="RPT5010_DAY_REPORT.INTEREST_15"/>
        <bm:field name="amount_16" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_16" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_16"/>
        <bm:field name="principal_16" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_16" prompt="RPT5010_DAY_REPORT.PRINCIPAL_16"/>
        <bm:field name="interest_16" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_16" prompt="RPT5010_DAY_REPORT.INTEREST_16"/>
        <bm:field name="amount_17" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_17" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_17"/>
        <bm:field name="principal_17" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_17" prompt="RPT5010_DAY_REPORT.PRINCIPAL_17"/>
        <bm:field name="interest_17" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_17" prompt="RPT5010_DAY_REPORT.INTEREST_17"/>
        <bm:field name="amount_18" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_18" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_18"/>
        <bm:field name="principal_18" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_18" prompt="RPT5010_DAY_REPORT.PRINCIPAL_18"/>
        <bm:field name="interest_18" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_18" prompt="RPT5010_DAY_REPORT.INTEREST_18"/>
        <bm:field name="amount_19" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_19" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_19"/>
        <bm:field name="principal_19" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_19" prompt="RPT5010_DAY_REPORT.PRINCIPAL_19"/>
        <bm:field name="interest_19" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_19" prompt="RPT5010_DAY_REPORT.INTEREST_19"/>
        <bm:field name="amount_20" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_20" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_20"/>
        <bm:field name="principal_20" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_20" prompt="RPT5010_DAY_REPORT.PRINCIPAL_20"/>
        <bm:field name="interest_20" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_20" prompt="RPT5010_DAY_REPORT.INTEREST_20"/>
        <bm:field name="amount_21" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_21" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_21"/>
        <bm:field name="principal_21" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_21" prompt="RPT5010_DAY_REPORT.PRINCIPAL_21"/>
        <bm:field name="interest_21" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_21" prompt="RPT5010_DAY_REPORT.INTEREST_21"/>
        <bm:field name="amount_22" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_22" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_22"/>
        <bm:field name="principal_22" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_22" prompt="RPT5010_DAY_REPORT.PRINCIPAL_22"/>
        <bm:field name="interest_22" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_22" prompt="RPT5010_DAY_REPORT.INTEREST_22"/>
        <bm:field name="amount_23" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_23" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_23"/>
        <bm:field name="principal_23" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_23" prompt="RPT5010_DAY_REPORT.PRINCIPAL_23"/>
        <bm:field name="interest_23" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_23" prompt="RPT5010_DAY_REPORT.INTEREST_23"/>
        <bm:field name="amount_24" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_24" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_24"/>
        <bm:field name="principal_24" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_24" prompt="RPT5010_DAY_REPORT.PRINCIPAL_24"/>
        <bm:field name="interest_24" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_24" prompt="RPT5010_DAY_REPORT.INTEREST_24"/>
        <bm:field name="amount_25" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_25" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_25"/>
        <bm:field name="principal_25" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_25" prompt="RPT5010_DAY_REPORT.PRINCIPAL_25"/>
        <bm:field name="interest_25" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_25" prompt="RPT5010_DAY_REPORT.INTEREST_25"/>
        <bm:field name="amount_26" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_26" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_26"/>
        <bm:field name="principal_26" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_26" prompt="RPT5010_DAY_REPORT.PRINCIPAL_26"/>
        <bm:field name="interest_26" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_26" prompt="RPT5010_DAY_REPORT.INTEREST_26"/>
        <bm:field name="amount_27" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_27" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_27"/>
        <bm:field name="principal_27" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_27" prompt="RPT5010_DAY_REPORT.PRINCIPAL_27"/>
        <bm:field name="interest_27" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_27" prompt="RPT5010_DAY_REPORT.INTEREST_27"/>
        <bm:field name="amount_28" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_28" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_28"/>
        <bm:field name="principal_28" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_28" prompt="RPT5010_DAY_REPORT.PRINCIPAL_28"/>
        <bm:field name="interest_28" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_28" prompt="RPT5010_DAY_REPORT.INTEREST_28"/>
        <bm:field name="amount_29" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_29" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_29"/>
        <bm:field name="principal_29" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_29" prompt="RPT5010_DAY_REPORT.PRINCIPAL_29"/>
        <bm:field name="interest_29" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_29" prompt="RPT5010_DAY_REPORT.INTEREST_29"/>
        <bm:field name="amount_30" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_30" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_30"/>
        <bm:field name="principal_30" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_30" prompt="RPT5010_DAY_REPORT.PRINCIPAL_30"/>
        <bm:field name="interest_30" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_30" prompt="RPT5010_DAY_REPORT.INTEREST_30"/>
        <bm:field name="amount_31" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT_31" prompt="RPT5010_DAY_REPORT.ATTRIBUTE_31"/>
        <bm:field name="principal_31" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_31" prompt="RPT5010_DAY_REPORT.PRINCIPAL_31"/>
        <bm:field name="interest_31" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_31" prompt="RPT5010_DAY_REPORT.INTEREST_31"/>
        </bm:fields> -->
    <bm:data-filters><![CDATA[
    ]]></bm:data-filters>
</bm:model>