<?xml version="1.0" encoding="UTF-8"?>
<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
<a:init-procedure>
<a:model-query fetchAll="true" model="basic.hls_lease_channel_for_lov" rootPath="lease_channel_path"/>
<a:model-query defaultWhereClause="t1.business_type in ('LEASE','LEASEBACK')" fetchAll="true" model="basic.hls_business_type_for_lov" rootPath="business_type_path"/>
</a:init-procedure>
<a:view>
<script type="text/javascript"><![CDATA[
function csh_advances_query() {
$('csh_advances_grid_ds').query();
}
function csh_advances_reset(){
$('csh_advances_form_ds').reset();
}
function csh_advances_export() {
$('source_to_grid')._export(null,'客户预收款明细');
}
]]></script>
<a:dataSets>
<a:dataSet id="lease_channel_ds">
<a:datas dataSource="/model/lease_channel_path"/>
</a:dataSet>
<a:dataSet id="business_type_ds">
<a:datas dataSource="/model/business_type_path"/>
</a:dataSet>
<a:dataSet id="contract_status_ds" lookupCode="CON500_CONTRACT_STATUS"/>
<a:dataSet id="division_name_ds" loadData="true" model="cont.CON1260.hls_division"/>
<a:dataSet id="csh_advances_form_ds">
<a:fields>
<a:field name="contract_status_n" displayField="code_value_name" options="contract_status_ds" returnField="contract_status" valueField="code_value"/>
<a:field name="lease_channel_n" displayField="description" options="lease_channel_ds"
returnField="lease_channel" valueField="lease_channel"/>
<a:field name="lease_channel" />
<a:field name="business_type_n" displayField="description" options="business_type_ds" returnField="business_type" valueField="business_type"/>
<a:field name="business_type" />
<a:field name="division_n" displayField="description" options="division_name_ds"
returnField="division" valueField="division"/>
<a:field name="bp_id_agent_level1_n" lovService="basic.hls_bp_master_v_for_lov?bp_category=AGENT"
lovHeight="500" lovLabelWidth="100" lovWidth="800" prompt="代理商" 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:fields>
</a:dataSet>
<a:dataSet id="csh_advances_grid_ds"
model="csh.CSH1030.csh_advances_received_detail"
queryDataSet="csh_advances_form_ds" autoQuery="false" selectable="true" selectionModel="single">
</a:dataSet>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:gridButton click="csh_advances_query" text="查询"/>
<a:gridButton click="csh_advances_reset" text="重置"/>
<a:gridButton click="csh_advances_export" text="导出"/>
</a:screenTopToolbar>
<a:form column="4" marginWidth="100" title="查询条件">
<a:textField name="contract_number" bindTarget="csh_advances_form_ds" prompt="合同编号"/>
<a:textField name="bp_code" bindTarget="csh_advances_form_ds" prompt="客户编号" />
<a:textField name="bp_name" bindTarget="csh_advances_form_ds" prompt="客户名称" />
<a:comboBox name="contract_status_n" bindTarget="csh_advances_form_ds" prompt="合同状态"/>
<a:lov name="bp_id_agent_level1_n" bindTarget="csh_advances_form_ds" prompt="代理商"/>
<a:datePicker name="journal_date_from" bindTarget="csh_advances_form_ds" prompt="记账日期从"/>
<a:datePicker name="journal_date_to" bindTarget="csh_advances_form_ds" prompt="记账日期到"/>
<a:textField name="transaction_num" bindTarget="csh_advances_form_ds" prompt="预收款现金事务编号" />
<a:numberField name="transaction_amount_from" bindTarget="csh_advances_form_ds" prompt="预收款金额从"/>
<a:numberField name="transaction_amount_to" bindTarget="csh_advances_form_ds" prompt="预收款金额到"/>
<a:textField name="bp_bank_account_name" bindTarget="csh_advances_form_ds" prompt="汇款人" />
<a:textField name="transaction_num_y" bindTarget="csh_advances_form_ds" prompt="汇款现金事务编号" />
<!--<a:comboBox name="division_n" bindTarget="csh_advances_form_ds" prompt="产品线"/>-->
<!--<a:comboBox name="business_type_n" bindTarget="csh_advances_form_ds" prompt="商业模式"/>-->
<!--<a:comboBox name="lease_channel_n" bindTarget="csh_advances_form_ds" prompt="业务类型" />-->
</a:form>
<a:grid id="source_to_grid" bindTarget="csh_advances_grid_ds" navBar="true" height="400" marginWidth="100">
<a:columns>
<a:column name="contract_number" align="center" prompt="合同编号" width="130"/>
<a:column name="bp_code" align="center" prompt="客户编号" width="100"/>
<a:column name="bp_name" align="center" prompt="客户名称" width="100"/>
<a:column name="bp_agent_code" align="center" prompt="代理商编号" width="100"/>
<a:column name="bp_agent_name" align="center" prompt="代理商名称" width="100"/>
<a:column name="pattern" align="center" prompt="机型" width="100"/>
<a:column name="machine_number" align="center" prompt="机号" width="100"/>
<a:column name="transaction_amount" align="center" prompt="预收款金额" width="100" renderer="Leaf.formatMoney"/>
<a:column name="unwrite_off_amount" align="center" prompt="未核销金额" width="100" renderer="Leaf.formatMoney"/>
<a:column name="contract_status_n" align="center" prompt="合同状态" width="100"/>
<a:column name="et_date" align="center" prompt="结清日期" width="100" renderer="Leaf.formatDate"/>
<a:column name="journal_date" align="center" prompt="记账日期" width="100" renderer="Leaf.formatDate"/>
<a:column name="transaction_num" align="center" prompt="预收款现金事务编号" width="150"/>
<a:column name="transaction_num_y" align="center" prompt="汇款现金事务编号" width="150"/>
<a:column name="transaction_amount_y" align="center" prompt="汇款金额" width="100" renderer="Leaf.formatMoney"/>
<a:column name="transaction_date" align="center" prompt="汇款日期" width="100" renderer="Leaf.formatDate"/>
<a:column name="bp_bank_account_name" align="center" prompt="汇款人" width="100"/>
<a:column name="description" align="center" prompt="汇款摘要" width="100"/>
<a:column name="ref_v05" align="center" prompt="备注" width="100"/>
<a:column name="zuonr" align="center" prompt="凭证上的ASSIGNMENT" width="150"/>
<a:column name="re_kunnr" align="center" prompt="客户sap编码" width="100"/>
<a:column name="division_n" align="center" prompt="产品线" width="100"/>
<a:column name="business_type_n" align="center" prompt="商业模式" width="150"/>
<a:column name="lease_channel_n" align="center" prompt="业务类型" width="100"/>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>