* id user_id period_year period_month amount expense_id branch_id created_at

* id name code address is_active created_at updated_at

* id customer_payment_id invoice_id invoice_number amount_paid remaining_before created_at

* id branch_id document_type file_url label created_at

* id company_name tagline address phone email logo_url created_at updated_at trn no_trn vehicle_inspection_enabled branch_id signature_terms_and_conditions logo_pdf_scale

* id user_id first_name last_name display_name gender mobile_number email password_hash date_of_birth image_url address total_spent last_visit created_at updated_at is_b2b company_name trn_number credit_terms special_discount contact_person

* id invoice_id job_card_id customer_id invoice_number customer_name customer_phone vehicle_license_plate amount payment_method payment_date advance_applied invoice_subtotal invoice_tax invoice_total invoice_remaining_before invoice_remaining_after notes created_at payment_type branch_id is_bulk_payment

* id description amount tax total_amount quantity unit_price category payment_method payment_date status vendor invoice_number notes trn approved_by created_at source_type source_id branch_id

* id branch_id code display_name sort_order created_at

* id branch_id name category description manufacturer model serial_number asset_tag status location acquired_date acquired_cost last_inspection_date next_inspection_due notes created_at updated_at

* id customer_name invoice_number amount payment_method payment_date status category description received_by created_at source customer_payment_id branch_id

* id branch_id code display_name sort_order created_at

* id branch_id name supplier_id product_id package_quantity buying_price created_at updated_at

* id proforma_invoice_id job_card_id customer_id quotation_id invoice_number subtotal tax total_amount advance_amount remaining_amount status due_date paid_date payment_method notes customer_name customer_email customer_phone vehicle_brand vehicle_name vehicle_year vehicle_license_plate vin_number created_at updated_at branch_id sales_vat_exempt discount

* id invoice_id description quantity unit_price total cost_price vendor_name vat_for_expense proforma_invoice_item_id type supplier_id product_id stock_deducted created_at discount

* id job_card_number quotation_id customer_id vehicle_id assigned_to status priority start_date completion_date actual_labor_hours notes subtotal tax total_amount created_at updated_at advance_amount vehicle_inspection_report_id branch_id sales_vat_exempt discount lpo_number vehicle_km

* id job_card_id user_id expected_labour_hours labour_hours created_at

* id job_card_id before_file_path after_file_path description sort_order created_at

* id job_card_id description amount_aed payment_method vat_applied created_at expense_type supplier_id product_id quantity unit_price cost_price vendor_name

* id job_card_id description quantity unit_price total cost_price vendor_name vat_for_expense type supplier_id product_id created_at is_done discount

* id job_card_id file_path caption type created_at

* id job_card_id signature_data_url signed_at created_at

* id job_card_id token expires_at signed_at signature_data_url created_at

* id job_card_id description completed sort_order created_at

* id supplier_id name description sku category unit_price cost_price stock_quantity min_stock_level max_stock_level unit status created_at updated_at

* id product_id branch_id quantity updated_at

* id product_id branch_id quantity unit_price vat_applied created_at

* id job_card_id customer_id quotation_id proforma_number subtotal tax total_amount advance_amount remaining_amount status notes created_at updated_at branch_id sales_vat_exempt discount

* id proforma_invoice_id description quantity unit_price total cost_price vendor_name vat_for_expense type supplier_id product_id created_at discount

* id quotation_number customer_id vehicle_id customer_name vehicle_info subtotal tax total_amount remaining_amount status valid_until notes created_at updated_at branch_id sales_vat_exempt discount vehicle_inspection_report_id

* id quotation_id description quantity unit_price total cost_price vendor_name vat_for_expense type supplier_id product_id created_at discount

* id user_id period_year period_month base_amount overtime_amount adjustment_amount bonus_amount advance_amount total_amount expense_id created_at branch_id

* user_id base_salary overtime_threshold_hours overtime_rate_per_hour created_at updated_at branch_id

* id product_id type quantity reference_type reference_id reference_display created_at branch_id

* id vendor_name supplier_id payment_date trn payment_method payment_status invoice_number notes total_amount paid_amount item_count status created_at description expense_id branch_id job_card_id

* id batch_id product_id product_name quantity buying_price amount vat_applied created_at

* id name email phone address rating products_count total_orders status category created_at updated_at display_name trn work_phone mobile address_line_1 bank_name account_number iban swift_code branch

* id purchase_id supplier_id vendor_name amount payment_method payment_date is_advance purchase_total purchase_remaining_before purchase_remaining_after notes created_at

* id email password_hash name role branch_id phone address emirates_id_file_path passport_file_path created_at updated_at

* id user_id branch_id created_at

* id vehicle_id customer_id brand name license_plate vin_number year color odometer_reading last_service_date next_service_date status fuel_type engine_size transmission images created_at updated_at insurance_start_date insurance_expiry_date mulkiya_start_date mulkiya_expiry_date traffic_plate_number

* id name description logo_url created_at updated_at

* id vehicle_id type file_path name created_at

* id report_id item_code item_name ok scratch rust dent sat_pickup unsat_pickup sat_turnin unsat_turnin remarks

* id report_id mark_type x_pct y_pct car_view created_at

* id report_id file_path sort_order caption created_at

* id job_card_id quotation_id vehicle_id customer_id branch_id status mileage_out mileage_in mileage inspector_name inspection_date remarks created_at updated_at

* id brand_id name description category created_at updated_at

select table advance_salary branches bulk_payment_invoices company_documents company_settings customers customer_payments expenses expense_categories garage_tools income income_categories inventory_packages invoices invoice_items job_cards job_card_assignments job_card_before_after job_card_hidden_expenses job_card_items job_card_photos job_card_signatures job_card_signature_links job_card_tasks products product_branch_stock product_stock_layers proforma_invoices proforma_invoice_items quotations quotation_items salary_records salary_settings stock_changes stock_topup_batches stock_topup_batch_items suppliers supplier_payments users user_branches vehicles vehicle_brands vehicle_documents vehicle_inspection_checklist vehicle_inspection_damage_marks vehicle_inspection_photos vehicle_inspection_reports vehicle_names . 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 advance_salary branches bulk_payment_invoices company_documents company_settings customers customer_payments expenses expense_categories garage_tools income income_categories inventory_packages invoices invoice_items job_cards job_card_assignments job_card_before_after job_card_hidden_expenses job_card_items job_card_photos job_card_signatures job_card_signature_links job_card_tasks products product_branch_stock product_stock_layers proforma_invoices proforma_invoice_items quotations quotation_items salary_records salary_settings stock_changes stock_topup_batches stock_topup_batch_items suppliers supplier_payments users user_branches vehicles vehicle_brands vehicle_documents vehicle_inspection_checklist vehicle_inspection_damage_marks vehicle_inspection_photos vehicle_inspection_reports vehicle_names .	select column