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 : 'cf_item',
	queryexpression : "t1.cf_item = ${@cf_item}"
} 

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


 
override();
add_datafilter();
