<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: qwm
$Date: 2013-12-28 下午1:24:13
$Revision: 1.0
$Purpose:
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
<a:init-procedure>
<a:model-query defaultWhereClause="t1.role_id=${/session/@role_id} and t1.company_id=${/session/@company_id}"
fetchAll="true" model="hls.HLS109.hls_default_parameter" rootPath="hls_default_parameter_path"/>
<a:model-query defaultWhereClause="fc.company_id=${/session/@company_id}" fetchAll="true"
model="fnd.fnd_companies" rootPath="default_company_path"/>
<a:model-query autoCount="false" fetchAll="true" model="gld.FND5800.gld_period_status_fieldset"
rootPath="fieldset"/>
</a:init-procedure>
<a:view>
<a:link id="con_finance_income_link"
url="${/request/@context_path}/modules/cont/CON901/con_finance_income.lview"/>
<a:link id="tre_accrued_interest_link"
url="${/request/@context_path}/modules/hls/HLS801/tre_accrued_interest.lview"/>
<a:link id="con_unearned_finance_income_link"
url="${/request/@context_path}/modules/hls/HLS801/con_unearned_finance_income.lview"/>
<a:link id="hls_monthly_statement_link"
url="${/request/@context_path}/modules/hls/HLS801/hls_monthly_statement.lview"/>
<a:link id="gld_period_pkg_init_period_link" model="db.gld_period_pkg.init_period" modelaction="update"/>
<a:link id="gld_period_pkg_close_period_link" model="db.gld_period_pkg.close_period" modelaction="execute"/>
<a:link id="gld_period_pkg_open_period_link" model="db.gld_period_pkg.open_period" modelaction="execute"/>
<a:link id="formula_sheets_excel_id"
url="${/request/@context_path}/modules/hls/HLS801/con_unearned_finance_income_excel_sheets.lsc"/>
<a:link id="insert_tre_accrued_interest_link" model="hls.HLS801.insert_tre_accrued_interest"
modelaction="execute"/>
<a:link id="insert_con_finance_income_link" model="hls.HLS801.con_finance_income_new" modelaction="execute"/>
<a:link id="insert_con_finance_income_link2" model="hls.HLS801.con_finance_income_new" modelaction="update"/>
<a:link id="insert_con_finance_income_link3" model="hls.HLS801.tre_finance_income_new" modelaction="execute"/>
<a:link id="insert_con_finance_income_link4" model="hls.HLS801.tre_finance_income_new" modelaction="update"/>
<a:link id="insert_con_finance_income_reverse_link" model="hls.HLS801.con_finance_income_reverse"
modelaction="execute"/>
<a:link id="insert_con_finance_income_reverse_link2" model="hls.HLS801.con_finance_income_reverse"
modelaction="update"/>
<a:link id="insert_stamp_duty_link" model="hls.HLS801.con_contract_stamp_duty"
modelaction="execute"/>
<a:link id="insert_stamp_duty_link2" model="hls.HLS801.con_contract_stamp_duty"
modelaction="update"/>
<a:link id="period_month_close_link" model="hls.HLS801.period_month_close" modelaction="execute"/>
<a:link id="tre_interest_confirm_link" model="hls.HLS801.tre_interest_confirm" modelaction="execute"/>
<a:link id="main_link" url="${/request/@context_path}/welcome.lview"/>
<script type="text/javascript"><![CDATA[
//HLS801.NEXT_STEP
var step = 0;
var g_company_id;
var g_company_id_2;
function nextStep() {
var stepTabPanel = $('step');
step = step + 1;
stepTabPanel.setEnabled(step);
stepTabPanel.selectTab(step);
stepTabPanel.setDisabled(step - 1);
}
//HLS801.LAST_STEP
function upStep() {
var stepTabPanel = $('step');
step = step - 1;
stepTabPanel.setEnabled(step);
stepTabPanel.selectTab(step);
stepTabPanel.setDisabled(step + 1);
}
//取消
function cancelFun() {
//history.go(-1);
window.location.href = $('main_link').getUrl();
}
function backFun() {
Leaf.showConfirm('${l:HLS.PROMPT}', '确定返回？', function okFun() {
window.location.href = $('hls_monthly_statement_link').getUrl();
}, function canFun() {
});
}
function step_0NextStep() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
var period_name = typeof(record.get('period_name')) == 'undefined' ? 0 : record.get('period_name');
if (period_name == 0 || period_name == '') {
Leaf.showMessage('${l:HLS.PROMPT}', '请确认期间！');
} else {
nextStep();
}
}
function step_1NextStep() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
var period_name = record.get('period_name');
nextStep();
/* year = period_name.substring(0, 4);
month = period_name.substring(5, 7);
var query_ds = $('unearned_finance_income_query_ds');
var qrecord = query_ds.getAt(0);
qrecord.set('year',year);
qrecord.set('month',month);
$('unearned_finance_income_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds').query(); */
}
function step_2NextStep() {
nextStep();
}
function hls202_link_con901_fun() {
// window.location.href = $('con_finance_income_link').getUrl();
new Leaf.Window({
id: 'con_finance_income_window',
url: $('con_finance_income_link').getUrl(),
params: {
winId: 'con_finance_income_window'
},
title: '',
fullScreen: true
});
}
function accrued_interest_query() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('tre_accrued_interest_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('tre_accrued_interest_ds').query();
}
function do_accrued_interest_excel() {
var url;
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
if (Ext.isEmpty(g_company_id)) {
url = $('formula_sheets_excel_id').getUrl() + '?internal_period_num=' + record.get('internal_period_num') + '&period_name=' + record.get('period_name') + '&datasoure_type=accrued_interest';
} else {
url = $('formula_sheets_excel_id').getUrl() + '?company_id=' + g_company_id + '&internal_period_num=' + record.get('internal_period_num') + '&period_name=' + record.get('period_name') + '&datasoure_type=accrued_interest';
}
window.open(url);
}
function accrued_interest_Onupdate(ds, record, name, value, oldVlaue) {
if (name == 'company_id') {
g_company_id = value;
}
}
function unearned_finance_income_query() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('unearned_finance_income_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds').setQueryParameter('buession_type', 'LEASE');
$('unearned_finance_income_ds').setQueryParameter('cf_item', '1');
$('unearned_finance_income_ds').query();
}
function unearned_finance_income_query2() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('unearned_finance_income_ds2').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds2').setQueryParameter('buession_type', 'LEASE');
$('unearned_finance_income_ds2').setQueryParameter('cf_item', '3');
$('unearned_finance_income_ds2').query();
}
function unearned_finance_income_query3() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('unearned_finance_income_ds3').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds3').setQueryParameter('buession_type', 'LOAN');
$('unearned_finance_income_ds3').setQueryParameter('cf_item', '900');
$('unearned_finance_income_ds3').query();
}
function unearned_finance_income_query4() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('unearned_finance_income_ds4').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds4').setQueryParameter('buession_type', 'LOAN');
$('unearned_finance_income_ds4').setQueryParameter('cf_item', '901');
$('unearned_finance_income_ds4').query();
}
function unearned_finance_income_query5() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('unearned_finance_income_ds5').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds5').setQueryParameter('buession_type', 'LEASE');
$('unearned_finance_income_ds5').setQueryParameter('cf_item', '1');
$('unearned_finance_income_ds5').query();
}
function stamp_duty_query() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('stamp_duty_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds').query();
}
function stamp_duty_query2() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('stamp_duty_ds2').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds2').query();
}
function con_lease_charge_query() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
$('con_lease_charge_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('con_lease_charge_ds').query();
}
function do_unearned_finance_income_excel() {
var url;
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
if (Ext.isEmpty(g_company_id_2)) {
url = $('formula_sheets_excel_id').getUrl() + '?internal_period_num=' + record.get('internal_period_num') + '&period_name=' + record.get('period_name') + '&datasoure_type=unearned_finance_income';
} else {
url = $('formula_sheets_excel_id').getUrl() + '?company_id=' + g_company_id_2 + '&internal_period_num=' + record.get('internal_period_num') + '&period_name=' + record.get('period_name') + '&datasoure_type=unearned_finance_income';
}
window.open(url);
}
function unearned_finance_income_Onupdate(ds, record, name, value, oldVlaue) {
if (name == 'company_id') {
g_company_id_2 = value;
}
}
function monthly_statement_Onupdate(ds, record, name, value, oldVlaue) {
if (name == 'period_name') {
year = value.substring(0, 4);
month = value.substring(5, 7);
var query_ds = $('accrued_interest_query_ds');
var qrecord = query_ds.getAt(0);
var query_ds_1 = $('unearned_finance_income_query_ds');
var qrecord_1 = query_ds_1.getAt(0);
var query_ds_2 = $('unearned_finance_income_query_ds2');
var qrecord_2 = query_ds_2.getAt(0);
var query_ds_3 = $('unearned_finance_income_query_ds3');
var qrecord_3 = query_ds_3.getAt(0);
var query_ds_4 = $('unearned_finance_income_query_ds4');
var qrecord_4 = query_ds_4.getAt(0);
var query_ds_5 = $('unearned_finance_income_query_ds5');
var qrecord_5 = query_ds_5.getAt(0);
qrecord.set('year', year);
qrecord.set('month', month);
qrecord_1.set('year', year);
qrecord_1.set('month', month);
qrecord_2.set('year', year);
qrecord_2.set('month', month);
qrecord_3.set('year', year);
qrecord_3.set('month', month);
qrecord_4.set('year', year);
qrecord_4.set('month', month);
qrecord_5.set('year', year);
qrecord_5.set('month', month);
$('tre_accrued_interest_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('tre_accrued_interest_ds').query();
$('unearned_finance_income_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds').setQueryParameter('buession_type', 'LEASE');
$('unearned_finance_income_ds').setQueryParameter('cf_item', 1);
$('unearned_finance_income_ds').query();
/*$('unearned_finance_income_ds2').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds2').setQueryParameter('buession_type', 'LEASE');
$('unearned_finance_income_ds2').setQueryParameter('cf_item', 3);
$('unearned_finance_income_ds2').query();*/
$('unearned_finance_income_ds3').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds3').setQueryParameter('buession_type', 'LOAN');
$('unearned_finance_income_ds3').setQueryParameter('cf_item', 900);
$('unearned_finance_income_ds3').query();
$('unearned_finance_income_ds4').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds4').setQueryParameter('buession_type', 'LOAN');
$('unearned_finance_income_ds4').setQueryParameter('cf_item', 901);
$('unearned_finance_income_ds4').query();
$('unearned_finance_income_ds5').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds5').setQueryParameter('buession_type', 'LEASE');
$('unearned_finance_income_ds5').setQueryParameter('cf_item', 1);
$('unearned_finance_income_ds5').query();
$('con_lease_charge_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('con_lease_charge_ds').query();
$('close_open_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('close_open_ds').setQueryParameter('period_set_code', '${/model/fieldset/record/@period_set_code}');
$('close_open_ds').query();
$('stamp_duty_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds').query();
$('stamp_duty_ds2').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds2').query();
$('leased_assets_ds').query();
var monthly_closed_flag =ds.getAt(0).get('monthly_closed_flag');
var stepTabPanel = $('step');
if (value) {
stepTabPanel.setEnabled(1);
stepTabPanel.setEnabled(2);
stepTabPanel.setEnabled(3);
stepTabPanel.setEnabled(4);
stepTabPanel.setEnabled(5);
stepTabPanel.setEnabled(6);
stepTabPanel.setEnabled(7);
stepTabPanel.setEnabled(8);
stepTabPanel.setEnabled(9);
stepTabPanel.setEnabled(10);
stepTabPanel.setEnabled(11);
if(monthly_closed_flag == 'Y'){
$('button_1').disable();
$('button_2').disable();
$('button_3').disable();
$('button_4').disable();
$('button_5').disable();
$('button_6').disable();
$('button_7').disable();
$('button_8').disable();
$('button_9').disable();
}else{
$('button_1').enable();
$('button_2').enable();
$('button_3').enable();
$('button_4').enable();
$('button_5').enable();
$('button_6').enable();
$('button_7').enable();
$('button_8').enable();
$('button_9').enable();
}
} else {
stepTabPanel.setDisabled(1);
stepTabPanel.setDisabled(2);
stepTabPanel.setDisabled(3);
stepTabPanel.setDisabled(4);
stepTabPanel.setDisabled(5);
stepTabPanel.setDisabled(6);
stepTabPanel.setDisabled(7);
stepTabPanel.setDisabled(8);
stepTabPanel.setDisabled(9);
stepTabPanel.setDisabled(10);
stepTabPanel.setDisabled(11);
}
}
}
function openPeriodDs(value, record, name) {
var period_status_code = record.get('period_status_code');
var ds = "close_open_ds";
if (period_status_code == 'C' || period_status_code == 'U') {
var url = $('gld_period_pkg_open_period_link').getUrl();
return '<a href="javascript:executeOpen(\'' + ds + '\',\'' + url + '\',' + record.id + ')">${l:OPEN_PERIOD}</a>';
} else if (period_status_code == 'O') {
return '';
}
}
function closePeriodDs(value, record, name) {
var period_status_code = record.get('period_status_code');
var ds = "close_open_ds";
if (period_status_code == 'C' || period_status_code == 'U') {
return '';
} else if (period_status_code == 'O') {
var url = $('gld_period_pkg_close_period_link').getUrl();
return '<a href="javascript:executeClose(\'' + ds + '\',\'' + url + '\',' + record.id + ')">${l:CLOSE_PERIOD}</a>';
}
}
function statusRenderer(value, record, name) {
if (value == null || value == undefined) {
return '${l:PROMPT.NOT_OPEN}';
} else if (value == 'O') {
return '${l:PROMPT.OPENED}';
} else if (value == 'C') {
return '${l:PROMPT.CLOSED}';
}
}
function executeOpen(ds, url, id) {
record = $(ds).findById(id);
Leaf.request({
url: url,
para: record.data,
success: function () {
record.set('period_status_code', 'O');
Leaf.SideBar.enable = true;
Leaf.SideBar.show({
msg: '打开成功',
duration: 3000
});
},
scope: this
});
}
function executeClose(ds, url, id) {
record = $(ds).findById(id);
if ($('close_open_ds').getAll().length == 0) {
Leaf.request({
url: $('gld_period_pkg_init_period_link').getUrl(),
para: record.data,
success: function () {
Leaf.showMessage('${l:PROMPT}', '${l:FND_DIMENSION_VALUES.OPR_SUC}', function (cmp) {
document.location.reload();
cmp.close();
});
},
scope: this
});
} else {
Leaf.request({
url: url,
para: record.data,
success: function () {
record.set('period_status_code', 'C');
Leaf.SideBar.enable = true;
Leaf.SideBar.show({
msg: '关闭成功',
duration: 3000
});
},
scope: this
});
}
}
function unearned_finance_income_clear() {
$('unearned_finance_income_grid').clear();
}
function accrued_interest_clear() {
$('tre_accrued_interest_grid').clear();
}
var g_return_value_1;
function accrued_interest_calculate() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '结算，确认计算计提利息？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_tre_accrued_interest_link').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
g_return_value_1 = result.return_value_1;
if (g_return_value_1 != 'SUCCESS') {
Leaf.showWarningMessage('', '计提利息计算出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}
Leaf.Masker.unmask(Ext.getBody());
$('tre_accrued_interest_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('tre_accrued_interest_ds').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
var g_return_value;
function unearned_finance_income_confirm() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '结算，确定执行收入确认？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_con_finance_income_link').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
/*var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
g_return_value = result.return_value;
if (g_return_value != 'SUCCESS') {
Leaf.showWarningMessage('', '收入确认出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}*/
Leaf.Masker.unmask(Ext.getBody());
$('unearned_finance_income_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds').setQueryParameter('cf_item', '1');
$('unearned_finance_income_ds').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function unearned_finance_income_confirm2() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '结算，确定执行收入确认？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_con_finance_income_link2').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
Leaf.Masker.unmask(Ext.getBody());
con_lease_charge_query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function unearned_finance_income_confirm3() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '结算，确定执行成本确认？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_con_finance_income_link3').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
Leaf.Masker.unmask(Ext.getBody());
$('unearned_finance_income_ds3').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds3').setQueryParameter('cf_item', '900');
$('unearned_finance_income_ds3').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function unearned_finance_income_confirm4() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '结算，确定执行成本确认？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_con_finance_income_link4').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
Leaf.Masker.unmask(Ext.getBody());
$('unearned_finance_income_ds4').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds4').setQueryParameter('cf_item', '901');
$('unearned_finance_income_ds4').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function monthlyendFun() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
Leaf.showConfirm('${l:HLS.PROMPT}', '本次月结结束后不可执行当月其他相关操作，是否确认结束？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('period_month_close_link').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
var period_return_value = result.period_return_value;
if (period_return_value != 'SUCCESS') {
Leaf.showWarningMessage('', '月结结束出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}
Leaf.Masker.unmask(Ext.getBody());
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function accrued_interest_confirm() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '结算，确认计提利息？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('tre_interest_confirm_link').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
var confirm_return_value = result.confirm_return_value;
if (confirm_return_value != 'SUCCESS') {
Leaf.showWarningMessage('', '计提利息确认出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}
Leaf.Masker.unmask(Ext.getBody());
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function ratePercentRender(value, record, name) {
if (!Ext.isEmpty(value)) {
return parseFloat(mul(value, 100)) + '%';
}
}
function unearned_finance_income_reversed() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '确定执行月结冲销操作吗？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_con_finance_income_reverse_link').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
g_return_value = result.return_value;
if (g_return_value != 'SUCCESS') {
Leaf.showWarningMessage('', '冲销出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}
Leaf.Masker.unmask(Ext.getBody());
$('unearned_finance_income_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds').setQueryParameter('buession_type', record.get('LEASE'));
$('unearned_finance_income_ds').query();
$('unearned_finance_income_ds3').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds3').setQueryParameter('buession_type', record.get('LOAN'));
$('unearned_finance_income_ds3').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function unearned_finance_income_reversed2() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '确定执行月结冲销操作吗？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_con_finance_income_reverse_link2').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) { //
var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
g_return_value = result.return_value;
if (g_return_value != 'SUCCESS') {
Leaf.showWarningMessage('', '冲销出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}
Leaf.Masker.unmask(Ext.getBody());
$('unearned_finance_income_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds').setQueryParameter('buession_type', record.get('LEASE'));
$('unearned_finance_income_ds').query();
$('unearned_finance_income_ds3').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('unearned_finance_income_ds3').setQueryParameter('buession_type', record.get('LOAN'));
$('unearned_finance_income_ds3').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function stamp_duty() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '确定执行印花税确认操作吗？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_stamp_duty_link').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) {
var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
g_return_value = result.return_value;
if (g_return_value != 'SUCCESS') {
Leaf.showWarningMessage('', '确认出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}
Leaf.Masker.unmask(Ext.getBody());
$('stamp_duty_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds').query();
$('stamp_duty_ds2').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds2').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function stamp_duty2() {
var headers_ds = $('hls_monthly_statement_ds');
var record = headers_ds.getAt(0);
year = record.get('period_name').substring(0, 4);
month = record.get('period_name').substring(5, 7);
Leaf.showConfirm('${l:HLS.PROMPT}', year + '年' + month + '月' + '确定执行印花税确认操作吗？', function okFun() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.SAVING}');
Leaf.request({
url: $('insert_stamp_duty_link2').getUrl(),
para: {
internal_period_num: record.get('internal_period_num')
},
success: function (args) {
var result = args.result;
if (!result) {
Leaf.showWarningMessage('', '${l:PRJ509.DATA_NOT_BACK}', null, 200, 100);
return;
}
g_return_value = result.return_value;
if (g_return_value != 'SUCCESS') {
Leaf.showWarningMessage('', '确认出错！', null, 200, 100);
Leaf.Masker.unmask(Ext.getBody());
return;
}
Leaf.Masker.unmask(Ext.getBody());
$('stamp_duty_ds').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds').query();
$('stamp_duty_ds2').setQueryParameter('internal_period_num', record.get('internal_period_num'));
$('stamp_duty_ds2').query();
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, Leaf.Masker.unmask(Ext.getBody()));
}
function internal_period_num_renderer(value, record, name) {
var headers_ds = $('hls_monthly_statement_ds');
var record1 = headers_ds.getAt(0);
return record1.get('internal_period_num');
}
function leased_assets_query(){
$('leased_assets_ds').query();
}
]]></script>
<a:dataSets>
<a:dataSet id="yes_no_ds" lookupCode="YES_NO"/>
<a:dataSet id="hls_monthly_statement_ds" autoCreate="true">
<a:fields>
<a:field name="period_name" lovGridHeight="300" lovHeight="500"
lovService="gld.gld_period_lov"
lovWidth="500" required="true" title="GLD_PERIODS.PERIOD_NAME">
<a:mapping>
<a:map from="internal_period_num" to="internal_period_num"/>
<a:map from="period_name" to="period_name"/>
<a:map from="monthly_closed_flag" to="monthly_closed_flag"/>
</a:mapping>
</a:field>
</a:fields>
<a:events>
<a:event name="update" handler="monthly_statement_Onupdate"/>
</a:events>
</a:dataSet>
<a:dataSet id="accrued_interest_query_ds" autoCreate="true">
<a:fields>
<a:field name="company_code" lovGridHeight="300" lovHeight="450"
lovService="hls.HLS801.fnd_companies_for_lov" lovWidth="500" title="">
<a:mapping>
<a:map from="company_id" to="company_id"/>
<a:map from="company_code" to="company_code"/>
<a:map from="company_short_name" to="company_short_name"/>
</a:mapping>
</a:field>
<a:field name="year" defaultValue="${/parameter/@year}"/>
<a:field name="month" defaultValue="${/parameter/@month}"/>
<a:field name="internal_period_num" defaultValue="${/parameter/@internal_period_num}"/>
</a:fields>
<a:events>
<a:event name="update" handler="accrued_interest_Onupdate"/>
</a:events>
</a:dataSet>
<a:dataSet id="tre_accrued_interest_ds" autoPageSize="true" autoQuery="false"
model="hls.HLS801.tre_accrued_interest" queryDataSet="accrued_interest_query_ds"
selectable="true">
<a:fields>
<a:field name="recognized_flag" checkedValue="Y" defaultValue="Y" readOnly="true"
uncheckedValue="N"/>
</a:fields>
</a:dataSet>
<a:dataSet id="unearned_finance_income_query_ds" autoCreate="true">
<a:fields>
<a:field name="company_code" lovGridHeight="300" lovHeight="450"
lovService="hls.HLS801.fnd_companies_for_lov" lovWidth="500" title="">
<a:mapping>
<a:map from="company_id" to="company_id"/>
<a:map from="company_code" to="company_code"/>
<a:map from="company_short_name" to="company_short_name"/>
</a:mapping>
</a:field>
<a:field name="cf_item" defaultValue="1"/>
<a:field name="year" defaultValue="${/parameter/@year}"/>
<a:field name="month" defaultValue="${/parameter/@month}"/>
<a:field name="internal_period_num" defaultValue="${/parameter/@internal_period_num}"/>
<a:field name="rental_overdue_90" defaultValue="Y"/>
<a:field name="contract_overdue_90" defaultValue="Y"/>
</a:fields>
<a:events>
<a:event name="update" handler="unearned_finance_income_Onupdate"/>
</a:events>
</a:dataSet>
<a:dataSet id="unearned_finance_income_query_ds2" autoCreate="true">
<a:fields>
<a:field name="company_code" lovGridHeight="300" lovHeight="450"
lovService="hls.HLS801.fnd_companies_for_lov" lovWidth="500" title="">
<a:mapping>
<a:map from="company_id" to="company_id"/>
<a:map from="company_code" to="company_code"/>
<a:map from="company_short_name" to="company_short_name"/>
</a:mapping>
</a:field>
<a:field name="cf_item" defaultValue="3"/>
<a:field name="year" defaultValue="${/parameter/@year}"/>
<a:field name="month" defaultValue="${/parameter/@month}"/>
<a:field name="internal_period_num" defaultValue="${/parameter/@internal_period_num}"/>
</a:fields>
<a:events>
<a:event name="update" handler="unearned_finance_income_Onupdate"/>
</a:events>
</a:dataSet>
<a:dataSet id="unearned_finance_income_query_ds3" autoCreate="true">
<a:fields>
<a:field name="company_code" lovGridHeight="300" lovHeight="450"
lovService="hls.HLS801.fnd_companies_for_lov" lovWidth="500" title="">
<a:mapping>
<a:map from="company_id" to="company_id"/>
<a:map from="company_code" to="company_code"/>
<a:map from="company_short_name" to="company_short_name"/>
</a:mapping>
</a:field>
<a:field name="cf_item" defaultValue="3"/>
<a:field name="year" defaultValue="${/parameter/@year}"/>
<a:field name="month" defaultValue="${/parameter/@month}"/>
<a:field name="internal_period_num" defaultValue="${/parameter/@internal_period_num}"/>
</a:fields>
<a:events>
<a:event name="update" handler="unearned_finance_income_Onupdate"/>
</a:events>
</a:dataSet>
<a:dataSet id="unearned_finance_income_query_ds4" autoCreate="true">
<a:fields>
<a:field name="company_code" lovGridHeight="300" lovHeight="450"
lovService="hls.HLS801.fnd_companies_for_lov" lovWidth="500" title="">
<a:mapping>
<a:map from="company_id" to="company_id"/>
<a:map from="company_code" to="company_code"/>
<a:map from="company_short_name" to="company_short_name"/>
</a:mapping>
</a:field>
<a:field name="cf_item" defaultValue="901"/>
<a:field name="year" defaultValue="${/parameter/@year}"/>
<a:field name="month" defaultValue="${/parameter/@month}"/>
<a:field name="internal_period_num" defaultValue="${/parameter/@internal_period_num}"/>
</a:fields>
<a:events>
<a:event name="update" handler="unearned_finance_income_Onupdate"/>
</a:events>
</a:dataSet>
<a:dataSet id="unearned_finance_income_query_ds5" autoCreate="true">
<a:fields>
<a:field name="company_code" lovGridHeight="300" lovHeight="450"
lovService="hls.HLS801.fnd_companies_for_lov" lovWidth="500" title="">
<a:mapping>
<a:map from="company_id" to="company_id"/>
<a:map from="company_code" to="company_code"/>
<a:map from="company_short_name" to="company_short_name"/>
</a:mapping>
</a:field>
<a:field name="cf_item" defaultValue="1"/>
<a:field name="year" defaultValue="${/parameter/@year}"/>
<a:field name="month" defaultValue="${/parameter/@month}"/>
<a:field name="internal_period_num" defaultValue="${/parameter/@internal_period_num}"/>
<a:field name="rental_overdue_90" defaultValue="Y"/>
<a:field name="contract_overdue_90" defaultValue="N"/>
</a:fields>
<a:events>
<a:event name="update" handler="unearned_finance_income_Onupdate"/>
</a:events>
</a:dataSet>
<a:dataSet id="unearned_finance_income_ds" autoPageSize="true" autoQuery="false"
model="hls.HLS801.con_unearned_finance_income_new"
queryDataSet="unearned_finance_income_query_ds"
selectable="true">
<a:fields>
<a:field name="finance_income_recognized" checkedValue="Y" defaultValue="Y" readOnly="true"
uncheckedValue="N"/>
</a:fields>
</a:dataSet>
<a:dataSet id="unearned_finance_income_ds2" autoPageSize="true" autoQuery="false"
model="hls.HLS801.con_unearned_finance_income" queryDataSet="unearned_finance_income_query_ds2"
selectable="true">
<a:fields>
<a:field name="finance_income_recognized" checkedValue="Y" defaultValue="Y" readOnly="true"
uncheckedValue="N"/>
</a:fields>
</a:dataSet>
<a:dataSet id="unearned_finance_income_ds3" autoPageSize="true" autoQuery="false"
model="hls.HLS801.con_unearned_finance_income_loan" queryDataSet="unearned_finance_income_query_ds3"
selectable="true">
<a:fields>
<a:field name="finance_income_recognized" checkedValue="Y" defaultValue="Y" readOnly="true"
uncheckedValue="N"/>
</a:fields>
</a:dataSet>
<a:dataSet id="unearned_finance_income_ds4" autoPageSize="true" autoQuery="false"
model="hls.HLS801.con_unearned_finance_income_loan901" queryDataSet="unearned_finance_income_query_ds4"
selectable="true">
<a:fields>
<a:field name="finance_income_recognized" checkedValue="Y" defaultValue="Y" readOnly="true"
uncheckedValue="N"/>
</a:fields>
</a:dataSet>
<a:dataSet id="unearned_finance_income_ds5" autoPageSize="true" autoQuery="false"
model="hls.HLS801.con_unearned_finance_income_new"
queryDataSet="unearned_finance_income_query_ds5"
selectable="true">
<a:fields>
<a:field name="finance_income_recognized" checkedValue="Y" defaultValue="Y" readOnly="true"
uncheckedValue="N"/>
</a:fields>
</a:dataSet>
<a:dataSet id="close_open_ds" autoQuery="false" fetchAll="true" model="hls.HLS801.hls_current_period_query"
queryUrl="${/request/@context_path}/autocrud/hls.HLS801.hls_current_period_query/query"><![CDATA[
]]>
</a:dataSet>
<a:dataSet id="stamp_duty_ds" autoQuery="false" fetchAll="false" model="hls.HLS801.con_contract_stamp_duty"
queryUrl="${/request/@context_path}/autocrud/hls.HLS801.con_contract_stamp_duty/query"
selectable="true"/>
<a:dataSet id="stamp_duty_ds2" autoQuery="false" fetchAll="false"
model="hls.HLS801.con_contract_stamp_duty2"
queryUrl="${/request/@context_path}/autocrud/hls.HLS801.con_contract_stamp_duty2/query"
selectable="true"/>
<a:dataSet id="con_lease_charge_query_ds" autoCreate="true">
<a:fields>
<a:field name="contract_number"/>
</a:fields>
</a:dataSet>
<a:dataSet id="con_lease_charge_ds" autoQuery="false" fetchAll="false"
model="hls.HLS801.con_unearned_finance_income_item3"
queryDataSet="con_lease_charge_query_ds"
selectable="true"/>
<a:dataSet id="leased_assets_query_ds" autoCreate="true">
<a:fields>
<a:field name="no" />
<a:field name="retaildate" />
<a:field name="company_code" />
<a:field name="company_short_name" />
</a:fields>
</a:dataSet>
<a:dataSet id="leased_assets_ds" autoQuery="false" fetchAll="false"
model="hls.HLS801.con_unearned_leased_assets"
queryDataSet="leased_assets_query_ds"
selectable="true"/>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
</a:screenTopToolbar>
<a:hBox>
<a:tabPanel id="step" marginHeight="80" marginWidth="50">
<a:tabs>
<a:tab id="step_0" disabled="false" prompt="GLD_PERIODS.PERIOD_NAME" selected="true"
width="100">
<!--<a:hBox height="50">
<a:button disabled="true" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="step_0NextStep" text="HLS801.NEXT_STEP"/>
</a:hBox>-->
<a:hBox>
<a:fieldSet height="250" title="GLD_PERIODS.PERIOD_NAME" width="300">
<a:lov name="period_name" bindTarget="hls_monthly_statement_ds"
prompt="GLD_PERIODS.PERIOD_NAME" width="200">
</a:lov>
</a:fieldSet>
</a:hBox>
</a:tab>
<a:tab id="step_1" disabled="true" marginHeight="20" prompt="融资租赁应收利息" selected="false"
width="150">
<a:hBox height="50">
<!-- <a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<a:button id="button_1" click="unearned_finance_income_reversed" text="次月冲销"/>
<a:label width="5"/>
<a:button id="button_2" click="unearned_finance_income_confirm" text="生成凭证"/>
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="5" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.MONTH" readOnly="true"/>
<a:lov name="company_code" bindTarget="unearned_finance_income_query_ds"
prompt="HLS.COMPANY_CODE"/>
<a:textField name="company_short_name" bindTarget="unearned_finance_income_query_ds"
prompt="HLS.COMPANY_NAME" readOnly="true"/>
<a:textField name="contract_number" bindTarget="unearned_finance_income_query_ds"
prompt="合同编号"/>
</a:box>
</a:form>
<p/>
<a:grid id="unearned_finance_income_grid" bindTarget="unearned_finance_income_ds"
marginHeight="350" marginWidth="80" navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="unearned_finance_income_query"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="seq" prompt="HLS801.SEQ" width="50"/>
<a:column name="contract_number" prompt="合同编号" width="150"/>
<a:column name="lease_execution_date" prompt="执行日期" width="100"
renderer="Leaf.formatDate"/>
<a:column name="lease_end_date" prompt="到期日" width="100"
renderer="Leaf.formatDate"/>
<a:column name="overdue_days" prompt="逾期天数" width="100"/>
<a:column name="business_type_n" prompt="租赁类型" width="80"/>
<a:column name="lease_channel_n" prompt="商业模式" width="80"/>
<a:column name="principal" prompt="债权余额(含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="principal_15" prompt="DCFL债权(含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="net_principal" prompt="债权净值(不含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="net_principal_15" prompt="DCFL债权净值(不含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="unearned_finance_income" prompt="租息(含税)" width="120" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="net_unearned_finance_income" prompt="租息(不含税)" width="120" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="vat_unearned_finance_income" prompt="增值税" width="120" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="contract_status_n" prompt="合同状态" width="120"/>
<!--<a:column name="contract_overdue_90" prompt="合同是否逾期90天内"
width="120"/>-->
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_2" disabled="true" prompt="融资租赁一般手续费" selected="false" width="150">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<!--<a:button click="stamp_duty" text="确认"/>-->
<a:button id="button_3" click="unearned_finance_income_confirm2" text="生成凭证"/>
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="3" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.MONTH" readOnly="true"/>
<a:textField name="contract_number" bindTarget="con_lease_charge_query_ds"
prompt="合同编号"/>
</a:box>
</a:form>
<a:grid id="con_lease_charge_id" bindTarget="con_lease_charge_ds" marginHeight="350"
marginWidth="80"
navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="con_lease_charge_query"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="contract_number" prompt="合同执行编号" width="120"/>
<a:column name="business_type_n" prompt="业务类型" width="100"/>
<a:column name="division_n" prompt="产品线" width="100"/>
<a:column name="lease_execution_date" prompt="执行日期" width="100"/>
<a:column name="lease_end_date" prompt="到期日" width="100"/>
<a:column name="bp_name" prompt="客户名称" width="150"/>
<a:column name="lease_charge" prompt="手续费总额" renderer="Leaf.formatMoney" align="right"
width="120"/>
<a:column name="unearned_finance_income" prompt="本期手续费分摊额(含税)" align="right"
renderer="Leaf.formatMoney" width="200"/>
<a:column name="net_unearned_finance_income" prompt="本期手续费分摊额(不含税)" align="right"
renderer="Leaf.formatMoney" width="200"/>
<a:column name="vat_unearned_finance_income" prompt="本期手续费分摊额(税金)" align="right"
renderer="Leaf.formatMoney" width="200"/>
<a:column name="total_finance_income" prompt="手续费合计摊销金额" align="right"
renderer="Leaf.formatMoney" width="200"/>
<a:column name="surplus_finance_income" prompt="待摊金额" align="right"
renderer="Leaf.formatMoney" width="200"/>
<a:column name="contract_status_n" prompt="合同状态" width="120"/>
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_3" disabled="true" marginHeight="20" prompt="融资租赁分期手续费" selected="false"
width="150">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<!--<a:button click="unearned_finance_income_confirm2" text="HLS801.INCOME_CONFIRM"/>-->
<a:label width="5"/>
</a:hBox>
<h1 style="font-size: 20px">请查看分期手续费报表</h1>
<!--<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="2" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds2"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds2"
prompt="HLS801.MONTH" readOnly="true"/>
<a:lov name="company_code" bindTarget="unearned_finance_income_query_ds2"
prompt="HLS.COMPANY_CODE"/>
<a:textField name="company_short_name"
bindTarget="unearned_finance_income_query_ds2"
prompt="HLS.COMPANY_NAME" readOnly="true"/>
<a:textField name="contract_number" bindTarget="unearned_finance_income_query_ds2"
prompt="合同编号"/>
</a:box>
</a:form>
<p/>
<a:grid id="unearned_finance_income_grid2" bindTarget="unearned_finance_income_ds2"
marginHeight="350" marginWidth="80" navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="unearned_finance_income_query2"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="seq" prompt="HLS801.SEQ" width="50"/>
<a:column name="contract_number" prompt="合同编号" width="150"/>
<a:column name="contract_name" prompt="合同名称" width="150"/>
<a:column name="cf_item_desc" prompt="费用项目" width="150"/>
<a:column name="finance_amount" align="right" prompt="HLS.FINANCE_AMOUNT"
renderer="Leaf.formatMoney" width="110"/>
<a:column name="period" prompt="GLD_BALANCES.PERIOD_NAME" width="150"/>
<a:column name="interest" align="right" prompt="HLS801.INTEREST"
renderer="Leaf.formatMoney" width="100"/>
<a:column name="int_rate_implicit" align="right" prompt="HLS801.INT_RATE"
renderer="ratePercentRender" width="70"/>
<a:column name="calc_period" prompt="HLS801.CALC_PERIOD" width="150"/>
<a:column name="calc_date_count" prompt="HLS801.CALC_DATE_COUNT" width="100"/>
<a:column name="vat_unearned_finance_income" align="right"
prompt="手续费(含税)" renderer="Leaf.formatMoney"
width="110"/>
<a:column name="unearned_finance_income" align="right"
prompt="手续费(不含税)" renderer="Leaf.formatMoney"
width="110"/>
<a:column name="finance_income_recognized" prompt="HLS801.FINANCE_INCOME_RECOGNIZED"
width="80"/>
</a:columns>
</a:grid>-->
</a:tab>
<a:tab id="step_4" disabled="true" marginHeight="20" prompt="借款利息" selected="false"
width="100">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<a:button id="button_4" click="unearned_finance_income_reversed2" text="次月冲销"/>
<a:label width="5"/>
<a:button id="button_5" click="unearned_finance_income_confirm3" text="生成凭证"/>
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="5" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds3"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds3"
prompt="HLS801.MONTH" readOnly="true"/>
<a:lov name="company_code" bindTarget="unearned_finance_income_query_ds3"
prompt="HLS.COMPANY_CODE"/>
<a:textField name="company_short_name"
bindTarget="unearned_finance_income_query_ds3"
prompt="HLS.COMPANY_NAME" readOnly="true"/>
<a:textField name="withdrawal_number"
bindTarget="unearned_finance_income_query_ds3"
prompt="取款编号"/>
</a:box>
</a:form>
<p/>
<a:grid id="unearned_finance_income_grid_3" bindTarget="unearned_finance_income_ds3"
marginHeight="350" marginWidth="80" navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="unearned_finance_income_query3"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="loan_con_bp_name" prompt="借款机构" width="150"/>
<a:column name="withdrawal_number" prompt="取款编号" width="120"/>
<a:column name="rate" prompt="利息率" width="100" renderer="Leaf.formatNumber"/>
<a:column name="widthdrawal_date_n" prompt="借款日" width="100"/>
<a:column name="last_date_n" prompt="到期日" width="100"/>
<a:column name="current_balance" align="right" prompt="本期余额" renderer="Leaf.formatMoney" width="150"/>
<a:column name="next_balance" align="right" prompt="本期末余额" renderer="Leaf.formatMoney" width="150"/>
<a:column name="times" prompt="还款期次" width="100"/>
<a:column name="last_maturity_date_n" prompt="上期利息支付日" width="120"/>
<a:column name="next_maturity_date_n" prompt="下期利息支付日" width="120"/>
<a:column name="interest" align="right" prompt="利息金额" renderer="Leaf.formatMoney" width="150"/>
<a:column name="pay_type" prompt="期前期后区分" width="100"/>
<a:column name="guarantee_days" prompt="保证天数" width="100"/>
<a:column name="total_days" prompt="全部天数" width="100"/>
<a:column name="unearned_finance_income" align="right" prompt="应付利息" renderer="Leaf.formatMoney" width="150"/>
<a:column name="aaa" align="right" prompt="待摊利息" renderer="Leaf.formatMoney" width="150"/>
<a:column name="net_unearned_finance_income" align="right" prompt="应付利息(不含税)" renderer="Leaf.formatMoney" width="150"/>
<a:column name="aaa" align="right" prompt="待摊利息(不含税）" renderer="Leaf.formatMoney" width="150"/>
<a:column name="vat_unearned_finance_income" align="right" prompt="增值税-进项" renderer="Leaf.formatMoney" width="150"/>
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_5" disabled="true" marginHeight="20" prompt="借款手续费" selected="false"
width="120">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<a:button id="button_6" click="unearned_finance_income_confirm4" text="生成凭证"/>
<a:label width="5"/>
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="5" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds4"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds4"
prompt="HLS801.MONTH" readOnly="true"/>
<a:lov name="company_code" bindTarget="unearned_finance_income_query_ds4"
prompt="HLS.COMPANY_CODE"/>
<a:textField name="company_short_name"
bindTarget="unearned_finance_income_query_ds4"
prompt="HLS.COMPANY_NAME" readOnly="true"/>
<a:textField name="withdrawal_number"
bindTarget="unearned_finance_income_query_ds4"
prompt="取款编号"/>
</a:box>
</a:form>
<p/>
<a:grid id="unearned_finance_income_grid4" bindTarget="unearned_finance_income_ds4"
marginHeight="350" marginWidth="80" navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="unearned_finance_income_query4"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="withdrawal_number" prompt="取款编号" width="100"/>
<a:column name="times" prompt="取款期次" width="80"/>
<a:column name="widthdrawal_date_n" prompt="借款日期" width="100"/>
<a:column name="maturity_date_n" prompt="到期日期" width="100"/>
<a:column name="amount" align="right" prompt="取款金额" renderer="Leaf.formatMoney" width="150"/>
<a:column name="change_money" align="right" prompt="手续费总金额" renderer="Leaf.formatMoney" width="150"/>
<a:column name="unearned_finance_income" align="right" prompt="每月摊销金额" renderer="Leaf.formatMoney" width="150"/>
<a:column name="unearned_finance_income_bl" align="right" prompt="累计摊销金额" renderer="Leaf.formatMoney" width="150"/>
<a:column name="unearned_finance_income_al" align="right" prompt="手续费余额" renderer="Leaf.formatMoney" width="150"/>
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_6" disabled="true" prompt="印花税(租赁)" selected="false" width="100">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<a:button id="button_7" click="stamp_duty" text="生成凭证"/>
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="2" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.MONTH" readOnly="true"/>
</a:box>
</a:form>
<a:grid id="stamp_duty_grid" bindTarget="stamp_duty_ds" marginHeight="350" marginWidth="80"
navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="stamp_duty_query"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="rownum" prompt="序号" width="50"/>
<a:column name="internal_period_num" prompt="年月"
renderer="internal_period_num_renderer" width="100"/>
<a:column name="business_type_desc" align="center" prompt="租赁方式" width="100"/>
<a:column name="bp_agent" prompt="代理商" width="150"/>
<a:column name="bp_tenant" prompt="客户名" width="150"/>
<a:column name="contract_number" prompt="租赁合同编号" width="100"/>
<a:column name="contract_status_desc" prompt="合同状态" width="100"/>
<a:column name="lease_start_date" prompt="执行日期" width="100"/>
<a:column name="lease_term_month" prompt="租赁期" align="left" width="50"/>
<a:column name="lease_item_name" prompt="产品名称" width="150"/>
<a:column name="pattern" prompt="机型" width="150"/>
<a:column name="machine_number" prompt="机号" width="100"/>
<a:column name="serial_number" prompt="台数" width="100"/>
<a:column name="lease_item_amount" prompt="购买合同额" align="right"
renderer="Leaf.formatMoney" width="150"/>
<a:column name="stamp_duty_rate_1" prompt="印花税率" width="100"/>
<a:column name="stamp_duty_1" prompt="购买合同税额" align="right"
renderer="Leaf.formatMoney" width="150"/>
<a:column name="finance_amount" prompt="融资租赁合同额" align="right"
renderer="Leaf.formatMoney" width="150"/>
<a:column name="stamp_duty_rate_2" prompt="印花税率" width="100"/>
<a:column name="stamp_duty_2" prompt="租赁印花税额" align="right"
renderer="Leaf.formatMoney" width="100"/>
<a:column name="stamp_duty_total" prompt="印花税总额" align="right"
renderer="Leaf.formatMoney" width="100"/>
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_7" disabled="true" prompt="印花税(借款)" selected="false" width="100">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<a:button id="button_8" click="stamp_duty2" text="生成凭证"/>
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="2" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.MONTH" readOnly="true"/>
</a:box>
</a:form>
<a:grid id="stamp_duty_grid2" bindTarget="stamp_duty_ds2" marginHeight="350"
marginWidth="80"
navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="stamp_duty_query2"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="rownum" prompt="序号" width="50"/>
<a:column name="loan_contract_number" prompt="借款合同编号" width="150"/>
<a:column name="signing_date" prompt="约定日期" width="150"/>
<a:column name="bp_name" prompt="借款机构" width="200"/>
<a:column name="loan_contract_term_type" prompt="借款类型" width="150"/>
<a:column name="loan_date_from" prompt="借款开始日" width="150"/>
<a:column name="loan_date_to" prompt="借款结束日" width="150"/>
<a:column name="loan_amount" prompt="转让合同价" align="right"
renderer="Leaf.formatMoney"
width="150"/>
<a:column name="stamp_duty_rate_1" prompt="印花税率" width="150"/>
<a:column name="stamp_duty_1" prompt="转让合同税额" align="right"
renderer="Leaf.formatMoney"
width="150"/>
<a:column name="loan_amount" prompt="回租赁金额" align="right"
renderer="Leaf.formatMoney"
width="150"/>
<a:column name="stamp_duty_rate" prompt="印花税率" width="150"/>
<a:column name="stamp_duty" prompt="回租赁税额" align="right" renderer="Leaf.formatMoney"
width="150"/>
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_8" disabled="true" marginHeight="20" prompt="租赁收入增值税" selected="false"
width="120">
<a:hBox height="50">
<!-- <a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<!--<a:button click="unearned_finance_income_reversed" text="冲销"/>
<a:label width="5"/>
<a:button click="unearned_finance_income_confirm" text="HLS801.INCOME_CONFIRM"/>-->
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="5" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds5"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds5"
prompt="HLS801.MONTH" readOnly="true"/>
<a:lov name="company_code" bindTarget="unearned_finance_income_query_ds5"
prompt="HLS.COMPANY_CODE"/>
<a:textField name="company_short_name"
bindTarget="unearned_finance_income_query_ds5"
prompt="HLS.COMPANY_NAME" readOnly="true"/>
<a:textField name="contract_number" bindTarget="unearned_finance_income_query_ds5"
prompt="合同编号"/>
</a:box>
</a:form>
<p/>
<a:grid id="unearned_finance_income_grid_5" bindTarget="unearned_finance_income_ds5"
marginHeight="350" marginWidth="80" navBar="true" style="margin-left:3px">
<a:toolBar>
<a:button click="unearned_finance_income_query5"
icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT"
type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="seq" prompt="HLS801.SEQ" width="50"/>
<a:column name="contract_number" prompt="合同编号" width="150"/>
<a:column name="lease_execution_date" prompt="执行日期" width="100"
renderer="Leaf.formatDate"/>
<a:column name="lease_end_date" prompt="到期日" width="100"
renderer="Leaf.formatDate"/>
<a:column name="overdue_days" prompt="逾期天数" width="100"/>
<a:column name="business_type_n" prompt="租赁类型" width="80"/>
<a:column name="lease_channel_n" prompt="商业模式" width="80"/>
<a:column name="principal" prompt="债权余额(含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="principal_15" prompt="DCFL债权(含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="net_principal" prompt="债权净值(不含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="net_principal_15" prompt="DCFL债权净值(不含税)" width="150" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="unearned_finance_income_1" prompt="租息(含税)" width="120" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="net_unearned_finance_income_1" prompt="租息(不含税)" width="120" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="vat_unearned_finance_income_1" prompt="增值税" width="120" align="right"
renderer="Leaf.formatMoney"/>
<a:column name="contract_status_n" prompt="合同状态" width="120"/>
<!--<a:column name="contract_overdue_90" prompt="合同是否逾期90天外"
width="120"/>-->
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_9" disabled="true" prompt="待融资租赁资产" selected="false" width="110">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button disabled="true" text="HLS801.NEXT_STEP"/>
<a:label width="50"/>-->
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="4" labelWidth="150" style="margin-left:-80px">
<a:textField name="no" bindTarget="leased_assets_query_ds" prompt="DCS订单号"/>
<a:textField name="tenant_name" bindTarget="leased_assets_query_ds" prompt="代理商"/>
<a:textField name="agent_name" bindTarget="leased_assets_query_ds" prompt="客户名称"/>
</a:box>
</a:form>
<p/>
<a:grid id="leased_assets_grid_id" bindTarget="leased_assets_ds" marginHeight="300" marginWidth="80">
<a:toolBar>
<a:button click="leased_assets_query" icon="${/request/@context_path}/images/search.png" text="HLS.QUERY"/>
<a:button type="clear"/>
<a:button icon="${/request/@context_path}/images/excel_16.png" text="HLS.EXPORT" type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="no" prompt="DCS订单号" sortable="true" width="150"/>
<a:column name="retaildate" align="center" prompt="出库时间" sortable="true" width="100"/>
<a:column name="agent_name" prompt="代理商" sortable="true" width="250"/>
<a:column name="tenant_name" prompt="客户名称" sortable="true" width="250"/>
<a:column name="pattern" prompt="机型" sortable="true" width="120"/>
<a:column name="machine_number" prompt="机号" sortable="true" width="120"/>
<a:column name="equipment_number" prompt="装备号" width="120"/>
<a:column name="factory_price" align="right" renderer="Leaf.formatMoney" prompt="DCS 出厂价" sortable="true" width="120"/>
</a:columns>
</a:grid>
</a:tab>
<a:tab id="step_10" disabled="true" prompt="HLS801.MONTH_END" selected="false" width="100">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button click="nextStep" text="HLS801.NEXT_STEP"/>
<a:label width="80"/>-->
<a:button id="button_9" click="monthlyendFun" text="HLS801.MONTH_END"/>
</a:hBox>
<a:form column="1" marginWidth="80" style="margin-left:3px" title="HLS.QUERY_TITLE">
<a:box column="2" labelWidth="150" style="margin-left:-80px">
<a:textField name="year" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.YEAR" readOnly="true"/>
<a:textField name="month" bindTarget="unearned_finance_income_query_ds"
prompt="HLS801.MONTH" readOnly="true"/>
</a:box>
</a:form>
</a:tab>
<a:tab id="step_11" disabled="true" prompt="HLS801.PERIOD_CONTROL" selected="false" width="100">
<a:hBox height="50">
<!--<a:button click="upStep" text="HLS801.LAST_STEP"/>
<a:label width="5"/>
<a:button disabled="true" text="HLS801.NEXT_STEP"/>
<a:label width="50"/>-->
</a:hBox>
<a:grid id="close_open_grid" bindTarget="close_open_ds" marginHeight="300" marginWidth="80">
<a:columns>
<a:column name="period_year" align="center" prompt="GLD_PERIODS.PERIOD_YEAR"
sortable="true" width="100"/>
<a:column name="period_num" align="center"
prompt="FND_DIMENSIONS.DIMENSION_SEQUENCE" sortable="true" width="80"/>
<a:column name="start_date_c" align="center" prompt="GLD_EXCHANGE_RATE.START_DATE"
sortable="true" width="150"/>
<a:column name="end_date_c" align="center" prompt="GLD_EXCHANGE_RATE.END_DATE"
sortable="true" width="150"/>
<a:column name="quarter_num" align="center" prompt="GLD_PERIOD_STATUS.QUARTER"
sortable="true" width="80"/>
<a:column name="period_name" align="center" prompt="GLD_PERIODS.PERIOD_NAME"
sortable="true" width="120"/>
<a:column name="adjustment_flag" align="center" prompt="GLD_PERIOD_STATUS.ADJUST"
width="100"/>
<a:column name="period_status_code" align="center"
prompt="GLD_PERIOD_STATUS.PERIOD_STATUS" renderer="statusRenderer"
width="120"/>
<a:column name="actionOpen" align="center" prompt="HLS.OPEN_PERIOD"
renderer="openPeriodDs" sortable="true" width="120"/>
<a:column name="actionClose" align="center" prompt="HLS.CLOSE_PERIOD"
renderer="closePeriodDs" sortable="true" width="120"/>
</a:columns>
<a:editors>
<a:checkBox id="closed_grid_cb"/>
</a:editors>
</a:grid>
</a:tab>
</a:tabs>
</a:tabPanel>
</a:hBox>
</a:screenBody>
</a:view>
</a:screen>