* id transaction_no transaction_date reference_no transaction_type party_type party_name description status source_module source_record_id total_debit total_credit created_by updated_by created_at updated_at

* id account_code account_name account_type parent_account_id normal_balance is_cash_account is_active notes created_by updated_by created_at updated_at

* id user_id employee_id token_hash device_name ip_address user_agent created_at last_used_at expires_at revoked_at

* id scope identifier_hash identifier_label window_started_at attempts blocked_until last_attempt_at created_at updated_at

* id asset_tag asset_code asset_category_id item_name brand model serial_number imei_1 imei_2 sim_number mobile_number plan_type processor ram storage operating_system charger_serial_number accessories_included purchase_date supplier warranty_date asset_condition status assigned_employee_id location purchase_cost accountability_form_no notes asset_photo public_view_token created_by updated_by created_at updated_at

* id form_control_no employee_id revision_no status generated_by printed_by printed_at remarks created_at updated_at

* id form_id asset_id assignment_id asset_tag asset_snapshot created_at

* id asset_id employee_id assigned_at expected_return_at condition_upon_issue accessories_included issued_by_user_id acknowledged_by returned_at return_condition assignment_notes received_by_user_id returned_to_user_id status clearance_status created_at

* id asset_id action_type employee_id reference_table reference_id remarks performed_by created_at

* id category_name description asset_tag_prefix is_active created_at updated_at

* id asset_id template_id label_type reprint_reason printer_used printed_by printed_at ip_address user_agent

* id template_name label_size width_mm height_mm include_brand_model include_serial include_qr status created_at updated_at

* id asset_id maintenance_date maintenance_type vendor_name cost details status performed_by_user_id resolved_at created_at

* id employee_id asset_id print_type reference_id label_type assets_included reprint_reason printer_used printed_by printed_at ip_address user_agent

* id asset_id from_employee_id to_employee_id from_location to_location transfer_date reason processed_by related_assignment_id created_at

* id employee_id attendance_id attendance_date requested_time_in requested_time_out reason attachment status created_by approved_by approved_at remarks created_at updated_at

* id name active

* id value attribute_parent_id

* id user_id user_name module record_type record_id action old_value new_value remarks ip_address user_agent created_at

* id user_id username event_type status ip_address ip_source is_internal_ip is_whitelisted_ip network_label user_agent browser_name platform device_hash session_id request_uri notes metadata_text created_at

* id name active

* id name active

* id offboarding_id clearance_area item_label assigned_to status remarks cleared_by cleared_at created_at updated_at

* id company_name service_charge_value vat_charge_value address phone payroll_funding_account country message currency

* id delivery_no supplier_name remarks created_at user_id status cancel_reason cancelled_at cancelled_by attachment_path

* id delivery_id product_id qty

* id department_name department_code department_head_id status created_at updated_at

* id employee_id case_type incident_date description attachment issued_by employee_response hr_remarks final_action acknowledgment_date status created_at updated_at

* id document_code title company department_id document_type_id other_document_type category uploaded_by current_approver_id additional_reviewer_id priority due_date original_filename stored_filename file_path file_size mime_type is_confidential status remarks submitted_at approved_at returned_at rejected_at archived_at created_at updated_at

* id document_id action user_id old_status new_status remarks ip_address user_agent created_at

* id document_id step_id user_id remarks_type remarks is_private page_number created_at

* id document_id step_id approver_id signature_file_path page_number x_position y_position width height signed_at created_at

* id document_id step_order approver_id approver_role status remarks signature_required signed_at approved_at returned_at rejected_at created_at updated_at

* id document_id version_number version_type filename file_path file_size mime_type uploaded_by created_at

* id department_id user_id can_upload can_view_department can_approve can_view_confidential can_view_private_remarks status created_at updated_at

* id department_id type_name type_code category requires_signature requires_approval default_workflow_id default_approver_id allowed_file_types max_file_size status created_at updated_at

* id workflow_name department_id document_type_id status created_at updated_at

* id workflow_id step_order approver_role approver_user_id require_signature require_remarks created_at updated_at

* id employee_id completion_percent status last_reviewed_by last_reviewed_at remarks created_at updated_at

* id raw_name employee_id corrected_name created_at updated_at

* id employee_id skill_name certification_name issuing_organization issue_date expiry_date attachment status created_at updated_at

* id employee_id document_type_id category section is_required is_confidential document_title file_path original_filename stored_filename file_extension mime_type file_size issue_date version_no expiry_date remarks status uploaded_by last_updated_by updated_by replaced_document_id archived_by archived_at created_at updated_at

* id document_id employee_id action_type user_id user_name ip_address user_agent remarks created_at

* id section category document_name is_required requires_expiry sort_order status created_at updated_at

* id document_id employee_id version_no document_type_id category section document_title original_filename stored_filename file_path file_extension mime_type file_size issue_date expiry_date is_required is_confidential remarks replaced_by replaced_at created_at

* id employee_id school course year_graduated awards document_path status created_at updated_at

* id employee_id previous_employer position start_date end_date reason_for_leaving status created_at updated_at

* id employee_id full_name relationship birthdate contact_no is_dependent status created_at updated_at

* id employee_id medical_exam_date fit_to_work_status medical_expiry_date certificate_path remarks status created_at updated_at

* id employee_id movement_type field_name old_value new_value effective_date reason attachment status created_by approved_by approved_at created_at updated_at

* id employee_id item_key item_label status completed_by completed_at remarks created_at updated_at

* id employee_id schedule_id effective_date end_date assigned_by remarks status created_at updated_at

* id transaction_id expense_date expense_type vendor_name amount payment_status related_inventory_reference notes created_by updated_by created_at updated_at

* id group_name permission

* id holiday_name holiday_date holiday_type created_at

* id employee_id cutoff_id schedule_id scheduled_start_at scheduled_end_at required_work_minutes break_minutes grace_period_minutes attendance_date time_in time_in_device_time time_in_server_time time_in_time_difference_seconds time_in_flagged_time_mismatch time_in_face_distance time_in_face_confidence time_in_face_source time_out time_out_device_time time_out_server_time time_out_time_difference_seconds time_out_flagged_time_mismatch time_out_face_distance time_out_face_confidence time_out_face_source latitude longitude photo time_in_latitude time_in_longitude time_in_photo time_out_latitude time_out_longitude time_out_photo hours_worked late_minutes undertime_minutes regular_work_minutes auto_overtime_hours rest_day_work rest_day_validated schedule_snapshot_json manual_overtime_hours manual_overtime_override status created_at updated_at

* id attendance_id employee_id attendance_date old_time_in old_time_out new_time_in new_time_out old_hours_worked new_hours_worked edited_by ip_address user_agent edit_reason created_at

* id employee_id action_key source device_time_raw device_time server_time time_difference_seconds threshold_seconds flagged_time_mismatch blocked warning_message ip_address user_agent extra_json created_at

* id employee_id checklist_type title status completion_percent created_by created_at updated_at

* id checklist_id item_label assigned_to due_date status remarks attachment completed_by completed_at created_at updated_at

* id employee_code bank_account_no bank_account_name payroll_account_status bank_name first_name middle_name last_name suffix nickname position job_title branch_location department payroll_type shift_id rest_day daily_rate salary_type monthly_salary hourly_rate date_hired date_regularized contract_start_date contract_end_date probationary_end_date supervisor_id birthdate gender civil_status nationality religion contact_no personal_email emergency_contact_name emergency_contact_no emergency_relationship emergency_contact_address address sss_no philhealth_no pagibig_no tin_no bir_tax_status rdo_code status employment_status active_flag face_image employee_photo face_descriptor created_at updated_at

* id employee_id cutoff_id week_start week_end days_worked paid_leave_days lwop_days regular_holiday_worked special_holiday_worked rate_per_day rate_per_min late_ut_minutes total_tardy basic_pay gross_pay holiday_pay leave_pay overtime_pay total_gp cash_advance sss_employee philhealth_employee pagibig_employee withholding_tax statutory_total taxable_income formula_version payroll_breakdown_json remarks benefits deductions net_pay adjustment total_net created_at updated_at regular_overtime_hours regular_overtime_pay holiday_overtime_hours holiday_overtime_pay approved_ot_hours rest_day_hours rest_day_pay night_diff_hours night_diff_pay ob_hours

