+ 'civicrm_financial_account_1' => array(
+ 'dao' => 'CRM_Financial_DAO_FinancialAccount',
+ 'fields' => array(
+ 'name' => array(
+ 'title' => ts('Revenue Account'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'id' => array(
+ 'title' => ts('Revenue Account ID'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'accounting_code' => array(
+ 'title' => ts('Revenue Accounting code'),
+ 'no_display' => TRUE,
+ 'required' => TRUE,
+ ),
+ ),
+ ),
+ 'civicrm_financial_item' => array(
+ 'dao' => 'CRM_Financial_DAO_FinancialItem',
+ 'fields' => array(
+ 'status_id' => array(
+ 'title' => ts('Status'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'id' => array(
+ 'title' => ts('Financial_item_id'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'description' => array(
+ 'title' => ts('Description'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ ),
+ ),
+ 'civicrm_financial_trxn_1' => array(
+ 'dao' => 'CRM_Financial_DAO_FinancialTrxn',
+ 'fields' => array(
+ 'total_amount' => array(
+ 'title' => ts('Deferred Transaction Amount'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ 'dbAlias' => 'GROUP_CONCAT(financial_trxn_1_civireport.total_amount)',
+ ),
+ 'trxn_date' => array(
+ 'title' => ts('Deferred Transaction Date'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ 'dbAlias' => 'GROUP_CONCAT(financial_trxn_1_civireport.trxn_date)',
+ ),
+ ),
+ ),
+ 'civicrm_contact' => array(
+ 'dao' => 'CRM_Contact_DAO_Contact',
+ 'fields' => array(
+ 'display_name' => array(
+ 'title' => ts('Display_name'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ ),
+ ),
+ 'civicrm_membership' => array(
+ 'dao' => 'CRM_Member_DAO_Membership',
+ 'fields' => array(
+ 'start_date' => array(
+ 'title' => ts('Start Date'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ 'dbAlias' => 'IFNULL(membership_civireport.start_date, event_civireport.start_date)',
+ ),
+ 'end_date' => array(
+ 'title' => ts('End Date'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ 'dbdbAlias' => 'IFNULL(membership_civireport.end_date, event_civireport.end_date)',
+ ),
+ ),
+ ),
+ 'civicrm_event' => array(
+ 'dao' => 'CRM_Event_DAO_Event',
+ ),
+ 'civicrm_participant' => array(
+ 'dao' => 'CRM_Event_DAO_Participant',
+ ),
+ 'civicrm_contribution' => array(
+ 'dao' => 'CRM_Contribute_DAO_Contribution',
+ 'fields' => array(
+ 'id' => array(
+ 'title' => ts('Contribution ID'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'contact_id' => array(
+ 'title' => ts('Contact ID'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'source' => array(
+ 'title' => ts('Source'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ ),
+ 'filters' => array(
+ 'receive_date' => array(
+ 'title' => ts('Receive Date'),
+ 'operatorType' => CRM_Report_Form::OP_DATE,
+ 'type' => CRM_Utils_Type::T_DATE,
+ ),
+ 'cancel_date' => array(
+ 'title' => ts('Cancel Date'),
+ 'operatorType' => CRM_Report_Form::OP_DATE,
+ 'type' => CRM_Utils_Type::T_DATE,
+ ),
+ 'revenue_recognition_date' => array(
+ 'title' => ts('Revenue Recognition Date'),
+ 'operatorType' => CRM_Report_Form::OP_DATE,
+ 'type' => CRM_Utils_Type::T_DATE,
+ ),
+ ),
+ ),
+ 'civicrm_financial_trxn' => array(
+ 'dao' => 'CRM_Financial_DAO_FinancialTrxn',
+ 'fields' => array(
+ 'status_id' => array(
+ 'title' => ts('Transaction Status'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'trxn_date' => array(
+ 'title' => ts('Transaction Date'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ 'total_amount' => array(
+ 'title' => ts('Transaction Amount'),
+ 'required' => TRUE,
+ 'no_display' => TRUE,
+ ),
+ ),
+ 'filters' => array(
+ 'trxn_date' => array(
+ 'title' => ts('Transaction Date'),
+ 'operatorType' => CRM_Report_Form::OP_DATE,
+ 'type' => CRM_Utils_Type::T_DATE,
+ ),
+ ),
+ ),