* id company_name company_name_en tax_id branch address phone fax email website logo bank_name bank_account_name bank_account_no created_at updated_at signer_name signer_title

* id customer_code customer_type name tax_id branch address phone email contact_name note active created_at updated_at

* id delivery_no delivery_date customer_id quotation_id subject note status created_by created_at updated_at

* id delivery_id product_id product_code product_name description unit quantity sort_order

* id invoice_no invoice_date due_date customer_id quotation_id delivery_id subject note subtotal discount vat_rate vat_amount grand_total paid_amount status created_by created_at updated_at payment_status receipt_id paid_at

* id invoice_id product_id product_code product_name description unit quantity unit_price discount amount sort_order

* id payment_no payment_date invoice_id customer_id amount payment_method bank_name reference_no note created_by created_at

* id product_code name description image unit price vat_rate active created_at updated_at

* id quotation_no quotation_date valid_until customer_id subject note subtotal discount vat_rate vat_amount grand_total status created_by created_at updated_at

* id quotation_id product_id product_code product_name description unit quantity unit_price discount amount sort_order

* id receipt_no receipt_date customer_id invoice_id payment_id amount note created_by created_at subtotal discount vat_rate vat_amount grand_total paid_amount payment_method payment_reference status

* id receipt_id product_code product_name description unit quantity unit_price amount sort_order

* user_id username password name role created_at

select table company_settings customers deliveries delivery_items invoices invoice_items payments products quotations quotation_items receipts receipt_items users . 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 company_settings customers deliveries delivery_items invoices invoice_items payments products quotations quotation_items receipts receipt_items users .	select column