Reciente
`farmamedi_doctest`.`review`
`csv3n`.`wp_wc_admin_note_actions`
`farmamedi_test`.`review`
`csv3n`.`wp_woocommerce_api_keys`
`27jun`.`wp_comments`
`mysql`.`plugin`
`27jun`.`wp_users`
`information_schema`.`INDEX_STATISTICS`
`information_schema`.`CLIENT_STATISTICS`
`information_schema`.`STATISTICS`
Favoritas
No existen tablas favoritas.
Nueva
13abr26
27jun
afa_maestra
csv3n
farmamedi
farmamedi_crmshare
farmamedi_doctest
farmamedi_hms0971mico
farmamedi_miconet
farmamedi_test
florece
grsdayey
grsdayey_blanca2712
grsdayey_f4rm45a1ud
grsdayey_farmagrs
grsdigow_wp172
grsmx
information_schema
lab
labbi
mitienditasaas
mysql
optikom
optikom_db
optikom_erp_db
performance_schema
phpmyadmin
sma_import_tmp
taller_saas
test
tiendita_transform_tmp
Panel de navegación
Árbol de navegación
Servidores
Bases de datos
Tablas
Panel de navegación
Cambiar la apariencia del panel de navegación.
Panel de navegación
Mostrar las bases de datos navegación como árbol
En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal
Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo
Mostrar el logo en el panel de navegación.
URL para enlace del logo
URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace
Abrir la página enlazada en la ventana principal (
principal
) o en una nueva (
nueva
).
main
new
Permitir destacar
Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel
El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro
Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas
Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas
Cantidad máxima de tablas favoritas; 0 para desactivar.
Anchura del panel de navegación
Asignar 0 para ocular el panel de navegación.
Árbol de navegación
Personalizar el árbol de navegación.
Árbol de navegación
Cantidad máxima de elementos en una rama
El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol
Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación
Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol
Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol
Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol
Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol
Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol
Si se muestran eventos bajo la base de datos en el árbol de navegación
Expandir la base de datos única
Si se debe desglosar automáticamente una base de datos individual en el árbol de navegación.
Servidores
Opciones para visualizar los servidores.
Servidores
Mostrar la selección de servidores
Mostrar la elección de servidor en la parte superior del panel de navegación.
Mostrar los servidores en una lista
Mostrar los servidores en una lista en lugar de una caja desplegable.
Bases de datos
Opciones para visualizar las bases de datos.
Bases de datos
Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos
Cadena que separa bases de datos en diferentes niveles de árbol.
Tablas
Opciones para visualizar las tablas.
Tablas
Destino para el icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Objetivo para el segundo icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Separador de árbol de tablas
Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas
Suelte aquí los archivos
Carga SQL (
0
)
x
-
Mostrar los elementos escondidos del árbol de navegación.
Crear vista
¡Pasado este punto, debe tener Javascript activado!
Servidor: 127.0.0.1
Base de datos: sma_import_tmp
Estructura
SQL
Buscar
Generar una consulta
(actual)
Exportar
Importar
Operaciones
Privilegios
Rutinas
Eventos
Disparadores
Seguimiento
Diseñador
Columnas centrales
Consola
Limpiar
Historial
Opciones
Favoritos
Depuración SQL
Presione Ctrl+Enter para ejecutar la consulta
Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar
Expandir
Mostrar rastro
Ocultar rastro
Cantidad :
Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Etiqueta:
Base de datos de destino:
Compartir favorito
OK
Opciones
Definir predeterminado
Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas en Enter e inserte una nueva línea con Shift+Enter. Para que esto sea permanente, consulte la configuración.
Cambiar al tema oscuro
Colapsar
Expandir
Reconsultar
Editar
Explicar
Perfilando
Agregar a favoritos
Falló la consulta
Base de datos :
Fecha y hora la consulta :
Cargando
Editor de ENUM/SET
Crear vista
Consulta multitabla
Consulta por ejemplo
Cambiar al
constructor visual
Búsquedas favoritas guardadas:
Nuevo favorito
Columna:
`sma_addresses`.*
`sma_addresses`.`id`
`sma_addresses`.`company_id`
`sma_addresses`.`line1`
`sma_addresses`.`line2`
`sma_addresses`.`city`
`sma_addresses`.`postal_code`
`sma_addresses`.`state`
`sma_addresses`.`country`
`sma_addresses`.`phone`
`sma_addresses`.`updated_at`
`sma_adjustment_items`.*
`sma_adjustment_items`.`id`
`sma_adjustment_items`.`adjustment_id`
`sma_adjustment_items`.`product_id`
`sma_adjustment_items`.`option_id`
`sma_adjustment_items`.`quantity`
`sma_adjustment_items`.`warehouse_id`
`sma_adjustment_items`.`serial_no`
`sma_adjustment_items`.`type`
`sma_adjustments`.*
`sma_adjustments`.`id`
`sma_adjustments`.`date`
`sma_adjustments`.`reference_no`
`sma_adjustments`.`warehouse_id`
`sma_adjustments`.`note`
`sma_adjustments`.`attachment`
`sma_adjustments`.`created_by`
`sma_adjustments`.`updated_by`
`sma_adjustments`.`updated_at`
`sma_adjustments`.`count_id`
`sma_api_keys`.*
`sma_api_keys`.`id`
`sma_api_keys`.`user_id`
`sma_api_keys`.`reference`
`sma_api_keys`.`key`
`sma_api_keys`.`level`
`sma_api_keys`.`ignore_limits`
`sma_api_keys`.`is_private_key`
`sma_api_keys`.`ip_addresses`
`sma_api_keys`.`date_created`
`sma_api_limits`.*
`sma_api_limits`.`id`
`sma_api_limits`.`uri`
`sma_api_limits`.`count`
`sma_api_limits`.`hour_started`
`sma_api_limits`.`api_key`
`sma_api_logs`.*
`sma_api_logs`.`id`
`sma_api_logs`.`uri`
`sma_api_logs`.`method`
`sma_api_logs`.`params`
`sma_api_logs`.`api_key`
`sma_api_logs`.`ip_address`
`sma_api_logs`.`time`
`sma_api_logs`.`rtime`
`sma_api_logs`.`authorized`
`sma_api_logs`.`response_code`
`sma_attachments`.*
`sma_attachments`.`id`
`sma_attachments`.`subject_id`
`sma_attachments`.`subject_type`
`sma_attachments`.`file_name`
`sma_attachments`.`orig_name`
`sma_brands`.*
`sma_brands`.`id`
`sma_brands`.`code`
`sma_brands`.`name`
`sma_brands`.`image`
`sma_brands`.`slug`
`sma_brands`.`description`
`sma_calendar`.*
`sma_calendar`.`id`
`sma_calendar`.`title`
`sma_calendar`.`description`
`sma_calendar`.`start`
`sma_calendar`.`end`
`sma_calendar`.`color`
`sma_calendar`.`user_id`
`sma_captcha`.*
`sma_captcha`.`captcha_id`
`sma_captcha`.`captcha_time`
`sma_captcha`.`ip_address`
`sma_captcha`.`word`
`sma_cart`.*
`sma_cart`.`id`
`sma_cart`.`time`
`sma_cart`.`user_id`
`sma_cart`.`data`
`sma_categories`.*
`sma_categories`.`id`
`sma_categories`.`code`
`sma_categories`.`name`
`sma_categories`.`image`
`sma_categories`.`parent_id`
`sma_categories`.`slug`
`sma_categories`.`description`
`sma_combo_items`.*
`sma_combo_items`.`id`
`sma_combo_items`.`product_id`
`sma_combo_items`.`item_code`
`sma_combo_items`.`quantity`
`sma_combo_items`.`unit_price`
`sma_companies`.*
`sma_companies`.`id`
`sma_companies`.`group_id`
`sma_companies`.`group_name`
`sma_companies`.`customer_group_id`
`sma_companies`.`customer_group_name`
`sma_companies`.`name`
`sma_companies`.`company`
`sma_companies`.`vat_no`
`sma_companies`.`address`
`sma_companies`.`city`
`sma_companies`.`state`
`sma_companies`.`postal_code`
`sma_companies`.`country`
`sma_companies`.`phone`
`sma_companies`.`email`
`sma_companies`.`cf1`
`sma_companies`.`cf2`
`sma_companies`.`cf3`
`sma_companies`.`cf4`
`sma_companies`.`cf5`
`sma_companies`.`cf6`
`sma_companies`.`invoice_footer`
`sma_companies`.`payment_term`
`sma_companies`.`logo`
`sma_companies`.`award_points`
`sma_companies`.`deposit_amount`
`sma_companies`.`price_group_id`
`sma_companies`.`price_group_name`
`sma_companies`.`gst_no`
`sma_costing`.*
`sma_costing`.`id`
`sma_costing`.`date`
`sma_costing`.`product_id`
`sma_costing`.`sale_item_id`
`sma_costing`.`sale_id`
`sma_costing`.`purchase_item_id`
`sma_costing`.`quantity`
`sma_costing`.`purchase_net_unit_cost`
`sma_costing`.`purchase_unit_cost`
`sma_costing`.`sale_net_unit_price`
`sma_costing`.`sale_unit_price`
`sma_costing`.`quantity_balance`
`sma_costing`.`inventory`
`sma_costing`.`overselling`
`sma_costing`.`option_id`
`sma_costing`.`purchase_id`
`sma_costing`.`transfer_id`
`sma_currencies`.*
`sma_currencies`.`id`
`sma_currencies`.`code`
`sma_currencies`.`name`
`sma_currencies`.`rate`
`sma_currencies`.`auto_update`
`sma_currencies`.`symbol`
`sma_customer_groups`.*
`sma_customer_groups`.`id`
`sma_customer_groups`.`name`
`sma_customer_groups`.`percent`
`sma_customer_groups`.`discount`
`sma_date_format`.*
`sma_date_format`.`id`
`sma_date_format`.`js`
`sma_date_format`.`php`
`sma_date_format`.`sql`
`sma_deliveries`.*
`sma_deliveries`.`id`
`sma_deliveries`.`date`
`sma_deliveries`.`sale_id`
`sma_deliveries`.`do_reference_no`
`sma_deliveries`.`sale_reference_no`
`sma_deliveries`.`customer`
`sma_deliveries`.`address`
`sma_deliveries`.`note`
`sma_deliveries`.`status`
`sma_deliveries`.`attachment`
`sma_deliveries`.`delivered_by`
`sma_deliveries`.`received_by`
`sma_deliveries`.`created_by`
`sma_deliveries`.`updated_by`
`sma_deliveries`.`updated_at`
`sma_deposits`.*
`sma_deposits`.`id`
`sma_deposits`.`date`
`sma_deposits`.`company_id`
`sma_deposits`.`amount`
`sma_deposits`.`paid_by`
`sma_deposits`.`note`
`sma_deposits`.`created_by`
`sma_deposits`.`updated_by`
`sma_deposits`.`updated_at`
`sma_expense_categories`.*
`sma_expense_categories`.`id`
`sma_expense_categories`.`code`
`sma_expense_categories`.`name`
`sma_expenses`.*
`sma_expenses`.`id`
`sma_expenses`.`date`
`sma_expenses`.`reference`
`sma_expenses`.`amount`
`sma_expenses`.`note`
`sma_expenses`.`created_by`
`sma_expenses`.`attachment`
`sma_expenses`.`category_id`
`sma_expenses`.`warehouse_id`
`sma_gift_card_topups`.*
`sma_gift_card_topups`.`id`
`sma_gift_card_topups`.`date`
`sma_gift_card_topups`.`card_id`
`sma_gift_card_topups`.`amount`
`sma_gift_card_topups`.`created_by`
`sma_gift_cards`.*
`sma_gift_cards`.`id`
`sma_gift_cards`.`date`
`sma_gift_cards`.`card_no`
`sma_gift_cards`.`value`
`sma_gift_cards`.`customer_id`
`sma_gift_cards`.`customer`
`sma_gift_cards`.`balance`
`sma_gift_cards`.`expiry`
`sma_gift_cards`.`created_by`
`sma_groups`.*
`sma_groups`.`id`
`sma_groups`.`name`
`sma_groups`.`description`
`sma_login_attempts`.*
`sma_login_attempts`.`id`
`sma_login_attempts`.`ip_address`
`sma_login_attempts`.`login`
`sma_login_attempts`.`time`
`sma_logs`.*
`sma_logs`.`id`
`sma_logs`.`detail`
`sma_logs`.`model`
`sma_logs`.`date`
`sma_migrations`.*
`sma_migrations`.`version`
`sma_notifications`.*
`sma_notifications`.`id`
`sma_notifications`.`comment`
`sma_notifications`.`date`
`sma_notifications`.`from_date`
`sma_notifications`.`till_date`
`sma_notifications`.`scope`
`sma_order_ref`.*
`sma_order_ref`.`ref_id`
`sma_order_ref`.`date`
`sma_order_ref`.`so`
`sma_order_ref`.`qu`
`sma_order_ref`.`po`
`sma_order_ref`.`to`
`sma_order_ref`.`pos`
`sma_order_ref`.`do`
`sma_order_ref`.`pay`
`sma_order_ref`.`re`
`sma_order_ref`.`rep`
`sma_order_ref`.`ex`
`sma_order_ref`.`ppay`
`sma_order_ref`.`qa`
`sma_pages`.*
`sma_pages`.`id`
`sma_pages`.`name`
`sma_pages`.`title`
`sma_pages`.`description`
`sma_pages`.`slug`
`sma_pages`.`body`
`sma_pages`.`active`
`sma_pages`.`updated_at`
`sma_pages`.`order_no`
`sma_payments`.*
`sma_payments`.`id`
`sma_payments`.`date`
`sma_payments`.`sale_id`
`sma_payments`.`return_id`
`sma_payments`.`purchase_id`
`sma_payments`.`reference_no`
`sma_payments`.`transaction_id`
`sma_payments`.`paid_by`
`sma_payments`.`cheque_no`
`sma_payments`.`cc_no`
`sma_payments`.`cc_holder`
`sma_payments`.`cc_month`
`sma_payments`.`cc_year`
`sma_payments`.`cc_type`
`sma_payments`.`amount`
`sma_payments`.`currency`
`sma_payments`.`created_by`
`sma_payments`.`attachment`
`sma_payments`.`type`
`sma_payments`.`note`
`sma_payments`.`pos_paid`
`sma_payments`.`pos_balance`
`sma_payments`.`approval_code`
`sma_paypal`.*
`sma_paypal`.`id`
`sma_paypal`.`active`
`sma_paypal`.`account_email`
`sma_paypal`.`paypal_currency`
`sma_paypal`.`fixed_charges`
`sma_paypal`.`extra_charges_my`
`sma_paypal`.`extra_charges_other`
`sma_permissions`.*
`sma_permissions`.`id`
`sma_permissions`.`group_id`
`sma_permissions`.`products-index`
`sma_permissions`.`products-add`
`sma_permissions`.`products-edit`
`sma_permissions`.`products-delete`
`sma_permissions`.`products-cost`
`sma_permissions`.`products-price`
`sma_permissions`.`quotes-index`
`sma_permissions`.`quotes-add`
`sma_permissions`.`quotes-edit`
`sma_permissions`.`quotes-pdf`
`sma_permissions`.`quotes-email`
`sma_permissions`.`quotes-delete`
`sma_permissions`.`sales-index`
`sma_permissions`.`sales-add`
`sma_permissions`.`sales-edit`
`sma_permissions`.`sales-pdf`
`sma_permissions`.`sales-email`
`sma_permissions`.`sales-delete`
`sma_permissions`.`purchases-index`
`sma_permissions`.`purchases-add`
`sma_permissions`.`purchases-edit`
`sma_permissions`.`purchases-pdf`
`sma_permissions`.`purchases-email`
`sma_permissions`.`purchases-delete`
`sma_permissions`.`transfers-index`
`sma_permissions`.`transfers-add`
`sma_permissions`.`transfers-edit`
`sma_permissions`.`transfers-pdf`
`sma_permissions`.`transfers-email`
`sma_permissions`.`transfers-delete`
`sma_permissions`.`customers-index`
`sma_permissions`.`customers-add`
`sma_permissions`.`customers-edit`
`sma_permissions`.`customers-delete`
`sma_permissions`.`suppliers-index`
`sma_permissions`.`suppliers-add`
`sma_permissions`.`suppliers-edit`
`sma_permissions`.`suppliers-delete`
`sma_permissions`.`sales-deliveries`
`sma_permissions`.`sales-add_delivery`
`sma_permissions`.`sales-edit_delivery`
`sma_permissions`.`sales-delete_delivery`
`sma_permissions`.`sales-email_delivery`
`sma_permissions`.`sales-pdf_delivery`
`sma_permissions`.`sales-gift_cards`
`sma_permissions`.`sales-add_gift_card`
`sma_permissions`.`sales-edit_gift_card`
`sma_permissions`.`sales-delete_gift_card`
`sma_permissions`.`pos-index`
`sma_permissions`.`sales-return_sales`
`sma_permissions`.`reports-index`
`sma_permissions`.`reports-warehouse_stock`
`sma_permissions`.`reports-quantity_alerts`
`sma_permissions`.`reports-expiry_alerts`
`sma_permissions`.`reports-products`
`sma_permissions`.`reports-daily_sales`
`sma_permissions`.`reports-monthly_sales`
`sma_permissions`.`reports-sales`
`sma_permissions`.`reports-payments`
`sma_permissions`.`reports-purchases`
`sma_permissions`.`reports-profit_loss`
`sma_permissions`.`reports-customers`
`sma_permissions`.`reports-suppliers`
`sma_permissions`.`reports-staff`
`sma_permissions`.`reports-register`
`sma_permissions`.`sales-payments`
`sma_permissions`.`purchases-payments`
`sma_permissions`.`purchases-expenses`
`sma_permissions`.`products-adjustments`
`sma_permissions`.`bulk_actions`
`sma_permissions`.`customers-deposits`
`sma_permissions`.`customers-delete_deposit`
`sma_permissions`.`products-barcode`
`sma_permissions`.`purchases-return_purchases`
`sma_permissions`.`reports-expenses`
`sma_permissions`.`reports-daily_purchases`
`sma_permissions`.`reports-monthly_purchases`
`sma_permissions`.`products-stock_count`
`sma_permissions`.`edit_price`
`sma_permissions`.`returns-index`
`sma_permissions`.`returns-add`
`sma_permissions`.`returns-edit`
`sma_permissions`.`returns-delete`
`sma_permissions`.`returns-email`
`sma_permissions`.`returns-pdf`
`sma_permissions`.`reports-tax`
`sma_pos_register`.*
`sma_pos_register`.`id`
`sma_pos_register`.`date`
`sma_pos_register`.`user_id`
`sma_pos_register`.`cash_in_hand`
`sma_pos_register`.`status`
`sma_pos_register`.`total_cash`
`sma_pos_register`.`total_cheques`
`sma_pos_register`.`total_cc_slips`
`sma_pos_register`.`total_cash_submitted`
`sma_pos_register`.`total_cheques_submitted`
`sma_pos_register`.`total_cc_slips_submitted`
`sma_pos_register`.`note`
`sma_pos_register`.`closed_at`
`sma_pos_register`.`transfer_opened_bills`
`sma_pos_register`.`closed_by`
`sma_pos_settings`.*
`sma_pos_settings`.`pos_id`
`sma_pos_settings`.`cat_limit`
`sma_pos_settings`.`pro_limit`
`sma_pos_settings`.`default_category`
`sma_pos_settings`.`default_customer`
`sma_pos_settings`.`default_biller`
`sma_pos_settings`.`display_time`
`sma_pos_settings`.`cf_title1`
`sma_pos_settings`.`cf_title2`
`sma_pos_settings`.`cf_value1`
`sma_pos_settings`.`cf_value2`
`sma_pos_settings`.`receipt_printer`
`sma_pos_settings`.`cash_drawer_codes`
`sma_pos_settings`.`focus_add_item`
`sma_pos_settings`.`add_manual_product`
`sma_pos_settings`.`customer_selection`
`sma_pos_settings`.`add_customer`
`sma_pos_settings`.`toggle_category_slider`
`sma_pos_settings`.`toggle_subcategory_slider`
`sma_pos_settings`.`cancel_sale`
`sma_pos_settings`.`suspend_sale`
`sma_pos_settings`.`print_items_list`
`sma_pos_settings`.`finalize_sale`
`sma_pos_settings`.`today_sale`
`sma_pos_settings`.`open_hold_bills`
`sma_pos_settings`.`close_register`
`sma_pos_settings`.`keyboard`
`sma_pos_settings`.`pos_printers`
`sma_pos_settings`.`java_applet`
`sma_pos_settings`.`product_button_color`
`sma_pos_settings`.`tooltips`
`sma_pos_settings`.`paypal_pro`
`sma_pos_settings`.`stripe`
`sma_pos_settings`.`rounding`
`sma_pos_settings`.`char_per_line`
`sma_pos_settings`.`pin_code`
`sma_pos_settings`.`purchase_code`
`sma_pos_settings`.`envato_username`
`sma_pos_settings`.`version`
`sma_pos_settings`.`after_sale_page`
`sma_pos_settings`.`item_order`
`sma_pos_settings`.`authorize`
`sma_pos_settings`.`toggle_brands_slider`
`sma_pos_settings`.`remote_printing`
`sma_pos_settings`.`printer`
`sma_pos_settings`.`order_printers`
`sma_pos_settings`.`auto_print`
`sma_pos_settings`.`customer_details`
`sma_pos_settings`.`local_printers`
`sma_price_groups`.*
`sma_price_groups`.`id`
`sma_price_groups`.`name`
`sma_printers`.*
`sma_printers`.`id`
`sma_printers`.`title`
`sma_printers`.`type`
`sma_printers`.`profile`
`sma_printers`.`char_per_line`
`sma_printers`.`path`
`sma_printers`.`ip_address`
`sma_printers`.`port`
`sma_product_photos`.*
`sma_product_photos`.`id`
`sma_product_photos`.`product_id`
`sma_product_photos`.`photo`
`sma_product_prices`.*
`sma_product_prices`.`id`
`sma_product_prices`.`product_id`
`sma_product_prices`.`price_group_id`
`sma_product_prices`.`price`
`sma_product_variants`.*
`sma_product_variants`.`id`
`sma_product_variants`.`product_id`
`sma_product_variants`.`name`
`sma_product_variants`.`cost`
`sma_product_variants`.`price`
`sma_product_variants`.`quantity`
`sma_products`.*
`sma_products`.`id`
`sma_products`.`code`
`sma_products`.`name`
`sma_products`.`unit`
`sma_products`.`cost`
`sma_products`.`price`
`sma_products`.`alert_quantity`
`sma_products`.`image`
`sma_products`.`category_id`
`sma_products`.`subcategory_id`
`sma_products`.`cf1`
`sma_products`.`cf2`
`sma_products`.`cf3`
`sma_products`.`cf4`
`sma_products`.`cf5`
`sma_products`.`cf6`
`sma_products`.`quantity`
`sma_products`.`tax_rate`
`sma_products`.`track_quantity`
`sma_products`.`details`
`sma_products`.`warehouse`
`sma_products`.`barcode_symbology`
`sma_products`.`file`
`sma_products`.`product_details`
`sma_products`.`tax_method`
`sma_products`.`type`
`sma_products`.`supplier1`
`sma_products`.`supplier1price`
`sma_products`.`supplier2`
`sma_products`.`supplier2price`
`sma_products`.`supplier3`
`sma_products`.`supplier3price`
`sma_products`.`supplier4`
`sma_products`.`supplier4price`
`sma_products`.`supplier5`
`sma_products`.`supplier5price`
`sma_products`.`promotion`
`sma_products`.`promo_price`
`sma_products`.`start_date`
`sma_products`.`end_date`
`sma_products`.`supplier1_part_no`
`sma_products`.`supplier2_part_no`
`sma_products`.`supplier3_part_no`
`sma_products`.`supplier4_part_no`
`sma_products`.`supplier5_part_no`
`sma_products`.`sale_unit`
`sma_products`.`purchase_unit`
`sma_products`.`brand`
`sma_products`.`slug`
`sma_products`.`featured`
`sma_products`.`weight`
`sma_products`.`hsn_code`
`sma_products`.`views`
`sma_products`.`hide`
`sma_products`.`second_name`
`sma_products`.`hide_pos`
`sma_promos`.*
`sma_promos`.`id`
`sma_promos`.`name`
`sma_promos`.`product2buy`
`sma_promos`.`product2get`
`sma_promos`.`start_date`
`sma_promos`.`end_date`
`sma_promos`.`description`
`sma_purchase_items`.*
`sma_purchase_items`.`id`
`sma_purchase_items`.`purchase_id`
`sma_purchase_items`.`transfer_id`
`sma_purchase_items`.`product_id`
`sma_purchase_items`.`product_code`
`sma_purchase_items`.`product_name`
`sma_purchase_items`.`option_id`
`sma_purchase_items`.`net_unit_cost`
`sma_purchase_items`.`quantity`
`sma_purchase_items`.`warehouse_id`
`sma_purchase_items`.`item_tax`
`sma_purchase_items`.`tax_rate_id`
`sma_purchase_items`.`tax`
`sma_purchase_items`.`discount`
`sma_purchase_items`.`item_discount`
`sma_purchase_items`.`expiry`
`sma_purchase_items`.`subtotal`
`sma_purchase_items`.`quantity_balance`
`sma_purchase_items`.`date`
`sma_purchase_items`.`status`
`sma_purchase_items`.`unit_cost`
`sma_purchase_items`.`real_unit_cost`
`sma_purchase_items`.`quantity_received`
`sma_purchase_items`.`supplier_part_no`
`sma_purchase_items`.`purchase_item_id`
`sma_purchase_items`.`product_unit_id`
`sma_purchase_items`.`product_unit_code`
`sma_purchase_items`.`unit_quantity`
`sma_purchase_items`.`gst`
`sma_purchase_items`.`cgst`
`sma_purchase_items`.`sgst`
`sma_purchase_items`.`igst`
`sma_purchase_items`.`base_unit_cost`
`sma_purchases`.*
`sma_purchases`.`id`
`sma_purchases`.`reference_no`
`sma_purchases`.`date`
`sma_purchases`.`supplier_id`
`sma_purchases`.`supplier`
`sma_purchases`.`warehouse_id`
`sma_purchases`.`note`
`sma_purchases`.`total`
`sma_purchases`.`product_discount`
`sma_purchases`.`order_discount_id`
`sma_purchases`.`order_discount`
`sma_purchases`.`total_discount`
`sma_purchases`.`product_tax`
`sma_purchases`.`order_tax_id`
`sma_purchases`.`order_tax`
`sma_purchases`.`total_tax`
`sma_purchases`.`shipping`
`sma_purchases`.`grand_total`
`sma_purchases`.`paid`
`sma_purchases`.`status`
`sma_purchases`.`payment_status`
`sma_purchases`.`created_by`
`sma_purchases`.`updated_by`
`sma_purchases`.`updated_at`
`sma_purchases`.`attachment`
`sma_purchases`.`payment_term`
`sma_purchases`.`due_date`
`sma_purchases`.`return_id`
`sma_purchases`.`surcharge`
`sma_purchases`.`return_purchase_ref`
`sma_purchases`.`purchase_id`
`sma_purchases`.`return_purchase_total`
`sma_purchases`.`cgst`
`sma_purchases`.`sgst`
`sma_purchases`.`igst`
`sma_quote_items`.*
`sma_quote_items`.`id`
`sma_quote_items`.`quote_id`
`sma_quote_items`.`product_id`
`sma_quote_items`.`product_code`
`sma_quote_items`.`product_name`
`sma_quote_items`.`product_type`
`sma_quote_items`.`option_id`
`sma_quote_items`.`net_unit_price`
`sma_quote_items`.`unit_price`
`sma_quote_items`.`quantity`
`sma_quote_items`.`warehouse_id`
`sma_quote_items`.`item_tax`
`sma_quote_items`.`tax_rate_id`
`sma_quote_items`.`tax`
`sma_quote_items`.`discount`
`sma_quote_items`.`item_discount`
`sma_quote_items`.`subtotal`
`sma_quote_items`.`serial_no`
`sma_quote_items`.`real_unit_price`
`sma_quote_items`.`product_unit_id`
`sma_quote_items`.`product_unit_code`
`sma_quote_items`.`unit_quantity`
`sma_quote_items`.`gst`
`sma_quote_items`.`cgst`
`sma_quote_items`.`sgst`
`sma_quote_items`.`igst`
`sma_quotes`.*
`sma_quotes`.`id`
`sma_quotes`.`date`
`sma_quotes`.`reference_no`
`sma_quotes`.`customer_id`
`sma_quotes`.`customer`
`sma_quotes`.`warehouse_id`
`sma_quotes`.`biller_id`
`sma_quotes`.`biller`
`sma_quotes`.`note`
`sma_quotes`.`internal_note`
`sma_quotes`.`total`
`sma_quotes`.`product_discount`
`sma_quotes`.`order_discount`
`sma_quotes`.`order_discount_id`
`sma_quotes`.`total_discount`
`sma_quotes`.`product_tax`
`sma_quotes`.`order_tax_id`
`sma_quotes`.`order_tax`
`sma_quotes`.`total_tax`
`sma_quotes`.`shipping`
`sma_quotes`.`grand_total`
`sma_quotes`.`status`
`sma_quotes`.`created_by`
`sma_quotes`.`updated_by`
`sma_quotes`.`updated_at`
`sma_quotes`.`attachment`
`sma_quotes`.`supplier_id`
`sma_quotes`.`supplier`
`sma_quotes`.`hash`
`sma_quotes`.`cgst`
`sma_quotes`.`sgst`
`sma_quotes`.`igst`
`sma_return_items`.*
`sma_return_items`.`id`
`sma_return_items`.`return_id`
`sma_return_items`.`product_id`
`sma_return_items`.`product_code`
`sma_return_items`.`product_name`
`sma_return_items`.`product_type`
`sma_return_items`.`option_id`
`sma_return_items`.`net_unit_price`
`sma_return_items`.`unit_price`
`sma_return_items`.`quantity`
`sma_return_items`.`warehouse_id`
`sma_return_items`.`item_tax`
`sma_return_items`.`tax_rate_id`
`sma_return_items`.`tax`
`sma_return_items`.`discount`
`sma_return_items`.`item_discount`
`sma_return_items`.`subtotal`
`sma_return_items`.`serial_no`
`sma_return_items`.`real_unit_price`
`sma_return_items`.`product_unit_id`
`sma_return_items`.`product_unit_code`
`sma_return_items`.`unit_quantity`
`sma_return_items`.`comment`
`sma_return_items`.`gst`
`sma_return_items`.`cgst`
`sma_return_items`.`sgst`
`sma_return_items`.`igst`
`sma_returns`.*
`sma_returns`.`id`
`sma_returns`.`date`
`sma_returns`.`reference_no`
`sma_returns`.`customer_id`
`sma_returns`.`customer`
`sma_returns`.`biller_id`
`sma_returns`.`biller`
`sma_returns`.`warehouse_id`
`sma_returns`.`note`
`sma_returns`.`staff_note`
`sma_returns`.`total`
`sma_returns`.`product_discount`
`sma_returns`.`order_discount_id`
`sma_returns`.`total_discount`
`sma_returns`.`order_discount`
`sma_returns`.`product_tax`
`sma_returns`.`order_tax_id`
`sma_returns`.`order_tax`
`sma_returns`.`total_tax`
`sma_returns`.`grand_total`
`sma_returns`.`created_by`
`sma_returns`.`updated_by`
`sma_returns`.`updated_at`
`sma_returns`.`total_items`
`sma_returns`.`paid`
`sma_returns`.`surcharge`
`sma_returns`.`attachment`
`sma_returns`.`hash`
`sma_returns`.`cgst`
`sma_returns`.`sgst`
`sma_returns`.`igst`
`sma_returns`.`shipping`
`sma_sale_items`.*
`sma_sale_items`.`id`
`sma_sale_items`.`sale_id`
`sma_sale_items`.`product_id`
`sma_sale_items`.`product_code`
`sma_sale_items`.`product_name`
`sma_sale_items`.`product_type`
`sma_sale_items`.`option_id`
`sma_sale_items`.`net_unit_price`
`sma_sale_items`.`unit_price`
`sma_sale_items`.`quantity`
`sma_sale_items`.`warehouse_id`
`sma_sale_items`.`item_tax`
`sma_sale_items`.`tax_rate_id`
`sma_sale_items`.`tax`
`sma_sale_items`.`discount`
`sma_sale_items`.`item_discount`
`sma_sale_items`.`subtotal`
`sma_sale_items`.`serial_no`
`sma_sale_items`.`real_unit_price`
`sma_sale_items`.`sale_item_id`
`sma_sale_items`.`product_unit_id`
`sma_sale_items`.`product_unit_code`
`sma_sale_items`.`unit_quantity`
`sma_sale_items`.`comment`
`sma_sale_items`.`gst`
`sma_sale_items`.`cgst`
`sma_sale_items`.`sgst`
`sma_sale_items`.`igst`
`sma_sales`.*
`sma_sales`.`id`
`sma_sales`.`date`
`sma_sales`.`reference_no`
`sma_sales`.`customer_id`
`sma_sales`.`customer`
`sma_sales`.`biller_id`
`sma_sales`.`biller`
`sma_sales`.`warehouse_id`
`sma_sales`.`note`
`sma_sales`.`staff_note`
`sma_sales`.`total`
`sma_sales`.`product_discount`
`sma_sales`.`order_discount_id`
`sma_sales`.`total_discount`
`sma_sales`.`order_discount`
`sma_sales`.`product_tax`
`sma_sales`.`order_tax_id`
`sma_sales`.`order_tax`
`sma_sales`.`total_tax`
`sma_sales`.`shipping`
`sma_sales`.`grand_total`
`sma_sales`.`sale_status`
`sma_sales`.`payment_status`
`sma_sales`.`payment_term`
`sma_sales`.`due_date`
`sma_sales`.`created_by`
`sma_sales`.`updated_by`
`sma_sales`.`updated_at`
`sma_sales`.`total_items`
`sma_sales`.`pos`
`sma_sales`.`paid`
`sma_sales`.`return_id`
`sma_sales`.`surcharge`
`sma_sales`.`attachment`
`sma_sales`.`return_sale_ref`
`sma_sales`.`sale_id`
`sma_sales`.`return_sale_total`
`sma_sales`.`rounding`
`sma_sales`.`suspend_note`
`sma_sales`.`api`
`sma_sales`.`shop`
`sma_sales`.`address_id`
`sma_sales`.`reserve_id`
`sma_sales`.`hash`
`sma_sales`.`manual_payment`
`sma_sales`.`cgst`
`sma_sales`.`sgst`
`sma_sales`.`igst`
`sma_sales`.`payment_method`
`sma_sessions`.*
`sma_sessions`.`id`
`sma_sessions`.`ip_address`
`sma_sessions`.`timestamp`
`sma_sessions`.`data`
`sma_settings`.*
`sma_settings`.`setting_id`
`sma_settings`.`logo`
`sma_settings`.`logo2`
`sma_settings`.`site_name`
`sma_settings`.`language`
`sma_settings`.`default_warehouse`
`sma_settings`.`accounting_method`
`sma_settings`.`default_currency`
`sma_settings`.`default_tax_rate`
`sma_settings`.`rows_per_page`
`sma_settings`.`version`
`sma_settings`.`default_tax_rate2`
`sma_settings`.`dateformat`
`sma_settings`.`sales_prefix`
`sma_settings`.`quote_prefix`
`sma_settings`.`purchase_prefix`
`sma_settings`.`transfer_prefix`
`sma_settings`.`delivery_prefix`
`sma_settings`.`payment_prefix`
`sma_settings`.`return_prefix`
`sma_settings`.`returnp_prefix`
`sma_settings`.`expense_prefix`
`sma_settings`.`item_addition`
`sma_settings`.`theme`
`sma_settings`.`product_serial`
`sma_settings`.`default_discount`
`sma_settings`.`product_discount`
`sma_settings`.`discount_method`
`sma_settings`.`tax1`
`sma_settings`.`tax2`
`sma_settings`.`overselling`
`sma_settings`.`restrict_user`
`sma_settings`.`restrict_calendar`
`sma_settings`.`timezone`
`sma_settings`.`iwidth`
`sma_settings`.`iheight`
`sma_settings`.`twidth`
`sma_settings`.`theight`
`sma_settings`.`watermark`
`sma_settings`.`reg_ver`
`sma_settings`.`allow_reg`
`sma_settings`.`reg_notification`
`sma_settings`.`auto_reg`
`sma_settings`.`protocol`
`sma_settings`.`mailpath`
`sma_settings`.`smtp_host`
`sma_settings`.`smtp_user`
`sma_settings`.`smtp_pass`
`sma_settings`.`smtp_port`
`sma_settings`.`smtp_crypto`
`sma_settings`.`corn`
`sma_settings`.`customer_group`
`sma_settings`.`default_email`
`sma_settings`.`mmode`
`sma_settings`.`bc_fix`
`sma_settings`.`auto_detect_barcode`
`sma_settings`.`captcha`
`sma_settings`.`reference_format`
`sma_settings`.`racks`
`sma_settings`.`attributes`
`sma_settings`.`product_expiry`
`sma_settings`.`decimals`
`sma_settings`.`qty_decimals`
`sma_settings`.`decimals_sep`
`sma_settings`.`thousands_sep`
`sma_settings`.`invoice_view`
`sma_settings`.`default_biller`
`sma_settings`.`envato_username`
`sma_settings`.`purchase_code`
`sma_settings`.`rtl`
`sma_settings`.`each_spent`
`sma_settings`.`ca_point`
`sma_settings`.`each_sale`
`sma_settings`.`sa_point`
`sma_settings`.`update`
`sma_settings`.`sac`
`sma_settings`.`display_all_products`
`sma_settings`.`display_symbol`
`sma_settings`.`symbol`
`sma_settings`.`remove_expired`
`sma_settings`.`barcode_separator`
`sma_settings`.`set_focus`
`sma_settings`.`price_group`
`sma_settings`.`barcode_img`
`sma_settings`.`ppayment_prefix`
`sma_settings`.`disable_editing`
`sma_settings`.`qa_prefix`
`sma_settings`.`update_cost`
`sma_settings`.`apis`
`sma_settings`.`state`
`sma_settings`.`pdf_lib`
`sma_settings`.`use_code_for_slug`
`sma_settings`.`ws_barcode_type`
`sma_settings`.`ws_barcode_chars`
`sma_settings`.`flag_chars`
`sma_settings`.`item_code_start`
`sma_settings`.`item_code_chars`
`sma_settings`.`price_start`
`sma_settings`.`price_chars`
`sma_settings`.`price_divide_by`
`sma_settings`.`weight_start`
`sma_settings`.`weight_chars`
`sma_settings`.`weight_divide_by`
`sma_settings`.`ksa_qrcode`
`sma_shop_settings`.*
`sma_shop_settings`.`shop_id`
`sma_shop_settings`.`shop_name`
`sma_shop_settings`.`description`
`sma_shop_settings`.`warehouse`
`sma_shop_settings`.`biller`
`sma_shop_settings`.`about_link`
`sma_shop_settings`.`terms_link`
`sma_shop_settings`.`privacy_link`
`sma_shop_settings`.`contact_link`
`sma_shop_settings`.`payment_text`
`sma_shop_settings`.`follow_text`
`sma_shop_settings`.`facebook`
`sma_shop_settings`.`twitter`
`sma_shop_settings`.`google_plus`
`sma_shop_settings`.`instagram`
`sma_shop_settings`.`phone`
`sma_shop_settings`.`email`
`sma_shop_settings`.`cookie_message`
`sma_shop_settings`.`cookie_link`
`sma_shop_settings`.`slider`
`sma_shop_settings`.`shipping`
`sma_shop_settings`.`purchase_code`
`sma_shop_settings`.`envato_username`
`sma_shop_settings`.`version`
`sma_shop_settings`.`logo`
`sma_shop_settings`.`bank_details`
`sma_shop_settings`.`products_page`
`sma_shop_settings`.`hide0`
`sma_shop_settings`.`products_description`
`sma_shop_settings`.`private`
`sma_shop_settings`.`hide_price`
`sma_shop_settings`.`stripe`
`sma_skrill`.*
`sma_skrill`.`id`
`sma_skrill`.`active`
`sma_skrill`.`account_email`
`sma_skrill`.`secret_word`
`sma_skrill`.`skrill_currency`
`sma_skrill`.`fixed_charges`
`sma_skrill`.`extra_charges_my`
`sma_skrill`.`extra_charges_other`
`sma_sms_settings`.*
`sma_sms_settings`.`id`
`sma_sms_settings`.`auto_send`
`sma_sms_settings`.`config`
`sma_stock_count_items`.*
`sma_stock_count_items`.`id`
`sma_stock_count_items`.`stock_count_id`
`sma_stock_count_items`.`product_id`
`sma_stock_count_items`.`product_code`
`sma_stock_count_items`.`product_name`
`sma_stock_count_items`.`product_variant`
`sma_stock_count_items`.`product_variant_id`
`sma_stock_count_items`.`expected`
`sma_stock_count_items`.`counted`
`sma_stock_count_items`.`cost`
`sma_stock_counts`.*
`sma_stock_counts`.`id`
`sma_stock_counts`.`date`
`sma_stock_counts`.`reference_no`
`sma_stock_counts`.`warehouse_id`
`sma_stock_counts`.`type`
`sma_stock_counts`.`initial_file`
`sma_stock_counts`.`final_file`
`sma_stock_counts`.`brands`
`sma_stock_counts`.`brand_names`
`sma_stock_counts`.`categories`
`sma_stock_counts`.`category_names`
`sma_stock_counts`.`note`
`sma_stock_counts`.`products`
`sma_stock_counts`.`rows`
`sma_stock_counts`.`differences`
`sma_stock_counts`.`matches`
`sma_stock_counts`.`missing`
`sma_stock_counts`.`created_by`
`sma_stock_counts`.`updated_by`
`sma_stock_counts`.`updated_at`
`sma_stock_counts`.`finalized`
`sma_suspended_bills`.*
`sma_suspended_bills`.`id`
`sma_suspended_bills`.`date`
`sma_suspended_bills`.`customer_id`
`sma_suspended_bills`.`customer`
`sma_suspended_bills`.`count`
`sma_suspended_bills`.`order_discount_id`
`sma_suspended_bills`.`order_tax_id`
`sma_suspended_bills`.`total`
`sma_suspended_bills`.`biller_id`
`sma_suspended_bills`.`warehouse_id`
`sma_suspended_bills`.`created_by`
`sma_suspended_bills`.`suspend_note`
`sma_suspended_bills`.`shipping`
`sma_suspended_bills`.`cgst`
`sma_suspended_bills`.`sgst`
`sma_suspended_bills`.`igst`
`sma_suspended_items`.*
`sma_suspended_items`.`id`
`sma_suspended_items`.`suspend_id`
`sma_suspended_items`.`product_id`
`sma_suspended_items`.`product_code`
`sma_suspended_items`.`product_name`
`sma_suspended_items`.`net_unit_price`
`sma_suspended_items`.`unit_price`
`sma_suspended_items`.`quantity`
`sma_suspended_items`.`warehouse_id`
`sma_suspended_items`.`item_tax`
`sma_suspended_items`.`tax_rate_id`
`sma_suspended_items`.`tax`
`sma_suspended_items`.`discount`
`sma_suspended_items`.`item_discount`
`sma_suspended_items`.`subtotal`
`sma_suspended_items`.`serial_no`
`sma_suspended_items`.`option_id`
`sma_suspended_items`.`product_type`
`sma_suspended_items`.`real_unit_price`
`sma_suspended_items`.`product_unit_id`
`sma_suspended_items`.`product_unit_code`
`sma_suspended_items`.`unit_quantity`
`sma_suspended_items`.`comment`
`sma_suspended_items`.`gst`
`sma_suspended_items`.`cgst`
`sma_suspended_items`.`sgst`
`sma_suspended_items`.`igst`
`sma_tax_rates`.*
`sma_tax_rates`.`id`
`sma_tax_rates`.`name`
`sma_tax_rates`.`code`
`sma_tax_rates`.`rate`
`sma_tax_rates`.`type`
`sma_transfer_items`.*
`sma_transfer_items`.`id`
`sma_transfer_items`.`transfer_id`
`sma_transfer_items`.`product_id`
`sma_transfer_items`.`product_code`
`sma_transfer_items`.`product_name`
`sma_transfer_items`.`option_id`
`sma_transfer_items`.`expiry`
`sma_transfer_items`.`quantity`
`sma_transfer_items`.`tax_rate_id`
`sma_transfer_items`.`tax`
`sma_transfer_items`.`item_tax`
`sma_transfer_items`.`net_unit_cost`
`sma_transfer_items`.`subtotal`
`sma_transfer_items`.`quantity_balance`
`sma_transfer_items`.`unit_cost`
`sma_transfer_items`.`real_unit_cost`
`sma_transfer_items`.`date`
`sma_transfer_items`.`warehouse_id`
`sma_transfer_items`.`product_unit_id`
`sma_transfer_items`.`product_unit_code`
`sma_transfer_items`.`unit_quantity`
`sma_transfer_items`.`gst`
`sma_transfer_items`.`cgst`
`sma_transfer_items`.`sgst`
`sma_transfer_items`.`igst`
`sma_transfers`.*
`sma_transfers`.`id`
`sma_transfers`.`transfer_no`
`sma_transfers`.`date`
`sma_transfers`.`from_warehouse_id`
`sma_transfers`.`from_warehouse_code`
`sma_transfers`.`from_warehouse_name`
`sma_transfers`.`to_warehouse_id`
`sma_transfers`.`to_warehouse_code`
`sma_transfers`.`to_warehouse_name`
`sma_transfers`.`note`
`sma_transfers`.`total`
`sma_transfers`.`total_tax`
`sma_transfers`.`grand_total`
`sma_transfers`.`created_by`
`sma_transfers`.`status`
`sma_transfers`.`shipping`
`sma_transfers`.`attachment`
`sma_transfers`.`cgst`
`sma_transfers`.`sgst`
`sma_transfers`.`igst`
`sma_units`.*
`sma_units`.`id`
`sma_units`.`code`
`sma_units`.`name`
`sma_units`.`base_unit`
`sma_units`.`operator`
`sma_units`.`unit_value`
`sma_units`.`operation_value`
`sma_user_logins`.*
`sma_user_logins`.`id`
`sma_user_logins`.`user_id`
`sma_user_logins`.`company_id`
`sma_user_logins`.`ip_address`
`sma_user_logins`.`login`
`sma_user_logins`.`time`
`sma_users`.*
`sma_users`.`id`
`sma_users`.`last_ip_address`
`sma_users`.`ip_address`
`sma_users`.`username`
`sma_users`.`password`
`sma_users`.`salt`
`sma_users`.`email`
`sma_users`.`activation_code`
`sma_users`.`forgotten_password_code`
`sma_users`.`forgotten_password_time`
`sma_users`.`remember_code`
`sma_users`.`created_on`
`sma_users`.`last_login`
`sma_users`.`active`
`sma_users`.`first_name`
`sma_users`.`last_name`
`sma_users`.`company`
`sma_users`.`phone`
`sma_users`.`avatar`
`sma_users`.`gender`
`sma_users`.`group_id`
`sma_users`.`warehouse_id`
`sma_users`.`biller_id`
`sma_users`.`company_id`
`sma_users`.`show_cost`
`sma_users`.`show_price`
`sma_users`.`award_points`
`sma_users`.`view_right`
`sma_users`.`edit_right`
`sma_users`.`allow_discount`
`sma_variants`.*
`sma_variants`.`id`
`sma_variants`.`name`
`sma_warehouses`.*
`sma_warehouses`.`id`
`sma_warehouses`.`code`
`sma_warehouses`.`name`
`sma_warehouses`.`address`
`sma_warehouses`.`map`
`sma_warehouses`.`phone`
`sma_warehouses`.`email`
`sma_warehouses`.`price_group_id`
`sma_warehouses_products`.*
`sma_warehouses_products`.`id`
`sma_warehouses_products`.`product_id`
`sma_warehouses_products`.`warehouse_id`
`sma_warehouses_products`.`quantity`
`sma_warehouses_products`.`rack`
`sma_warehouses_products`.`avg_cost`
`sma_warehouses_products_variants`.*
`sma_warehouses_products_variants`.`id`
`sma_warehouses_products_variants`.`option_id`
`sma_warehouses_products_variants`.`product_id`
`sma_warehouses_products_variants`.`warehouse_id`
`sma_warehouses_products_variants`.`quantity`
`sma_warehouses_products_variants`.`rack`
`sma_wishlist`.*
`sma_wishlist`.`id`
`sma_wishlist`.`user_id`
`sma_wishlist`.`product_id`
`sma_addresses`.*
`sma_addresses`.`id`
`sma_addresses`.`company_id`
`sma_addresses`.`line1`
`sma_addresses`.`line2`
`sma_addresses`.`city`
`sma_addresses`.`postal_code`
`sma_addresses`.`state`
`sma_addresses`.`country`
`sma_addresses`.`phone`
`sma_addresses`.`updated_at`
`sma_adjustment_items`.*
`sma_adjustment_items`.`id`
`sma_adjustment_items`.`adjustment_id`
`sma_adjustment_items`.`product_id`
`sma_adjustment_items`.`option_id`
`sma_adjustment_items`.`quantity`
`sma_adjustment_items`.`warehouse_id`
`sma_adjustment_items`.`serial_no`
`sma_adjustment_items`.`type`
`sma_adjustments`.*
`sma_adjustments`.`id`
`sma_adjustments`.`date`
`sma_adjustments`.`reference_no`
`sma_adjustments`.`warehouse_id`
`sma_adjustments`.`note`
`sma_adjustments`.`attachment`
`sma_adjustments`.`created_by`
`sma_adjustments`.`updated_by`
`sma_adjustments`.`updated_at`
`sma_adjustments`.`count_id`
`sma_api_keys`.*
`sma_api_keys`.`id`
`sma_api_keys`.`user_id`
`sma_api_keys`.`reference`
`sma_api_keys`.`key`
`sma_api_keys`.`level`
`sma_api_keys`.`ignore_limits`
`sma_api_keys`.`is_private_key`
`sma_api_keys`.`ip_addresses`
`sma_api_keys`.`date_created`
`sma_api_limits`.*
`sma_api_limits`.`id`
`sma_api_limits`.`uri`
`sma_api_limits`.`count`
`sma_api_limits`.`hour_started`
`sma_api_limits`.`api_key`
`sma_api_logs`.*
`sma_api_logs`.`id`
`sma_api_logs`.`uri`
`sma_api_logs`.`method`
`sma_api_logs`.`params`
`sma_api_logs`.`api_key`
`sma_api_logs`.`ip_address`
`sma_api_logs`.`time`
`sma_api_logs`.`rtime`
`sma_api_logs`.`authorized`
`sma_api_logs`.`response_code`
`sma_attachments`.*
`sma_attachments`.`id`
`sma_attachments`.`subject_id`
`sma_attachments`.`subject_type`
`sma_attachments`.`file_name`
`sma_attachments`.`orig_name`
`sma_brands`.*
`sma_brands`.`id`
`sma_brands`.`code`
`sma_brands`.`name`
`sma_brands`.`image`
`sma_brands`.`slug`
`sma_brands`.`description`
`sma_calendar`.*
`sma_calendar`.`id`
`sma_calendar`.`title`
`sma_calendar`.`description`
`sma_calendar`.`start`
`sma_calendar`.`end`
`sma_calendar`.`color`
`sma_calendar`.`user_id`
`sma_captcha`.*
`sma_captcha`.`captcha_id`
`sma_captcha`.`captcha_time`
`sma_captcha`.`ip_address`
`sma_captcha`.`word`
`sma_cart`.*
`sma_cart`.`id`
`sma_cart`.`time`
`sma_cart`.`user_id`
`sma_cart`.`data`
`sma_categories`.*
`sma_categories`.`id`
`sma_categories`.`code`
`sma_categories`.`name`
`sma_categories`.`image`
`sma_categories`.`parent_id`
`sma_categories`.`slug`
`sma_categories`.`description`
`sma_combo_items`.*
`sma_combo_items`.`id`
`sma_combo_items`.`product_id`
`sma_combo_items`.`item_code`
`sma_combo_items`.`quantity`
`sma_combo_items`.`unit_price`
`sma_companies`.*
`sma_companies`.`id`
`sma_companies`.`group_id`
`sma_companies`.`group_name`
`sma_companies`.`customer_group_id`
`sma_companies`.`customer_group_name`
`sma_companies`.`name`
`sma_companies`.`company`
`sma_companies`.`vat_no`
`sma_companies`.`address`
`sma_companies`.`city`
`sma_companies`.`state`
`sma_companies`.`postal_code`
`sma_companies`.`country`
`sma_companies`.`phone`
`sma_companies`.`email`
`sma_companies`.`cf1`
`sma_companies`.`cf2`
`sma_companies`.`cf3`
`sma_companies`.`cf4`
`sma_companies`.`cf5`
`sma_companies`.`cf6`
`sma_companies`.`invoice_footer`
`sma_companies`.`payment_term`
`sma_companies`.`logo`
`sma_companies`.`award_points`
`sma_companies`.`deposit_amount`
`sma_companies`.`price_group_id`
`sma_companies`.`price_group_name`
`sma_companies`.`gst_no`
`sma_costing`.*
`sma_costing`.`id`
`sma_costing`.`date`
`sma_costing`.`product_id`
`sma_costing`.`sale_item_id`
`sma_costing`.`sale_id`
`sma_costing`.`purchase_item_id`
`sma_costing`.`quantity`
`sma_costing`.`purchase_net_unit_cost`
`sma_costing`.`purchase_unit_cost`
`sma_costing`.`sale_net_unit_price`
`sma_costing`.`sale_unit_price`
`sma_costing`.`quantity_balance`
`sma_costing`.`inventory`
`sma_costing`.`overselling`
`sma_costing`.`option_id`
`sma_costing`.`purchase_id`
`sma_costing`.`transfer_id`
`sma_currencies`.*
`sma_currencies`.`id`
`sma_currencies`.`code`
`sma_currencies`.`name`
`sma_currencies`.`rate`
`sma_currencies`.`auto_update`
`sma_currencies`.`symbol`
`sma_customer_groups`.*
`sma_customer_groups`.`id`
`sma_customer_groups`.`name`
`sma_customer_groups`.`percent`
`sma_customer_groups`.`discount`
`sma_date_format`.*
`sma_date_format`.`id`
`sma_date_format`.`js`
`sma_date_format`.`php`
`sma_date_format`.`sql`
`sma_deliveries`.*
`sma_deliveries`.`id`
`sma_deliveries`.`date`
`sma_deliveries`.`sale_id`
`sma_deliveries`.`do_reference_no`
`sma_deliveries`.`sale_reference_no`
`sma_deliveries`.`customer`
`sma_deliveries`.`address`
`sma_deliveries`.`note`
`sma_deliveries`.`status`
`sma_deliveries`.`attachment`
`sma_deliveries`.`delivered_by`
`sma_deliveries`.`received_by`
`sma_deliveries`.`created_by`
`sma_deliveries`.`updated_by`
`sma_deliveries`.`updated_at`
`sma_deposits`.*
`sma_deposits`.`id`
`sma_deposits`.`date`
`sma_deposits`.`company_id`
`sma_deposits`.`amount`
`sma_deposits`.`paid_by`
`sma_deposits`.`note`
`sma_deposits`.`created_by`
`sma_deposits`.`updated_by`
`sma_deposits`.`updated_at`
`sma_expense_categories`.*
`sma_expense_categories`.`id`
`sma_expense_categories`.`code`
`sma_expense_categories`.`name`
`sma_expenses`.*
`sma_expenses`.`id`
`sma_expenses`.`date`
`sma_expenses`.`reference`
`sma_expenses`.`amount`
`sma_expenses`.`note`
`sma_expenses`.`created_by`
`sma_expenses`.`attachment`
`sma_expenses`.`category_id`
`sma_expenses`.`warehouse_id`
`sma_gift_card_topups`.*
`sma_gift_card_topups`.`id`
`sma_gift_card_topups`.`date`
`sma_gift_card_topups`.`card_id`
`sma_gift_card_topups`.`amount`
`sma_gift_card_topups`.`created_by`
`sma_gift_cards`.*
`sma_gift_cards`.`id`
`sma_gift_cards`.`date`
`sma_gift_cards`.`card_no`
`sma_gift_cards`.`value`
`sma_gift_cards`.`customer_id`
`sma_gift_cards`.`customer`
`sma_gift_cards`.`balance`
`sma_gift_cards`.`expiry`
`sma_gift_cards`.`created_by`
`sma_groups`.*
`sma_groups`.`id`
`sma_groups`.`name`
`sma_groups`.`description`
`sma_login_attempts`.*
`sma_login_attempts`.`id`
`sma_login_attempts`.`ip_address`
`sma_login_attempts`.`login`
`sma_login_attempts`.`time`
`sma_logs`.*
`sma_logs`.`id`
`sma_logs`.`detail`
`sma_logs`.`model`
`sma_logs`.`date`
`sma_migrations`.*
`sma_migrations`.`version`
`sma_notifications`.*
`sma_notifications`.`id`
`sma_notifications`.`comment`
`sma_notifications`.`date`
`sma_notifications`.`from_date`
`sma_notifications`.`till_date`
`sma_notifications`.`scope`
`sma_order_ref`.*
`sma_order_ref`.`ref_id`
`sma_order_ref`.`date`
`sma_order_ref`.`so`
`sma_order_ref`.`qu`
`sma_order_ref`.`po`
`sma_order_ref`.`to`
`sma_order_ref`.`pos`
`sma_order_ref`.`do`
`sma_order_ref`.`pay`
`sma_order_ref`.`re`
`sma_order_ref`.`rep`
`sma_order_ref`.`ex`
`sma_order_ref`.`ppay`
`sma_order_ref`.`qa`
`sma_pages`.*
`sma_pages`.`id`
`sma_pages`.`name`
`sma_pages`.`title`
`sma_pages`.`description`
`sma_pages`.`slug`
`sma_pages`.`body`
`sma_pages`.`active`
`sma_pages`.`updated_at`
`sma_pages`.`order_no`
`sma_payments`.*
`sma_payments`.`id`
`sma_payments`.`date`
`sma_payments`.`sale_id`
`sma_payments`.`return_id`
`sma_payments`.`purchase_id`
`sma_payments`.`reference_no`
`sma_payments`.`transaction_id`
`sma_payments`.`paid_by`
`sma_payments`.`cheque_no`
`sma_payments`.`cc_no`
`sma_payments`.`cc_holder`
`sma_payments`.`cc_month`
`sma_payments`.`cc_year`
`sma_payments`.`cc_type`
`sma_payments`.`amount`
`sma_payments`.`currency`
`sma_payments`.`created_by`
`sma_payments`.`attachment`
`sma_payments`.`type`
`sma_payments`.`note`
`sma_payments`.`pos_paid`
`sma_payments`.`pos_balance`
`sma_payments`.`approval_code`
`sma_paypal`.*
`sma_paypal`.`id`
`sma_paypal`.`active`
`sma_paypal`.`account_email`
`sma_paypal`.`paypal_currency`
`sma_paypal`.`fixed_charges`
`sma_paypal`.`extra_charges_my`
`sma_paypal`.`extra_charges_other`
`sma_permissions`.*
`sma_permissions`.`id`
`sma_permissions`.`group_id`
`sma_permissions`.`products-index`
`sma_permissions`.`products-add`
`sma_permissions`.`products-edit`
`sma_permissions`.`products-delete`
`sma_permissions`.`products-cost`
`sma_permissions`.`products-price`
`sma_permissions`.`quotes-index`
`sma_permissions`.`quotes-add`
`sma_permissions`.`quotes-edit`
`sma_permissions`.`quotes-pdf`
`sma_permissions`.`quotes-email`
`sma_permissions`.`quotes-delete`
`sma_permissions`.`sales-index`
`sma_permissions`.`sales-add`
`sma_permissions`.`sales-edit`
`sma_permissions`.`sales-pdf`
`sma_permissions`.`sales-email`
`sma_permissions`.`sales-delete`
`sma_permissions`.`purchases-index`
`sma_permissions`.`purchases-add`
`sma_permissions`.`purchases-edit`
`sma_permissions`.`purchases-pdf`
`sma_permissions`.`purchases-email`
`sma_permissions`.`purchases-delete`
`sma_permissions`.`transfers-index`
`sma_permissions`.`transfers-add`
`sma_permissions`.`transfers-edit`
`sma_permissions`.`transfers-pdf`
`sma_permissions`.`transfers-email`
`sma_permissions`.`transfers-delete`
`sma_permissions`.`customers-index`
`sma_permissions`.`customers-add`
`sma_permissions`.`customers-edit`
`sma_permissions`.`customers-delete`
`sma_permissions`.`suppliers-index`
`sma_permissions`.`suppliers-add`
`sma_permissions`.`suppliers-edit`
`sma_permissions`.`suppliers-delete`
`sma_permissions`.`sales-deliveries`
`sma_permissions`.`sales-add_delivery`
`sma_permissions`.`sales-edit_delivery`
`sma_permissions`.`sales-delete_delivery`
`sma_permissions`.`sales-email_delivery`
`sma_permissions`.`sales-pdf_delivery`
`sma_permissions`.`sales-gift_cards`
`sma_permissions`.`sales-add_gift_card`
`sma_permissions`.`sales-edit_gift_card`
`sma_permissions`.`sales-delete_gift_card`
`sma_permissions`.`pos-index`
`sma_permissions`.`sales-return_sales`
`sma_permissions`.`reports-index`
`sma_permissions`.`reports-warehouse_stock`
`sma_permissions`.`reports-quantity_alerts`
`sma_permissions`.`reports-expiry_alerts`
`sma_permissions`.`reports-products`
`sma_permissions`.`reports-daily_sales`
`sma_permissions`.`reports-monthly_sales`
`sma_permissions`.`reports-sales`
`sma_permissions`.`reports-payments`
`sma_permissions`.`reports-purchases`
`sma_permissions`.`reports-profit_loss`
`sma_permissions`.`reports-customers`
`sma_permissions`.`reports-suppliers`
`sma_permissions`.`reports-staff`
`sma_permissions`.`reports-register`
`sma_permissions`.`sales-payments`
`sma_permissions`.`purchases-payments`
`sma_permissions`.`purchases-expenses`
`sma_permissions`.`products-adjustments`
`sma_permissions`.`bulk_actions`
`sma_permissions`.`customers-deposits`
`sma_permissions`.`customers-delete_deposit`
`sma_permissions`.`products-barcode`
`sma_permissions`.`purchases-return_purchases`
`sma_permissions`.`reports-expenses`
`sma_permissions`.`reports-daily_purchases`
`sma_permissions`.`reports-monthly_purchases`
`sma_permissions`.`products-stock_count`
`sma_permissions`.`edit_price`
`sma_permissions`.`returns-index`
`sma_permissions`.`returns-add`
`sma_permissions`.`returns-edit`
`sma_permissions`.`returns-delete`
`sma_permissions`.`returns-email`
`sma_permissions`.`returns-pdf`
`sma_permissions`.`reports-tax`
`sma_pos_register`.*
`sma_pos_register`.`id`
`sma_pos_register`.`date`
`sma_pos_register`.`user_id`
`sma_pos_register`.`cash_in_hand`
`sma_pos_register`.`status`
`sma_pos_register`.`total_cash`
`sma_pos_register`.`total_cheques`
`sma_pos_register`.`total_cc_slips`
`sma_pos_register`.`total_cash_submitted`
`sma_pos_register`.`total_cheques_submitted`
`sma_pos_register`.`total_cc_slips_submitted`
`sma_pos_register`.`note`
`sma_pos_register`.`closed_at`
`sma_pos_register`.`transfer_opened_bills`
`sma_pos_register`.`closed_by`
`sma_pos_settings`.*
`sma_pos_settings`.`pos_id`
`sma_pos_settings`.`cat_limit`
`sma_pos_settings`.`pro_limit`
`sma_pos_settings`.`default_category`
`sma_pos_settings`.`default_customer`
`sma_pos_settings`.`default_biller`
`sma_pos_settings`.`display_time`
`sma_pos_settings`.`cf_title1`
`sma_pos_settings`.`cf_title2`
`sma_pos_settings`.`cf_value1`
`sma_pos_settings`.`cf_value2`
`sma_pos_settings`.`receipt_printer`
`sma_pos_settings`.`cash_drawer_codes`
`sma_pos_settings`.`focus_add_item`
`sma_pos_settings`.`add_manual_product`
`sma_pos_settings`.`customer_selection`
`sma_pos_settings`.`add_customer`
`sma_pos_settings`.`toggle_category_slider`
`sma_pos_settings`.`toggle_subcategory_slider`
`sma_pos_settings`.`cancel_sale`
`sma_pos_settings`.`suspend_sale`
`sma_pos_settings`.`print_items_list`
`sma_pos_settings`.`finalize_sale`
`sma_pos_settings`.`today_sale`
`sma_pos_settings`.`open_hold_bills`
`sma_pos_settings`.`close_register`
`sma_pos_settings`.`keyboard`
`sma_pos_settings`.`pos_printers`
`sma_pos_settings`.`java_applet`
`sma_pos_settings`.`product_button_color`
`sma_pos_settings`.`tooltips`
`sma_pos_settings`.`paypal_pro`
`sma_pos_settings`.`stripe`
`sma_pos_settings`.`rounding`
`sma_pos_settings`.`char_per_line`
`sma_pos_settings`.`pin_code`
`sma_pos_settings`.`purchase_code`
`sma_pos_settings`.`envato_username`
`sma_pos_settings`.`version`
`sma_pos_settings`.`after_sale_page`
`sma_pos_settings`.`item_order`
`sma_pos_settings`.`authorize`
`sma_pos_settings`.`toggle_brands_slider`
`sma_pos_settings`.`remote_printing`
`sma_pos_settings`.`printer`
`sma_pos_settings`.`order_printers`
`sma_pos_settings`.`auto_print`
`sma_pos_settings`.`customer_details`
`sma_pos_settings`.`local_printers`
`sma_price_groups`.*
`sma_price_groups`.`id`
`sma_price_groups`.`name`
`sma_printers`.*
`sma_printers`.`id`
`sma_printers`.`title`
`sma_printers`.`type`
`sma_printers`.`profile`
`sma_printers`.`char_per_line`
`sma_printers`.`path`
`sma_printers`.`ip_address`
`sma_printers`.`port`
`sma_product_photos`.*
`sma_product_photos`.`id`
`sma_product_photos`.`product_id`
`sma_product_photos`.`photo`
`sma_product_prices`.*
`sma_product_prices`.`id`
`sma_product_prices`.`product_id`
`sma_product_prices`.`price_group_id`
`sma_product_prices`.`price`
`sma_product_variants`.*
`sma_product_variants`.`id`
`sma_product_variants`.`product_id`
`sma_product_variants`.`name`
`sma_product_variants`.`cost`
`sma_product_variants`.`price`
`sma_product_variants`.`quantity`
`sma_products`.*
`sma_products`.`id`
`sma_products`.`code`
`sma_products`.`name`
`sma_products`.`unit`
`sma_products`.`cost`
`sma_products`.`price`
`sma_products`.`alert_quantity`
`sma_products`.`image`
`sma_products`.`category_id`
`sma_products`.`subcategory_id`
`sma_products`.`cf1`
`sma_products`.`cf2`
`sma_products`.`cf3`
`sma_products`.`cf4`
`sma_products`.`cf5`
`sma_products`.`cf6`
`sma_products`.`quantity`
`sma_products`.`tax_rate`
`sma_products`.`track_quantity`
`sma_products`.`details`
`sma_products`.`warehouse`
`sma_products`.`barcode_symbology`
`sma_products`.`file`
`sma_products`.`product_details`
`sma_products`.`tax_method`
`sma_products`.`type`
`sma_products`.`supplier1`
`sma_products`.`supplier1price`
`sma_products`.`supplier2`
`sma_products`.`supplier2price`
`sma_products`.`supplier3`
`sma_products`.`supplier3price`
`sma_products`.`supplier4`
`sma_products`.`supplier4price`
`sma_products`.`supplier5`
`sma_products`.`supplier5price`
`sma_products`.`promotion`
`sma_products`.`promo_price`
`sma_products`.`start_date`
`sma_products`.`end_date`
`sma_products`.`supplier1_part_no`
`sma_products`.`supplier2_part_no`
`sma_products`.`supplier3_part_no`
`sma_products`.`supplier4_part_no`
`sma_products`.`supplier5_part_no`
`sma_products`.`sale_unit`
`sma_products`.`purchase_unit`
`sma_products`.`brand`
`sma_products`.`slug`
`sma_products`.`featured`
`sma_products`.`weight`
`sma_products`.`hsn_code`
`sma_products`.`views`
`sma_products`.`hide`
`sma_products`.`second_name`
`sma_products`.`hide_pos`
`sma_promos`.*
`sma_promos`.`id`
`sma_promos`.`name`
`sma_promos`.`product2buy`
`sma_promos`.`product2get`
`sma_promos`.`start_date`
`sma_promos`.`end_date`
`sma_promos`.`description`
`sma_purchase_items`.*
`sma_purchase_items`.`id`
`sma_purchase_items`.`purchase_id`
`sma_purchase_items`.`transfer_id`
`sma_purchase_items`.`product_id`
`sma_purchase_items`.`product_code`
`sma_purchase_items`.`product_name`
`sma_purchase_items`.`option_id`
`sma_purchase_items`.`net_unit_cost`
`sma_purchase_items`.`quantity`
`sma_purchase_items`.`warehouse_id`
`sma_purchase_items`.`item_tax`
`sma_purchase_items`.`tax_rate_id`
`sma_purchase_items`.`tax`
`sma_purchase_items`.`discount`
`sma_purchase_items`.`item_discount`
`sma_purchase_items`.`expiry`
`sma_purchase_items`.`subtotal`
`sma_purchase_items`.`quantity_balance`
`sma_purchase_items`.`date`
`sma_purchase_items`.`status`
`sma_purchase_items`.`unit_cost`
`sma_purchase_items`.`real_unit_cost`
`sma_purchase_items`.`quantity_received`
`sma_purchase_items`.`supplier_part_no`
`sma_purchase_items`.`purchase_item_id`
`sma_purchase_items`.`product_unit_id`
`sma_purchase_items`.`product_unit_code`
`sma_purchase_items`.`unit_quantity`
`sma_purchase_items`.`gst`
`sma_purchase_items`.`cgst`
`sma_purchase_items`.`sgst`
`sma_purchase_items`.`igst`
`sma_purchase_items`.`base_unit_cost`
`sma_purchases`.*
`sma_purchases`.`id`
`sma_purchases`.`reference_no`
`sma_purchases`.`date`
`sma_purchases`.`supplier_id`
`sma_purchases`.`supplier`
`sma_purchases`.`warehouse_id`
`sma_purchases`.`note`
`sma_purchases`.`total`
`sma_purchases`.`product_discount`
`sma_purchases`.`order_discount_id`
`sma_purchases`.`order_discount`
`sma_purchases`.`total_discount`
`sma_purchases`.`product_tax`
`sma_purchases`.`order_tax_id`
`sma_purchases`.`order_tax`
`sma_purchases`.`total_tax`
`sma_purchases`.`shipping`
`sma_purchases`.`grand_total`
`sma_purchases`.`paid`
`sma_purchases`.`status`
`sma_purchases`.`payment_status`
`sma_purchases`.`created_by`
`sma_purchases`.`updated_by`
`sma_purchases`.`updated_at`
`sma_purchases`.`attachment`
`sma_purchases`.`payment_term`
`sma_purchases`.`due_date`
`sma_purchases`.`return_id`
`sma_purchases`.`surcharge`
`sma_purchases`.`return_purchase_ref`
`sma_purchases`.`purchase_id`
`sma_purchases`.`return_purchase_total`
`sma_purchases`.`cgst`
`sma_purchases`.`sgst`
`sma_purchases`.`igst`
`sma_quote_items`.*
`sma_quote_items`.`id`
`sma_quote_items`.`quote_id`
`sma_quote_items`.`product_id`
`sma_quote_items`.`product_code`
`sma_quote_items`.`product_name`
`sma_quote_items`.`product_type`
`sma_quote_items`.`option_id`
`sma_quote_items`.`net_unit_price`
`sma_quote_items`.`unit_price`
`sma_quote_items`.`quantity`
`sma_quote_items`.`warehouse_id`
`sma_quote_items`.`item_tax`
`sma_quote_items`.`tax_rate_id`
`sma_quote_items`.`tax`
`sma_quote_items`.`discount`
`sma_quote_items`.`item_discount`
`sma_quote_items`.`subtotal`
`sma_quote_items`.`serial_no`
`sma_quote_items`.`real_unit_price`
`sma_quote_items`.`product_unit_id`
`sma_quote_items`.`product_unit_code`
`sma_quote_items`.`unit_quantity`
`sma_quote_items`.`gst`
`sma_quote_items`.`cgst`
`sma_quote_items`.`sgst`
`sma_quote_items`.`igst`
`sma_quotes`.*
`sma_quotes`.`id`
`sma_quotes`.`date`
`sma_quotes`.`reference_no`
`sma_quotes`.`customer_id`
`sma_quotes`.`customer`
`sma_quotes`.`warehouse_id`
`sma_quotes`.`biller_id`
`sma_quotes`.`biller`
`sma_quotes`.`note`
`sma_quotes`.`internal_note`
`sma_quotes`.`total`
`sma_quotes`.`product_discount`
`sma_quotes`.`order_discount`
`sma_quotes`.`order_discount_id`
`sma_quotes`.`total_discount`
`sma_quotes`.`product_tax`
`sma_quotes`.`order_tax_id`
`sma_quotes`.`order_tax`
`sma_quotes`.`total_tax`
`sma_quotes`.`shipping`
`sma_quotes`.`grand_total`
`sma_quotes`.`status`
`sma_quotes`.`created_by`
`sma_quotes`.`updated_by`
`sma_quotes`.`updated_at`
`sma_quotes`.`attachment`
`sma_quotes`.`supplier_id`
`sma_quotes`.`supplier`
`sma_quotes`.`hash`
`sma_quotes`.`cgst`
`sma_quotes`.`sgst`
`sma_quotes`.`igst`
`sma_return_items`.*
`sma_return_items`.`id`
`sma_return_items`.`return_id`
`sma_return_items`.`product_id`
`sma_return_items`.`product_code`
`sma_return_items`.`product_name`
`sma_return_items`.`product_type`
`sma_return_items`.`option_id`
`sma_return_items`.`net_unit_price`
`sma_return_items`.`unit_price`
`sma_return_items`.`quantity`
`sma_return_items`.`warehouse_id`
`sma_return_items`.`item_tax`
`sma_return_items`.`tax_rate_id`
`sma_return_items`.`tax`
`sma_return_items`.`discount`
`sma_return_items`.`item_discount`
`sma_return_items`.`subtotal`
`sma_return_items`.`serial_no`
`sma_return_items`.`real_unit_price`
`sma_return_items`.`product_unit_id`
`sma_return_items`.`product_unit_code`
`sma_return_items`.`unit_quantity`
`sma_return_items`.`comment`
`sma_return_items`.`gst`
`sma_return_items`.`cgst`
`sma_return_items`.`sgst`
`sma_return_items`.`igst`
`sma_returns`.*
`sma_returns`.`id`
`sma_returns`.`date`
`sma_returns`.`reference_no`
`sma_returns`.`customer_id`
`sma_returns`.`customer`
`sma_returns`.`biller_id`
`sma_returns`.`biller`
`sma_returns`.`warehouse_id`
`sma_returns`.`note`
`sma_returns`.`staff_note`
`sma_returns`.`total`
`sma_returns`.`product_discount`
`sma_returns`.`order_discount_id`
`sma_returns`.`total_discount`
`sma_returns`.`order_discount`
`sma_returns`.`product_tax`
`sma_returns`.`order_tax_id`
`sma_returns`.`order_tax`
`sma_returns`.`total_tax`
`sma_returns`.`grand_total`
`sma_returns`.`created_by`
`sma_returns`.`updated_by`
`sma_returns`.`updated_at`
`sma_returns`.`total_items`
`sma_returns`.`paid`
`sma_returns`.`surcharge`
`sma_returns`.`attachment`
`sma_returns`.`hash`
`sma_returns`.`cgst`
`sma_returns`.`sgst`
`sma_returns`.`igst`
`sma_returns`.`shipping`
`sma_sale_items`.*
`sma_sale_items`.`id`
`sma_sale_items`.`sale_id`
`sma_sale_items`.`product_id`
`sma_sale_items`.`product_code`
`sma_sale_items`.`product_name`
`sma_sale_items`.`product_type`
`sma_sale_items`.`option_id`
`sma_sale_items`.`net_unit_price`
`sma_sale_items`.`unit_price`
`sma_sale_items`.`quantity`
`sma_sale_items`.`warehouse_id`
`sma_sale_items`.`item_tax`
`sma_sale_items`.`tax_rate_id`
`sma_sale_items`.`tax`
`sma_sale_items`.`discount`
`sma_sale_items`.`item_discount`
`sma_sale_items`.`subtotal`
`sma_sale_items`.`serial_no`
`sma_sale_items`.`real_unit_price`
`sma_sale_items`.`sale_item_id`
`sma_sale_items`.`product_unit_id`
`sma_sale_items`.`product_unit_code`
`sma_sale_items`.`unit_quantity`
`sma_sale_items`.`comment`
`sma_sale_items`.`gst`
`sma_sale_items`.`cgst`
`sma_sale_items`.`sgst`
`sma_sale_items`.`igst`
`sma_sales`.*
`sma_sales`.`id`
`sma_sales`.`date`
`sma_sales`.`reference_no`
`sma_sales`.`customer_id`
`sma_sales`.`customer`
`sma_sales`.`biller_id`
`sma_sales`.`biller`
`sma_sales`.`warehouse_id`
`sma_sales`.`note`
`sma_sales`.`staff_note`
`sma_sales`.`total`
`sma_sales`.`product_discount`
`sma_sales`.`order_discount_id`
`sma_sales`.`total_discount`
`sma_sales`.`order_discount`
`sma_sales`.`product_tax`
`sma_sales`.`order_tax_id`
`sma_sales`.`order_tax`
`sma_sales`.`total_tax`
`sma_sales`.`shipping`
`sma_sales`.`grand_total`
`sma_sales`.`sale_status`
`sma_sales`.`payment_status`
`sma_sales`.`payment_term`
`sma_sales`.`due_date`
`sma_sales`.`created_by`
`sma_sales`.`updated_by`
`sma_sales`.`updated_at`
`sma_sales`.`total_items`
`sma_sales`.`pos`
`sma_sales`.`paid`
`sma_sales`.`return_id`
`sma_sales`.`surcharge`
`sma_sales`.`attachment`
`sma_sales`.`return_sale_ref`
`sma_sales`.`sale_id`
`sma_sales`.`return_sale_total`
`sma_sales`.`rounding`
`sma_sales`.`suspend_note`
`sma_sales`.`api`
`sma_sales`.`shop`
`sma_sales`.`address_id`
`sma_sales`.`reserve_id`
`sma_sales`.`hash`
`sma_sales`.`manual_payment`
`sma_sales`.`cgst`
`sma_sales`.`sgst`
`sma_sales`.`igst`
`sma_sales`.`payment_method`
`sma_sessions`.*
`sma_sessions`.`id`
`sma_sessions`.`ip_address`
`sma_sessions`.`timestamp`
`sma_sessions`.`data`
`sma_settings`.*
`sma_settings`.`setting_id`
`sma_settings`.`logo`
`sma_settings`.`logo2`
`sma_settings`.`site_name`
`sma_settings`.`language`
`sma_settings`.`default_warehouse`
`sma_settings`.`accounting_method`
`sma_settings`.`default_currency`
`sma_settings`.`default_tax_rate`
`sma_settings`.`rows_per_page`
`sma_settings`.`version`
`sma_settings`.`default_tax_rate2`
`sma_settings`.`dateformat`
`sma_settings`.`sales_prefix`
`sma_settings`.`quote_prefix`
`sma_settings`.`purchase_prefix`
`sma_settings`.`transfer_prefix`
`sma_settings`.`delivery_prefix`
`sma_settings`.`payment_prefix`
`sma_settings`.`return_prefix`
`sma_settings`.`returnp_prefix`
`sma_settings`.`expense_prefix`
`sma_settings`.`item_addition`
`sma_settings`.`theme`
`sma_settings`.`product_serial`
`sma_settings`.`default_discount`
`sma_settings`.`product_discount`
`sma_settings`.`discount_method`
`sma_settings`.`tax1`
`sma_settings`.`tax2`
`sma_settings`.`overselling`
`sma_settings`.`restrict_user`
`sma_settings`.`restrict_calendar`
`sma_settings`.`timezone`
`sma_settings`.`iwidth`
`sma_settings`.`iheight`
`sma_settings`.`twidth`
`sma_settings`.`theight`
`sma_settings`.`watermark`
`sma_settings`.`reg_ver`
`sma_settings`.`allow_reg`
`sma_settings`.`reg_notification`
`sma_settings`.`auto_reg`
`sma_settings`.`protocol`
`sma_settings`.`mailpath`
`sma_settings`.`smtp_host`
`sma_settings`.`smtp_user`
`sma_settings`.`smtp_pass`
`sma_settings`.`smtp_port`
`sma_settings`.`smtp_crypto`
`sma_settings`.`corn`
`sma_settings`.`customer_group`
`sma_settings`.`default_email`
`sma_settings`.`mmode`
`sma_settings`.`bc_fix`
`sma_settings`.`auto_detect_barcode`
`sma_settings`.`captcha`
`sma_settings`.`reference_format`
`sma_settings`.`racks`
`sma_settings`.`attributes`
`sma_settings`.`product_expiry`
`sma_settings`.`decimals`
`sma_settings`.`qty_decimals`
`sma_settings`.`decimals_sep`
`sma_settings`.`thousands_sep`
`sma_settings`.`invoice_view`
`sma_settings`.`default_biller`
`sma_settings`.`envato_username`
`sma_settings`.`purchase_code`
`sma_settings`.`rtl`
`sma_settings`.`each_spent`
`sma_settings`.`ca_point`
`sma_settings`.`each_sale`
`sma_settings`.`sa_point`
`sma_settings`.`update`
`sma_settings`.`sac`
`sma_settings`.`display_all_products`
`sma_settings`.`display_symbol`
`sma_settings`.`symbol`
`sma_settings`.`remove_expired`
`sma_settings`.`barcode_separator`
`sma_settings`.`set_focus`
`sma_settings`.`price_group`
`sma_settings`.`barcode_img`
`sma_settings`.`ppayment_prefix`
`sma_settings`.`disable_editing`
`sma_settings`.`qa_prefix`
`sma_settings`.`update_cost`
`sma_settings`.`apis`
`sma_settings`.`state`
`sma_settings`.`pdf_lib`
`sma_settings`.`use_code_for_slug`
`sma_settings`.`ws_barcode_type`
`sma_settings`.`ws_barcode_chars`
`sma_settings`.`flag_chars`
`sma_settings`.`item_code_start`
`sma_settings`.`item_code_chars`
`sma_settings`.`price_start`
`sma_settings`.`price_chars`
`sma_settings`.`price_divide_by`
`sma_settings`.`weight_start`
`sma_settings`.`weight_chars`
`sma_settings`.`weight_divide_by`
`sma_settings`.`ksa_qrcode`
`sma_shop_settings`.*
`sma_shop_settings`.`shop_id`
`sma_shop_settings`.`shop_name`
`sma_shop_settings`.`description`
`sma_shop_settings`.`warehouse`
`sma_shop_settings`.`biller`
`sma_shop_settings`.`about_link`
`sma_shop_settings`.`terms_link`
`sma_shop_settings`.`privacy_link`
`sma_shop_settings`.`contact_link`
`sma_shop_settings`.`payment_text`
`sma_shop_settings`.`follow_text`
`sma_shop_settings`.`facebook`
`sma_shop_settings`.`twitter`
`sma_shop_settings`.`google_plus`
`sma_shop_settings`.`instagram`
`sma_shop_settings`.`phone`
`sma_shop_settings`.`email`
`sma_shop_settings`.`cookie_message`
`sma_shop_settings`.`cookie_link`
`sma_shop_settings`.`slider`
`sma_shop_settings`.`shipping`
`sma_shop_settings`.`purchase_code`
`sma_shop_settings`.`envato_username`
`sma_shop_settings`.`version`
`sma_shop_settings`.`logo`
`sma_shop_settings`.`bank_details`
`sma_shop_settings`.`products_page`
`sma_shop_settings`.`hide0`
`sma_shop_settings`.`products_description`
`sma_shop_settings`.`private`
`sma_shop_settings`.`hide_price`
`sma_shop_settings`.`stripe`
`sma_skrill`.*
`sma_skrill`.`id`
`sma_skrill`.`active`
`sma_skrill`.`account_email`
`sma_skrill`.`secret_word`
`sma_skrill`.`skrill_currency`
`sma_skrill`.`fixed_charges`
`sma_skrill`.`extra_charges_my`
`sma_skrill`.`extra_charges_other`
`sma_sms_settings`.*
`sma_sms_settings`.`id`
`sma_sms_settings`.`auto_send`
`sma_sms_settings`.`config`
`sma_stock_count_items`.*
`sma_stock_count_items`.`id`
`sma_stock_count_items`.`stock_count_id`
`sma_stock_count_items`.`product_id`
`sma_stock_count_items`.`product_code`
`sma_stock_count_items`.`product_name`
`sma_stock_count_items`.`product_variant`
`sma_stock_count_items`.`product_variant_id`
`sma_stock_count_items`.`expected`
`sma_stock_count_items`.`counted`
`sma_stock_count_items`.`cost`
`sma_stock_counts`.*
`sma_stock_counts`.`id`
`sma_stock_counts`.`date`
`sma_stock_counts`.`reference_no`
`sma_stock_counts`.`warehouse_id`
`sma_stock_counts`.`type`
`sma_stock_counts`.`initial_file`
`sma_stock_counts`.`final_file`
`sma_stock_counts`.`brands`
`sma_stock_counts`.`brand_names`
`sma_stock_counts`.`categories`
`sma_stock_counts`.`category_names`
`sma_stock_counts`.`note`
`sma_stock_counts`.`products`
`sma_stock_counts`.`rows`
`sma_stock_counts`.`differences`
`sma_stock_counts`.`matches`
`sma_stock_counts`.`missing`
`sma_stock_counts`.`created_by`
`sma_stock_counts`.`updated_by`
`sma_stock_counts`.`updated_at`
`sma_stock_counts`.`finalized`
`sma_suspended_bills`.*
`sma_suspended_bills`.`id`
`sma_suspended_bills`.`date`
`sma_suspended_bills`.`customer_id`
`sma_suspended_bills`.`customer`
`sma_suspended_bills`.`count`
`sma_suspended_bills`.`order_discount_id`
`sma_suspended_bills`.`order_tax_id`
`sma_suspended_bills`.`total`
`sma_suspended_bills`.`biller_id`
`sma_suspended_bills`.`warehouse_id`
`sma_suspended_bills`.`created_by`
`sma_suspended_bills`.`suspend_note`
`sma_suspended_bills`.`shipping`
`sma_suspended_bills`.`cgst`
`sma_suspended_bills`.`sgst`
`sma_suspended_bills`.`igst`
`sma_suspended_items`.*
`sma_suspended_items`.`id`
`sma_suspended_items`.`suspend_id`
`sma_suspended_items`.`product_id`
`sma_suspended_items`.`product_code`
`sma_suspended_items`.`product_name`
`sma_suspended_items`.`net_unit_price`
`sma_suspended_items`.`unit_price`
`sma_suspended_items`.`quantity`
`sma_suspended_items`.`warehouse_id`
`sma_suspended_items`.`item_tax`
`sma_suspended_items`.`tax_rate_id`
`sma_suspended_items`.`tax`
`sma_suspended_items`.`discount`
`sma_suspended_items`.`item_discount`
`sma_suspended_items`.`subtotal`
`sma_suspended_items`.`serial_no`
`sma_suspended_items`.`option_id`
`sma_suspended_items`.`product_type`
`sma_suspended_items`.`real_unit_price`
`sma_suspended_items`.`product_unit_id`
`sma_suspended_items`.`product_unit_code`
`sma_suspended_items`.`unit_quantity`
`sma_suspended_items`.`comment`
`sma_suspended_items`.`gst`
`sma_suspended_items`.`cgst`
`sma_suspended_items`.`sgst`
`sma_suspended_items`.`igst`
`sma_tax_rates`.*
`sma_tax_rates`.`id`
`sma_tax_rates`.`name`
`sma_tax_rates`.`code`
`sma_tax_rates`.`rate`
`sma_tax_rates`.`type`
`sma_transfer_items`.*
`sma_transfer_items`.`id`
`sma_transfer_items`.`transfer_id`
`sma_transfer_items`.`product_id`
`sma_transfer_items`.`product_code`
`sma_transfer_items`.`product_name`
`sma_transfer_items`.`option_id`
`sma_transfer_items`.`expiry`
`sma_transfer_items`.`quantity`
`sma_transfer_items`.`tax_rate_id`
`sma_transfer_items`.`tax`
`sma_transfer_items`.`item_tax`
`sma_transfer_items`.`net_unit_cost`
`sma_transfer_items`.`subtotal`
`sma_transfer_items`.`quantity_balance`
`sma_transfer_items`.`unit_cost`
`sma_transfer_items`.`real_unit_cost`
`sma_transfer_items`.`date`
`sma_transfer_items`.`warehouse_id`
`sma_transfer_items`.`product_unit_id`
`sma_transfer_items`.`product_unit_code`
`sma_transfer_items`.`unit_quantity`
`sma_transfer_items`.`gst`
`sma_transfer_items`.`cgst`
`sma_transfer_items`.`sgst`
`sma_transfer_items`.`igst`
`sma_transfers`.*
`sma_transfers`.`id`
`sma_transfers`.`transfer_no`
`sma_transfers`.`date`
`sma_transfers`.`from_warehouse_id`
`sma_transfers`.`from_warehouse_code`
`sma_transfers`.`from_warehouse_name`
`sma_transfers`.`to_warehouse_id`
`sma_transfers`.`to_warehouse_code`
`sma_transfers`.`to_warehouse_name`
`sma_transfers`.`note`
`sma_transfers`.`total`
`sma_transfers`.`total_tax`
`sma_transfers`.`grand_total`
`sma_transfers`.`created_by`
`sma_transfers`.`status`
`sma_transfers`.`shipping`
`sma_transfers`.`attachment`
`sma_transfers`.`cgst`
`sma_transfers`.`sgst`
`sma_transfers`.`igst`
`sma_units`.*
`sma_units`.`id`
`sma_units`.`code`
`sma_units`.`name`
`sma_units`.`base_unit`
`sma_units`.`operator`
`sma_units`.`unit_value`
`sma_units`.`operation_value`
`sma_user_logins`.*
`sma_user_logins`.`id`
`sma_user_logins`.`user_id`
`sma_user_logins`.`company_id`
`sma_user_logins`.`ip_address`
`sma_user_logins`.`login`
`sma_user_logins`.`time`
`sma_users`.*
`sma_users`.`id`
`sma_users`.`last_ip_address`
`sma_users`.`ip_address`
`sma_users`.`username`
`sma_users`.`password`
`sma_users`.`salt`
`sma_users`.`email`
`sma_users`.`activation_code`
`sma_users`.`forgotten_password_code`
`sma_users`.`forgotten_password_time`
`sma_users`.`remember_code`
`sma_users`.`created_on`
`sma_users`.`last_login`
`sma_users`.`active`
`sma_users`.`first_name`
`sma_users`.`last_name`
`sma_users`.`company`
`sma_users`.`phone`
`sma_users`.`avatar`
`sma_users`.`gender`
`sma_users`.`group_id`
`sma_users`.`warehouse_id`
`sma_users`.`biller_id`
`sma_users`.`company_id`
`sma_users`.`show_cost`
`sma_users`.`show_price`
`sma_users`.`award_points`
`sma_users`.`view_right`
`sma_users`.`edit_right`
`sma_users`.`allow_discount`
`sma_variants`.*
`sma_variants`.`id`
`sma_variants`.`name`
`sma_warehouses`.*
`sma_warehouses`.`id`
`sma_warehouses`.`code`
`sma_warehouses`.`name`
`sma_warehouses`.`address`
`sma_warehouses`.`map`
`sma_warehouses`.`phone`
`sma_warehouses`.`email`
`sma_warehouses`.`price_group_id`
`sma_warehouses_products`.*
`sma_warehouses_products`.`id`
`sma_warehouses_products`.`product_id`
`sma_warehouses_products`.`warehouse_id`
`sma_warehouses_products`.`quantity`
`sma_warehouses_products`.`rack`
`sma_warehouses_products`.`avg_cost`
`sma_warehouses_products_variants`.*
`sma_warehouses_products_variants`.`id`
`sma_warehouses_products_variants`.`option_id`
`sma_warehouses_products_variants`.`product_id`
`sma_warehouses_products_variants`.`warehouse_id`
`sma_warehouses_products_variants`.`quantity`
`sma_warehouses_products_variants`.`rack`
`sma_wishlist`.*
`sma_wishlist`.`id`
`sma_wishlist`.`user_id`
`sma_wishlist`.`product_id`
`sma_addresses`.*
`sma_addresses`.`id`
`sma_addresses`.`company_id`
`sma_addresses`.`line1`
`sma_addresses`.`line2`
`sma_addresses`.`city`
`sma_addresses`.`postal_code`
`sma_addresses`.`state`
`sma_addresses`.`country`
`sma_addresses`.`phone`
`sma_addresses`.`updated_at`
`sma_adjustment_items`.*
`sma_adjustment_items`.`id`
`sma_adjustment_items`.`adjustment_id`
`sma_adjustment_items`.`product_id`
`sma_adjustment_items`.`option_id`
`sma_adjustment_items`.`quantity`
`sma_adjustment_items`.`warehouse_id`
`sma_adjustment_items`.`serial_no`
`sma_adjustment_items`.`type`
`sma_adjustments`.*
`sma_adjustments`.`id`
`sma_adjustments`.`date`
`sma_adjustments`.`reference_no`
`sma_adjustments`.`warehouse_id`
`sma_adjustments`.`note`
`sma_adjustments`.`attachment`
`sma_adjustments`.`created_by`
`sma_adjustments`.`updated_by`
`sma_adjustments`.`updated_at`
`sma_adjustments`.`count_id`
`sma_api_keys`.*
`sma_api_keys`.`id`
`sma_api_keys`.`user_id`
`sma_api_keys`.`reference`
`sma_api_keys`.`key`
`sma_api_keys`.`level`
`sma_api_keys`.`ignore_limits`
`sma_api_keys`.`is_private_key`
`sma_api_keys`.`ip_addresses`
`sma_api_keys`.`date_created`
`sma_api_limits`.*
`sma_api_limits`.`id`
`sma_api_limits`.`uri`
`sma_api_limits`.`count`
`sma_api_limits`.`hour_started`
`sma_api_limits`.`api_key`
`sma_api_logs`.*
`sma_api_logs`.`id`
`sma_api_logs`.`uri`
`sma_api_logs`.`method`
`sma_api_logs`.`params`
`sma_api_logs`.`api_key`
`sma_api_logs`.`ip_address`
`sma_api_logs`.`time`
`sma_api_logs`.`rtime`
`sma_api_logs`.`authorized`
`sma_api_logs`.`response_code`
`sma_attachments`.*
`sma_attachments`.`id`
`sma_attachments`.`subject_id`
`sma_attachments`.`subject_type`
`sma_attachments`.`file_name`
`sma_attachments`.`orig_name`
`sma_brands`.*
`sma_brands`.`id`
`sma_brands`.`code`
`sma_brands`.`name`
`sma_brands`.`image`
`sma_brands`.`slug`
`sma_brands`.`description`
`sma_calendar`.*
`sma_calendar`.`id`
`sma_calendar`.`title`
`sma_calendar`.`description`
`sma_calendar`.`start`
`sma_calendar`.`end`
`sma_calendar`.`color`
`sma_calendar`.`user_id`
`sma_captcha`.*
`sma_captcha`.`captcha_id`
`sma_captcha`.`captcha_time`
`sma_captcha`.`ip_address`
`sma_captcha`.`word`
`sma_cart`.*
`sma_cart`.`id`
`sma_cart`.`time`
`sma_cart`.`user_id`
`sma_cart`.`data`
`sma_categories`.*
`sma_categories`.`id`
`sma_categories`.`code`
`sma_categories`.`name`
`sma_categories`.`image`
`sma_categories`.`parent_id`
`sma_categories`.`slug`
`sma_categories`.`description`
`sma_combo_items`.*
`sma_combo_items`.`id`
`sma_combo_items`.`product_id`
`sma_combo_items`.`item_code`
`sma_combo_items`.`quantity`
`sma_combo_items`.`unit_price`
`sma_companies`.*
`sma_companies`.`id`
`sma_companies`.`group_id`
`sma_companies`.`group_name`
`sma_companies`.`customer_group_id`
`sma_companies`.`customer_group_name`
`sma_companies`.`name`
`sma_companies`.`company`
`sma_companies`.`vat_no`
`sma_companies`.`address`
`sma_companies`.`city`
`sma_companies`.`state`
`sma_companies`.`postal_code`
`sma_companies`.`country`
`sma_companies`.`phone`
`sma_companies`.`email`
`sma_companies`.`cf1`
`sma_companies`.`cf2`
`sma_companies`.`cf3`
`sma_companies`.`cf4`
`sma_companies`.`cf5`
`sma_companies`.`cf6`
`sma_companies`.`invoice_footer`
`sma_companies`.`payment_term`
`sma_companies`.`logo`
`sma_companies`.`award_points`
`sma_companies`.`deposit_amount`
`sma_companies`.`price_group_id`
`sma_companies`.`price_group_name`
`sma_companies`.`gst_no`
`sma_costing`.*
`sma_costing`.`id`
`sma_costing`.`date`
`sma_costing`.`product_id`
`sma_costing`.`sale_item_id`
`sma_costing`.`sale_id`
`sma_costing`.`purchase_item_id`
`sma_costing`.`quantity`
`sma_costing`.`purchase_net_unit_cost`
`sma_costing`.`purchase_unit_cost`
`sma_costing`.`sale_net_unit_price`
`sma_costing`.`sale_unit_price`
`sma_costing`.`quantity_balance`
`sma_costing`.`inventory`
`sma_costing`.`overselling`
`sma_costing`.`option_id`
`sma_costing`.`purchase_id`
`sma_costing`.`transfer_id`
`sma_currencies`.*
`sma_currencies`.`id`
`sma_currencies`.`code`
`sma_currencies`.`name`
`sma_currencies`.`rate`
`sma_currencies`.`auto_update`
`sma_currencies`.`symbol`
`sma_customer_groups`.*
`sma_customer_groups`.`id`
`sma_customer_groups`.`name`
`sma_customer_groups`.`percent`
`sma_customer_groups`.`discount`
`sma_date_format`.*
`sma_date_format`.`id`
`sma_date_format`.`js`
`sma_date_format`.`php`
`sma_date_format`.`sql`
`sma_deliveries`.*
`sma_deliveries`.`id`
`sma_deliveries`.`date`
`sma_deliveries`.`sale_id`
`sma_deliveries`.`do_reference_no`
`sma_deliveries`.`sale_reference_no`
`sma_deliveries`.`customer`
`sma_deliveries`.`address`
`sma_deliveries`.`note`
`sma_deliveries`.`status`
`sma_deliveries`.`attachment`
`sma_deliveries`.`delivered_by`
`sma_deliveries`.`received_by`
`sma_deliveries`.`created_by`
`sma_deliveries`.`updated_by`
`sma_deliveries`.`updated_at`
`sma_deposits`.*
`sma_deposits`.`id`
`sma_deposits`.`date`
`sma_deposits`.`company_id`
`sma_deposits`.`amount`
`sma_deposits`.`paid_by`
`sma_deposits`.`note`
`sma_deposits`.`created_by`
`sma_deposits`.`updated_by`
`sma_deposits`.`updated_at`
`sma_expense_categories`.*
`sma_expense_categories`.`id`
`sma_expense_categories`.`code`
`sma_expense_categories`.`name`
`sma_expenses`.*
`sma_expenses`.`id`
`sma_expenses`.`date`
`sma_expenses`.`reference`
`sma_expenses`.`amount`
`sma_expenses`.`note`
`sma_expenses`.`created_by`
`sma_expenses`.`attachment`
`sma_expenses`.`category_id`
`sma_expenses`.`warehouse_id`
`sma_gift_card_topups`.*
`sma_gift_card_topups`.`id`
`sma_gift_card_topups`.`date`
`sma_gift_card_topups`.`card_id`
`sma_gift_card_topups`.`amount`
`sma_gift_card_topups`.`created_by`
`sma_gift_cards`.*
`sma_gift_cards`.`id`
`sma_gift_cards`.`date`
`sma_gift_cards`.`card_no`
`sma_gift_cards`.`value`
`sma_gift_cards`.`customer_id`
`sma_gift_cards`.`customer`
`sma_gift_cards`.`balance`
`sma_gift_cards`.`expiry`
`sma_gift_cards`.`created_by`
`sma_groups`.*
`sma_groups`.`id`
`sma_groups`.`name`
`sma_groups`.`description`
`sma_login_attempts`.*
`sma_login_attempts`.`id`
`sma_login_attempts`.`ip_address`
`sma_login_attempts`.`login`
`sma_login_attempts`.`time`
`sma_logs`.*
`sma_logs`.`id`
`sma_logs`.`detail`
`sma_logs`.`model`
`sma_logs`.`date`
`sma_migrations`.*
`sma_migrations`.`version`
`sma_notifications`.*
`sma_notifications`.`id`
`sma_notifications`.`comment`
`sma_notifications`.`date`
`sma_notifications`.`from_date`
`sma_notifications`.`till_date`
`sma_notifications`.`scope`
`sma_order_ref`.*
`sma_order_ref`.`ref_id`
`sma_order_ref`.`date`
`sma_order_ref`.`so`
`sma_order_ref`.`qu`
`sma_order_ref`.`po`
`sma_order_ref`.`to`
`sma_order_ref`.`pos`
`sma_order_ref`.`do`
`sma_order_ref`.`pay`
`sma_order_ref`.`re`
`sma_order_ref`.`rep`
`sma_order_ref`.`ex`
`sma_order_ref`.`ppay`
`sma_order_ref`.`qa`
`sma_pages`.*
`sma_pages`.`id`
`sma_pages`.`name`
`sma_pages`.`title`
`sma_pages`.`description`
`sma_pages`.`slug`
`sma_pages`.`body`
`sma_pages`.`active`
`sma_pages`.`updated_at`
`sma_pages`.`order_no`
`sma_payments`.*
`sma_payments`.`id`
`sma_payments`.`date`
`sma_payments`.`sale_id`
`sma_payments`.`return_id`
`sma_payments`.`purchase_id`
`sma_payments`.`reference_no`
`sma_payments`.`transaction_id`
`sma_payments`.`paid_by`
`sma_payments`.`cheque_no`
`sma_payments`.`cc_no`
`sma_payments`.`cc_holder`
`sma_payments`.`cc_month`
`sma_payments`.`cc_year`
`sma_payments`.`cc_type`
`sma_payments`.`amount`
`sma_payments`.`currency`
`sma_payments`.`created_by`
`sma_payments`.`attachment`
`sma_payments`.`type`
`sma_payments`.`note`
`sma_payments`.`pos_paid`
`sma_payments`.`pos_balance`
`sma_payments`.`approval_code`
`sma_paypal`.*
`sma_paypal`.`id`
`sma_paypal`.`active`
`sma_paypal`.`account_email`
`sma_paypal`.`paypal_currency`
`sma_paypal`.`fixed_charges`
`sma_paypal`.`extra_charges_my`
`sma_paypal`.`extra_charges_other`
`sma_permissions`.*
`sma_permissions`.`id`
`sma_permissions`.`group_id`
`sma_permissions`.`products-index`
`sma_permissions`.`products-add`
`sma_permissions`.`products-edit`
`sma_permissions`.`products-delete`
`sma_permissions`.`products-cost`
`sma_permissions`.`products-price`
`sma_permissions`.`quotes-index`
`sma_permissions`.`quotes-add`
`sma_permissions`.`quotes-edit`
`sma_permissions`.`quotes-pdf`
`sma_permissions`.`quotes-email`
`sma_permissions`.`quotes-delete`
`sma_permissions`.`sales-index`
`sma_permissions`.`sales-add`
`sma_permissions`.`sales-edit`
`sma_permissions`.`sales-pdf`
`sma_permissions`.`sales-email`
`sma_permissions`.`sales-delete`
`sma_permissions`.`purchases-index`
`sma_permissions`.`purchases-add`
`sma_permissions`.`purchases-edit`
`sma_permissions`.`purchases-pdf`
`sma_permissions`.`purchases-email`
`sma_permissions`.`purchases-delete`
`sma_permissions`.`transfers-index`
`sma_permissions`.`transfers-add`
`sma_permissions`.`transfers-edit`
`sma_permissions`.`transfers-pdf`
`sma_permissions`.`transfers-email`
`sma_permissions`.`transfers-delete`
`sma_permissions`.`customers-index`
`sma_permissions`.`customers-add`
`sma_permissions`.`customers-edit`
`sma_permissions`.`customers-delete`
`sma_permissions`.`suppliers-index`
`sma_permissions`.`suppliers-add`
`sma_permissions`.`suppliers-edit`
`sma_permissions`.`suppliers-delete`
`sma_permissions`.`sales-deliveries`
`sma_permissions`.`sales-add_delivery`
`sma_permissions`.`sales-edit_delivery`
`sma_permissions`.`sales-delete_delivery`
`sma_permissions`.`sales-email_delivery`
`sma_permissions`.`sales-pdf_delivery`
`sma_permissions`.`sales-gift_cards`
`sma_permissions`.`sales-add_gift_card`
`sma_permissions`.`sales-edit_gift_card`
`sma_permissions`.`sales-delete_gift_card`
`sma_permissions`.`pos-index`
`sma_permissions`.`sales-return_sales`
`sma_permissions`.`reports-index`
`sma_permissions`.`reports-warehouse_stock`
`sma_permissions`.`reports-quantity_alerts`
`sma_permissions`.`reports-expiry_alerts`
`sma_permissions`.`reports-products`
`sma_permissions`.`reports-daily_sales`
`sma_permissions`.`reports-monthly_sales`
`sma_permissions`.`reports-sales`
`sma_permissions`.`reports-payments`
`sma_permissions`.`reports-purchases`
`sma_permissions`.`reports-profit_loss`
`sma_permissions`.`reports-customers`
`sma_permissions`.`reports-suppliers`
`sma_permissions`.`reports-staff`
`sma_permissions`.`reports-register`
`sma_permissions`.`sales-payments`
`sma_permissions`.`purchases-payments`
`sma_permissions`.`purchases-expenses`
`sma_permissions`.`products-adjustments`
`sma_permissions`.`bulk_actions`
`sma_permissions`.`customers-deposits`
`sma_permissions`.`customers-delete_deposit`
`sma_permissions`.`products-barcode`
`sma_permissions`.`purchases-return_purchases`
`sma_permissions`.`reports-expenses`
`sma_permissions`.`reports-daily_purchases`
`sma_permissions`.`reports-monthly_purchases`
`sma_permissions`.`products-stock_count`
`sma_permissions`.`edit_price`
`sma_permissions`.`returns-index`
`sma_permissions`.`returns-add`
`sma_permissions`.`returns-edit`
`sma_permissions`.`returns-delete`
`sma_permissions`.`returns-email`
`sma_permissions`.`returns-pdf`
`sma_permissions`.`reports-tax`
`sma_pos_register`.*
`sma_pos_register`.`id`
`sma_pos_register`.`date`
`sma_pos_register`.`user_id`
`sma_pos_register`.`cash_in_hand`
`sma_pos_register`.`status`
`sma_pos_register`.`total_cash`
`sma_pos_register`.`total_cheques`
`sma_pos_register`.`total_cc_slips`
`sma_pos_register`.`total_cash_submitted`
`sma_pos_register`.`total_cheques_submitted`
`sma_pos_register`.`total_cc_slips_submitted`
`sma_pos_register`.`note`
`sma_pos_register`.`closed_at`
`sma_pos_register`.`transfer_opened_bills`
`sma_pos_register`.`closed_by`
`sma_pos_settings`.*
`sma_pos_settings`.`pos_id`
`sma_pos_settings`.`cat_limit`
`sma_pos_settings`.`pro_limit`
`sma_pos_settings`.`default_category`
`sma_pos_settings`.`default_customer`
`sma_pos_settings`.`default_biller`
`sma_pos_settings`.`display_time`
`sma_pos_settings`.`cf_title1`
`sma_pos_settings`.`cf_title2`
`sma_pos_settings`.`cf_value1`
`sma_pos_settings`.`cf_value2`
`sma_pos_settings`.`receipt_printer`
`sma_pos_settings`.`cash_drawer_codes`
`sma_pos_settings`.`focus_add_item`
`sma_pos_settings`.`add_manual_product`
`sma_pos_settings`.`customer_selection`
`sma_pos_settings`.`add_customer`
`sma_pos_settings`.`toggle_category_slider`
`sma_pos_settings`.`toggle_subcategory_slider`
`sma_pos_settings`.`cancel_sale`
`sma_pos_settings`.`suspend_sale`
`sma_pos_settings`.`print_items_list`
`sma_pos_settings`.`finalize_sale`
`sma_pos_settings`.`today_sale`
`sma_pos_settings`.`open_hold_bills`
`sma_pos_settings`.`close_register`
`sma_pos_settings`.`keyboard`
`sma_pos_settings`.`pos_printers`
`sma_pos_settings`.`java_applet`
`sma_pos_settings`.`product_button_color`
`sma_pos_settings`.`tooltips`
`sma_pos_settings`.`paypal_pro`
`sma_pos_settings`.`stripe`
`sma_pos_settings`.`rounding`
`sma_pos_settings`.`char_per_line`
`sma_pos_settings`.`pin_code`
`sma_pos_settings`.`purchase_code`
`sma_pos_settings`.`envato_username`
`sma_pos_settings`.`version`
`sma_pos_settings`.`after_sale_page`
`sma_pos_settings`.`item_order`
`sma_pos_settings`.`authorize`
`sma_pos_settings`.`toggle_brands_slider`
`sma_pos_settings`.`remote_printing`
`sma_pos_settings`.`printer`
`sma_pos_settings`.`order_printers`
`sma_pos_settings`.`auto_print`
`sma_pos_settings`.`customer_details`
`sma_pos_settings`.`local_printers`
`sma_price_groups`.*
`sma_price_groups`.`id`
`sma_price_groups`.`name`
`sma_printers`.*
`sma_printers`.`id`
`sma_printers`.`title`
`sma_printers`.`type`
`sma_printers`.`profile`
`sma_printers`.`char_per_line`
`sma_printers`.`path`
`sma_printers`.`ip_address`
`sma_printers`.`port`
`sma_product_photos`.*
`sma_product_photos`.`id`
`sma_product_photos`.`product_id`
`sma_product_photos`.`photo`
`sma_product_prices`.*
`sma_product_prices`.`id`
`sma_product_prices`.`product_id`
`sma_product_prices`.`price_group_id`
`sma_product_prices`.`price`
`sma_product_variants`.*
`sma_product_variants`.`id`
`sma_product_variants`.`product_id`
`sma_product_variants`.`name`
`sma_product_variants`.`cost`
`sma_product_variants`.`price`
`sma_product_variants`.`quantity`
`sma_products`.*
`sma_products`.`id`
`sma_products`.`code`
`sma_products`.`name`
`sma_products`.`unit`
`sma_products`.`cost`
`sma_products`.`price`
`sma_products`.`alert_quantity`
`sma_products`.`image`
`sma_products`.`category_id`
`sma_products`.`subcategory_id`
`sma_products`.`cf1`
`sma_products`.`cf2`
`sma_products`.`cf3`
`sma_products`.`cf4`
`sma_products`.`cf5`
`sma_products`.`cf6`
`sma_products`.`quantity`
`sma_products`.`tax_rate`
`sma_products`.`track_quantity`
`sma_products`.`details`
`sma_products`.`warehouse`
`sma_products`.`barcode_symbology`
`sma_products`.`file`
`sma_products`.`product_details`
`sma_products`.`tax_method`
`sma_products`.`type`
`sma_products`.`supplier1`
`sma_products`.`supplier1price`
`sma_products`.`supplier2`
`sma_products`.`supplier2price`
`sma_products`.`supplier3`
`sma_products`.`supplier3price`
`sma_products`.`supplier4`
`sma_products`.`supplier4price`
`sma_products`.`supplier5`
`sma_products`.`supplier5price`
`sma_products`.`promotion`
`sma_products`.`promo_price`
`sma_products`.`start_date`
`sma_products`.`end_date`
`sma_products`.`supplier1_part_no`
`sma_products`.`supplier2_part_no`
`sma_products`.`supplier3_part_no`
`sma_products`.`supplier4_part_no`
`sma_products`.`supplier5_part_no`
`sma_products`.`sale_unit`
`sma_products`.`purchase_unit`
`sma_products`.`brand`
`sma_products`.`slug`
`sma_products`.`featured`
`sma_products`.`weight`
`sma_products`.`hsn_code`
`sma_products`.`views`
`sma_products`.`hide`
`sma_products`.`second_name`
`sma_products`.`hide_pos`
`sma_promos`.*
`sma_promos`.`id`
`sma_promos`.`name`
`sma_promos`.`product2buy`
`sma_promos`.`product2get`
`sma_promos`.`start_date`
`sma_promos`.`end_date`
`sma_promos`.`description`
`sma_purchase_items`.*
`sma_purchase_items`.`id`
`sma_purchase_items`.`purchase_id`
`sma_purchase_items`.`transfer_id`
`sma_purchase_items`.`product_id`
`sma_purchase_items`.`product_code`
`sma_purchase_items`.`product_name`
`sma_purchase_items`.`option_id`
`sma_purchase_items`.`net_unit_cost`
`sma_purchase_items`.`quantity`
`sma_purchase_items`.`warehouse_id`
`sma_purchase_items`.`item_tax`
`sma_purchase_items`.`tax_rate_id`
`sma_purchase_items`.`tax`
`sma_purchase_items`.`discount`
`sma_purchase_items`.`item_discount`
`sma_purchase_items`.`expiry`
`sma_purchase_items`.`subtotal`
`sma_purchase_items`.`quantity_balance`
`sma_purchase_items`.`date`
`sma_purchase_items`.`status`
`sma_purchase_items`.`unit_cost`
`sma_purchase_items`.`real_unit_cost`
`sma_purchase_items`.`quantity_received`
`sma_purchase_items`.`supplier_part_no`
`sma_purchase_items`.`purchase_item_id`
`sma_purchase_items`.`product_unit_id`
`sma_purchase_items`.`product_unit_code`
`sma_purchase_items`.`unit_quantity`
`sma_purchase_items`.`gst`
`sma_purchase_items`.`cgst`
`sma_purchase_items`.`sgst`
`sma_purchase_items`.`igst`
`sma_purchase_items`.`base_unit_cost`
`sma_purchases`.*
`sma_purchases`.`id`
`sma_purchases`.`reference_no`
`sma_purchases`.`date`
`sma_purchases`.`supplier_id`
`sma_purchases`.`supplier`
`sma_purchases`.`warehouse_id`
`sma_purchases`.`note`
`sma_purchases`.`total`
`sma_purchases`.`product_discount`
`sma_purchases`.`order_discount_id`
`sma_purchases`.`order_discount`
`sma_purchases`.`total_discount`
`sma_purchases`.`product_tax`
`sma_purchases`.`order_tax_id`
`sma_purchases`.`order_tax`
`sma_purchases`.`total_tax`
`sma_purchases`.`shipping`
`sma_purchases`.`grand_total`
`sma_purchases`.`paid`
`sma_purchases`.`status`
`sma_purchases`.`payment_status`
`sma_purchases`.`created_by`
`sma_purchases`.`updated_by`
`sma_purchases`.`updated_at`
`sma_purchases`.`attachment`
`sma_purchases`.`payment_term`
`sma_purchases`.`due_date`
`sma_purchases`.`return_id`
`sma_purchases`.`surcharge`
`sma_purchases`.`return_purchase_ref`
`sma_purchases`.`purchase_id`
`sma_purchases`.`return_purchase_total`
`sma_purchases`.`cgst`
`sma_purchases`.`sgst`
`sma_purchases`.`igst`
`sma_quote_items`.*
`sma_quote_items`.`id`
`sma_quote_items`.`quote_id`
`sma_quote_items`.`product_id`
`sma_quote_items`.`product_code`
`sma_quote_items`.`product_name`
`sma_quote_items`.`product_type`
`sma_quote_items`.`option_id`
`sma_quote_items`.`net_unit_price`
`sma_quote_items`.`unit_price`
`sma_quote_items`.`quantity`
`sma_quote_items`.`warehouse_id`
`sma_quote_items`.`item_tax`
`sma_quote_items`.`tax_rate_id`
`sma_quote_items`.`tax`
`sma_quote_items`.`discount`
`sma_quote_items`.`item_discount`
`sma_quote_items`.`subtotal`
`sma_quote_items`.`serial_no`
`sma_quote_items`.`real_unit_price`
`sma_quote_items`.`product_unit_id`
`sma_quote_items`.`product_unit_code`
`sma_quote_items`.`unit_quantity`
`sma_quote_items`.`gst`
`sma_quote_items`.`cgst`
`sma_quote_items`.`sgst`
`sma_quote_items`.`igst`
`sma_quotes`.*
`sma_quotes`.`id`
`sma_quotes`.`date`
`sma_quotes`.`reference_no`
`sma_quotes`.`customer_id`
`sma_quotes`.`customer`
`sma_quotes`.`warehouse_id`
`sma_quotes`.`biller_id`
`sma_quotes`.`biller`
`sma_quotes`.`note`
`sma_quotes`.`internal_note`
`sma_quotes`.`total`
`sma_quotes`.`product_discount`
`sma_quotes`.`order_discount`
`sma_quotes`.`order_discount_id`
`sma_quotes`.`total_discount`
`sma_quotes`.`product_tax`
`sma_quotes`.`order_tax_id`
`sma_quotes`.`order_tax`
`sma_quotes`.`total_tax`
`sma_quotes`.`shipping`
`sma_quotes`.`grand_total`
`sma_quotes`.`status`
`sma_quotes`.`created_by`
`sma_quotes`.`updated_by`
`sma_quotes`.`updated_at`
`sma_quotes`.`attachment`
`sma_quotes`.`supplier_id`
`sma_quotes`.`supplier`
`sma_quotes`.`hash`
`sma_quotes`.`cgst`
`sma_quotes`.`sgst`
`sma_quotes`.`igst`
`sma_return_items`.*
`sma_return_items`.`id`
`sma_return_items`.`return_id`
`sma_return_items`.`product_id`
`sma_return_items`.`product_code`
`sma_return_items`.`product_name`
`sma_return_items`.`product_type`
`sma_return_items`.`option_id`
`sma_return_items`.`net_unit_price`
`sma_return_items`.`unit_price`
`sma_return_items`.`quantity`
`sma_return_items`.`warehouse_id`
`sma_return_items`.`item_tax`
`sma_return_items`.`tax_rate_id`
`sma_return_items`.`tax`
`sma_return_items`.`discount`
`sma_return_items`.`item_discount`
`sma_return_items`.`subtotal`
`sma_return_items`.`serial_no`
`sma_return_items`.`real_unit_price`
`sma_return_items`.`product_unit_id`
`sma_return_items`.`product_unit_code`
`sma_return_items`.`unit_quantity`
`sma_return_items`.`comment`
`sma_return_items`.`gst`
`sma_return_items`.`cgst`
`sma_return_items`.`sgst`
`sma_return_items`.`igst`
`sma_returns`.*
`sma_returns`.`id`
`sma_returns`.`date`
`sma_returns`.`reference_no`
`sma_returns`.`customer_id`
`sma_returns`.`customer`
`sma_returns`.`biller_id`
`sma_returns`.`biller`
`sma_returns`.`warehouse_id`
`sma_returns`.`note`
`sma_returns`.`staff_note`
`sma_returns`.`total`
`sma_returns`.`product_discount`
`sma_returns`.`order_discount_id`
`sma_returns`.`total_discount`
`sma_returns`.`order_discount`
`sma_returns`.`product_tax`
`sma_returns`.`order_tax_id`
`sma_returns`.`order_tax`
`sma_returns`.`total_tax`
`sma_returns`.`grand_total`
`sma_returns`.`created_by`
`sma_returns`.`updated_by`
`sma_returns`.`updated_at`
`sma_returns`.`total_items`
`sma_returns`.`paid`
`sma_returns`.`surcharge`
`sma_returns`.`attachment`
`sma_returns`.`hash`
`sma_returns`.`cgst`
`sma_returns`.`sgst`
`sma_returns`.`igst`
`sma_returns`.`shipping`
`sma_sale_items`.*
`sma_sale_items`.`id`
`sma_sale_items`.`sale_id`
`sma_sale_items`.`product_id`
`sma_sale_items`.`product_code`
`sma_sale_items`.`product_name`
`sma_sale_items`.`product_type`
`sma_sale_items`.`option_id`
`sma_sale_items`.`net_unit_price`
`sma_sale_items`.`unit_price`
`sma_sale_items`.`quantity`
`sma_sale_items`.`warehouse_id`
`sma_sale_items`.`item_tax`
`sma_sale_items`.`tax_rate_id`
`sma_sale_items`.`tax`
`sma_sale_items`.`discount`
`sma_sale_items`.`item_discount`
`sma_sale_items`.`subtotal`
`sma_sale_items`.`serial_no`
`sma_sale_items`.`real_unit_price`
`sma_sale_items`.`sale_item_id`
`sma_sale_items`.`product_unit_id`
`sma_sale_items`.`product_unit_code`
`sma_sale_items`.`unit_quantity`
`sma_sale_items`.`comment`
`sma_sale_items`.`gst`
`sma_sale_items`.`cgst`
`sma_sale_items`.`sgst`
`sma_sale_items`.`igst`
`sma_sales`.*
`sma_sales`.`id`
`sma_sales`.`date`
`sma_sales`.`reference_no`
`sma_sales`.`customer_id`
`sma_sales`.`customer`
`sma_sales`.`biller_id`
`sma_sales`.`biller`
`sma_sales`.`warehouse_id`
`sma_sales`.`note`
`sma_sales`.`staff_note`
`sma_sales`.`total`
`sma_sales`.`product_discount`
`sma_sales`.`order_discount_id`
`sma_sales`.`total_discount`
`sma_sales`.`order_discount`
`sma_sales`.`product_tax`
`sma_sales`.`order_tax_id`
`sma_sales`.`order_tax`
`sma_sales`.`total_tax`
`sma_sales`.`shipping`
`sma_sales`.`grand_total`
`sma_sales`.`sale_status`
`sma_sales`.`payment_status`
`sma_sales`.`payment_term`
`sma_sales`.`due_date`
`sma_sales`.`created_by`
`sma_sales`.`updated_by`
`sma_sales`.`updated_at`
`sma_sales`.`total_items`
`sma_sales`.`pos`
`sma_sales`.`paid`
`sma_sales`.`return_id`
`sma_sales`.`surcharge`
`sma_sales`.`attachment`
`sma_sales`.`return_sale_ref`
`sma_sales`.`sale_id`
`sma_sales`.`return_sale_total`
`sma_sales`.`rounding`
`sma_sales`.`suspend_note`
`sma_sales`.`api`
`sma_sales`.`shop`
`sma_sales`.`address_id`
`sma_sales`.`reserve_id`
`sma_sales`.`hash`
`sma_sales`.`manual_payment`
`sma_sales`.`cgst`
`sma_sales`.`sgst`
`sma_sales`.`igst`
`sma_sales`.`payment_method`
`sma_sessions`.*
`sma_sessions`.`id`
`sma_sessions`.`ip_address`
`sma_sessions`.`timestamp`
`sma_sessions`.`data`
`sma_settings`.*
`sma_settings`.`setting_id`
`sma_settings`.`logo`
`sma_settings`.`logo2`
`sma_settings`.`site_name`
`sma_settings`.`language`
`sma_settings`.`default_warehouse`
`sma_settings`.`accounting_method`
`sma_settings`.`default_currency`
`sma_settings`.`default_tax_rate`
`sma_settings`.`rows_per_page`
`sma_settings`.`version`
`sma_settings`.`default_tax_rate2`
`sma_settings`.`dateformat`
`sma_settings`.`sales_prefix`
`sma_settings`.`quote_prefix`
`sma_settings`.`purchase_prefix`
`sma_settings`.`transfer_prefix`
`sma_settings`.`delivery_prefix`
`sma_settings`.`payment_prefix`
`sma_settings`.`return_prefix`
`sma_settings`.`returnp_prefix`
`sma_settings`.`expense_prefix`
`sma_settings`.`item_addition`
`sma_settings`.`theme`
`sma_settings`.`product_serial`
`sma_settings`.`default_discount`
`sma_settings`.`product_discount`
`sma_settings`.`discount_method`
`sma_settings`.`tax1`
`sma_settings`.`tax2`
`sma_settings`.`overselling`
`sma_settings`.`restrict_user`
`sma_settings`.`restrict_calendar`
`sma_settings`.`timezone`
`sma_settings`.`iwidth`
`sma_settings`.`iheight`
`sma_settings`.`twidth`
`sma_settings`.`theight`
`sma_settings`.`watermark`
`sma_settings`.`reg_ver`
`sma_settings`.`allow_reg`
`sma_settings`.`reg_notification`
`sma_settings`.`auto_reg`
`sma_settings`.`protocol`
`sma_settings`.`mailpath`
`sma_settings`.`smtp_host`
`sma_settings`.`smtp_user`
`sma_settings`.`smtp_pass`
`sma_settings`.`smtp_port`
`sma_settings`.`smtp_crypto`
`sma_settings`.`corn`
`sma_settings`.`customer_group`
`sma_settings`.`default_email`
`sma_settings`.`mmode`
`sma_settings`.`bc_fix`
`sma_settings`.`auto_detect_barcode`
`sma_settings`.`captcha`
`sma_settings`.`reference_format`
`sma_settings`.`racks`
`sma_settings`.`attributes`
`sma_settings`.`product_expiry`
`sma_settings`.`decimals`
`sma_settings`.`qty_decimals`
`sma_settings`.`decimals_sep`
`sma_settings`.`thousands_sep`
`sma_settings`.`invoice_view`
`sma_settings`.`default_biller`
`sma_settings`.`envato_username`
`sma_settings`.`purchase_code`
`sma_settings`.`rtl`
`sma_settings`.`each_spent`
`sma_settings`.`ca_point`
`sma_settings`.`each_sale`
`sma_settings`.`sa_point`
`sma_settings`.`update`
`sma_settings`.`sac`
`sma_settings`.`display_all_products`
`sma_settings`.`display_symbol`
`sma_settings`.`symbol`
`sma_settings`.`remove_expired`
`sma_settings`.`barcode_separator`
`sma_settings`.`set_focus`
`sma_settings`.`price_group`
`sma_settings`.`barcode_img`
`sma_settings`.`ppayment_prefix`
`sma_settings`.`disable_editing`
`sma_settings`.`qa_prefix`
`sma_settings`.`update_cost`
`sma_settings`.`apis`
`sma_settings`.`state`
`sma_settings`.`pdf_lib`
`sma_settings`.`use_code_for_slug`
`sma_settings`.`ws_barcode_type`
`sma_settings`.`ws_barcode_chars`
`sma_settings`.`flag_chars`
`sma_settings`.`item_code_start`
`sma_settings`.`item_code_chars`
`sma_settings`.`price_start`
`sma_settings`.`price_chars`
`sma_settings`.`price_divide_by`
`sma_settings`.`weight_start`
`sma_settings`.`weight_chars`
`sma_settings`.`weight_divide_by`
`sma_settings`.`ksa_qrcode`
`sma_shop_settings`.*
`sma_shop_settings`.`shop_id`
`sma_shop_settings`.`shop_name`
`sma_shop_settings`.`description`
`sma_shop_settings`.`warehouse`
`sma_shop_settings`.`biller`
`sma_shop_settings`.`about_link`
`sma_shop_settings`.`terms_link`
`sma_shop_settings`.`privacy_link`
`sma_shop_settings`.`contact_link`
`sma_shop_settings`.`payment_text`
`sma_shop_settings`.`follow_text`
`sma_shop_settings`.`facebook`
`sma_shop_settings`.`twitter`
`sma_shop_settings`.`google_plus`
`sma_shop_settings`.`instagram`
`sma_shop_settings`.`phone`
`sma_shop_settings`.`email`
`sma_shop_settings`.`cookie_message`
`sma_shop_settings`.`cookie_link`
`sma_shop_settings`.`slider`
`sma_shop_settings`.`shipping`
`sma_shop_settings`.`purchase_code`
`sma_shop_settings`.`envato_username`
`sma_shop_settings`.`version`
`sma_shop_settings`.`logo`
`sma_shop_settings`.`bank_details`
`sma_shop_settings`.`products_page`
`sma_shop_settings`.`hide0`
`sma_shop_settings`.`products_description`
`sma_shop_settings`.`private`
`sma_shop_settings`.`hide_price`
`sma_shop_settings`.`stripe`
`sma_skrill`.*
`sma_skrill`.`id`
`sma_skrill`.`active`
`sma_skrill`.`account_email`
`sma_skrill`.`secret_word`
`sma_skrill`.`skrill_currency`
`sma_skrill`.`fixed_charges`
`sma_skrill`.`extra_charges_my`
`sma_skrill`.`extra_charges_other`
`sma_sms_settings`.*
`sma_sms_settings`.`id`
`sma_sms_settings`.`auto_send`
`sma_sms_settings`.`config`
`sma_stock_count_items`.*
`sma_stock_count_items`.`id`
`sma_stock_count_items`.`stock_count_id`
`sma_stock_count_items`.`product_id`
`sma_stock_count_items`.`product_code`
`sma_stock_count_items`.`product_name`
`sma_stock_count_items`.`product_variant`
`sma_stock_count_items`.`product_variant_id`
`sma_stock_count_items`.`expected`
`sma_stock_count_items`.`counted`
`sma_stock_count_items`.`cost`
`sma_stock_counts`.*
`sma_stock_counts`.`id`
`sma_stock_counts`.`date`
`sma_stock_counts`.`reference_no`
`sma_stock_counts`.`warehouse_id`
`sma_stock_counts`.`type`
`sma_stock_counts`.`initial_file`
`sma_stock_counts`.`final_file`
`sma_stock_counts`.`brands`
`sma_stock_counts`.`brand_names`
`sma_stock_counts`.`categories`
`sma_stock_counts`.`category_names`
`sma_stock_counts`.`note`
`sma_stock_counts`.`products`
`sma_stock_counts`.`rows`
`sma_stock_counts`.`differences`
`sma_stock_counts`.`matches`
`sma_stock_counts`.`missing`
`sma_stock_counts`.`created_by`
`sma_stock_counts`.`updated_by`
`sma_stock_counts`.`updated_at`
`sma_stock_counts`.`finalized`
`sma_suspended_bills`.*
`sma_suspended_bills`.`id`
`sma_suspended_bills`.`date`
`sma_suspended_bills`.`customer_id`
`sma_suspended_bills`.`customer`
`sma_suspended_bills`.`count`
`sma_suspended_bills`.`order_discount_id`
`sma_suspended_bills`.`order_tax_id`
`sma_suspended_bills`.`total`
`sma_suspended_bills`.`biller_id`
`sma_suspended_bills`.`warehouse_id`
`sma_suspended_bills`.`created_by`
`sma_suspended_bills`.`suspend_note`
`sma_suspended_bills`.`shipping`
`sma_suspended_bills`.`cgst`
`sma_suspended_bills`.`sgst`
`sma_suspended_bills`.`igst`
`sma_suspended_items`.*
`sma_suspended_items`.`id`
`sma_suspended_items`.`suspend_id`
`sma_suspended_items`.`product_id`
`sma_suspended_items`.`product_code`
`sma_suspended_items`.`product_name`
`sma_suspended_items`.`net_unit_price`
`sma_suspended_items`.`unit_price`
`sma_suspended_items`.`quantity`
`sma_suspended_items`.`warehouse_id`
`sma_suspended_items`.`item_tax`
`sma_suspended_items`.`tax_rate_id`
`sma_suspended_items`.`tax`
`sma_suspended_items`.`discount`
`sma_suspended_items`.`item_discount`
`sma_suspended_items`.`subtotal`
`sma_suspended_items`.`serial_no`
`sma_suspended_items`.`option_id`
`sma_suspended_items`.`product_type`
`sma_suspended_items`.`real_unit_price`
`sma_suspended_items`.`product_unit_id`
`sma_suspended_items`.`product_unit_code`
`sma_suspended_items`.`unit_quantity`
`sma_suspended_items`.`comment`
`sma_suspended_items`.`gst`
`sma_suspended_items`.`cgst`
`sma_suspended_items`.`sgst`
`sma_suspended_items`.`igst`
`sma_tax_rates`.*
`sma_tax_rates`.`id`
`sma_tax_rates`.`name`
`sma_tax_rates`.`code`
`sma_tax_rates`.`rate`
`sma_tax_rates`.`type`
`sma_transfer_items`.*
`sma_transfer_items`.`id`
`sma_transfer_items`.`transfer_id`
`sma_transfer_items`.`product_id`
`sma_transfer_items`.`product_code`
`sma_transfer_items`.`product_name`
`sma_transfer_items`.`option_id`
`sma_transfer_items`.`expiry`
`sma_transfer_items`.`quantity`
`sma_transfer_items`.`tax_rate_id`
`sma_transfer_items`.`tax`
`sma_transfer_items`.`item_tax`
`sma_transfer_items`.`net_unit_cost`
`sma_transfer_items`.`subtotal`
`sma_transfer_items`.`quantity_balance`
`sma_transfer_items`.`unit_cost`
`sma_transfer_items`.`real_unit_cost`
`sma_transfer_items`.`date`
`sma_transfer_items`.`warehouse_id`
`sma_transfer_items`.`product_unit_id`
`sma_transfer_items`.`product_unit_code`
`sma_transfer_items`.`unit_quantity`
`sma_transfer_items`.`gst`
`sma_transfer_items`.`cgst`
`sma_transfer_items`.`sgst`
`sma_transfer_items`.`igst`
`sma_transfers`.*
`sma_transfers`.`id`
`sma_transfers`.`transfer_no`
`sma_transfers`.`date`
`sma_transfers`.`from_warehouse_id`
`sma_transfers`.`from_warehouse_code`
`sma_transfers`.`from_warehouse_name`
`sma_transfers`.`to_warehouse_id`
`sma_transfers`.`to_warehouse_code`
`sma_transfers`.`to_warehouse_name`
`sma_transfers`.`note`
`sma_transfers`.`total`
`sma_transfers`.`total_tax`
`sma_transfers`.`grand_total`
`sma_transfers`.`created_by`
`sma_transfers`.`status`
`sma_transfers`.`shipping`
`sma_transfers`.`attachment`
`sma_transfers`.`cgst`
`sma_transfers`.`sgst`
`sma_transfers`.`igst`
`sma_units`.*
`sma_units`.`id`
`sma_units`.`code`
`sma_units`.`name`
`sma_units`.`base_unit`
`sma_units`.`operator`
`sma_units`.`unit_value`
`sma_units`.`operation_value`
`sma_user_logins`.*
`sma_user_logins`.`id`
`sma_user_logins`.`user_id`
`sma_user_logins`.`company_id`
`sma_user_logins`.`ip_address`
`sma_user_logins`.`login`
`sma_user_logins`.`time`
`sma_users`.*
`sma_users`.`id`
`sma_users`.`last_ip_address`
`sma_users`.`ip_address`
`sma_users`.`username`
`sma_users`.`password`
`sma_users`.`salt`
`sma_users`.`email`
`sma_users`.`activation_code`
`sma_users`.`forgotten_password_code`
`sma_users`.`forgotten_password_time`
`sma_users`.`remember_code`
`sma_users`.`created_on`
`sma_users`.`last_login`
`sma_users`.`active`
`sma_users`.`first_name`
`sma_users`.`last_name`
`sma_users`.`company`
`sma_users`.`phone`
`sma_users`.`avatar`
`sma_users`.`gender`
`sma_users`.`group_id`
`sma_users`.`warehouse_id`
`sma_users`.`biller_id`
`sma_users`.`company_id`
`sma_users`.`show_cost`
`sma_users`.`show_price`
`sma_users`.`award_points`
`sma_users`.`view_right`
`sma_users`.`edit_right`
`sma_users`.`allow_discount`
`sma_variants`.*
`sma_variants`.`id`
`sma_variants`.`name`
`sma_warehouses`.*
`sma_warehouses`.`id`
`sma_warehouses`.`code`
`sma_warehouses`.`name`
`sma_warehouses`.`address`
`sma_warehouses`.`map`
`sma_warehouses`.`phone`
`sma_warehouses`.`email`
`sma_warehouses`.`price_group_id`
`sma_warehouses_products`.*
`sma_warehouses_products`.`id`
`sma_warehouses_products`.`product_id`
`sma_warehouses_products`.`warehouse_id`
`sma_warehouses_products`.`quantity`
`sma_warehouses_products`.`rack`
`sma_warehouses_products`.`avg_cost`
`sma_warehouses_products_variants`.*
`sma_warehouses_products_variants`.`id`
`sma_warehouses_products_variants`.`option_id`
`sma_warehouses_products_variants`.`product_id`
`sma_warehouses_products_variants`.`warehouse_id`
`sma_warehouses_products_variants`.`quantity`
`sma_warehouses_products_variants`.`rack`
`sma_wishlist`.*
`sma_wishlist`.`id`
`sma_wishlist`.`user_id`
`sma_wishlist`.`product_id`
Alias:
Mostrar:
Ordenar:
Ascendente
Descendente
Ascendente
Descendente
Ascendente
Descendente
Orden de clasificación:
1
2
3
1
2
3
1
2
3
Criterio:
Agregar:
Y:
Borrar:
O:
Modificar:
O:
Y:
Insertar
Borrar
O:
Y:
Insertar
Borrar
Insertar
Borrar
Añadir/Eliminar filas de criterio:
-3
-2
-1
0
1
2
3
Añadir/Eliminar columnas:
-3
-2
-1
0
1
2
3
Usar tablas
sma_addresses
sma_adjustment_items
sma_adjustments
sma_api_keys
sma_api_limits
sma_api_logs
sma_attachments
sma_brands
sma_calendar
sma_captcha
sma_cart
sma_categories
sma_combo_items
sma_companies
sma_costing
sma_currencies
sma_customer_groups
sma_date_format
sma_deliveries
sma_deposits
sma_expense_categories
sma_expenses
sma_gift_card_topups
sma_gift_cards
sma_groups
sma_login_attempts
sma_logs
sma_migrations
sma_notifications
sma_order_ref
sma_pages
sma_payments
sma_paypal
sma_permissions
sma_pos_register
sma_pos_settings
sma_price_groups
sma_printers
sma_product_photos
sma_product_prices
sma_product_variants
sma_products
sma_promos
sma_purchase_items
sma_purchases
sma_quote_items
sma_quotes
sma_return_items
sma_returns
sma_sale_items
sma_sales
sma_sessions
sma_settings
sma_shop_settings
sma_skrill
sma_sms_settings
sma_stock_count_items
sma_stock_counts
sma_suspended_bills
sma_suspended_items
sma_tax_rates
sma_transfer_items
sma_transfers
sma_units
sma_user_logins
sma_users
sma_variants
sma_warehouses
sma_warehouses_products
sma_warehouses_products_variants
sma_wishlist
Consulta a la base de datos
sma_import_tmp
: