* id company_id line1 line2 city postal_code state country phone updated_at

* id date reference_no warehouse_id note attachment created_by updated_by updated_at count_id

* id adjustment_id product_id option_id quantity warehouse_id serial_no type

* id code name image slug description

* id title description start end color user_id

* captcha_id captcha_time ip_address word

* id code name image parent_id slug description

* id product_id item_code quantity unit_price

* id group_id group_name customer_group_id customer_group_name name company vat_no address city state postal_code country phone email cf1 cf2 cf3 cf4 cf5 cf6 invoice_footer payment_term logo award_points deposit_amount price_group_id price_group_name gst_no

* id date product_id sale_item_id sale_id purchase_item_id quantity purchase_net_unit_cost purchase_unit_cost sale_net_unit_price sale_unit_price quantity_balance inventory overselling option_id

* id code name rate auto_update symbol

* id name percent

* id js php sql

* id date sale_id do_reference_no sale_reference_no customer address note status attachment delivered_by received_by created_by updated_by updated_at

* id date company_id amount paid_by note created_by updated_by updated_at

* id date reference amount note created_by attachment category_id warehouse_id

* id code name

* id date card_no value customer_id customer balance expiry created_by

* id date card_id amount created_by

* id name description

* id ip_address login time

* version

* id comment date from_date till_date scope

* ref_id date so qu po to pos do pay re rep ex ppay qa

* id date sale_id return_id purchase_id reference_no transaction_id paid_by cheque_no cc_no cc_holder cc_month cc_year cc_type amount currency created_by attachment type note pos_paid pos_balance approval_code

* id active account_email paypal_currency fixed_charges extra_charges_my extra_charges_other

* id group_id products-index products-add products-edit products-delete products-cost products-price quotes-index quotes-add quotes-edit quotes-pdf quotes-email quotes-delete sales-index sales-add sales-edit sales-pdf sales-email sales-delete purchases-index purchases-add purchases-edit purchases-pdf purchases-email purchases-delete transfers-index transfers-add transfers-edit transfers-pdf transfers-email transfers-delete customers-index customers-add customers-edit customers-delete suppliers-index suppliers-add suppliers-edit suppliers-delete sales-deliveries sales-add_delivery sales-edit_delivery sales-delete_delivery sales-email_delivery sales-pdf_delivery sales-gift_cards sales-add_gift_card sales-edit_gift_card sales-delete_gift_card pos-index sales-return_sales reports-index reports-warehouse_stock reports-quantity_alerts reports-expiry_alerts reports-products reports-daily_sales reports-monthly_sales reports-sales reports-payments reports-purchases reports-profit_loss reports-customers reports-suppliers reports-staff reports-register sales-payments purchases-payments purchases-expenses products-adjustments bulk_actions customers-deposits customers-delete_deposit products-barcode purchases-return_purchases reports-expenses reports-daily_purchases reports-monthly_purchases products-stock_count edit_price returns-index returns-add returns-edit returns-delete returns-email returns-pdf reports-tax

* id date user_id cash_in_hand status total_cash total_cheques total_cc_slips total_cash_submitted total_cheques_submitted total_cc_slips_submitted note closed_at transfer_opened_bills closed_by

* pos_id cat_limit pro_limit default_category default_customer default_biller display_time cf_title1 cf_title2 cf_value1 cf_value2 receipt_printer cash_drawer_codes focus_add_item add_manual_product customer_selection add_customer toggle_category_slider toggle_subcategory_slider cancel_sale suspend_sale print_items_list finalize_sale today_sale open_hold_bills close_register keyboard pos_printers java_applet product_button_color tooltips paypal_pro stripe rounding char_per_line pin_code purchase_code envato_username version after_sale_page item_order authorize toggle_brands_slider remote_printing printer order_printers auto_print customer_details local_printers biller_hp

* id name

* id title type profile char_per_line path ip_address port

