<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: WangYu  
    $Date: 2014-4-25 上午09:31:11  
    $Revision: 1.0  
    $Purpose: 
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
    <a:view>
        <a:link id="con_cashflow_pre_query_id" model="cont.CON930.con_contract_cashflow_monthly" modelaction="update"/>
        <script><![CDATA[
            function CON321_con_contract_query() {
                if ($('con_contract_cashflow_monthly_query_ds').validate()){
                    var headers_ds = $('con_contract_cashflow_monthly_query_ds');
                var record = headers_ds.getAt(0);

                Leaf.Masker.mask(Ext.getBody(), '正在统计并查询，请稍等...');
			           Leaf.request({
                        url: $('con_cashflow_pre_query_id').getUrl(),
                        para: {
                            due_date : record.get('due_date'),
                            bp_id : record.get('bp_id_agent_level1'),
                            overday1:record.get('overdue_day1'),
                            overday2:record.get('overdue_day2'),
                            overday3:record.get('overdue_day3'),
                            not_overday1:record.get('not_overday1'),
                            not_overday2:record.get('not_overday2'),
                            not_overday3:record.get('not_overday3'),
                            not_overday4:record.get('not_overday4'),
                            not_overday5:record.get('not_overday5'),
                            not_overday6:record.get('not_overday6')
                        },
                        success: function(res) {
                           Leaf.Masker.unmask (Ext.getBody());
                           $('con_contract_cashflow_monthly_result_ds').query();
                            $('con_contract_cashflow_monthly_agent_result_ds').query();
                            $('con_contract_cashflow_monthly_result_lease_item_ds').query();
                         
                        },
                        failure: function() {
                             Leaf.Masker.unmask (Ext.getBody());
                        },
                        error: function() {
                             Leaf.Masker.unmask (Ext.getBody());
                        },
                        scope: this
                    });
            }
        }
            
            function CON321_con_contract_reset() {
                $('con_contract_cashflow_monthly_query_ds').reset();
            }
        ]]></script>
        <a:dataSets>
            <a:dataSet id="gld_accounts_ds" loadData="true" model="cont.CON930.gld_accounts_ds"/>
            <a:dataSet id="con_contract_cashflow_monthly_query_ds" autoCreate="true">
                <a:fields>
                    <a:field name="due_date" required="true"  prompt="基准日期"/>
                    <a:field name="bp_id_agent_level1" />
                    <a:field name="account_name" displayField="account_name" options="gld_accounts_ds" returnField="account_id" valueField="account_id"/>
                    <a:field name="bp_id_agent_level1_n" prompt="代理店" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov?bp_category=AGENT" lovWidth="500" title="HLS.BP_TITLE" >
                        <a:mapping>
                            <a:map from="bp_id" to="bp_id_agent_level1"/>
                            <a:map from="bp_name" to="bp_id_agent_level1_n" />
                        </a:mapping>
                    </a:field>
                    <a:field name="overdue_day1" required="true" prompt="已到期1个月界定天数" defaultValue="30"/>
                    <a:field name="overdue_day2" required="true" prompt="已到期2个月界定天数" defaultValue="60"/>
                    <a:field name="overdue_day3" required="true" prompt="已到期3个月界定天数" defaultValue="90"/>
                    <a:field name="not_overday1" required="true" prompt="未到期1个月界定天数" defaultValue="31"/>
                    <a:field name="not_overday2" required="true" prompt="未到期2个月界定天数" defaultValue="61"/>
                    <a:field name="not_overday3" required="true" prompt="未到期3个月界定天数" defaultValue="92"/>
                    <a:field name="not_overday4" required="true" prompt="未到期4个月界定天数" defaultValue="122"/>
                    <a:field name="not_overday5" required="true" prompt="未到期5个月界定天数" defaultValue="153"/>
                    <a:field name="not_overday6" required="true" prompt="未到期6个月界定天数" defaultValue="184"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="con_contract_cashflow_monthly_result_ds" model="cont.CON930.con_contract_cashflow_monthly" autoPageSize="true" queryDataSet="con_contract_cashflow_monthly_query_ds"/>
            <a:dataSet id="con_contract_cashflow_monthly_agent_result_ds" model="cont.CON930.con_contract_cashflow_monthly_agent"  autoPageSize="true" queryDataSet="con_contract_cashflow_monthly_query_ds"/>
            <a:dataSet id="con_contract_cashflow_monthly_result_lease_item_ds" model="cont.CON930.con_contract_cashflow_monthly_lease_item" autoPageSize="true" queryDataSet="con_contract_cashflow_monthly_query_ds"/>
        </a:dataSets>
        <a:screenBody>
            <a:screenTopToolbar>
                <a:gridButton click="CON321_con_contract_query" text="HLS.QUERY"/>
                <a:gridButton click="CON321_con_contract_reset" text="HLS.RESET"/>
            </a:screenTopToolbar>
            <a:form bindTarget="con_contract_cashflow_balance_query_ds" column="4" title="收付款预定查询" marginWidth="40">
                <a:datePicker name="due_date" bindTarget="con_contract_cashflow_monthly_query_ds"/>
