rpt5010_result_query.lwm 22.6 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211
<?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
                    to_Char(amount_1,'FM999,999,999,999,990.00') amount_1,
                    to_Char(principal_1,'FM999,999,999,999,990.00') principal_1,
                    to_Char(interest_1,'FM999,999,999,999,990.00') interest_1,
                    to_Char(amount_2,'FM999,999,999,999,990.00') amount_2,
                    to_Char(principal_2,'FM999,999,999,999,990.00') principal_2,
                    to_Char(interest_2,'FM999,999,999,999,990.00') interest_2,
                    to_Char(amount_3,'FM999,999,999,999,990.00') amount_3,
                    to_Char(principal_3,'FM999,999,999,999,990.00') principal_3,
                    to_Char(interest_3,'FM999,999,999,999,990.00') interest_3,
                    to_Char(amount_4,'FM999,999,999,999,990.00') amount_4,
                    to_Char(principal_4,'FM999,999,999,999,990.00') principal_4,
                    to_Char(interest_4,'FM999,999,999,999,990.00') interest_4,
                    to_Char(amount_5,'FM999,999,999,999,990.00') amount_5,
                    to_Char(principal_5,'FM999,999,999,999,990.00') principal_5,
                    to_Char(interest_5,'FM999,999,999,999,990.00') interest_5,
                    to_Char(amount_6,'FM999,999,999,999,990.00') amount_6,
                    to_Char(principal_6,'FM999,999,999,999,990.00') principal_6,
                    to_Char(interest_6,'FM999,999,999,999,990.00') interest_6,
                    to_Char(amount_7,'FM999,999,999,999,990.00') amount_7,
                    to_Char(principal_7,'FM999,999,999,999,990.00') principal_7,
                    to_Char(interest_7,'FM999,999,999,999,990.00') interest_7,
                    to_Char(amount_8,'FM999,999,999,999,990.00') amount_8,
                    to_Char(principal_8,'FM999,999,999,999,990.00') principal_8,
                    to_Char(interest_8,'FM999,999,999,999,990.00') interest_8,
                    to_Char(amount_9,'FM999,999,999,999,990.00') amount_9,
                    to_Char(principal_9,'FM999,999,999,999,990.00') principal_9,
                    to_Char(interest_9,'FM999,999,999,999,990.00') interest_9,
                    to_Char(amount_10,'FM999,999,999,999,990.00') amount_10,
                    to_Char(principal_10,'FM999,999,999,999,990.00') principal_10,
                    to_Char(interest_10,'FM999,999,999,999,990.00') interest_10,
                    to_Char(amount_11,'FM999,999,999,999,990.00') amount_11,
                    to_Char(principal_11,'FM999,999,999,999,990.00') principal_11,
                    to_Char(interest_11,'FM999,999,999,999,990.00') interest_11,
                    to_Char(amount_12,'FM999,999,999,999,990.00') amount_12,
                    to_Char(principal_12,'FM999,999,999,999,990.00') principal_12,
                    to_Char(interest_12,'FM999,999,999,999,990.00') interest_12,
                    to_Char(amount_13,'FM999,999,999,999,990.00')amount_13,
                    to_Char(principal_13,'FM999,999,999,999,990.00') principal_13,
                    to_Char(interest_13,'FM999,999,999,999,990.00') interest_13,
                    to_Char(amount_14,'FM999,999,999,999,990.00') amount_14,
                    to_Char(principal_14,'FM999,999,999,999,990.00') principal_14,
                    to_Char(interest_14,'FM999,999,999,999,990.00') interest_14,
                    to_Char(amount_15,'FM999,999,999,999,990.00') amount_15,
                    to_Char(principal_15,'FM999,999,999,999,990.00') principal_15,
                    to_Char(interest_15,'FM999,999,999,999,990.00') interest_15,
                    to_Char(amount_16,'FM999,999,999,999,990.00') amount_16,
                    to_Char(principal_16,'FM999,999,999,999,990.00') principal_16,
                    to_Char(interest_16,'FM999,999,999,999,990.00') interest_16,
                    to_Char(amount_17,'FM999,999,999,999,990.00') amount_17,
                    to_Char(principal_17,'FM999,999,999,999,990.00') principal_17,
                    to_Char(interest_17,'FM999,999,999,999,990.00') interest_17,
                    to_Char(amount_18,'FM999,999,999,999,990.00') amount_18,
                    to_Char(principal_18,'FM999,999,999,999,990.00') principal_18,
                    to_Char(interest_18,'FM999,999,999,999,990.00') interest_18,
                    to_Char(amount_19,'FM999,999,999,999,990.00') amount_19,
                    to_Char(principal_19,'FM999,999,999,999,990.00') principal_19,
                    to_Char(interest_19,'FM999,999,999,999,990.00') interest_19,
                    to_Char(amount_20,'FM999,999,999,999,990.00') amount_20,
                    to_Char(principal_20,'FM999,999,999,999,990.00') principal_20,
                    to_Char(interest_20,'FM999,999,999,999,990.00') interest_20,
                    to_Char(amount_21,'FM999,999,999,999,990.00') amount_21,
                    to_Char(principal_21,'FM999,999,999,999,990.00') principal_21,
                    to_Char(interest_21,'FM999,999,999,999,990.00')interest_21,
                    to_Char(amount_22,'FM999,999,999,999,990.00') amount_22,
                    to_Char(principal_22,'FM999,999,999,999,990.00') principal_22,
                    to_Char(interest_22,'FM999,999,999,999,990.00') interest_22,
                    to_Char(amount_23,'FM999,999,999,999,990.00') amount_23,
                    to_Char(principal_23,'FM999,999,999,999,990.00') principal_23,
                    to_Char(interest_23,'FM999,999,999,999,990.00') interest_23,
                    to_Char(amount_24,'FM999,999,999,999,990.00') amount_24,
                    to_Char(principal_24,'FM999,999,999,999,990.00') principal_24,
                    to_Char(interest_24,'FM999,999,999,999,990.00') interest_24,
                    to_Char(amount_25,'FM999,999,999,999,990.00') amount_25,
                    to_Char(principal_25,'FM999,999,999,999,990.00') principal_25,
                    to_Char(interest_25,'FM999,999,999,999,990.00') interest_25,
                    to_Char(amount_26,'FM999,999,999,999,990.00') amount_26,
                    to_Char(principal_26,'FM999,999,999,999,990.00') principal_26,
                    to_Char(interest_26,'FM999,999,999,999,990.00') interest_26,
                    to_Char(amount_27,'FM999,999,999,999,990.00') amount_27,
                    to_Char(principal_27,'FM999,999,999,999,990.00') principal_27,
                    to_Char(interest_27,'FM999,999,999,999,990.00') interest_27,
                    to_Char(amount_28,'FM999,999,999,999,990.00') amount_28,
                    to_Char(principal_28,'FM999,999,999,999,990.00') principal_28,
                    to_Char(interest_28,'FM999,999,999,999,990.00') interest_28,
                    to_Char(amount_29,'FM999,999,999,999,990.00') amount_29,
                    to_Char(principal_29,'FM999,999,999,999,990.00') principal_29,
                    to_Char(interest_29,'FM999,999,999,999,990.00') interest_29,
                    to_Char(amount_30,'FM999,999,999,999,990.00') amount_30,
                    to_Char(principal_30,'FM999,999,999,999,990.00') principal_30,
                    to_Char(interest_30,'FM999,999,999,999,990.00') interest_30,
                    to_Char(amount_31,'FM999,999,999,999,990.00') amount_31,
                    to_Char(principal_31,'FM999,999,999,999,990.00') principal_31,
                    to_Char(interest_31,'FM999,999,999,999,990.00') interest_31,
                    t1.contract_id,
                    t1.contract_number,
                    t1.tenant_name,
                    t1.record_id
                FROM
                    RPT5010_DAY_REPORT T1 #WHERE_CLAUSE#
                    order  BY T1.contract_id desc
            ]]></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>