* id code name unit cost price alert_quantity image category_id subcategory_id cf1 cf2 cf3 cf4 cf5 cf6 quantity tax_rate track_quantity details warehouse barcode_symbology file product_details tax_method type supplier1 supplier1price supplier2 supplier2price supplier3 supplier3price supplier4 supplier4price supplier5 supplier5price promotion promo_price start_date end_date supplier1_part_no supplier2_part_no supplier3_part_no supplier4_part_no supplier5_part_no sale_unit purchase_unit brand slug featured weight hsn_code views hide second_name

* id product_id photo

* id product_id price_group_id price

* id product_id name cost price quantity

* id reference_no date supplier_id supplier warehouse_id note total product_discount order_discount_id order_discount total_discount product_tax order_tax_id order_tax total_tax shipping grand_total paid status payment_status created_by updated_by updated_at attachment payment_term due_date return_id surcharge return_purchase_ref purchase_id return_purchase_total cgst sgst igst

* id purchase_id transfer_id product_id product_code product_name option_id net_unit_cost quantity warehouse_id item_tax tax_rate_id tax discount item_discount expiry subtotal quantity_balance date status unit_cost real_unit_cost quantity_received supplier_part_no purchase_item_id product_unit_id product_unit_code unit_quantity gst cgst sgst igst

* id date reference_no customer_id customer warehouse_id biller_id biller note internal_note total product_discount order_discount order_discount_id total_discount product_tax order_tax_id order_tax total_tax shipping grand_total status created_by updated_by updated_at attachment supplier_id supplier hash cgst sgst igst

* id quote_id product_id product_code product_name product_type option_id net_unit_price unit_price quantity warehouse_id item_tax tax_rate_id tax discount item_discount subtotal serial_no real_unit_price product_unit_id product_unit_code unit_quantity gst cgst sgst igst

* id date reference_no customer_id customer biller_id biller warehouse_id note staff_note total product_discount order_discount_id total_discount order_discount product_tax order_tax_id order_tax total_tax grand_total created_by updated_by updated_at total_items paid surcharge attachment hash cgst sgst igst

* id return_id product_id product_code product_name product_type option_id net_unit_price unit_price quantity warehouse_id item_tax tax_rate_id tax discount item_discount subtotal serial_no real_unit_price product_unit_id product_unit_code unit_quantity comment gst cgst sgst igst

* id date reference_no customer_id customer biller_id biller warehouse_id note staff_note total product_discount order_discount_id total_discount order_discount product_tax order_tax_id order_tax total_tax shipping grand_total sale_status payment_status payment_term due_date created_by updated_by updated_at total_items pos paid return_id surcharge attachment return_sale_ref sale_id return_sale_total rounding suspend_note api shop address_id reserve_id hash manual_payment cgst sgst igst payment_method

* id sale_id product_id product_code product_name product_type option_id net_unit_price unit_price quantity warehouse_id item_tax tax_rate_id tax discount item_discount subtotal serial_no real_unit_price sale_item_id product_unit_id product_unit_code unit_quantity comment gst cgst sgst igst

* id ip_address timestamp data

* setting_id logo logo2 site_name language default_warehouse accounting_method default_currency default_tax_rate rows_per_page version default_tax_rate2 dateformat sales_prefix quote_prefix purchase_prefix transfer_prefix delivery_prefix payment_prefix return_prefix returnp_prefix expense_prefix item_addition theme product_serial default_discount product_discount discount_method tax1 tax2 overselling restrict_user restrict_calendar timezone iwidth iheight twidth theight watermark reg_ver allow_reg reg_notification auto_reg protocol mailpath smtp_host smtp_user smtp_pass smtp_port smtp_crypto corn customer_group default_email mmode bc_fix auto_detect_barcode captcha reference_format racks attributes product_expiry decimals qty_decimals decimals_sep thousands_sep invoice_view default_biller envato_username purchase_code rtl each_spent ca_point each_sale sa_point update sac display_all_products display_symbol symbol remove_expired barcode_separator set_focus price_group barcode_img ppayment_prefix disable_editing qa_prefix update_cost apis state pdf_lib options options2 options3 show_brand

* id active account_email secret_word skrill_currency fixed_charges extra_charges_my extra_charges_other

* id date reference_no warehouse_id type initial_file final_file brands brand_names categories category_names note products rows differences matches missing created_by updated_by updated_at finalized

