var override_queryfields = [
{
	name : 'trandatetime_from',
	queryexpression : "t1.trandatetime >= trunc(to_date(${@trandatetime_from},'yyyy-mm-dd') )"
},
{
	name : 'trandatetime_to',
	queryexpression : "trunc(t1.trandatetime) <=to_date(${@trandatetime_to},'yyyy-mm-dd')"
},
{
	name : 'amount_avaliable_from',
	queryexpression : "t1.amount_avaliable >= ${@amount_avaliable_from}"
},
{
	name : 'amount_avaliable_to',
	queryexpression : "t1.amount_avaliable <= ${@amount_avaliable_to}"
},
{
	name : 'write_off_amount_from',
	queryexpression : "t1.write_off_amount >= ${@write_off_amount_from}"
},
{
	name : 'write_off_amount_to',
	queryexpression : "t1.write_off_amount <= ${@write_off_amount_to}"
}
];


var add_datafilters = [
               		{
               			name : 'create_transaction_flag',
               			expression : "(nvl(t1.create_transaction_flag,'N') = 'N')"

               		} ];
add_datafilter();
override();