Récentes
`pv_paola`.`sms_setting`
`pv_demo_test`.`bank_transaction_info`
`pv_paola`.`category_to_store`
`pv_paola`.`shortcut_links`
`pv_paola`.`brand_to_store`
`pv_tienda_010814`.`holding_item`
`pv_tienda_010814`.`language_translations`
`pv_tienda_010814`.`income_sources`
`pv_web_011204`.`bank_accounts`
`pv_tienda_010814`.`transfer_items`
Préférées
Pas de tables préférées.
Nouvelle base de données
central_db
information_schema
mysql
performance_schema
phpmyadmin
pos_moderno
puntoventa
puntoventa
puntoventa_registry
pv
demo
pv_demo
pv_demo_test
pv_fgaete
pv_genesis
pv_paola
pv_pasteleria_ivonne_sierra_spa
pv_tienda_010814
pv_web_011204
test
Panneau de navigation
Arborescence de navigation
Serveurs
Bases de données
Tables
Panneau de navigation
Personnaliser l'apparence du panneau de navigation.
Panneau de navigation
Afficher la navigation des bases de données en tant qu'arborescence
Dans le volet de navigation, remplacer l'arborescence de la base de données par un sélecteur
Relier au panneau principal
Relier au panneau principal en mettant en surbrillance la base de données ou la table active.
Afficher le logo
Afficher le logo dans le panneau de navigation.
URL du lien sous le logo
L'URL vers lequel pointera le logo dans le panneau de navigation.
Fenêtre cible pour la page ouverte lors d'un clic sur le logo
Ouvrir la page en lien dans la fenêtre principale, (
main
) ou dans une nouvelle fenêtre, (
new
).
main
new
Active la surbrillance
Faire ressortir le nom du serveur dans le panneau de navigation.
Nombre maximum d'éléments au premier niveau
Le nombre d'éléments qui peuvent être affichés pour chaque page du premier niveau de l'arborescence de navigation.
Nombre minimum d'éléments pour afficher la boîte de filtrage
Définir le nombre minimum d'éléments (tables, vues, procédures et événements) nécessaires pour afficher la boîte de filtrage.
Tables récemment utilisées
Nombre maximum de tables récentes ; définir à 0 pour désactiver.
Tables préférées
Le nombre maximum de tables préférées ; définir à 0 pour désactiver.
Largeur du panneau de navigation
Définir à 0 pour replier le panneau de navigation.
Arborescence de navigation
Personnaliser l'arborescence de navigation.
Arborescence de navigation
Nombre maximum d'éléments dans la branche
Le nombre d'éléments qui peuvent être affichés pour chaque page de l'arborescence de navigation.
Regrouper les éléments dans l'arborescence
Regrouper les éléments dans l'arborescence de navigation (déterminé par le séparateur défini dans les onglets Bases de données et Tables ci-dessus).
Activer l'expansion de l'arborescence de navigation
Pour offrir la possibilité d'expansion de l'arborescence dans le panneau de navigation.
Afficher les tables dans l'arborescence
Pour afficher les tables dans l'arborescence de navigation
Afficher les vues dans l'arborescence
Pour afficher les vues dans l'arborescence de navigation
Afficher les fonctions dans l'arborescence
Pour afficher les fonctions dans l'arborescence de navigation
Afficher les procédures dans l'arborescence
Pour afficher les procédures dans l'arborescence de navigation
Afficher les évènements dans l'arborescence
Pour afficher les événements dans l'arborescence de navigation
Expansion d'une seule base de données
S'il faut développer automatiquement une base de données unique dans l'arborescence de navigation.
Serveurs
Options d'affichage des serveurs.
Serveurs
Afficher la liste des serveurs
Afficher le choix de serveurs au haut du panneau de navigation.
Afficher les serveurs sous forme de liste
Afficher la liste des serveurs au lieu d'un menu déroulant.
Bases de données
Options d'affichage des bases de données.
Bases de données
Nombre minimum de bases de données pour activer le filtre
Séparateur pour l'arborescence des bases de données
Chaîne qui sépare les noms de bases de données en niveaux.
Tables
Options d'affichage des tables.
Tables
Cible de l'icône d'accès rapide
Structure
SQL
Rechercher
Insérer
Parcourir
Cible de la deuxième icône d'accès rapide
Structure
SQL
Rechercher
Insérer
Parcourir
Séparateur pour l'arborescence des noms de tables
Chaîne qui sépare les noms de table en niveaux.
Nombre de niveaux pour l'arborescence des tables
Déposer des fichiers ici
Téléversement SQL (
0
)
x
-
Afficher les éléments cachés de l'arbre de navigation.
Créer une vue
JavaScript doit être activé !
Serveur : 127.0.0.1
Base de données : pv_paola
Structure
SQL
Rechercher
Requête
(actuelle)
Exporter
Importer
Opérations
Privilèges
Procédures stockées
Évènements
Déclencheurs
Suivi
Concepteur
Colonnes centrales
Console de requêtes SQL
Effacer
Historique
Options
Signets
Déboguer SQL
Faire Ctrl+Entrée pour exécuter la requête
Faire Entrée pour exécuter la requête
croissant
décroissant
Ordre :
Déboguer SQL
Nombre
Ordre d'exécution
Temps nécessaire
Trier par :
Regrouper les requêtes
Dissocier les groupes
Réduire
Développer
Afficher le suivi
Masquer le suivi
Nombre :
Temps nécessaire :
Signets
Actualiser
Ajouter
Aucun signet
Ajouter un signet
Intitulé:
Base de données cible:
Partager ce signet
OK
Options
Définir par défaut
Toujours développer les messages
Afficher l'historique des requêtes au démarrage
Afficher la requête de navigation courante
Exécuter les requêtes avec Entrée et insérer une nouvelle ligne avec Maj+Entrée. Ce choix peut être rendu permanent via les paramètres.
Passer au thème sombre
Réduire
Développer
Exécuter la requête à nouveau
Éditer
Expliquer
Profilage
Signet
La requête a échoué
Base de données :
Daté du :
Chargement en cours
Éditeur ENUM/SET
Créer une vue
Requête à tables multiples
Requête par exemple
Passer en
mode visuel
Signets de recherches sauvegardés :
Nouveau signet
Colonne :
`bank_account_to_store`.*
`bank_account_to_store`.`ba2s`
`bank_account_to_store`.`store_id`
`bank_account_to_store`.`account_id`
`bank_account_to_store`.`deposit`
`bank_account_to_store`.`withdraw`
`bank_account_to_store`.`transfer_from_other`
`bank_account_to_store`.`transfer_to_other`
`bank_account_to_store`.`status`
`bank_account_to_store`.`sort_order`
`bank_accounts`.*
`bank_accounts`.`id`
`bank_accounts`.`account_name`
`bank_accounts`.`account_details`
`bank_accounts`.`initial_balance`
`bank_accounts`.`account_no`
`bank_accounts`.`contact_person`
`bank_accounts`.`phone_number`
`bank_accounts`.`opening_date`
`bank_accounts`.`url`
`bank_accounts`.`total_deposit`
`bank_accounts`.`total_withdraw`
`bank_accounts`.`total_transfer_from_other`
`bank_accounts`.`total_transfer_to_other`
`bank_accounts`.`created_at`
`bank_accounts`.`updated_at`
`bank_transaction_info`.*
`bank_transaction_info`.`info_id`
`bank_transaction_info`.`store_id`
`bank_transaction_info`.`transaction_type`
`bank_transaction_info`.`is_substract`
`bank_transaction_info`.`is_hide`
`bank_transaction_info`.`account_id`
`bank_transaction_info`.`source_id`
`bank_transaction_info`.`exp_category_id`
`bank_transaction_info`.`ref_no`
`bank_transaction_info`.`invoice_id`
`bank_transaction_info`.`title`
`bank_transaction_info`.`details`
`bank_transaction_info`.`from_account_id`
`bank_transaction_info`.`status`
`bank_transaction_info`.`image`
`bank_transaction_info`.`created_by`
`bank_transaction_info`.`created_at`
`bank_transaction_info`.`updated_at`
`bank_transaction_price`.*
`bank_transaction_price`.`price_id`
`bank_transaction_price`.`store_id`
`bank_transaction_price`.`info_id`
`bank_transaction_price`.`ref_no`
`bank_transaction_price`.`amount`
`box_to_store`.*
`box_to_store`.`id`
`box_to_store`.`box_id`
`box_to_store`.`store_id`
`box_to_store`.`status`
`box_to_store`.`sort_order`
`boxes`.*
`boxes`.`box_id`
`boxes`.`box_name`
`boxes`.`code_name`
`boxes`.`box_details`
`brand_to_store`.*
`brand_to_store`.`b2s_id`
`brand_to_store`.`brand_id`
`brand_to_store`.`store_id`
`brand_to_store`.`status`
`brand_to_store`.`sort_order`
`brands`.*
`brands`.`brand_id`
`brands`.`brand_name`
`brands`.`code_name`
`brands`.`brand_details`
`brands`.`brand_image`
`brands`.`created_at`
`brands`.`updated_at`
`cash_register_arqueo_lines`.*
`cash_register_arqueo_lines`.`id`
`cash_register_arqueo_lines`.`session_id`
`cash_register_arqueo_lines`.`phase`
`cash_register_arqueo_lines`.`line_kind`
`cash_register_arqueo_lines`.`pmethod_id`
`cash_register_arqueo_lines`.`label`
`cash_register_arqueo_lines`.`unit_value`
`cash_register_arqueo_lines`.`quantity`
`cash_register_arqueo_lines`.`amount`
`cash_register_movements`.*
`cash_register_movements`.`id`
`cash_register_movements`.`session_id`
`cash_register_movements`.`direction`
`cash_register_movements`.`reason`
`cash_register_movements`.`amount`
`cash_register_movements`.`note`
`cash_register_movements`.`created_by`
`cash_register_movements`.`created_at`
`cash_register_sessions`.*
`cash_register_sessions`.`id`
`cash_register_sessions`.`store_id`
`cash_register_sessions`.`ref_no`
`cash_register_sessions`.`status`
`cash_register_sessions`.`opened_by`
`cash_register_sessions`.`closed_by`
`cash_register_sessions`.`opened_at`
`cash_register_sessions`.`closed_at`
`cash_register_sessions`.`opening_cash`
`cash_register_sessions`.`opening_note`
`cash_register_sessions`.`expected_cash`
`cash_register_sessions`.`expected_total`
`cash_register_sessions`.`counted_cash`
`cash_register_sessions`.`counted_total`
`cash_register_sessions`.`difference_amount`
`cash_register_sessions`.`closing_note`
`cash_register_sessions`.`created_at`
`cash_register_sessions`.`updated_at`
`category_to_store`.*
`category_to_store`.`c2s_id`
`category_to_store`.`ccategory_id`
`category_to_store`.`store_id`
`category_to_store`.`status`
`category_to_store`.`sort_order`
`categorys`.*
`categorys`.`category_id`
`categorys`.`category_name`
`categorys`.`category_slug`
`categorys`.`parent_id`
`categorys`.`category_details`
`categorys`.`category_image`
`categorys`.`created_at`
`categorys`.`updated_at`
`city`.*
`city`.`id`
`city`.`id_department`
`city`.`name`
`city`.`code`
`currency`.*
`currency`.`currency_id`
`currency`.`title`
`currency`.`code`
`currency`.`symbol_left`
`currency`.`symbol_right`
`currency`.`decimal_place`
`currency`.`value`
`currency`.`created_at`
`currency_to_store`.*
`currency_to_store`.`ca2s_id`
`currency_to_store`.`currency_id`
`currency_to_store`.`store_id`
`currency_to_store`.`status`
`currency_to_store`.`sort_order`
`customer_to_store`.*
`customer_to_store`.`c2s_id`
`customer_to_store`.`customer_id`
`customer_to_store`.`store_id`
`customer_to_store`.`balance`
`customer_to_store`.`due`
`customer_to_store`.`status`
`customer_to_store`.`sort_order`
`customer_transactions`.*
`customer_transactions`.`id`
`customer_transactions`.`type`
`customer_transactions`.`reference_no`
`customer_transactions`.`ref_invoice_id`
`customer_transactions`.`customer_id`
`customer_transactions`.`store_id`
`customer_transactions`.`pmethod_id`
`customer_transactions`.`notes`
`customer_transactions`.`amount`
`customer_transactions`.`balance`
`customer_transactions`.`created_by`
`customer_transactions`.`created_at`
`customer_transactions`.`updated_at`
`customers`.*
`customers`.`customer_id`
`customers`.`customer_name`
`customers`.`customer_email`
`customers`.`customer_mobile`
`customers`.`customer_address`
`customers`.`dob`
`customers`.`customer_sex`
`customers`.`customer_age`
`customers`.`gtin`
`customers`.`customer_city`
`customers`.`customer_state`
`customers`.`customer_country`
`customers`.`is_giftcard`
`customers`.`password`
`customers`.`raw_password`
`customers`.`created_at`
`customers`.`updated_at`
`expense_categorys`.*
`expense_categorys`.`category_id`
`expense_categorys`.`category_name`
`expense_categorys`.`category_slug`
`expense_categorys`.`parent_id`
`expense_categorys`.`category_details`
`expense_categorys`.`sell_return`
`expense_categorys`.`sell_delete`
`expense_categorys`.`loan_delete`
`expense_categorys`.`loan_payment`
`expense_categorys`.`giftcard_sell_delete`
`expense_categorys`.`topup_delete`
`expense_categorys`.`product_purchase`
`expense_categorys`.`stock_transfer`
`expense_categorys`.`due_paid`
`expense_categorys`.`status`
`expense_categorys`.`is_hide`
`expense_categorys`.`sort_order`
`expense_categorys`.`created_at`
`expense_categorys`.`updated_at`
`expenses`.*
`expenses`.`id`
`expenses`.`store_id`
`expenses`.`reference_no`
`expenses`.`category_id`
`expenses`.`title`
`expenses`.`amount`
`expenses`.`returnable`
`expenses`.`note`
`expenses`.`attachment`
`expenses`.`status`
`expenses`.`created_by`
`expenses`.`created_at`
`expenses`.`updated_at`
`gift_card_topups`.*
`gift_card_topups`.`id`
`gift_card_topups`.`date`
`gift_card_topups`.`card_id`
`gift_card_topups`.`amount`
`gift_card_topups`.`created_by`
`gift_cards`.*
`gift_cards`.`id`
`gift_cards`.`date`
`gift_cards`.`card_no`
`gift_cards`.`value`
`gift_cards`.`customer_id`
`gift_cards`.`customer`
`gift_cards`.`balance`
`gift_cards`.`expiry`
`gift_cards`.`created_by`
`holding_info`.*
`holding_info`.`info_id`
`holding_info`.`store_id`
`holding_info`.`order_title`
`holding_info`.`ref_no`
`holding_info`.`customer_id`
`holding_info`.`customer_mobile`
`holding_info`.`invoice_note`
`holding_info`.`total_items`
`holding_info`.`created_by`
`holding_info`.`created_at`
`holding_info`.`updated_at`
`holding_item`.*
`holding_item`.`id`
`holding_item`.`ref_no`
`holding_item`.`store_id`
`holding_item`.`item_id`
`holding_item`.`category_id`
`holding_item`.`brand_id`
`holding_item`.`sup_id`
`holding_item`.`item_name`
`holding_item`.`item_price`
`holding_item`.`item_discount`
`holding_item`.`item_tax`
`holding_item`.`tax_method`
`holding_item`.`taxrate_id`
`holding_item`.`tax`
`holding_item`.`gst`
`holding_item`.`cgst`
`holding_item`.`sgst`
`holding_item`.`igst`
`holding_item`.`item_quantity`
`holding_item`.`item_total`
`holding_item`.`created_at`
`holding_price`.*
`holding_price`.`price_id`
`holding_price`.`ref_no`
`holding_price`.`store_id`
`holding_price`.`subtotal`
`holding_price`.`discount_type`
`holding_price`.`discount_amount`
`holding_price`.`item_tax`
`holding_price`.`order_tax`
`holding_price`.`cgst`
`holding_price`.`sgst`
`holding_price`.`igst`
`holding_price`.`shipping_type`
`holding_price`.`shipping_amount`
`holding_price`.`others_charge`
`holding_price`.`payable_amount`
`income_sources`.*
`income_sources`.`source_id`
`income_sources`.`source_name`
`income_sources`.`type`
`income_sources`.`source_slug`
`income_sources`.`parent_id`
`income_sources`.`source_details`
`income_sources`.`for_sell`
`income_sources`.`for_purchase_return`
`income_sources`.`for_due_collection`
`income_sources`.`for_loan`
`income_sources`.`for_giftcard_sell`
`income_sources`.`for_topup`
`income_sources`.`for_stock_transfer`
`income_sources`.`for_purchase_delete`
`income_sources`.`for_expense_delete`
`income_sources`.`profitable`
`income_sources`.`show_in_income`
`income_sources`.`status`
`income_sources`.`is_hide`
`income_sources`.`sort_order`
`income_sources`.`created_at`
`income_sources`.`updated_at`
`installment_orders`.*
`installment_orders`.`id`
`installment_orders`.`store_id`
`installment_orders`.`invoice_id`
`installment_orders`.`purchase_invoice_id`
`installment_orders`.`duration`
`installment_orders`.`interval_count`
`installment_orders`.`installment_count`
`installment_orders`.`interest_percentage`
`installment_orders`.`interest_amount`
`installment_orders`.`initial_amount`
`installment_orders`.`payment_status`
`installment_orders`.`last_installment_date`
`installment_orders`.`installment_end_date`
`installment_orders`.`created_at`
`installment_payments`.*
`installment_payments`.`id`
`installment_payments`.`store_id`
`installment_payments`.`invoice_id`
`installment_payments`.`payment_date`
`installment_payments`.`pmethod_id`
`installment_payments`.`created_by`
`installment_payments`.`note`
`installment_payments`.`capital`
`installment_payments`.`interest`
`installment_payments`.`payable`
`installment_payments`.`paid`
`installment_payments`.`due`
`installment_payments`.`payment_status`
`language_translations`.*
`language_translations`.`id`
`language_translations`.`lang_id`
`language_translations`.`lang_key`
`language_translations`.`key_type`
`language_translations`.`lang_value`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`slug`
`languages`.`code`
`loan_payments`.*
`loan_payments`.`id`
`loan_payments`.`lloan_id`
`loan_payments`.`ref_no`
`loan_payments`.`paid`
`loan_payments`.`note`
`loan_payments`.`created_by`
`loan_payments`.`created_at`
`loan_payments`.`updated_at`
`loans`.*
`loans`.`loan_id`
`loans`.`ref_no`
`loans`.`loan_from`
`loans`.`title`
`loans`.`amount`
`loans`.`interest`
`loans`.`payable`
`loans`.`paid`
`loans`.`due`
`loans`.`details`
`loans`.`attachment`
`loans`.`status`
`loans`.`sort_order`
`loans`.`created_by`
`loans`.`created_at`
`loans`.`updated_at`
`login_logs`.*
`login_logs`.`id`
`login_logs`.`user_id`
`login_logs`.`username`
`login_logs`.`ip`
`login_logs`.`status`
`login_logs`.`created_at`
`mail_sms_tag`.*
`mail_sms_tag`.`tag_id`
`mail_sms_tag`.`type`
`mail_sms_tag`.`tagname`
`mail_sms_tag`.`created_at`
`payments`.*
`payments`.`id`
`payments`.`type`
`payments`.`is_profit`
`payments`.`is_hide`
`payments`.`store_id`
`payments`.`invoice_id`
`payments`.`reference_no`
`payments`.`pmethod_id`
`payments`.`transaction_id`
`payments`.`capital`
`payments`.`amount`
`payments`.`details`
`payments`.`attachment`
`payments`.`note`
`payments`.`total_paid`
`payments`.`pos_balance`
`payments`.`created_by`
`payments`.`created_at`
`pmethod_to_store`.*
`pmethod_to_store`.`p2s_id`
`pmethod_to_store`.`ppmethod_id`
`pmethod_to_store`.`store_id`
`pmethod_to_store`.`status`
`pmethod_to_store`.`sort_order`
`pmethods`.*
`pmethods`.`pmethod_id`
`pmethods`.`name`
`pmethods`.`code_name`
`pmethods`.`details`
`pmethods`.`created_at`
`pmethods`.`updated_at`
`pos_register`.*
`pos_register`.`id`
`pos_register`.`store_id`
`pos_register`.`opening_balance`
`pos_register`.`closing_balance`
`pos_register`.`note`
`pos_register`.`status`
`pos_register`.`created_at`
`pos_register`.`updated_at`
`pos_template_to_store`.*
`pos_template_to_store`.`pt2s`
`pos_template_to_store`.`store_id`
`pos_template_to_store`.`ttemplate_id`
`pos_template_to_store`.`is_active`
`pos_template_to_store`.`status`
`pos_template_to_store`.`sort_order`
`pos_templates`.*
`pos_templates`.`template_id`
`pos_templates`.`template_name`
`pos_templates`.`template_content`
`pos_templates`.`template_css`
`pos_templates`.`created_at`
`pos_templates`.`updated_at`
`pos_templates`.`created_by`
`printer_to_store`.*
`printer_to_store`.`p2s_id`
`printer_to_store`.`pprinter_id`
`printer_to_store`.`store_id`
`printer_to_store`.`path`
`printer_to_store`.`ip_address`
`printer_to_store`.`port`
`printer_to_store`.`status`
`printer_to_store`.`sort_order`
`printers`.*
`printers`.`printer_id`
`printers`.`title`
`printers`.`type`
`printers`.`profile`
`printers`.`char_per_line`
`printers`.`created_at`
`product_images`.*
`product_images`.`image_id`
`product_images`.`product_id`
`product_images`.`url`
`product_images`.`sort_order`
`product_price_history`.*
`product_price_history`.`id`
`product_price_history`.`store_id`
`product_price_history`.`product_id`
`product_price_history`.`purchase_price`
`product_price_history`.`sell_price`
`product_price_history`.`effective_from`
`product_price_history`.`effective_to`
`product_price_history`.`period_type`
`product_price_history`.`source`
`product_price_history`.`source_ref`
`product_price_history`.`note`
`product_price_history`.`created_by`
`product_price_history`.`created_at`
`product_to_store`.*
`product_to_store`.`id`
`product_to_store`.`product_id`
`product_to_store`.`store_id`
`product_to_store`.`purchase_price`
`product_to_store`.`sell_price`
`product_to_store`.`quantity_in_stock`
`product_to_store`.`alert_quantity`
`product_to_store`.`sup_id`
`product_to_store`.`brand_id`
`product_to_store`.`box_id`
`product_to_store`.`taxrate_id`
`product_to_store`.`tax_method`
`product_to_store`.`preference`
`product_to_store`.`e_date`
`product_to_store`.`p_date`
`product_to_store`.`status`
`product_to_store`.`sort_order`
`products`.*
`products`.`p_id`
`products`.`p_type`
`products`.`p_code`
`products`.`hsn_code`
`products`.`barcode_symbology`
`products`.`p_name`
`products`.`category_id`
`products`.`unit_id`
`products`.`p_image`
`products`.`description`
`purchase_info`.*
`purchase_info`.`info_id`
`purchase_info`.`invoice_id`
`purchase_info`.`inv_type`
`purchase_info`.`store_id`
`purchase_info`.`sup_id`
`purchase_info`.`total_item`
`purchase_info`.`status`
`purchase_info`.`total_sell`
`purchase_info`.`purchase_note`
`purchase_info`.`attachment`
`purchase_info`.`is_visible`
`purchase_info`.`payment_status`
`purchase_info`.`checkout_status`
`purchase_info`.`shipping_status`
`purchase_info`.`created_by`
`purchase_info`.`purchase_date`
`purchase_info`.`created_at`
`purchase_info`.`updated_at`
`purchase_item`.*
`purchase_item`.`id`
`purchase_item`.`invoice_id`
`purchase_item`.`store_id`
`purchase_item`.`item_id`
`purchase_item`.`category_id`
`purchase_item`.`brand_id`
`purchase_item`.`item_name`
`purchase_item`.`item_purchase_price`
`purchase_item`.`item_selling_price`
`purchase_item`.`item_quantity`
`purchase_item`.`total_sell`
`purchase_item`.`status`
`purchase_item`.`item_total`
`purchase_item`.`item_tax`
`purchase_item`.`tax_method`
`purchase_item`.`tax`
`purchase_item`.`gst`
`purchase_item`.`cgst`
`purchase_item`.`sgst`
`purchase_item`.`igst`
`purchase_item`.`return_quantity`
`purchase_item`.`installment_quantity`
`purchase_logs`.*
`purchase_logs`.`id`
`purchase_logs`.`sup_id`
`purchase_logs`.`reference_no`
`purchase_logs`.`ref_invoice_id`
`purchase_logs`.`type`
`purchase_logs`.`pmethod_id`
`purchase_logs`.`description`
`purchase_logs`.`amount`
`purchase_logs`.`store_id`
`purchase_logs`.`created_by`
`purchase_logs`.`created_at`
`purchase_logs`.`updated_at`
`purchase_payments`.*
`purchase_payments`.`id`
`purchase_payments`.`type`
`purchase_payments`.`is_hide`
`purchase_payments`.`store_id`
`purchase_payments`.`invoice_id`
`purchase_payments`.`reference_no`
`purchase_payments`.`pmethod_id`
`purchase_payments`.`transaction_id`
`purchase_payments`.`details`
`purchase_payments`.`attachment`
`purchase_payments`.`note`
`purchase_payments`.`amount`
`purchase_payments`.`total_paid`
`purchase_payments`.`balance`
`purchase_payments`.`created_by`
`purchase_payments`.`created_at`
`purchase_price`.*
`purchase_price`.`price_id`
`purchase_price`.`invoice_id`
`purchase_price`.`store_id`
`purchase_price`.`subtotal`
`purchase_price`.`discount_type`
`purchase_price`.`discount_amount`
`purchase_price`.`shipping_type`
`purchase_price`.`shipping_amount`
`purchase_price`.`others_charge`
`purchase_price`.`item_tax`
`purchase_price`.`order_tax`
`purchase_price`.`cgst`
`purchase_price`.`sgst`
`purchase_price`.`igst`
`purchase_price`.`payable_amount`
`purchase_price`.`paid_amount`
`purchase_price`.`due_paid`
`purchase_price`.`due`
`purchase_price`.`return_amount`
`purchase_price`.`balance`
`purchase_return_items`.*
`purchase_return_items`.`id`
`purchase_return_items`.`store_id`
`purchase_return_items`.`invoice_id`
`purchase_return_items`.`item_id`
`purchase_return_items`.`item_name`
`purchase_return_items`.`item_quantity`
`purchase_return_items`.`item_price`
`purchase_return_items`.`item_tax`
`purchase_return_items`.`cgst`
`purchase_return_items`.`sgst`
`purchase_return_items`.`igst`
`purchase_return_items`.`item_total`
`purchase_return_items`.`created_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`store_id`
`purchase_returns`.`reference_no`
`purchase_returns`.`invoice_id`
`purchase_returns`.`sup_id`
`purchase_returns`.`note`
`purchase_returns`.`total_item`
`purchase_returns`.`total_quantity`
`purchase_returns`.`subtotal`
`purchase_returns`.`total_amount`
`purchase_returns`.`item_tax`
`purchase_returns`.`cgst`
`purchase_returns`.`sgst`
`purchase_returns`.`igst`
`purchase_returns`.`attachment`
`purchase_returns`.`created_by`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`quotation_info`.*
`quotation_info`.`info_id`
`quotation_info`.`reference_no`
`quotation_info`.`invoice_id`
`quotation_info`.`store_id`
`quotation_info`.`customer_id`
`quotation_info`.`customer_mobile`
`quotation_info`.`status`
`quotation_info`.`payment_status`
`quotation_info`.`quotation_note`
`quotation_info`.`is_installment`
`quotation_info`.`is_order`
`quotation_info`.`total_items`
`quotation_info`.`address`
`quotation_info`.`pmethod_details`
`quotation_info`.`created_by`
`quotation_info`.`created_at`
`quotation_info`.`updated_at`
`quotation_item`.*
`quotation_item`.`id`
`quotation_item`.`reference_no`
`quotation_item`.`store_id`
`quotation_item`.`sup_id`
`quotation_item`.`category_id`
`quotation_item`.`brand_id`
`quotation_item`.`item_id`
`quotation_item`.`item_name`
`quotation_item`.`item_price`
`quotation_item`.`item_discount`
`quotation_item`.`item_tax`
`quotation_item`.`tax_method`
`quotation_item`.`taxrate_id`
`quotation_item`.`tax`
`quotation_item`.`gst`
`quotation_item`.`cgst`
`quotation_item`.`sgst`
`quotation_item`.`igst`
`quotation_item`.`item_quantity`
`quotation_item`.`item_purchase_price`
`quotation_item`.`item_total`
`quotation_item`.`purchase_invoice_id`
`quotation_price`.*
`quotation_price`.`price_id`
`quotation_price`.`reference_no`
`quotation_price`.`store_id`
`quotation_price`.`subtotal`
`quotation_price`.`discount_type`
`quotation_price`.`discount_amount`
`quotation_price`.`interest_amount`
`quotation_price`.`interest_percentage`
`quotation_price`.`item_tax`
`quotation_price`.`order_tax`
`quotation_price`.`cgst`
`quotation_price`.`sgst`
`quotation_price`.`igst`
`quotation_price`.`total_purchase_price`
`quotation_price`.`shipping_type`
`quotation_price`.`shipping_amount`
`quotation_price`.`others_charge`
`quotation_price`.`payable_amount`
`return_items`.*
`return_items`.`id`
`return_items`.`store_id`
`return_items`.`reference_no`
`return_items`.`item_id`
`return_items`.`item_name`
`return_items`.`item_quantity`
`return_items`.`item_purchase_price`
`return_items`.`item_price`
`return_items`.`item_tax`
`return_items`.`cgst`
`return_items`.`sgst`
`return_items`.`igst`
`return_items`.`item_total`
`return_items`.`created_at`
`returns`.*
`returns`.`id`
`returns`.`store_id`
`returns`.`reference_no`
`returns`.`invoice_id`
`returns`.`purchase_invoice_id`
`returns`.`customer_id`
`returns`.`note`
`returns`.`total_item`
`returns`.`total_quantity`
`returns`.`subtotal`
`returns`.`total_amount`
`returns`.`item_tax`
`returns`.`cgst`
`returns`.`sgst`
`returns`.`igst`
`returns`.`total_purchase_price`
`returns`.`profit`
`returns`.`attachment`
`returns`.`created_by`
`returns`.`created_at`
`returns`.`updated_at`
`sell_logs`.*
`sell_logs`.`id`
`sell_logs`.`customer_id`
`sell_logs`.`reference_no`
`sell_logs`.`ref_invoice_id`
`sell_logs`.`type`
`sell_logs`.`pmethod_id`
`sell_logs`.`description`
`sell_logs`.`amount`
`sell_logs`.`store_id`
`sell_logs`.`created_by`
`sell_logs`.`created_at`
`sell_logs`.`updated_at`
`selling_info`.*
`selling_info`.`info_id`
`selling_info`.`invoice_id`
`selling_info`.`edit_counter`
`selling_info`.`inv_type`
`selling_info`.`store_id`
`selling_info`.`customer_id`
`selling_info`.`customer_mobile`
`selling_info`.`ref_invoice_id`
`selling_info`.`ref_user_id`
`selling_info`.`invoice_note`
`selling_info`.`total_items`
`selling_info`.`is_installment`
`selling_info`.`status`
`selling_info`.`pmethod_id`
`selling_info`.`payment_status`
`selling_info`.`checkout_status`
`selling_info`.`created_by`
`selling_info`.`created_at`
`selling_info`.`updated_at`
`selling_item`.*
`selling_item`.`id`
`selling_item`.`invoice_id`
`selling_item`.`category_id`
`selling_item`.`brand_id`
`selling_item`.`sup_id`
`selling_item`.`store_id`
`selling_item`.`item_id`
`selling_item`.`item_name`
`selling_item`.`item_price`
`selling_item`.`item_discount`
`selling_item`.`item_tax`
`selling_item`.`tax_method`
`selling_item`.`taxrate_id`
`selling_item`.`tax`
`selling_item`.`gst`
`selling_item`.`cgst`
`selling_item`.`sgst`
`selling_item`.`igst`
`selling_item`.`item_quantity`
`selling_item`.`item_purchase_price`
`selling_item`.`item_total`
`selling_item`.`purchase_invoice_id`
`selling_item`.`print_counter`
`selling_item`.`print_counter_time`
`selling_item`.`printed_by`
`selling_item`.`return_quantity`
`selling_item`.`installment_quantity`
`selling_item`.`created_at`
`selling_price`.*
`selling_price`.`price_id`
`selling_price`.`invoice_id`
`selling_price`.`store_id`
`selling_price`.`subtotal`
`selling_price`.`discount_type`
`selling_price`.`discount_amount`
`selling_price`.`interest_amount`
`selling_price`.`interest_percentage`
`selling_price`.`item_tax`
`selling_price`.`order_tax`
`selling_price`.`cgst`
`selling_price`.`sgst`
`selling_price`.`igst`
`selling_price`.`total_purchase_price`
`selling_price`.`shipping_type`
`selling_price`.`shipping_amount`
`selling_price`.`others_charge`
`selling_price`.`payable_amount`
`selling_price`.`paid_amount`
`selling_price`.`due`
`selling_price`.`due_paid`
`selling_price`.`return_amount`
`selling_price`.`balance`
`selling_price`.`profit`
`selling_price`.`previous_due`
`selling_price`.`prev_due_paid`
`settings`.*
`settings`.`id`
`settings`.`version`
`settings`.`is_update_available`
`settings`.`update_version`
`settings`.`update_link`
`settings`.`created_at`
`settings`.`updated_at`
`shortcut_links`.*
`shortcut_links`.`id`
`shortcut_links`.`type`
`shortcut_links`.`href`
`shortcut_links`.`target`
`shortcut_links`.`title`
`shortcut_links`.`icon`
`shortcut_links`.`thumbnail`
`shortcut_links`.`permission_slug`
`shortcut_links`.`status`
`shortcut_links`.`sort_order`
`shortcut_links`.`created_at`
`shortcut_links`.`updated_at`
`sms_schedule`.*
`sms_schedule`.`id`
`sms_schedule`.`schedule_datetime`
`sms_schedule`.`store_id`
`sms_schedule`.`people_type`
`sms_schedule`.`people_sms_type`
`sms_schedule`.`mobile_number`
`sms_schedule`.`people_name`
`sms_schedule`.`sms_text`
`sms_schedule`.`sms_type`
`sms_schedule`.`campaign_name`
`sms_schedule`.`process_status`
`sms_schedule`.`total_try`
`sms_schedule`.`response_text`
`sms_schedule`.`delivery_status`
`sms_schedule`.`created_at`
`sms_setting`.*
`sms_setting`.`id`
`sms_setting`.`type`
`sms_setting`.`api_id`
`sms_setting`.`auth_key`
`sms_setting`.`sender_id`
`sms_setting`.`contact`
`sms_setting`.`username`
`sms_setting`.`password`
`sms_setting`.`maskname`
`sms_setting`.`campaignname`
`sms_setting`.`unicode`
`sms_setting`.`country_code`
`sms_setting`.`url`
`sms_setting`.`status`
`sms_setting`.`sort_order`
`sms_setting`.`created_at`
`sms_setting`.`updated_at`
`stock_movement_items`.*
`stock_movement_items`.`id`
`stock_movement_items`.`movement_id`
`stock_movement_items`.`store_id`
`stock_movement_items`.`product_id`
`stock_movement_items`.`product_name`
`stock_movement_items`.`quantity`
`stock_movement_items`.`unit_cost`
`stock_movement_items`.`unit_sell_price`
`stock_movement_items`.`line_cost_total`
`stock_movement_items`.`line_sell_total`
`stock_movement_items`.`purchase_item_id`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`store_id`
`stock_movements`.`ref_no`
`stock_movements`.`direction`
`stock_movements`.`reason`
`stock_movements`.`note`
`stock_movements`.`total_cost_value`
`stock_movements`.`total_sell_value`
`stock_movements`.`purchase_invoice_id`
`stock_movements`.`created_by`
`stock_movements`.`created_at`
`stores`.*
`stores`.`store_id`
`stores`.`name`
`stores`.`code_name`
`stores`.`mobile`
`stores`.`email`
`stores`.`country`
`stores`.`zip_code`
`stores`.`currency`
`stores`.`vat_reg_no`
`stores`.`cashier_id`
`stores`.`address`
`stores`.`receipt_printer`
`stores`.`cash_drawer_codes`
`stores`.`char_per_line`
`stores`.`remote_printing`
`stores`.`printer`
`stores`.`order_printers`
`stores`.`auto_print`
`stores`.`cash_drawer_enabled`
`stores`.`local_printers`
`stores`.`logo`
`stores`.`favicon`
`stores`.`preference`
`stores`.`sound_effect`
`stores`.`sort_order`
`stores`.`feedback_status`
`stores`.`feedback_at`
`stores`.`deposit_account_id`
`stores`.`thumbnail`
`stores`.`status`
`stores`.`created_at`
`supplier_to_store`.*
`supplier_to_store`.`s2s_id`
`supplier_to_store`.`sup_id`
`supplier_to_store`.`store_id`
`supplier_to_store`.`balance`
`supplier_to_store`.`status`
`supplier_to_store`.`sort_order`
`suppliers`.*
`suppliers`.`sup_id`
`suppliers`.`sup_name`
`suppliers`.`code_name`
`suppliers`.`sup_mobile`
`suppliers`.`sup_email`
`suppliers`.`gtin`
`suppliers`.`sup_address`
`suppliers`.`sup_city`
`suppliers`.`sup_state`
`suppliers`.`sup_country`
`suppliers`.`sup_details`
`suppliers`.`created_at`
`taxrates`.*
`taxrates`.`taxrate_id`
`taxrates`.`taxrate_name`
`taxrates`.`code_name`
`taxrates`.`taxrate`
`taxrates`.`status`
`taxrates`.`sort_order`
`transfer_items`.*
`transfer_items`.`id`
`transfer_items`.`store_id`
`transfer_items`.`transfer_id`
`transfer_items`.`product_id`
`transfer_items`.`product_name`
`transfer_items`.`quantity`
`transfers`.*
`transfers`.`id`
`transfers`.`ref_no`
`transfers`.`invoice_id`
`transfers`.`ref_invoice_id`
`transfers`.`from_store_id`
`transfers`.`to_store_id`
`transfers`.`note`
`transfers`.`total_item`
`transfers`.`total_quantity`
`transfers`.`created_by`
`transfers`.`received_by`
`transfers`.`cancelled_by`
`transfers`.`status`
`transfers`.`attachment`
`transfers`.`created_at`
`unit_to_store`.*
`unit_to_store`.`unit2s_id`
`unit_to_store`.`uunit_id`
`unit_to_store`.`store_id`
`unit_to_store`.`status`
`unit_to_store`.`sort_order`
`units`.*
`units`.`unit_id`
`units`.`unit_name`
`units`.`code_name`
`units`.`unit_details`
`user_group`.*
`user_group`.`group_id`
`user_group`.`name`
`user_group`.`slug`
`user_group`.`sort_order`
`user_group`.`status`
`user_group`.`permission`
`user_to_store`.*
`user_to_store`.`u2s_id`
`user_to_store`.`user_id`
`user_to_store`.`store_id`
`user_to_store`.`status`
`user_to_store`.`sort_order`
`users`.*
`users`.`id`
`users`.`group_id`
`users`.`username`
`users`.`email`
`users`.`mobile`
`users`.`dob`
`users`.`sex`
`users`.`password`
`users`.`raw_password`
`users`.`pass_reset_code`
`users`.`reset_code_time`
`users`.`login_try`
`users`.`last_login`
`users`.`ip`
`users`.`address`
`users`.`preference`
`users`.`user_image`
`users`.`created_at`
`users`.`updated_at`
`bank_account_to_store`.*
`bank_account_to_store`.`ba2s`
`bank_account_to_store`.`store_id`
`bank_account_to_store`.`account_id`
`bank_account_to_store`.`deposit`
`bank_account_to_store`.`withdraw`
`bank_account_to_store`.`transfer_from_other`
`bank_account_to_store`.`transfer_to_other`
`bank_account_to_store`.`status`
`bank_account_to_store`.`sort_order`
`bank_accounts`.*
`bank_accounts`.`id`
`bank_accounts`.`account_name`
`bank_accounts`.`account_details`
`bank_accounts`.`initial_balance`
`bank_accounts`.`account_no`
`bank_accounts`.`contact_person`
`bank_accounts`.`phone_number`
`bank_accounts`.`opening_date`
`bank_accounts`.`url`
`bank_accounts`.`total_deposit`
`bank_accounts`.`total_withdraw`
`bank_accounts`.`total_transfer_from_other`
`bank_accounts`.`total_transfer_to_other`
`bank_accounts`.`created_at`
`bank_accounts`.`updated_at`
`bank_transaction_info`.*
`bank_transaction_info`.`info_id`
`bank_transaction_info`.`store_id`
`bank_transaction_info`.`transaction_type`
`bank_transaction_info`.`is_substract`
`bank_transaction_info`.`is_hide`
`bank_transaction_info`.`account_id`
`bank_transaction_info`.`source_id`
`bank_transaction_info`.`exp_category_id`
`bank_transaction_info`.`ref_no`
`bank_transaction_info`.`invoice_id`
`bank_transaction_info`.`title`
`bank_transaction_info`.`details`
`bank_transaction_info`.`from_account_id`
`bank_transaction_info`.`status`
`bank_transaction_info`.`image`
`bank_transaction_info`.`created_by`
`bank_transaction_info`.`created_at`
`bank_transaction_info`.`updated_at`
`bank_transaction_price`.*
`bank_transaction_price`.`price_id`
`bank_transaction_price`.`store_id`
`bank_transaction_price`.`info_id`
`bank_transaction_price`.`ref_no`
`bank_transaction_price`.`amount`
`box_to_store`.*
`box_to_store`.`id`
`box_to_store`.`box_id`
`box_to_store`.`store_id`
`box_to_store`.`status`
`box_to_store`.`sort_order`
`boxes`.*
`boxes`.`box_id`
`boxes`.`box_name`
`boxes`.`code_name`
`boxes`.`box_details`
`brand_to_store`.*
`brand_to_store`.`b2s_id`
`brand_to_store`.`brand_id`
`brand_to_store`.`store_id`
`brand_to_store`.`status`
`brand_to_store`.`sort_order`
`brands`.*
`brands`.`brand_id`
`brands`.`brand_name`
`brands`.`code_name`
`brands`.`brand_details`
`brands`.`brand_image`
`brands`.`created_at`
`brands`.`updated_at`
`cash_register_arqueo_lines`.*
`cash_register_arqueo_lines`.`id`
`cash_register_arqueo_lines`.`session_id`
`cash_register_arqueo_lines`.`phase`
`cash_register_arqueo_lines`.`line_kind`
`cash_register_arqueo_lines`.`pmethod_id`
`cash_register_arqueo_lines`.`label`
`cash_register_arqueo_lines`.`unit_value`
`cash_register_arqueo_lines`.`quantity`
`cash_register_arqueo_lines`.`amount`
`cash_register_movements`.*
`cash_register_movements`.`id`
`cash_register_movements`.`session_id`
`cash_register_movements`.`direction`
`cash_register_movements`.`reason`
`cash_register_movements`.`amount`
`cash_register_movements`.`note`
`cash_register_movements`.`created_by`
`cash_register_movements`.`created_at`
`cash_register_sessions`.*
`cash_register_sessions`.`id`
`cash_register_sessions`.`store_id`
`cash_register_sessions`.`ref_no`
`cash_register_sessions`.`status`
`cash_register_sessions`.`opened_by`
`cash_register_sessions`.`closed_by`
`cash_register_sessions`.`opened_at`
`cash_register_sessions`.`closed_at`
`cash_register_sessions`.`opening_cash`
`cash_register_sessions`.`opening_note`
`cash_register_sessions`.`expected_cash`
`cash_register_sessions`.`expected_total`
`cash_register_sessions`.`counted_cash`
`cash_register_sessions`.`counted_total`
`cash_register_sessions`.`difference_amount`
`cash_register_sessions`.`closing_note`
`cash_register_sessions`.`created_at`
`cash_register_sessions`.`updated_at`
`category_to_store`.*
`category_to_store`.`c2s_id`
`category_to_store`.`ccategory_id`
`category_to_store`.`store_id`
`category_to_store`.`status`
`category_to_store`.`sort_order`
`categorys`.*
`categorys`.`category_id`
`categorys`.`category_name`
`categorys`.`category_slug`
`categorys`.`parent_id`
`categorys`.`category_details`
`categorys`.`category_image`
`categorys`.`created_at`
`categorys`.`updated_at`
`city`.*
`city`.`id`
`city`.`id_department`
`city`.`name`
`city`.`code`
`currency`.*
`currency`.`currency_id`
`currency`.`title`
`currency`.`code`
`currency`.`symbol_left`
`currency`.`symbol_right`
`currency`.`decimal_place`
`currency`.`value`
`currency`.`created_at`
`currency_to_store`.*
`currency_to_store`.`ca2s_id`
`currency_to_store`.`currency_id`
`currency_to_store`.`store_id`
`currency_to_store`.`status`
`currency_to_store`.`sort_order`
`customer_to_store`.*
`customer_to_store`.`c2s_id`
`customer_to_store`.`customer_id`
`customer_to_store`.`store_id`
`customer_to_store`.`balance`
`customer_to_store`.`due`
`customer_to_store`.`status`
`customer_to_store`.`sort_order`
`customer_transactions`.*
`customer_transactions`.`id`
`customer_transactions`.`type`
`customer_transactions`.`reference_no`
`customer_transactions`.`ref_invoice_id`
`customer_transactions`.`customer_id`
`customer_transactions`.`store_id`
`customer_transactions`.`pmethod_id`
`customer_transactions`.`notes`
`customer_transactions`.`amount`
`customer_transactions`.`balance`
`customer_transactions`.`created_by`
`customer_transactions`.`created_at`
`customer_transactions`.`updated_at`
`customers`.*
`customers`.`customer_id`
`customers`.`customer_name`
`customers`.`customer_email`
`customers`.`customer_mobile`
`customers`.`customer_address`
`customers`.`dob`
`customers`.`customer_sex`
`customers`.`customer_age`
`customers`.`gtin`
`customers`.`customer_city`
`customers`.`customer_state`
`customers`.`customer_country`
`customers`.`is_giftcard`
`customers`.`password`
`customers`.`raw_password`
`customers`.`created_at`
`customers`.`updated_at`
`expense_categorys`.*
`expense_categorys`.`category_id`
`expense_categorys`.`category_name`
`expense_categorys`.`category_slug`
`expense_categorys`.`parent_id`
`expense_categorys`.`category_details`
`expense_categorys`.`sell_return`
`expense_categorys`.`sell_delete`
`expense_categorys`.`loan_delete`
`expense_categorys`.`loan_payment`
`expense_categorys`.`giftcard_sell_delete`
`expense_categorys`.`topup_delete`
`expense_categorys`.`product_purchase`
`expense_categorys`.`stock_transfer`
`expense_categorys`.`due_paid`
`expense_categorys`.`status`
`expense_categorys`.`is_hide`
`expense_categorys`.`sort_order`
`expense_categorys`.`created_at`
`expense_categorys`.`updated_at`
`expenses`.*
`expenses`.`id`
`expenses`.`store_id`
`expenses`.`reference_no`
`expenses`.`category_id`
`expenses`.`title`
`expenses`.`amount`
`expenses`.`returnable`
`expenses`.`note`
`expenses`.`attachment`
`expenses`.`status`
`expenses`.`created_by`
`expenses`.`created_at`
`expenses`.`updated_at`
`gift_card_topups`.*
`gift_card_topups`.`id`
`gift_card_topups`.`date`
`gift_card_topups`.`card_id`
`gift_card_topups`.`amount`
`gift_card_topups`.`created_by`
`gift_cards`.*
`gift_cards`.`id`
`gift_cards`.`date`
`gift_cards`.`card_no`
`gift_cards`.`value`
`gift_cards`.`customer_id`
`gift_cards`.`customer`
`gift_cards`.`balance`
`gift_cards`.`expiry`
`gift_cards`.`created_by`
`holding_info`.*
`holding_info`.`info_id`
`holding_info`.`store_id`
`holding_info`.`order_title`
`holding_info`.`ref_no`
`holding_info`.`customer_id`
`holding_info`.`customer_mobile`
`holding_info`.`invoice_note`
`holding_info`.`total_items`
`holding_info`.`created_by`
`holding_info`.`created_at`
`holding_info`.`updated_at`
`holding_item`.*
`holding_item`.`id`
`holding_item`.`ref_no`
`holding_item`.`store_id`
`holding_item`.`item_id`
`holding_item`.`category_id`
`holding_item`.`brand_id`
`holding_item`.`sup_id`
`holding_item`.`item_name`
`holding_item`.`item_price`
`holding_item`.`item_discount`
`holding_item`.`item_tax`
`holding_item`.`tax_method`
`holding_item`.`taxrate_id`
`holding_item`.`tax`
`holding_item`.`gst`
`holding_item`.`cgst`
`holding_item`.`sgst`
`holding_item`.`igst`
`holding_item`.`item_quantity`
`holding_item`.`item_total`
`holding_item`.`created_at`
`holding_price`.*
`holding_price`.`price_id`
`holding_price`.`ref_no`
`holding_price`.`store_id`
`holding_price`.`subtotal`
`holding_price`.`discount_type`
`holding_price`.`discount_amount`
`holding_price`.`item_tax`
`holding_price`.`order_tax`
`holding_price`.`cgst`
`holding_price`.`sgst`
`holding_price`.`igst`
`holding_price`.`shipping_type`
`holding_price`.`shipping_amount`
`holding_price`.`others_charge`
`holding_price`.`payable_amount`
`income_sources`.*
`income_sources`.`source_id`
`income_sources`.`source_name`
`income_sources`.`type`
`income_sources`.`source_slug`
`income_sources`.`parent_id`
`income_sources`.`source_details`
`income_sources`.`for_sell`
`income_sources`.`for_purchase_return`
`income_sources`.`for_due_collection`
`income_sources`.`for_loan`
`income_sources`.`for_giftcard_sell`
`income_sources`.`for_topup`
`income_sources`.`for_stock_transfer`
`income_sources`.`for_purchase_delete`
`income_sources`.`for_expense_delete`
`income_sources`.`profitable`
`income_sources`.`show_in_income`
`income_sources`.`status`
`income_sources`.`is_hide`
`income_sources`.`sort_order`
`income_sources`.`created_at`
`income_sources`.`updated_at`
`installment_orders`.*
`installment_orders`.`id`
`installment_orders`.`store_id`
`installment_orders`.`invoice_id`
`installment_orders`.`purchase_invoice_id`
`installment_orders`.`duration`
`installment_orders`.`interval_count`
`installment_orders`.`installment_count`
`installment_orders`.`interest_percentage`
`installment_orders`.`interest_amount`
`installment_orders`.`initial_amount`
`installment_orders`.`payment_status`
`installment_orders`.`last_installment_date`
`installment_orders`.`installment_end_date`
`installment_orders`.`created_at`
`installment_payments`.*
`installment_payments`.`id`
`installment_payments`.`store_id`
`installment_payments`.`invoice_id`
`installment_payments`.`payment_date`
`installment_payments`.`pmethod_id`
`installment_payments`.`created_by`
`installment_payments`.`note`
`installment_payments`.`capital`
`installment_payments`.`interest`
`installment_payments`.`payable`
`installment_payments`.`paid`
`installment_payments`.`due`
`installment_payments`.`payment_status`
`language_translations`.*
`language_translations`.`id`
`language_translations`.`lang_id`
`language_translations`.`lang_key`
`language_translations`.`key_type`
`language_translations`.`lang_value`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`slug`
`languages`.`code`
`loan_payments`.*
`loan_payments`.`id`
`loan_payments`.`lloan_id`
`loan_payments`.`ref_no`
`loan_payments`.`paid`
`loan_payments`.`note`
`loan_payments`.`created_by`
`loan_payments`.`created_at`
`loan_payments`.`updated_at`
`loans`.*
`loans`.`loan_id`
`loans`.`ref_no`
`loans`.`loan_from`
`loans`.`title`
`loans`.`amount`
`loans`.`interest`
`loans`.`payable`
`loans`.`paid`
`loans`.`due`
`loans`.`details`
`loans`.`attachment`
`loans`.`status`
`loans`.`sort_order`
`loans`.`created_by`
`loans`.`created_at`
`loans`.`updated_at`
`login_logs`.*
`login_logs`.`id`
`login_logs`.`user_id`
`login_logs`.`username`
`login_logs`.`ip`
`login_logs`.`status`
`login_logs`.`created_at`
`mail_sms_tag`.*
`mail_sms_tag`.`tag_id`
`mail_sms_tag`.`type`
`mail_sms_tag`.`tagname`
`mail_sms_tag`.`created_at`
`payments`.*
`payments`.`id`
`payments`.`type`
`payments`.`is_profit`
`payments`.`is_hide`
`payments`.`store_id`
`payments`.`invoice_id`
`payments`.`reference_no`
`payments`.`pmethod_id`
`payments`.`transaction_id`
`payments`.`capital`
`payments`.`amount`
`payments`.`details`
`payments`.`attachment`
`payments`.`note`
`payments`.`total_paid`
`payments`.`pos_balance`
`payments`.`created_by`
`payments`.`created_at`
`pmethod_to_store`.*
`pmethod_to_store`.`p2s_id`
`pmethod_to_store`.`ppmethod_id`
`pmethod_to_store`.`store_id`
`pmethod_to_store`.`status`
`pmethod_to_store`.`sort_order`
`pmethods`.*
`pmethods`.`pmethod_id`
`pmethods`.`name`
`pmethods`.`code_name`
`pmethods`.`details`
`pmethods`.`created_at`
`pmethods`.`updated_at`
`pos_register`.*
`pos_register`.`id`
`pos_register`.`store_id`
`pos_register`.`opening_balance`
`pos_register`.`closing_balance`
`pos_register`.`note`
`pos_register`.`status`
`pos_register`.`created_at`
`pos_register`.`updated_at`
`pos_template_to_store`.*
`pos_template_to_store`.`pt2s`
`pos_template_to_store`.`store_id`
`pos_template_to_store`.`ttemplate_id`
`pos_template_to_store`.`is_active`
`pos_template_to_store`.`status`
`pos_template_to_store`.`sort_order`
`pos_templates`.*
`pos_templates`.`template_id`
`pos_templates`.`template_name`
`pos_templates`.`template_content`
`pos_templates`.`template_css`
`pos_templates`.`created_at`
`pos_templates`.`updated_at`
`pos_templates`.`created_by`
`printer_to_store`.*
`printer_to_store`.`p2s_id`
`printer_to_store`.`pprinter_id`
`printer_to_store`.`store_id`
`printer_to_store`.`path`
`printer_to_store`.`ip_address`
`printer_to_store`.`port`
`printer_to_store`.`status`
`printer_to_store`.`sort_order`
`printers`.*
`printers`.`printer_id`
`printers`.`title`
`printers`.`type`
`printers`.`profile`
`printers`.`char_per_line`
`printers`.`created_at`
`product_images`.*
`product_images`.`image_id`
`product_images`.`product_id`
`product_images`.`url`
`product_images`.`sort_order`
`product_price_history`.*
`product_price_history`.`id`
`product_price_history`.`store_id`
`product_price_history`.`product_id`
`product_price_history`.`purchase_price`
`product_price_history`.`sell_price`
`product_price_history`.`effective_from`
`product_price_history`.`effective_to`
`product_price_history`.`period_type`
`product_price_history`.`source`
`product_price_history`.`source_ref`
`product_price_history`.`note`
`product_price_history`.`created_by`
`product_price_history`.`created_at`
`product_to_store`.*
`product_to_store`.`id`
`product_to_store`.`product_id`
`product_to_store`.`store_id`
`product_to_store`.`purchase_price`
`product_to_store`.`sell_price`
`product_to_store`.`quantity_in_stock`
`product_to_store`.`alert_quantity`
`product_to_store`.`sup_id`
`product_to_store`.`brand_id`
`product_to_store`.`box_id`
`product_to_store`.`taxrate_id`
`product_to_store`.`tax_method`
`product_to_store`.`preference`
`product_to_store`.`e_date`
`product_to_store`.`p_date`
`product_to_store`.`status`
`product_to_store`.`sort_order`
`products`.*
`products`.`p_id`
`products`.`p_type`
`products`.`p_code`
`products`.`hsn_code`
`products`.`barcode_symbology`
`products`.`p_name`
`products`.`category_id`
`products`.`unit_id`
`products`.`p_image`
`products`.`description`
`purchase_info`.*
`purchase_info`.`info_id`
`purchase_info`.`invoice_id`
`purchase_info`.`inv_type`
`purchase_info`.`store_id`
`purchase_info`.`sup_id`
`purchase_info`.`total_item`
`purchase_info`.`status`
`purchase_info`.`total_sell`
`purchase_info`.`purchase_note`
`purchase_info`.`attachment`
`purchase_info`.`is_visible`
`purchase_info`.`payment_status`
`purchase_info`.`checkout_status`
`purchase_info`.`shipping_status`
`purchase_info`.`created_by`
`purchase_info`.`purchase_date`
`purchase_info`.`created_at`
`purchase_info`.`updated_at`
`purchase_item`.*
`purchase_item`.`id`
`purchase_item`.`invoice_id`
`purchase_item`.`store_id`
`purchase_item`.`item_id`
`purchase_item`.`category_id`
`purchase_item`.`brand_id`
`purchase_item`.`item_name`
`purchase_item`.`item_purchase_price`
`purchase_item`.`item_selling_price`
`purchase_item`.`item_quantity`
`purchase_item`.`total_sell`
`purchase_item`.`status`
`purchase_item`.`item_total`
`purchase_item`.`item_tax`
`purchase_item`.`tax_method`
`purchase_item`.`tax`
`purchase_item`.`gst`
`purchase_item`.`cgst`
`purchase_item`.`sgst`
`purchase_item`.`igst`
`purchase_item`.`return_quantity`
`purchase_item`.`installment_quantity`
`purchase_logs`.*
`purchase_logs`.`id`
`purchase_logs`.`sup_id`
`purchase_logs`.`reference_no`
`purchase_logs`.`ref_invoice_id`
`purchase_logs`.`type`
`purchase_logs`.`pmethod_id`
`purchase_logs`.`description`
`purchase_logs`.`amount`
`purchase_logs`.`store_id`
`purchase_logs`.`created_by`
`purchase_logs`.`created_at`
`purchase_logs`.`updated_at`
`purchase_payments`.*
`purchase_payments`.`id`
`purchase_payments`.`type`
`purchase_payments`.`is_hide`
`purchase_payments`.`store_id`
`purchase_payments`.`invoice_id`
`purchase_payments`.`reference_no`
`purchase_payments`.`pmethod_id`
`purchase_payments`.`transaction_id`
`purchase_payments`.`details`
`purchase_payments`.`attachment`
`purchase_payments`.`note`
`purchase_payments`.`amount`
`purchase_payments`.`total_paid`
`purchase_payments`.`balance`
`purchase_payments`.`created_by`
`purchase_payments`.`created_at`
`purchase_price`.*
`purchase_price`.`price_id`
`purchase_price`.`invoice_id`
`purchase_price`.`store_id`
`purchase_price`.`subtotal`
`purchase_price`.`discount_type`
`purchase_price`.`discount_amount`
`purchase_price`.`shipping_type`
`purchase_price`.`shipping_amount`
`purchase_price`.`others_charge`
`purchase_price`.`item_tax`
`purchase_price`.`order_tax`
`purchase_price`.`cgst`
`purchase_price`.`sgst`
`purchase_price`.`igst`
`purchase_price`.`payable_amount`
`purchase_price`.`paid_amount`
`purchase_price`.`due_paid`
`purchase_price`.`due`
`purchase_price`.`return_amount`
`purchase_price`.`balance`
`purchase_return_items`.*
`purchase_return_items`.`id`
`purchase_return_items`.`store_id`
`purchase_return_items`.`invoice_id`
`purchase_return_items`.`item_id`
`purchase_return_items`.`item_name`
`purchase_return_items`.`item_quantity`
`purchase_return_items`.`item_price`
`purchase_return_items`.`item_tax`
`purchase_return_items`.`cgst`
`purchase_return_items`.`sgst`
`purchase_return_items`.`igst`
`purchase_return_items`.`item_total`
`purchase_return_items`.`created_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`store_id`
`purchase_returns`.`reference_no`
`purchase_returns`.`invoice_id`
`purchase_returns`.`sup_id`
`purchase_returns`.`note`
`purchase_returns`.`total_item`
`purchase_returns`.`total_quantity`
`purchase_returns`.`subtotal`
`purchase_returns`.`total_amount`
`purchase_returns`.`item_tax`
`purchase_returns`.`cgst`
`purchase_returns`.`sgst`
`purchase_returns`.`igst`
`purchase_returns`.`attachment`
`purchase_returns`.`created_by`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`quotation_info`.*
`quotation_info`.`info_id`
`quotation_info`.`reference_no`
`quotation_info`.`invoice_id`
`quotation_info`.`store_id`
`quotation_info`.`customer_id`
`quotation_info`.`customer_mobile`
`quotation_info`.`status`
`quotation_info`.`payment_status`
`quotation_info`.`quotation_note`
`quotation_info`.`is_installment`
`quotation_info`.`is_order`
`quotation_info`.`total_items`
`quotation_info`.`address`
`quotation_info`.`pmethod_details`
`quotation_info`.`created_by`
`quotation_info`.`created_at`
`quotation_info`.`updated_at`
`quotation_item`.*
`quotation_item`.`id`
`quotation_item`.`reference_no`
`quotation_item`.`store_id`
`quotation_item`.`sup_id`
`quotation_item`.`category_id`
`quotation_item`.`brand_id`
`quotation_item`.`item_id`
`quotation_item`.`item_name`
`quotation_item`.`item_price`
`quotation_item`.`item_discount`
`quotation_item`.`item_tax`
`quotation_item`.`tax_method`
`quotation_item`.`taxrate_id`
`quotation_item`.`tax`
`quotation_item`.`gst`
`quotation_item`.`cgst`
`quotation_item`.`sgst`
`quotation_item`.`igst`
`quotation_item`.`item_quantity`
`quotation_item`.`item_purchase_price`
`quotation_item`.`item_total`
`quotation_item`.`purchase_invoice_id`
`quotation_price`.*
`quotation_price`.`price_id`
`quotation_price`.`reference_no`
`quotation_price`.`store_id`
`quotation_price`.`subtotal`
`quotation_price`.`discount_type`
`quotation_price`.`discount_amount`
`quotation_price`.`interest_amount`
`quotation_price`.`interest_percentage`
`quotation_price`.`item_tax`
`quotation_price`.`order_tax`
`quotation_price`.`cgst`
`quotation_price`.`sgst`
`quotation_price`.`igst`
`quotation_price`.`total_purchase_price`
`quotation_price`.`shipping_type`
`quotation_price`.`shipping_amount`
`quotation_price`.`others_charge`
`quotation_price`.`payable_amount`
`return_items`.*
`return_items`.`id`
`return_items`.`store_id`
`return_items`.`reference_no`
`return_items`.`item_id`
`return_items`.`item_name`
`return_items`.`item_quantity`
`return_items`.`item_purchase_price`
`return_items`.`item_price`
`return_items`.`item_tax`
`return_items`.`cgst`
`return_items`.`sgst`
`return_items`.`igst`
`return_items`.`item_total`
`return_items`.`created_at`
`returns`.*
`returns`.`id`
`returns`.`store_id`
`returns`.`reference_no`
`returns`.`invoice_id`
`returns`.`purchase_invoice_id`
`returns`.`customer_id`
`returns`.`note`
`returns`.`total_item`
`returns`.`total_quantity`
`returns`.`subtotal`
`returns`.`total_amount`
`returns`.`item_tax`
`returns`.`cgst`
`returns`.`sgst`
`returns`.`igst`
`returns`.`total_purchase_price`
`returns`.`profit`
`returns`.`attachment`
`returns`.`created_by`
`returns`.`created_at`
`returns`.`updated_at`
`sell_logs`.*
`sell_logs`.`id`
`sell_logs`.`customer_id`
`sell_logs`.`reference_no`
`sell_logs`.`ref_invoice_id`
`sell_logs`.`type`
`sell_logs`.`pmethod_id`
`sell_logs`.`description`
`sell_logs`.`amount`
`sell_logs`.`store_id`
`sell_logs`.`created_by`
`sell_logs`.`created_at`
`sell_logs`.`updated_at`
`selling_info`.*
`selling_info`.`info_id`
`selling_info`.`invoice_id`
`selling_info`.`edit_counter`
`selling_info`.`inv_type`
`selling_info`.`store_id`
`selling_info`.`customer_id`
`selling_info`.`customer_mobile`
`selling_info`.`ref_invoice_id`
`selling_info`.`ref_user_id`
`selling_info`.`invoice_note`
`selling_info`.`total_items`
`selling_info`.`is_installment`
`selling_info`.`status`
`selling_info`.`pmethod_id`
`selling_info`.`payment_status`
`selling_info`.`checkout_status`
`selling_info`.`created_by`
`selling_info`.`created_at`
`selling_info`.`updated_at`
`selling_item`.*
`selling_item`.`id`
`selling_item`.`invoice_id`
`selling_item`.`category_id`
`selling_item`.`brand_id`
`selling_item`.`sup_id`
`selling_item`.`store_id`
`selling_item`.`item_id`
`selling_item`.`item_name`
`selling_item`.`item_price`
`selling_item`.`item_discount`
`selling_item`.`item_tax`
`selling_item`.`tax_method`
`selling_item`.`taxrate_id`
`selling_item`.`tax`
`selling_item`.`gst`
`selling_item`.`cgst`
`selling_item`.`sgst`
`selling_item`.`igst`
`selling_item`.`item_quantity`
`selling_item`.`item_purchase_price`
`selling_item`.`item_total`
`selling_item`.`purchase_invoice_id`
`selling_item`.`print_counter`
`selling_item`.`print_counter_time`
`selling_item`.`printed_by`
`selling_item`.`return_quantity`
`selling_item`.`installment_quantity`
`selling_item`.`created_at`
`selling_price`.*
`selling_price`.`price_id`
`selling_price`.`invoice_id`
`selling_price`.`store_id`
`selling_price`.`subtotal`
`selling_price`.`discount_type`
`selling_price`.`discount_amount`
`selling_price`.`interest_amount`
`selling_price`.`interest_percentage`
`selling_price`.`item_tax`
`selling_price`.`order_tax`
`selling_price`.`cgst`
`selling_price`.`sgst`
`selling_price`.`igst`
`selling_price`.`total_purchase_price`
`selling_price`.`shipping_type`
`selling_price`.`shipping_amount`
`selling_price`.`others_charge`
`selling_price`.`payable_amount`
`selling_price`.`paid_amount`
`selling_price`.`due`
`selling_price`.`due_paid`
`selling_price`.`return_amount`
`selling_price`.`balance`
`selling_price`.`profit`
`selling_price`.`previous_due`
`selling_price`.`prev_due_paid`
`settings`.*
`settings`.`id`
`settings`.`version`
`settings`.`is_update_available`
`settings`.`update_version`
`settings`.`update_link`
`settings`.`created_at`
`settings`.`updated_at`
`shortcut_links`.*
`shortcut_links`.`id`
`shortcut_links`.`type`
`shortcut_links`.`href`
`shortcut_links`.`target`
`shortcut_links`.`title`
`shortcut_links`.`icon`
`shortcut_links`.`thumbnail`
`shortcut_links`.`permission_slug`
`shortcut_links`.`status`
`shortcut_links`.`sort_order`
`shortcut_links`.`created_at`
`shortcut_links`.`updated_at`
`sms_schedule`.*
`sms_schedule`.`id`
`sms_schedule`.`schedule_datetime`
`sms_schedule`.`store_id`
`sms_schedule`.`people_type`
`sms_schedule`.`people_sms_type`
`sms_schedule`.`mobile_number`
`sms_schedule`.`people_name`
`sms_schedule`.`sms_text`
`sms_schedule`.`sms_type`
`sms_schedule`.`campaign_name`
`sms_schedule`.`process_status`
`sms_schedule`.`total_try`
`sms_schedule`.`response_text`
`sms_schedule`.`delivery_status`
`sms_schedule`.`created_at`
`sms_setting`.*
`sms_setting`.`id`
`sms_setting`.`type`
`sms_setting`.`api_id`
`sms_setting`.`auth_key`
`sms_setting`.`sender_id`
`sms_setting`.`contact`
`sms_setting`.`username`
`sms_setting`.`password`
`sms_setting`.`maskname`
`sms_setting`.`campaignname`
`sms_setting`.`unicode`
`sms_setting`.`country_code`
`sms_setting`.`url`
`sms_setting`.`status`
`sms_setting`.`sort_order`
`sms_setting`.`created_at`
`sms_setting`.`updated_at`
`stock_movement_items`.*
`stock_movement_items`.`id`
`stock_movement_items`.`movement_id`
`stock_movement_items`.`store_id`
`stock_movement_items`.`product_id`
`stock_movement_items`.`product_name`
`stock_movement_items`.`quantity`
`stock_movement_items`.`unit_cost`
`stock_movement_items`.`unit_sell_price`
`stock_movement_items`.`line_cost_total`
`stock_movement_items`.`line_sell_total`
`stock_movement_items`.`purchase_item_id`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`store_id`
`stock_movements`.`ref_no`
`stock_movements`.`direction`
`stock_movements`.`reason`
`stock_movements`.`note`
`stock_movements`.`total_cost_value`
`stock_movements`.`total_sell_value`
`stock_movements`.`purchase_invoice_id`
`stock_movements`.`created_by`
`stock_movements`.`created_at`
`stores`.*
`stores`.`store_id`
`stores`.`name`
`stores`.`code_name`
`stores`.`mobile`
`stores`.`email`
`stores`.`country`
`stores`.`zip_code`
`stores`.`currency`
`stores`.`vat_reg_no`
`stores`.`cashier_id`
`stores`.`address`
`stores`.`receipt_printer`
`stores`.`cash_drawer_codes`
`stores`.`char_per_line`
`stores`.`remote_printing`
`stores`.`printer`
`stores`.`order_printers`
`stores`.`auto_print`
`stores`.`cash_drawer_enabled`
`stores`.`local_printers`
`stores`.`logo`
`stores`.`favicon`
`stores`.`preference`
`stores`.`sound_effect`
`stores`.`sort_order`
`stores`.`feedback_status`
`stores`.`feedback_at`
`stores`.`deposit_account_id`
`stores`.`thumbnail`
`stores`.`status`
`stores`.`created_at`
`supplier_to_store`.*
`supplier_to_store`.`s2s_id`
`supplier_to_store`.`sup_id`
`supplier_to_store`.`store_id`
`supplier_to_store`.`balance`
`supplier_to_store`.`status`
`supplier_to_store`.`sort_order`
`suppliers`.*
`suppliers`.`sup_id`
`suppliers`.`sup_name`
`suppliers`.`code_name`
`suppliers`.`sup_mobile`
`suppliers`.`sup_email`
`suppliers`.`gtin`
`suppliers`.`sup_address`
`suppliers`.`sup_city`
`suppliers`.`sup_state`
`suppliers`.`sup_country`
`suppliers`.`sup_details`
`suppliers`.`created_at`
`taxrates`.*
`taxrates`.`taxrate_id`
`taxrates`.`taxrate_name`
`taxrates`.`code_name`
`taxrates`.`taxrate`
`taxrates`.`status`
`taxrates`.`sort_order`
`transfer_items`.*
`transfer_items`.`id`
`transfer_items`.`store_id`
`transfer_items`.`transfer_id`
`transfer_items`.`product_id`
`transfer_items`.`product_name`
`transfer_items`.`quantity`
`transfers`.*
`transfers`.`id`
`transfers`.`ref_no`
`transfers`.`invoice_id`
`transfers`.`ref_invoice_id`
`transfers`.`from_store_id`
`transfers`.`to_store_id`
`transfers`.`note`
`transfers`.`total_item`
`transfers`.`total_quantity`
`transfers`.`created_by`
`transfers`.`received_by`
`transfers`.`cancelled_by`
`transfers`.`status`
`transfers`.`attachment`
`transfers`.`created_at`
`unit_to_store`.*
`unit_to_store`.`unit2s_id`
`unit_to_store`.`uunit_id`
`unit_to_store`.`store_id`
`unit_to_store`.`status`
`unit_to_store`.`sort_order`
`units`.*
`units`.`unit_id`
`units`.`unit_name`
`units`.`code_name`
`units`.`unit_details`
`user_group`.*
`user_group`.`group_id`
`user_group`.`name`
`user_group`.`slug`
`user_group`.`sort_order`
`user_group`.`status`
`user_group`.`permission`
`user_to_store`.*
`user_to_store`.`u2s_id`
`user_to_store`.`user_id`
`user_to_store`.`store_id`
`user_to_store`.`status`
`user_to_store`.`sort_order`
`users`.*
`users`.`id`
`users`.`group_id`
`users`.`username`
`users`.`email`
`users`.`mobile`
`users`.`dob`
`users`.`sex`
`users`.`password`
`users`.`raw_password`
`users`.`pass_reset_code`
`users`.`reset_code_time`
`users`.`login_try`
`users`.`last_login`
`users`.`ip`
`users`.`address`
`users`.`preference`
`users`.`user_image`
`users`.`created_at`
`users`.`updated_at`
`bank_account_to_store`.*
`bank_account_to_store`.`ba2s`
`bank_account_to_store`.`store_id`
`bank_account_to_store`.`account_id`
`bank_account_to_store`.`deposit`
`bank_account_to_store`.`withdraw`
`bank_account_to_store`.`transfer_from_other`
`bank_account_to_store`.`transfer_to_other`
`bank_account_to_store`.`status`
`bank_account_to_store`.`sort_order`
`bank_accounts`.*
`bank_accounts`.`id`
`bank_accounts`.`account_name`
`bank_accounts`.`account_details`
`bank_accounts`.`initial_balance`
`bank_accounts`.`account_no`
`bank_accounts`.`contact_person`
`bank_accounts`.`phone_number`
`bank_accounts`.`opening_date`
`bank_accounts`.`url`
`bank_accounts`.`total_deposit`
`bank_accounts`.`total_withdraw`
`bank_accounts`.`total_transfer_from_other`
`bank_accounts`.`total_transfer_to_other`
`bank_accounts`.`created_at`
`bank_accounts`.`updated_at`
`bank_transaction_info`.*
`bank_transaction_info`.`info_id`
`bank_transaction_info`.`store_id`
`bank_transaction_info`.`transaction_type`
`bank_transaction_info`.`is_substract`
`bank_transaction_info`.`is_hide`
`bank_transaction_info`.`account_id`
`bank_transaction_info`.`source_id`
`bank_transaction_info`.`exp_category_id`
`bank_transaction_info`.`ref_no`
`bank_transaction_info`.`invoice_id`
`bank_transaction_info`.`title`
`bank_transaction_info`.`details`
`bank_transaction_info`.`from_account_id`
`bank_transaction_info`.`status`
`bank_transaction_info`.`image`
`bank_transaction_info`.`created_by`
`bank_transaction_info`.`created_at`
`bank_transaction_info`.`updated_at`
`bank_transaction_price`.*
`bank_transaction_price`.`price_id`
`bank_transaction_price`.`store_id`
`bank_transaction_price`.`info_id`
`bank_transaction_price`.`ref_no`
`bank_transaction_price`.`amount`
`box_to_store`.*
`box_to_store`.`id`
`box_to_store`.`box_id`
`box_to_store`.`store_id`
`box_to_store`.`status`
`box_to_store`.`sort_order`
`boxes`.*
`boxes`.`box_id`
`boxes`.`box_name`
`boxes`.`code_name`
`boxes`.`box_details`
`brand_to_store`.*
`brand_to_store`.`b2s_id`
`brand_to_store`.`brand_id`
`brand_to_store`.`store_id`
`brand_to_store`.`status`
`brand_to_store`.`sort_order`
`brands`.*
`brands`.`brand_id`
`brands`.`brand_name`
`brands`.`code_name`
`brands`.`brand_details`
`brands`.`brand_image`
`brands`.`created_at`
`brands`.`updated_at`
`cash_register_arqueo_lines`.*
`cash_register_arqueo_lines`.`id`
`cash_register_arqueo_lines`.`session_id`
`cash_register_arqueo_lines`.`phase`
`cash_register_arqueo_lines`.`line_kind`
`cash_register_arqueo_lines`.`pmethod_id`
`cash_register_arqueo_lines`.`label`
`cash_register_arqueo_lines`.`unit_value`
`cash_register_arqueo_lines`.`quantity`
`cash_register_arqueo_lines`.`amount`
`cash_register_movements`.*
`cash_register_movements`.`id`
`cash_register_movements`.`session_id`
`cash_register_movements`.`direction`
`cash_register_movements`.`reason`
`cash_register_movements`.`amount`
`cash_register_movements`.`note`
`cash_register_movements`.`created_by`
`cash_register_movements`.`created_at`
`cash_register_sessions`.*
`cash_register_sessions`.`id`
`cash_register_sessions`.`store_id`
`cash_register_sessions`.`ref_no`
`cash_register_sessions`.`status`
`cash_register_sessions`.`opened_by`
`cash_register_sessions`.`closed_by`
`cash_register_sessions`.`opened_at`
`cash_register_sessions`.`closed_at`
`cash_register_sessions`.`opening_cash`
`cash_register_sessions`.`opening_note`
`cash_register_sessions`.`expected_cash`
`cash_register_sessions`.`expected_total`
`cash_register_sessions`.`counted_cash`
`cash_register_sessions`.`counted_total`
`cash_register_sessions`.`difference_amount`
`cash_register_sessions`.`closing_note`
`cash_register_sessions`.`created_at`
`cash_register_sessions`.`updated_at`
`category_to_store`.*
`category_to_store`.`c2s_id`
`category_to_store`.`ccategory_id`
`category_to_store`.`store_id`
`category_to_store`.`status`
`category_to_store`.`sort_order`
`categorys`.*
`categorys`.`category_id`
`categorys`.`category_name`
`categorys`.`category_slug`
`categorys`.`parent_id`
`categorys`.`category_details`
`categorys`.`category_image`
`categorys`.`created_at`
`categorys`.`updated_at`
`city`.*
`city`.`id`
`city`.`id_department`
`city`.`name`
`city`.`code`
`currency`.*
`currency`.`currency_id`
`currency`.`title`
`currency`.`code`
`currency`.`symbol_left`
`currency`.`symbol_right`
`currency`.`decimal_place`
`currency`.`value`
`currency`.`created_at`
`currency_to_store`.*
`currency_to_store`.`ca2s_id`
`currency_to_store`.`currency_id`
`currency_to_store`.`store_id`
`currency_to_store`.`status`
`currency_to_store`.`sort_order`
`customer_to_store`.*
`customer_to_store`.`c2s_id`
`customer_to_store`.`customer_id`
`customer_to_store`.`store_id`
`customer_to_store`.`balance`
`customer_to_store`.`due`
`customer_to_store`.`status`
`customer_to_store`.`sort_order`
`customer_transactions`.*
`customer_transactions`.`id`
`customer_transactions`.`type`
`customer_transactions`.`reference_no`
`customer_transactions`.`ref_invoice_id`
`customer_transactions`.`customer_id`
`customer_transactions`.`store_id`
`customer_transactions`.`pmethod_id`
`customer_transactions`.`notes`
`customer_transactions`.`amount`
`customer_transactions`.`balance`
`customer_transactions`.`created_by`
`customer_transactions`.`created_at`
`customer_transactions`.`updated_at`
`customers`.*
`customers`.`customer_id`
`customers`.`customer_name`
`customers`.`customer_email`
`customers`.`customer_mobile`
`customers`.`customer_address`
`customers`.`dob`
`customers`.`customer_sex`
`customers`.`customer_age`
`customers`.`gtin`
`customers`.`customer_city`
`customers`.`customer_state`
`customers`.`customer_country`
`customers`.`is_giftcard`
`customers`.`password`
`customers`.`raw_password`
`customers`.`created_at`
`customers`.`updated_at`
`expense_categorys`.*
`expense_categorys`.`category_id`
`expense_categorys`.`category_name`
`expense_categorys`.`category_slug`
`expense_categorys`.`parent_id`
`expense_categorys`.`category_details`
`expense_categorys`.`sell_return`
`expense_categorys`.`sell_delete`
`expense_categorys`.`loan_delete`
`expense_categorys`.`loan_payment`
`expense_categorys`.`giftcard_sell_delete`
`expense_categorys`.`topup_delete`
`expense_categorys`.`product_purchase`
`expense_categorys`.`stock_transfer`
`expense_categorys`.`due_paid`
`expense_categorys`.`status`
`expense_categorys`.`is_hide`
`expense_categorys`.`sort_order`
`expense_categorys`.`created_at`
`expense_categorys`.`updated_at`
`expenses`.*
`expenses`.`id`
`expenses`.`store_id`
`expenses`.`reference_no`
`expenses`.`category_id`
`expenses`.`title`
`expenses`.`amount`
`expenses`.`returnable`
`expenses`.`note`
`expenses`.`attachment`
`expenses`.`status`
`expenses`.`created_by`
`expenses`.`created_at`
`expenses`.`updated_at`
`gift_card_topups`.*
`gift_card_topups`.`id`
`gift_card_topups`.`date`
`gift_card_topups`.`card_id`
`gift_card_topups`.`amount`
`gift_card_topups`.`created_by`
`gift_cards`.*
`gift_cards`.`id`
`gift_cards`.`date`
`gift_cards`.`card_no`
`gift_cards`.`value`
`gift_cards`.`customer_id`
`gift_cards`.`customer`
`gift_cards`.`balance`
`gift_cards`.`expiry`
`gift_cards`.`created_by`
`holding_info`.*
`holding_info`.`info_id`
`holding_info`.`store_id`
`holding_info`.`order_title`
`holding_info`.`ref_no`
`holding_info`.`customer_id`
`holding_info`.`customer_mobile`
`holding_info`.`invoice_note`
`holding_info`.`total_items`
`holding_info`.`created_by`
`holding_info`.`created_at`
`holding_info`.`updated_at`
`holding_item`.*
`holding_item`.`id`
`holding_item`.`ref_no`
`holding_item`.`store_id`
`holding_item`.`item_id`
`holding_item`.`category_id`
`holding_item`.`brand_id`
`holding_item`.`sup_id`
`holding_item`.`item_name`
`holding_item`.`item_price`
`holding_item`.`item_discount`
`holding_item`.`item_tax`
`holding_item`.`tax_method`
`holding_item`.`taxrate_id`
`holding_item`.`tax`
`holding_item`.`gst`
`holding_item`.`cgst`
`holding_item`.`sgst`
`holding_item`.`igst`
`holding_item`.`item_quantity`
`holding_item`.`item_total`
`holding_item`.`created_at`
`holding_price`.*
`holding_price`.`price_id`
`holding_price`.`ref_no`
`holding_price`.`store_id`
`holding_price`.`subtotal`
`holding_price`.`discount_type`
`holding_price`.`discount_amount`
`holding_price`.`item_tax`
`holding_price`.`order_tax`
`holding_price`.`cgst`
`holding_price`.`sgst`
`holding_price`.`igst`
`holding_price`.`shipping_type`
`holding_price`.`shipping_amount`
`holding_price`.`others_charge`
`holding_price`.`payable_amount`
`income_sources`.*
`income_sources`.`source_id`
`income_sources`.`source_name`
`income_sources`.`type`
`income_sources`.`source_slug`
`income_sources`.`parent_id`
`income_sources`.`source_details`
`income_sources`.`for_sell`
`income_sources`.`for_purchase_return`
`income_sources`.`for_due_collection`
`income_sources`.`for_loan`
`income_sources`.`for_giftcard_sell`
`income_sources`.`for_topup`
`income_sources`.`for_stock_transfer`
`income_sources`.`for_purchase_delete`
`income_sources`.`for_expense_delete`
`income_sources`.`profitable`
`income_sources`.`show_in_income`
`income_sources`.`status`
`income_sources`.`is_hide`
`income_sources`.`sort_order`
`income_sources`.`created_at`
`income_sources`.`updated_at`
`installment_orders`.*
`installment_orders`.`id`
`installment_orders`.`store_id`
`installment_orders`.`invoice_id`
`installment_orders`.`purchase_invoice_id`
`installment_orders`.`duration`
`installment_orders`.`interval_count`
`installment_orders`.`installment_count`
`installment_orders`.`interest_percentage`
`installment_orders`.`interest_amount`
`installment_orders`.`initial_amount`
`installment_orders`.`payment_status`
`installment_orders`.`last_installment_date`
`installment_orders`.`installment_end_date`
`installment_orders`.`created_at`
`installment_payments`.*
`installment_payments`.`id`
`installment_payments`.`store_id`
`installment_payments`.`invoice_id`
`installment_payments`.`payment_date`
`installment_payments`.`pmethod_id`
`installment_payments`.`created_by`
`installment_payments`.`note`
`installment_payments`.`capital`
`installment_payments`.`interest`
`installment_payments`.`payable`
`installment_payments`.`paid`
`installment_payments`.`due`
`installment_payments`.`payment_status`
`language_translations`.*
`language_translations`.`id`
`language_translations`.`lang_id`
`language_translations`.`lang_key`
`language_translations`.`key_type`
`language_translations`.`lang_value`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`slug`
`languages`.`code`
`loan_payments`.*
`loan_payments`.`id`
`loan_payments`.`lloan_id`
`loan_payments`.`ref_no`
`loan_payments`.`paid`
`loan_payments`.`note`
`loan_payments`.`created_by`
`loan_payments`.`created_at`
`loan_payments`.`updated_at`
`loans`.*
`loans`.`loan_id`
`loans`.`ref_no`
`loans`.`loan_from`
`loans`.`title`
`loans`.`amount`
`loans`.`interest`
`loans`.`payable`
`loans`.`paid`
`loans`.`due`
`loans`.`details`
`loans`.`attachment`
`loans`.`status`
`loans`.`sort_order`
`loans`.`created_by`
`loans`.`created_at`
`loans`.`updated_at`
`login_logs`.*
`login_logs`.`id`
`login_logs`.`user_id`
`login_logs`.`username`
`login_logs`.`ip`
`login_logs`.`status`
`login_logs`.`created_at`
`mail_sms_tag`.*
`mail_sms_tag`.`tag_id`
`mail_sms_tag`.`type`
`mail_sms_tag`.`tagname`
`mail_sms_tag`.`created_at`
`payments`.*
`payments`.`id`
`payments`.`type`
`payments`.`is_profit`
`payments`.`is_hide`
`payments`.`store_id`
`payments`.`invoice_id`
`payments`.`reference_no`
`payments`.`pmethod_id`
`payments`.`transaction_id`
`payments`.`capital`
`payments`.`amount`
`payments`.`details`
`payments`.`attachment`
`payments`.`note`
`payments`.`total_paid`
`payments`.`pos_balance`
`payments`.`created_by`
`payments`.`created_at`
`pmethod_to_store`.*
`pmethod_to_store`.`p2s_id`
`pmethod_to_store`.`ppmethod_id`
`pmethod_to_store`.`store_id`
`pmethod_to_store`.`status`
`pmethod_to_store`.`sort_order`
`pmethods`.*
`pmethods`.`pmethod_id`
`pmethods`.`name`
`pmethods`.`code_name`
`pmethods`.`details`
`pmethods`.`created_at`
`pmethods`.`updated_at`
`pos_register`.*
`pos_register`.`id`
`pos_register`.`store_id`
`pos_register`.`opening_balance`
`pos_register`.`closing_balance`
`pos_register`.`note`
`pos_register`.`status`
`pos_register`.`created_at`
`pos_register`.`updated_at`
`pos_template_to_store`.*
`pos_template_to_store`.`pt2s`
`pos_template_to_store`.`store_id`
`pos_template_to_store`.`ttemplate_id`
`pos_template_to_store`.`is_active`
`pos_template_to_store`.`status`
`pos_template_to_store`.`sort_order`
`pos_templates`.*
`pos_templates`.`template_id`
`pos_templates`.`template_name`
`pos_templates`.`template_content`
`pos_templates`.`template_css`
`pos_templates`.`created_at`
`pos_templates`.`updated_at`
`pos_templates`.`created_by`
`printer_to_store`.*
`printer_to_store`.`p2s_id`
`printer_to_store`.`pprinter_id`
`printer_to_store`.`store_id`
`printer_to_store`.`path`
`printer_to_store`.`ip_address`
`printer_to_store`.`port`
`printer_to_store`.`status`
`printer_to_store`.`sort_order`
`printers`.*
`printers`.`printer_id`
`printers`.`title`
`printers`.`type`
`printers`.`profile`
`printers`.`char_per_line`
`printers`.`created_at`
`product_images`.*
`product_images`.`image_id`
`product_images`.`product_id`
`product_images`.`url`
`product_images`.`sort_order`
`product_price_history`.*
`product_price_history`.`id`
`product_price_history`.`store_id`
`product_price_history`.`product_id`
`product_price_history`.`purchase_price`
`product_price_history`.`sell_price`
`product_price_history`.`effective_from`
`product_price_history`.`effective_to`
`product_price_history`.`period_type`
`product_price_history`.`source`
`product_price_history`.`source_ref`
`product_price_history`.`note`
`product_price_history`.`created_by`
`product_price_history`.`created_at`
`product_to_store`.*
`product_to_store`.`id`
`product_to_store`.`product_id`
`product_to_store`.`store_id`
`product_to_store`.`purchase_price`
`product_to_store`.`sell_price`
`product_to_store`.`quantity_in_stock`
`product_to_store`.`alert_quantity`
`product_to_store`.`sup_id`
`product_to_store`.`brand_id`
`product_to_store`.`box_id`
`product_to_store`.`taxrate_id`
`product_to_store`.`tax_method`
`product_to_store`.`preference`
`product_to_store`.`e_date`
`product_to_store`.`p_date`
`product_to_store`.`status`
`product_to_store`.`sort_order`
`products`.*
`products`.`p_id`
`products`.`p_type`
`products`.`p_code`
`products`.`hsn_code`
`products`.`barcode_symbology`
`products`.`p_name`
`products`.`category_id`
`products`.`unit_id`
`products`.`p_image`
`products`.`description`
`purchase_info`.*
`purchase_info`.`info_id`
`purchase_info`.`invoice_id`
`purchase_info`.`inv_type`
`purchase_info`.`store_id`
`purchase_info`.`sup_id`
`purchase_info`.`total_item`
`purchase_info`.`status`
`purchase_info`.`total_sell`
`purchase_info`.`purchase_note`
`purchase_info`.`attachment`
`purchase_info`.`is_visible`
`purchase_info`.`payment_status`
`purchase_info`.`checkout_status`
`purchase_info`.`shipping_status`
`purchase_info`.`created_by`
`purchase_info`.`purchase_date`
`purchase_info`.`created_at`
`purchase_info`.`updated_at`
`purchase_item`.*
`purchase_item`.`id`
`purchase_item`.`invoice_id`
`purchase_item`.`store_id`
`purchase_item`.`item_id`
`purchase_item`.`category_id`
`purchase_item`.`brand_id`
`purchase_item`.`item_name`
`purchase_item`.`item_purchase_price`
`purchase_item`.`item_selling_price`
`purchase_item`.`item_quantity`
`purchase_item`.`total_sell`
`purchase_item`.`status`
`purchase_item`.`item_total`
`purchase_item`.`item_tax`
`purchase_item`.`tax_method`
`purchase_item`.`tax`
`purchase_item`.`gst`
`purchase_item`.`cgst`
`purchase_item`.`sgst`
`purchase_item`.`igst`
`purchase_item`.`return_quantity`
`purchase_item`.`installment_quantity`
`purchase_logs`.*
`purchase_logs`.`id`
`purchase_logs`.`sup_id`
`purchase_logs`.`reference_no`
`purchase_logs`.`ref_invoice_id`
`purchase_logs`.`type`
`purchase_logs`.`pmethod_id`
`purchase_logs`.`description`
`purchase_logs`.`amount`
`purchase_logs`.`store_id`
`purchase_logs`.`created_by`
`purchase_logs`.`created_at`
`purchase_logs`.`updated_at`
`purchase_payments`.*
`purchase_payments`.`id`
`purchase_payments`.`type`
`purchase_payments`.`is_hide`
`purchase_payments`.`store_id`
`purchase_payments`.`invoice_id`
`purchase_payments`.`reference_no`
`purchase_payments`.`pmethod_id`
`purchase_payments`.`transaction_id`
`purchase_payments`.`details`
`purchase_payments`.`attachment`
`purchase_payments`.`note`
`purchase_payments`.`amount`
`purchase_payments`.`total_paid`
`purchase_payments`.`balance`
`purchase_payments`.`created_by`
`purchase_payments`.`created_at`
`purchase_price`.*
`purchase_price`.`price_id`
`purchase_price`.`invoice_id`
`purchase_price`.`store_id`
`purchase_price`.`subtotal`
`purchase_price`.`discount_type`
`purchase_price`.`discount_amount`
`purchase_price`.`shipping_type`
`purchase_price`.`shipping_amount`
`purchase_price`.`others_charge`
`purchase_price`.`item_tax`
`purchase_price`.`order_tax`
`purchase_price`.`cgst`
`purchase_price`.`sgst`
`purchase_price`.`igst`
`purchase_price`.`payable_amount`
`purchase_price`.`paid_amount`
`purchase_price`.`due_paid`
`purchase_price`.`due`
`purchase_price`.`return_amount`
`purchase_price`.`balance`
`purchase_return_items`.*
`purchase_return_items`.`id`
`purchase_return_items`.`store_id`
`purchase_return_items`.`invoice_id`
`purchase_return_items`.`item_id`
`purchase_return_items`.`item_name`
`purchase_return_items`.`item_quantity`
`purchase_return_items`.`item_price`
`purchase_return_items`.`item_tax`
`purchase_return_items`.`cgst`
`purchase_return_items`.`sgst`
`purchase_return_items`.`igst`
`purchase_return_items`.`item_total`
`purchase_return_items`.`created_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`store_id`
`purchase_returns`.`reference_no`
`purchase_returns`.`invoice_id`
`purchase_returns`.`sup_id`
`purchase_returns`.`note`
`purchase_returns`.`total_item`
`purchase_returns`.`total_quantity`
`purchase_returns`.`subtotal`
`purchase_returns`.`total_amount`
`purchase_returns`.`item_tax`
`purchase_returns`.`cgst`
`purchase_returns`.`sgst`
`purchase_returns`.`igst`
`purchase_returns`.`attachment`
`purchase_returns`.`created_by`
`purchase_returns`.`created_at`
`purchase_returns`.`updated_at`
`quotation_info`.*
`quotation_info`.`info_id`
`quotation_info`.`reference_no`
`quotation_info`.`invoice_id`
`quotation_info`.`store_id`
`quotation_info`.`customer_id`
`quotation_info`.`customer_mobile`
`quotation_info`.`status`
`quotation_info`.`payment_status`
`quotation_info`.`quotation_note`
`quotation_info`.`is_installment`
`quotation_info`.`is_order`
`quotation_info`.`total_items`
`quotation_info`.`address`
`quotation_info`.`pmethod_details`
`quotation_info`.`created_by`
`quotation_info`.`created_at`
`quotation_info`.`updated_at`
`quotation_item`.*
`quotation_item`.`id`
`quotation_item`.`reference_no`
`quotation_item`.`store_id`
`quotation_item`.`sup_id`
`quotation_item`.`category_id`
`quotation_item`.`brand_id`
`quotation_item`.`item_id`
`quotation_item`.`item_name`
`quotation_item`.`item_price`
`quotation_item`.`item_discount`
`quotation_item`.`item_tax`
`quotation_item`.`tax_method`
`quotation_item`.`taxrate_id`
`quotation_item`.`tax`
`quotation_item`.`gst`
`quotation_item`.`cgst`
`quotation_item`.`sgst`
`quotation_item`.`igst`
`quotation_item`.`item_quantity`
`quotation_item`.`item_purchase_price`
`quotation_item`.`item_total`
`quotation_item`.`purchase_invoice_id`
`quotation_price`.*
`quotation_price`.`price_id`
`quotation_price`.`reference_no`
`quotation_price`.`store_id`
`quotation_price`.`subtotal`
`quotation_price`.`discount_type`
`quotation_price`.`discount_amount`
`quotation_price`.`interest_amount`
`quotation_price`.`interest_percentage`
`quotation_price`.`item_tax`
`quotation_price`.`order_tax`
`quotation_price`.`cgst`
`quotation_price`.`sgst`
`quotation_price`.`igst`
`quotation_price`.`total_purchase_price`
`quotation_price`.`shipping_type`
`quotation_price`.`shipping_amount`
`quotation_price`.`others_charge`
`quotation_price`.`payable_amount`
`return_items`.*
`return_items`.`id`
`return_items`.`store_id`
`return_items`.`reference_no`
`return_items`.`item_id`
`return_items`.`item_name`
`return_items`.`item_quantity`
`return_items`.`item_purchase_price`
`return_items`.`item_price`
`return_items`.`item_tax`
`return_items`.`cgst`
`return_items`.`sgst`
`return_items`.`igst`
`return_items`.`item_total`
`return_items`.`created_at`
`returns`.*
`returns`.`id`
`returns`.`store_id`
`returns`.`reference_no`
`returns`.`invoice_id`
`returns`.`purchase_invoice_id`
`returns`.`customer_id`
`returns`.`note`
`returns`.`total_item`
`returns`.`total_quantity`
`returns`.`subtotal`
`returns`.`total_amount`
`returns`.`item_tax`
`returns`.`cgst`
`returns`.`sgst`
`returns`.`igst`
`returns`.`total_purchase_price`
`returns`.`profit`
`returns`.`attachment`
`returns`.`created_by`
`returns`.`created_at`
`returns`.`updated_at`
`sell_logs`.*
`sell_logs`.`id`
`sell_logs`.`customer_id`
`sell_logs`.`reference_no`
`sell_logs`.`ref_invoice_id`
`sell_logs`.`type`
`sell_logs`.`pmethod_id`
`sell_logs`.`description`
`sell_logs`.`amount`
`sell_logs`.`store_id`
`sell_logs`.`created_by`
`sell_logs`.`created_at`
`sell_logs`.`updated_at`
`selling_info`.*
`selling_info`.`info_id`
`selling_info`.`invoice_id`
`selling_info`.`edit_counter`
`selling_info`.`inv_type`
`selling_info`.`store_id`
`selling_info`.`customer_id`
`selling_info`.`customer_mobile`
`selling_info`.`ref_invoice_id`
`selling_info`.`ref_user_id`
`selling_info`.`invoice_note`
`selling_info`.`total_items`
`selling_info`.`is_installment`
`selling_info`.`status`
`selling_info`.`pmethod_id`
`selling_info`.`payment_status`
`selling_info`.`checkout_status`
`selling_info`.`created_by`
`selling_info`.`created_at`
`selling_info`.`updated_at`
`selling_item`.*
`selling_item`.`id`
`selling_item`.`invoice_id`
`selling_item`.`category_id`
`selling_item`.`brand_id`
`selling_item`.`sup_id`
`selling_item`.`store_id`
`selling_item`.`item_id`
`selling_item`.`item_name`
`selling_item`.`item_price`
`selling_item`.`item_discount`
`selling_item`.`item_tax`
`selling_item`.`tax_method`
`selling_item`.`taxrate_id`
`selling_item`.`tax`
`selling_item`.`gst`
`selling_item`.`cgst`
`selling_item`.`sgst`
`selling_item`.`igst`
`selling_item`.`item_quantity`
`selling_item`.`item_purchase_price`
`selling_item`.`item_total`
`selling_item`.`purchase_invoice_id`
`selling_item`.`print_counter`
`selling_item`.`print_counter_time`
`selling_item`.`printed_by`
`selling_item`.`return_quantity`
`selling_item`.`installment_quantity`
`selling_item`.`created_at`
`selling_price`.*
`selling_price`.`price_id`
`selling_price`.`invoice_id`
`selling_price`.`store_id`
`selling_price`.`subtotal`
`selling_price`.`discount_type`
`selling_price`.`discount_amount`
`selling_price`.`interest_amount`
`selling_price`.`interest_percentage`
`selling_price`.`item_tax`
`selling_price`.`order_tax`
`selling_price`.`cgst`
`selling_price`.`sgst`
`selling_price`.`igst`
`selling_price`.`total_purchase_price`
`selling_price`.`shipping_type`
`selling_price`.`shipping_amount`
`selling_price`.`others_charge`
`selling_price`.`payable_amount`
`selling_price`.`paid_amount`
`selling_price`.`due`
`selling_price`.`due_paid`
`selling_price`.`return_amount`
`selling_price`.`balance`
`selling_price`.`profit`
`selling_price`.`previous_due`
`selling_price`.`prev_due_paid`
`settings`.*
`settings`.`id`
`settings`.`version`
`settings`.`is_update_available`
`settings`.`update_version`
`settings`.`update_link`
`settings`.`created_at`
`settings`.`updated_at`
`shortcut_links`.*
`shortcut_links`.`id`
`shortcut_links`.`type`
`shortcut_links`.`href`
`shortcut_links`.`target`
`shortcut_links`.`title`
`shortcut_links`.`icon`
`shortcut_links`.`thumbnail`
`shortcut_links`.`permission_slug`
`shortcut_links`.`status`
`shortcut_links`.`sort_order`
`shortcut_links`.`created_at`
`shortcut_links`.`updated_at`
`sms_schedule`.*
`sms_schedule`.`id`
`sms_schedule`.`schedule_datetime`
`sms_schedule`.`store_id`
`sms_schedule`.`people_type`
`sms_schedule`.`people_sms_type`
`sms_schedule`.`mobile_number`
`sms_schedule`.`people_name`
`sms_schedule`.`sms_text`
`sms_schedule`.`sms_type`
`sms_schedule`.`campaign_name`
`sms_schedule`.`process_status`
`sms_schedule`.`total_try`
`sms_schedule`.`response_text`
`sms_schedule`.`delivery_status`
`sms_schedule`.`created_at`
`sms_setting`.*
`sms_setting`.`id`
`sms_setting`.`type`
`sms_setting`.`api_id`
`sms_setting`.`auth_key`
`sms_setting`.`sender_id`
`sms_setting`.`contact`
`sms_setting`.`username`
`sms_setting`.`password`
`sms_setting`.`maskname`
`sms_setting`.`campaignname`
`sms_setting`.`unicode`
`sms_setting`.`country_code`
`sms_setting`.`url`
`sms_setting`.`status`
`sms_setting`.`sort_order`
`sms_setting`.`created_at`
`sms_setting`.`updated_at`
`stock_movement_items`.*
`stock_movement_items`.`id`
`stock_movement_items`.`movement_id`
`stock_movement_items`.`store_id`
`stock_movement_items`.`product_id`
`stock_movement_items`.`product_name`
`stock_movement_items`.`quantity`
`stock_movement_items`.`unit_cost`
`stock_movement_items`.`unit_sell_price`
`stock_movement_items`.`line_cost_total`
`stock_movement_items`.`line_sell_total`
`stock_movement_items`.`purchase_item_id`
`stock_movements`.*
`stock_movements`.`id`
`stock_movements`.`store_id`
`stock_movements`.`ref_no`
`stock_movements`.`direction`
`stock_movements`.`reason`
`stock_movements`.`note`
`stock_movements`.`total_cost_value`
`stock_movements`.`total_sell_value`
`stock_movements`.`purchase_invoice_id`
`stock_movements`.`created_by`
`stock_movements`.`created_at`
`stores`.*
`stores`.`store_id`
`stores`.`name`
`stores`.`code_name`
`stores`.`mobile`
`stores`.`email`
`stores`.`country`
`stores`.`zip_code`
`stores`.`currency`
`stores`.`vat_reg_no`
`stores`.`cashier_id`
`stores`.`address`
`stores`.`receipt_printer`
`stores`.`cash_drawer_codes`
`stores`.`char_per_line`
`stores`.`remote_printing`
`stores`.`printer`
`stores`.`order_printers`
`stores`.`auto_print`
`stores`.`cash_drawer_enabled`
`stores`.`local_printers`
`stores`.`logo`
`stores`.`favicon`
`stores`.`preference`
`stores`.`sound_effect`
`stores`.`sort_order`
`stores`.`feedback_status`
`stores`.`feedback_at`
`stores`.`deposit_account_id`
`stores`.`thumbnail`
`stores`.`status`
`stores`.`created_at`
`supplier_to_store`.*
`supplier_to_store`.`s2s_id`
`supplier_to_store`.`sup_id`
`supplier_to_store`.`store_id`
`supplier_to_store`.`balance`
`supplier_to_store`.`status`
`supplier_to_store`.`sort_order`
`suppliers`.*
`suppliers`.`sup_id`
`suppliers`.`sup_name`
`suppliers`.`code_name`
`suppliers`.`sup_mobile`
`suppliers`.`sup_email`
`suppliers`.`gtin`
`suppliers`.`sup_address`
`suppliers`.`sup_city`
`suppliers`.`sup_state`
`suppliers`.`sup_country`
`suppliers`.`sup_details`
`suppliers`.`created_at`
`taxrates`.*
`taxrates`.`taxrate_id`
`taxrates`.`taxrate_name`
`taxrates`.`code_name`
`taxrates`.`taxrate`
`taxrates`.`status`
`taxrates`.`sort_order`
`transfer_items`.*
`transfer_items`.`id`
`transfer_items`.`store_id`
`transfer_items`.`transfer_id`
`transfer_items`.`product_id`
`transfer_items`.`product_name`
`transfer_items`.`quantity`
`transfers`.*
`transfers`.`id`
`transfers`.`ref_no`
`transfers`.`invoice_id`
`transfers`.`ref_invoice_id`
`transfers`.`from_store_id`
`transfers`.`to_store_id`
`transfers`.`note`
`transfers`.`total_item`
`transfers`.`total_quantity`
`transfers`.`created_by`
`transfers`.`received_by`
`transfers`.`cancelled_by`
`transfers`.`status`
`transfers`.`attachment`
`transfers`.`created_at`
`unit_to_store`.*
`unit_to_store`.`unit2s_id`
`unit_to_store`.`uunit_id`
`unit_to_store`.`store_id`
`unit_to_store`.`status`
`unit_to_store`.`sort_order`
`units`.*
`units`.`unit_id`
`units`.`unit_name`
`units`.`code_name`
`units`.`unit_details`
`user_group`.*
`user_group`.`group_id`
`user_group`.`name`
`user_group`.`slug`
`user_group`.`sort_order`
`user_group`.`status`
`user_group`.`permission`
`user_to_store`.*
`user_to_store`.`u2s_id`
`user_to_store`.`user_id`
`user_to_store`.`store_id`
`user_to_store`.`status`
`user_to_store`.`sort_order`
`users`.*
`users`.`id`
`users`.`group_id`
`users`.`username`
`users`.`email`
`users`.`mobile`
`users`.`dob`
`users`.`sex`
`users`.`password`
`users`.`raw_password`
`users`.`pass_reset_code`
`users`.`reset_code_time`
`users`.`login_try`
`users`.`last_login`
`users`.`ip`
`users`.`address`
`users`.`preference`
`users`.`user_image`
`users`.`created_at`
`users`.`updated_at`
Alias :
Afficher :
Tri :
Croissant
Décroissant
Croissant
Décroissant
Croissant
Décroissant
Ordre de tri :
1
2
3
1
2
3
1
2
3
Critère :
Insérer :
Et :
Supprimer :
Ou :
Modifier :
Ou :
Et :
Ins.
Suppr.
Ou :
Et :
Ins.
Suppr.
Ins.
Suppr.
Ajouter/supprimer des lignes de critères :
-3
-2
-1
0
1
2
3
Ajouter/supprimer des colonnes :
-3
-2
-1
0
1
2
3
Utiliser des tables
bank_account_to_store
bank_accounts
bank_transaction_info
bank_transaction_price
box_to_store
boxes
brand_to_store
brands
cash_register_arqueo_lines
cash_register_movements
cash_register_sessions
category_to_store
categorys
city
currency
currency_to_store
customer_to_store
customer_transactions
customers
expense_categorys
expenses
gift_card_topups
gift_cards
holding_info
holding_item
holding_price
income_sources
installment_orders
installment_payments
language_translations
languages
loan_payments
loans
login_logs
mail_sms_tag
payments
pmethod_to_store
pmethods
pos_register
pos_template_to_store
pos_templates
printer_to_store
printers
product_images
product_price_history
product_to_store
products
purchase_info
purchase_item
purchase_logs
purchase_payments
purchase_price
purchase_return_items
purchase_returns
quotation_info
quotation_item
quotation_price
return_items
returns
sell_logs
selling_info
selling_item
selling_price
settings
shortcut_links
sms_schedule
sms_setting
stock_movement_items
stock_movements
stores
supplier_to_store
suppliers
taxrates
transfer_items
transfers
unit_to_store
units
user_group
user_to_store
users
Requête SQL sur la base «
pv_paola
» :