* id stock_count_id product_id product_code product_name product_variant product_variant_id expected counted cost

* id date customer_id customer count order_discount_id order_tax_id total biller_id warehouse_id created_by suspend_note shipping cgst sgst igst

* id suspend_id product_id product_code product_name net_unit_price unit_price quantity warehouse_id item_tax tax_rate_id tax discount item_discount subtotal serial_no option_id product_type real_unit_price product_unit_id product_unit_code unit_quantity comment gst cgst sgst igst

* id name code rate type

* id transfer_no date from_warehouse_id from_warehouse_code from_warehouse_name to_warehouse_id to_warehouse_code to_warehouse_name note total total_tax grand_total created_by status shipping attachment cgst sgst igst

* id transfer_id product_id product_code product_name option_id expiry quantity tax_rate_id tax item_tax net_unit_cost subtotal quantity_balance unit_cost real_unit_cost date warehouse_id product_unit_id product_unit_code unit_quantity gst cgst sgst igst

* id code name base_unit operator unit_value operation_value

* id last_ip_address ip_address username password salt email activation_code forgotten_password_code forgotten_password_time remember_code created_on last_login active first_name last_name company phone avatar gender group_id warehouse_id biller_id company_id show_cost show_price award_points view_right edit_right allow_discount

* id user_id company_id ip_address login time

* id name

* id code name address map phone email price_group_id

* id product_id warehouse_id quantity rack avg_cost

* id option_id product_id warehouse_id quantity rack

* id device_name otp serial_number vat_number org_unit_name org_name location_address industry private_key secret binary_security_token csr environment is_active created_at

* id device_name otp serial_number vat_number org_unit_name org_name location_address industry private_key csr certificate binary_security_token secret compliance_request_id production_request_id environment is_active last_sync created_at

* id sale_id invoice_number uuid zatca_status api_response request_json xml pdf_path invoice_hash qr_code cleared_invoice created_at

select table sma_addresses sma_adjustments sma_adjustment_items sma_brands sma_calendar sma_captcha sma_categories sma_combo_items sma_companies sma_costing sma_currencies sma_customer_groups sma_date_format sma_deliveries sma_deposits sma_expenses sma_expense_categories sma_gift_cards sma_gift_card_topups sma_groups sma_login_attempts sma_migrations sma_notifications sma_order_ref sma_payments sma_paypal sma_permissions sma_pos_register sma_pos_settings sma_price_groups sma_printers sma_products sma_product_photos sma_product_prices sma_product_variants sma_purchases sma_purchase_items sma_quotes sma_quote_items sma_returns sma_return_items sma_sales sma_sale_items sma_sessions sma_settings sma_skrill sma_stock_counts sma_stock_count_items sma_suspended_bills sma_suspended_items sma_tax_rates sma_transfers sma_transfer_items sma_units sma_users sma_user_logins sma_variants sma_warehouses sma_warehouses_products sma_warehouses_products_variants sma_zatca_devices zatca_devices zatca_sales_logs . select column
عرض

criteria

ترتيب	تصاعديا	تنازليا
إضافة كـ	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	نص Another column
	select table sma_addresses sma_adjustments sma_adjustment_items sma_brands sma_calendar sma_captcha sma_categories sma_combo_items sma_companies sma_costing sma_currencies sma_customer_groups sma_date_format sma_deliveries sma_deposits sma_expenses sma_expense_categories sma_gift_cards sma_gift_card_topups sma_groups sma_login_attempts sma_migrations sma_notifications sma_order_ref sma_payments sma_paypal sma_permissions sma_pos_register sma_pos_settings sma_price_groups sma_printers sma_products sma_product_photos sma_product_prices sma_product_variants sma_purchases sma_purchase_items sma_quotes sma_quote_items sma_returns sma_return_items sma_sales sma_sale_items sma_sessions sma_settings sma_skrill sma_stock_counts sma_stock_count_items sma_suspended_bills sma_suspended_items sma_tax_rates sma_transfers sma_transfer_items sma_units sma_users sma_user_logins sma_variants sma_warehouses sma_warehouses_products sma_warehouses_products_variants sma_zatca_devices zatca_devices zatca_sales_logs .	select column