Recent
`ecommerce_db`.`attribute_value_translations`
`ecommerce_db`.`role_permissions`
`biotimedb`.`payroll_salarystructure_exceptionformula`
`biotimedb`.`att_payloadtimecard`
`biotimedb`.`iclock_transaction`
`delivery_db_new`.`branches`
`biotimedb`.`payroll_extradeduction`
`invoice_db`.`ip_invoice_item_amounts`
`biotimedb`.`attparam`
`ecommerce_db`.`permissions`
Favourites
There are no favourite tables.
X
New
alnaqeeb_charity
bagisto
biotimedb
charity
charity
charity_test
delivery_db
delivery_db
delivery_db_new
ecommerce_db
emp_track_db
enjazi_db
enjaz_workflow
enterprise_workflow
goal_tracker
hr_complaint_app
icehrm_db
ims
information_schema
inventory_management
invoice_db
jobapplications
kalkun
mysql
opencart_db
performance_schema
phpmyadmin
sales
sales_inventory_db
sales_management
supermarket_app
test
the_old_database
ticket_app_db
ticket_app_db
ticket_app_db_test
velstore
warehouse
warehouse_inventory
warehouse_management
warehouse_supplychain
workflow
zk_attendance
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise 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.
Favourite tables
Maximum number of favourite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customise 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: sales_management
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:
`bank`.*
`bank`.`id`
`bank`.`bank_name`
`bank`.`bank_name_ar`
`bank`.`account_number`
`bank`.`account_holder`
`bank`.`description`
`bank`.`is_active`
`bank`.`currency_id`
`bank`.`money`
`bank`.`created_at`
`bank`.`updated_at`
`bank_insert`.*
`bank_insert`.`id`
`bank_insert`.`bank_id`
`bank_insert`.`money`
`bank_insert`.`currency_id`
`bank_insert`.`exchange_rate`
`bank_insert`.`base_currency_amount`
`bank_insert`.`date`
`bank_insert`.`name`
`bank_insert`.`reason`
`bank_insert`.`created_at`
`bank_insert`.`updated_at`
`bank_pull`.*
`bank_pull`.`id`
`bank_pull`.`bank_id`
`bank_pull`.`money`
`bank_pull`.`currency_id`
`bank_pull`.`exchange_rate`
`bank_pull`.`base_currency_amount`
`bank_pull`.`date`
`bank_pull`.`name`
`bank_pull`.`reason`
`bank_pull`.`created_at`
`bank_pull`.`updated_at`
`batch_adjustments`.*
`batch_adjustments`.`id`
`batch_adjustments`.`batch_id`
`batch_adjustments`.`adjustment_qty`
`batch_adjustments`.`reason_code`
`batch_adjustments`.`notes`
`batch_adjustments`.`user_id`
`batch_adjustments`.`adjustment_date`
`batch_adjustments`.`created_at`
`batch_transactions`.*
`batch_transactions`.`id`
`batch_transactions`.`batch_id`
`batch_transactions`.`sales_detail_id`
`batch_transactions`.`buy_detail_id`
`batch_transactions`.`quantity`
`batch_transactions`.`unit_price`
`batch_transactions`.`transaction_date`
`batch_transactions`.`transaction_type`
`batch_transactions`.`created_at`
`buy`.*
`buy`.`order_id`
`buy`.`date`
`buy`.`due_date`
`buy`.`payment_status`
`buy`.`sup_id`
`buy`.`store_id`
`buy_details`.*
`buy_details`.`id`
`buy_details`.`order_id`
`buy_details`.`sup_id`
`buy_details`.`pro_id`
`buy_details`.`date`
`buy_details`.`qty`
`buy_details`.`unit_id`
`buy_details`.`user_name`
`buy_details`.`price`
`buy_details`.`discount`
`buy_details`.`total`
`buy_details`.`total_order`
`buy_details`.`madfoua`
`buy_details`.`bakey`
`buy_details`.`tax_value`
`buy_details`.`price_tax`
`buy_details`.`time`
`buy_details`.`unit_name`
`buy_details`.`currency_id`
`buy_details`.`exchange_rate`
`buy_details`.`base_currency_total`
`currencies`.*
`currencies`.`id`
`currencies`.`code`
`currencies`.`name`
`currencies`.`name_ar`
`currencies`.`symbol`
`currencies`.`is_base`
`currencies`.`is_active`
`currencies`.`created_at`
`currencies`.`updated_at`
`customer_money`.*
`customer_money`.`id`
`customer_money`.`cust_id`
`customer_money`.`cust_name`
`customer_money`.`money`
`customer_money`.`date`
`customer_money`.`created_at`
`customer_money`.`updated_at`
`customer_report`.*
`customer_report`.`id`
`customer_report`.`cust_id`
`customer_report`.`cust_name`
`customer_report`.`total`
`customer_report`.`madfoua`
`customer_report`.`bakey`
`customer_report`.`date`
`customer_report`.`order_id`
`customer_report`.`created_at`
`customer_report`.`updated_at`
`customers`.*
`customers`.`cust_id`
`customers`.`cust_name`
`customers`.`cust_address`
`customers`.`cust_phone`
`customers`.`notes`
`customers`.`payment_terms`
`customers`.`credit_limit`
`customers`.`created_at`
`customers`.`updated_at`
`deserved`.*
`deserved`.`des_id`
`deserved`.`price`
`deserved`.`date`
`deserved`.`notes`
`deserved`.`type_id`
`deserved`.`currency_id`
`deserved`.`exchange_rate`
`deserved`.`stock_account_id`
`deserved`.`user_id`
`deserved`.`stock_pull_id`
`deserved_type`.*
`deserved_type`.`des_id`
`deserved_type`.`name`
`deserved_type`.`name_ar`
`employee`.*
`employee`.`emp_id`
`employee`.`emp_name`
`employee`.`salary`
`employee`.`date`
`employee`.`national_id`
`employee`.`emp_phone`
`employee`.`emp_address`
`employee_borrow_items`.*
`employee_borrow_items`.`id`
`employee_borrow_items`.`emp_id`
`employee_borrow_items`.`item_name`
`employee_borrow_items`.`quantity`
`employee_borrow_items`.`borrow_date`
`employee_borrow_items`.`return_date`
`employee_borrow_items`.`notes`
`employee_borrow_items`.`is_returned`
`employee_borrow_money`.*
`employee_borrow_money`.`id`
`employee_borrow_money`.`emp_id`
`employee_borrow_money`.`amount`
`employee_borrow_money`.`borrow_date`
`employee_borrow_money`.`due_date`
`employee_borrow_money`.`notes`
`employee_borrow_money`.`is_returned`
`employee_salary`.*
`employee_salary`.`id`
`employee_salary`.`emp_id`
`employee_salary`.`salary`
`employee_salary`.`date`
`employee_salary`.`notes`
`employee_salary_minus`.*
`employee_salary_minus`.`id`
`employee_salary_minus`.`emp_id`
`employee_salary_minus`.`minus_amount`
`employee_salary_minus`.`date`
`employee_salary_minus`.`reason`
`exchange_rates`.*
`exchange_rates`.`id`
`exchange_rates`.`currency_id`
`exchange_rates`.`rate`
`exchange_rates`.`date`
`exchange_rates`.`source`
`exchange_rates`.`created_at`
`exchange_rates`.`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`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`order_print_data`.*
`order_print_data`.`id`
`order_print_data`.`logo`
`order_print_data`.`name`
`order_print_data`.`name_ar`
`order_print_data`.`address`
`order_print_data`.`address_ar`
`order_print_data`.`description`
`order_print_data`.`description_ar`
`order_print_data`.`phone1`
`order_print_data`.`phone2`
`password_reset_tokens`.*
`password_reset_tokens`.`email`
`password_reset_tokens`.`token`
`password_reset_tokens`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`display_name`
`permissions`.`module`
`permissions`.`action`
`permissions`.`description`
`permissions`.`created_at`
`permissions`.`updated_at`
`personal_access_tokens`.*
`personal_access_tokens`.`id`
`personal_access_tokens`.`tokenable_type`
`personal_access_tokens`.`tokenable_id`
`personal_access_tokens`.`name`
`personal_access_tokens`.`token`
`personal_access_tokens`.`abilities`
`personal_access_tokens`.`last_used_at`
`personal_access_tokens`.`expires_at`
`personal_access_tokens`.`created_at`
`personal_access_tokens`.`updated_at`
`product_batches`.*
`product_batches`.`batch_id`
`product_batches`.`batch_number`
`product_batches`.`barcode`
`product_batches`.`pro_id`
`product_batches`.`purchase_order_id`
`product_batches`.`purchase_price`
`product_batches`.`quantity`
`product_batches`.`remaining_qty`
`product_batches`.`purchase_date`
`product_batches`.`expiry_date`
`product_batches`.`manufacturing_date`
`product_batches`.`supplier_id`
`product_batches`.`supplier_batch_number`
`product_batches`.`notes`
`product_batches`.`status`
`product_batches`.`created_at`
`product_batches`.`updated_at`
`products`.*
`products`.`pro_id`
`products`.`pro_name`
`products`.`pro_name_ar`
`products`.`qty`
`products`.`gomla_price`
`products`.`sale_price`
`products`.`tax_value`
`products`.`sale_price_tax`
`products`.`barcode`
`products`.`min_qty`
`products`.`max_discount`
`products`.`is_tax`
`products`.`group_id`
`products`.`main_unit_name`
`products`.`main_unit_id`
`products`.`sale_unit_name`
`products`.`sale_unit_id`
`products`.`buy_unit_name`
`products`.`buy_unit_id`
`products`.`currency_id`
`products`.`batch_tracking_enabled`
`products`.`created_at`
`products`.`updated_at`
`products_group`.*
`products_group`.`group_id`
`products_group`.`group_name`
`products_group`.`group_name_ar`
`products_group`.`created_at`
`products_group`.`updated_at`
`products_outstore`.*
`products_outstore`.`id`
`products_outstore`.`pro_id`
`products_outstore`.`store_id`
`products_outstore`.`qty`
`products_outstore`.`unit`
`products_outstore`.`date`
`products_outstore`.`name`
`products_outstore`.`reason`
`products_outstore`.`created_at`
`products_outstore`.`updated_at`
`products_qty`.*
`products_qty`.`id`
`products_qty`.`pro_id`
`products_qty`.`store_id`
`products_qty`.`store_name`
`products_qty`.`qty`
`products_qty`.`buy_price`
`products_qty`.`sale_price_tax`
`products_qty`.`created_at`
`products_qty`.`updated_at`
`products_transfer`.*
`products_transfer`.`id`
`products_transfer`.`pro_id`
`products_transfer`.`store_from`
`products_transfer`.`store_to`
`products_transfer`.`qty`
`products_transfer`.`unit`
`products_transfer`.`buy_price`
`products_transfer`.`sale_price`
`products_transfer`.`date`
`products_transfer`.`name`
`products_transfer`.`reason`
`products_transfer`.`created_at`
`products_transfer`.`updated_at`
`products_unit`.*
`products_unit`.`id`
`products_unit`.`pro_id`
`products_unit`.`unit_id`
`products_unit`.`unit_name`
`products_unit`.`qty_in_main`
`products_unit`.`unit_sale_price`
`products_unit`.`total_sale_price`
`products_unit`.`created_at`
`products_unit`.`updated_at`
`purchase_return_details`.*
`purchase_return_details`.`id`
`purchase_return_details`.`return_id`
`purchase_return_details`.`buy_detail_id`
`purchase_return_details`.`pro_id`
`purchase_return_details`.`store_id`
`purchase_return_details`.`qty`
`purchase_return_details`.`unit_id`
`purchase_return_details`.`qty_in_main_unit`
`purchase_return_details`.`price`
`purchase_return_details`.`discount`
`purchase_return_details`.`total`
`purchase_return_details`.`currency_id`
`purchase_return_details`.`exchange_rate`
`purchase_return_details`.`base_currency_total`
`purchase_return_details`.`created_at`
`purchase_return_details`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`return_id`
`purchase_returns`.`order_id`
`purchase_returns`.`sup_id`
`purchase_returns`.`store_id`
`purchase_returns`.`return_date`
`purchase_returns`.`return_reason`
`purchase_returns`.`total_amount`
`purchase_returns`.`currency_id`
`purchase_returns`.`exchange_rate`
`purchase_returns`.`base_currency_total`
`purchase_returns`.`user_name`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`random_barcode`.*
`random_barcode`.`id`
`random_barcode`.`barcode`
`random_barcode`.`is_used`
`random_barcode`.`pro_id`
`random_barcode`.`created_at`
`random_barcode`.`updated_at`
`report_schedules`.*
`report_schedules`.`id`
`report_schedules`.`user_id`
`report_schedules`.`report_type`
`report_schedules`.`frequency`
`report_schedules`.`parameters`
`report_schedules`.`recipients`
`report_schedules`.`last_run_at`
`report_schedules`.`next_run_at`
`report_schedules`.`status`
`report_schedules`.`created_at`
`report_schedules`.`updated_at`
`returns`.*
`returns`.`id`
`returns`.`order_date`
`returns`.`order_type`
`returns`.`created_at`
`returns`.`updated_at`
`returns_details`.*
`returns_details`.`id`
`returns_details`.`order_id`
`returns_details`.`sup_name`
`returns_details`.`cust_name`
`returns_details`.`pro_name`
`returns_details`.`pro_id`
`returns_details`.`date`
`returns_details`.`qty`
`returns_details`.`price`
`returns_details`.`total`
`returns_details`.`user_name`
`returns_details`.`total_order`
`returns_details`.`madfoua`
`returns_details`.`bakey`
`returns_details`.`tax_value`
`returns_details`.`price_tax`
`returns_details`.`unit_id`
`returns_details`.`time`
`returns_details`.`currency_id`
`returns_details`.`exchange_rate`
`returns_details`.`base_currency_total`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`permission_id`
`role_permissions`.`created_at`
`role_permissions`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`display_name`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales`.*
`sales`.`order_id`
`sales`.`date`
`sales`.`due_date`
`sales`.`payment_status`
`sales`.`cust_name`
`sales`.`store_id`
`sales_batch_items`.*
`sales_batch_items`.`id`
`sales_batch_items`.`sales_detail_id`
`sales_batch_items`.`batch_id`
`sales_batch_items`.`qty_from_batch`
`sales_batch_items`.`cost_per_unit`
`sales_batch_items`.`total_cost`
`sales_batch_items`.`created_at`
`sales_batch_items`.`updated_at`
`sales_details`.*
`sales_details`.`id`
`sales_details`.`order_id`
`sales_details`.`cust_name`
`sales_details`.`pro_id`
`sales_details`.`date`
`sales_details`.`qty`
`sales_details`.`user_name`
`sales_details`.`price`
`sales_details`.`discount`
`sales_details`.`total`
`sales_details`.`total_order`
`sales_details`.`madfoua`
`sales_details`.`bakey`
`sales_details`.`unit_id`
`sales_details`.`tax_value`
`sales_details`.`price_tax`
`sales_details`.`time`
`sales_details`.`currency_id`
`sales_details`.`exchange_rate`
`sales_details`.`base_currency_total`
`sales_details`.`cogs`
`sales_rbyh`.*
`sales_rbyh`.`id`
`sales_rbyh`.`order_id`
`sales_rbyh`.`pro_id`
`sales_rbyh`.`pro_name`
`sales_rbyh`.`qty`
`sales_rbyh`.`buy_price`
`sales_rbyh`.`sale_price`
`sales_rbyh`.`rbyh`
`sales_rbyh`.`date`
`sales_rbyh`.`user_name`
`sales_rbyh`.`currency_id`
`sales_rbyh`.`exchange_rate`
`sales_rbyh`.`base_currency_rbyh`
`sales_return_details`.*
`sales_return_details`.`id`
`sales_return_details`.`return_id`
`sales_return_details`.`sales_detail_id`
`sales_return_details`.`pro_id`
`sales_return_details`.`store_id`
`sales_return_details`.`qty`
`sales_return_details`.`unit_id`
`sales_return_details`.`qty_in_main_unit`
`sales_return_details`.`price`
`sales_return_details`.`discount`
`sales_return_details`.`total`
`sales_return_details`.`currency_id`
`sales_return_details`.`exchange_rate`
`sales_return_details`.`base_currency_total`
`sales_return_details`.`cogs`
`sales_return_details`.`created_at`
`sales_return_details`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`return_id`
`sales_returns`.`order_id`
`sales_returns`.`cust_name`
`sales_returns`.`store_id`
`sales_returns`.`return_date`
`sales_returns`.`return_reason`
`sales_returns`.`total_amount`
`sales_returns`.`currency_id`
`sales_returns`.`exchange_rate`
`sales_returns`.`base_currency_total`
`sales_returns`.`user_name`
`sales_returns`.`created_at`
`sales_returns`.`updated_at`
`sanad_kabd`.*
`sanad_kabd`.`order_id`
`sanad_kabd`.`customer_id`
`sanad_kabd`.`name`
`sanad_kabd`.`price`
`sanad_kabd`.`currency_id`
`sanad_kabd`.`exchange_rate`
`sanad_kabd`.`base_currency_amount`
`sanad_kabd`.`date`
`sanad_kabd`.`from_`
`sanad_kabd`.`reason`
`sanad_kabd`.`payment_allocations`
`sanad_kabd`.`created_at`
`sanad_kabd`.`updated_at`
`sanad_kabd_allocations`.*
`sanad_kabd_allocations`.`id`
`sanad_kabd_allocations`.`sanad_kabd_id`
`sanad_kabd_allocations`.`sales_order_id`
`sanad_kabd_allocations`.`allocated_amount`
`sanad_kabd_allocations`.`base_currency_amount`
`sanad_kabd_allocations`.`created_at`
`sanad_sarf`.*
`sanad_sarf`.`order_id`
`sanad_sarf`.`supplier_id`
`sanad_sarf`.`name`
`sanad_sarf`.`price`
`sanad_sarf`.`currency_id`
`sanad_sarf`.`exchange_rate`
`sanad_sarf`.`base_currency_amount`
`sanad_sarf`.`date`
`sanad_sarf`.`to_`
`sanad_sarf`.`reason`
`sanad_sarf`.`payment_allocations`
`sanad_sarf`.`created_at`
`sanad_sarf`.`updated_at`
`sanad_sarf_allocations`.*
`sanad_sarf_allocations`.`id`
`sanad_sarf_allocations`.`sanad_sarf_id`
`sanad_sarf_allocations`.`purchase_order_id`
`sanad_sarf_allocations`.`allocated_amount`
`sanad_sarf_allocations`.`base_currency_amount`
`sanad_sarf_allocations`.`created_at`
`stock`.*
`stock`.`id`
`stock`.`stock_id`
`stock`.`money`
`stock`.`created_at`
`stock`.`updated_at`
`stock_bank_transfer`.*
`stock_bank_transfer`.`id`
`stock_bank_transfer`.`transfer_type`
`stock_bank_transfer`.`stock_id`
`stock_bank_transfer`.`bank_id`
`stock_bank_transfer`.`money`
`stock_bank_transfer`.`currency_id`
`stock_bank_transfer`.`exchange_rate`
`stock_bank_transfer`.`base_currency_amount`
`stock_bank_transfer`.`date`
`stock_bank_transfer`.`name`
`stock_bank_transfer`.`reason`
`stock_bank_transfer`.`created_at`
`stock_bank_transfer`.`updated_at`
`stock_data`.*
`stock_data`.`stock_id`
`stock_data`.`stock_name`
`stock_data`.`stock_name_ar`
`stock_data`.`description`
`stock_data`.`money`
`stock_data`.`is_active`
`stock_data`.`currency_id`
`stock_insert`.*
`stock_insert`.`id`
`stock_insert`.`stock_id`
`stock_insert`.`money`
`stock_insert`.`currency_id`
`stock_insert`.`exchange_rate`
`stock_insert`.`base_currency_amount`
`stock_insert`.`date`
`stock_insert`.`name`
`stock_insert`.`reason`
`stock_insert`.`created_at`
`stock_insert`.`updated_at`
`stock_pull`.*
`stock_pull`.`id`
`stock_pull`.`stock_id`
`stock_pull`.`money`
`stock_pull`.`currency_id`
`stock_pull`.`exchange_rate`
`stock_pull`.`base_currency_amount`
`stock_pull`.`date`
`stock_pull`.`name`
`stock_pull`.`reason`
`stock_pull`.`created_at`
`stock_pull`.`updated_at`
`stock_transfer`.*
`stock_transfer`.`id`
`stock_transfer`.`from_stock_id`
`stock_transfer`.`to_stock_id`
`stock_transfer`.`money`
`stock_transfer`.`currency_id`
`stock_transfer`.`exchange_rate`
`stock_transfer`.`base_currency_amount`
`stock_transfer`.`date`
`stock_transfer`.`name`
`stock_transfer`.`reason`
`stock_transfer`.`created_at`
`stock_transfer`.`updated_at`
`store`.*
`store`.`store_id`
`store`.`store_name`
`store`.`created_at`
`store`.`updated_at`
`suppliers`.*
`suppliers`.`sup_id`
`suppliers`.`sup_name`
`suppliers`.`sup_address`
`suppliers`.`sup_phone`
`suppliers`.`notes`
`suppliers`.`payment_terms`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers_money`.*
`suppliers_money`.`id`
`suppliers_money`.`sup_id`
`suppliers_money`.`sup_name`
`suppliers_money`.`money`
`suppliers_money`.`date`
`suppliers_money`.`created_at`
`suppliers_money`.`updated_at`
`suppliers_report`.*
`suppliers_report`.`id`
`suppliers_report`.`sup_id`
`suppliers_report`.`sup_name`
`suppliers_report`.`total`
`suppliers_report`.`madfoua`
`suppliers_report`.`bakey`
`suppliers_report`.`date`
`suppliers_report`.`order_id`
`suppliers_report`.`created_at`
`suppliers_report`.`updated_at`
`units`.*
`units`.`unit_id`
`units`.`unit_name`
`units`.`unit_name_ar`
`units`.`created_at`
`units`.`updated_at`
`user_buy`.*
`user_buy`.`id`
`user_buy`.`user_id`
`user_buy`.`can_access`
`user_buy`.`created_at`
`user_buy`.`updated_at`
`user_customers`.*
`user_customers`.`id`
`user_customers`.`user_id`
`user_customers`.`can_access`
`user_customers`.`created_at`
`user_customers`.`updated_at`
`user_finance`.*
`user_finance`.`id`
`user_finance`.`user_id`
`user_finance`.`can_access`
`user_finance`.`created_at`
`user_finance`.`updated_at`
`user_inventory`.*
`user_inventory`.`id`
`user_inventory`.`user_id`
`user_inventory`.`can_access`
`user_inventory`.`created_at`
`user_inventory`.`updated_at`
`user_reports`.*
`user_reports`.`id`
`user_reports`.`user_id`
`user_reports`.`can_access`
`user_reports`.`created_at`
`user_reports`.`updated_at`
`user_roles`.*
`user_roles`.`id`
`user_roles`.`user_id`
`user_roles`.`role_id`
`user_roles`.`created_at`
`user_roles`.`updated_at`
`user_sale`.*
`user_sale`.`id`
`user_sale`.`user_id`
`user_sale`.`can_access`
`user_sale`.`created_at`
`user_sale`.`updated_at`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`can_access`
`user_settings`.`created_at`
`user_settings`.`updated_at`
`user_suppliers`.*
`user_suppliers`.`id`
`user_suppliers`.`user_id`
`user_suppliers`.`can_access`
`user_suppliers`.`created_at`
`user_suppliers`.`updated_at`
`users`.*
`users`.`id`
`users`.`user_name`
`users`.`user_password`
`users`.`type`
`users`.`role_id`
`users`.`stock_id`
`users`.`rbyh`
`users`.`language`
`users`.`currency_id`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`bank`.*
`bank`.`id`
`bank`.`bank_name`
`bank`.`bank_name_ar`
`bank`.`account_number`
`bank`.`account_holder`
`bank`.`description`
`bank`.`is_active`
`bank`.`currency_id`
`bank`.`money`
`bank`.`created_at`
`bank`.`updated_at`
`bank_insert`.*
`bank_insert`.`id`
`bank_insert`.`bank_id`
`bank_insert`.`money`
`bank_insert`.`currency_id`
`bank_insert`.`exchange_rate`
`bank_insert`.`base_currency_amount`
`bank_insert`.`date`
`bank_insert`.`name`
`bank_insert`.`reason`
`bank_insert`.`created_at`
`bank_insert`.`updated_at`
`bank_pull`.*
`bank_pull`.`id`
`bank_pull`.`bank_id`
`bank_pull`.`money`
`bank_pull`.`currency_id`
`bank_pull`.`exchange_rate`
`bank_pull`.`base_currency_amount`
`bank_pull`.`date`
`bank_pull`.`name`
`bank_pull`.`reason`
`bank_pull`.`created_at`
`bank_pull`.`updated_at`
`batch_adjustments`.*
`batch_adjustments`.`id`
`batch_adjustments`.`batch_id`
`batch_adjustments`.`adjustment_qty`
`batch_adjustments`.`reason_code`
`batch_adjustments`.`notes`
`batch_adjustments`.`user_id`
`batch_adjustments`.`adjustment_date`
`batch_adjustments`.`created_at`
`batch_transactions`.*
`batch_transactions`.`id`
`batch_transactions`.`batch_id`
`batch_transactions`.`sales_detail_id`
`batch_transactions`.`buy_detail_id`
`batch_transactions`.`quantity`
`batch_transactions`.`unit_price`
`batch_transactions`.`transaction_date`
`batch_transactions`.`transaction_type`
`batch_transactions`.`created_at`
`buy`.*
`buy`.`order_id`
`buy`.`date`
`buy`.`due_date`
`buy`.`payment_status`
`buy`.`sup_id`
`buy`.`store_id`
`buy_details`.*
`buy_details`.`id`
`buy_details`.`order_id`
`buy_details`.`sup_id`
`buy_details`.`pro_id`
`buy_details`.`date`
`buy_details`.`qty`
`buy_details`.`unit_id`
`buy_details`.`user_name`
`buy_details`.`price`
`buy_details`.`discount`
`buy_details`.`total`
`buy_details`.`total_order`
`buy_details`.`madfoua`
`buy_details`.`bakey`
`buy_details`.`tax_value`
`buy_details`.`price_tax`
`buy_details`.`time`
`buy_details`.`unit_name`
`buy_details`.`currency_id`
`buy_details`.`exchange_rate`
`buy_details`.`base_currency_total`
`currencies`.*
`currencies`.`id`
`currencies`.`code`
`currencies`.`name`
`currencies`.`name_ar`
`currencies`.`symbol`
`currencies`.`is_base`
`currencies`.`is_active`
`currencies`.`created_at`
`currencies`.`updated_at`
`customer_money`.*
`customer_money`.`id`
`customer_money`.`cust_id`
`customer_money`.`cust_name`
`customer_money`.`money`
`customer_money`.`date`
`customer_money`.`created_at`
`customer_money`.`updated_at`
`customer_report`.*
`customer_report`.`id`
`customer_report`.`cust_id`
`customer_report`.`cust_name`
`customer_report`.`total`
`customer_report`.`madfoua`
`customer_report`.`bakey`
`customer_report`.`date`
`customer_report`.`order_id`
`customer_report`.`created_at`
`customer_report`.`updated_at`
`customers`.*
`customers`.`cust_id`
`customers`.`cust_name`
`customers`.`cust_address`
`customers`.`cust_phone`
`customers`.`notes`
`customers`.`payment_terms`
`customers`.`credit_limit`
`customers`.`created_at`
`customers`.`updated_at`
`deserved`.*
`deserved`.`des_id`
`deserved`.`price`
`deserved`.`date`
`deserved`.`notes`
`deserved`.`type_id`
`deserved`.`currency_id`
`deserved`.`exchange_rate`
`deserved`.`stock_account_id`
`deserved`.`user_id`
`deserved`.`stock_pull_id`
`deserved_type`.*
`deserved_type`.`des_id`
`deserved_type`.`name`
`deserved_type`.`name_ar`
`employee`.*
`employee`.`emp_id`
`employee`.`emp_name`
`employee`.`salary`
`employee`.`date`
`employee`.`national_id`
`employee`.`emp_phone`
`employee`.`emp_address`
`employee_borrow_items`.*
`employee_borrow_items`.`id`
`employee_borrow_items`.`emp_id`
`employee_borrow_items`.`item_name`
`employee_borrow_items`.`quantity`
`employee_borrow_items`.`borrow_date`
`employee_borrow_items`.`return_date`
`employee_borrow_items`.`notes`
`employee_borrow_items`.`is_returned`
`employee_borrow_money`.*
`employee_borrow_money`.`id`
`employee_borrow_money`.`emp_id`
`employee_borrow_money`.`amount`
`employee_borrow_money`.`borrow_date`
`employee_borrow_money`.`due_date`
`employee_borrow_money`.`notes`
`employee_borrow_money`.`is_returned`
`employee_salary`.*
`employee_salary`.`id`
`employee_salary`.`emp_id`
`employee_salary`.`salary`
`employee_salary`.`date`
`employee_salary`.`notes`
`employee_salary_minus`.*
`employee_salary_minus`.`id`
`employee_salary_minus`.`emp_id`
`employee_salary_minus`.`minus_amount`
`employee_salary_minus`.`date`
`employee_salary_minus`.`reason`
`exchange_rates`.*
`exchange_rates`.`id`
`exchange_rates`.`currency_id`
`exchange_rates`.`rate`
`exchange_rates`.`date`
`exchange_rates`.`source`
`exchange_rates`.`created_at`
`exchange_rates`.`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`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`order_print_data`.*
`order_print_data`.`id`
`order_print_data`.`logo`
`order_print_data`.`name`
`order_print_data`.`name_ar`
`order_print_data`.`address`
`order_print_data`.`address_ar`
`order_print_data`.`description`
`order_print_data`.`description_ar`
`order_print_data`.`phone1`
`order_print_data`.`phone2`
`password_reset_tokens`.*
`password_reset_tokens`.`email`
`password_reset_tokens`.`token`
`password_reset_tokens`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`display_name`
`permissions`.`module`
`permissions`.`action`
`permissions`.`description`
`permissions`.`created_at`
`permissions`.`updated_at`
`personal_access_tokens`.*
`personal_access_tokens`.`id`
`personal_access_tokens`.`tokenable_type`
`personal_access_tokens`.`tokenable_id`
`personal_access_tokens`.`name`
`personal_access_tokens`.`token`
`personal_access_tokens`.`abilities`
`personal_access_tokens`.`last_used_at`
`personal_access_tokens`.`expires_at`
`personal_access_tokens`.`created_at`
`personal_access_tokens`.`updated_at`
`product_batches`.*
`product_batches`.`batch_id`
`product_batches`.`batch_number`
`product_batches`.`barcode`
`product_batches`.`pro_id`
`product_batches`.`purchase_order_id`
`product_batches`.`purchase_price`
`product_batches`.`quantity`
`product_batches`.`remaining_qty`
`product_batches`.`purchase_date`
`product_batches`.`expiry_date`
`product_batches`.`manufacturing_date`
`product_batches`.`supplier_id`
`product_batches`.`supplier_batch_number`
`product_batches`.`notes`
`product_batches`.`status`
`product_batches`.`created_at`
`product_batches`.`updated_at`
`products`.*
`products`.`pro_id`
`products`.`pro_name`
`products`.`pro_name_ar`
`products`.`qty`
`products`.`gomla_price`
`products`.`sale_price`
`products`.`tax_value`
`products`.`sale_price_tax`
`products`.`barcode`
`products`.`min_qty`
`products`.`max_discount`
`products`.`is_tax`
`products`.`group_id`
`products`.`main_unit_name`
`products`.`main_unit_id`
`products`.`sale_unit_name`
`products`.`sale_unit_id`
`products`.`buy_unit_name`
`products`.`buy_unit_id`
`products`.`currency_id`
`products`.`batch_tracking_enabled`
`products`.`created_at`
`products`.`updated_at`
`products_group`.*
`products_group`.`group_id`
`products_group`.`group_name`
`products_group`.`group_name_ar`
`products_group`.`created_at`
`products_group`.`updated_at`
`products_outstore`.*
`products_outstore`.`id`
`products_outstore`.`pro_id`
`products_outstore`.`store_id`
`products_outstore`.`qty`
`products_outstore`.`unit`
`products_outstore`.`date`
`products_outstore`.`name`
`products_outstore`.`reason`
`products_outstore`.`created_at`
`products_outstore`.`updated_at`
`products_qty`.*
`products_qty`.`id`
`products_qty`.`pro_id`
`products_qty`.`store_id`
`products_qty`.`store_name`
`products_qty`.`qty`
`products_qty`.`buy_price`
`products_qty`.`sale_price_tax`
`products_qty`.`created_at`
`products_qty`.`updated_at`
`products_transfer`.*
`products_transfer`.`id`
`products_transfer`.`pro_id`
`products_transfer`.`store_from`
`products_transfer`.`store_to`
`products_transfer`.`qty`
`products_transfer`.`unit`
`products_transfer`.`buy_price`
`products_transfer`.`sale_price`
`products_transfer`.`date`
`products_transfer`.`name`
`products_transfer`.`reason`
`products_transfer`.`created_at`
`products_transfer`.`updated_at`
`products_unit`.*
`products_unit`.`id`
`products_unit`.`pro_id`
`products_unit`.`unit_id`
`products_unit`.`unit_name`
`products_unit`.`qty_in_main`
`products_unit`.`unit_sale_price`
`products_unit`.`total_sale_price`
`products_unit`.`created_at`
`products_unit`.`updated_at`
`purchase_return_details`.*
`purchase_return_details`.`id`
`purchase_return_details`.`return_id`
`purchase_return_details`.`buy_detail_id`
`purchase_return_details`.`pro_id`
`purchase_return_details`.`store_id`
`purchase_return_details`.`qty`
`purchase_return_details`.`unit_id`
`purchase_return_details`.`qty_in_main_unit`
`purchase_return_details`.`price`
`purchase_return_details`.`discount`
`purchase_return_details`.`total`
`purchase_return_details`.`currency_id`
`purchase_return_details`.`exchange_rate`
`purchase_return_details`.`base_currency_total`
`purchase_return_details`.`created_at`
`purchase_return_details`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`return_id`
`purchase_returns`.`order_id`
`purchase_returns`.`sup_id`
`purchase_returns`.`store_id`
`purchase_returns`.`return_date`
`purchase_returns`.`return_reason`
`purchase_returns`.`total_amount`
`purchase_returns`.`currency_id`
`purchase_returns`.`exchange_rate`
`purchase_returns`.`base_currency_total`
`purchase_returns`.`user_name`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`random_barcode`.*
`random_barcode`.`id`
`random_barcode`.`barcode`
`random_barcode`.`is_used`
`random_barcode`.`pro_id`
`random_barcode`.`created_at`
`random_barcode`.`updated_at`
`report_schedules`.*
`report_schedules`.`id`
`report_schedules`.`user_id`
`report_schedules`.`report_type`
`report_schedules`.`frequency`
`report_schedules`.`parameters`
`report_schedules`.`recipients`
`report_schedules`.`last_run_at`
`report_schedules`.`next_run_at`
`report_schedules`.`status`
`report_schedules`.`created_at`
`report_schedules`.`updated_at`
`returns`.*
`returns`.`id`
`returns`.`order_date`
`returns`.`order_type`
`returns`.`created_at`
`returns`.`updated_at`
`returns_details`.*
`returns_details`.`id`
`returns_details`.`order_id`
`returns_details`.`sup_name`
`returns_details`.`cust_name`
`returns_details`.`pro_name`
`returns_details`.`pro_id`
`returns_details`.`date`
`returns_details`.`qty`
`returns_details`.`price`
`returns_details`.`total`
`returns_details`.`user_name`
`returns_details`.`total_order`
`returns_details`.`madfoua`
`returns_details`.`bakey`
`returns_details`.`tax_value`
`returns_details`.`price_tax`
`returns_details`.`unit_id`
`returns_details`.`time`
`returns_details`.`currency_id`
`returns_details`.`exchange_rate`
`returns_details`.`base_currency_total`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`permission_id`
`role_permissions`.`created_at`
`role_permissions`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`display_name`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales`.*
`sales`.`order_id`
`sales`.`date`
`sales`.`due_date`
`sales`.`payment_status`
`sales`.`cust_name`
`sales`.`store_id`
`sales_batch_items`.*
`sales_batch_items`.`id`
`sales_batch_items`.`sales_detail_id`
`sales_batch_items`.`batch_id`
`sales_batch_items`.`qty_from_batch`
`sales_batch_items`.`cost_per_unit`
`sales_batch_items`.`total_cost`
`sales_batch_items`.`created_at`
`sales_batch_items`.`updated_at`
`sales_details`.*
`sales_details`.`id`
`sales_details`.`order_id`
`sales_details`.`cust_name`
`sales_details`.`pro_id`
`sales_details`.`date`
`sales_details`.`qty`
`sales_details`.`user_name`
`sales_details`.`price`
`sales_details`.`discount`
`sales_details`.`total`
`sales_details`.`total_order`
`sales_details`.`madfoua`
`sales_details`.`bakey`
`sales_details`.`unit_id`
`sales_details`.`tax_value`
`sales_details`.`price_tax`
`sales_details`.`time`
`sales_details`.`currency_id`
`sales_details`.`exchange_rate`
`sales_details`.`base_currency_total`
`sales_details`.`cogs`
`sales_rbyh`.*
`sales_rbyh`.`id`
`sales_rbyh`.`order_id`
`sales_rbyh`.`pro_id`
`sales_rbyh`.`pro_name`
`sales_rbyh`.`qty`
`sales_rbyh`.`buy_price`
`sales_rbyh`.`sale_price`
`sales_rbyh`.`rbyh`
`sales_rbyh`.`date`
`sales_rbyh`.`user_name`
`sales_rbyh`.`currency_id`
`sales_rbyh`.`exchange_rate`
`sales_rbyh`.`base_currency_rbyh`
`sales_return_details`.*
`sales_return_details`.`id`
`sales_return_details`.`return_id`
`sales_return_details`.`sales_detail_id`
`sales_return_details`.`pro_id`
`sales_return_details`.`store_id`
`sales_return_details`.`qty`
`sales_return_details`.`unit_id`
`sales_return_details`.`qty_in_main_unit`
`sales_return_details`.`price`
`sales_return_details`.`discount`
`sales_return_details`.`total`
`sales_return_details`.`currency_id`
`sales_return_details`.`exchange_rate`
`sales_return_details`.`base_currency_total`
`sales_return_details`.`cogs`
`sales_return_details`.`created_at`
`sales_return_details`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`return_id`
`sales_returns`.`order_id`
`sales_returns`.`cust_name`
`sales_returns`.`store_id`
`sales_returns`.`return_date`
`sales_returns`.`return_reason`
`sales_returns`.`total_amount`
`sales_returns`.`currency_id`
`sales_returns`.`exchange_rate`
`sales_returns`.`base_currency_total`
`sales_returns`.`user_name`
`sales_returns`.`created_at`
`sales_returns`.`updated_at`
`sanad_kabd`.*
`sanad_kabd`.`order_id`
`sanad_kabd`.`customer_id`
`sanad_kabd`.`name`
`sanad_kabd`.`price`
`sanad_kabd`.`currency_id`
`sanad_kabd`.`exchange_rate`
`sanad_kabd`.`base_currency_amount`
`sanad_kabd`.`date`
`sanad_kabd`.`from_`
`sanad_kabd`.`reason`
`sanad_kabd`.`payment_allocations`
`sanad_kabd`.`created_at`
`sanad_kabd`.`updated_at`
`sanad_kabd_allocations`.*
`sanad_kabd_allocations`.`id`
`sanad_kabd_allocations`.`sanad_kabd_id`
`sanad_kabd_allocations`.`sales_order_id`
`sanad_kabd_allocations`.`allocated_amount`
`sanad_kabd_allocations`.`base_currency_amount`
`sanad_kabd_allocations`.`created_at`
`sanad_sarf`.*
`sanad_sarf`.`order_id`
`sanad_sarf`.`supplier_id`
`sanad_sarf`.`name`
`sanad_sarf`.`price`
`sanad_sarf`.`currency_id`
`sanad_sarf`.`exchange_rate`
`sanad_sarf`.`base_currency_amount`
`sanad_sarf`.`date`
`sanad_sarf`.`to_`
`sanad_sarf`.`reason`
`sanad_sarf`.`payment_allocations`
`sanad_sarf`.`created_at`
`sanad_sarf`.`updated_at`
`sanad_sarf_allocations`.*
`sanad_sarf_allocations`.`id`
`sanad_sarf_allocations`.`sanad_sarf_id`
`sanad_sarf_allocations`.`purchase_order_id`
`sanad_sarf_allocations`.`allocated_amount`
`sanad_sarf_allocations`.`base_currency_amount`
`sanad_sarf_allocations`.`created_at`
`stock`.*
`stock`.`id`
`stock`.`stock_id`
`stock`.`money`
`stock`.`created_at`
`stock`.`updated_at`
`stock_bank_transfer`.*
`stock_bank_transfer`.`id`
`stock_bank_transfer`.`transfer_type`
`stock_bank_transfer`.`stock_id`
`stock_bank_transfer`.`bank_id`
`stock_bank_transfer`.`money`
`stock_bank_transfer`.`currency_id`
`stock_bank_transfer`.`exchange_rate`
`stock_bank_transfer`.`base_currency_amount`
`stock_bank_transfer`.`date`
`stock_bank_transfer`.`name`
`stock_bank_transfer`.`reason`
`stock_bank_transfer`.`created_at`
`stock_bank_transfer`.`updated_at`
`stock_data`.*
`stock_data`.`stock_id`
`stock_data`.`stock_name`
`stock_data`.`stock_name_ar`
`stock_data`.`description`
`stock_data`.`money`
`stock_data`.`is_active`
`stock_data`.`currency_id`
`stock_insert`.*
`stock_insert`.`id`
`stock_insert`.`stock_id`
`stock_insert`.`money`
`stock_insert`.`currency_id`
`stock_insert`.`exchange_rate`
`stock_insert`.`base_currency_amount`
`stock_insert`.`date`
`stock_insert`.`name`
`stock_insert`.`reason`
`stock_insert`.`created_at`
`stock_insert`.`updated_at`
`stock_pull`.*
`stock_pull`.`id`
`stock_pull`.`stock_id`
`stock_pull`.`money`
`stock_pull`.`currency_id`
`stock_pull`.`exchange_rate`
`stock_pull`.`base_currency_amount`
`stock_pull`.`date`
`stock_pull`.`name`
`stock_pull`.`reason`
`stock_pull`.`created_at`
`stock_pull`.`updated_at`
`stock_transfer`.*
`stock_transfer`.`id`
`stock_transfer`.`from_stock_id`
`stock_transfer`.`to_stock_id`
`stock_transfer`.`money`
`stock_transfer`.`currency_id`
`stock_transfer`.`exchange_rate`
`stock_transfer`.`base_currency_amount`
`stock_transfer`.`date`
`stock_transfer`.`name`
`stock_transfer`.`reason`
`stock_transfer`.`created_at`
`stock_transfer`.`updated_at`
`store`.*
`store`.`store_id`
`store`.`store_name`
`store`.`created_at`
`store`.`updated_at`
`suppliers`.*
`suppliers`.`sup_id`
`suppliers`.`sup_name`
`suppliers`.`sup_address`
`suppliers`.`sup_phone`
`suppliers`.`notes`
`suppliers`.`payment_terms`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers_money`.*
`suppliers_money`.`id`
`suppliers_money`.`sup_id`
`suppliers_money`.`sup_name`
`suppliers_money`.`money`
`suppliers_money`.`date`
`suppliers_money`.`created_at`
`suppliers_money`.`updated_at`
`suppliers_report`.*
`suppliers_report`.`id`
`suppliers_report`.`sup_id`
`suppliers_report`.`sup_name`
`suppliers_report`.`total`
`suppliers_report`.`madfoua`
`suppliers_report`.`bakey`
`suppliers_report`.`date`
`suppliers_report`.`order_id`
`suppliers_report`.`created_at`
`suppliers_report`.`updated_at`
`units`.*
`units`.`unit_id`
`units`.`unit_name`
`units`.`unit_name_ar`
`units`.`created_at`
`units`.`updated_at`
`user_buy`.*
`user_buy`.`id`
`user_buy`.`user_id`
`user_buy`.`can_access`
`user_buy`.`created_at`
`user_buy`.`updated_at`
`user_customers`.*
`user_customers`.`id`
`user_customers`.`user_id`
`user_customers`.`can_access`
`user_customers`.`created_at`
`user_customers`.`updated_at`
`user_finance`.*
`user_finance`.`id`
`user_finance`.`user_id`
`user_finance`.`can_access`
`user_finance`.`created_at`
`user_finance`.`updated_at`
`user_inventory`.*
`user_inventory`.`id`
`user_inventory`.`user_id`
`user_inventory`.`can_access`
`user_inventory`.`created_at`
`user_inventory`.`updated_at`
`user_reports`.*
`user_reports`.`id`
`user_reports`.`user_id`
`user_reports`.`can_access`
`user_reports`.`created_at`
`user_reports`.`updated_at`
`user_roles`.*
`user_roles`.`id`
`user_roles`.`user_id`
`user_roles`.`role_id`
`user_roles`.`created_at`
`user_roles`.`updated_at`
`user_sale`.*
`user_sale`.`id`
`user_sale`.`user_id`
`user_sale`.`can_access`
`user_sale`.`created_at`
`user_sale`.`updated_at`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`can_access`
`user_settings`.`created_at`
`user_settings`.`updated_at`
`user_suppliers`.*
`user_suppliers`.`id`
`user_suppliers`.`user_id`
`user_suppliers`.`can_access`
`user_suppliers`.`created_at`
`user_suppliers`.`updated_at`
`users`.*
`users`.`id`
`users`.`user_name`
`users`.`user_password`
`users`.`type`
`users`.`role_id`
`users`.`stock_id`
`users`.`rbyh`
`users`.`language`
`users`.`currency_id`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`bank`.*
`bank`.`id`
`bank`.`bank_name`
`bank`.`bank_name_ar`
`bank`.`account_number`
`bank`.`account_holder`
`bank`.`description`
`bank`.`is_active`
`bank`.`currency_id`
`bank`.`money`
`bank`.`created_at`
`bank`.`updated_at`
`bank_insert`.*
`bank_insert`.`id`
`bank_insert`.`bank_id`
`bank_insert`.`money`
`bank_insert`.`currency_id`
`bank_insert`.`exchange_rate`
`bank_insert`.`base_currency_amount`
`bank_insert`.`date`
`bank_insert`.`name`
`bank_insert`.`reason`
`bank_insert`.`created_at`
`bank_insert`.`updated_at`
`bank_pull`.*
`bank_pull`.`id`
`bank_pull`.`bank_id`
`bank_pull`.`money`
`bank_pull`.`currency_id`
`bank_pull`.`exchange_rate`
`bank_pull`.`base_currency_amount`
`bank_pull`.`date`
`bank_pull`.`name`
`bank_pull`.`reason`
`bank_pull`.`created_at`
`bank_pull`.`updated_at`
`batch_adjustments`.*
`batch_adjustments`.`id`
`batch_adjustments`.`batch_id`
`batch_adjustments`.`adjustment_qty`
`batch_adjustments`.`reason_code`
`batch_adjustments`.`notes`
`batch_adjustments`.`user_id`
`batch_adjustments`.`adjustment_date`
`batch_adjustments`.`created_at`
`batch_transactions`.*
`batch_transactions`.`id`
`batch_transactions`.`batch_id`
`batch_transactions`.`sales_detail_id`
`batch_transactions`.`buy_detail_id`
`batch_transactions`.`quantity`
`batch_transactions`.`unit_price`
`batch_transactions`.`transaction_date`
`batch_transactions`.`transaction_type`
`batch_transactions`.`created_at`
`buy`.*
`buy`.`order_id`
`buy`.`date`
`buy`.`due_date`
`buy`.`payment_status`
`buy`.`sup_id`
`buy`.`store_id`
`buy_details`.*
`buy_details`.`id`
`buy_details`.`order_id`
`buy_details`.`sup_id`
`buy_details`.`pro_id`
`buy_details`.`date`
`buy_details`.`qty`
`buy_details`.`unit_id`
`buy_details`.`user_name`
`buy_details`.`price`
`buy_details`.`discount`
`buy_details`.`total`
`buy_details`.`total_order`
`buy_details`.`madfoua`
`buy_details`.`bakey`
`buy_details`.`tax_value`
`buy_details`.`price_tax`
`buy_details`.`time`
`buy_details`.`unit_name`
`buy_details`.`currency_id`
`buy_details`.`exchange_rate`
`buy_details`.`base_currency_total`
`currencies`.*
`currencies`.`id`
`currencies`.`code`
`currencies`.`name`
`currencies`.`name_ar`
`currencies`.`symbol`
`currencies`.`is_base`
`currencies`.`is_active`
`currencies`.`created_at`
`currencies`.`updated_at`
`customer_money`.*
`customer_money`.`id`
`customer_money`.`cust_id`
`customer_money`.`cust_name`
`customer_money`.`money`
`customer_money`.`date`
`customer_money`.`created_at`
`customer_money`.`updated_at`
`customer_report`.*
`customer_report`.`id`
`customer_report`.`cust_id`
`customer_report`.`cust_name`
`customer_report`.`total`
`customer_report`.`madfoua`
`customer_report`.`bakey`
`customer_report`.`date`
`customer_report`.`order_id`
`customer_report`.`created_at`
`customer_report`.`updated_at`
`customers`.*
`customers`.`cust_id`
`customers`.`cust_name`
`customers`.`cust_address`
`customers`.`cust_phone`
`customers`.`notes`
`customers`.`payment_terms`
`customers`.`credit_limit`
`customers`.`created_at`
`customers`.`updated_at`
`deserved`.*
`deserved`.`des_id`
`deserved`.`price`
`deserved`.`date`
`deserved`.`notes`
`deserved`.`type_id`
`deserved`.`currency_id`
`deserved`.`exchange_rate`
`deserved`.`stock_account_id`
`deserved`.`user_id`
`deserved`.`stock_pull_id`
`deserved_type`.*
`deserved_type`.`des_id`
`deserved_type`.`name`
`deserved_type`.`name_ar`
`employee`.*
`employee`.`emp_id`
`employee`.`emp_name`
`employee`.`salary`
`employee`.`date`
`employee`.`national_id`
`employee`.`emp_phone`
`employee`.`emp_address`
`employee_borrow_items`.*
`employee_borrow_items`.`id`
`employee_borrow_items`.`emp_id`
`employee_borrow_items`.`item_name`
`employee_borrow_items`.`quantity`
`employee_borrow_items`.`borrow_date`
`employee_borrow_items`.`return_date`
`employee_borrow_items`.`notes`
`employee_borrow_items`.`is_returned`
`employee_borrow_money`.*
`employee_borrow_money`.`id`
`employee_borrow_money`.`emp_id`
`employee_borrow_money`.`amount`
`employee_borrow_money`.`borrow_date`
`employee_borrow_money`.`due_date`
`employee_borrow_money`.`notes`
`employee_borrow_money`.`is_returned`
`employee_salary`.*
`employee_salary`.`id`
`employee_salary`.`emp_id`
`employee_salary`.`salary`
`employee_salary`.`date`
`employee_salary`.`notes`
`employee_salary_minus`.*
`employee_salary_minus`.`id`
`employee_salary_minus`.`emp_id`
`employee_salary_minus`.`minus_amount`
`employee_salary_minus`.`date`
`employee_salary_minus`.`reason`
`exchange_rates`.*
`exchange_rates`.`id`
`exchange_rates`.`currency_id`
`exchange_rates`.`rate`
`exchange_rates`.`date`
`exchange_rates`.`source`
`exchange_rates`.`created_at`
`exchange_rates`.`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`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`order_print_data`.*
`order_print_data`.`id`
`order_print_data`.`logo`
`order_print_data`.`name`
`order_print_data`.`name_ar`
`order_print_data`.`address`
`order_print_data`.`address_ar`
`order_print_data`.`description`
`order_print_data`.`description_ar`
`order_print_data`.`phone1`
`order_print_data`.`phone2`
`password_reset_tokens`.*
`password_reset_tokens`.`email`
`password_reset_tokens`.`token`
`password_reset_tokens`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`display_name`
`permissions`.`module`
`permissions`.`action`
`permissions`.`description`
`permissions`.`created_at`
`permissions`.`updated_at`
`personal_access_tokens`.*
`personal_access_tokens`.`id`
`personal_access_tokens`.`tokenable_type`
`personal_access_tokens`.`tokenable_id`
`personal_access_tokens`.`name`
`personal_access_tokens`.`token`
`personal_access_tokens`.`abilities`
`personal_access_tokens`.`last_used_at`
`personal_access_tokens`.`expires_at`
`personal_access_tokens`.`created_at`
`personal_access_tokens`.`updated_at`
`product_batches`.*
`product_batches`.`batch_id`
`product_batches`.`batch_number`
`product_batches`.`barcode`
`product_batches`.`pro_id`
`product_batches`.`purchase_order_id`
`product_batches`.`purchase_price`
`product_batches`.`quantity`
`product_batches`.`remaining_qty`
`product_batches`.`purchase_date`
`product_batches`.`expiry_date`
`product_batches`.`manufacturing_date`
`product_batches`.`supplier_id`
`product_batches`.`supplier_batch_number`
`product_batches`.`notes`
`product_batches`.`status`
`product_batches`.`created_at`
`product_batches`.`updated_at`
`products`.*
`products`.`pro_id`
`products`.`pro_name`
`products`.`pro_name_ar`
`products`.`qty`
`products`.`gomla_price`
`products`.`sale_price`
`products`.`tax_value`
`products`.`sale_price_tax`
`products`.`barcode`
`products`.`min_qty`
`products`.`max_discount`
`products`.`is_tax`
`products`.`group_id`
`products`.`main_unit_name`
`products`.`main_unit_id`
`products`.`sale_unit_name`
`products`.`sale_unit_id`
`products`.`buy_unit_name`
`products`.`buy_unit_id`
`products`.`currency_id`
`products`.`batch_tracking_enabled`
`products`.`created_at`
`products`.`updated_at`
`products_group`.*
`products_group`.`group_id`
`products_group`.`group_name`
`products_group`.`group_name_ar`
`products_group`.`created_at`
`products_group`.`updated_at`
`products_outstore`.*
`products_outstore`.`id`
`products_outstore`.`pro_id`
`products_outstore`.`store_id`
`products_outstore`.`qty`
`products_outstore`.`unit`
`products_outstore`.`date`
`products_outstore`.`name`
`products_outstore`.`reason`
`products_outstore`.`created_at`
`products_outstore`.`updated_at`
`products_qty`.*
`products_qty`.`id`
`products_qty`.`pro_id`
`products_qty`.`store_id`
`products_qty`.`store_name`
`products_qty`.`qty`
`products_qty`.`buy_price`
`products_qty`.`sale_price_tax`
`products_qty`.`created_at`
`products_qty`.`updated_at`
`products_transfer`.*
`products_transfer`.`id`
`products_transfer`.`pro_id`
`products_transfer`.`store_from`
`products_transfer`.`store_to`
`products_transfer`.`qty`
`products_transfer`.`unit`
`products_transfer`.`buy_price`
`products_transfer`.`sale_price`
`products_transfer`.`date`
`products_transfer`.`name`
`products_transfer`.`reason`
`products_transfer`.`created_at`
`products_transfer`.`updated_at`
`products_unit`.*
`products_unit`.`id`
`products_unit`.`pro_id`
`products_unit`.`unit_id`
`products_unit`.`unit_name`
`products_unit`.`qty_in_main`
`products_unit`.`unit_sale_price`
`products_unit`.`total_sale_price`
`products_unit`.`created_at`
`products_unit`.`updated_at`
`purchase_return_details`.*
`purchase_return_details`.`id`
`purchase_return_details`.`return_id`
`purchase_return_details`.`buy_detail_id`
`purchase_return_details`.`pro_id`
`purchase_return_details`.`store_id`
`purchase_return_details`.`qty`
`purchase_return_details`.`unit_id`
`purchase_return_details`.`qty_in_main_unit`
`purchase_return_details`.`price`
`purchase_return_details`.`discount`
`purchase_return_details`.`total`
`purchase_return_details`.`currency_id`
`purchase_return_details`.`exchange_rate`
`purchase_return_details`.`base_currency_total`
`purchase_return_details`.`created_at`
`purchase_return_details`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`return_id`
`purchase_returns`.`order_id`
`purchase_returns`.`sup_id`
`purchase_returns`.`store_id`
`purchase_returns`.`return_date`
`purchase_returns`.`return_reason`
`purchase_returns`.`total_amount`
`purchase_returns`.`currency_id`
`purchase_returns`.`exchange_rate`
`purchase_returns`.`base_currency_total`
`purchase_returns`.`user_name`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`random_barcode`.*
`random_barcode`.`id`
`random_barcode`.`barcode`
`random_barcode`.`is_used`
`random_barcode`.`pro_id`
`random_barcode`.`created_at`
`random_barcode`.`updated_at`
`report_schedules`.*
`report_schedules`.`id`
`report_schedules`.`user_id`
`report_schedules`.`report_type`
`report_schedules`.`frequency`
`report_schedules`.`parameters`
`report_schedules`.`recipients`
`report_schedules`.`last_run_at`
`report_schedules`.`next_run_at`
`report_schedules`.`status`
`report_schedules`.`created_at`
`report_schedules`.`updated_at`
`returns`.*
`returns`.`id`
`returns`.`order_date`
`returns`.`order_type`
`returns`.`created_at`
`returns`.`updated_at`
`returns_details`.*
`returns_details`.`id`
`returns_details`.`order_id`
`returns_details`.`sup_name`
`returns_details`.`cust_name`
`returns_details`.`pro_name`
`returns_details`.`pro_id`
`returns_details`.`date`
`returns_details`.`qty`
`returns_details`.`price`
`returns_details`.`total`
`returns_details`.`user_name`
`returns_details`.`total_order`
`returns_details`.`madfoua`
`returns_details`.`bakey`
`returns_details`.`tax_value`
`returns_details`.`price_tax`
`returns_details`.`unit_id`
`returns_details`.`time`
`returns_details`.`currency_id`
`returns_details`.`exchange_rate`
`returns_details`.`base_currency_total`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`permission_id`
`role_permissions`.`created_at`
`role_permissions`.`updated_at`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`display_name`
`roles`.`description`
`roles`.`is_active`
`roles`.`created_at`
`roles`.`updated_at`
`sales`.*
`sales`.`order_id`
`sales`.`date`
`sales`.`due_date`
`sales`.`payment_status`
`sales`.`cust_name`
`sales`.`store_id`
`sales_batch_items`.*
`sales_batch_items`.`id`
`sales_batch_items`.`sales_detail_id`
`sales_batch_items`.`batch_id`
`sales_batch_items`.`qty_from_batch`
`sales_batch_items`.`cost_per_unit`
`sales_batch_items`.`total_cost`
`sales_batch_items`.`created_at`
`sales_batch_items`.`updated_at`
`sales_details`.*
`sales_details`.`id`
`sales_details`.`order_id`
`sales_details`.`cust_name`
`sales_details`.`pro_id`
`sales_details`.`date`
`sales_details`.`qty`
`sales_details`.`user_name`
`sales_details`.`price`
`sales_details`.`discount`
`sales_details`.`total`
`sales_details`.`total_order`
`sales_details`.`madfoua`
`sales_details`.`bakey`
`sales_details`.`unit_id`
`sales_details`.`tax_value`
`sales_details`.`price_tax`
`sales_details`.`time`
`sales_details`.`currency_id`
`sales_details`.`exchange_rate`
`sales_details`.`base_currency_total`
`sales_details`.`cogs`
`sales_rbyh`.*
`sales_rbyh`.`id`
`sales_rbyh`.`order_id`
`sales_rbyh`.`pro_id`
`sales_rbyh`.`pro_name`
`sales_rbyh`.`qty`
`sales_rbyh`.`buy_price`
`sales_rbyh`.`sale_price`
`sales_rbyh`.`rbyh`
`sales_rbyh`.`date`
`sales_rbyh`.`user_name`
`sales_rbyh`.`currency_id`
`sales_rbyh`.`exchange_rate`
`sales_rbyh`.`base_currency_rbyh`
`sales_return_details`.*
`sales_return_details`.`id`
`sales_return_details`.`return_id`
`sales_return_details`.`sales_detail_id`
`sales_return_details`.`pro_id`
`sales_return_details`.`store_id`
`sales_return_details`.`qty`
`sales_return_details`.`unit_id`
`sales_return_details`.`qty_in_main_unit`
`sales_return_details`.`price`
`sales_return_details`.`discount`
`sales_return_details`.`total`
`sales_return_details`.`currency_id`
`sales_return_details`.`exchange_rate`
`sales_return_details`.`base_currency_total`
`sales_return_details`.`cogs`
`sales_return_details`.`created_at`
`sales_return_details`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`return_id`
`sales_returns`.`order_id`
`sales_returns`.`cust_name`
`sales_returns`.`store_id`
`sales_returns`.`return_date`
`sales_returns`.`return_reason`
`sales_returns`.`total_amount`
`sales_returns`.`currency_id`
`sales_returns`.`exchange_rate`
`sales_returns`.`base_currency_total`
`sales_returns`.`user_name`
`sales_returns`.`created_at`
`sales_returns`.`updated_at`
`sanad_kabd`.*
`sanad_kabd`.`order_id`
`sanad_kabd`.`customer_id`
`sanad_kabd`.`name`
`sanad_kabd`.`price`
`sanad_kabd`.`currency_id`
`sanad_kabd`.`exchange_rate`
`sanad_kabd`.`base_currency_amount`
`sanad_kabd`.`date`
`sanad_kabd`.`from_`
`sanad_kabd`.`reason`
`sanad_kabd`.`payment_allocations`
`sanad_kabd`.`created_at`
`sanad_kabd`.`updated_at`
`sanad_kabd_allocations`.*
`sanad_kabd_allocations`.`id`
`sanad_kabd_allocations`.`sanad_kabd_id`
`sanad_kabd_allocations`.`sales_order_id`
`sanad_kabd_allocations`.`allocated_amount`
`sanad_kabd_allocations`.`base_currency_amount`
`sanad_kabd_allocations`.`created_at`
`sanad_sarf`.*
`sanad_sarf`.`order_id`
`sanad_sarf`.`supplier_id`
`sanad_sarf`.`name`
`sanad_sarf`.`price`
`sanad_sarf`.`currency_id`
`sanad_sarf`.`exchange_rate`
`sanad_sarf`.`base_currency_amount`
`sanad_sarf`.`date`
`sanad_sarf`.`to_`
`sanad_sarf`.`reason`
`sanad_sarf`.`payment_allocations`
`sanad_sarf`.`created_at`
`sanad_sarf`.`updated_at`
`sanad_sarf_allocations`.*
`sanad_sarf_allocations`.`id`
`sanad_sarf_allocations`.`sanad_sarf_id`
`sanad_sarf_allocations`.`purchase_order_id`
`sanad_sarf_allocations`.`allocated_amount`
`sanad_sarf_allocations`.`base_currency_amount`
`sanad_sarf_allocations`.`created_at`
`stock`.*
`stock`.`id`
`stock`.`stock_id`
`stock`.`money`
`stock`.`created_at`
`stock`.`updated_at`
`stock_bank_transfer`.*
`stock_bank_transfer`.`id`
`stock_bank_transfer`.`transfer_type`
`stock_bank_transfer`.`stock_id`
`stock_bank_transfer`.`bank_id`
`stock_bank_transfer`.`money`
`stock_bank_transfer`.`currency_id`
`stock_bank_transfer`.`exchange_rate`
`stock_bank_transfer`.`base_currency_amount`
`stock_bank_transfer`.`date`
`stock_bank_transfer`.`name`
`stock_bank_transfer`.`reason`
`stock_bank_transfer`.`created_at`
`stock_bank_transfer`.`updated_at`
`stock_data`.*
`stock_data`.`stock_id`
`stock_data`.`stock_name`
`stock_data`.`stock_name_ar`
`stock_data`.`description`
`stock_data`.`money`
`stock_data`.`is_active`
`stock_data`.`currency_id`
`stock_insert`.*
`stock_insert`.`id`
`stock_insert`.`stock_id`
`stock_insert`.`money`
`stock_insert`.`currency_id`
`stock_insert`.`exchange_rate`
`stock_insert`.`base_currency_amount`
`stock_insert`.`date`
`stock_insert`.`name`
`stock_insert`.`reason`
`stock_insert`.`created_at`
`stock_insert`.`updated_at`
`stock_pull`.*
`stock_pull`.`id`
`stock_pull`.`stock_id`
`stock_pull`.`money`
`stock_pull`.`currency_id`
`stock_pull`.`exchange_rate`
`stock_pull`.`base_currency_amount`
`stock_pull`.`date`
`stock_pull`.`name`
`stock_pull`.`reason`
`stock_pull`.`created_at`
`stock_pull`.`updated_at`
`stock_transfer`.*
`stock_transfer`.`id`
`stock_transfer`.`from_stock_id`
`stock_transfer`.`to_stock_id`
`stock_transfer`.`money`
`stock_transfer`.`currency_id`
`stock_transfer`.`exchange_rate`
`stock_transfer`.`base_currency_amount`
`stock_transfer`.`date`
`stock_transfer`.`name`
`stock_transfer`.`reason`
`stock_transfer`.`created_at`
`stock_transfer`.`updated_at`
`store`.*
`store`.`store_id`
`store`.`store_name`
`store`.`created_at`
`store`.`updated_at`
`suppliers`.*
`suppliers`.`sup_id`
`suppliers`.`sup_name`
`suppliers`.`sup_address`
`suppliers`.`sup_phone`
`suppliers`.`notes`
`suppliers`.`payment_terms`
`suppliers`.`created_at`
`suppliers`.`updated_at`
`suppliers_money`.*
`suppliers_money`.`id`
`suppliers_money`.`sup_id`
`suppliers_money`.`sup_name`
`suppliers_money`.`money`
`suppliers_money`.`date`
`suppliers_money`.`created_at`
`suppliers_money`.`updated_at`
`suppliers_report`.*
`suppliers_report`.`id`
`suppliers_report`.`sup_id`
`suppliers_report`.`sup_name`
`suppliers_report`.`total`
`suppliers_report`.`madfoua`
`suppliers_report`.`bakey`
`suppliers_report`.`date`
`suppliers_report`.`order_id`
`suppliers_report`.`created_at`
`suppliers_report`.`updated_at`
`units`.*
`units`.`unit_id`
`units`.`unit_name`
`units`.`unit_name_ar`
`units`.`created_at`
`units`.`updated_at`
`user_buy`.*
`user_buy`.`id`
`user_buy`.`user_id`
`user_buy`.`can_access`
`user_buy`.`created_at`
`user_buy`.`updated_at`
`user_customers`.*
`user_customers`.`id`
`user_customers`.`user_id`
`user_customers`.`can_access`
`user_customers`.`created_at`
`user_customers`.`updated_at`
`user_finance`.*
`user_finance`.`id`
`user_finance`.`user_id`
`user_finance`.`can_access`
`user_finance`.`created_at`
`user_finance`.`updated_at`
`user_inventory`.*
`user_inventory`.`id`
`user_inventory`.`user_id`
`user_inventory`.`can_access`
`user_inventory`.`created_at`
`user_inventory`.`updated_at`
`user_reports`.*
`user_reports`.`id`
`user_reports`.`user_id`
`user_reports`.`can_access`
`user_reports`.`created_at`
`user_reports`.`updated_at`
`user_roles`.*
`user_roles`.`id`
`user_roles`.`user_id`
`user_roles`.`role_id`
`user_roles`.`created_at`
`user_roles`.`updated_at`
`user_sale`.*
`user_sale`.`id`
`user_sale`.`user_id`
`user_sale`.`can_access`
`user_sale`.`created_at`
`user_sale`.`updated_at`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`can_access`
`user_settings`.`created_at`
`user_settings`.`updated_at`
`user_suppliers`.*
`user_suppliers`.`id`
`user_suppliers`.`user_id`
`user_suppliers`.`can_access`
`user_suppliers`.`created_at`
`user_suppliers`.`updated_at`
`users`.*
`users`.`id`
`users`.`user_name`
`users`.`user_password`
`users`.`type`
`users`.`role_id`
`users`.`stock_id`
`users`.`rbyh`
`users`.`language`
`users`.`currency_id`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`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
bank
bank_insert
bank_pull
batch_adjustments
batch_transactions
buy
buy_details
currencies
customer_money
customer_report
customers
deserved
deserved_type
employee
employee_borrow_items
employee_borrow_money
employee_salary
employee_salary_minus
exchange_rates
failed_jobs
migrations
order_print_data
password_reset_tokens
permissions
personal_access_tokens
product_batches
products
products_group
products_outstore
products_qty
products_transfer
products_unit
purchase_return_details
purchase_returns
random_barcode
report_schedules
returns
returns_details
role_permissions
roles
sales
sales_batch_items
sales_details
sales_rbyh
sales_return_details
sales_returns
sanad_kabd
sanad_kabd_allocations
sanad_sarf
sanad_sarf_allocations
stock
stock_bank_transfer
stock_data
stock_insert
stock_pull
stock_transfer
store
suppliers
suppliers_money
suppliers_report
units
user_buy
user_customers
user_finance
user_inventory
user_reports
user_roles
user_sale
user_settings
user_suppliers
users
SQL query on database
sales_management
: