* id tenant_id name description created_at updated_at

* id tenant_id chart_of_account_id period opening_balance total_debit total_credit closing_balance created_at updated_at

* id is_active name created_at updated_at

* id tenant_id user_name module type payload created_at updated_at

* key value expiration

* key owner expiration

* id tenant_id chart_of_account_id payment_number payment_date description amount created_at updated_at

* id tenant_id cash_bank_payment_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id cash_bank_payment_id chart_of_account_id amount note created_at updated_at

* id tenant_id chart_of_account_id receipt_number receipt_date description amount created_at updated_at

* id tenant_id cash_bank_receipt_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id cash_bank_receipt_id chart_of_account_id amount note created_at updated_at

* id tenant_id is_active parent_id account_type account_code account_name description created_at updated_at

* id tenant_id chart_of_account_id company_name short_name company_tax_id company_phone company_email signatory_name company_address company_logo created_at updated_at

* id tenant_id is_active customer_code customer_name tax_id address province sales_price_level created_at updated_at

* id uuid connection queue payload exception failed_at

* id tenant_id entry_number entry_date description total_debit total_credit created_at updated_at

* id tenant_id general_journal_entry_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id general_journal_entry_id chart_of_account_id debit credit note created_at updated_at

* id tenant_id is_active item_code item_name inventory_type description average_cost sales_price_level_1 sales_price_level_2 sales_price_level_3 sales_price_level_4 sales_price_level_5 sales_price_level_6 sales_price_level_7 sales_price_level_8 sales_price_level_9 sales_price_level_10 sales_price_level_11 sales_price_level_12 sales_price_level_13 sales_price_level_14 sales_price_level_15 sales_price_level_16 sales_price_level_17 sales_price_level_18 sales_price_level_19 sales_price_level_20 created_at updated_at cogs_account_id revenue_account_id sales_return_account_id inventory_account_id sales_discount_account_id goods_sent_account_id purchase_return_account_id unbilled_account_id

* id tenant_id warehouse_id warehouse_rack_id item_id balance_qty balance_value created_at updated_at

* id queue payload attempts reserved_at available_at created_at

* id name total_jobs pending_jobs failed_jobs failed_job_ids options cancelled_at created_at finished_at

* id tenant_id chart_of_account_id source_id transaction_date reference_number source_type amount mutation_type description created_at updated_at

* id tenant_id menu_name route type parent_id sort_order icon is_active created_at updated_at

* id migration batch

* id tenant_id prefix period last_number

* email token created_at

* id tenant_id supplier_id purchase_receipt_id account_payable_id invoice_number invoice_date description vat_amount shipping_cost paid_amount process_status created_by updated_by grand_total due_date order_date created_at updated_at

* id tenant_id purchase_invoice_id purchase_receipt_detail_id item_id item_code item_name quantity item_price discount_amount subtotal note created_at updated_at

* id tenant_id supplier_id purchase_request_id customer_id discount_account_id vat_account_id shipping_cost_account_id warehouse_id created_by updated_by order_number due_days order_date is_vat_applied vat_amount shipping_cost discount_percent discount_amount subtotal_before_discount subtotal_after_discount grand_total description process_status created_at updated_at

* id tenant_id purchase_order_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id purchase_order_id item_id quantity received_quantity item_price discount_percent discount_amount subtotal note created_at updated_at

* id tenant_id supplier_id bank_account_id created_by updated_by payment_number payment_date paid_amount description account_payable_id created_at updated_at

* id tenant_id purchase_payment_id purchase_invoice_id paid_amount created_at updated_at

* id tenant_id receipt_number receipt_date supplier_id warehouse_id warehouse_rack_id purchase_order_id status notes subtotal grand_total created_at updated_at

* id tenant_id purchase_receipt_id purchase_order_detail_id item_id item_code item_name qty unit_price line_total note created_at updated_at

* id tenant_id request_number request_date needed_date supplier_id status previous_status_before_processed notes subtotal grand_total created_at updated_at

* id tenant_id purchase_request_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id purchase_request_id item_id item_code item_name qty unit_price discount_amount line_total note created_at updated_at

* id tenant_id supplier_id purchase_invoice_id account_payable_id return_number return_date status description grand_total created_by updated_by created_at updated_at

* id tenant_id purchase_return_id purchase_invoice_detail_id item_id item_code item_name qty unit_price line_total note created_at updated_at

* id tenant_id name description is_active created_at updated_at

* role_id ability_id created_at updated_at

* id tenant_id delivery_number delivery_date customer_id warehouse_id warehouse_rack_id sales_order_id sales_quotation_id status notes subtotal grand_total created_at updated_at

* id tenant_id sales_delivery_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id sales_delivery_id item_id item_code item_name qty unit_price line_total note created_at updated_at