* id week_start week_end payroll_type status reviewed_by reviewed_at approved_by approved_at released_by released_at locked_by locked_at is_finalized is_locked finalized_by finalized_at note created_by created_at updated_at

* id batch_id week_start week_end from_status to_status action_by note created_at

* id work_schedule_id shift_code shift_name schedule_type start_time end_time break_minutes paid_hours late_grace_minutes is_active remarks created_at updated_at

* id effective_start effective_end monthly_salary_from monthly_salary_to employee_rate max_employee_contribution notes created_at

* id effective_start effective_end premium_rate monthly_salary_floor monthly_salary_ceiling employee_share_ratio notes created_at

* id effective_start effective_end monthly_salary_from monthly_salary_to employee_share employer_share ec_share notes created_at

* id effective_start effective_end annual_taxable_from annual_taxable_to base_tax over_percent notes created_at

* id payout_year status note generated_by generated_at released_by released_at created_at updated_at

* id batch_id employee_id payout_year coverage_start coverage_end payroll_rows_count qualifying_days basic_salary_base thirteenth_month_pay taxable_excess withholding_tax net_amount remarks created_at updated_at

* id employee_id leave_type_id year allocated_days used_days created_at updated_at

* id employee_id leave_type_id start_date end_date total_days reason attachment status approved_by approved_date remarks balance_applied created_at

* id leave_request_id action from_status to_status acted_by remarks ip_address user_agent created_at

* id leave_name description is_paid default_days

* id module record_id action old_value new_value remarks created_by created_at

* id invoice_no client_id shipment_id dispatch_id billing_type income_amount expense_amount billing_status due_date notes posted_to_accounting accounting_reference created_by updated_by created_at updated_at

* id client_code company_name contact_person contact_number email address status created_by updated_by created_at updated_at

* id batch_no batch_name status dispatch_ref_no remarks created_by updated_by created_at updated_at

* id batch_id shipment_id created_at

* id shipment_id customs_status document_checklist remarks created_by updated_by created_at updated_at

* id clearance_id shipment_id old_status new_status remarks updated_by created_at

* id dispatch_no batch_id shipment_id delivery_schedule truck_id driver_employee_id pickup_location delivery_address delivery_status proof_of_delivery delivery_photo signature_image remarks created_by updated_by created_at updated_at

* id shipment_ref_no client_id transaction_type container_no bl_awb_no cargo_description quantity weight_kg cbm date_received warehouse_location current_status remarks created_by updated_by created_at updated_at

* id shipment_id movement_type from_location to_location status_from status_to remarks moved_by created_at

* id user_id employee_id expo_push_token platform device_name app_mode is_active last_seen_at created_at updated_at

* id employee_id trigger_type resignation_date last_working_day reason final_pay_request_status status created_by created_at updated_at

* id employee_id ob_date start_time end_time location client_company purpose attachment credited_hours status supervisor_by supervisor_at approved_by approved_at remarks created_by created_at updated_at

* id bill_no company_name customer_name customer_address customer_phone delivery_date delivery_type date_time gross_amount service_charge_rate service_charge vat_charge_rate vat_charge tax_inclusive tax_exclusive net_amount deliveryfee discount paid_status return_note payment_proof modeofpayment record_type approval_status approved_at approved_by source_quotation_id quotation_valid_until user_id created_at

* id order_id product_id product_name qty rate amount

* id allocation_no order_id truck_id scheduled_date route_sequence payment_mode cash_to_collect pickup_location dropoff_location trip_type route_profile estimated_one_way_distance_km estimated_total_distance_km estimated_cargo_weight_kg load_utilization_percent truck_km_per_liter recommended_km_per_liter diesel_price_per_liter cost_per_km estimated_fuel_liters estimated_fuel_cost actual_start_odometer actual_end_odometer actual_distance_km actual_fuel_liters actual_km_per_liter actual_fuel_cost fuel_variance distance_variance status notes cancel_reason canceled_at canceled_by proof_path user_id created_at

* id order_delivery_id expense_name amount created_at

* id order_delivery_id order_item_id product_id qty_allocated

* id order_delivery_id order_delivery_item_id product_id qty_returned reason returned_by returned_at

* id order_delivery_id stop_no stop_name created_at

* id order_delivery_id from_status to_status note changed_by changed_at

* id employee_id ot_date start_time end_time reason attachment requested_hours approved_hours payable_hours is_pre_shift status supervisor_by supervisor_at approved_by approved_at remarks created_by created_at updated_at

* id supplier_name reference_no delivery_id due_date amount balance status notes created_by updated_by created_at updated_at

* id payment_no payment_date direction payer_type payer_name reference_type reference_id cash_account_id counter_account_id amount payment_method reference_no notes transaction_id created_by updated_by created_at updated_at

* id cutoff_id record_type record_id action user_id details_json created_at

* id payroll_id cutoff_id employee_id adjustment_type amount reason status created_by approved_by approved_at created_at updated_at

* id payroll_id detail_type label quantity rate amount metadata_json created_at

* id cutoff_id employee_id daily_rate paid_days late_undertime_deduction overtime allowance incentive deduction remarks encoded_by created_at updated_at

* id setting_key setting_value value_type effective_start effective_end description updated_by created_at updated_at

* id cutoff_id employee_id raw_name corrected_name position truck_number container_number area_destination rate entry_type remarks encoded_by created_at updated_at

* id destination_area truck_type km customer standard_trip_rate driver_rate_type driver_rate_value helper_rate_type helper_rate_value checker_rate_type checker_rate_value food_allowance toll_other_expense status created_at updated_at

* id payroll_id employee_id cutoff_id token_hash generated_by generated_at viewed_at status

* id employee_id evaluation_type period_start period_end evaluator_id final_score comments strengths areas_for_improvement recommendation attachment status created_at updated_at

* id name sku price qty image description attribute_value_id brand_id category_id store_id availability kilogram unit_item dealerprice pricing_type dealer_price_per_kg

* id product_id user_id before_data after_data created_at action reference qty_change

* id employee_id field_name old_value new_value proof_attachment reason status created_by reviewed_by reviewed_at remarks created_at updated_at

* id customer_name reference_no order_id due_date amount balance status notes created_by updated_by created_at updated_at

* id applicant_code first_name middle_name last_name suffix birthdate gender civil_status contact_number email address position_id preferred_company expected_salary availability_date employment_history educational_background skills certifications driver_license_details work_experience referral_source remarks status consent_accepted consent_accepted_at consent_ip consent_version converted_employee_id created_at updated_at

* id applicant_id document_type title original_filename stored_filename file_path file_extension mime_type file_size status uploaded_by created_at updated_at

* id applicant_id interview_session_id consent_type consent_version consent_text ip_address user_agent accepted_at

* id applicant_id email_type recipient_email subject body_snapshot status error_message sent_by sent_at created_at

* id template_name stage subject body status created_by updated_by created_at updated_at

* id applicant_id interview_date interview_time interview_type location_or_link interviewer_id remarks status created_by created_at updated_at

* id interview_session_id applicant_id question_id event_type event_time duration_seconds metadata ip_address user_agent created_at

* id interview_session_id applicant_id tab_switch_count total_away_seconds fullscreen_exit_count copy_attempt_count right_click_attempt_count suspicious_key_count device_interruption_count duplicate_session_count early_stop_count too_short_answer_count failed_upload_count invalid_step_count no_face_count multiple_face_count risk_score risk_level hr_review_status hr_integrity_remarks first_ip_address last_ip_address first_user_agent last_user_agent browser_name operating_system device_type screen_size timezone started_at completed_at created_at updated_at

* id interview_session_id applicant_id current_question_id current_question_order completed_questions_count status current_step current_question_started_at recording_state last_activity_at updated_at

* id applicant_id position_id token token_expires_at status expires_at allow_retake retakes_allowed allow_preview require_all_questions consent_accepted consent_accepted_at consent_ip consent_user_agent applicant_agreed_interview_rules rules_agreed_at rules_agreed_ip rules_agreed_user_agent first_client_id active_client_id active_client_seen_at last_device_info created_by started_at completed_at created_at updated_at

* id applicant_id token_id action reviewer_name rating remarks recommendation ip_address user_agent created_at

* id applicant_id token expires_at status allow_rating allow_remarks show_question_videos show_applicant_details show_documents created_by revoked_by revoked_at created_at updated_at

* id position_title company department job_description qualifications requirements employment_type vacancy_count status created_by created_at updated_at

* id position_id company question_text question_type question_mode question_video_path question_video_original_filename question_video_stored_filename question_video_mime_type question_video_size question_video_duration_seconds show_text_overlay text_overlay_position answer_time_limit_seconds allow_replay max_replay_count require_full_watch_before_answer allow_answer_retake max_answer_retake_count time_limit_seconds sort_order is_required status created_by updated_by created_at updated_at

* id question_id question_video_path question_video_original_filename question_video_stored_filename question_video_mime_type question_video_size question_video_duration_seconds replaced_by replaced_at

* id interview_session_id applicant_id question_id viewed_at completed_full_watch replay_count ip_address user_agent created_at

* id applicant_id reviewer_id technical_rating communication_rating experience_rating professionalism_rating overall_rating recommendation remarks created_at updated_at

* id review_id applicant_id interview_session_id reviewer_id question_id rating remarks pass_fail_status created_at updated_at

* id setting_key setting_value value_type description updated_by created_at updated_at

* id applicant_id old_status new_status changed_by remarks created_at

* id interview_session_id applicant_id question_id question_shown_at question_video_started_at question_video_ended_at countdown_started_at recording_started_at recording_ended_at auto_started_recording recording_stop_reason upload_started_at upload_completed_at uploaded_at is_early_submitted confirmed_short_answer answer_video_path answer_video_original_filename answer_video_stored_filename answer_video_mime_type answer_video_size answer_duration_seconds retake_count video_file_path video_filename video_size mime_type duration_seconds attempt_no recorded_at submitted_at upload_status status created_at updated_at

* id employee_id scope_type scope_value old_schedule_id new_schedule_id effective_date changed_by reason created_at

* id scope_type scope_value schedule_id effective_date end_date assigned_by remarks status created_at updated_at

* id product_id old_qty new_qty difference reason user_id created_at

* id name active

* id setting_key setting_value value_type description updated_by created_at updated_at

* id transaction_id account_id line_type amount memo created_at

* id name plate_no capacity_kg capacity_cbm gps_device_id active created_at

* id truck_id latitude longitude speed_kph captured_at source created_at

* id username password must_change_password email employee_id firstname lastname phone gender

* id user_id group_id

* id user_id type title message link_url payload_json is_read created_at read_at

* id product_id product_name client_name company_name email phone subject message source_page ip_address user_agent status created_at updated_at

* id schedule_code schedule_name schedule_type start_time end_time break_minutes required_work_minutes grace_period_minutes is_overnight effective_date status remarks legacy_shift_id created_by updated_by created_at updated_at

* id schedule_id day_of_week is_working_day is_rest_day

