<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: nyl
$Date: 2015-3-13 上午10:30:25
$Revision: 1.0
$Purpose:
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
<a:init-procedure>
<a:model-query model="cus.CUS100.cus_default_values" rootPath="default_value"/>
</a:init-procedure>
<a:init-procedure><![CDATA[
]]></a:init-procedure>
<a:view>
<a:link id="con_contract_get_layout_code_link_id" model="cont.CON500.con_contract_get_layout_code" modelaction="update"/>
<script type="text/javascript"><![CDATA[
function cus312n_con_contract_return() {
history.go(-1);
}
function cus312n_con_contract_query() {
$('cus312n_contract_result_ds').query();
}
function cus312n_con_contract_reset(){
$('cus312n_contract_query_ds').reset();
}
function cus312n_con_contract_export(){
$('cus312n_con_contract_grid_ds')._export();
}
]]></script>
<a:screen-include screen="modules/cont/CON500/con_contract_get_layout_code.lview"/>
<!-- <a:screen-include screen="modules/cont/CON500/con_contract_authority_list_validate.lview?document_category=CONTRACT&function_code=cus312n"/> -->
<a:dataSets>
<a:dataSet id="cus312n_contract_query_ds">
<a:fields>
<a:field name="period_name" defaultValue="${/model/default_value/record/@current_month}"/>
<a:field name="bp_id_tenant_c" autoComplete="true" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov?bp_category=TENANT" lovWidth="500" title="HLS.BP_TITLE">
<a:mapping>
<a:map from="bp_code" to="bp_id_tenant_c"/>
<a:map from="bp_name" to="bp_id_tenant_n"/>
<a:map from="bp_id" to="bp_id_tenant"/>
</a:mapping>
</a:field>
<a:field name="bp_id_tenant"/>
<a:field name="bp_id_tenant_n"/>
<a:field name="transaction_date_from"/>
<a:field name="transaction_date_to" defaultValue="${/model/default_value/record/@sys_date}" required="true"/>
</a:fields>
</a:dataSet>
<a:dataSet id="cus312n_contract_result_ds" model="cus.CUS312N.cus_payment_current_report_lv" pageSize="100" queryDataSet="cus312n_contract_query_ds" selectable="true">
<!-- <a:events>
<a:event name="query" handler="aut_authority_list_validate_query"/>
</a:events> --><![CDATA[
]]></a:dataSet>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:gridButton click="cus312n_con_contract_return" text="HLS.RETURN"/>
<a:gridButton click="cus312n_con_contract_query" text="HLS.QUERY"/>
<a:gridButton click="cus312n_con_contract_reset" text="HLS.RESET"/>
<a:gridButton click="cus312n_con_contract_export" text="导出"/>
</a:screenTopToolbar>
<a:form column="4" labelSeparator=" " labelWidth="100" marginWidth="30" title="CON301.CONTRACT_QUERY">
<!-- <a:textField name="period_name" bindTarget="cus312n_contract_query_ds" prompt="计算月份"/> -->
<a:textField name="contract_number" bindTarget="cus312n_contract_query_ds" prompt="合同序号"/>
<a:textField name="search_term_1" bindTarget="cus312n_contract_query_ds" prompt="合同号"/>
<a:lov name="bp_id_tenant_c" bindTarget="cus312n_contract_query_ds" prompt="客户编码"><![CDATA[
]]></a:lov>
<a:textField name="bp_id_tenant_n" bindTarget="cus312n_contract_query_ds" prompt="客户名称"/>
<!-- <a:datePicker name="transaction_date_from" bindTarget="cus312n_contract_query_ds" prompt="收款日期从"/> -->
<a:datePicker name="transaction_date_to" bindTarget="cus312n_contract_query_ds" prompt="计算截止日"/>
</a:form>
<a:grid id="cus312n_con_contract_grid_ds" bindTarget="cus312n_contract_result_ds" marginHeight="265" marginWidth="30" navBar="true">
<a:columns>
<a:column name="search_term_1" align="left" prompt="合同号" width="100"/>
<a:column name="contract_number" align="left" prompt="合同序号" width="100"/>
<a:column name="bp_id_tenant_n" align="left" prompt="客户名称" width="100"/>
<a:column name="account_period" align="center" prompt="会计期间" width="100"/>
<a:column name="inception_of_lease" align="center" prompt="起租日" width="100"/>
<a:column name="signing_date" align="center" prompt="合同签订日" width="100"/>
<a:column name="transaction_date" align="center" prompt="收款日期" width="100"/>
<a:column name="division_n" align="left" prompt="产品线" width="100"/>
<a:column name="specification" align="left" prompt="设备型号" width="100"/>
<a:column name="serial_number" align="left" prompt="设备编号" width="100"/>
<a:column name="bp_id_vender_n" align="left" prompt="供应商" width="100"/>
<a:column name="province_id_tenant_n" align="left" prompt="承租人省份" width="100"/>
<a:column name="lease_item_amount" align="right" prompt="整机价格" renderer="Leaf.formatMoney" width="100"/>
<a:column name="insurance_fee" align="right" prompt="保险费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="csa" align="right" prompt="CSA" renderer="Leaf.formatMoney" width="100"/>
<a:column name="ar" align="right" prompt="应付账款" renderer="Leaf.formatMoney" width="100"/>
<a:column name="lease_mgt_fee" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="residual_value" align="right" prompt="抵押金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="deposit" align="right" prompt="保证金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="down_payment_1" align="right" prompt="DOWNPAYMENT" renderer="Leaf.formatMoney" width="100"/>
<a:column name="down_payment" align="right" prompt="首付款" renderer="Leaf.formatMoney" width="100"/>
<a:column name="change_type" align="right" prompt="合同变更" renderer="Leaf.formatMoney" width="100"/>
<a:column name="change_date" align="right" prompt="变更时间" width="100"/>
<a:column name="ccr_fee" align="right" prompt="变更手续费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="actual_finance_amount" align="right" prompt="净融资额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="total_interest" align="right" prompt="利息总额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="finance_income_sum" align="right" prompt="确认收入总额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="due_amount" align="right" prompt="月租金总和" renderer="Leaf.formatMoney" width="100"/>
<a:column name="total_rental" align="right" prompt="租金总和" renderer="Leaf.formatMoney" width="100"/>
<a:column name="int_rate" align="right" prompt="名义利率" renderer="Leaf.formatMoney" width="100"/>
<a:column name="collected_times" align="right" prompt="已付租期" renderer="Leaf.formatMoney" width="100"/>
<a:column name="uncollected_times" align="right" prompt="未付租期" renderer="Leaf.formatMoney" width="100"/>
<a:column name="overdue_times" align="right" prompt="逾期(月)" renderer="Leaf.formatMoney" width="100"/>
<a:column name="times" align="right" prompt="总租期" width="100"/>
<a:column name="transaction_amount_rental" align="right" prompt="当月收到租金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="penalty" align="right" prompt="延迟履行金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="uncollected_ar" align="right" prompt="应收未收余额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="net_invest_amount" align="right" prompt="净投资额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="uncollected_interest" align="right" prompt="未实现利息余额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_current" align="right" prompt="本月确认利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="huichong" align="right" prompt="逾期3期以上收入回冲" renderer="Leaf.formatMoney" width="100"/>
<a:column name="principal_c_12_remain" align="right" prompt="当月开始往后12月本金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="overdue_amount_new" align="right" prompt="逾期租金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="principal_12" align="right" prompt="次12个月未到期本金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_12" align="right" prompt="次12个月未到期利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="principal_12_remain" align="right" prompt="超过12个月到期本金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_12_remain" align="right" prompt="超过12个月到期利息" renderer="Leaf.formatMoney" width="100"/>
<!-- <a:column name="principal_5" align="right" prompt="剩余5年内到期本金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_5" align="right" prompt="剩余5年内到期利息" renderer="Leaf.formatMoney" width="100"/> -->
<a:column name="principal_5_over" align="right" prompt="超过5年到期本金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_5_over" align="right" prompt="超过5年到期利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_straight" align="right" prompt="直线法每期利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="uncollected_interest_straight" align="right" prompt="未到期直线法利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_tax_adjust" align="right" prompt="税务调整利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_declared" align="right" prompt="本月申报已收利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_declared_last" align="right" prompt="截止上月累计已申报" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_declared_current" align="right" prompt="截止本月累计已申报" renderer="Leaf.formatMoney" width="100"/>
<a:column name="collected_rental" align="right" prompt="累计已收租金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="contract_status_n" align="left" prompt="合同状态" width="100"/>
<a:column name="all_file_confirm_status_n" align="left" prompt="付款状态" width="100"/>
<a:column name="company_id_n" align="left" prompt="公司名称" width="100"/>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>