* id alert_type entity_id message is_resolved created_at

* party_id customer_name invoice_number total_amount paid_amount balance due_date status aging_bucket

* product_name variant_name warehouse_name batch_number quantity reorder_point

* warehouse_name sku product_name variant_name batch_number quantity expiry_date costing_method stock_value

* id user_id action entity_type entity_id old_values new_values ip_address user_agent created_at

* id batch_number product_id variant_id warehouse_id location_id purchase_price currency_code quantity manufacturing_date expiry_date costing_method created_at updated_at

* code symbol name is_base_currency created_at

* id from_currency to_currency rate effective_date created_at

* id transaction_type product_id variant_id batch_id warehouse_id from_warehouse_id to_warehouse_id quantity_change reference_type reference_id notes created_at

* id invoice_number sales_order_id party_id currency_code total_amount paid_amount status issued_at due_date created_at

* id name is_rtl created_at

* party_id party_name outstanding_amount bucket_30 bucket_60 bucket_90_plus last_refresh

* warehouse_id product_id variant_id batch_id quantity unit_cost total_value costing_method last_refresh

* id party_type code name email phone credit_limit currency_code balance created_at updated_at

* id party_id address_type address_line1 address_line2 city state postal_code country is_default created_at

* id resource action description created_at

* id sku upc name description base_currency base_cost base_price reorder_point reorder_quantity created_at updated_at

* id product_id variant_name sku upc base_cost base_price created_at

* id po_number supplier_id warehouse_id currency_code status total_amount created_at received_at

* id purchase_order_id product_id variant_id expected_quantity received_quantity unit_cost line_total created_at

* id name description created_at

* role_id permission_id

* id order_number party_id warehouse_id currency_code status total_amount created_at confirmed_at shipped_at delivered_at

* id sales_order_id product_id variant_id batch_id quantity unit_price line_total created_at

* id supplier_id amount currency_code payment_method reference applied_to_po_ids paid_at

* id language_id entity_type entity_id field_name translated_text created_at updated_at

* id username email password_hash first_name last_name is_active last_login created_at updated_at

* user_id role_id

* id name code address_id is_active created_at

* id warehouse_id location_code description created_at

select table alert_log api_customer_statements api_low_stock_alerts api_stock_status audit_log batches currencies exchange_rate_history inventory_transactions invoices languages mv_customer_aging mv_inventory_valuation parties party_addresses permissions products product_variants purchase_orders purchase_order_lines roles role_permissions sales_orders sales_order_lines supplier_payments translations users user_roles warehouses warehouse_locations . 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 alert_log api_customer_statements api_low_stock_alerts api_stock_status audit_log batches currencies exchange_rate_history inventory_transactions invoices languages mv_customer_aging mv_inventory_valuation parties party_addresses permissions products product_variants purchase_orders purchase_order_lines roles role_permissions sales_orders sales_order_lines supplier_payments translations users user_roles warehouses warehouse_locations .	select column