* id account_no name initial_balance total_balance note is_default is_active created_at updated_at

* id reference_no warehouse_id document total_qty item note created_at updated_at

* id date employee_id user_id checkin checkout status note created_at updated_at

* id name image company_name vat_number email phone_number address city state postal_code country is_active created_at updated_at

* id title image is_active created_at updated_at

* id cash_in_hand user_id warehouse_id status created_at updated_at

* id name image parent_id is_active created_at updated_at

* id code type amount minimum_amount quantity used expired_date user_id is_active created_at updated_at

* id customer_group_id name company_name email phone_number tax_no address city state postal_code country deposit expense is_active created_at updated_at

* id name percentage is_active created_at updated_at

* id reference_no sale_id user_id address delivered_by recieved_by file note status created_at updated_at

* id name is_active created_at updated_at

* id amount customer_id user_id note created_at updated_at

* id name email phone_number department_id user_id image address city country is_active created_at updated_at

* id reference_no expense_category_id warehouse_id account_id user_id cash_register_id amount note created_at updated_at

* id code name is_active created_at updated_at

* id connection queue payload exception failed_at

* id site_title site_logo currency staff_access date_format developed_by theme created_at updated_at currency_position

* id card_no amount expense customer_id user_id expired_date created_by is_active created_at updated_at

* id gift_card_id amount user_id created_at updated_at

* id user_id from_date to_date note is_approved created_at updated_at

* id checkin checkout created_at updated_at

* id code created_at updated_at

* id migration batch

* id reference_no from_account_id to_account_id amount created_at updated_at

* id type notifiable_type notifiable_id data read_at created_at updated_at

* email token created_at

* id payment_reference user_id purchase_id sale_id cash_register_id account_id amount change paying_method payment_note created_at updated_at

* id payment_id cheque_no created_at updated_at

* id payment_id customer_id customer_stripe_id charge_id created_at updated_at

* id payment_id gift_card_id created_at updated_at

* id payment_id transaction_id created_at updated_at

* id reference_no employee_id account_id user_id amount paying_method note created_at updated_at

* id name guard_name created_at updated_at

* id customer_id warehouse_id biller_id product_number keybord_active stripe_public_key stripe_secret_key created_at updated_at

* id name code type barcode_symbology brand_id category_id unit_id purchase_unit_id sale_unit_id cost price qty alert_quantity promotion promotion_price starting_date last_date tax_id tax_method image file is_variant featured product_list qty_list price_list product_details is_active created_at updated_at

* id adjustment_id product_id qty action created_at updated_at

* id purchase_id product_id variant_id qty recieved purchase_unit_id net_unit_cost discount tax_rate tax total created_at updated_at

* id quotation_id product_id variant_id qty sale_unit_id net_unit_price discount tax_rate tax total created_at updated_at

* id return_id product_id variant_id qty sale_unit_id net_unit_price discount tax_rate tax total created_at updated_at

* id sale_id product_id variant_id qty sale_unit_id net_unit_price discount tax_rate tax total created_at updated_at

* id transfer_id product_id variant_id qty purchase_unit_id net_unit_cost tax_rate tax total created_at updated_at

* id product_id variant_id position item_code additional_price qty created_at updated_at

* id product_id variant_id warehouse_id qty created_at updated_at

* id reference_no user_id warehouse_id supplier_id item total_qty total_discount total_tax total_cost order_tax_rate order_tax order_discount shipping_cost grand_total paid_amount status payment_status document note created_at updated_at

* id return_id product_id variant_id qty purchase_unit_id net_unit_cost discount tax_rate tax total created_at updated_at

* id reference_no user_id biller_id supplier_id customer_id warehouse_id item total_qty total_discount total_tax total_price order_tax_rate order_tax order_discount shipping_cost grand_total quotation_status document note created_at updated_at

* id reference_no user_id cash_register_id customer_id warehouse_id biller_id account_id item total_qty total_discount total_tax total_price order_tax_rate order_tax grand_total document return_note staff_note created_at updated_at

* id reference_no supplier_id warehouse_id user_id account_id item total_qty total_discount total_tax total_cost order_tax_rate order_tax grand_total document return_note staff_note created_at updated_at

* id name description guard_name is_active created_at updated_at

* permission_id role_id

* id reference_no user_id cash_register_id customer_id warehouse_id biller_id item total_qty total_discount total_tax total_price grand_total order_tax_rate order_tax order_discount coupon_id coupon_discount shipping_cost sale_status payment_status document paid_amount sale_note staff_note created_at updated_at

* id reference_no warehouse_id category_id brand_id user_id type initial_file final_file note is_adjusted created_at updated_at

* id name image company_name vat_number email phone_number address city state postal_code country is_active created_at updated_at

* id name rate is_active created_at updated_at

* id reference_no user_id status from_warehouse_id to_warehouse_id item total_qty total_tax total_cost shipping_cost grand_total document note created_at updated_at

* id unit_code unit_name base_unit operator operation_value is_active created_at updated_at

* id name email password remember_token phone company_name role_id biller_id warehouse_id is_active is_deleted created_at updated_at

* id name created_at updated_at

* id name phone email address is_active created_at updated_at

select table accounts adjustments attendances billers brands cash_registers categories coupons customers customer_groups deliveries departments deposits employees expenses expense_categories failed_jobs general_settings gift_cards gift_card_recharges holidays hrm_settings languages migrations money_transfers notifications password_resets payments payment_with_cheque payment_with_credit_card payment_with_gift_card payment_with_paypal payrolls permissions pos_setting products product_adjustments product_purchases product_quotation product_returns product_sales product_transfer product_variants product_warehouse purchases purchase_product_return quotations returns return_purchases roles role_has_permissions sales stock_counts suppliers taxes transfers units users variants warehouses . 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 accounts adjustments attendances billers brands cash_registers categories coupons customers customer_groups deliveries departments deposits employees expenses expense_categories failed_jobs general_settings gift_cards gift_card_recharges holidays hrm_settings languages migrations money_transfers notifications password_resets payments payment_with_cheque payment_with_credit_card payment_with_gift_card payment_with_paypal payrolls permissions pos_setting products product_adjustments product_purchases product_quotation product_returns product_sales product_transfer product_variants product_warehouse purchases purchase_product_return quotations returns return_purchases roles role_has_permissions sales stock_counts suppliers taxes transfers units users variants warehouses .	select column