0001 expense_item_id date_incurred user_id name_first name_last report_id report_no report_title date_from date_to purpose cash_advance is_complete when_submitted when_approved when_emp_pmt_logged status_id_emp status_employee when_logged_for_invoicing invoice_id when_invoiced amt_invoiced_base handling_percent amt_invoiced_total when_pmt_received amt_pmt_received when_adjusted amt_adjusted balance_due status_id_admin status_admin bohi bpi_id dbase project_id is_billable is_dedicated_site jobno afe_no job_title client_pm_id client location local_currency conv_factor_toreim conv_factor_tousd conv_factor_toclient reimbursed_currency_id reimbursed_currency reimbursed_currency_abrv expense_type_id expense_type mileage mileage_rate mileage_rate_reim expense_amount_local expense_amount_reim expense_amount_usd notes 0002 1 2015-01-28 0003 Alan Aldo 1 0001 Test Submittal 2015-01-28 2015-01-28 Testing the expense account submittal process 0.00 2 2015-01-28 14:09:01 0000-00-00 00:00:00 0000-00-00 00:00:00 2 Submitted 1 Await Processing 000000 000002 rogandeila 8 1 0 102 Green Field 7 0 Chevron Orinda USD 1.00000 1.00000 1 85 US Dollar USD 1 Supplies 150.00 150 150 Beer 0003 2 2015-01-28 0003 Alan Aldo 2 0002 OH Expense 2015-01-28 2015-01-28 Testing OH expense submittal 0.00 2 2015-01-28 14:12:22 0000-00-00 00:00:00 0000-00-00 00:00:00 2 Submitted 1 Await Processing 000000 000000 OH Overhead Orinda USD 1.00000 1.00000 1 85 US Dollar USD 3 Miscellaneous 100.00 100 100