select table accounting_transactions accounts api_mobile_tokens app_rate_limits assets asset_accountability_forms asset_accountability_form_items asset_assignments asset_audit_logs asset_categories asset_label_print_logs asset_label_templates asset_maintenance_logs asset_print_logs asset_transfers attendance_corrections attributes attribute_value audit_logs auth_access_logs brands categories clearance_items company deliveries delivery_items departments disciplinary_cases document_approvals document_approval_logs document_approval_remarks document_approval_signatures document_approval_steps document_approval_versions document_department_users document_types document_workflows document_workflow_steps employee_201_files employee_aliases employee_certifications employee_documents employee_document_access_logs employee_document_types employee_document_versions employee_education employee_employment_history employee_family_dependents employee_medical_records employee_movements employee_onboarding_items employee_schedule_assignments expenses groups holidays hr_attendance hr_attendance_edit_logs hr_attendance_time_security_logs hr_checklists hr_checklist_items hr_employees hr_payrolls hr_payroll_batches hr_payroll_batch_logs hr_shifts hr_statutory_pagibig hr_statutory_philhealth hr_statutory_sss hr_statutory_withholding hr_thirteenth_month_batches hr_thirteenth_month_rows leave_balances leave_requests leave_request_audit_logs leave_types logistics_audit_logs logistics_billing logistics_clients logistics_consolidation_batches logistics_consolidation_items logistics_customs_clearances logistics_customs_logs logistics_dispatches logistics_shipments logistics_warehouse_movements mobile_push_tokens offboarding_records official_business_requests orders orders_item order_deliveries order_delivery_expenses order_delivery_items order_delivery_item_returns order_delivery_itinerary order_delivery_status_logs overtime_requests payables payments payroll_activity_logs payroll_adjustments payroll_details payroll_office_entries payroll_settings payroll_trip_entries payroll_trip_rates payslips performance_evaluations products product_history profile_update_requests receivables recruitment_applicants recruitment_applicant_documents recruitment_consent_logs recruitment_email_logs recruitment_email_templates recruitment_final_interviews recruitment_interview_event_logs recruitment_interview_integrity_summary recruitment_interview_progress recruitment_interview_sessions recruitment_management_review_logs recruitment_management_review_tokens recruitment_positions recruitment_questions recruitment_question_video_versions recruitment_question_view_logs recruitment_reviews recruitment_review_scores recruitment_settings recruitment_status_logs recruitment_video_answers schedule_change_logs schedule_scope_assignments stock_adjustments stores system_settings transaction_lines trucks truck_locations users user_group user_notifications website_inquiries work_schedules work_schedule_days . 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 accounting_transactions accounts api_mobile_tokens app_rate_limits assets asset_accountability_forms asset_accountability_form_items asset_assignments asset_audit_logs asset_categories asset_label_print_logs asset_label_templates asset_maintenance_logs asset_print_logs asset_transfers attendance_corrections attributes attribute_value audit_logs auth_access_logs brands categories clearance_items company deliveries delivery_items departments disciplinary_cases document_approvals document_approval_logs document_approval_remarks document_approval_signatures document_approval_steps document_approval_versions document_department_users document_types document_workflows document_workflow_steps employee_201_files employee_aliases employee_certifications employee_documents employee_document_access_logs employee_document_types employee_document_versions employee_education employee_employment_history employee_family_dependents employee_medical_records employee_movements employee_onboarding_items employee_schedule_assignments expenses groups holidays hr_attendance hr_attendance_edit_logs hr_attendance_time_security_logs hr_checklists hr_checklist_items hr_employees hr_payrolls hr_payroll_batches hr_payroll_batch_logs hr_shifts hr_statutory_pagibig hr_statutory_philhealth hr_statutory_sss hr_statutory_withholding hr_thirteenth_month_batches hr_thirteenth_month_rows leave_balances leave_requests leave_request_audit_logs leave_types logistics_audit_logs logistics_billing logistics_clients logistics_consolidation_batches logistics_consolidation_items logistics_customs_clearances logistics_customs_logs logistics_dispatches logistics_shipments logistics_warehouse_movements mobile_push_tokens offboarding_records official_business_requests orders orders_item order_deliveries order_delivery_expenses order_delivery_items order_delivery_item_returns order_delivery_itinerary order_delivery_status_logs overtime_requests payables payments payroll_activity_logs payroll_adjustments payroll_details payroll_office_entries payroll_settings payroll_trip_entries payroll_trip_rates payslips performance_evaluations products product_history profile_update_requests receivables recruitment_applicants recruitment_applicant_documents recruitment_consent_logs recruitment_email_logs recruitment_email_templates recruitment_final_interviews recruitment_interview_event_logs recruitment_interview_integrity_summary recruitment_interview_progress recruitment_interview_sessions recruitment_management_review_logs recruitment_management_review_tokens recruitment_positions recruitment_questions recruitment_question_video_versions recruitment_question_view_logs recruitment_reviews recruitment_review_scores recruitment_settings recruitment_status_logs recruitment_video_answers schedule_change_logs schedule_scope_assignments stock_adjustments stores system_settings transaction_lines trucks truck_locations users user_group user_notifications website_inquiries work_schedules work_schedule_days .	select column