* id receiving_id po_id bo_code supplier_id amount discount_perc discount tax_perc tax remarks status date_created date_updated

* bo_id item_id quantity price unit total

* id name address cperson contact status date_created date_updated tpin

* id customer_id invoice_date invoice_number smart_invoice payment_mode invoice_amount amount_paid type date_created date_updated

* id name description supplier_id cost status date_created date_updated item_code

* id user_id token expiry used created_at

* po_id item_id quantity price unit total

* id po_code supplier_id amount discount_perc discount tax_perc tax remarks status date_created date_updated

* id po_code supplier_id amount discount_perc discount tax_perc tax remarks status date_created date_updated

* id quotation_code smart_invoice client_id subtotal amount total_discount tax remarks stock_ids type tpin date_created date_updated phone

* id item_id quantity unit price total type date_created discount item_code

* id form_id from_order amount discount_perc discount tax_perc tax stock_ids remarks date_created date_updated

* id return_code supplier_id amount remarks stock_ids date_created date_updated item_code_input

* id sales_code smart_invoice client_id subtotal amount total_discount tax remarks stock_ids type tpin date_created date_updated item_code_input phone invoice_date quotation_number

* id return_code customer_id amount remarks stock_ids date_created date_updated item_code_input type tpin smart_invoice

* id sale_id item_id quantity unit price discount total

* id item_id quantity unit price total type date_created discount item_code

* id name address cperson contact status date_created date_updated tpin

* id supplier_id invoice_date invoice_number payment_mode invoice_amount amount_paid type date_created date_updated tpin date_paid cheque_number remarks

* id meta_field meta_value postal_address phone email bank_details acc branch_code sort_code swift_code

* id firstname middlename lastname username password contact email avatar last_login type date_added date_updated code reset_token token_expiry

* user_id meta_field meta_value date_created

select table back_order_list bo_items customer_list customer_transactions item_list password_resets po_items purchase_list purchase_order_list quotation_list quotation_stock_list receiving_list return_list sales_list sales_return_list sales_stock_list stock_list supplier_list supplier_transactions system_info users user_meta . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table back_order_list bo_items customer_list customer_transactions item_list password_resets po_items purchase_list purchase_order_list quotation_list quotation_stock_list receiving_list return_list sales_list sales_return_list sales_stock_list stock_list supplier_list supplier_transactions system_info users user_meta .	select column