Recent
`sistem`.`chart_of_accounts`
`information_schema`.`ALL_PLUGINS`
`information_schema`.`ROUTINES`
`sistem`.`tenant_user`
`information_schema`.`PLUGINS`
`information_schema`.`PROFILING`
`mysql`.`columns_priv`
`mysql`.`proxies_priv`
`information_schema`.`COLLATIONS`
`phpmyadmin`.`pma__navigationhiding`
Favorites
There are no favorite tables.
New
information_schema
mysql
performance_schema
phpmyadmin
sistem
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: sistem
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`abilities`.*
`abilities`.`id`
`abilities`.`tenant_id`
`abilities`.`name`
`abilities`.`description`
`abilities`.`created_at`
`abilities`.`updated_at`
`account_balances`.*
`account_balances`.`id`
`account_balances`.`tenant_id`
`account_balances`.`chart_of_account_id`
`account_balances`.`period`
`account_balances`.`opening_balance`
`account_balances`.`total_debit`
`account_balances`.`total_credit`
`account_balances`.`closing_balance`
`account_balances`.`created_at`
`account_balances`.`updated_at`
`account_types`.*
`account_types`.`id`
`account_types`.`is_active`
`account_types`.`name`
`account_types`.`created_at`
`account_types`.`updated_at`
`activity_logs`.*
`activity_logs`.`id`
`activity_logs`.`tenant_id`
`activity_logs`.`user_name`
`activity_logs`.`module`
`activity_logs`.`type`
`activity_logs`.`payload`
`activity_logs`.`created_at`
`activity_logs`.`updated_at`
`cache`.*
`cache`.`key`
`cache`.`value`
`cache`.`expiration`
`cache_locks`.*
`cache_locks`.`key`
`cache_locks`.`owner`
`cache_locks`.`expiration`
`cash_bank_payment_attachments`.*
`cash_bank_payment_attachments`.`id`
`cash_bank_payment_attachments`.`tenant_id`
`cash_bank_payment_attachments`.`cash_bank_payment_id`
`cash_bank_payment_attachments`.`original_name`
`cash_bank_payment_attachments`.`file_path`
`cash_bank_payment_attachments`.`mime_type`
`cash_bank_payment_attachments`.`file_size`
`cash_bank_payment_attachments`.`created_at`
`cash_bank_payment_attachments`.`updated_at`
`cash_bank_payment_details`.*
`cash_bank_payment_details`.`id`
`cash_bank_payment_details`.`tenant_id`
`cash_bank_payment_details`.`cash_bank_payment_id`
`cash_bank_payment_details`.`chart_of_account_id`
`cash_bank_payment_details`.`amount`
`cash_bank_payment_details`.`note`
`cash_bank_payment_details`.`created_at`
`cash_bank_payment_details`.`updated_at`
`cash_bank_payments`.*
`cash_bank_payments`.`id`
`cash_bank_payments`.`tenant_id`
`cash_bank_payments`.`chart_of_account_id`
`cash_bank_payments`.`payment_number`
`cash_bank_payments`.`payment_date`
`cash_bank_payments`.`description`
`cash_bank_payments`.`amount`
`cash_bank_payments`.`created_at`
`cash_bank_payments`.`updated_at`
`cash_bank_receipt_attachments`.*
`cash_bank_receipt_attachments`.`id`
`cash_bank_receipt_attachments`.`tenant_id`
`cash_bank_receipt_attachments`.`cash_bank_receipt_id`
`cash_bank_receipt_attachments`.`original_name`
`cash_bank_receipt_attachments`.`file_path`
`cash_bank_receipt_attachments`.`mime_type`
`cash_bank_receipt_attachments`.`file_size`
`cash_bank_receipt_attachments`.`created_at`
`cash_bank_receipt_attachments`.`updated_at`
`cash_bank_receipt_details`.*
`cash_bank_receipt_details`.`id`
`cash_bank_receipt_details`.`tenant_id`
`cash_bank_receipt_details`.`cash_bank_receipt_id`
`cash_bank_receipt_details`.`chart_of_account_id`
`cash_bank_receipt_details`.`amount`
`cash_bank_receipt_details`.`note`
`cash_bank_receipt_details`.`created_at`
`cash_bank_receipt_details`.`updated_at`
`cash_bank_receipts`.*
`cash_bank_receipts`.`id`
`cash_bank_receipts`.`tenant_id`
`cash_bank_receipts`.`chart_of_account_id`
`cash_bank_receipts`.`receipt_number`
`cash_bank_receipts`.`receipt_date`
`cash_bank_receipts`.`description`
`cash_bank_receipts`.`amount`
`cash_bank_receipts`.`created_at`
`cash_bank_receipts`.`updated_at`
`chart_of_accounts`.*
`chart_of_accounts`.`id`
`chart_of_accounts`.`tenant_id`
`chart_of_accounts`.`is_active`
`chart_of_accounts`.`parent_id`
`chart_of_accounts`.`account_type`
`chart_of_accounts`.`account_code`
`chart_of_accounts`.`account_name`
`chart_of_accounts`.`description`
`chart_of_accounts`.`created_at`
`chart_of_accounts`.`updated_at`
`company_preferences`.*
`company_preferences`.`id`
`company_preferences`.`tenant_id`
`company_preferences`.`chart_of_account_id`
`company_preferences`.`company_name`
`company_preferences`.`short_name`
`company_preferences`.`company_tax_id`
`company_preferences`.`company_phone`
`company_preferences`.`company_email`
`company_preferences`.`signatory_name`
`company_preferences`.`company_address`
`company_preferences`.`company_logo`
`company_preferences`.`created_at`
`company_preferences`.`updated_at`
`customers`.*
`customers`.`id`
`customers`.`tenant_id`
`customers`.`is_active`
`customers`.`customer_code`
`customers`.`customer_name`
`customers`.`tax_id`
`customers`.`address`
`customers`.`province`
`customers`.`sales_price_level`
`customers`.`created_at`
`customers`.`updated_at`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`general_journal_entries`.*
`general_journal_entries`.`id`
`general_journal_entries`.`tenant_id`
`general_journal_entries`.`entry_number`
`general_journal_entries`.`entry_date`
`general_journal_entries`.`description`
`general_journal_entries`.`total_debit`
`general_journal_entries`.`total_credit`
`general_journal_entries`.`created_at`
`general_journal_entries`.`updated_at`
`general_journal_entry_attachments`.*
`general_journal_entry_attachments`.`id`
`general_journal_entry_attachments`.`tenant_id`
`general_journal_entry_attachments`.`general_journal_entry_id`
`general_journal_entry_attachments`.`original_name`
`general_journal_entry_attachments`.`file_path`
`general_journal_entry_attachments`.`mime_type`
`general_journal_entry_attachments`.`file_size`
`general_journal_entry_attachments`.`created_at`
`general_journal_entry_attachments`.`updated_at`
`general_journal_entry_details`.*
`general_journal_entry_details`.`id`
`general_journal_entry_details`.`tenant_id`
`general_journal_entry_details`.`general_journal_entry_id`
`general_journal_entry_details`.`chart_of_account_id`
`general_journal_entry_details`.`debit`
`general_journal_entry_details`.`credit`
`general_journal_entry_details`.`note`
`general_journal_entry_details`.`created_at`
`general_journal_entry_details`.`updated_at`
`item_stock_balances`.*
`item_stock_balances`.`id`
`item_stock_balances`.`tenant_id`
`item_stock_balances`.`warehouse_id`
`item_stock_balances`.`warehouse_rack_id`
`item_stock_balances`.`item_id`
`item_stock_balances`.`balance_qty`
`item_stock_balances`.`balance_value`
`item_stock_balances`.`created_at`
`item_stock_balances`.`updated_at`
`items`.*
`items`.`id`
`items`.`tenant_id`
`items`.`is_active`
`items`.`item_code`
`items`.`item_name`
`items`.`inventory_type`
`items`.`description`
`items`.`average_cost`
`items`.`sales_price_level_1`
`items`.`sales_price_level_2`
`items`.`sales_price_level_3`
`items`.`sales_price_level_4`
`items`.`sales_price_level_5`
`items`.`sales_price_level_6`
`items`.`sales_price_level_7`
`items`.`sales_price_level_8`
`items`.`sales_price_level_9`
`items`.`sales_price_level_10`
`items`.`sales_price_level_11`
`items`.`sales_price_level_12`
`items`.`sales_price_level_13`
`items`.`sales_price_level_14`
`items`.`sales_price_level_15`
`items`.`sales_price_level_16`
`items`.`sales_price_level_17`
`items`.`sales_price_level_18`
`items`.`sales_price_level_19`
`items`.`sales_price_level_20`
`items`.`created_at`
`items`.`updated_at`
`items`.`cogs_account_id`
`items`.`revenue_account_id`
`items`.`sales_return_account_id`
`items`.`inventory_account_id`
`items`.`sales_discount_account_id`
`items`.`goods_sent_account_id`
`items`.`purchase_return_account_id`
`items`.`unbilled_account_id`
`job_batches`.*
`job_batches`.`id`
`job_batches`.`name`
`job_batches`.`total_jobs`
`job_batches`.`pending_jobs`
`job_batches`.`failed_jobs`
`job_batches`.`failed_job_ids`
`job_batches`.`options`
`job_batches`.`cancelled_at`
`job_batches`.`created_at`
`job_batches`.`finished_at`
`jobs`.*
`jobs`.`id`
`jobs`.`queue`
`jobs`.`payload`
`jobs`.`attempts`
`jobs`.`reserved_at`
`jobs`.`available_at`
`jobs`.`created_at`
`ledger_entries`.*
`ledger_entries`.`id`
`ledger_entries`.`tenant_id`
`ledger_entries`.`chart_of_account_id`
`ledger_entries`.`source_id`
`ledger_entries`.`transaction_date`
`ledger_entries`.`reference_number`
`ledger_entries`.`source_type`
`ledger_entries`.`amount`
`ledger_entries`.`mutation_type`
`ledger_entries`.`description`
`ledger_entries`.`created_at`
`ledger_entries`.`updated_at`
`menus`.*
`menus`.`id`
`menus`.`tenant_id`
`menus`.`menu_name`
`menus`.`route`
`menus`.`type`
`menus`.`parent_id`
`menus`.`sort_order`
`menus`.`icon`
`menus`.`is_active`
`menus`.`created_at`
`menus`.`updated_at`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`number_sequences`.*
`number_sequences`.`id`
`number_sequences`.`tenant_id`
`number_sequences`.`prefix`
`number_sequences`.`period`
`number_sequences`.`last_number`
`password_reset_tokens`.*
`password_reset_tokens`.`email`
`password_reset_tokens`.`token`
`password_reset_tokens`.`created_at`
`purchase_invoice_details`.*
`purchase_invoice_details`.`id`
`purchase_invoice_details`.`tenant_id`
`purchase_invoice_details`.`purchase_invoice_id`
`purchase_invoice_details`.`purchase_receipt_detail_id`
`purchase_invoice_details`.`item_id`
`purchase_invoice_details`.`item_code`
`purchase_invoice_details`.`item_name`
`purchase_invoice_details`.`quantity`
`purchase_invoice_details`.`item_price`
`purchase_invoice_details`.`discount_amount`
`purchase_invoice_details`.`subtotal`
`purchase_invoice_details`.`note`
`purchase_invoice_details`.`created_at`
`purchase_invoice_details`.`updated_at`
`purchase_invoices`.*
`purchase_invoices`.`id`
`purchase_invoices`.`tenant_id`
`purchase_invoices`.`supplier_id`
`purchase_invoices`.`purchase_receipt_id`
`purchase_invoices`.`account_payable_id`
`purchase_invoices`.`invoice_number`
`purchase_invoices`.`invoice_date`
`purchase_invoices`.`description`
`purchase_invoices`.`vat_amount`
`purchase_invoices`.`shipping_cost`
`purchase_invoices`.`paid_amount`
`purchase_invoices`.`process_status`
`purchase_invoices`.`created_by`
`purchase_invoices`.`updated_by`
`purchase_invoices`.`grand_total`
`purchase_invoices`.`due_date`
`purchase_invoices`.`order_date`
`purchase_invoices`.`created_at`
`purchase_invoices`.`updated_at`
`purchase_order_attachments`.*
`purchase_order_attachments`.`id`
`purchase_order_attachments`.`tenant_id`
`purchase_order_attachments`.`purchase_order_id`
`purchase_order_attachments`.`original_name`
`purchase_order_attachments`.`file_path`
`purchase_order_attachments`.`mime_type`
`purchase_order_attachments`.`file_size`
`purchase_order_attachments`.`created_at`
`purchase_order_attachments`.`updated_at`
`purchase_order_details`.*
`purchase_order_details`.`id`
`purchase_order_details`.`tenant_id`
`purchase_order_details`.`purchase_order_id`
`purchase_order_details`.`item_id`
`purchase_order_details`.`quantity`
`purchase_order_details`.`received_quantity`
`purchase_order_details`.`item_price`
`purchase_order_details`.`discount_percent`
`purchase_order_details`.`discount_amount`
`purchase_order_details`.`subtotal`
`purchase_order_details`.`note`
`purchase_order_details`.`created_at`
`purchase_order_details`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`tenant_id`
`purchase_orders`.`supplier_id`
`purchase_orders`.`purchase_request_id`
`purchase_orders`.`customer_id`
`purchase_orders`.`discount_account_id`
`purchase_orders`.`vat_account_id`
`purchase_orders`.`shipping_cost_account_id`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`created_by`
`purchase_orders`.`updated_by`
`purchase_orders`.`order_number`
`purchase_orders`.`due_days`
`purchase_orders`.`order_date`
`purchase_orders`.`is_vat_applied`
`purchase_orders`.`vat_amount`
`purchase_orders`.`shipping_cost`
`purchase_orders`.`discount_percent`
`purchase_orders`.`discount_amount`
`purchase_orders`.`subtotal_before_discount`
`purchase_orders`.`subtotal_after_discount`
`purchase_orders`.`grand_total`
`purchase_orders`.`description`
`purchase_orders`.`process_status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_payment_details`.*
`purchase_payment_details`.`id`
`purchase_payment_details`.`tenant_id`
`purchase_payment_details`.`purchase_payment_id`
`purchase_payment_details`.`purchase_invoice_id`
`purchase_payment_details`.`paid_amount`
`purchase_payment_details`.`created_at`
`purchase_payment_details`.`updated_at`
`purchase_payments`.*
`purchase_payments`.`id`
`purchase_payments`.`tenant_id`
`purchase_payments`.`supplier_id`
`purchase_payments`.`bank_account_id`
`purchase_payments`.`created_by`
`purchase_payments`.`updated_by`
`purchase_payments`.`payment_number`
`purchase_payments`.`payment_date`
`purchase_payments`.`paid_amount`
`purchase_payments`.`description`
`purchase_payments`.`account_payable_id`
`purchase_payments`.`created_at`
`purchase_payments`.`updated_at`
`purchase_receipt_details`.*
`purchase_receipt_details`.`id`
`purchase_receipt_details`.`tenant_id`
`purchase_receipt_details`.`purchase_receipt_id`
`purchase_receipt_details`.`purchase_order_detail_id`
`purchase_receipt_details`.`item_id`
`purchase_receipt_details`.`item_code`
`purchase_receipt_details`.`item_name`
`purchase_receipt_details`.`qty`
`purchase_receipt_details`.`unit_price`
`purchase_receipt_details`.`line_total`
`purchase_receipt_details`.`note`
`purchase_receipt_details`.`created_at`
`purchase_receipt_details`.`updated_at`
`purchase_receipts`.*
`purchase_receipts`.`id`
`purchase_receipts`.`tenant_id`
`purchase_receipts`.`receipt_number`
`purchase_receipts`.`receipt_date`
`purchase_receipts`.`supplier_id`
`purchase_receipts`.`warehouse_id`
`purchase_receipts`.`warehouse_rack_id`
`purchase_receipts`.`purchase_order_id`
`purchase_receipts`.`status`
`purchase_receipts`.`notes`
`purchase_receipts`.`subtotal`
`purchase_receipts`.`grand_total`
`purchase_receipts`.`created_at`
`purchase_receipts`.`updated_at`
`purchase_request_attachments`.*
`purchase_request_attachments`.`id`
`purchase_request_attachments`.`tenant_id`
`purchase_request_attachments`.`purchase_request_id`
`purchase_request_attachments`.`original_name`
`purchase_request_attachments`.`file_path`
`purchase_request_attachments`.`mime_type`
`purchase_request_attachments`.`file_size`
`purchase_request_attachments`.`created_at`
`purchase_request_attachments`.`updated_at`
`purchase_request_details`.*
`purchase_request_details`.`id`
`purchase_request_details`.`tenant_id`
`purchase_request_details`.`purchase_request_id`
`purchase_request_details`.`item_id`
`purchase_request_details`.`item_code`
`purchase_request_details`.`item_name`
`purchase_request_details`.`qty`
`purchase_request_details`.`unit_price`
`purchase_request_details`.`discount_amount`
`purchase_request_details`.`line_total`
`purchase_request_details`.`note`
`purchase_request_details`.`created_at`
`purchase_request_details`.`updated_at`
`purchase_requests`.*
`purchase_requests`.`id`
`purchase_requests`.`tenant_id`
`purchase_requests`.`request_number`
`purchase_requests`.`request_date`
`purchase_requests`.`needed_date`
`purchase_requests`.`supplier_id`
`purchase_requests`.`status`
`purchase_requests`.`previous_status_before_processed`
`purchase_requests`.`notes`
`purchase_requests`.`subtotal`
`purchase_requests`.`grand_total`
`purchase_requests`.`created_at`
`purchase_requests`.`updated_at`
`purchase_return_details`.*
`purchase_return_details`.`id`
`purchase_return_details`.`tenant_id`
`purchase_return_details`.`purchase_return_id`
`purchase_return_details`.`purchase_invoice_detail_id`
`purchase_return_details`.`item_id`
`purchase_return_details`.`item_code`
`purchase_return_details`.`item_name`
`purchase_return_details`.`qty`
`purchase_return_details`.`unit_price`
`purchase_return_details`.`line_total`
`purchase_return_details`.`note`
`purchase_return_details`.`created_at`
`purchase_return_details`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`tenant_id`
`purchase_returns`.`supplier_id`
`purchase_returns`.`purchase_invoice_id`
`purchase_returns`.`account_payable_id`
`purchase_returns`.`return_number`
`purchase_returns`.`return_date`
`purchase_returns`.`status`
`purchase_returns`.`description`
`purchase_returns`.`grand_total`
`purchase_returns`.`created_by`
`purchase_returns`.`updated_by`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`role_ability`.*
`role_ability`.`role_id`
`role_ability`.`ability_id`
`role_ability`.`created_at`
`role_ability`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`tenant_id`
`roles`.`name`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales_deliveries`.*
`sales_deliveries`.`id`
`sales_deliveries`.`tenant_id`
`sales_deliveries`.`delivery_number`
`sales_deliveries`.`delivery_date`
`sales_deliveries`.`customer_id`
`sales_deliveries`.`warehouse_id`
`sales_deliveries`.`warehouse_rack_id`
`sales_deliveries`.`sales_order_id`
`sales_deliveries`.`sales_quotation_id`
`sales_deliveries`.`status`
`sales_deliveries`.`notes`
`sales_deliveries`.`subtotal`
`sales_deliveries`.`grand_total`
`sales_deliveries`.`created_at`
`sales_deliveries`.`updated_at`
`sales_delivery_attachments`.*
`sales_delivery_attachments`.`id`
`sales_delivery_attachments`.`tenant_id`
`sales_delivery_attachments`.`sales_delivery_id`
`sales_delivery_attachments`.`original_name`
`sales_delivery_attachments`.`file_path`
`sales_delivery_attachments`.`mime_type`
`sales_delivery_attachments`.`file_size`
`sales_delivery_attachments`.`created_at`
`sales_delivery_attachments`.`updated_at`
`sales_delivery_details`.*
`sales_delivery_details`.`id`
`sales_delivery_details`.`tenant_id`
`sales_delivery_details`.`sales_delivery_id`
`sales_delivery_details`.`item_id`
`sales_delivery_details`.`item_code`
`sales_delivery_details`.`item_name`
`sales_delivery_details`.`qty`
`sales_delivery_details`.`unit_price`
`sales_delivery_details`.`line_total`
`sales_delivery_details`.`note`
`sales_delivery_details`.`created_at`
`sales_delivery_details`.`updated_at`
`sales_invoice_attachments`.*
`sales_invoice_attachments`.`id`
`sales_invoice_attachments`.`tenant_id`
`sales_invoice_attachments`.`sales_invoice_id`
`sales_invoice_attachments`.`original_name`
`sales_invoice_attachments`.`file_path`
`sales_invoice_attachments`.`mime_type`
`sales_invoice_attachments`.`file_size`
`sales_invoice_attachments`.`created_at`
`sales_invoice_attachments`.`updated_at`
`sales_invoice_details`.*
`sales_invoice_details`.`id`
`sales_invoice_details`.`tenant_id`
`sales_invoice_details`.`sales_invoice_id`
`sales_invoice_details`.`item_id`
`sales_invoice_details`.`item_code`
`sales_invoice_details`.`item_name`
`sales_invoice_details`.`quantity`
`sales_invoice_details`.`price`
`sales_invoice_details`.`discount_percent`
`sales_invoice_details`.`discount_amount`
`sales_invoice_details`.`subtotal`
`sales_invoice_details`.`note`
`sales_invoice_details`.`created_at`
`sales_invoice_details`.`updated_at`
`sales_invoices`.*
`sales_invoices`.`id`
`sales_invoices`.`tenant_id`
`sales_invoices`.`customer_id`
`sales_invoices`.`warehouse_id`
`sales_invoices`.`warehouse_rack_id`
`sales_invoices`.`sales_order_id`
`sales_invoices`.`sales_delivery_id`
`sales_invoices`.`vat_rate_id`
`sales_invoices`.`account_receivable_id`
`sales_invoices`.`invoice_number`
`sales_invoices`.`invoice_date`
`sales_invoices`.`description`
`sales_invoices`.`vat_percent`
`sales_invoices`.`vat_amount`
`sales_invoices`.`discount_percent`
`sales_invoices`.`discount_amount`
`sales_invoices`.`grand_total`
`sales_invoices`.`paid_amount`
`sales_invoices`.`process_status`
`sales_invoices`.`created_by`
`sales_invoices`.`updated_by`
`sales_invoices`.`created_at`
`sales_invoices`.`updated_at`
`sales_order_attachments`.*
`sales_order_attachments`.`id`
`sales_order_attachments`.`tenant_id`
`sales_order_attachments`.`sales_order_id`
`sales_order_attachments`.`original_name`
`sales_order_attachments`.`file_path`
`sales_order_attachments`.`mime_type`
`sales_order_attachments`.`file_size`
`sales_order_attachments`.`created_at`
`sales_order_attachments`.`updated_at`
`sales_order_details`.*
`sales_order_details`.`id`
`sales_order_details`.`tenant_id`
`sales_order_details`.`sales_order_id`
`sales_order_details`.`item_id`
`sales_order_details`.`item_code`
`sales_order_details`.`item_name`
`sales_order_details`.`qty`
`sales_order_details`.`unit_price`
`sales_order_details`.`discount_percent`
`sales_order_details`.`discount_amount`
`sales_order_details`.`line_total`
`sales_order_details`.`note`
`sales_order_details`.`created_at`
`sales_order_details`.`updated_at`
`sales_orders`.*
`sales_orders`.`id`
`sales_orders`.`tenant_id`
`sales_orders`.`order_number`
`sales_orders`.`order_date`
`sales_orders`.`customer_id`
`sales_orders`.`sales_quotation_id`
`sales_orders`.`vat_rate_id`
`sales_orders`.`status`
`sales_orders`.`previous_status_before_processed`
`sales_orders`.`notes`
`sales_orders`.`subtotal`
`sales_orders`.`vat_percent`
`sales_orders`.`vat_amount`
`sales_orders`.`grand_total`
`sales_orders`.`created_at`
`sales_orders`.`updated_at`
`sales_quotation_attachments`.*
`sales_quotation_attachments`.`id`
`sales_quotation_attachments`.`tenant_id`
`sales_quotation_attachments`.`sales_quotation_id`
`sales_quotation_attachments`.`original_name`
`sales_quotation_attachments`.`file_path`
`sales_quotation_attachments`.`mime_type`
`sales_quotation_attachments`.`file_size`
`sales_quotation_attachments`.`created_at`
`sales_quotation_attachments`.`updated_at`
`sales_quotation_details`.*
`sales_quotation_details`.`id`
`sales_quotation_details`.`tenant_id`
`sales_quotation_details`.`sales_quotation_id`
`sales_quotation_details`.`item_id`
`sales_quotation_details`.`item_code`
`sales_quotation_details`.`item_name`
`sales_quotation_details`.`qty`
`sales_quotation_details`.`unit_price`
`sales_quotation_details`.`discount_percent`
`sales_quotation_details`.`discount_amount`
`sales_quotation_details`.`line_total`
`sales_quotation_details`.`note`
`sales_quotation_details`.`created_at`
`sales_quotation_details`.`updated_at`
`sales_quotations`.*
`sales_quotations`.`id`
`sales_quotations`.`tenant_id`
`sales_quotations`.`quotation_number`
`sales_quotations`.`quotation_date`
`sales_quotations`.`valid_until`
`sales_quotations`.`customer_id`
`sales_quotations`.`vat_rate_id`
`sales_quotations`.`status`
`sales_quotations`.`previous_status_before_processed`
`sales_quotations`.`notes`
`sales_quotations`.`subtotal`
`sales_quotations`.`vat_percent`
`sales_quotations`.`vat_amount`
`sales_quotations`.`grand_total`
`sales_quotations`.`created_at`
`sales_quotations`.`updated_at`
`sales_receipt_details`.*
`sales_receipt_details`.`id`
`sales_receipt_details`.`tenant_id`
`sales_receipt_details`.`sales_receipt_id`
`sales_receipt_details`.`sales_invoice_id`
`sales_receipt_details`.`paid_amount`
`sales_receipt_details`.`created_at`
`sales_receipt_details`.`updated_at`
`sales_receipts`.*
`sales_receipts`.`id`
`sales_receipts`.`tenant_id`
`sales_receipts`.`created_by`
`sales_receipts`.`updated_by`
`sales_receipts`.`customer_id`
`sales_receipts`.`bank_account_id`
`sales_receipts`.`receipt_number`
`sales_receipts`.`receipt_date`
`sales_receipts`.`paid_amount`
`sales_receipts`.`description`
`sales_receipts`.`account_receivable_id`
`sales_receipts`.`created_at`
`sales_receipts`.`updated_at`
`sales_return_details`.*
`sales_return_details`.`id`
`sales_return_details`.`tenant_id`
`sales_return_details`.`sales_return_id`
`sales_return_details`.`item_id`
`sales_return_details`.`item_code`
`sales_return_details`.`item_name`
`sales_return_details`.`qty`
`sales_return_details`.`unit_price`
`sales_return_details`.`line_total`
`sales_return_details`.`note`
`sales_return_details`.`created_at`
`sales_return_details`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`tenant_id`
`sales_returns`.`return_number`
`sales_returns`.`return_date`
`sales_returns`.`customer_id`
`sales_returns`.`warehouse_id`
`sales_returns`.`warehouse_rack_id`
`sales_returns`.`sales_invoice_id`
`sales_returns`.`status`
`sales_returns`.`notes`
`sales_returns`.`subtotal`
`sales_returns`.`grand_total`
`sales_returns`.`created_at`
`sales_returns`.`updated_at`
`sessions`.*
`sessions`.`id`
`sessions`.`user_id`
`sessions`.`ip_address`
`sessions`.`user_agent`
`sessions`.`payload`
`sessions`.`last_activity`
`stock_mutations`.*
`stock_mutations`.`id`
`stock_mutations`.`tenant_id`
`stock_mutations`.`warehouse_id`
`stock_mutations`.`warehouse_rack_id`
`stock_mutations`.`item_id`
`stock_mutations`.`transaction_date`
`stock_mutations`.`reference_number`
`stock_mutations`.`source_type`
`stock_mutations`.`source_id`
`stock_mutations`.`mutation_type`
`stock_mutations`.`direction`
`stock_mutations`.`quantity`
`stock_mutations`.`unit_cost`
`stock_mutations`.`total_cost`
`stock_mutations`.`description`
`stock_mutations`.`created_at`
`stock_mutations`.`updated_at`
`stock_transfer_details`.*
`stock_transfer_details`.`id`
`stock_transfer_details`.`tenant_id`
`stock_transfer_details`.`stock_transfer_id`
`stock_transfer_details`.`item_id`
`stock_transfer_details`.`from_warehouse_rack_id`
`stock_transfer_details`.`to_warehouse_rack_id`
`stock_transfer_details`.`item_code`
`stock_transfer_details`.`item_name`
`stock_transfer_details`.`qty`
`stock_transfer_details`.`unit_cost`
`stock_transfer_details`.`total_cost`
`stock_transfer_details`.`note`
`stock_transfer_details`.`created_at`
`stock_transfer_details`.`updated_at`
`stock_transfers`.*
`stock_transfers`.`id`
`stock_transfers`.`tenant_id`
`stock_transfers`.`transfer_number`
`stock_transfers`.`transfer_date`
`stock_transfers`.`from_warehouse_id`
`stock_transfers`.`to_warehouse_id`
`stock_transfers`.`status`
`stock_transfers`.`notes`
`stock_transfers`.`created_at`
`stock_transfers`.`updated_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`tenant_id`
`suppliers`.`is_active`
`suppliers`.`supplier_code`
`suppliers`.`supplier_name`
`suppliers`.`supplier_email`
`suppliers`.`supplier_address`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`tenant_user`.*
`tenant_user`.`tenant_id`
`tenant_user`.`user_id`
`tenant_user`.`role`
`tenant_user`.`is_owner`
`tenant_user`.`created_at`
`tenant_user`.`updated_at`
`tenant_user_roles`.*
`tenant_user_roles`.`tenant_id`
`tenant_user_roles`.`user_id`
`tenant_user_roles`.`role_id`
`tenant_user_roles`.`created_at`
`tenant_user_roles`.`updated_at`
`tenants`.*
`tenants`.`id`
`tenants`.`name`
`tenants`.`slug`
`tenants`.`is_active`
`tenants`.`created_at`
`tenants`.`updated_at`
`users`.*
`users`.`id`
`users`.`active_tenant_id`
`users`.`locale`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`profile_photo`
`users`.`created_at`
`users`.`updated_at`
`vat_rates`.*
`vat_rates`.`id`
`vat_rates`.`tenant_id`
`vat_rates`.`name`
`vat_rates`.`rate`
`vat_rates`.`is_active`
`vat_rates`.`created_at`
`vat_rates`.`updated_at`
`warehouse_racks`.*
`warehouse_racks`.`id`
`warehouse_racks`.`tenant_id`
`warehouse_racks`.`warehouse_id`
`warehouse_racks`.`rack_code`
`warehouse_racks`.`rack_name`
`warehouse_racks`.`description`
`warehouse_racks`.`is_active`
`warehouse_racks`.`created_at`
`warehouse_racks`.`updated_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`tenant_id`
`warehouses`.`is_active`
`warehouses`.`warehouse_code`
`warehouses`.`warehouse_name`
`warehouses`.`description`
`warehouses`.`created_at`
`warehouses`.`updated_at`
`abilities`.*
`abilities`.`id`
`abilities`.`tenant_id`
`abilities`.`name`
`abilities`.`description`
`abilities`.`created_at`
`abilities`.`updated_at`
`account_balances`.*
`account_balances`.`id`
`account_balances`.`tenant_id`
`account_balances`.`chart_of_account_id`
`account_balances`.`period`
`account_balances`.`opening_balance`
`account_balances`.`total_debit`
`account_balances`.`total_credit`
`account_balances`.`closing_balance`
`account_balances`.`created_at`
`account_balances`.`updated_at`
`account_types`.*
`account_types`.`id`
`account_types`.`is_active`
`account_types`.`name`
`account_types`.`created_at`
`account_types`.`updated_at`
`activity_logs`.*
`activity_logs`.`id`
`activity_logs`.`tenant_id`
`activity_logs`.`user_name`
`activity_logs`.`module`
`activity_logs`.`type`
`activity_logs`.`payload`
`activity_logs`.`created_at`
`activity_logs`.`updated_at`
`cache`.*
`cache`.`key`
`cache`.`value`
`cache`.`expiration`
`cache_locks`.*
`cache_locks`.`key`
`cache_locks`.`owner`
`cache_locks`.`expiration`
`cash_bank_payment_attachments`.*
`cash_bank_payment_attachments`.`id`
`cash_bank_payment_attachments`.`tenant_id`
`cash_bank_payment_attachments`.`cash_bank_payment_id`
`cash_bank_payment_attachments`.`original_name`
`cash_bank_payment_attachments`.`file_path`
`cash_bank_payment_attachments`.`mime_type`
`cash_bank_payment_attachments`.`file_size`
`cash_bank_payment_attachments`.`created_at`
`cash_bank_payment_attachments`.`updated_at`
`cash_bank_payment_details`.*
`cash_bank_payment_details`.`id`
`cash_bank_payment_details`.`tenant_id`
`cash_bank_payment_details`.`cash_bank_payment_id`
`cash_bank_payment_details`.`chart_of_account_id`
`cash_bank_payment_details`.`amount`
`cash_bank_payment_details`.`note`
`cash_bank_payment_details`.`created_at`
`cash_bank_payment_details`.`updated_at`
`cash_bank_payments`.*
`cash_bank_payments`.`id`
`cash_bank_payments`.`tenant_id`
`cash_bank_payments`.`chart_of_account_id`
`cash_bank_payments`.`payment_number`
`cash_bank_payments`.`payment_date`
`cash_bank_payments`.`description`
`cash_bank_payments`.`amount`
`cash_bank_payments`.`created_at`
`cash_bank_payments`.`updated_at`
`cash_bank_receipt_attachments`.*
`cash_bank_receipt_attachments`.`id`
`cash_bank_receipt_attachments`.`tenant_id`
`cash_bank_receipt_attachments`.`cash_bank_receipt_id`
`cash_bank_receipt_attachments`.`original_name`
`cash_bank_receipt_attachments`.`file_path`
`cash_bank_receipt_attachments`.`mime_type`
`cash_bank_receipt_attachments`.`file_size`
`cash_bank_receipt_attachments`.`created_at`
`cash_bank_receipt_attachments`.`updated_at`
`cash_bank_receipt_details`.*
`cash_bank_receipt_details`.`id`
`cash_bank_receipt_details`.`tenant_id`
`cash_bank_receipt_details`.`cash_bank_receipt_id`
`cash_bank_receipt_details`.`chart_of_account_id`
`cash_bank_receipt_details`.`amount`
`cash_bank_receipt_details`.`note`
`cash_bank_receipt_details`.`created_at`
`cash_bank_receipt_details`.`updated_at`
`cash_bank_receipts`.*
`cash_bank_receipts`.`id`
`cash_bank_receipts`.`tenant_id`
`cash_bank_receipts`.`chart_of_account_id`
`cash_bank_receipts`.`receipt_number`
`cash_bank_receipts`.`receipt_date`
`cash_bank_receipts`.`description`
`cash_bank_receipts`.`amount`
`cash_bank_receipts`.`created_at`
`cash_bank_receipts`.`updated_at`
`chart_of_accounts`.*
`chart_of_accounts`.`id`
`chart_of_accounts`.`tenant_id`
`chart_of_accounts`.`is_active`
`chart_of_accounts`.`parent_id`
`chart_of_accounts`.`account_type`
`chart_of_accounts`.`account_code`
`chart_of_accounts`.`account_name`
`chart_of_accounts`.`description`
`chart_of_accounts`.`created_at`
`chart_of_accounts`.`updated_at`
`company_preferences`.*
`company_preferences`.`id`
`company_preferences`.`tenant_id`
`company_preferences`.`chart_of_account_id`
`company_preferences`.`company_name`
`company_preferences`.`short_name`
`company_preferences`.`company_tax_id`
`company_preferences`.`company_phone`
`company_preferences`.`company_email`
`company_preferences`.`signatory_name`
`company_preferences`.`company_address`
`company_preferences`.`company_logo`
`company_preferences`.`created_at`
`company_preferences`.`updated_at`
`customers`.*
`customers`.`id`
`customers`.`tenant_id`
`customers`.`is_active`
`customers`.`customer_code`
`customers`.`customer_name`
`customers`.`tax_id`
`customers`.`address`
`customers`.`province`
`customers`.`sales_price_level`
`customers`.`created_at`
`customers`.`updated_at`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`general_journal_entries`.*
`general_journal_entries`.`id`
`general_journal_entries`.`tenant_id`
`general_journal_entries`.`entry_number`
`general_journal_entries`.`entry_date`
`general_journal_entries`.`description`
`general_journal_entries`.`total_debit`
`general_journal_entries`.`total_credit`
`general_journal_entries`.`created_at`
`general_journal_entries`.`updated_at`
`general_journal_entry_attachments`.*
`general_journal_entry_attachments`.`id`
`general_journal_entry_attachments`.`tenant_id`
`general_journal_entry_attachments`.`general_journal_entry_id`
`general_journal_entry_attachments`.`original_name`
`general_journal_entry_attachments`.`file_path`
`general_journal_entry_attachments`.`mime_type`
`general_journal_entry_attachments`.`file_size`
`general_journal_entry_attachments`.`created_at`
`general_journal_entry_attachments`.`updated_at`
`general_journal_entry_details`.*
`general_journal_entry_details`.`id`
`general_journal_entry_details`.`tenant_id`
`general_journal_entry_details`.`general_journal_entry_id`
`general_journal_entry_details`.`chart_of_account_id`
`general_journal_entry_details`.`debit`
`general_journal_entry_details`.`credit`
`general_journal_entry_details`.`note`
`general_journal_entry_details`.`created_at`
`general_journal_entry_details`.`updated_at`
`item_stock_balances`.*
`item_stock_balances`.`id`
`item_stock_balances`.`tenant_id`
`item_stock_balances`.`warehouse_id`
`item_stock_balances`.`warehouse_rack_id`
`item_stock_balances`.`item_id`
`item_stock_balances`.`balance_qty`
`item_stock_balances`.`balance_value`
`item_stock_balances`.`created_at`
`item_stock_balances`.`updated_at`
`items`.*
`items`.`id`
`items`.`tenant_id`
`items`.`is_active`
`items`.`item_code`
`items`.`item_name`
`items`.`inventory_type`
`items`.`description`
`items`.`average_cost`
`items`.`sales_price_level_1`
`items`.`sales_price_level_2`
`items`.`sales_price_level_3`
`items`.`sales_price_level_4`
`items`.`sales_price_level_5`
`items`.`sales_price_level_6`
`items`.`sales_price_level_7`
`items`.`sales_price_level_8`
`items`.`sales_price_level_9`
`items`.`sales_price_level_10`
`items`.`sales_price_level_11`
`items`.`sales_price_level_12`
`items`.`sales_price_level_13`
`items`.`sales_price_level_14`
`items`.`sales_price_level_15`
`items`.`sales_price_level_16`
`items`.`sales_price_level_17`
`items`.`sales_price_level_18`
`items`.`sales_price_level_19`
`items`.`sales_price_level_20`
`items`.`created_at`
`items`.`updated_at`
`items`.`cogs_account_id`
`items`.`revenue_account_id`
`items`.`sales_return_account_id`
`items`.`inventory_account_id`
`items`.`sales_discount_account_id`
`items`.`goods_sent_account_id`
`items`.`purchase_return_account_id`
`items`.`unbilled_account_id`
`job_batches`.*
`job_batches`.`id`
`job_batches`.`name`
`job_batches`.`total_jobs`
`job_batches`.`pending_jobs`
`job_batches`.`failed_jobs`
`job_batches`.`failed_job_ids`
`job_batches`.`options`
`job_batches`.`cancelled_at`
`job_batches`.`created_at`
`job_batches`.`finished_at`
`jobs`.*
`jobs`.`id`
`jobs`.`queue`
`jobs`.`payload`
`jobs`.`attempts`
`jobs`.`reserved_at`
`jobs`.`available_at`
`jobs`.`created_at`
`ledger_entries`.*
`ledger_entries`.`id`
`ledger_entries`.`tenant_id`
`ledger_entries`.`chart_of_account_id`
`ledger_entries`.`source_id`
`ledger_entries`.`transaction_date`
`ledger_entries`.`reference_number`
`ledger_entries`.`source_type`
`ledger_entries`.`amount`
`ledger_entries`.`mutation_type`
`ledger_entries`.`description`
`ledger_entries`.`created_at`
`ledger_entries`.`updated_at`
`menus`.*
`menus`.`id`
`menus`.`tenant_id`
`menus`.`menu_name`
`menus`.`route`
`menus`.`type`
`menus`.`parent_id`
`menus`.`sort_order`
`menus`.`icon`
`menus`.`is_active`
`menus`.`created_at`
`menus`.`updated_at`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`number_sequences`.*
`number_sequences`.`id`
`number_sequences`.`tenant_id`
`number_sequences`.`prefix`
`number_sequences`.`period`
`number_sequences`.`last_number`
`password_reset_tokens`.*
`password_reset_tokens`.`email`
`password_reset_tokens`.`token`
`password_reset_tokens`.`created_at`
`purchase_invoice_details`.*
`purchase_invoice_details`.`id`
`purchase_invoice_details`.`tenant_id`
`purchase_invoice_details`.`purchase_invoice_id`
`purchase_invoice_details`.`purchase_receipt_detail_id`
`purchase_invoice_details`.`item_id`
`purchase_invoice_details`.`item_code`
`purchase_invoice_details`.`item_name`
`purchase_invoice_details`.`quantity`
`purchase_invoice_details`.`item_price`
`purchase_invoice_details`.`discount_amount`
`purchase_invoice_details`.`subtotal`
`purchase_invoice_details`.`note`
`purchase_invoice_details`.`created_at`
`purchase_invoice_details`.`updated_at`
`purchase_invoices`.*
`purchase_invoices`.`id`
`purchase_invoices`.`tenant_id`
`purchase_invoices`.`supplier_id`
`purchase_invoices`.`purchase_receipt_id`
`purchase_invoices`.`account_payable_id`
`purchase_invoices`.`invoice_number`
`purchase_invoices`.`invoice_date`
`purchase_invoices`.`description`
`purchase_invoices`.`vat_amount`
`purchase_invoices`.`shipping_cost`
`purchase_invoices`.`paid_amount`
`purchase_invoices`.`process_status`
`purchase_invoices`.`created_by`
`purchase_invoices`.`updated_by`
`purchase_invoices`.`grand_total`
`purchase_invoices`.`due_date`
`purchase_invoices`.`order_date`
`purchase_invoices`.`created_at`
`purchase_invoices`.`updated_at`
`purchase_order_attachments`.*
`purchase_order_attachments`.`id`
`purchase_order_attachments`.`tenant_id`
`purchase_order_attachments`.`purchase_order_id`
`purchase_order_attachments`.`original_name`
`purchase_order_attachments`.`file_path`
`purchase_order_attachments`.`mime_type`
`purchase_order_attachments`.`file_size`
`purchase_order_attachments`.`created_at`
`purchase_order_attachments`.`updated_at`
`purchase_order_details`.*
`purchase_order_details`.`id`
`purchase_order_details`.`tenant_id`
`purchase_order_details`.`purchase_order_id`
`purchase_order_details`.`item_id`
`purchase_order_details`.`quantity`
`purchase_order_details`.`received_quantity`
`purchase_order_details`.`item_price`
`purchase_order_details`.`discount_percent`
`purchase_order_details`.`discount_amount`
`purchase_order_details`.`subtotal`
`purchase_order_details`.`note`
`purchase_order_details`.`created_at`
`purchase_order_details`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`tenant_id`
`purchase_orders`.`supplier_id`
`purchase_orders`.`purchase_request_id`
`purchase_orders`.`customer_id`
`purchase_orders`.`discount_account_id`
`purchase_orders`.`vat_account_id`
`purchase_orders`.`shipping_cost_account_id`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`created_by`
`purchase_orders`.`updated_by`
`purchase_orders`.`order_number`
`purchase_orders`.`due_days`
`purchase_orders`.`order_date`
`purchase_orders`.`is_vat_applied`
`purchase_orders`.`vat_amount`
`purchase_orders`.`shipping_cost`
`purchase_orders`.`discount_percent`
`purchase_orders`.`discount_amount`
`purchase_orders`.`subtotal_before_discount`
`purchase_orders`.`subtotal_after_discount`
`purchase_orders`.`grand_total`
`purchase_orders`.`description`
`purchase_orders`.`process_status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_payment_details`.*
`purchase_payment_details`.`id`
`purchase_payment_details`.`tenant_id`
`purchase_payment_details`.`purchase_payment_id`
`purchase_payment_details`.`purchase_invoice_id`
`purchase_payment_details`.`paid_amount`
`purchase_payment_details`.`created_at`
`purchase_payment_details`.`updated_at`
`purchase_payments`.*
`purchase_payments`.`id`
`purchase_payments`.`tenant_id`
`purchase_payments`.`supplier_id`
`purchase_payments`.`bank_account_id`
`purchase_payments`.`created_by`
`purchase_payments`.`updated_by`
`purchase_payments`.`payment_number`
`purchase_payments`.`payment_date`
`purchase_payments`.`paid_amount`
`purchase_payments`.`description`
`purchase_payments`.`account_payable_id`
`purchase_payments`.`created_at`
`purchase_payments`.`updated_at`
`purchase_receipt_details`.*
`purchase_receipt_details`.`id`
`purchase_receipt_details`.`tenant_id`
`purchase_receipt_details`.`purchase_receipt_id`
`purchase_receipt_details`.`purchase_order_detail_id`
`purchase_receipt_details`.`item_id`
`purchase_receipt_details`.`item_code`
`purchase_receipt_details`.`item_name`
`purchase_receipt_details`.`qty`
`purchase_receipt_details`.`unit_price`
`purchase_receipt_details`.`line_total`
`purchase_receipt_details`.`note`
`purchase_receipt_details`.`created_at`
`purchase_receipt_details`.`updated_at`
`purchase_receipts`.*
`purchase_receipts`.`id`
`purchase_receipts`.`tenant_id`
`purchase_receipts`.`receipt_number`
`purchase_receipts`.`receipt_date`
`purchase_receipts`.`supplier_id`
`purchase_receipts`.`warehouse_id`
`purchase_receipts`.`warehouse_rack_id`
`purchase_receipts`.`purchase_order_id`
`purchase_receipts`.`status`
`purchase_receipts`.`notes`
`purchase_receipts`.`subtotal`
`purchase_receipts`.`grand_total`
`purchase_receipts`.`created_at`
`purchase_receipts`.`updated_at`
`purchase_request_attachments`.*
`purchase_request_attachments`.`id`
`purchase_request_attachments`.`tenant_id`
`purchase_request_attachments`.`purchase_request_id`
`purchase_request_attachments`.`original_name`
`purchase_request_attachments`.`file_path`
`purchase_request_attachments`.`mime_type`
`purchase_request_attachments`.`file_size`
`purchase_request_attachments`.`created_at`
`purchase_request_attachments`.`updated_at`
`purchase_request_details`.*
`purchase_request_details`.`id`
`purchase_request_details`.`tenant_id`
`purchase_request_details`.`purchase_request_id`
`purchase_request_details`.`item_id`
`purchase_request_details`.`item_code`
`purchase_request_details`.`item_name`
`purchase_request_details`.`qty`
`purchase_request_details`.`unit_price`
`purchase_request_details`.`discount_amount`
`purchase_request_details`.`line_total`
`purchase_request_details`.`note`
`purchase_request_details`.`created_at`
`purchase_request_details`.`updated_at`
`purchase_requests`.*
`purchase_requests`.`id`
`purchase_requests`.`tenant_id`
`purchase_requests`.`request_number`
`purchase_requests`.`request_date`
`purchase_requests`.`needed_date`
`purchase_requests`.`supplier_id`
`purchase_requests`.`status`
`purchase_requests`.`previous_status_before_processed`
`purchase_requests`.`notes`
`purchase_requests`.`subtotal`
`purchase_requests`.`grand_total`
`purchase_requests`.`created_at`
`purchase_requests`.`updated_at`
`purchase_return_details`.*
`purchase_return_details`.`id`
`purchase_return_details`.`tenant_id`
`purchase_return_details`.`purchase_return_id`
`purchase_return_details`.`purchase_invoice_detail_id`
`purchase_return_details`.`item_id`
`purchase_return_details`.`item_code`
`purchase_return_details`.`item_name`
`purchase_return_details`.`qty`
`purchase_return_details`.`unit_price`
`purchase_return_details`.`line_total`
`purchase_return_details`.`note`
`purchase_return_details`.`created_at`
`purchase_return_details`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`tenant_id`
`purchase_returns`.`supplier_id`
`purchase_returns`.`purchase_invoice_id`
`purchase_returns`.`account_payable_id`
`purchase_returns`.`return_number`
`purchase_returns`.`return_date`
`purchase_returns`.`status`
`purchase_returns`.`description`
`purchase_returns`.`grand_total`
`purchase_returns`.`created_by`
`purchase_returns`.`updated_by`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`role_ability`.*
`role_ability`.`role_id`
`role_ability`.`ability_id`
`role_ability`.`created_at`
`role_ability`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`tenant_id`
`roles`.`name`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales_deliveries`.*
`sales_deliveries`.`id`
`sales_deliveries`.`tenant_id`
`sales_deliveries`.`delivery_number`
`sales_deliveries`.`delivery_date`
`sales_deliveries`.`customer_id`
`sales_deliveries`.`warehouse_id`
`sales_deliveries`.`warehouse_rack_id`
`sales_deliveries`.`sales_order_id`
`sales_deliveries`.`sales_quotation_id`
`sales_deliveries`.`status`
`sales_deliveries`.`notes`
`sales_deliveries`.`subtotal`
`sales_deliveries`.`grand_total`
`sales_deliveries`.`created_at`
`sales_deliveries`.`updated_at`
`sales_delivery_attachments`.*
`sales_delivery_attachments`.`id`
`sales_delivery_attachments`.`tenant_id`
`sales_delivery_attachments`.`sales_delivery_id`
`sales_delivery_attachments`.`original_name`
`sales_delivery_attachments`.`file_path`
`sales_delivery_attachments`.`mime_type`
`sales_delivery_attachments`.`file_size`
`sales_delivery_attachments`.`created_at`
`sales_delivery_attachments`.`updated_at`
`sales_delivery_details`.*
`sales_delivery_details`.`id`
`sales_delivery_details`.`tenant_id`
`sales_delivery_details`.`sales_delivery_id`
`sales_delivery_details`.`item_id`
`sales_delivery_details`.`item_code`
`sales_delivery_details`.`item_name`
`sales_delivery_details`.`qty`
`sales_delivery_details`.`unit_price`
`sales_delivery_details`.`line_total`
`sales_delivery_details`.`note`
`sales_delivery_details`.`created_at`
`sales_delivery_details`.`updated_at`
`sales_invoice_attachments`.*
`sales_invoice_attachments`.`id`
`sales_invoice_attachments`.`tenant_id`
`sales_invoice_attachments`.`sales_invoice_id`
`sales_invoice_attachments`.`original_name`
`sales_invoice_attachments`.`file_path`
`sales_invoice_attachments`.`mime_type`
`sales_invoice_attachments`.`file_size`
`sales_invoice_attachments`.`created_at`
`sales_invoice_attachments`.`updated_at`
`sales_invoice_details`.*
`sales_invoice_details`.`id`
`sales_invoice_details`.`tenant_id`
`sales_invoice_details`.`sales_invoice_id`
`sales_invoice_details`.`item_id`
`sales_invoice_details`.`item_code`
`sales_invoice_details`.`item_name`
`sales_invoice_details`.`quantity`
`sales_invoice_details`.`price`
`sales_invoice_details`.`discount_percent`
`sales_invoice_details`.`discount_amount`
`sales_invoice_details`.`subtotal`
`sales_invoice_details`.`note`
`sales_invoice_details`.`created_at`
`sales_invoice_details`.`updated_at`
`sales_invoices`.*
`sales_invoices`.`id`
`sales_invoices`.`tenant_id`
`sales_invoices`.`customer_id`
`sales_invoices`.`warehouse_id`
`sales_invoices`.`warehouse_rack_id`
`sales_invoices`.`sales_order_id`
`sales_invoices`.`sales_delivery_id`
`sales_invoices`.`vat_rate_id`
`sales_invoices`.`account_receivable_id`
`sales_invoices`.`invoice_number`
`sales_invoices`.`invoice_date`
`sales_invoices`.`description`
`sales_invoices`.`vat_percent`
`sales_invoices`.`vat_amount`
`sales_invoices`.`discount_percent`
`sales_invoices`.`discount_amount`
`sales_invoices`.`grand_total`
`sales_invoices`.`paid_amount`
`sales_invoices`.`process_status`
`sales_invoices`.`created_by`
`sales_invoices`.`updated_by`
`sales_invoices`.`created_at`
`sales_invoices`.`updated_at`
`sales_order_attachments`.*
`sales_order_attachments`.`id`
`sales_order_attachments`.`tenant_id`
`sales_order_attachments`.`sales_order_id`
`sales_order_attachments`.`original_name`
`sales_order_attachments`.`file_path`
`sales_order_attachments`.`mime_type`
`sales_order_attachments`.`file_size`
`sales_order_attachments`.`created_at`
`sales_order_attachments`.`updated_at`
`sales_order_details`.*
`sales_order_details`.`id`
`sales_order_details`.`tenant_id`
`sales_order_details`.`sales_order_id`
`sales_order_details`.`item_id`
`sales_order_details`.`item_code`
`sales_order_details`.`item_name`
`sales_order_details`.`qty`
`sales_order_details`.`unit_price`
`sales_order_details`.`discount_percent`
`sales_order_details`.`discount_amount`
`sales_order_details`.`line_total`
`sales_order_details`.`note`
`sales_order_details`.`created_at`
`sales_order_details`.`updated_at`
`sales_orders`.*
`sales_orders`.`id`
`sales_orders`.`tenant_id`
`sales_orders`.`order_number`
`sales_orders`.`order_date`
`sales_orders`.`customer_id`
`sales_orders`.`sales_quotation_id`
`sales_orders`.`vat_rate_id`
`sales_orders`.`status`
`sales_orders`.`previous_status_before_processed`
`sales_orders`.`notes`
`sales_orders`.`subtotal`
`sales_orders`.`vat_percent`
`sales_orders`.`vat_amount`
`sales_orders`.`grand_total`
`sales_orders`.`created_at`
`sales_orders`.`updated_at`
`sales_quotation_attachments`.*
`sales_quotation_attachments`.`id`
`sales_quotation_attachments`.`tenant_id`
`sales_quotation_attachments`.`sales_quotation_id`
`sales_quotation_attachments`.`original_name`
`sales_quotation_attachments`.`file_path`
`sales_quotation_attachments`.`mime_type`
`sales_quotation_attachments`.`file_size`
`sales_quotation_attachments`.`created_at`
`sales_quotation_attachments`.`updated_at`
`sales_quotation_details`.*
`sales_quotation_details`.`id`
`sales_quotation_details`.`tenant_id`
`sales_quotation_details`.`sales_quotation_id`
`sales_quotation_details`.`item_id`
`sales_quotation_details`.`item_code`
`sales_quotation_details`.`item_name`
`sales_quotation_details`.`qty`
`sales_quotation_details`.`unit_price`
`sales_quotation_details`.`discount_percent`
`sales_quotation_details`.`discount_amount`
`sales_quotation_details`.`line_total`
`sales_quotation_details`.`note`
`sales_quotation_details`.`created_at`
`sales_quotation_details`.`updated_at`
`sales_quotations`.*
`sales_quotations`.`id`
`sales_quotations`.`tenant_id`
`sales_quotations`.`quotation_number`
`sales_quotations`.`quotation_date`
`sales_quotations`.`valid_until`
`sales_quotations`.`customer_id`
`sales_quotations`.`vat_rate_id`
`sales_quotations`.`status`
`sales_quotations`.`previous_status_before_processed`
`sales_quotations`.`notes`
`sales_quotations`.`subtotal`
`sales_quotations`.`vat_percent`
`sales_quotations`.`vat_amount`
`sales_quotations`.`grand_total`
`sales_quotations`.`created_at`
`sales_quotations`.`updated_at`
`sales_receipt_details`.*
`sales_receipt_details`.`id`
`sales_receipt_details`.`tenant_id`
`sales_receipt_details`.`sales_receipt_id`
`sales_receipt_details`.`sales_invoice_id`
`sales_receipt_details`.`paid_amount`
`sales_receipt_details`.`created_at`
`sales_receipt_details`.`updated_at`
`sales_receipts`.*
`sales_receipts`.`id`
`sales_receipts`.`tenant_id`
`sales_receipts`.`created_by`
`sales_receipts`.`updated_by`
`sales_receipts`.`customer_id`
`sales_receipts`.`bank_account_id`
`sales_receipts`.`receipt_number`
`sales_receipts`.`receipt_date`
`sales_receipts`.`paid_amount`
`sales_receipts`.`description`
`sales_receipts`.`account_receivable_id`
`sales_receipts`.`created_at`
`sales_receipts`.`updated_at`
`sales_return_details`.*
`sales_return_details`.`id`
`sales_return_details`.`tenant_id`
`sales_return_details`.`sales_return_id`
`sales_return_details`.`item_id`
`sales_return_details`.`item_code`
`sales_return_details`.`item_name`
`sales_return_details`.`qty`
`sales_return_details`.`unit_price`
`sales_return_details`.`line_total`
`sales_return_details`.`note`
`sales_return_details`.`created_at`
`sales_return_details`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`tenant_id`
`sales_returns`.`return_number`
`sales_returns`.`return_date`
`sales_returns`.`customer_id`
`sales_returns`.`warehouse_id`
`sales_returns`.`warehouse_rack_id`
`sales_returns`.`sales_invoice_id`
`sales_returns`.`status`
`sales_returns`.`notes`
`sales_returns`.`subtotal`
`sales_returns`.`grand_total`
`sales_returns`.`created_at`
`sales_returns`.`updated_at`
`sessions`.*
`sessions`.`id`
`sessions`.`user_id`
`sessions`.`ip_address`
`sessions`.`user_agent`
`sessions`.`payload`
`sessions`.`last_activity`
`stock_mutations`.*
`stock_mutations`.`id`
`stock_mutations`.`tenant_id`
`stock_mutations`.`warehouse_id`
`stock_mutations`.`warehouse_rack_id`
`stock_mutations`.`item_id`
`stock_mutations`.`transaction_date`
`stock_mutations`.`reference_number`
`stock_mutations`.`source_type`
`stock_mutations`.`source_id`
`stock_mutations`.`mutation_type`
`stock_mutations`.`direction`
`stock_mutations`.`quantity`
`stock_mutations`.`unit_cost`
`stock_mutations`.`total_cost`
`stock_mutations`.`description`
`stock_mutations`.`created_at`
`stock_mutations`.`updated_at`
`stock_transfer_details`.*
`stock_transfer_details`.`id`
`stock_transfer_details`.`tenant_id`
`stock_transfer_details`.`stock_transfer_id`
`stock_transfer_details`.`item_id`
`stock_transfer_details`.`from_warehouse_rack_id`
`stock_transfer_details`.`to_warehouse_rack_id`
`stock_transfer_details`.`item_code`
`stock_transfer_details`.`item_name`
`stock_transfer_details`.`qty`
`stock_transfer_details`.`unit_cost`
`stock_transfer_details`.`total_cost`
`stock_transfer_details`.`note`
`stock_transfer_details`.`created_at`
`stock_transfer_details`.`updated_at`
`stock_transfers`.*
`stock_transfers`.`id`
`stock_transfers`.`tenant_id`
`stock_transfers`.`transfer_number`
`stock_transfers`.`transfer_date`
`stock_transfers`.`from_warehouse_id`
`stock_transfers`.`to_warehouse_id`
`stock_transfers`.`status`
`stock_transfers`.`notes`
`stock_transfers`.`created_at`
`stock_transfers`.`updated_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`tenant_id`
`suppliers`.`is_active`
`suppliers`.`supplier_code`
`suppliers`.`supplier_name`
`suppliers`.`supplier_email`
`suppliers`.`supplier_address`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`tenant_user`.*
`tenant_user`.`tenant_id`
`tenant_user`.`user_id`
`tenant_user`.`role`
`tenant_user`.`is_owner`
`tenant_user`.`created_at`
`tenant_user`.`updated_at`
`tenant_user_roles`.*
`tenant_user_roles`.`tenant_id`
`tenant_user_roles`.`user_id`
`tenant_user_roles`.`role_id`
`tenant_user_roles`.`created_at`
`tenant_user_roles`.`updated_at`
`tenants`.*
`tenants`.`id`
`tenants`.`name`
`tenants`.`slug`
`tenants`.`is_active`
`tenants`.`created_at`
`tenants`.`updated_at`
`users`.*
`users`.`id`
`users`.`active_tenant_id`
`users`.`locale`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`profile_photo`
`users`.`created_at`
`users`.`updated_at`
`vat_rates`.*
`vat_rates`.`id`
`vat_rates`.`tenant_id`
`vat_rates`.`name`
`vat_rates`.`rate`
`vat_rates`.`is_active`
`vat_rates`.`created_at`
`vat_rates`.`updated_at`
`warehouse_racks`.*
`warehouse_racks`.`id`
`warehouse_racks`.`tenant_id`
`warehouse_racks`.`warehouse_id`
`warehouse_racks`.`rack_code`
`warehouse_racks`.`rack_name`
`warehouse_racks`.`description`
`warehouse_racks`.`is_active`
`warehouse_racks`.`created_at`
`warehouse_racks`.`updated_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`tenant_id`
`warehouses`.`is_active`
`warehouses`.`warehouse_code`
`warehouses`.`warehouse_name`
`warehouses`.`description`
`warehouses`.`created_at`
`warehouses`.`updated_at`
`abilities`.*
`abilities`.`id`
`abilities`.`tenant_id`
`abilities`.`name`
`abilities`.`description`
`abilities`.`created_at`
`abilities`.`updated_at`
`account_balances`.*
`account_balances`.`id`
`account_balances`.`tenant_id`
`account_balances`.`chart_of_account_id`
`account_balances`.`period`
`account_balances`.`opening_balance`
`account_balances`.`total_debit`
`account_balances`.`total_credit`
`account_balances`.`closing_balance`
`account_balances`.`created_at`
`account_balances`.`updated_at`
`account_types`.*
`account_types`.`id`
`account_types`.`is_active`
`account_types`.`name`
`account_types`.`created_at`
`account_types`.`updated_at`
`activity_logs`.*
`activity_logs`.`id`
`activity_logs`.`tenant_id`
`activity_logs`.`user_name`
`activity_logs`.`module`
`activity_logs`.`type`
`activity_logs`.`payload`
`activity_logs`.`created_at`
`activity_logs`.`updated_at`
`cache`.*
`cache`.`key`
`cache`.`value`
`cache`.`expiration`
`cache_locks`.*
`cache_locks`.`key`
`cache_locks`.`owner`
`cache_locks`.`expiration`
`cash_bank_payment_attachments`.*
`cash_bank_payment_attachments`.`id`
`cash_bank_payment_attachments`.`tenant_id`
`cash_bank_payment_attachments`.`cash_bank_payment_id`
`cash_bank_payment_attachments`.`original_name`
`cash_bank_payment_attachments`.`file_path`
`cash_bank_payment_attachments`.`mime_type`
`cash_bank_payment_attachments`.`file_size`
`cash_bank_payment_attachments`.`created_at`
`cash_bank_payment_attachments`.`updated_at`
`cash_bank_payment_details`.*
`cash_bank_payment_details`.`id`
`cash_bank_payment_details`.`tenant_id`
`cash_bank_payment_details`.`cash_bank_payment_id`
`cash_bank_payment_details`.`chart_of_account_id`
`cash_bank_payment_details`.`amount`
`cash_bank_payment_details`.`note`
`cash_bank_payment_details`.`created_at`
`cash_bank_payment_details`.`updated_at`
`cash_bank_payments`.*
`cash_bank_payments`.`id`
`cash_bank_payments`.`tenant_id`
`cash_bank_payments`.`chart_of_account_id`
`cash_bank_payments`.`payment_number`
`cash_bank_payments`.`payment_date`
`cash_bank_payments`.`description`
`cash_bank_payments`.`amount`
`cash_bank_payments`.`created_at`
`cash_bank_payments`.`updated_at`
`cash_bank_receipt_attachments`.*
`cash_bank_receipt_attachments`.`id`
`cash_bank_receipt_attachments`.`tenant_id`
`cash_bank_receipt_attachments`.`cash_bank_receipt_id`
`cash_bank_receipt_attachments`.`original_name`
`cash_bank_receipt_attachments`.`file_path`
`cash_bank_receipt_attachments`.`mime_type`
`cash_bank_receipt_attachments`.`file_size`
`cash_bank_receipt_attachments`.`created_at`
`cash_bank_receipt_attachments`.`updated_at`
`cash_bank_receipt_details`.*
`cash_bank_receipt_details`.`id`
`cash_bank_receipt_details`.`tenant_id`
`cash_bank_receipt_details`.`cash_bank_receipt_id`
`cash_bank_receipt_details`.`chart_of_account_id`
`cash_bank_receipt_details`.`amount`
`cash_bank_receipt_details`.`note`
`cash_bank_receipt_details`.`created_at`
`cash_bank_receipt_details`.`updated_at`
`cash_bank_receipts`.*
`cash_bank_receipts`.`id`
`cash_bank_receipts`.`tenant_id`
`cash_bank_receipts`.`chart_of_account_id`
`cash_bank_receipts`.`receipt_number`
`cash_bank_receipts`.`receipt_date`
`cash_bank_receipts`.`description`
`cash_bank_receipts`.`amount`
`cash_bank_receipts`.`created_at`
`cash_bank_receipts`.`updated_at`
`chart_of_accounts`.*
`chart_of_accounts`.`id`
`chart_of_accounts`.`tenant_id`
`chart_of_accounts`.`is_active`
`chart_of_accounts`.`parent_id`
`chart_of_accounts`.`account_type`
`chart_of_accounts`.`account_code`
`chart_of_accounts`.`account_name`
`chart_of_accounts`.`description`
`chart_of_accounts`.`created_at`
`chart_of_accounts`.`updated_at`
`company_preferences`.*
`company_preferences`.`id`
`company_preferences`.`tenant_id`
`company_preferences`.`chart_of_account_id`
`company_preferences`.`company_name`
`company_preferences`.`short_name`
`company_preferences`.`company_tax_id`
`company_preferences`.`company_phone`
`company_preferences`.`company_email`
`company_preferences`.`signatory_name`
`company_preferences`.`company_address`
`company_preferences`.`company_logo`
`company_preferences`.`created_at`
`company_preferences`.`updated_at`
`customers`.*
`customers`.`id`
`customers`.`tenant_id`
`customers`.`is_active`
`customers`.`customer_code`
`customers`.`customer_name`
`customers`.`tax_id`
`customers`.`address`
`customers`.`province`
`customers`.`sales_price_level`
`customers`.`created_at`
`customers`.`updated_at`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`uuid`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`general_journal_entries`.*
`general_journal_entries`.`id`
`general_journal_entries`.`tenant_id`
`general_journal_entries`.`entry_number`
`general_journal_entries`.`entry_date`
`general_journal_entries`.`description`
`general_journal_entries`.`total_debit`
`general_journal_entries`.`total_credit`
`general_journal_entries`.`created_at`
`general_journal_entries`.`updated_at`
`general_journal_entry_attachments`.*
`general_journal_entry_attachments`.`id`
`general_journal_entry_attachments`.`tenant_id`
`general_journal_entry_attachments`.`general_journal_entry_id`
`general_journal_entry_attachments`.`original_name`
`general_journal_entry_attachments`.`file_path`
`general_journal_entry_attachments`.`mime_type`
`general_journal_entry_attachments`.`file_size`
`general_journal_entry_attachments`.`created_at`
`general_journal_entry_attachments`.`updated_at`
`general_journal_entry_details`.*
`general_journal_entry_details`.`id`
`general_journal_entry_details`.`tenant_id`
`general_journal_entry_details`.`general_journal_entry_id`
`general_journal_entry_details`.`chart_of_account_id`
`general_journal_entry_details`.`debit`
`general_journal_entry_details`.`credit`
`general_journal_entry_details`.`note`
`general_journal_entry_details`.`created_at`
`general_journal_entry_details`.`updated_at`
`item_stock_balances`.*
`item_stock_balances`.`id`
`item_stock_balances`.`tenant_id`
`item_stock_balances`.`warehouse_id`
`item_stock_balances`.`warehouse_rack_id`
`item_stock_balances`.`item_id`
`item_stock_balances`.`balance_qty`
`item_stock_balances`.`balance_value`
`item_stock_balances`.`created_at`
`item_stock_balances`.`updated_at`
`items`.*
`items`.`id`
`items`.`tenant_id`
`items`.`is_active`
`items`.`item_code`
`items`.`item_name`
`items`.`inventory_type`
`items`.`description`
`items`.`average_cost`
`items`.`sales_price_level_1`
`items`.`sales_price_level_2`
`items`.`sales_price_level_3`
`items`.`sales_price_level_4`
`items`.`sales_price_level_5`
`items`.`sales_price_level_6`
`items`.`sales_price_level_7`
`items`.`sales_price_level_8`
`items`.`sales_price_level_9`
`items`.`sales_price_level_10`
`items`.`sales_price_level_11`
`items`.`sales_price_level_12`
`items`.`sales_price_level_13`
`items`.`sales_price_level_14`
`items`.`sales_price_level_15`
`items`.`sales_price_level_16`
`items`.`sales_price_level_17`
`items`.`sales_price_level_18`
`items`.`sales_price_level_19`
`items`.`sales_price_level_20`
`items`.`created_at`
`items`.`updated_at`
`items`.`cogs_account_id`
`items`.`revenue_account_id`
`items`.`sales_return_account_id`
`items`.`inventory_account_id`
`items`.`sales_discount_account_id`
`items`.`goods_sent_account_id`
`items`.`purchase_return_account_id`
`items`.`unbilled_account_id`
`job_batches`.*
`job_batches`.`id`
`job_batches`.`name`
`job_batches`.`total_jobs`
`job_batches`.`pending_jobs`
`job_batches`.`failed_jobs`
`job_batches`.`failed_job_ids`
`job_batches`.`options`
`job_batches`.`cancelled_at`
`job_batches`.`created_at`
`job_batches`.`finished_at`
`jobs`.*
`jobs`.`id`
`jobs`.`queue`
`jobs`.`payload`
`jobs`.`attempts`
`jobs`.`reserved_at`
`jobs`.`available_at`
`jobs`.`created_at`
`ledger_entries`.*
`ledger_entries`.`id`
`ledger_entries`.`tenant_id`
`ledger_entries`.`chart_of_account_id`
`ledger_entries`.`source_id`
`ledger_entries`.`transaction_date`
`ledger_entries`.`reference_number`
`ledger_entries`.`source_type`
`ledger_entries`.`amount`
`ledger_entries`.`mutation_type`
`ledger_entries`.`description`
`ledger_entries`.`created_at`
`ledger_entries`.`updated_at`
`menus`.*
`menus`.`id`
`menus`.`tenant_id`
`menus`.`menu_name`
`menus`.`route`
`menus`.`type`
`menus`.`parent_id`
`menus`.`sort_order`
`menus`.`icon`
`menus`.`is_active`
`menus`.`created_at`
`menus`.`updated_at`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`number_sequences`.*
`number_sequences`.`id`
`number_sequences`.`tenant_id`
`number_sequences`.`prefix`
`number_sequences`.`period`
`number_sequences`.`last_number`
`password_reset_tokens`.*
`password_reset_tokens`.`email`
`password_reset_tokens`.`token`
`password_reset_tokens`.`created_at`
`purchase_invoice_details`.*
`purchase_invoice_details`.`id`
`purchase_invoice_details`.`tenant_id`
`purchase_invoice_details`.`purchase_invoice_id`
`purchase_invoice_details`.`purchase_receipt_detail_id`
`purchase_invoice_details`.`item_id`
`purchase_invoice_details`.`item_code`
`purchase_invoice_details`.`item_name`
`purchase_invoice_details`.`quantity`
`purchase_invoice_details`.`item_price`
`purchase_invoice_details`.`discount_amount`
`purchase_invoice_details`.`subtotal`
`purchase_invoice_details`.`note`
`purchase_invoice_details`.`created_at`
`purchase_invoice_details`.`updated_at`
`purchase_invoices`.*
`purchase_invoices`.`id`
`purchase_invoices`.`tenant_id`
`purchase_invoices`.`supplier_id`
`purchase_invoices`.`purchase_receipt_id`
`purchase_invoices`.`account_payable_id`
`purchase_invoices`.`invoice_number`
`purchase_invoices`.`invoice_date`
`purchase_invoices`.`description`
`purchase_invoices`.`vat_amount`
`purchase_invoices`.`shipping_cost`
`purchase_invoices`.`paid_amount`
`purchase_invoices`.`process_status`
`purchase_invoices`.`created_by`
`purchase_invoices`.`updated_by`
`purchase_invoices`.`grand_total`
`purchase_invoices`.`due_date`
`purchase_invoices`.`order_date`
`purchase_invoices`.`created_at`
`purchase_invoices`.`updated_at`
`purchase_order_attachments`.*
`purchase_order_attachments`.`id`
`purchase_order_attachments`.`tenant_id`
`purchase_order_attachments`.`purchase_order_id`
`purchase_order_attachments`.`original_name`
`purchase_order_attachments`.`file_path`
`purchase_order_attachments`.`mime_type`
`purchase_order_attachments`.`file_size`
`purchase_order_attachments`.`created_at`
`purchase_order_attachments`.`updated_at`
`purchase_order_details`.*
`purchase_order_details`.`id`
`purchase_order_details`.`tenant_id`
`purchase_order_details`.`purchase_order_id`
`purchase_order_details`.`item_id`
`purchase_order_details`.`quantity`
`purchase_order_details`.`received_quantity`
`purchase_order_details`.`item_price`
`purchase_order_details`.`discount_percent`
`purchase_order_details`.`discount_amount`
`purchase_order_details`.`subtotal`
`purchase_order_details`.`note`
`purchase_order_details`.`created_at`
`purchase_order_details`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`tenant_id`
`purchase_orders`.`supplier_id`
`purchase_orders`.`purchase_request_id`
`purchase_orders`.`customer_id`
`purchase_orders`.`discount_account_id`
`purchase_orders`.`vat_account_id`
`purchase_orders`.`shipping_cost_account_id`
`purchase_orders`.`warehouse_id`
`purchase_orders`.`created_by`
`purchase_orders`.`updated_by`
`purchase_orders`.`order_number`
`purchase_orders`.`due_days`
`purchase_orders`.`order_date`
`purchase_orders`.`is_vat_applied`
`purchase_orders`.`vat_amount`
`purchase_orders`.`shipping_cost`
`purchase_orders`.`discount_percent`
`purchase_orders`.`discount_amount`
`purchase_orders`.`subtotal_before_discount`
`purchase_orders`.`subtotal_after_discount`
`purchase_orders`.`grand_total`
`purchase_orders`.`description`
`purchase_orders`.`process_status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_payment_details`.*
`purchase_payment_details`.`id`
`purchase_payment_details`.`tenant_id`
`purchase_payment_details`.`purchase_payment_id`
`purchase_payment_details`.`purchase_invoice_id`
`purchase_payment_details`.`paid_amount`
`purchase_payment_details`.`created_at`
`purchase_payment_details`.`updated_at`
`purchase_payments`.*
`purchase_payments`.`id`
`purchase_payments`.`tenant_id`
`purchase_payments`.`supplier_id`
`purchase_payments`.`bank_account_id`
`purchase_payments`.`created_by`
`purchase_payments`.`updated_by`
`purchase_payments`.`payment_number`
`purchase_payments`.`payment_date`
`purchase_payments`.`paid_amount`
`purchase_payments`.`description`
`purchase_payments`.`account_payable_id`
`purchase_payments`.`created_at`
`purchase_payments`.`updated_at`
`purchase_receipt_details`.*
`purchase_receipt_details`.`id`
`purchase_receipt_details`.`tenant_id`
`purchase_receipt_details`.`purchase_receipt_id`
`purchase_receipt_details`.`purchase_order_detail_id`
`purchase_receipt_details`.`item_id`
`purchase_receipt_details`.`item_code`
`purchase_receipt_details`.`item_name`
`purchase_receipt_details`.`qty`
`purchase_receipt_details`.`unit_price`
`purchase_receipt_details`.`line_total`
`purchase_receipt_details`.`note`
`purchase_receipt_details`.`created_at`
`purchase_receipt_details`.`updated_at`
`purchase_receipts`.*
`purchase_receipts`.`id`
`purchase_receipts`.`tenant_id`
`purchase_receipts`.`receipt_number`
`purchase_receipts`.`receipt_date`
`purchase_receipts`.`supplier_id`
`purchase_receipts`.`warehouse_id`
`purchase_receipts`.`warehouse_rack_id`
`purchase_receipts`.`purchase_order_id`
`purchase_receipts`.`status`
`purchase_receipts`.`notes`
`purchase_receipts`.`subtotal`
`purchase_receipts`.`grand_total`
`purchase_receipts`.`created_at`
`purchase_receipts`.`updated_at`
`purchase_request_attachments`.*
`purchase_request_attachments`.`id`
`purchase_request_attachments`.`tenant_id`
`purchase_request_attachments`.`purchase_request_id`
`purchase_request_attachments`.`original_name`
`purchase_request_attachments`.`file_path`
`purchase_request_attachments`.`mime_type`
`purchase_request_attachments`.`file_size`
`purchase_request_attachments`.`created_at`
`purchase_request_attachments`.`updated_at`
`purchase_request_details`.*
`purchase_request_details`.`id`
`purchase_request_details`.`tenant_id`
`purchase_request_details`.`purchase_request_id`
`purchase_request_details`.`item_id`
`purchase_request_details`.`item_code`
`purchase_request_details`.`item_name`
`purchase_request_details`.`qty`
`purchase_request_details`.`unit_price`
`purchase_request_details`.`discount_amount`
`purchase_request_details`.`line_total`
`purchase_request_details`.`note`
`purchase_request_details`.`created_at`
`purchase_request_details`.`updated_at`
`purchase_requests`.*
`purchase_requests`.`id`
`purchase_requests`.`tenant_id`
`purchase_requests`.`request_number`
`purchase_requests`.`request_date`
`purchase_requests`.`needed_date`
`purchase_requests`.`supplier_id`
`purchase_requests`.`status`
`purchase_requests`.`previous_status_before_processed`
`purchase_requests`.`notes`
`purchase_requests`.`subtotal`
`purchase_requests`.`grand_total`
`purchase_requests`.`created_at`
`purchase_requests`.`updated_at`
`purchase_return_details`.*
`purchase_return_details`.`id`
`purchase_return_details`.`tenant_id`
`purchase_return_details`.`purchase_return_id`
`purchase_return_details`.`purchase_invoice_detail_id`
`purchase_return_details`.`item_id`
`purchase_return_details`.`item_code`
`purchase_return_details`.`item_name`
`purchase_return_details`.`qty`
`purchase_return_details`.`unit_price`
`purchase_return_details`.`line_total`
`purchase_return_details`.`note`
`purchase_return_details`.`created_at`
`purchase_return_details`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`tenant_id`
`purchase_returns`.`supplier_id`
`purchase_returns`.`purchase_invoice_id`
`purchase_returns`.`account_payable_id`
`purchase_returns`.`return_number`
`purchase_returns`.`return_date`
`purchase_returns`.`status`
`purchase_returns`.`description`
`purchase_returns`.`grand_total`
`purchase_returns`.`created_by`
`purchase_returns`.`updated_by`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`role_ability`.*
`role_ability`.`role_id`
`role_ability`.`ability_id`
`role_ability`.`created_at`
`role_ability`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`tenant_id`
`roles`.`name`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales_deliveries`.*
`sales_deliveries`.`id`
`sales_deliveries`.`tenant_id`
`sales_deliveries`.`delivery_number`
`sales_deliveries`.`delivery_date`
`sales_deliveries`.`customer_id`
`sales_deliveries`.`warehouse_id`
`sales_deliveries`.`warehouse_rack_id`
`sales_deliveries`.`sales_order_id`
`sales_deliveries`.`sales_quotation_id`
`sales_deliveries`.`status`
`sales_deliveries`.`notes`
`sales_deliveries`.`subtotal`
`sales_deliveries`.`grand_total`
`sales_deliveries`.`created_at`
`sales_deliveries`.`updated_at`
`sales_delivery_attachments`.*
`sales_delivery_attachments`.`id`
`sales_delivery_attachments`.`tenant_id`
`sales_delivery_attachments`.`sales_delivery_id`
`sales_delivery_attachments`.`original_name`
`sales_delivery_attachments`.`file_path`
`sales_delivery_attachments`.`mime_type`
`sales_delivery_attachments`.`file_size`
`sales_delivery_attachments`.`created_at`
`sales_delivery_attachments`.`updated_at`
`sales_delivery_details`.*
`sales_delivery_details`.`id`
`sales_delivery_details`.`tenant_id`
`sales_delivery_details`.`sales_delivery_id`
`sales_delivery_details`.`item_id`
`sales_delivery_details`.`item_code`
`sales_delivery_details`.`item_name`
`sales_delivery_details`.`qty`
`sales_delivery_details`.`unit_price`
`sales_delivery_details`.`line_total`
`sales_delivery_details`.`note`
`sales_delivery_details`.`created_at`
`sales_delivery_details`.`updated_at`
`sales_invoice_attachments`.*
`sales_invoice_attachments`.`id`
`sales_invoice_attachments`.`tenant_id`
`sales_invoice_attachments`.`sales_invoice_id`
`sales_invoice_attachments`.`original_name`
`sales_invoice_attachments`.`file_path`
`sales_invoice_attachments`.`mime_type`
`sales_invoice_attachments`.`file_size`
`sales_invoice_attachments`.`created_at`
`sales_invoice_attachments`.`updated_at`
`sales_invoice_details`.*
`sales_invoice_details`.`id`
`sales_invoice_details`.`tenant_id`
`sales_invoice_details`.`sales_invoice_id`
`sales_invoice_details`.`item_id`
`sales_invoice_details`.`item_code`
`sales_invoice_details`.`item_name`
`sales_invoice_details`.`quantity`
`sales_invoice_details`.`price`
`sales_invoice_details`.`discount_percent`
`sales_invoice_details`.`discount_amount`
`sales_invoice_details`.`subtotal`
`sales_invoice_details`.`note`
`sales_invoice_details`.`created_at`
`sales_invoice_details`.`updated_at`
`sales_invoices`.*
`sales_invoices`.`id`
`sales_invoices`.`tenant_id`
`sales_invoices`.`customer_id`
`sales_invoices`.`warehouse_id`
`sales_invoices`.`warehouse_rack_id`
`sales_invoices`.`sales_order_id`
`sales_invoices`.`sales_delivery_id`
`sales_invoices`.`vat_rate_id`
`sales_invoices`.`account_receivable_id`
`sales_invoices`.`invoice_number`
`sales_invoices`.`invoice_date`
`sales_invoices`.`description`
`sales_invoices`.`vat_percent`
`sales_invoices`.`vat_amount`
`sales_invoices`.`discount_percent`
`sales_invoices`.`discount_amount`
`sales_invoices`.`grand_total`
`sales_invoices`.`paid_amount`
`sales_invoices`.`process_status`
`sales_invoices`.`created_by`
`sales_invoices`.`updated_by`
`sales_invoices`.`created_at`
`sales_invoices`.`updated_at`
`sales_order_attachments`.*
`sales_order_attachments`.`id`
`sales_order_attachments`.`tenant_id`
`sales_order_attachments`.`sales_order_id`
`sales_order_attachments`.`original_name`
`sales_order_attachments`.`file_path`
`sales_order_attachments`.`mime_type`
`sales_order_attachments`.`file_size`
`sales_order_attachments`.`created_at`
`sales_order_attachments`.`updated_at`
`sales_order_details`.*
`sales_order_details`.`id`
`sales_order_details`.`tenant_id`
`sales_order_details`.`sales_order_id`
`sales_order_details`.`item_id`
`sales_order_details`.`item_code`
`sales_order_details`.`item_name`
`sales_order_details`.`qty`
`sales_order_details`.`unit_price`
`sales_order_details`.`discount_percent`
`sales_order_details`.`discount_amount`
`sales_order_details`.`line_total`
`sales_order_details`.`note`
`sales_order_details`.`created_at`
`sales_order_details`.`updated_at`
`sales_orders`.*
`sales_orders`.`id`
`sales_orders`.`tenant_id`
`sales_orders`.`order_number`
`sales_orders`.`order_date`
`sales_orders`.`customer_id`
`sales_orders`.`sales_quotation_id`
`sales_orders`.`vat_rate_id`
`sales_orders`.`status`
`sales_orders`.`previous_status_before_processed`
`sales_orders`.`notes`
`sales_orders`.`subtotal`
`sales_orders`.`vat_percent`
`sales_orders`.`vat_amount`
`sales_orders`.`grand_total`
`sales_orders`.`created_at`
`sales_orders`.`updated_at`
`sales_quotation_attachments`.*
`sales_quotation_attachments`.`id`
`sales_quotation_attachments`.`tenant_id`
`sales_quotation_attachments`.`sales_quotation_id`
`sales_quotation_attachments`.`original_name`
`sales_quotation_attachments`.`file_path`
`sales_quotation_attachments`.`mime_type`
`sales_quotation_attachments`.`file_size`
`sales_quotation_attachments`.`created_at`
`sales_quotation_attachments`.`updated_at`
`sales_quotation_details`.*
`sales_quotation_details`.`id`
`sales_quotation_details`.`tenant_id`
`sales_quotation_details`.`sales_quotation_id`
`sales_quotation_details`.`item_id`
`sales_quotation_details`.`item_code`
`sales_quotation_details`.`item_name`
`sales_quotation_details`.`qty`
`sales_quotation_details`.`unit_price`
`sales_quotation_details`.`discount_percent`
`sales_quotation_details`.`discount_amount`
`sales_quotation_details`.`line_total`
`sales_quotation_details`.`note`
`sales_quotation_details`.`created_at`
`sales_quotation_details`.`updated_at`
`sales_quotations`.*
`sales_quotations`.`id`
`sales_quotations`.`tenant_id`
`sales_quotations`.`quotation_number`
`sales_quotations`.`quotation_date`
`sales_quotations`.`valid_until`
`sales_quotations`.`customer_id`
`sales_quotations`.`vat_rate_id`
`sales_quotations`.`status`
`sales_quotations`.`previous_status_before_processed`
`sales_quotations`.`notes`
`sales_quotations`.`subtotal`
`sales_quotations`.`vat_percent`
`sales_quotations`.`vat_amount`
`sales_quotations`.`grand_total`
`sales_quotations`.`created_at`
`sales_quotations`.`updated_at`
`sales_receipt_details`.*
`sales_receipt_details`.`id`
`sales_receipt_details`.`tenant_id`
`sales_receipt_details`.`sales_receipt_id`
`sales_receipt_details`.`sales_invoice_id`
`sales_receipt_details`.`paid_amount`
`sales_receipt_details`.`created_at`
`sales_receipt_details`.`updated_at`
`sales_receipts`.*
`sales_receipts`.`id`
`sales_receipts`.`tenant_id`
`sales_receipts`.`created_by`
`sales_receipts`.`updated_by`
`sales_receipts`.`customer_id`
`sales_receipts`.`bank_account_id`
`sales_receipts`.`receipt_number`
`sales_receipts`.`receipt_date`
`sales_receipts`.`paid_amount`
`sales_receipts`.`description`
`sales_receipts`.`account_receivable_id`
`sales_receipts`.`created_at`
`sales_receipts`.`updated_at`
`sales_return_details`.*
`sales_return_details`.`id`
`sales_return_details`.`tenant_id`
`sales_return_details`.`sales_return_id`
`sales_return_details`.`item_id`
`sales_return_details`.`item_code`
`sales_return_details`.`item_name`
`sales_return_details`.`qty`
`sales_return_details`.`unit_price`
`sales_return_details`.`line_total`
`sales_return_details`.`note`
`sales_return_details`.`created_at`
`sales_return_details`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`tenant_id`
`sales_returns`.`return_number`
`sales_returns`.`return_date`
`sales_returns`.`customer_id`
`sales_returns`.`warehouse_id`
`sales_returns`.`warehouse_rack_id`
`sales_returns`.`sales_invoice_id`
`sales_returns`.`status`
`sales_returns`.`notes`
`sales_returns`.`subtotal`
`sales_returns`.`grand_total`
`sales_returns`.`created_at`
`sales_returns`.`updated_at`
`sessions`.*
`sessions`.`id`
`sessions`.`user_id`
`sessions`.`ip_address`
`sessions`.`user_agent`
`sessions`.`payload`
`sessions`.`last_activity`
`stock_mutations`.*
`stock_mutations`.`id`
`stock_mutations`.`tenant_id`
`stock_mutations`.`warehouse_id`
`stock_mutations`.`warehouse_rack_id`
`stock_mutations`.`item_id`
`stock_mutations`.`transaction_date`
`stock_mutations`.`reference_number`
`stock_mutations`.`source_type`
`stock_mutations`.`source_id`
`stock_mutations`.`mutation_type`
`stock_mutations`.`direction`
`stock_mutations`.`quantity`
`stock_mutations`.`unit_cost`
`stock_mutations`.`total_cost`
`stock_mutations`.`description`
`stock_mutations`.`created_at`
`stock_mutations`.`updated_at`
`stock_transfer_details`.*
`stock_transfer_details`.`id`
`stock_transfer_details`.`tenant_id`
`stock_transfer_details`.`stock_transfer_id`
`stock_transfer_details`.`item_id`
`stock_transfer_details`.`from_warehouse_rack_id`
`stock_transfer_details`.`to_warehouse_rack_id`
`stock_transfer_details`.`item_code`
`stock_transfer_details`.`item_name`
`stock_transfer_details`.`qty`
`stock_transfer_details`.`unit_cost`
`stock_transfer_details`.`total_cost`
`stock_transfer_details`.`note`
`stock_transfer_details`.`created_at`
`stock_transfer_details`.`updated_at`
`stock_transfers`.*
`stock_transfers`.`id`
`stock_transfers`.`tenant_id`
`stock_transfers`.`transfer_number`
`stock_transfers`.`transfer_date`
`stock_transfers`.`from_warehouse_id`
`stock_transfers`.`to_warehouse_id`
`stock_transfers`.`status`
`stock_transfers`.`notes`
`stock_transfers`.`created_at`
`stock_transfers`.`updated_at`
`suppliers`.*
`suppliers`.`id`
`suppliers`.`tenant_id`
`suppliers`.`is_active`
`suppliers`.`supplier_code`
`suppliers`.`supplier_name`
`suppliers`.`supplier_email`
`suppliers`.`supplier_address`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`tenant_user`.*
`tenant_user`.`tenant_id`
`tenant_user`.`user_id`
`tenant_user`.`role`
`tenant_user`.`is_owner`
`tenant_user`.`created_at`
`tenant_user`.`updated_at`
`tenant_user_roles`.*
`tenant_user_roles`.`tenant_id`
`tenant_user_roles`.`user_id`
`tenant_user_roles`.`role_id`
`tenant_user_roles`.`created_at`
`tenant_user_roles`.`updated_at`
`tenants`.*
`tenants`.`id`
`tenants`.`name`
`tenants`.`slug`
`tenants`.`is_active`
`tenants`.`created_at`
`tenants`.`updated_at`
`users`.*
`users`.`id`
`users`.`active_tenant_id`
`users`.`locale`
`users`.`name`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`profile_photo`
`users`.`created_at`
`users`.`updated_at`
`vat_rates`.*
`vat_rates`.`id`
`vat_rates`.`tenant_id`
`vat_rates`.`name`
`vat_rates`.`rate`
`vat_rates`.`is_active`
`vat_rates`.`created_at`
`vat_rates`.`updated_at`
`warehouse_racks`.*
`warehouse_racks`.`id`
`warehouse_racks`.`tenant_id`
`warehouse_racks`.`warehouse_id`
`warehouse_racks`.`rack_code`
`warehouse_racks`.`rack_name`
`warehouse_racks`.`description`
`warehouse_racks`.`is_active`
`warehouse_racks`.`created_at`
`warehouse_racks`.`updated_at`
`warehouses`.*
`warehouses`.`id`
`warehouses`.`tenant_id`
`warehouses`.`is_active`
`warehouses`.`warehouse_code`
`warehouses`.`warehouse_name`
`warehouses`.`description`
`warehouses`.`created_at`
`warehouses`.`updated_at`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
abilities
account_balances
account_types
activity_logs
cache
cache_locks
cash_bank_payment_attachments
cash_bank_payment_details
cash_bank_payments
cash_bank_receipt_attachments
cash_bank_receipt_details
cash_bank_receipts
chart_of_accounts
company_preferences
customers
failed_jobs
general_journal_entries
general_journal_entry_attachments
general_journal_entry_details
item_stock_balances
items
job_batches
jobs
ledger_entries
menus
migrations
number_sequences
password_reset_tokens
purchase_invoice_details
purchase_invoices
purchase_order_attachments
purchase_order_details
purchase_orders
purchase_payment_details
purchase_payments
purchase_receipt_details
purchase_receipts
purchase_request_attachments
purchase_request_details
purchase_requests
purchase_return_details
purchase_returns
role_ability
roles
sales_deliveries
sales_delivery_attachments
sales_delivery_details
sales_invoice_attachments
sales_invoice_details
sales_invoices
sales_order_attachments
sales_order_details
sales_orders
sales_quotation_attachments
sales_quotation_details
sales_quotations
sales_receipt_details
sales_receipts
sales_return_details
sales_returns
sessions
stock_mutations
stock_transfer_details
stock_transfers
suppliers
tenant_user
tenant_user_roles
tenants
users
vat_rates
warehouse_racks
warehouses
SQL query on database
sistem
: