* id description minimum_charge percentage

* SysPK_waterrates class_id code minimum_consumption maximum_consumption rate_per_cubic size_id

* Applicant_No application_date sequence_no acct_no zone_no book_id person_code brgy_id purok house_number street village_district city province route_no phone_number meter_id meter_number type class_id classification reading_sched meter_type discount sen_cit payment_order_id image mo_id date_stat_active Address customer_name

* book_id book_desc

* con_type_id class_type con_type_desc short_desc type category

* zone_id zone_num brgy_id book

* book_code description username timestamp

* rec_id ref_desc

* id rec_id brand_id size_id description prefix serial_no active cuid muid created

* rec_id ref_code ref_desc

* id reader_id readername meter_no reading

* id type status form_id

* signatory_id form_id setupType_id employee_id priority_no location title_id savedate status sig_display_name_id prefix suffix position

* id type

* comp_setup comp_desc

* id app_no amount trans_date no_days t_type

* id class_id Zone/Book Amount trans_date no_days t_type

* id description income_acc_id income_acc_code income_acc_name coa_id

* id particular debit_accnt_id credit_accnt_id oth_charges type status paid_accnit

* id desc min_days max_days

* id dept area plumber

* bam_id bill_id bam_no bam_date accnt_id acct_no account_type bill_date emp_meter_reader explnation date_saved pay_status status prepared_by cancelled_by cancelled_date posted_by posted_date JID bam_amount oth_credit with_bill bill_amount is_new_rate

* bam_id bill_id bam_no bam_date accnt_id acct_no account_type bill_date emp_meter_reader explnation date_saved pay_status status prepared_by cancelled_by cancelled_date posted_by posted_date JID bam_amount oth_credit with_bill bill_amount

* id bam_id particular_id ref_id original should_be adjusted coa_id accnt_id amount dr_cr particular change_class class_id date_saved trans_type payment_status

* rec_id applicant_no original_accnt change_accnt_no from_class_id to_class_id change_class_date date_save

* id application_no acct_no meter_from meter_idfrom from_brand current_reading previous_reading cubic_used prev_date_installed meter_to meter_idto to_brand installation_date initial_reading installed_by remarks bill_id date_save type mo_id

* id app_id account_no comp_id complaint_desc date_billed timestamp Status

* complaint_id complaint_desc desc_work_id

* Applicant_No application_date sequence_no acct_no zone_no book_id person_code brgy_id purok house_number street village_district district city province route_no phone_number meter_id lib_mter_id meter_number meter_size type class_id classification reading_sched meter_type discount sen_cit payment_order_id image mo_id date_stat_active timestamp type_applied include_pnalty status

* id applicant_no acct_no employed employer emp_address emp_status annual_sal spouse other_income other_spec annual_inc no_house_member no_of_fam con_type con_size tapping_desc service_con_before when_scb legal_owner who_own willing_for_con desired_con other_desired bday age civil_stat phone_number status

* meter_id applicant_no acct_no customer_id serial_no meter_number meter_size installation_date inspection_date installed_by inspected_by OR_number service_status status meter_status meter_remarks barangay_address addressID OR_date customer_description brgy_id or_amount date_disconnected time_disconnected disconnected_by classification subName brand first_meter_reading last_meter_reading remarks re_connect date_re_connect transferred date_transferred timestamp

* customer_id person_profile_id classification customer_name timestatmp

* desc_work_id work_desc trans_type

* id applicant_no emp_number cum_benefit amount remarks status payroll_period to_deduct time_stamp

* gd_id applicant_no account_id guarantee_deposit gd_ordate gd_ornumber status

* gd_id_detail gd_id account_desc amount

* inspector_id pp_person_code inspector_name date_saved

* mo_id applicant_no person_id type complainant address assigned_from remarks tran_type posted pay_order_id status

* mo_detail_id mo_id mo_no complaint action_taken date_of_complaint plumber date_assigned date_accomplished time_started time_finished remarks serial_no serial_id brand reading last_reading estimated_cost status assigned_to foreman_remarks area_id ref error late time_late save_date

* offset_id ref_no applicant_no guarantee_dep arears guarantee_deposit_bal offsetted_amount trans_date inc_accont_id date_stamp offset_stat prep_by JID

* id offset_id account_id particular amount

* id offset_id account_id particular amount

* other_charges_id ref bill_no applicant_no coa_id income_account_code income_account_description target_month year payable_in_months charge_amount adjustment adj_status date date_stamp status remarks payment_date or_id JID cap prep_by cancelled_by group_id

* other_charges_id ref bill_no applicant_no coa_id income_account_code income_account_description target_month year payable_in_months charge_amount adjustment adj_status date date_stamp status remarks payment_date or_id JID cap prep_by cancelled_by group_id

* other_charges_id ref bill_no applicant_no coa_id income_account_code income_account_description target_month year payable_in_months charge_amount date date_stamp status remarks payment_date or_id JID cap prep_by cancelled_by group_id

* id jid emp_id account_id amount date_trans pep_by time_stamp status

* id main_id jid app_no bill_no coa_id amount trans_date type tmstamp

* payment_order_id reference_no applicant_no person_id type total prepared_by date remarks pay_remarks or_id date_paid date_stamp cap GID JID manual_pay

* detail id payment_order_id account_id amount direct

* id app_id bill_no no_months service_fee service_charge penalty bill_month trans_date timestamp prep_by

* penalty_id penalty_desc penalty_charge

* id ratescale_desc_id ratescale_desc plumber target date_from date_to

* id emp_id person_id plumber_name

* promissory_id reference_no applicant_no date date_tobe_paid approved_by status bill_no arrears

* ratingscale_id minimum_rate maximum_rate score rate_desc

* rec_id person_id applicant_no type address initial_reading balance brand serial_id serial reconnected_date reconnected_by tmestamp

* sen_cit_id app_no acct_no dis_percentage consumer_id date_applied date_expire approved approved_by status osca_id_no birthdate remarks address

* dtl_id sen_cit_id app_no acct_no dis_percentage consumer_id date_applied date_expire approved approved_by status osca_id_no birthdate remarks address

* transfer_id applicant_no_from applicant_no_to transferred_from transferred_to transferred_date from_type to_type

* id desc code type legend comment

* bill_number main_id cust_bill_number application_no acct_no customer_id meter_id meter_number meter_reader_id guarantee_deposit advance_amount bill_from bill_to billing_date due_date prev_consumption present_consumption ave_consumption prev_meter_reading present_meter_reading cut_off_cum cubic_meter_consumed last_payment_date basicCharge total total_unpaid_amount adjustment adj_status remarks pay_remarks b_or_id b_or_number b_or_date b_or_amount entry_status JID coa_id date_saved exp_id explanation penalty_date penalty_stat cancel_remarks bill_type sen_cit adj_type adj_reading

* id zone_id book_id brgy_id meter_reader_id bill_month reding_sche date_save

* id main_id app_no bill_number read bill_status date_save

* id acct_no sequence_no consumer_name address

select table cto_water_applicant_classification cto_water_rates jay_list_consumer_view lgu_book lgu_consumer_type lgu_zone lib_books lib_brand lib_meters lib_sizes reading_migration setup_formtype setup_signatory setup_signatorytype tbl_restrict_print temp_tbl_aging_account temp_tbl_aging_account_summary ww_account_setup ww_adjustments_setup ww_aging_no_days ww_area_setup ww_billing_adjustment ww_billing_adjustment_admin_tool ww_billing_adjustment_detail ww_change_class ww_change_meter ww_complaint_billing ww_complaint_setup ww_customer_application ww_customer_application_details ww_customer_meter_details ww_customer_profile ww_desc_work ww_employee_withbenefit ww_guaranty_deposit ww_guaranty_deposit_details ww_inspectors ww_maintenance_order ww_maintenance_order_details ww_offset ww_offset_details ww_offset_details_admin_tool ww_other_charges ww_other_charges_admin_tool ww_other_charges_temp ww_payments_employee ww_payment_employee_dtl ww_payment_order ww_payment_order_detail ww_penalty_list ww_penalty_setup ww_plumberaccomplishmenttarget ww_plumbersetup ww_promissory ww_rating_scale_setup ww_reconnection ww_senior_citizen_discount ww_senior_citizen_discount_logs ww_transfer ww_type ww_water_billing ww_water_billing_assgn_reader ww_water_billing_assgn_reader_dtl ww_ww_cust_list_old . 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 cto_water_applicant_classification cto_water_rates jay_list_consumer_view lgu_book lgu_consumer_type lgu_zone lib_books lib_brand lib_meters lib_sizes reading_migration setup_formtype setup_signatory setup_signatorytype tbl_restrict_print temp_tbl_aging_account temp_tbl_aging_account_summary ww_account_setup ww_adjustments_setup ww_aging_no_days ww_area_setup ww_billing_adjustment ww_billing_adjustment_admin_tool ww_billing_adjustment_detail ww_change_class ww_change_meter ww_complaint_billing ww_complaint_setup ww_customer_application ww_customer_application_details ww_customer_meter_details ww_customer_profile ww_desc_work ww_employee_withbenefit ww_guaranty_deposit ww_guaranty_deposit_details ww_inspectors ww_maintenance_order ww_maintenance_order_details ww_offset ww_offset_details ww_offset_details_admin_tool ww_other_charges ww_other_charges_admin_tool ww_other_charges_temp ww_payments_employee ww_payment_employee_dtl ww_payment_order ww_payment_order_detail ww_penalty_list ww_penalty_setup ww_plumberaccomplishmenttarget ww_plumbersetup ww_promissory ww_rating_scale_setup ww_reconnection ww_senior_citizen_discount ww_senior_citizen_discount_logs ww_transfer ww_type ww_water_billing ww_water_billing_assgn_reader ww_water_billing_assgn_reader_dtl ww_ww_cust_list_old .	select column