* id account_name account_details initial_balance account_no contact_person phone_number opening_date url total_deposit total_withdraw total_transfer_from_other total_transfer_to_other created_at updated_at

* ba2s store_id account_id deposit withdraw transfer_from_other transfer_to_other status sort_order

* info_id store_id transaction_type is_substract is_hide account_id source_id exp_category_id ref_no invoice_id title details from_account_id status image created_by created_at updated_at

* price_id store_id info_id ref_no amount

* box_id box_name code_name box_details

* id box_id store_id status sort_order

* brand_id brand_name code_name brand_details brand_image created_at updated_at

* b2s_id brand_id store_id status sort_order

* category_id category_name category_slug parent_id category_details category_image created_at updated_at

* c2s_id ccategory_id store_id status sort_order

* id id_department name code

* currency_id title code symbol_left symbol_right decimal_place value created_at

* ca2s_id currency_id store_id status sort_order

* customer_id customer_name customer_email customer_mobile customer_address dob customer_sex customer_age gtin customer_city customer_state customer_country is_giftcard password raw_password created_at updated_at

* c2s_id customer_id store_id balance due status sort_order

* id type reference_no ref_invoice_id customer_id store_id pmethod_id notes amount balance created_by created_at updated_at

* id store_id reference_no category_id title amount returnable note attachment status created_by created_at updated_at

* category_id category_name category_slug parent_id category_details sell_return sell_delete loan_delete loan_payment giftcard_sell_delete topup_delete product_purchase stock_transfer due_paid status is_hide sort_order created_at updated_at

* id date card_no value customer_id customer balance expiry created_by

* id date card_id amount created_by

* info_id store_id order_title ref_no customer_id customer_mobile invoice_note total_items created_by created_at updated_at

* id ref_no store_id item_id category_id brand_id sup_id item_name item_price item_discount item_tax tax_method taxrate_id tax gst cgst sgst igst item_quantity item_total created_at

* price_id ref_no store_id subtotal discount_type discount_amount item_tax order_tax cgst sgst igst shipping_type shipping_amount others_charge payable_amount

* source_id source_name type source_slug parent_id source_details for_sell for_purchase_return for_due_collection for_loan for_giftcard_sell for_topup for_stock_transfer for_purchase_delete for_expense_delete profitable show_in_income status is_hide sort_order created_at updated_at

* id store_id invoice_id purchase_invoice_id duration interval_count installment_count interest_percentage interest_amount initial_amount payment_status last_installment_date installment_end_date created_at

* id store_id invoice_id payment_date pmethod_id created_by note capital interest payable paid due payment_status

* id name slug code

* id lang_id lang_key key_type lang_value

* loan_id ref_no loan_from title amount interest payable paid due details attachment status sort_order created_by created_at updated_at

* id lloan_id ref_no paid note created_by created_at updated_at

* id user_id username ip status created_at

* tag_id type tagname created_at

* id type is_profit is_hide store_id invoice_id reference_no pmethod_id transaction_id capital amount details attachment note total_paid pos_balance created_by created_at

* pmethod_id name code_name details created_at updated_at

* p2s_id ppmethod_id store_id status sort_order

* id store_id opening_balance closing_balance note status created_at updated_at

* template_id template_name template_content template_css created_at updated_at created_by

* pt2s store_id ttemplate_id is_active status sort_order

* printer_id title type profile char_per_line created_at

* p2s_id pprinter_id store_id path ip_address port status sort_order

* p_id p_type p_code hsn_code barcode_symbology p_name category_id unit_id p_image description

* image_id product_id url sort_order

* id product_id store_id purchase_price sell_price quantity_in_stock alert_quantity sup_id brand_id box_id taxrate_id tax_method preference e_date p_date status sort_order

* info_id invoice_id inv_type store_id sup_id total_item status total_sell purchase_note attachment is_visible payment_status checkout_status shipping_status created_by purchase_date created_at updated_at

* id invoice_id store_id item_id category_id brand_id item_name item_purchase_price item_selling_price item_quantity total_sell status item_total item_tax tax_method tax gst cgst sgst igst return_quantity installment_quantity

* id sup_id reference_no ref_invoice_id type pmethod_id description amount store_id created_by created_at updated_at

* id type is_hide store_id invoice_id reference_no pmethod_id transaction_id details attachment note amount total_paid balance created_by created_at

* price_id invoice_id store_id subtotal discount_type discount_amount shipping_type shipping_amount others_charge item_tax order_tax cgst sgst igst payable_amount paid_amount due_paid due return_amount balance

* id store_id reference_no invoice_id sup_id note total_item total_quantity subtotal total_amount item_tax cgst sgst igst attachment created_by created_at updated_at

* id store_id invoice_id item_id item_name item_quantity item_price item_tax cgst sgst igst item_total created_at

* info_id reference_no invoice_id store_id customer_id customer_mobile status payment_status quotation_note is_installment is_order total_items address pmethod_details created_by created_at updated_at

* id reference_no store_id sup_id category_id brand_id item_id item_name item_price item_discount item_tax tax_method taxrate_id tax gst cgst sgst igst item_quantity item_purchase_price item_total purchase_invoice_id

* price_id reference_no store_id subtotal discount_type discount_amount interest_amount interest_percentage item_tax order_tax cgst sgst igst total_purchase_price shipping_type shipping_amount others_charge payable_amount

* id store_id reference_no invoice_id purchase_invoice_id customer_id note total_item total_quantity subtotal total_amount item_tax cgst sgst igst total_purchase_price profit attachment created_by created_at updated_at

* id store_id reference_no item_id item_name item_quantity item_purchase_price item_price item_tax cgst sgst igst item_total created_at

* info_id invoice_id edit_counter inv_type store_id customer_id customer_mobile ref_invoice_id ref_user_id invoice_note total_items is_installment status pmethod_id payment_status checkout_status created_by created_at updated_at

* id invoice_id category_id brand_id sup_id store_id item_id item_name item_price item_discount item_tax tax_method taxrate_id tax gst cgst sgst igst item_quantity item_purchase_price item_total purchase_invoice_id print_counter print_counter_time printed_by return_quantity installment_quantity created_at

* price_id invoice_id store_id subtotal discount_type discount_amount interest_amount interest_percentage item_tax order_tax cgst sgst igst total_purchase_price shipping_type shipping_amount others_charge payable_amount paid_amount due due_paid return_amount balance profit previous_due prev_due_paid

* id customer_id reference_no ref_invoice_id type pmethod_id description amount store_id created_by created_at updated_at

* id version is_update_available update_version update_link created_at updated_at

* id type href target title icon thumbnail permission_slug status sort_order created_at updated_at

* id schedule_datetime store_id people_type people_sms_type mobile_number people_name sms_text sms_type campaign_name process_status total_try response_text delivery_status created_at

* id type api_id auth_key sender_id contact username password maskname campaignname unicode country_code url status sort_order created_at updated_at

* store_id name code_name mobile email country zip_code currency vat_reg_no cashier_id address receipt_printer cash_drawer_codes char_per_line remote_printing printer order_printers auto_print local_printers logo favicon preference sound_effect sort_order feedback_status feedback_at deposit_account_id thumbnail status created_at

* sup_id sup_name code_name sup_mobile sup_email gtin sup_address sup_city sup_state sup_country sup_details created_at

* s2s_id sup_id store_id balance status sort_order

* taxrate_id taxrate_name code_name taxrate status sort_order

* id ref_no invoice_id ref_invoice_id from_store_id to_store_id note total_item total_quantity created_by received_by cancelled_by status attachment created_at

* id store_id transfer_id product_id product_name quantity

* unit_id unit_name code_name unit_details

* unit2s_id uunit_id store_id status sort_order

* id group_id username email mobile dob sex password raw_password pass_reset_code reset_code_time login_try last_login ip address preference user_image created_at updated_at

* group_id name slug sort_order status permission

* u2s_id user_id store_id status sort_order

sélectionner une table bank_accounts bank_account_to_store bank_transaction_info bank_transaction_price boxes box_to_store brands brand_to_store categorys category_to_store city currency currency_to_store customers customer_to_store customer_transactions expenses expense_categorys gift_cards gift_card_topups holding_info holding_item holding_price income_sources installment_orders installment_payments languages language_translations loans loan_payments login_logs mail_sms_tag payments pmethods pmethod_to_store pos_register pos_templates pos_template_to_store printers printer_to_store products product_images product_to_store purchase_info purchase_item purchase_logs purchase_payments purchase_price purchase_returns purchase_return_items quotation_info quotation_item quotation_price returns return_items selling_info selling_item selling_price sell_logs settings shortcut_links sms_schedule sms_setting stores suppliers supplier_to_store taxrates transfers transfer_items units unit_to_store users user_group user_to_store . sélectionner une colonne
Afficher

critère

Tri	Croissant	Décroissant
Ajouter en	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Texte Autre colonne
	sélectionner une table bank_accounts bank_account_to_store bank_transaction_info bank_transaction_price boxes box_to_store brands brand_to_store categorys category_to_store city currency currency_to_store customers customer_to_store customer_transactions expenses expense_categorys gift_cards gift_card_topups holding_info holding_item holding_price income_sources installment_orders installment_payments languages language_translations loans loan_payments login_logs mail_sms_tag payments pmethods pmethod_to_store pos_register pos_templates pos_template_to_store printers printer_to_store products product_images product_to_store purchase_info purchase_item purchase_logs purchase_payments purchase_price purchase_returns purchase_return_items quotation_info quotation_item quotation_price returns return_items selling_info selling_item selling_price sell_logs settings shortcut_links sms_schedule sms_setting stores suppliers supplier_to_store taxrates transfers transfer_items units unit_to_store users user_group user_to_store .	sélectionner une colonne