* id name purchase_date purchase_value useful_life_months residual_value status created_at

* id code name type is_active

* id entry_date description reference_type reference_id created_by created_at

* id entry_id coa_id debit credit

* id user_id role_type month year attendance_score discipline_notes tickets_completed avg_speed_minutes rating_avg punctuality_score complaints_count revenue_generated efficiency_percent invoices_completed avg_response_time_mins input_errors_count report_closing_status schedule_order_score cashflow_accuracy ar_collection_rate report_delay_days cash_diff_amount final_kpi_score updated_at

* id ticket_id user_id customer_id description severity status created_at

* id role_type component_name weight_percent

* id username password name email phone role_id photo is_active last_login created_at updated_at

* id sparepart_id transaction_type source source_id qty stock_before stock_after notes created_by created_at

* id purchase_number supplier_id supplier_name total_amount status received_at created_by created_at

* id purchase_id sparepart_id qty cost_price subtotal

* id code name category brand price cost_price stock min_stock unit is_active created_at updated_at

* id transfer_number from_location to_location status notes created_at

* id code name company email phone address city customer_type_id latitude longitude location_photo favorite_teknisi_id notes is_active created_by created_at updated_at

* id customer_id device_name brand model serial_number purchase_date warranty_expired notes is_active created_at

* id name description is_active

* id name color is_closed sequence

* id name code description default_margin is_active created_at

* id name code description base_price is_active created_at

* id ticket_id teknisi_id checkin_type latitude longitude address checkin_time checkout_time duration_minutes notes created_at

* id ticket_id checklist_item is_checked checked_by checked_at notes created_at

* id ticket_id teknisi_id expense_type amount description receipt_url is_approved approved_by approved_at created_by created_at

* id ticket_id onsite_checkin_id photo_type photo_url description uploaded_by created_at

* id ticket_id report_number report_data pdf_url is_generated generated_by generated_at created_at

* id ticket_id signature_type signature_data signer_name signer_phone signed_at ip_address created_at

* id order_number session_id customer_id customer_name customer_phone subtotal discount tax total payment_method amount_paid change_due status notes created_by created_at completed_at

* id order_id sparepart_id sparepart_code sparepart_name price cost_price quantity discount subtotal

* id user_id start_time end_time starting_cash ending_cash status notes

* id project_number project_name customer_id project_type_id status_id pm_id start_date end_date survey_date deal_date completed_date nilai_rab nilai_penawaran nilai_deal biaya_barang biaya_tenaga biaya_transport fee_marketing total_cost laba_rugi margin_persen description location notes survey_file rab_file penawaran_file kontrak_file bast_file created_by created_at updated_at

* id project_id action description old_value new_value user_id created_at

* id project_id invoice_number jumlah status due_date paid_at created_at

* id project_id user_id role assigned_at

* id project_id percent description photo created_by created_at

* id project_id item_name qty satuan harga_satuan total supplier status created_at

* lead_baru menunggu_deal project_aktif project_selesai total_nilai_proyek total_laba_tahun

* id setting_key setting_value description created_at updated_at

* id phone message message_type priority status error_message created_at sent_at updated_at

* id invoice_number ticket_id customer_id service_fee sparepart_fee discount tax total_amount final_amount status payment_method paid_at due_date notes created_by created_at updated_at

* id invoice_id item_type item_id item_name quantity price subtotal

* id job_number ticket_id title description assigned_to status_id notes started_at completed_at created_at updated_at

* id ticket_number customer_id service_type_id teknisi_id title description status_id priority_id estimated_price final_price device_brand device_model device_sn accessories notes scheduled_date scheduled_time started_at completed_at created_by created_at updated_at

* id ticket_id user_id action description old_value new_value created_at

* id ticket_id sparepart_id quantity price subtotal created_at

* tickets_today tickets_baru tickets_proses tickets_waiting revenue_month revenue_year completed_today total_customers total_teknisi

select table acc_assets acc_coa acc_journal_entries acc_journal_items employee_kpis hr_complaints hr_kpi_settings hr_users inv_inventory_transactions inv_purchases inv_purchase_items inv_spareparts inv_stock_transfers mst_customers mst_customer_devices mst_customer_types mst_project_statuses mst_project_types mst_service_types onsite_checkins onsite_checklists onsite_expenses onsite_photos onsite_reports onsite_signatures pos_orders pos_order_items pos_sessions prj_projects prj_project_history prj_project_invoices prj_project_members prj_project_progress prj_project_purchases prj_v_project_stats sys_settings sys_wa_queue trx_invoices trx_invoice_details trx_jobs trx_tickets trx_ticket_history trx_ticket_spareparts v_dashboard_stats . 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 acc_assets acc_coa acc_journal_entries acc_journal_items employee_kpis hr_complaints hr_kpi_settings hr_users inv_inventory_transactions inv_purchases inv_purchase_items inv_spareparts inv_stock_transfers mst_customers mst_customer_devices mst_customer_types mst_project_statuses mst_project_types mst_service_types onsite_checkins onsite_checklists onsite_expenses onsite_photos onsite_reports onsite_signatures pos_orders pos_order_items pos_sessions prj_projects prj_project_history prj_project_invoices prj_project_members prj_project_progress prj_project_purchases prj_v_project_stats sys_settings sys_wa_queue trx_invoices trx_invoice_details trx_jobs trx_tickets trx_ticket_history trx_ticket_spareparts v_dashboard_stats .	select column