* id tenant_id customer_id warehouse_id warehouse_rack_id sales_order_id sales_delivery_id vat_rate_id account_receivable_id invoice_number invoice_date description vat_percent vat_amount discount_percent discount_amount grand_total paid_amount process_status created_by updated_by created_at updated_at

* id tenant_id sales_invoice_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id sales_invoice_id item_id item_code item_name quantity price discount_percent discount_amount subtotal note created_at updated_at

* id tenant_id order_number order_date customer_id sales_quotation_id vat_rate_id status previous_status_before_processed notes subtotal vat_percent vat_amount grand_total created_at updated_at

* id tenant_id sales_order_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id sales_order_id item_id item_code item_name qty unit_price discount_percent discount_amount line_total note created_at updated_at

* id tenant_id quotation_number quotation_date valid_until customer_id vat_rate_id status previous_status_before_processed notes subtotal vat_percent vat_amount grand_total created_at updated_at

* id tenant_id sales_quotation_id original_name file_path mime_type file_size created_at updated_at

* id tenant_id sales_quotation_id item_id item_code item_name qty unit_price discount_percent discount_amount line_total note created_at updated_at

* id tenant_id created_by updated_by customer_id bank_account_id receipt_number receipt_date paid_amount description account_receivable_id created_at updated_at

* id tenant_id sales_receipt_id sales_invoice_id paid_amount created_at updated_at

* id tenant_id return_number return_date customer_id warehouse_id warehouse_rack_id sales_invoice_id status notes subtotal grand_total created_at updated_at

* id tenant_id sales_return_id item_id item_code item_name qty unit_price line_total note created_at updated_at

* id user_id ip_address user_agent payload last_activity

* id tenant_id warehouse_id warehouse_rack_id item_id transaction_date reference_number source_type source_id mutation_type direction quantity unit_cost total_cost description created_at updated_at

* id tenant_id transfer_number transfer_date from_warehouse_id to_warehouse_id status notes created_at updated_at

* id tenant_id stock_transfer_id item_id from_warehouse_rack_id to_warehouse_rack_id item_code item_name qty unit_cost total_cost note created_at updated_at

* id tenant_id is_active supplier_code supplier_name supplier_email supplier_address created_at updated_at

* id name slug is_active created_at updated_at

* tenant_id user_id role is_owner created_at updated_at

* tenant_id user_id role_id created_at updated_at

* id active_tenant_id locale name email email_verified_at password remember_token profile_photo created_at updated_at

* id tenant_id name rate is_active created_at updated_at

* id tenant_id is_active warehouse_code warehouse_name description created_at updated_at

* id tenant_id warehouse_id rack_code rack_name description is_active created_at updated_at

select table abilities account_balances account_types activity_logs cache cache_locks cash_bank_payments cash_bank_payment_attachments cash_bank_payment_details cash_bank_receipts cash_bank_receipt_attachments cash_bank_receipt_details chart_of_accounts company_preferences customers failed_jobs general_journal_entries general_journal_entry_attachments general_journal_entry_details items item_stock_balances jobs job_batches ledger_entries menus migrations number_sequences password_reset_tokens purchase_invoices purchase_invoice_details purchase_orders purchase_order_attachments purchase_order_details purchase_payments purchase_payment_details purchase_receipts purchase_receipt_details purchase_requests purchase_request_attachments purchase_request_details purchase_returns purchase_return_details roles role_ability sales_deliveries sales_delivery_attachments sales_delivery_details sales_invoices sales_invoice_attachments sales_invoice_details sales_orders sales_order_attachments sales_order_details sales_quotations sales_quotation_attachments sales_quotation_details sales_receipts sales_receipt_details sales_returns sales_return_details sessions stock_mutations stock_transfers stock_transfer_details suppliers tenants tenant_user tenant_user_roles users vat_rates warehouses warehouse_racks . 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 abilities account_balances account_types activity_logs cache cache_locks cash_bank_payments cash_bank_payment_attachments cash_bank_payment_details cash_bank_receipts cash_bank_receipt_attachments cash_bank_receipt_details chart_of_accounts company_preferences customers failed_jobs general_journal_entries general_journal_entry_attachments general_journal_entry_details items item_stock_balances jobs job_batches ledger_entries menus migrations number_sequences password_reset_tokens purchase_invoices purchase_invoice_details purchase_orders purchase_order_attachments purchase_order_details purchase_payments purchase_payment_details purchase_receipts purchase_receipt_details purchase_requests purchase_request_attachments purchase_request_details purchase_returns purchase_return_details roles role_ability sales_deliveries sales_delivery_attachments sales_delivery_details sales_invoices sales_invoice_attachments sales_invoice_details sales_orders sales_order_attachments sales_order_details sales_quotations sales_quotation_attachments sales_quotation_details sales_receipts sales_receipt_details sales_returns sales_return_details sessions stock_mutations stock_transfers stock_transfer_details suppliers tenants tenant_user tenant_user_roles users vat_rates warehouses warehouse_racks .	select column