<!--                <a:lov name="bp_id_agent_level1_n" bindTarget="con_contract_cashflow_monthly_query_ds"/>-->
<!--                <a:numberField name="overdue_day1" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="overdue_day2" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="overdue_day3" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="not_overday1" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="not_overday2" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="not_overday3" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="not_overday4" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="not_overday5" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->
<!--                <a:numberField name="not_overday6" bindTarget="con_contract_cashflow_monthly_query_ds" allowDecimals="false"/>-->

<!--                <a:comboBox name="account_name" bindTarget="con_contract_cashflow_monthly_query_ds" prompt="科目"/>-->
            </a:form>
            <a:tabPanel marginHeight="115" marginWidth="40">
            <a:tabs>
                <a:tab prompt="合同维度" width="120">
            <a:grid id="con_contract_cashflow_monthly_result_grid" bindTarget="con_contract_cashflow_monthly_result_ds" marginHeight="150" navBar="true" marginWidth="40">
                <a:toolBar>
                    <a:button type="excel"/>
                </a:toolBar>
                <a:columns>
                    <a:column name="division_n" align="center" prompt="租赁物" width="220"/>
                    <a:column name="bp_id_agent_level1_n" align="center" prompt="代理店" width="200"/>
                    <a:column name="contract_number" align="center" prompt="合同号" width="120"/>
                    <a:column name="bp_code" align="center" prompt="业务伙伴号" width="100"/>
                    <a:column name="account_id_n" align="center" prompt="科目代码" width="120"/>
                    <a:column name="account_name" align="center" prompt="科目名称" width="180"/>
                    <a:column name="unreceived_sum_amount" align="center" prompt="总额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="overdue_amount_1" align="center" prompt="已到期1个月" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="overdue_amount_2" align="center" prompt="已到期2个月" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="overdue_amount_3" align="center" prompt="已到期3个月" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="overdue_amount_left" align="center" prompt="已到期3个月以上" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="overdue_sum_amount" align="center" prompt="已到期余额合计" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="not_due_sum_amount" align="center" prompt="未到期余额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="not_due_amount_1" align="center" prompt="未到期1个月" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="not_due_amount_2" align="center" prompt="未到期2个月" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="not_due_amount_3" align="center" prompt="未到期3个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_4" align="center" prompt="未到期4个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_5" align="center" prompt="未到期5个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_6" align="center" prompt="未到期6个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_left" align="center" prompt="未到期6个月以上" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_7" align="center" prompt="未到期7个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_8" align="center" prompt="未到期8个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_9" align="center" prompt="未到期9个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_10" align="center" prompt="未到期10个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_11" align="center" prompt="未到期11个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_12" align="center" prompt="未到期12个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_13" align="center" prompt="未到期13个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_14" align="center" prompt="未到期14个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_15" align="center" prompt="未到期15个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_16" align="center" prompt="未到期16个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_17" align="center" prompt="未到期17个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_18" align="center" prompt="未到期18个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_19" align="center" prompt="未到期19个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_20" align="center" prompt="未到期20个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_21" align="center" prompt="未到期21个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_22" align="center" prompt="未到期22个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_23" align="center" prompt="未到期23个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_24" align="center" prompt="未到期24个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_25" align="center" prompt="未到期25个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_26" align="center" prompt="未到期26个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_27" align="center" prompt="未到期27个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_28" align="center" prompt="未到期28个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_29" align="center" prompt="未到期29个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_30" align="center" prompt="未到期30个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_31" align="center" prompt="未到期31个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_32" align="center" prompt="未到期32个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_33" align="center" prompt="未到期33个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_34" align="center" prompt="未到期34个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_35" align="center" prompt="未到期35个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_36" align="center" prompt="未到期36个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_37" align="center" prompt="未到期37个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_38" align="center" prompt="未到期38个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_39" align="center" prompt="未到期39个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_40" align="center" prompt="未到期40个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_41" align="center" prompt="未到期41个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_42" align="center" prompt="未到期42个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_43" align="center" prompt="未到期43个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_44" align="center" prompt="未到期44个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_45" align="center" prompt="未到期45个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_46" align="center" prompt="未到期46个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_47" align="center" prompt="未到期47个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_48" align="center" prompt="未到期48个月" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_48_left" align="center" prompt="未到期48个月以上" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_year_1" align="center" prompt="未到期1年" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_year_2" align="center" prompt="未到期2年" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_year_3" align="center" prompt="未到期3年" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_year_4" align="center" prompt="未到期4年" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_year_5" align="center" prompt="未到期5年" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="not_due_amount_year_5_left" align="center" prompt="未到期5年以上" renderer="Leaf.formatMoney" width="80"/>
                </a:columns>
            </a:grid>
                </a:tab>
                <a:tab prompt="代理店的租赁物维度" width="150">
                    <a:grid id="con_contract_cashflow_monthly_agent_result_grid" bindTarget="con_contract_cashflow_monthly_agent_result_ds" marginHeight="150" navBar="true" marginWidth="40">
                        <a:toolBar>
                            <a:button type="excel"/>
                        </a:toolBar>
                        <a:columns>
                            <a:column name="division_n" align="center" prompt="租赁物" width="220"/>
                            <a:column name="bp_id_agent_level1_n" align="center" prompt="代理店" width="200"/>
                            <a:column name="account_id_n" align="center" prompt="科目代码" width="120"/>
                            <a:column name="account_name" align="center" prompt="科目名称" width="180"/>
                            <a:column name="unreceived_sum_amount" align="center" prompt="总额" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_1" align="center" prompt="已到期1个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_2" align="center" prompt="已到期2个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_3" align="center" prompt="已到期3个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_left" align="center" prompt="已到期3个月以上" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_sum_amount" align="center" prompt="已到期余额合计" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_sum_amount" align="center" prompt="未到期余额" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_1" align="center" prompt="未到期1个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_2" align="center" prompt="未到期2个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_3" align="center" prompt="未到期3个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_4" align="center" prompt="未到期4个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_5" align="center" prompt="未到期5个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_6" align="center" prompt="未到期6个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_left" align="center" prompt="未到期6个月以上" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_7" align="center" prompt="未到期7个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_8" align="center" prompt="未到期8个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_9" align="center" prompt="未到期9个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_10" align="center" prompt="未到期10个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_11" align="center" prompt="未到期11个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_12" align="center" prompt="未到期12个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_13" align="center" prompt="未到期13个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_14" align="center" prompt="未到期14个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_15" align="center" prompt="未到期15个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_16" align="center" prompt="未到期16个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_17" align="center" prompt="未到期17个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_18" align="center" prompt="未到期18个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_19" align="center" prompt="未到期19个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_20" align="center" prompt="未到期20个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_21" align="center" prompt="未到期21个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_22" align="center" prompt="未到期22个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_23" align="center" prompt="未到期23个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_24" align="center" prompt="未到期24个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_25" align="center" prompt="未到期25个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_26" align="center" prompt="未到期26个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_27" align="center" prompt="未到期27个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_28" align="center" prompt="未到期28个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_29" align="center" prompt="未到期29个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_30" align="center" prompt="未到期30个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_31" align="center" prompt="未到期31个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_32" align="center" prompt="未到期32个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_33" align="center" prompt="未到期33个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_34" align="center" prompt="未到期34个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_35" align="center" prompt="未到期35个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_36" align="center" prompt="未到期36个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_37" align="center" prompt="未到期37个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_38" align="center" prompt="未到期38个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_39" align="center" prompt="未到期39个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_40" align="center" prompt="未到期40个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_41" align="center" prompt="未到期41个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_42" align="center" prompt="未到期42个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_43" align="center" prompt="未到期43个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_44" align="center" prompt="未到期44个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_45" align="center" prompt="未到期45个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_46" align="center" prompt="未到期46个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_47" align="center" prompt="未到期47个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_48" align="center" prompt="未到期48个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_48_left" align="center" prompt="未到期48个月以上" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_1" align="center" prompt="未到期1年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_2" align="center" prompt="未到期2年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_3" align="center" prompt="未到期3年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_4" align="center" prompt="未到期4年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_5" align="center" prompt="未到期5年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_5_left" align="center" prompt="未到期5年以上" renderer="Leaf.formatMoney" width="80"/>
                        </a:columns>
                    </a:grid>
                </a:tab>
                <a:tab prompt="租赁物维度" width="120">
                    <a:grid id="con_contract_cashflow_monthly_result_lease_item_grid" bindTarget="con_contract_cashflow_monthly_result_lease_item_ds" marginHeight="150" navBar="true" marginWidth="40">
                        <a:toolBar>
                            <a:button type="excel"/>
                        </a:toolBar>
                        <a:columns>
                            <a:column name="division_n" align="center" prompt="租赁物" width="220"/>
                            <a:column name="account_id_n" align="center" prompt="科目代码" width="120"/>
                            <a:column name="account_name" align="center" prompt="科目名称" width="180"/>
                            <a:column name="unreceived_sum_amount" align="center" prompt="总额" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_1" align="center" prompt="已到期1个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_2" align="center" prompt="已到期2个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_3" align="center" prompt="已到期3个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_amount_left" align="center" prompt="已到期3个月以上" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_sum_amount" align="center" prompt="已到期余额合计" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_sum_amount" align="center" prompt="未到期余额" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_1" align="center" prompt="未到期1个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_2" align="center" prompt="未到期2个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_3" align="center" prompt="未到期3个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_4" align="center" prompt="未到期4个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_5" align="center" prompt="未到期5个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_6" align="center" prompt="未到期6个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_left" align="center" prompt="未到期6个月以上" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_7" align="center" prompt="未到期7个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_8" align="center" prompt="未到期8个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_9" align="center" prompt="未到期9个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_10" align="center" prompt="未到期10个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_11" align="center" prompt="未到期11个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_12" align="center" prompt="未到期12个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_13" align="center" prompt="未到期13个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_14" align="center" prompt="未到期14个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_15" align="center" prompt="未到期15个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_16" align="center" prompt="未到期16个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_17" align="center" prompt="未到期17个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_18" align="center" prompt="未到期18个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_19" align="center" prompt="未到期19个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_20" align="center" prompt="未到期20个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_21" align="center" prompt="未到期21个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_22" align="center" prompt="未到期22个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_23" align="center" prompt="未到期23个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_24" align="center" prompt="未到期24个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_25" align="center" prompt="未到期25个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_26" align="center" prompt="未到期26个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_27" align="center" prompt="未到期27个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_28" align="center" prompt="未到期28个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_29" align="center" prompt="未到期29个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_30" align="center" prompt="未到期30个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_31" align="center" prompt="未到期31个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_32" align="center" prompt="未到期32个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_33" align="center" prompt="未到期33个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_34" align="center" prompt="未到期34个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_35" align="center" prompt="未到期35个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_36" align="center" prompt="未到期36个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_37" align="center" prompt="未到期37个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_38" align="center" prompt="未到期38个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_39" align="center" prompt="未到期39个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_40" align="center" prompt="未到期40个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_41" align="center" prompt="未到期41个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_42" align="center" prompt="未到期42个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_43" align="center" prompt="未到期43个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_44" align="center" prompt="未到期44个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_45" align="center" prompt="未到期45个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_46" align="center" prompt="未到期46个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_47" align="center" prompt="未到期47个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_48" align="center" prompt="未到期48个月" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_48_left" align="center" prompt="未到期48个月以上" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_1" align="center" prompt="未到期1年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_2" align="center" prompt="未到期2年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_3" align="center" prompt="未到期3年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_4" align="center" prompt="未到期4年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_5" align="center" prompt="未到期5年" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="not_due_amount_year_5_left" align="center" prompt="未到期5年以上" renderer="Leaf.formatMoney" width="80"/>
                        </a:columns>
                    </a:grid>
                </a:tab>
            </a:tabs>
            </a:tabPanel>
        </a:screenBody>
    </a:view>
</a:screen>
