* id transfer_date amount currency currency_amount reason from_payment_method to_payment_method created_at updated_at

* id advance_id url file_name uploaded_at

* id advance_expense_id url file_name mime_type uploaded_at

* id trip_id date amount service category created_at updated_at qashio

* id employee_name amount trip_date trip_id status deduction_date deduction_source created_at updated_at currency currency_amount petty_cash qashio advance_payment_method payment_reference bulk_advance_id

* id slug display_name is_system created_at

* id role_id path_prefix

* id trip_id client_name batch_total_amount company trip_ids allocations batch_receipt_upload amount channel payment_date payment_id created_at currency currency_amount remarks

* id company_name pension_month mol_id phone_number amount com_amount include_vat vat_amount net_amount payment_method payment_date attachment_1 attachment_2 attachment_3 created_at updated_at

* id company_name year month_no amount payment_method pay_date docs remarks created_at updated_at reimbursement_month attachment_1 attachment_2 attachment_3

* id company_name total_employees salary_month salary_amount sif_charges service_charges atm_charges discount include_vat vat_rate vat_amount total_amount payment_method payment_date attachment_1 attachment_2 attachment_3 created_at updated_at

* name address tel_no po_box trn_no contact_person person_number

* id client_id trip_id amount_due paid

* name

* id name icon file_name file_path expiry_date created_at

* id expense_id url file_name mime_type uploaded_at

* id title note status created_at updated_at

* id date driver_name vehicle_number types liter amount currency paid_from_advance trip_id created_at updated_at

* id diesel_id url file_name uploaded_at

* id employee_name month year base_salary working_days trip_allowance visa_deduction advance_deduction fine_deduction diesel_sold net_salary payment_status payment_date payment_method created_at updated_at

* employee refered_as designation contact_no whatsapp_no salary visa_outstanding advance_avl visa_under visa_exp nationality eid health_ins_exp emp_ins_exp license_exp status

* id type url uploadDate employee_name

* id miscellaneous_id payment_date amount method reference_no notes created_at updated_at

* id trip_id reason truck_number driver_name driver_fault fine_date amount payment_status paid_by salary_id

* fine_id url uploaded_at

* id date name cost remarks photo_url

* id number quantity cost remarks

* id date trip_id fixed_tir_price sold_tir_price amount_due paid tir_number remarks

* id invoice_number client url date price status approval_status approved_by approved_at trip_ids include_vat include_vat_company_rate vat_amount total_with_vat due_date company invoice_destination

* id payment_group_id client_name company invoice_id invoice_ids allocations amount payment_date channel created_at remarks

* id invoice_id company credit_date amount vat_applied created_at

* id invoice_id trip_id date description d_o qty unit price amount lpo_no driver_name truck_no extra_delivery_details created_at updated_at is_bold item_order

* id invoice_id amount channel payment_date bulk_payment_id created_at

* id invoice_id invoice_item_id remark created_at updated_at

* id invoice_id invoice_item_id share_amount created_at updated_at

* id invoice_id remark created_at updated_at

* id name created_at

* id project_id invoice_id added_at

* id project_id payment_date amount remarks payment_method receipt_upload created_at updated_at

* id user action description timestamp

* id month year income expense net_profit created_at updated_at

* id master_account_id category reference_id amount type description created_at

* id date category description amount vat total reference_no status flow_type petty_cash prepaid_expense prepaid_start_date prepaid_end_date prepaid_write_off_date paid_from_advance trip_id company remarks document_url created_at updated_at trn supplier truck_number employee_name

* id name is_active created_at updated_at

* employee owner refered_as designation contact_no whatsapp_no visa_under visa_exp nationality eid health_ins_exp emp_ins_exp license_exp

* id type url uploadDate employee_name

* name remarks eid phone_number whatsapp_number address

* trailer_no owner company_under mulkiya_exp oman_ins_exp

* id type url uploadDate other_trailer_number

* truck_number owner driver year vehicle_under trailer_no country mulkiya_exp ins_exp

* id type url uploadDate other_truck_number

* id date owner driver truck remark amount status created_at updated_at

* id account_id url file_name uploaded_at document_type

* id payment_id owner_name batch_total_amount account_ids allocations channel batch_receipt_upload account_id amount payment_date remark created_at

* id trip_id party_name trip_date amount status deduction_date deduction_source currency currency_amount petty_cash qashio advance_payment_method payment_reference created_at updated_at

* id code name company display_name account_kind account description is_credit created_at updated_at

* id chq_no issued_from issued_to issued_for amount chq_dated pdc_days_left status picture_path created_at updated_at

* id employee_name amount advance_date status remarks currency currency_amount petty_cash qashio advance_payment_method created_at updated_at

* id personal_advance_id payment_date amount source payment_method remarks salary_id receipt_upload created_at updated_at

