var override_queryfields = [ 
{
	name : 'bp_id_tenant',
	queryexpression : "t1.bp_id_tenant =${@bp_id_tenant}"
},
{
	name : 'bp_id',
	queryexpression : "t1.bp_id_tenant =${@bp_id}"
},
{
	name : 'bp_id_tenant_n',
	queryexpression : "t1.bp_id_tenant_n like ${@bp_id_tenant_n}"
},
 
{
	name : 'lease_start_date_from',
	queryexpression : "t1.lease_start_date between to_date(${@lease_start_date_from},'yyyy-mm-dd') and nvl(to_date(${@lease_start_date_to},'yyyy-mm-dd'),t1.lease_start_date)"
},
{
	name : 'lease_start_date_to',
	queryexpression : "t1.lease_start_date between nvl(to_date(${@lease_start_date_from},'yyyy-mm-dd'),t1.lease_start_date) and to_date(${@lease_start_date_to},'yyyy-mm-dd')"
},
 
{
	name : 'contract_num_from',
	queryexpression : "t1.contract_id between ${@contract_num_from} and nvl(${@contract_num_to},${@contract_num_from})"
},
{
	name : 'contract_num_to',
	queryexpression : "t1.contract_id between ${@contract_num_from} and nvl(${@contract_num_to},${@contract_num_from})"
},
{
	name : 'search_term_1',
	queryexpression : "t1.search_term_1 like ${@search_term_1}"
},
{
	name : 'serial_number',
	queryexpression : "t1.serial_number like ${@serial_number}"
} ,
{
	name : 'contract_number',
	queryexpression : "t1.contract_number like ${@contract_number}"
} ,
{
	name : 'cf_item',
	queryexpression : "t1.cf_item = ${@cf_item}"
} ,
{
	name : 'cf_item_n',
	queryexpression : "t1.cf_item_n like ${@cf_item_n}"
},
{
	name : 'contract_status',
	queryexpression : "t1.contract_status = ${@contract_status}"
} ,
{
	name : 'default_contract_status',
	queryexpression : "t1.contract_status in ${@default_contract_status}"
},
 
{
	name : 'write_off_date_from',
	queryexpression : "t1.write_off_date between to_date(${@write_off_date_from},'yyyy-mm-dd') and nvl(to_date(${@write_off_date_to},'yyyy-mm-dd'),t1.write_off_date)"
},
{
	name : 'write_off_date_to',
	queryexpression : "t1.write_off_date between nvl(to_date(${@write_off_date_from},'yyyy-mm-dd'),t1.write_off_date) and to_date(${@write_off_date_to},'yyyy-mm-dd')"
}   

];
 //预收款租金
//var add_datafilters=[
//                     {
//                    	name:'datafilter1',
//                    	expression:"(t1.transaction_type = 'ADVANCE_RECEIPT' and t1.cf_item = 1)"
//                    }
//                     ];


 
override();
//add_datafilter();
