* id user_id opening_balance opening_time closing_time status expected_closing_balance actual_closing_balance difference note

* id name icon sort_order exclude_from_commission

* id name phone address created_at

* id beneficiary reason user_id created_at

* id courtesy_id product_id quantity

* id name note last_updated_by updated_at created_at

* id order_id product_name quantity motive user_id deleted_at

* id comuna name price active

* id document_type order_id customer_name customer_identification customer_email alegra_id status pdf_url xml_url cufe qr_code created_at dian_message consecutive_number payload

* id name document_id phone position salary_base active created_at

* id user_id cash_session_id amount description category created_at employee_id order_id expense_type supplier_id

* id name unit stock cost_price

* id item_type item_id quantity action notes created_at user_id previous_stock new_stock

* id item_name stock created_at updated_at

* id item_id type quantity user_id created_at

* id table_id user_id client_id total status payment_method payment_detail amount_paid change_amount order_type delivery_fee client_name client_phone client_address created_at updated_at cash_session_id external_id is_hotel deduct_delivery tip_amount tip_percentage

* id order_id product_id quantity price subtotal notes selections printed cost_price

* id name ip port type active created_at order_types categories connection_type paper_size

* id printer_id ticket_content status created_at

* id category_id name description price image is_composite stock max_selections qty_per_selection is_deleted cost_price show_in_public

* id product_id name

* product_id ingredient_id quantity

* id name identification_type identification dv address city_code email regime created_at

* setting_key setting_value

* id table_number status waiter_id

* id username password full_name role ip_address created_at permissions active

* variant_id ingredient_id quantity

* id user_id product_id quantity price session_id original_order_id status created_at

select table cash_sessions categories clients courtesies courtesy_items daily_supplies deleted_items_history delivery_zones electronic_invoices employees expenses ingredients inventory_logs manual_inventory manual_inventory_log orders order_items printers print_jobs products product_variants recipes suppliers system_settings tables users variant_recipes wrong_products . 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 cash_sessions categories clients courtesies courtesy_items daily_supplies deleted_items_history delivery_zones electronic_invoices employees expenses ingredients inventory_logs manual_inventory manual_inventory_log orders order_items printers print_jobs products product_variants recipes suppliers system_settings tables users variant_recipes wrong_products .	select column