* id qashio_id transaction_category transaction_time billing_amount billing_currency transaction_amount transaction_currency memo merchant_name expense_category_name card_name card_last_four card_holder_name raw_json synced_at assigned_trip_id assigned_kind assigned_at voided voided_at linked_trip_expense_id linked_advance_tracker_id marked_synced remark clearing_delta qashio_txn_id parent_txn_id message_type

* id salary_id url file_name document_type uploaded_at

* employee_name year month created_at

* name tel_no contact_person phone_no about trn

* id payment_date company_name assigned_months payment_method payment_amount remarks created_at updated_at

* id payment_date amount remarks payment_method created_at

* id quantity added_at remarks

* id quantity unit_cost updated_at

* trailer_no company_under mulkiya_exp oman_ins_exp asset_value status

* id type url uploadDate trailer_number

* id date destination_country service_provider client trip_description remarks trip_type return_load created_at updated_at tons unit cash_trip_receipt_upload

* id trip_id uae_border uae_border_details international_border international_border_details custom extra_delivery extra_delivery_details driver_extra_rate extra_charges extra_charges_details paid_by_client paid_by_client_details expense tons unit

* id trip_id lpo_no dio_no tir_no tir_price

* id trip_id type url upload_date

* id trip_id date amount service outsource_expense category created_at updated_at qashio expense_payment_method

* id trip_id company_rate driver_rate trip_rate advance advance_expense receivable_client receivable_status outsource_payment payable_status outsource_payment_method outsource_payment_reference truck_profit company_profit remaining_advance

* id trip_id investor_type share_amount

* id trip_id date amount service DO_num tons unit invoice_include_vat created_at updated_at

* id trip_id truck_no driver other_truck_no other_driver other_driver_contact other_owner other_owner_number diesel diesel_sold

* id date driver_name truck_number vehicle_under maintenance_detail credit_card bank cash vat round_off total status supplier trip_id paid_from_advance petty_cash qashio_amount include_vat

* id payment_id supplier_name batch_total_amount maintenance_ids allocations batch_receipt_upload truck_maintenance_id amount channel payment_date created_at

* id truck_number url uploaded_at truck_maintenance_id

* truck_number driver year vehicle_under trailer_no country mulkiya_exp ins_exp truck_value status

* id type url uploadDate truck_number

* id username password_hash email created_at role last_modified active last_login

* id truck_number driver vehicle_under status comment date created_at updated_at

select table account_transfers advance_documents advance_expense_documents advance_expense_usage advance_tracker app_roles app_role_permissions cash_trip_payment_entries city_exchange_pension city_exchange_reimbursement city_exchange_salary clients client_share_accounts company company_documents company_expense_documents dashboard_notes diesel diesel_documents driver_salaries employees employee_documents expense_payment_logs fines fine_documents inventory_parts inventory_tir investor1_accounts invoice invoice_bulk_payments invoice_credit_notes invoice_items invoice_payments kec_invoice_item_remarks kec_invoice_item_share_amounts kec_invoice_remarks kec_projects kec_project_invoices kec_project_payments logs master_accounts master_account_details miscellaneous miscellaneous_categories other_employees other_employee_documents other_owner other_trailer other_trailer_documents other_trucks other_trucks_documents outside_accounts outside_account_documents outside_account_payments outsource_advance_details payment_types pdc personal_advance personal_advance_payments qashio_erp_transactions salary_documents salary_na suppliers tax_submitted tir_sold_payment_log tir_stock_additions tir_stock_settings trailers trailer_documents trips trip_charges trip_documents trip_documents_files trip_expenses trip_financials trip_investors trip_paid_by_client trip_resources truckmaintenance truckmaintenance_payments truckmaintenance_receipts trucks truck_documents users vehicle_status . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table account_transfers advance_documents advance_expense_documents advance_expense_usage advance_tracker app_roles app_role_permissions cash_trip_payment_entries city_exchange_pension city_exchange_reimbursement city_exchange_salary clients client_share_accounts company company_documents company_expense_documents dashboard_notes diesel diesel_documents driver_salaries employees employee_documents expense_payment_logs fines fine_documents inventory_parts inventory_tir investor1_accounts invoice invoice_bulk_payments invoice_credit_notes invoice_items invoice_payments kec_invoice_item_remarks kec_invoice_item_share_amounts kec_invoice_remarks kec_projects kec_project_invoices kec_project_payments logs master_accounts master_account_details miscellaneous miscellaneous_categories other_employees other_employee_documents other_owner other_trailer other_trailer_documents other_trucks other_trucks_documents outside_accounts outside_account_documents outside_account_payments outsource_advance_details payment_types pdc personal_advance personal_advance_payments qashio_erp_transactions salary_documents salary_na suppliers tax_submitted tir_sold_payment_log tir_stock_additions tir_stock_settings trailers trailer_documents trips trip_charges trip_documents trip_documents_files trip_expenses trip_financials trip_investors trip_paid_by_client trip_resources truckmaintenance truckmaintenance_payments truckmaintenance_receipts trucks truck_documents users vehicle_status .	select column