payment_seq_excel_sheets.lsc

<?xml version="1.0" encoding="UTF-8"?>
<a:service xmlns:a="http://www.leaf-framework.org/application" xmlns:dr="leaf.plugin.excelreport" trace="true">
    <a:init-procedure>
        <a:model-query fetchAll="true" model="csh.CSH502.payment_seq_excel" rootPath="/model/datasource"/>
        <dr:excel-report enableTask="false" filename="zx_query_list.xlsx">
            <dr:styles>
                <dr:cell-style name="cell1" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="宋体" height="9"/>
                </dr:cell-style>
                <dr:cell-style name="cell2" align="ALIGN_RIGHT" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="Arial" height="9"/>
                </dr:cell-style>
                <dr:cell-style name="cell3" align="ALIGN_LEFT" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="宋体" height="9"/>
                </dr:cell-style>
                <dr:cell-style name="cell4" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" vertical="VERTICAL_CENTER">
                    <dr:font bold="false" fontName="Arial" height="9"/>
                </dr:cell-style>
                <dr:cell-style name="header" align="ALIGN_LEFT" borderbottom="BORDER_THIN" borderright="BORDER_THIN" bordertop="BORDER_THIN" cell_style_id="2" foregroundcolor="BLACK">
                    <dr:font bold="true" cell_style_id="2" fontname="宋体" height="10"/>
                </dr:cell-style>
            </dr:styles>
            <dr:sheets>
                <dr:sheet name="付款申请支付" autoSizeColumns="0,1,2,3,4,5,6,7,8,9,10,11" displayGridlines="true">
                    <dr:dynamic-content cell="A" dataModel="/model/datasource" row="1">
                        <dr:columns>
                            <dr:table-column cellStyle="cell1" field="rn" title="序号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell1" field="bank_account_name" title="付款账号名称" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell2" field="bank_account_num" title="付款账号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="invoice_bp_bank_account" title="付款账号一级分行行号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="bp_bank_account_num" title="收款人账号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="bp_bank_account_name" title="收款账号名称" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="bp_bank_code" title="收款账户一级分行行号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="bank_full_name" title="收款账号开户行名称" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="bp_branch_code" title="收款联行号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="gt_code" title="柜台号" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="inner_flag" title="行内转账标志" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="pay_amount" title="本次支付金额" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="currency" title="币种" titlestyle="header" type="content"/>
                            <dr:table-column cellStyle="cell3" field="contract_num" title="用途" titlestyle="header" type="content"/>
                            <!-- <dr:table-column cellStyle="cell3" field="item_frame_number" title="车架号" titlestyle="header" type="content"/> -->
                            <!-- <dr:table-column cellStyle="cell3" field="bp_name" title="承租人名称" titlestyle="header" type="content"/> -->
                            <!-- <dr:table-column cellStyle="cell3" field="lease_start_date" title="租赁开始日期" titlestyle="header" type="content"/> -->
                            <!-- <dr:table-column cellStyle="cell3" field="inception_of_lease" title="支付开始日期" titlestyle="header" type="content"/> -->
                            <!-- <dr:table-column cellStyle="cell3" field="contract_status_n" title="合同状态" titlestyle="header" type="content"/> -->
                        </dr:columns>
                    </dr:dynamic-content>
                </dr:sheet>
            </dr:sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>