Recent
`accounting`.`majorfund`
`el_laravue`.`migrations`
`qpsii_lguengineering`.`eceo_suspension_order`
`mysql`.`innodb_index_stats`
`accounting`.`doc_verbalmotion_dtls`
`accounting`.`cash_advance_request`
`accounting`.`doc_attendance`
`qpsii_lgusystem`.`brgy_entry_table`
`budget`.`remittance_beg`
`lgu_repository`.`tble_taxdec_shapefiles`
Favorites
There are no favorite tables.
New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance
performance_management
performance_schema
qpsii
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: qpsii_waterworks
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Column:
`cto_water_applicant_classification`.*
`cto_water_applicant_classification`.`id`
`cto_water_applicant_classification`.`description`
`cto_water_applicant_classification`.`minimum_charge`
`cto_water_applicant_classification`.`percentage`
`cto_water_rates`.*
`cto_water_rates`.`SysPK_waterrates`
`cto_water_rates`.`class_id`
`cto_water_rates`.`code`
`cto_water_rates`.`minimum_consumption`
`cto_water_rates`.`maximum_consumption`
`cto_water_rates`.`rate_per_cubic`
`cto_water_rates`.`size_id`
`jay_list_consumer_view`.*
`jay_list_consumer_view`.`Applicant_No`
`jay_list_consumer_view`.`application_date`
`jay_list_consumer_view`.`sequence_no`
`jay_list_consumer_view`.`acct_no`
`jay_list_consumer_view`.`zone_no`
`jay_list_consumer_view`.`book_id`
`jay_list_consumer_view`.`person_code`
`jay_list_consumer_view`.`brgy_id`
`jay_list_consumer_view`.`purok`
`jay_list_consumer_view`.`house_number`
`jay_list_consumer_view`.`street`
`jay_list_consumer_view`.`village_district`
`jay_list_consumer_view`.`city`
`jay_list_consumer_view`.`province`
`jay_list_consumer_view`.`route_no`
`jay_list_consumer_view`.`phone_number`
`jay_list_consumer_view`.`meter_id`
`jay_list_consumer_view`.`meter_number`
`jay_list_consumer_view`.`type`
`jay_list_consumer_view`.`class_id`
`jay_list_consumer_view`.`classification`
`jay_list_consumer_view`.`reading_sched`
`jay_list_consumer_view`.`meter_type`
`jay_list_consumer_view`.`discount`
`jay_list_consumer_view`.`sen_cit`
`jay_list_consumer_view`.`payment_order_id`
`jay_list_consumer_view`.`image`
`jay_list_consumer_view`.`mo_id`
`jay_list_consumer_view`.`date_stat_active`
`jay_list_consumer_view`.`Address`
`jay_list_consumer_view`.`customer_name`
`lgu_book`.*
`lgu_book`.`book_id`
`lgu_book`.`book_desc`
`lgu_consumer_type`.*
`lgu_consumer_type`.`con_type_id`
`lgu_consumer_type`.`class_type`
`lgu_consumer_type`.`con_type_desc`
`lgu_consumer_type`.`short_desc`
`lgu_consumer_type`.`type`
`lgu_consumer_type`.`category`
`lgu_zone`.*
`lgu_zone`.`zone_id`
`lgu_zone`.`zone_num`
`lgu_zone`.`brgy_id`
`lgu_zone`.`book`
`lib_books`.*
`lib_books`.`book_code`
`lib_books`.`description`
`lib_books`.`username`
`lib_books`.`timestamp`
`lib_brand`.*
`lib_brand`.`rec_id`
`lib_brand`.`ref_desc`
`lib_meters`.*
`lib_meters`.`id`
`lib_meters`.`rec_id`
`lib_meters`.`brand_id`
`lib_meters`.`size_id`
`lib_meters`.`description`
`lib_meters`.`prefix`
`lib_meters`.`serial_no`
`lib_meters`.`active`
`lib_meters`.`cuid`
`lib_meters`.`muid`
`lib_meters`.`created`
`lib_sizes`.*
`lib_sizes`.`rec_id`
`lib_sizes`.`ref_code`
`lib_sizes`.`ref_desc`
`reading_migration`.*
`reading_migration`.`id`
`reading_migration`.`reader_id`
`reading_migration`.`readername`
`reading_migration`.`meter_no`
`reading_migration`.`reading`
`setup_formtype`.*
`setup_formtype`.`id`
`setup_formtype`.`type`
`setup_formtype`.`status`
`setup_formtype`.`form_id`
`setup_signatory`.*
`setup_signatory`.`signatory_id`
`setup_signatory`.`form_id`
`setup_signatory`.`setupType_id`
`setup_signatory`.`employee_id`
`setup_signatory`.`priority_no`
`setup_signatory`.`location`
`setup_signatory`.`title_id`
`setup_signatory`.`savedate`
`setup_signatory`.`status`
`setup_signatory`.`sig_display_name_id`
`setup_signatory`.`prefix`
`setup_signatory`.`suffix`
`setup_signatory`.`position`
`setup_signatorytype`.*
`setup_signatorytype`.`id`
`setup_signatorytype`.`type`
`tbl_restrict_print`.*
`tbl_restrict_print`.`comp_setup`
`tbl_restrict_print`.`comp_desc`
`temp_tbl_aging_account`.*
`temp_tbl_aging_account`.`id`
`temp_tbl_aging_account`.`app_no`
`temp_tbl_aging_account`.`amount`
`temp_tbl_aging_account`.`trans_date`
`temp_tbl_aging_account`.`no_days`
`temp_tbl_aging_account`.`t_type`
`temp_tbl_aging_account_summary`.*
`temp_tbl_aging_account_summary`.`id`
`temp_tbl_aging_account_summary`.`class_id`
`temp_tbl_aging_account_summary`.`Zone/Book`
`temp_tbl_aging_account_summary`.`Amount`
`temp_tbl_aging_account_summary`.`trans_date`
`temp_tbl_aging_account_summary`.`no_days`
`temp_tbl_aging_account_summary`.`t_type`
`ww_account_setup`.*
`ww_account_setup`.`id`
`ww_account_setup`.`description`
`ww_account_setup`.`income_acc_id`
`ww_account_setup`.`income_acc_code`
`ww_account_setup`.`income_acc_name`
`ww_account_setup`.`coa_id`
`ww_adjustments_setup`.*
`ww_adjustments_setup`.`id`
`ww_adjustments_setup`.`particular`
`ww_adjustments_setup`.`debit_accnt_id`
`ww_adjustments_setup`.`credit_accnt_id`
`ww_adjustments_setup`.`oth_charges`
`ww_adjustments_setup`.`type`
`ww_adjustments_setup`.`status`
`ww_adjustments_setup`.`paid_accnit`
`ww_aging_no_days`.*
`ww_aging_no_days`.`id`
`ww_aging_no_days`.`desc`
`ww_aging_no_days`.`min_days`
`ww_aging_no_days`.`max_days`
`ww_area_setup`.*
`ww_area_setup`.`id`
`ww_area_setup`.`dept`
`ww_area_setup`.`area`
`ww_area_setup`.`plumber`
`ww_billing_adjustment`.*
`ww_billing_adjustment`.`bam_id`
`ww_billing_adjustment`.`bill_id`
`ww_billing_adjustment`.`bam_no`
`ww_billing_adjustment`.`bam_date`
`ww_billing_adjustment`.`accnt_id`
`ww_billing_adjustment`.`acct_no`
`ww_billing_adjustment`.`account_type`
`ww_billing_adjustment`.`bill_date`
`ww_billing_adjustment`.`emp_meter_reader`
`ww_billing_adjustment`.`explnation`
`ww_billing_adjustment`.`date_saved`
`ww_billing_adjustment`.`pay_status`
`ww_billing_adjustment`.`status`
`ww_billing_adjustment`.`prepared_by`
`ww_billing_adjustment`.`cancelled_by`
`ww_billing_adjustment`.`cancelled_date`
`ww_billing_adjustment`.`posted_by`
`ww_billing_adjustment`.`posted_date`
`ww_billing_adjustment`.`JID`
`ww_billing_adjustment`.`bam_amount`
`ww_billing_adjustment`.`oth_credit`
`ww_billing_adjustment`.`with_bill`
`ww_billing_adjustment`.`bill_amount`
`ww_billing_adjustment`.`is_new_rate`
`ww_billing_adjustment_admin_tool`.*
`ww_billing_adjustment_admin_tool`.`bam_id`
`ww_billing_adjustment_admin_tool`.`bill_id`
`ww_billing_adjustment_admin_tool`.`bam_no`
`ww_billing_adjustment_admin_tool`.`bam_date`
`ww_billing_adjustment_admin_tool`.`accnt_id`
`ww_billing_adjustment_admin_tool`.`acct_no`
`ww_billing_adjustment_admin_tool`.`account_type`
`ww_billing_adjustment_admin_tool`.`bill_date`
`ww_billing_adjustment_admin_tool`.`emp_meter_reader`
`ww_billing_adjustment_admin_tool`.`explnation`
`ww_billing_adjustment_admin_tool`.`date_saved`
`ww_billing_adjustment_admin_tool`.`pay_status`
`ww_billing_adjustment_admin_tool`.`status`
`ww_billing_adjustment_admin_tool`.`prepared_by`
`ww_billing_adjustment_admin_tool`.`cancelled_by`
`ww_billing_adjustment_admin_tool`.`cancelled_date`
`ww_billing_adjustment_admin_tool`.`posted_by`
`ww_billing_adjustment_admin_tool`.`posted_date`
`ww_billing_adjustment_admin_tool`.`JID`
`ww_billing_adjustment_admin_tool`.`bam_amount`
`ww_billing_adjustment_admin_tool`.`oth_credit`
`ww_billing_adjustment_admin_tool`.`with_bill`
`ww_billing_adjustment_admin_tool`.`bill_amount`
`ww_billing_adjustment_detail`.*
`ww_billing_adjustment_detail`.`id`
`ww_billing_adjustment_detail`.`bam_id`
`ww_billing_adjustment_detail`.`particular_id`
`ww_billing_adjustment_detail`.`ref_id`
`ww_billing_adjustment_detail`.`original`
`ww_billing_adjustment_detail`.`should_be`
`ww_billing_adjustment_detail`.`adjusted`
`ww_billing_adjustment_detail`.`coa_id`
`ww_billing_adjustment_detail`.`accnt_id`
`ww_billing_adjustment_detail`.`amount`
`ww_billing_adjustment_detail`.`dr_cr`
`ww_billing_adjustment_detail`.`particular`
`ww_billing_adjustment_detail`.`change_class`
`ww_billing_adjustment_detail`.`class_id`
`ww_billing_adjustment_detail`.`date_saved`
`ww_billing_adjustment_detail`.`trans_type`
`ww_billing_adjustment_detail`.`payment_status`
`ww_change_class`.*
`ww_change_class`.`rec_id`
`ww_change_class`.`applicant_no`
`ww_change_class`.`original_accnt`
`ww_change_class`.`change_accnt_no`
`ww_change_class`.`from_class_id`
`ww_change_class`.`to_class_id`
`ww_change_class`.`change_class_date`
`ww_change_class`.`date_save`
`ww_change_meter`.*
`ww_change_meter`.`id`
`ww_change_meter`.`application_no`
`ww_change_meter`.`acct_no`
`ww_change_meter`.`meter_from`
`ww_change_meter`.`meter_idfrom`
`ww_change_meter`.`from_brand`
`ww_change_meter`.`current_reading`
`ww_change_meter`.`previous_reading`
`ww_change_meter`.`cubic_used`
`ww_change_meter`.`prev_date_installed`
`ww_change_meter`.`meter_to`
`ww_change_meter`.`meter_idto`
`ww_change_meter`.`to_brand`
`ww_change_meter`.`installation_date`
`ww_change_meter`.`initial_reading`
`ww_change_meter`.`installed_by`
`ww_change_meter`.`remarks`
`ww_change_meter`.`bill_id`
`ww_change_meter`.`date_save`
`ww_change_meter`.`type`
`ww_change_meter`.`mo_id`
`ww_complaint_billing`.*
`ww_complaint_billing`.`id`
`ww_complaint_billing`.`app_id`
`ww_complaint_billing`.`account_no`
`ww_complaint_billing`.`comp_id`
`ww_complaint_billing`.`complaint_desc`
`ww_complaint_billing`.`date_billed`
`ww_complaint_billing`.`timestamp`
`ww_complaint_billing`.`Status`
`ww_complaint_setup`.*
`ww_complaint_setup`.`complaint_id`
`ww_complaint_setup`.`complaint_desc`
`ww_complaint_setup`.`desc_work_id`
`ww_customer_application`.*
`ww_customer_application`.`Applicant_No`
`ww_customer_application`.`application_date`
`ww_customer_application`.`sequence_no`
`ww_customer_application`.`acct_no`
`ww_customer_application`.`zone_no`
`ww_customer_application`.`book_id`
`ww_customer_application`.`person_code`
`ww_customer_application`.`brgy_id`
`ww_customer_application`.`purok`
`ww_customer_application`.`house_number`
`ww_customer_application`.`street`
`ww_customer_application`.`village_district`
`ww_customer_application`.`district`
`ww_customer_application`.`city`
`ww_customer_application`.`province`
`ww_customer_application`.`route_no`
`ww_customer_application`.`phone_number`
`ww_customer_application`.`meter_id`
`ww_customer_application`.`lib_mter_id`
`ww_customer_application`.`meter_number`
`ww_customer_application`.`meter_size`
`ww_customer_application`.`type`
`ww_customer_application`.`class_id`
`ww_customer_application`.`classification`
`ww_customer_application`.`reading_sched`
`ww_customer_application`.`meter_type`
`ww_customer_application`.`discount`
`ww_customer_application`.`sen_cit`
`ww_customer_application`.`payment_order_id`
`ww_customer_application`.`image`
`ww_customer_application`.`mo_id`
`ww_customer_application`.`date_stat_active`
`ww_customer_application`.`timestamp`
`ww_customer_application`.`type_applied`
`ww_customer_application`.`include_pnalty`
`ww_customer_application`.`status`
`ww_customer_application_details`.*
`ww_customer_application_details`.`id`
`ww_customer_application_details`.`applicant_no`
`ww_customer_application_details`.`acct_no`
`ww_customer_application_details`.`employed`
`ww_customer_application_details`.`employer`
`ww_customer_application_details`.`emp_address`
`ww_customer_application_details`.`emp_status`
`ww_customer_application_details`.`annual_sal`
`ww_customer_application_details`.`spouse`
`ww_customer_application_details`.`other_income`
`ww_customer_application_details`.`other_spec`
`ww_customer_application_details`.`annual_inc`
`ww_customer_application_details`.`no_house_member`
`ww_customer_application_details`.`no_of_fam`
`ww_customer_application_details`.`con_type`
`ww_customer_application_details`.`con_size`
`ww_customer_application_details`.`tapping_desc`
`ww_customer_application_details`.`service_con_before`
`ww_customer_application_details`.`when_scb`
`ww_customer_application_details`.`legal_owner`
`ww_customer_application_details`.`who_own`
`ww_customer_application_details`.`willing_for_con`
`ww_customer_application_details`.`desired_con`
`ww_customer_application_details`.`other_desired`
`ww_customer_application_details`.`bday`
`ww_customer_application_details`.`age`
`ww_customer_application_details`.`civil_stat`
`ww_customer_application_details`.`phone_number`
`ww_customer_application_details`.`status`
`ww_customer_meter_details`.*
`ww_customer_meter_details`.`meter_id`
`ww_customer_meter_details`.`applicant_no`
`ww_customer_meter_details`.`acct_no`
`ww_customer_meter_details`.`customer_id`
`ww_customer_meter_details`.`serial_no`
`ww_customer_meter_details`.`meter_number`
`ww_customer_meter_details`.`meter_size`
`ww_customer_meter_details`.`installation_date`
`ww_customer_meter_details`.`inspection_date`
`ww_customer_meter_details`.`installed_by`
`ww_customer_meter_details`.`inspected_by`
`ww_customer_meter_details`.`OR_number`
`ww_customer_meter_details`.`service_status`
`ww_customer_meter_details`.`status`
`ww_customer_meter_details`.`meter_status`
`ww_customer_meter_details`.`meter_remarks`
`ww_customer_meter_details`.`barangay_address`
`ww_customer_meter_details`.`addressID`
`ww_customer_meter_details`.`OR_date`
`ww_customer_meter_details`.`customer_description`
`ww_customer_meter_details`.`brgy_id`
`ww_customer_meter_details`.`or_amount`
`ww_customer_meter_details`.`date_disconnected`
`ww_customer_meter_details`.`time_disconnected`
`ww_customer_meter_details`.`disconnected_by`
`ww_customer_meter_details`.`classification`
`ww_customer_meter_details`.`subName`
`ww_customer_meter_details`.`brand`
`ww_customer_meter_details`.`first_meter_reading`
`ww_customer_meter_details`.`last_meter_reading`
`ww_customer_meter_details`.`remarks`
`ww_customer_meter_details`.`re_connect`
`ww_customer_meter_details`.`date_re_connect`
`ww_customer_meter_details`.`transferred`
`ww_customer_meter_details`.`date_transferred`
`ww_customer_meter_details`.`timestamp`
`ww_customer_profile`.*
`ww_customer_profile`.`customer_id`
`ww_customer_profile`.`person_profile_id`
`ww_customer_profile`.`classification`
`ww_customer_profile`.`customer_name`
`ww_customer_profile`.`timestatmp`
`ww_desc_work`.*
`ww_desc_work`.`desc_work_id`
`ww_desc_work`.`work_desc`
`ww_desc_work`.`trans_type`
`ww_employee_withbenefit`.*
`ww_employee_withbenefit`.`id`
`ww_employee_withbenefit`.`applicant_no`
`ww_employee_withbenefit`.`emp_number`
`ww_employee_withbenefit`.`cum_benefit`
`ww_employee_withbenefit`.`amount`
`ww_employee_withbenefit`.`remarks`
`ww_employee_withbenefit`.`status`
`ww_employee_withbenefit`.`payroll_period`
`ww_employee_withbenefit`.`to_deduct`
`ww_employee_withbenefit`.`time_stamp`
`ww_guaranty_deposit`.*
`ww_guaranty_deposit`.`gd_id`
`ww_guaranty_deposit`.`applicant_no`
`ww_guaranty_deposit`.`account_id`
`ww_guaranty_deposit`.`guarantee_deposit`
`ww_guaranty_deposit`.`gd_ordate`
`ww_guaranty_deposit`.`gd_ornumber`
`ww_guaranty_deposit`.`status`
`ww_guaranty_deposit_details`.*
`ww_guaranty_deposit_details`.`gd_id_detail`
`ww_guaranty_deposit_details`.`gd_id`
`ww_guaranty_deposit_details`.`account_desc`
`ww_guaranty_deposit_details`.`amount`
`ww_inspectors`.*
`ww_inspectors`.`inspector_id`
`ww_inspectors`.`pp_person_code`
`ww_inspectors`.`inspector_name`
`ww_inspectors`.`date_saved`
`ww_maintenance_order`.*
`ww_maintenance_order`.`mo_id`
`ww_maintenance_order`.`applicant_no`
`ww_maintenance_order`.`person_id`
`ww_maintenance_order`.`type`
`ww_maintenance_order`.`complainant`
`ww_maintenance_order`.`address`
`ww_maintenance_order`.`assigned_from`
`ww_maintenance_order`.`remarks`
`ww_maintenance_order`.`tran_type`
`ww_maintenance_order`.`posted`
`ww_maintenance_order`.`pay_order_id`
`ww_maintenance_order`.`status`
`ww_maintenance_order_details`.*
`ww_maintenance_order_details`.`mo_detail_id`
`ww_maintenance_order_details`.`mo_id`
`ww_maintenance_order_details`.`mo_no`
`ww_maintenance_order_details`.`complaint`
`ww_maintenance_order_details`.`action_taken`
`ww_maintenance_order_details`.`date_of_complaint`
`ww_maintenance_order_details`.`plumber`
`ww_maintenance_order_details`.`date_assigned`
`ww_maintenance_order_details`.`date_accomplished`
`ww_maintenance_order_details`.`time_started`
`ww_maintenance_order_details`.`time_finished`
`ww_maintenance_order_details`.`remarks`
`ww_maintenance_order_details`.`serial_no`
`ww_maintenance_order_details`.`serial_id`
`ww_maintenance_order_details`.`brand`
`ww_maintenance_order_details`.`reading`
`ww_maintenance_order_details`.`last_reading`
`ww_maintenance_order_details`.`estimated_cost`
`ww_maintenance_order_details`.`status`
`ww_maintenance_order_details`.`assigned_to`
`ww_maintenance_order_details`.`foreman_remarks`
`ww_maintenance_order_details`.`area_id`
`ww_maintenance_order_details`.`ref`
`ww_maintenance_order_details`.`error`
`ww_maintenance_order_details`.`late`
`ww_maintenance_order_details`.`time_late`
`ww_maintenance_order_details`.`save_date`
`ww_offset`.*
`ww_offset`.`offset_id`
`ww_offset`.`ref_no`
`ww_offset`.`applicant_no`
`ww_offset`.`guarantee_dep`
`ww_offset`.`arears`
`ww_offset`.`guarantee_deposit_bal`
`ww_offset`.`offsetted_amount`
`ww_offset`.`trans_date`
`ww_offset`.`inc_accont_id`
`ww_offset`.`date_stamp`
`ww_offset`.`offset_stat`
`ww_offset`.`prep_by`
`ww_offset`.`JID`
`ww_offset_details`.*
`ww_offset_details`.`id`
`ww_offset_details`.`offset_id`
`ww_offset_details`.`account_id`
`ww_offset_details`.`particular`
`ww_offset_details`.`amount`
`ww_offset_details_admin_tool`.*
`ww_offset_details_admin_tool`.`id`
`ww_offset_details_admin_tool`.`offset_id`
`ww_offset_details_admin_tool`.`account_id`
`ww_offset_details_admin_tool`.`particular`
`ww_offset_details_admin_tool`.`amount`
`ww_other_charges`.*
`ww_other_charges`.`other_charges_id`
`ww_other_charges`.`ref`
`ww_other_charges`.`bill_no`
`ww_other_charges`.`applicant_no`
`ww_other_charges`.`coa_id`
`ww_other_charges`.`income_account_code`
`ww_other_charges`.`income_account_description`
`ww_other_charges`.`target_month`
`ww_other_charges`.`year`
`ww_other_charges`.`payable_in_months`
`ww_other_charges`.`charge_amount`
`ww_other_charges`.`adjustment`
`ww_other_charges`.`adj_status`
`ww_other_charges`.`date`
`ww_other_charges`.`date_stamp`
`ww_other_charges`.`status`
`ww_other_charges`.`remarks`
`ww_other_charges`.`payment_date`
`ww_other_charges`.`or_id`
`ww_other_charges`.`JID`
`ww_other_charges`.`cap`
`ww_other_charges`.`prep_by`
`ww_other_charges`.`cancelled_by`
`ww_other_charges`.`group_id`
`ww_other_charges_admin_tool`.*
`ww_other_charges_admin_tool`.`other_charges_id`
`ww_other_charges_admin_tool`.`ref`
`ww_other_charges_admin_tool`.`bill_no`
`ww_other_charges_admin_tool`.`applicant_no`
`ww_other_charges_admin_tool`.`coa_id`
`ww_other_charges_admin_tool`.`income_account_code`
`ww_other_charges_admin_tool`.`income_account_description`
`ww_other_charges_admin_tool`.`target_month`
`ww_other_charges_admin_tool`.`year`
`ww_other_charges_admin_tool`.`payable_in_months`
`ww_other_charges_admin_tool`.`charge_amount`
`ww_other_charges_admin_tool`.`adjustment`
`ww_other_charges_admin_tool`.`adj_status`
`ww_other_charges_admin_tool`.`date`
`ww_other_charges_admin_tool`.`date_stamp`
`ww_other_charges_admin_tool`.`status`
`ww_other_charges_admin_tool`.`remarks`
`ww_other_charges_admin_tool`.`payment_date`
`ww_other_charges_admin_tool`.`or_id`
`ww_other_charges_admin_tool`.`JID`
`ww_other_charges_admin_tool`.`cap`
`ww_other_charges_admin_tool`.`prep_by`
`ww_other_charges_admin_tool`.`cancelled_by`
`ww_other_charges_admin_tool`.`group_id`
`ww_other_charges_temp`.*
`ww_other_charges_temp`.`other_charges_id`
`ww_other_charges_temp`.`ref`
`ww_other_charges_temp`.`bill_no`
`ww_other_charges_temp`.`applicant_no`
`ww_other_charges_temp`.`coa_id`
`ww_other_charges_temp`.`income_account_code`
`ww_other_charges_temp`.`income_account_description`
`ww_other_charges_temp`.`target_month`
`ww_other_charges_temp`.`year`
`ww_other_charges_temp`.`payable_in_months`
`ww_other_charges_temp`.`charge_amount`
`ww_other_charges_temp`.`date`
`ww_other_charges_temp`.`date_stamp`
`ww_other_charges_temp`.`status`
`ww_other_charges_temp`.`remarks`
`ww_other_charges_temp`.`payment_date`
`ww_other_charges_temp`.`or_id`
`ww_other_charges_temp`.`JID`
`ww_other_charges_temp`.`cap`
`ww_other_charges_temp`.`prep_by`
`ww_other_charges_temp`.`cancelled_by`
`ww_other_charges_temp`.`group_id`
`ww_payment_employee_dtl`.*
`ww_payment_employee_dtl`.`id`
`ww_payment_employee_dtl`.`main_id`
`ww_payment_employee_dtl`.`jid`
`ww_payment_employee_dtl`.`app_no`
`ww_payment_employee_dtl`.`bill_no`
`ww_payment_employee_dtl`.`coa_id`
`ww_payment_employee_dtl`.`amount`
`ww_payment_employee_dtl`.`trans_date`
`ww_payment_employee_dtl`.`type`
`ww_payment_employee_dtl`.`tmstamp`
`ww_payment_order`.*
`ww_payment_order`.`payment_order_id`
`ww_payment_order`.`reference_no`
`ww_payment_order`.`applicant_no`
`ww_payment_order`.`person_id`
`ww_payment_order`.`type`
`ww_payment_order`.`total`
`ww_payment_order`.`prepared_by`
`ww_payment_order`.`date`
`ww_payment_order`.`remarks`
`ww_payment_order`.`pay_remarks`
`ww_payment_order`.`or_id`
`ww_payment_order`.`date_paid`
`ww_payment_order`.`date_stamp`
`ww_payment_order`.`cap`
`ww_payment_order`.`GID`
`ww_payment_order`.`JID`
`ww_payment_order`.`manual_pay`
`ww_payment_order_detail`.*
`ww_payment_order_detail`.`detail id`
`ww_payment_order_detail`.`payment_order_id`
`ww_payment_order_detail`.`account_id`
`ww_payment_order_detail`.`amount`
`ww_payment_order_detail`.`direct`
`ww_payments_employee`.*
`ww_payments_employee`.`id`
`ww_payments_employee`.`jid`
`ww_payments_employee`.`emp_id`
`ww_payments_employee`.`account_id`
`ww_payments_employee`.`amount`
`ww_payments_employee`.`date_trans`
`ww_payments_employee`.`pep_by`
`ww_payments_employee`.`time_stamp`
`ww_payments_employee`.`status`
`ww_penalty_list`.*
`ww_penalty_list`.`id`
`ww_penalty_list`.`app_id`
`ww_penalty_list`.`bill_no`
`ww_penalty_list`.`no_months`
`ww_penalty_list`.`service_fee`
`ww_penalty_list`.`service_charge`
`ww_penalty_list`.`penalty`
`ww_penalty_list`.`bill_month`
`ww_penalty_list`.`trans_date`
`ww_penalty_list`.`timestamp`
`ww_penalty_list`.`prep_by`
`ww_penalty_setup`.*
`ww_penalty_setup`.`penalty_id`
`ww_penalty_setup`.`penalty_desc`
`ww_penalty_setup`.`penalty_charge`
`ww_plumberaccomplishmenttarget`.*
`ww_plumberaccomplishmenttarget`.`id`
`ww_plumberaccomplishmenttarget`.`ratescale_desc_id`
`ww_plumberaccomplishmenttarget`.`ratescale_desc`
`ww_plumberaccomplishmenttarget`.`plumber`
`ww_plumberaccomplishmenttarget`.`target`
`ww_plumberaccomplishmenttarget`.`date_from`
`ww_plumberaccomplishmenttarget`.`date_to`
`ww_plumbersetup`.*
`ww_plumbersetup`.`id`
`ww_plumbersetup`.`emp_id`
`ww_plumbersetup`.`person_id`
`ww_plumbersetup`.`plumber_name`
`ww_promissory`.*
`ww_promissory`.`promissory_id`
`ww_promissory`.`reference_no`
`ww_promissory`.`applicant_no`
`ww_promissory`.`date`
`ww_promissory`.`date_tobe_paid`
`ww_promissory`.`approved_by`
`ww_promissory`.`status`
`ww_promissory`.`bill_no`
`ww_promissory`.`arrears`
`ww_rating_scale_setup`.*
`ww_rating_scale_setup`.`ratingscale_id`
`ww_rating_scale_setup`.`minimum_rate`
`ww_rating_scale_setup`.`maximum_rate`
`ww_rating_scale_setup`.`score`
`ww_rating_scale_setup`.`rate_desc`
`ww_reconnection`.*
`ww_reconnection`.`rec_id`
`ww_reconnection`.`person_id`
`ww_reconnection`.`applicant_no`
`ww_reconnection`.`type`
`ww_reconnection`.`address`
`ww_reconnection`.`initial_reading`
`ww_reconnection`.`balance`
`ww_reconnection`.`brand`
`ww_reconnection`.`serial_id`
`ww_reconnection`.`serial`
`ww_reconnection`.`reconnected_date`
`ww_reconnection`.`reconnected_by`
`ww_reconnection`.`tmestamp`
`ww_senior_citizen_discount`.*
`ww_senior_citizen_discount`.`sen_cit_id`
`ww_senior_citizen_discount`.`app_no`
`ww_senior_citizen_discount`.`acct_no`
`ww_senior_citizen_discount`.`dis_percentage`
`ww_senior_citizen_discount`.`consumer_id`
`ww_senior_citizen_discount`.`date_applied`
`ww_senior_citizen_discount`.`date_expire`
`ww_senior_citizen_discount`.`approved`
`ww_senior_citizen_discount`.`approved_by`
`ww_senior_citizen_discount`.`status`
`ww_senior_citizen_discount`.`osca_id_no`
`ww_senior_citizen_discount`.`birthdate`
`ww_senior_citizen_discount`.`remarks`
`ww_senior_citizen_discount`.`address`
`ww_senior_citizen_discount_logs`.*
`ww_senior_citizen_discount_logs`.`dtl_id`
`ww_senior_citizen_discount_logs`.`sen_cit_id`
`ww_senior_citizen_discount_logs`.`app_no`
`ww_senior_citizen_discount_logs`.`acct_no`
`ww_senior_citizen_discount_logs`.`dis_percentage`
`ww_senior_citizen_discount_logs`.`consumer_id`
`ww_senior_citizen_discount_logs`.`date_applied`
`ww_senior_citizen_discount_logs`.`date_expire`
`ww_senior_citizen_discount_logs`.`approved`
`ww_senior_citizen_discount_logs`.`approved_by`
`ww_senior_citizen_discount_logs`.`status`
`ww_senior_citizen_discount_logs`.`osca_id_no`
`ww_senior_citizen_discount_logs`.`birthdate`
`ww_senior_citizen_discount_logs`.`remarks`
`ww_senior_citizen_discount_logs`.`address`
`ww_transfer`.*
`ww_transfer`.`transfer_id`
`ww_transfer`.`applicant_no_from`
`ww_transfer`.`applicant_no_to`
`ww_transfer`.`transferred_from`
`ww_transfer`.`transferred_to`
`ww_transfer`.`transferred_date`
`ww_transfer`.`from_type`
`ww_transfer`.`to_type`
`ww_type`.*
`ww_type`.`id`
`ww_type`.`desc`
`ww_type`.`code`
`ww_type`.`type`
`ww_type`.`legend`
`ww_type`.`comment`
`ww_water_billing`.*
`ww_water_billing`.`bill_number`
`ww_water_billing`.`main_id`
`ww_water_billing`.`cust_bill_number`
`ww_water_billing`.`application_no`
`ww_water_billing`.`acct_no`
`ww_water_billing`.`customer_id`
`ww_water_billing`.`meter_id`
`ww_water_billing`.`meter_number`
`ww_water_billing`.`meter_reader_id`
`ww_water_billing`.`guarantee_deposit`
`ww_water_billing`.`advance_amount`
`ww_water_billing`.`bill_from`
`ww_water_billing`.`bill_to`
`ww_water_billing`.`billing_date`
`ww_water_billing`.`due_date`
`ww_water_billing`.`prev_consumption`
`ww_water_billing`.`present_consumption`
`ww_water_billing`.`ave_consumption`
`ww_water_billing`.`prev_meter_reading`
`ww_water_billing`.`present_meter_reading`
`ww_water_billing`.`cut_off_cum`
`ww_water_billing`.`cubic_meter_consumed`
`ww_water_billing`.`last_payment_date`
`ww_water_billing`.`basicCharge`
`ww_water_billing`.`total`
`ww_water_billing`.`total_unpaid_amount`
`ww_water_billing`.`adjustment`
`ww_water_billing`.`adj_status`
`ww_water_billing`.`remarks`
`ww_water_billing`.`pay_remarks`
`ww_water_billing`.`b_or_id`
`ww_water_billing`.`b_or_number`
`ww_water_billing`.`b_or_date`
`ww_water_billing`.`b_or_amount`
`ww_water_billing`.`entry_status`
`ww_water_billing`.`JID`
`ww_water_billing`.`coa_id`
`ww_water_billing`.`date_saved`
`ww_water_billing`.`exp_id`
`ww_water_billing`.`explanation`
`ww_water_billing`.`penalty_date`
`ww_water_billing`.`penalty_stat`
`ww_water_billing`.`cancel_remarks`
`ww_water_billing`.`bill_type`
`ww_water_billing`.`sen_cit`
`ww_water_billing`.`adj_type`
`ww_water_billing`.`adj_reading`
`ww_water_billing_assgn_reader`.*
`ww_water_billing_assgn_reader`.`id`
`ww_water_billing_assgn_reader`.`zone_id`
`ww_water_billing_assgn_reader`.`book_id`
`ww_water_billing_assgn_reader`.`brgy_id`
`ww_water_billing_assgn_reader`.`meter_reader_id`
`ww_water_billing_assgn_reader`.`bill_month`
`ww_water_billing_assgn_reader`.`reding_sche`
`ww_water_billing_assgn_reader`.`date_save`
`ww_water_billing_assgn_reader_dtl`.*
`ww_water_billing_assgn_reader_dtl`.`id`
`ww_water_billing_assgn_reader_dtl`.`main_id`
`ww_water_billing_assgn_reader_dtl`.`app_no`
`ww_water_billing_assgn_reader_dtl`.`bill_number`
`ww_water_billing_assgn_reader_dtl`.`read`
`ww_water_billing_assgn_reader_dtl`.`bill_status`
`ww_water_billing_assgn_reader_dtl`.`date_save`
`ww_ww_cust_list_old`.*
`ww_ww_cust_list_old`.`id`
`ww_ww_cust_list_old`.`acct_no`
`ww_ww_cust_list_old`.`sequence_no`
`ww_ww_cust_list_old`.`consumer_name`
`ww_ww_cust_list_old`.`address`
`cto_water_applicant_classification`.*
`cto_water_applicant_classification`.`id`
`cto_water_applicant_classification`.`description`
`cto_water_applicant_classification`.`minimum_charge`
`cto_water_applicant_classification`.`percentage`
`cto_water_rates`.*
`cto_water_rates`.`SysPK_waterrates`
`cto_water_rates`.`class_id`
`cto_water_rates`.`code`
`cto_water_rates`.`minimum_consumption`
`cto_water_rates`.`maximum_consumption`
`cto_water_rates`.`rate_per_cubic`
`cto_water_rates`.`size_id`
`jay_list_consumer_view`.*
`jay_list_consumer_view`.`Applicant_No`
`jay_list_consumer_view`.`application_date`
`jay_list_consumer_view`.`sequence_no`
`jay_list_consumer_view`.`acct_no`
`jay_list_consumer_view`.`zone_no`
`jay_list_consumer_view`.`book_id`
`jay_list_consumer_view`.`person_code`
`jay_list_consumer_view`.`brgy_id`
`jay_list_consumer_view`.`purok`
`jay_list_consumer_view`.`house_number`
`jay_list_consumer_view`.`street`
`jay_list_consumer_view`.`village_district`
`jay_list_consumer_view`.`city`
`jay_list_consumer_view`.`province`
`jay_list_consumer_view`.`route_no`
`jay_list_consumer_view`.`phone_number`
`jay_list_consumer_view`.`meter_id`
`jay_list_consumer_view`.`meter_number`
`jay_list_consumer_view`.`type`
`jay_list_consumer_view`.`class_id`
`jay_list_consumer_view`.`classification`
`jay_list_consumer_view`.`reading_sched`
`jay_list_consumer_view`.`meter_type`
`jay_list_consumer_view`.`discount`
`jay_list_consumer_view`.`sen_cit`
`jay_list_consumer_view`.`payment_order_id`
`jay_list_consumer_view`.`image`
`jay_list_consumer_view`.`mo_id`
`jay_list_consumer_view`.`date_stat_active`
`jay_list_consumer_view`.`Address`
`jay_list_consumer_view`.`customer_name`
`lgu_book`.*
`lgu_book`.`book_id`
`lgu_book`.`book_desc`
`lgu_consumer_type`.*
`lgu_consumer_type`.`con_type_id`
`lgu_consumer_type`.`class_type`
`lgu_consumer_type`.`con_type_desc`
`lgu_consumer_type`.`short_desc`
`lgu_consumer_type`.`type`
`lgu_consumer_type`.`category`
`lgu_zone`.*
`lgu_zone`.`zone_id`
`lgu_zone`.`zone_num`
`lgu_zone`.`brgy_id`
`lgu_zone`.`book`
`lib_books`.*
`lib_books`.`book_code`
`lib_books`.`description`
`lib_books`.`username`
`lib_books`.`timestamp`
`lib_brand`.*
`lib_brand`.`rec_id`
`lib_brand`.`ref_desc`
`lib_meters`.*
`lib_meters`.`id`
`lib_meters`.`rec_id`
`lib_meters`.`brand_id`
`lib_meters`.`size_id`
`lib_meters`.`description`
`lib_meters`.`prefix`
`lib_meters`.`serial_no`
`lib_meters`.`active`
`lib_meters`.`cuid`
`lib_meters`.`muid`
`lib_meters`.`created`
`lib_sizes`.*
`lib_sizes`.`rec_id`
`lib_sizes`.`ref_code`
`lib_sizes`.`ref_desc`
`reading_migration`.*
`reading_migration`.`id`
`reading_migration`.`reader_id`
`reading_migration`.`readername`
`reading_migration`.`meter_no`
`reading_migration`.`reading`
`setup_formtype`.*
`setup_formtype`.`id`
`setup_formtype`.`type`
`setup_formtype`.`status`
`setup_formtype`.`form_id`
`setup_signatory`.*
`setup_signatory`.`signatory_id`
`setup_signatory`.`form_id`
`setup_signatory`.`setupType_id`
`setup_signatory`.`employee_id`
`setup_signatory`.`priority_no`
`setup_signatory`.`location`
`setup_signatory`.`title_id`
`setup_signatory`.`savedate`
`setup_signatory`.`status`
`setup_signatory`.`sig_display_name_id`
`setup_signatory`.`prefix`
`setup_signatory`.`suffix`
`setup_signatory`.`position`
`setup_signatorytype`.*
`setup_signatorytype`.`id`
`setup_signatorytype`.`type`
`tbl_restrict_print`.*
`tbl_restrict_print`.`comp_setup`
`tbl_restrict_print`.`comp_desc`
`temp_tbl_aging_account`.*
`temp_tbl_aging_account`.`id`
`temp_tbl_aging_account`.`app_no`
`temp_tbl_aging_account`.`amount`
`temp_tbl_aging_account`.`trans_date`
`temp_tbl_aging_account`.`no_days`
`temp_tbl_aging_account`.`t_type`
`temp_tbl_aging_account_summary`.*
`temp_tbl_aging_account_summary`.`id`
`temp_tbl_aging_account_summary`.`class_id`
`temp_tbl_aging_account_summary`.`Zone/Book`
`temp_tbl_aging_account_summary`.`Amount`
`temp_tbl_aging_account_summary`.`trans_date`
`temp_tbl_aging_account_summary`.`no_days`
`temp_tbl_aging_account_summary`.`t_type`
`ww_account_setup`.*
`ww_account_setup`.`id`
`ww_account_setup`.`description`
`ww_account_setup`.`income_acc_id`
`ww_account_setup`.`income_acc_code`
`ww_account_setup`.`income_acc_name`
`ww_account_setup`.`coa_id`
`ww_adjustments_setup`.*
`ww_adjustments_setup`.`id`
`ww_adjustments_setup`.`particular`
`ww_adjustments_setup`.`debit_accnt_id`
`ww_adjustments_setup`.`credit_accnt_id`
`ww_adjustments_setup`.`oth_charges`
`ww_adjustments_setup`.`type`
`ww_adjustments_setup`.`status`
`ww_adjustments_setup`.`paid_accnit`
`ww_aging_no_days`.*
`ww_aging_no_days`.`id`
`ww_aging_no_days`.`desc`
`ww_aging_no_days`.`min_days`
`ww_aging_no_days`.`max_days`
`ww_area_setup`.*
`ww_area_setup`.`id`
`ww_area_setup`.`dept`
`ww_area_setup`.`area`
`ww_area_setup`.`plumber`
`ww_billing_adjustment`.*
`ww_billing_adjustment`.`bam_id`
`ww_billing_adjustment`.`bill_id`
`ww_billing_adjustment`.`bam_no`
`ww_billing_adjustment`.`bam_date`
`ww_billing_adjustment`.`accnt_id`
`ww_billing_adjustment`.`acct_no`
`ww_billing_adjustment`.`account_type`
`ww_billing_adjustment`.`bill_date`
`ww_billing_adjustment`.`emp_meter_reader`
`ww_billing_adjustment`.`explnation`
`ww_billing_adjustment`.`date_saved`
`ww_billing_adjustment`.`pay_status`
`ww_billing_adjustment`.`status`
`ww_billing_adjustment`.`prepared_by`
`ww_billing_adjustment`.`cancelled_by`
`ww_billing_adjustment`.`cancelled_date`
`ww_billing_adjustment`.`posted_by`
`ww_billing_adjustment`.`posted_date`
`ww_billing_adjustment`.`JID`
`ww_billing_adjustment`.`bam_amount`
`ww_billing_adjustment`.`oth_credit`
`ww_billing_adjustment`.`with_bill`
`ww_billing_adjustment`.`bill_amount`
`ww_billing_adjustment`.`is_new_rate`
`ww_billing_adjustment_admin_tool`.*
`ww_billing_adjustment_admin_tool`.`bam_id`
`ww_billing_adjustment_admin_tool`.`bill_id`
`ww_billing_adjustment_admin_tool`.`bam_no`
`ww_billing_adjustment_admin_tool`.`bam_date`
`ww_billing_adjustment_admin_tool`.`accnt_id`
`ww_billing_adjustment_admin_tool`.`acct_no`
`ww_billing_adjustment_admin_tool`.`account_type`
`ww_billing_adjustment_admin_tool`.`bill_date`
`ww_billing_adjustment_admin_tool`.`emp_meter_reader`
`ww_billing_adjustment_admin_tool`.`explnation`
`ww_billing_adjustment_admin_tool`.`date_saved`
`ww_billing_adjustment_admin_tool`.`pay_status`
`ww_billing_adjustment_admin_tool`.`status`
`ww_billing_adjustment_admin_tool`.`prepared_by`
`ww_billing_adjustment_admin_tool`.`cancelled_by`
`ww_billing_adjustment_admin_tool`.`cancelled_date`
`ww_billing_adjustment_admin_tool`.`posted_by`
`ww_billing_adjustment_admin_tool`.`posted_date`
`ww_billing_adjustment_admin_tool`.`JID`
`ww_billing_adjustment_admin_tool`.`bam_amount`
`ww_billing_adjustment_admin_tool`.`oth_credit`
`ww_billing_adjustment_admin_tool`.`with_bill`
`ww_billing_adjustment_admin_tool`.`bill_amount`
`ww_billing_adjustment_detail`.*
`ww_billing_adjustment_detail`.`id`
`ww_billing_adjustment_detail`.`bam_id`
`ww_billing_adjustment_detail`.`particular_id`
`ww_billing_adjustment_detail`.`ref_id`
`ww_billing_adjustment_detail`.`original`
`ww_billing_adjustment_detail`.`should_be`
`ww_billing_adjustment_detail`.`adjusted`
`ww_billing_adjustment_detail`.`coa_id`
`ww_billing_adjustment_detail`.`accnt_id`
`ww_billing_adjustment_detail`.`amount`
`ww_billing_adjustment_detail`.`dr_cr`
`ww_billing_adjustment_detail`.`particular`
`ww_billing_adjustment_detail`.`change_class`
`ww_billing_adjustment_detail`.`class_id`
`ww_billing_adjustment_detail`.`date_saved`
`ww_billing_adjustment_detail`.`trans_type`
`ww_billing_adjustment_detail`.`payment_status`
`ww_change_class`.*
`ww_change_class`.`rec_id`
`ww_change_class`.`applicant_no`
`ww_change_class`.`original_accnt`
`ww_change_class`.`change_accnt_no`
`ww_change_class`.`from_class_id`
`ww_change_class`.`to_class_id`
`ww_change_class`.`change_class_date`
`ww_change_class`.`date_save`
`ww_change_meter`.*
`ww_change_meter`.`id`
`ww_change_meter`.`application_no`
`ww_change_meter`.`acct_no`
`ww_change_meter`.`meter_from`
`ww_change_meter`.`meter_idfrom`
`ww_change_meter`.`from_brand`
`ww_change_meter`.`current_reading`
`ww_change_meter`.`previous_reading`
`ww_change_meter`.`cubic_used`
`ww_change_meter`.`prev_date_installed`
`ww_change_meter`.`meter_to`
`ww_change_meter`.`meter_idto`
`ww_change_meter`.`to_brand`
`ww_change_meter`.`installation_date`
`ww_change_meter`.`initial_reading`
`ww_change_meter`.`installed_by`
`ww_change_meter`.`remarks`
`ww_change_meter`.`bill_id`
`ww_change_meter`.`date_save`
`ww_change_meter`.`type`
`ww_change_meter`.`mo_id`
`ww_complaint_billing`.*
`ww_complaint_billing`.`id`
`ww_complaint_billing`.`app_id`
`ww_complaint_billing`.`account_no`
`ww_complaint_billing`.`comp_id`
`ww_complaint_billing`.`complaint_desc`
`ww_complaint_billing`.`date_billed`
`ww_complaint_billing`.`timestamp`
`ww_complaint_billing`.`Status`
`ww_complaint_setup`.*
`ww_complaint_setup`.`complaint_id`
`ww_complaint_setup`.`complaint_desc`
`ww_complaint_setup`.`desc_work_id`
`ww_customer_application`.*
`ww_customer_application`.`Applicant_No`
`ww_customer_application`.`application_date`
`ww_customer_application`.`sequence_no`
`ww_customer_application`.`acct_no`
`ww_customer_application`.`zone_no`
`ww_customer_application`.`book_id`
`ww_customer_application`.`person_code`
`ww_customer_application`.`brgy_id`
`ww_customer_application`.`purok`
`ww_customer_application`.`house_number`
`ww_customer_application`.`street`
`ww_customer_application`.`village_district`
`ww_customer_application`.`district`
`ww_customer_application`.`city`
`ww_customer_application`.`province`
`ww_customer_application`.`route_no`
`ww_customer_application`.`phone_number`
`ww_customer_application`.`meter_id`
`ww_customer_application`.`lib_mter_id`
`ww_customer_application`.`meter_number`
`ww_customer_application`.`meter_size`
`ww_customer_application`.`type`
`ww_customer_application`.`class_id`
`ww_customer_application`.`classification`
`ww_customer_application`.`reading_sched`
`ww_customer_application`.`meter_type`
`ww_customer_application`.`discount`
`ww_customer_application`.`sen_cit`
`ww_customer_application`.`payment_order_id`
`ww_customer_application`.`image`
`ww_customer_application`.`mo_id`
`ww_customer_application`.`date_stat_active`
`ww_customer_application`.`timestamp`
`ww_customer_application`.`type_applied`
`ww_customer_application`.`include_pnalty`
`ww_customer_application`.`status`
`ww_customer_application_details`.*
`ww_customer_application_details`.`id`
`ww_customer_application_details`.`applicant_no`
`ww_customer_application_details`.`acct_no`
`ww_customer_application_details`.`employed`
`ww_customer_application_details`.`employer`
`ww_customer_application_details`.`emp_address`
`ww_customer_application_details`.`emp_status`
`ww_customer_application_details`.`annual_sal`
`ww_customer_application_details`.`spouse`
`ww_customer_application_details`.`other_income`
`ww_customer_application_details`.`other_spec`
`ww_customer_application_details`.`annual_inc`
`ww_customer_application_details`.`no_house_member`
`ww_customer_application_details`.`no_of_fam`
`ww_customer_application_details`.`con_type`
`ww_customer_application_details`.`con_size`
`ww_customer_application_details`.`tapping_desc`
`ww_customer_application_details`.`service_con_before`
`ww_customer_application_details`.`when_scb`
`ww_customer_application_details`.`legal_owner`
`ww_customer_application_details`.`who_own`
`ww_customer_application_details`.`willing_for_con`
`ww_customer_application_details`.`desired_con`
`ww_customer_application_details`.`other_desired`
`ww_customer_application_details`.`bday`
`ww_customer_application_details`.`age`
`ww_customer_application_details`.`civil_stat`
`ww_customer_application_details`.`phone_number`
`ww_customer_application_details`.`status`
`ww_customer_meter_details`.*
`ww_customer_meter_details`.`meter_id`
`ww_customer_meter_details`.`applicant_no`
`ww_customer_meter_details`.`acct_no`
`ww_customer_meter_details`.`customer_id`
`ww_customer_meter_details`.`serial_no`
`ww_customer_meter_details`.`meter_number`
`ww_customer_meter_details`.`meter_size`
`ww_customer_meter_details`.`installation_date`
`ww_customer_meter_details`.`inspection_date`
`ww_customer_meter_details`.`installed_by`
`ww_customer_meter_details`.`inspected_by`
`ww_customer_meter_details`.`OR_number`
`ww_customer_meter_details`.`service_status`
`ww_customer_meter_details`.`status`
`ww_customer_meter_details`.`meter_status`
`ww_customer_meter_details`.`meter_remarks`
`ww_customer_meter_details`.`barangay_address`
`ww_customer_meter_details`.`addressID`
`ww_customer_meter_details`.`OR_date`
`ww_customer_meter_details`.`customer_description`
`ww_customer_meter_details`.`brgy_id`
`ww_customer_meter_details`.`or_amount`
`ww_customer_meter_details`.`date_disconnected`
`ww_customer_meter_details`.`time_disconnected`
`ww_customer_meter_details`.`disconnected_by`
`ww_customer_meter_details`.`classification`
`ww_customer_meter_details`.`subName`
`ww_customer_meter_details`.`brand`
`ww_customer_meter_details`.`first_meter_reading`
`ww_customer_meter_details`.`last_meter_reading`
`ww_customer_meter_details`.`remarks`
`ww_customer_meter_details`.`re_connect`
`ww_customer_meter_details`.`date_re_connect`
`ww_customer_meter_details`.`transferred`
`ww_customer_meter_details`.`date_transferred`
`ww_customer_meter_details`.`timestamp`
`ww_customer_profile`.*
`ww_customer_profile`.`customer_id`
`ww_customer_profile`.`person_profile_id`
`ww_customer_profile`.`classification`
`ww_customer_profile`.`customer_name`
`ww_customer_profile`.`timestatmp`
`ww_desc_work`.*
`ww_desc_work`.`desc_work_id`
`ww_desc_work`.`work_desc`
`ww_desc_work`.`trans_type`
`ww_employee_withbenefit`.*
`ww_employee_withbenefit`.`id`
`ww_employee_withbenefit`.`applicant_no`
`ww_employee_withbenefit`.`emp_number`
`ww_employee_withbenefit`.`cum_benefit`
`ww_employee_withbenefit`.`amount`
`ww_employee_withbenefit`.`remarks`
`ww_employee_withbenefit`.`status`
`ww_employee_withbenefit`.`payroll_period`
`ww_employee_withbenefit`.`to_deduct`
`ww_employee_withbenefit`.`time_stamp`
`ww_guaranty_deposit`.*
`ww_guaranty_deposit`.`gd_id`
`ww_guaranty_deposit`.`applicant_no`
`ww_guaranty_deposit`.`account_id`
`ww_guaranty_deposit`.`guarantee_deposit`
`ww_guaranty_deposit`.`gd_ordate`
`ww_guaranty_deposit`.`gd_ornumber`
`ww_guaranty_deposit`.`status`
`ww_guaranty_deposit_details`.*
`ww_guaranty_deposit_details`.`gd_id_detail`
`ww_guaranty_deposit_details`.`gd_id`
`ww_guaranty_deposit_details`.`account_desc`
`ww_guaranty_deposit_details`.`amount`
`ww_inspectors`.*
`ww_inspectors`.`inspector_id`
`ww_inspectors`.`pp_person_code`
`ww_inspectors`.`inspector_name`
`ww_inspectors`.`date_saved`
`ww_maintenance_order`.*
`ww_maintenance_order`.`mo_id`
`ww_maintenance_order`.`applicant_no`
`ww_maintenance_order`.`person_id`
`ww_maintenance_order`.`type`
`ww_maintenance_order`.`complainant`
`ww_maintenance_order`.`address`
`ww_maintenance_order`.`assigned_from`
`ww_maintenance_order`.`remarks`
`ww_maintenance_order`.`tran_type`
`ww_maintenance_order`.`posted`
`ww_maintenance_order`.`pay_order_id`
`ww_maintenance_order`.`status`
`ww_maintenance_order_details`.*
`ww_maintenance_order_details`.`mo_detail_id`
`ww_maintenance_order_details`.`mo_id`
`ww_maintenance_order_details`.`mo_no`
`ww_maintenance_order_details`.`complaint`
`ww_maintenance_order_details`.`action_taken`
`ww_maintenance_order_details`.`date_of_complaint`
`ww_maintenance_order_details`.`plumber`
`ww_maintenance_order_details`.`date_assigned`
`ww_maintenance_order_details`.`date_accomplished`
`ww_maintenance_order_details`.`time_started`
`ww_maintenance_order_details`.`time_finished`
`ww_maintenance_order_details`.`remarks`
`ww_maintenance_order_details`.`serial_no`
`ww_maintenance_order_details`.`serial_id`
`ww_maintenance_order_details`.`brand`
`ww_maintenance_order_details`.`reading`
`ww_maintenance_order_details`.`last_reading`
`ww_maintenance_order_details`.`estimated_cost`
`ww_maintenance_order_details`.`status`
`ww_maintenance_order_details`.`assigned_to`
`ww_maintenance_order_details`.`foreman_remarks`
`ww_maintenance_order_details`.`area_id`
`ww_maintenance_order_details`.`ref`
`ww_maintenance_order_details`.`error`
`ww_maintenance_order_details`.`late`
`ww_maintenance_order_details`.`time_late`
`ww_maintenance_order_details`.`save_date`
`ww_offset`.*
`ww_offset`.`offset_id`
`ww_offset`.`ref_no`
`ww_offset`.`applicant_no`
`ww_offset`.`guarantee_dep`
`ww_offset`.`arears`
`ww_offset`.`guarantee_deposit_bal`
`ww_offset`.`offsetted_amount`
`ww_offset`.`trans_date`
`ww_offset`.`inc_accont_id`
`ww_offset`.`date_stamp`
`ww_offset`.`offset_stat`
`ww_offset`.`prep_by`
`ww_offset`.`JID`
`ww_offset_details`.*
`ww_offset_details`.`id`
`ww_offset_details`.`offset_id`
`ww_offset_details`.`account_id`
`ww_offset_details`.`particular`
`ww_offset_details`.`amount`
`ww_offset_details_admin_tool`.*
`ww_offset_details_admin_tool`.`id`
`ww_offset_details_admin_tool`.`offset_id`
`ww_offset_details_admin_tool`.`account_id`
`ww_offset_details_admin_tool`.`particular`
`ww_offset_details_admin_tool`.`amount`
`ww_other_charges`.*
`ww_other_charges`.`other_charges_id`
`ww_other_charges`.`ref`
`ww_other_charges`.`bill_no`
`ww_other_charges`.`applicant_no`
`ww_other_charges`.`coa_id`
`ww_other_charges`.`income_account_code`
`ww_other_charges`.`income_account_description`
`ww_other_charges`.`target_month`
`ww_other_charges`.`year`
`ww_other_charges`.`payable_in_months`
`ww_other_charges`.`charge_amount`
`ww_other_charges`.`adjustment`
`ww_other_charges`.`adj_status`
`ww_other_charges`.`date`
`ww_other_charges`.`date_stamp`
`ww_other_charges`.`status`
`ww_other_charges`.`remarks`
`ww_other_charges`.`payment_date`
`ww_other_charges`.`or_id`
`ww_other_charges`.`JID`
`ww_other_charges`.`cap`
`ww_other_charges`.`prep_by`
`ww_other_charges`.`cancelled_by`
`ww_other_charges`.`group_id`
`ww_other_charges_admin_tool`.*
`ww_other_charges_admin_tool`.`other_charges_id`
`ww_other_charges_admin_tool`.`ref`
`ww_other_charges_admin_tool`.`bill_no`
`ww_other_charges_admin_tool`.`applicant_no`
`ww_other_charges_admin_tool`.`coa_id`
`ww_other_charges_admin_tool`.`income_account_code`
`ww_other_charges_admin_tool`.`income_account_description`
`ww_other_charges_admin_tool`.`target_month`
`ww_other_charges_admin_tool`.`year`
`ww_other_charges_admin_tool`.`payable_in_months`
`ww_other_charges_admin_tool`.`charge_amount`
`ww_other_charges_admin_tool`.`adjustment`
`ww_other_charges_admin_tool`.`adj_status`
`ww_other_charges_admin_tool`.`date`
`ww_other_charges_admin_tool`.`date_stamp`
`ww_other_charges_admin_tool`.`status`
`ww_other_charges_admin_tool`.`remarks`
`ww_other_charges_admin_tool`.`payment_date`
`ww_other_charges_admin_tool`.`or_id`
`ww_other_charges_admin_tool`.`JID`
`ww_other_charges_admin_tool`.`cap`
`ww_other_charges_admin_tool`.`prep_by`
`ww_other_charges_admin_tool`.`cancelled_by`
`ww_other_charges_admin_tool`.`group_id`
`ww_other_charges_temp`.*
`ww_other_charges_temp`.`other_charges_id`
`ww_other_charges_temp`.`ref`
`ww_other_charges_temp`.`bill_no`
`ww_other_charges_temp`.`applicant_no`
`ww_other_charges_temp`.`coa_id`
`ww_other_charges_temp`.`income_account_code`
`ww_other_charges_temp`.`income_account_description`
`ww_other_charges_temp`.`target_month`
`ww_other_charges_temp`.`year`
`ww_other_charges_temp`.`payable_in_months`
`ww_other_charges_temp`.`charge_amount`
`ww_other_charges_temp`.`date`
`ww_other_charges_temp`.`date_stamp`
`ww_other_charges_temp`.`status`
`ww_other_charges_temp`.`remarks`
`ww_other_charges_temp`.`payment_date`
`ww_other_charges_temp`.`or_id`
`ww_other_charges_temp`.`JID`
`ww_other_charges_temp`.`cap`
`ww_other_charges_temp`.`prep_by`
`ww_other_charges_temp`.`cancelled_by`
`ww_other_charges_temp`.`group_id`
`ww_payment_employee_dtl`.*
`ww_payment_employee_dtl`.`id`
`ww_payment_employee_dtl`.`main_id`
`ww_payment_employee_dtl`.`jid`
`ww_payment_employee_dtl`.`app_no`
`ww_payment_employee_dtl`.`bill_no`
`ww_payment_employee_dtl`.`coa_id`
`ww_payment_employee_dtl`.`amount`
`ww_payment_employee_dtl`.`trans_date`
`ww_payment_employee_dtl`.`type`
`ww_payment_employee_dtl`.`tmstamp`
`ww_payment_order`.*
`ww_payment_order`.`payment_order_id`
`ww_payment_order`.`reference_no`
`ww_payment_order`.`applicant_no`
`ww_payment_order`.`person_id`
`ww_payment_order`.`type`
`ww_payment_order`.`total`
`ww_payment_order`.`prepared_by`
`ww_payment_order`.`date`
`ww_payment_order`.`remarks`
`ww_payment_order`.`pay_remarks`
`ww_payment_order`.`or_id`
`ww_payment_order`.`date_paid`
`ww_payment_order`.`date_stamp`
`ww_payment_order`.`cap`
`ww_payment_order`.`GID`
`ww_payment_order`.`JID`
`ww_payment_order`.`manual_pay`
`ww_payment_order_detail`.*
`ww_payment_order_detail`.`detail id`
`ww_payment_order_detail`.`payment_order_id`
`ww_payment_order_detail`.`account_id`
`ww_payment_order_detail`.`amount`
`ww_payment_order_detail`.`direct`
`ww_payments_employee`.*
`ww_payments_employee`.`id`
`ww_payments_employee`.`jid`
`ww_payments_employee`.`emp_id`
`ww_payments_employee`.`account_id`
`ww_payments_employee`.`amount`
`ww_payments_employee`.`date_trans`
`ww_payments_employee`.`pep_by`
`ww_payments_employee`.`time_stamp`
`ww_payments_employee`.`status`
`ww_penalty_list`.*
`ww_penalty_list`.`id`
`ww_penalty_list`.`app_id`
`ww_penalty_list`.`bill_no`
`ww_penalty_list`.`no_months`
`ww_penalty_list`.`service_fee`
`ww_penalty_list`.`service_charge`
`ww_penalty_list`.`penalty`
`ww_penalty_list`.`bill_month`
`ww_penalty_list`.`trans_date`
`ww_penalty_list`.`timestamp`
`ww_penalty_list`.`prep_by`
`ww_penalty_setup`.*
`ww_penalty_setup`.`penalty_id`
`ww_penalty_setup`.`penalty_desc`
`ww_penalty_setup`.`penalty_charge`
`ww_plumberaccomplishmenttarget`.*
`ww_plumberaccomplishmenttarget`.`id`
`ww_plumberaccomplishmenttarget`.`ratescale_desc_id`
`ww_plumberaccomplishmenttarget`.`ratescale_desc`
`ww_plumberaccomplishmenttarget`.`plumber`
`ww_plumberaccomplishmenttarget`.`target`
`ww_plumberaccomplishmenttarget`.`date_from`
`ww_plumberaccomplishmenttarget`.`date_to`
`ww_plumbersetup`.*
`ww_plumbersetup`.`id`
`ww_plumbersetup`.`emp_id`
`ww_plumbersetup`.`person_id`
`ww_plumbersetup`.`plumber_name`
`ww_promissory`.*
`ww_promissory`.`promissory_id`
`ww_promissory`.`reference_no`
`ww_promissory`.`applicant_no`
`ww_promissory`.`date`
`ww_promissory`.`date_tobe_paid`
`ww_promissory`.`approved_by`
`ww_promissory`.`status`
`ww_promissory`.`bill_no`
`ww_promissory`.`arrears`
`ww_rating_scale_setup`.*
`ww_rating_scale_setup`.`ratingscale_id`
`ww_rating_scale_setup`.`minimum_rate`
`ww_rating_scale_setup`.`maximum_rate`
`ww_rating_scale_setup`.`score`
`ww_rating_scale_setup`.`rate_desc`
`ww_reconnection`.*
`ww_reconnection`.`rec_id`
`ww_reconnection`.`person_id`
`ww_reconnection`.`applicant_no`
`ww_reconnection`.`type`
`ww_reconnection`.`address`
`ww_reconnection`.`initial_reading`
`ww_reconnection`.`balance`
`ww_reconnection`.`brand`
`ww_reconnection`.`serial_id`
`ww_reconnection`.`serial`
`ww_reconnection`.`reconnected_date`
`ww_reconnection`.`reconnected_by`
`ww_reconnection`.`tmestamp`
`ww_senior_citizen_discount`.*
`ww_senior_citizen_discount`.`sen_cit_id`
`ww_senior_citizen_discount`.`app_no`
`ww_senior_citizen_discount`.`acct_no`
`ww_senior_citizen_discount`.`dis_percentage`
`ww_senior_citizen_discount`.`consumer_id`
`ww_senior_citizen_discount`.`date_applied`
`ww_senior_citizen_discount`.`date_expire`
`ww_senior_citizen_discount`.`approved`
`ww_senior_citizen_discount`.`approved_by`
`ww_senior_citizen_discount`.`status`
`ww_senior_citizen_discount`.`osca_id_no`
`ww_senior_citizen_discount`.`birthdate`
`ww_senior_citizen_discount`.`remarks`
`ww_senior_citizen_discount`.`address`
`ww_senior_citizen_discount_logs`.*
`ww_senior_citizen_discount_logs`.`dtl_id`
`ww_senior_citizen_discount_logs`.`sen_cit_id`
`ww_senior_citizen_discount_logs`.`app_no`
`ww_senior_citizen_discount_logs`.`acct_no`
`ww_senior_citizen_discount_logs`.`dis_percentage`
`ww_senior_citizen_discount_logs`.`consumer_id`
`ww_senior_citizen_discount_logs`.`date_applied`
`ww_senior_citizen_discount_logs`.`date_expire`
`ww_senior_citizen_discount_logs`.`approved`
`ww_senior_citizen_discount_logs`.`approved_by`
`ww_senior_citizen_discount_logs`.`status`
`ww_senior_citizen_discount_logs`.`osca_id_no`
`ww_senior_citizen_discount_logs`.`birthdate`
`ww_senior_citizen_discount_logs`.`remarks`
`ww_senior_citizen_discount_logs`.`address`
`ww_transfer`.*
`ww_transfer`.`transfer_id`
`ww_transfer`.`applicant_no_from`
`ww_transfer`.`applicant_no_to`
`ww_transfer`.`transferred_from`
`ww_transfer`.`transferred_to`
`ww_transfer`.`transferred_date`
`ww_transfer`.`from_type`
`ww_transfer`.`to_type`
`ww_type`.*
`ww_type`.`id`
`ww_type`.`desc`
`ww_type`.`code`
`ww_type`.`type`
`ww_type`.`legend`
`ww_type`.`comment`
`ww_water_billing`.*
`ww_water_billing`.`bill_number`
`ww_water_billing`.`main_id`
`ww_water_billing`.`cust_bill_number`
`ww_water_billing`.`application_no`
`ww_water_billing`.`acct_no`
`ww_water_billing`.`customer_id`
`ww_water_billing`.`meter_id`
`ww_water_billing`.`meter_number`
`ww_water_billing`.`meter_reader_id`
`ww_water_billing`.`guarantee_deposit`
`ww_water_billing`.`advance_amount`
`ww_water_billing`.`bill_from`
`ww_water_billing`.`bill_to`
`ww_water_billing`.`billing_date`
`ww_water_billing`.`due_date`
`ww_water_billing`.`prev_consumption`
`ww_water_billing`.`present_consumption`
`ww_water_billing`.`ave_consumption`
`ww_water_billing`.`prev_meter_reading`
`ww_water_billing`.`present_meter_reading`
`ww_water_billing`.`cut_off_cum`
`ww_water_billing`.`cubic_meter_consumed`
`ww_water_billing`.`last_payment_date`
`ww_water_billing`.`basicCharge`
`ww_water_billing`.`total`
`ww_water_billing`.`total_unpaid_amount`
`ww_water_billing`.`adjustment`
`ww_water_billing`.`adj_status`
`ww_water_billing`.`remarks`
`ww_water_billing`.`pay_remarks`
`ww_water_billing`.`b_or_id`
`ww_water_billing`.`b_or_number`
`ww_water_billing`.`b_or_date`
`ww_water_billing`.`b_or_amount`
`ww_water_billing`.`entry_status`
`ww_water_billing`.`JID`
`ww_water_billing`.`coa_id`
`ww_water_billing`.`date_saved`
`ww_water_billing`.`exp_id`
`ww_water_billing`.`explanation`
`ww_water_billing`.`penalty_date`
`ww_water_billing`.`penalty_stat`
`ww_water_billing`.`cancel_remarks`
`ww_water_billing`.`bill_type`
`ww_water_billing`.`sen_cit`
`ww_water_billing`.`adj_type`
`ww_water_billing`.`adj_reading`
`ww_water_billing_assgn_reader`.*
`ww_water_billing_assgn_reader`.`id`
`ww_water_billing_assgn_reader`.`zone_id`
`ww_water_billing_assgn_reader`.`book_id`
`ww_water_billing_assgn_reader`.`brgy_id`
`ww_water_billing_assgn_reader`.`meter_reader_id`
`ww_water_billing_assgn_reader`.`bill_month`
`ww_water_billing_assgn_reader`.`reding_sche`
`ww_water_billing_assgn_reader`.`date_save`
`ww_water_billing_assgn_reader_dtl`.*
`ww_water_billing_assgn_reader_dtl`.`id`
`ww_water_billing_assgn_reader_dtl`.`main_id`
`ww_water_billing_assgn_reader_dtl`.`app_no`
`ww_water_billing_assgn_reader_dtl`.`bill_number`
`ww_water_billing_assgn_reader_dtl`.`read`
`ww_water_billing_assgn_reader_dtl`.`bill_status`
`ww_water_billing_assgn_reader_dtl`.`date_save`
`ww_ww_cust_list_old`.*
`ww_ww_cust_list_old`.`id`
`ww_ww_cust_list_old`.`acct_no`
`ww_ww_cust_list_old`.`sequence_no`
`ww_ww_cust_list_old`.`consumer_name`
`ww_ww_cust_list_old`.`address`
`cto_water_applicant_classification`.*
`cto_water_applicant_classification`.`id`
`cto_water_applicant_classification`.`description`
`cto_water_applicant_classification`.`minimum_charge`
`cto_water_applicant_classification`.`percentage`
`cto_water_rates`.*
`cto_water_rates`.`SysPK_waterrates`
`cto_water_rates`.`class_id`
`cto_water_rates`.`code`
`cto_water_rates`.`minimum_consumption`
`cto_water_rates`.`maximum_consumption`
`cto_water_rates`.`rate_per_cubic`
`cto_water_rates`.`size_id`
`jay_list_consumer_view`.*
`jay_list_consumer_view`.`Applicant_No`
`jay_list_consumer_view`.`application_date`
`jay_list_consumer_view`.`sequence_no`
`jay_list_consumer_view`.`acct_no`
`jay_list_consumer_view`.`zone_no`
`jay_list_consumer_view`.`book_id`
`jay_list_consumer_view`.`person_code`
`jay_list_consumer_view`.`brgy_id`
`jay_list_consumer_view`.`purok`
`jay_list_consumer_view`.`house_number`
`jay_list_consumer_view`.`street`
`jay_list_consumer_view`.`village_district`
`jay_list_consumer_view`.`city`
`jay_list_consumer_view`.`province`
`jay_list_consumer_view`.`route_no`
`jay_list_consumer_view`.`phone_number`
`jay_list_consumer_view`.`meter_id`
`jay_list_consumer_view`.`meter_number`
`jay_list_consumer_view`.`type`
`jay_list_consumer_view`.`class_id`
`jay_list_consumer_view`.`classification`
`jay_list_consumer_view`.`reading_sched`
`jay_list_consumer_view`.`meter_type`
`jay_list_consumer_view`.`discount`
`jay_list_consumer_view`.`sen_cit`
`jay_list_consumer_view`.`payment_order_id`
`jay_list_consumer_view`.`image`
`jay_list_consumer_view`.`mo_id`
`jay_list_consumer_view`.`date_stat_active`
`jay_list_consumer_view`.`Address`
`jay_list_consumer_view`.`customer_name`
`lgu_book`.*
`lgu_book`.`book_id`
`lgu_book`.`book_desc`
`lgu_consumer_type`.*
`lgu_consumer_type`.`con_type_id`
`lgu_consumer_type`.`class_type`
`lgu_consumer_type`.`con_type_desc`
`lgu_consumer_type`.`short_desc`
`lgu_consumer_type`.`type`
`lgu_consumer_type`.`category`
`lgu_zone`.*
`lgu_zone`.`zone_id`
`lgu_zone`.`zone_num`
`lgu_zone`.`brgy_id`
`lgu_zone`.`book`
`lib_books`.*
`lib_books`.`book_code`
`lib_books`.`description`
`lib_books`.`username`
`lib_books`.`timestamp`
`lib_brand`.*
`lib_brand`.`rec_id`
`lib_brand`.`ref_desc`
`lib_meters`.*
`lib_meters`.`id`
`lib_meters`.`rec_id`
`lib_meters`.`brand_id`
`lib_meters`.`size_id`
`lib_meters`.`description`
`lib_meters`.`prefix`
`lib_meters`.`serial_no`
`lib_meters`.`active`
`lib_meters`.`cuid`
`lib_meters`.`muid`
`lib_meters`.`created`
`lib_sizes`.*
`lib_sizes`.`rec_id`
`lib_sizes`.`ref_code`
`lib_sizes`.`ref_desc`
`reading_migration`.*
`reading_migration`.`id`
`reading_migration`.`reader_id`
`reading_migration`.`readername`
`reading_migration`.`meter_no`
`reading_migration`.`reading`
`setup_formtype`.*
`setup_formtype`.`id`
`setup_formtype`.`type`
`setup_formtype`.`status`
`setup_formtype`.`form_id`
`setup_signatory`.*
`setup_signatory`.`signatory_id`
`setup_signatory`.`form_id`
`setup_signatory`.`setupType_id`
`setup_signatory`.`employee_id`
`setup_signatory`.`priority_no`
`setup_signatory`.`location`
`setup_signatory`.`title_id`
`setup_signatory`.`savedate`
`setup_signatory`.`status`
`setup_signatory`.`sig_display_name_id`
`setup_signatory`.`prefix`
`setup_signatory`.`suffix`
`setup_signatory`.`position`
`setup_signatorytype`.*
`setup_signatorytype`.`id`
`setup_signatorytype`.`type`
`tbl_restrict_print`.*
`tbl_restrict_print`.`comp_setup`
`tbl_restrict_print`.`comp_desc`
`temp_tbl_aging_account`.*
`temp_tbl_aging_account`.`id`
`temp_tbl_aging_account`.`app_no`
`temp_tbl_aging_account`.`amount`
`temp_tbl_aging_account`.`trans_date`
`temp_tbl_aging_account`.`no_days`
`temp_tbl_aging_account`.`t_type`
`temp_tbl_aging_account_summary`.*
`temp_tbl_aging_account_summary`.`id`
`temp_tbl_aging_account_summary`.`class_id`
`temp_tbl_aging_account_summary`.`Zone/Book`
`temp_tbl_aging_account_summary`.`Amount`
`temp_tbl_aging_account_summary`.`trans_date`
`temp_tbl_aging_account_summary`.`no_days`
`temp_tbl_aging_account_summary`.`t_type`
`ww_account_setup`.*
`ww_account_setup`.`id`
`ww_account_setup`.`description`
`ww_account_setup`.`income_acc_id`
`ww_account_setup`.`income_acc_code`
`ww_account_setup`.`income_acc_name`
`ww_account_setup`.`coa_id`
`ww_adjustments_setup`.*
`ww_adjustments_setup`.`id`
`ww_adjustments_setup`.`particular`
`ww_adjustments_setup`.`debit_accnt_id`
`ww_adjustments_setup`.`credit_accnt_id`
`ww_adjustments_setup`.`oth_charges`
`ww_adjustments_setup`.`type`
`ww_adjustments_setup`.`status`
`ww_adjustments_setup`.`paid_accnit`
`ww_aging_no_days`.*
`ww_aging_no_days`.`id`
`ww_aging_no_days`.`desc`
`ww_aging_no_days`.`min_days`
`ww_aging_no_days`.`max_days`
`ww_area_setup`.*
`ww_area_setup`.`id`
`ww_area_setup`.`dept`
`ww_area_setup`.`area`
`ww_area_setup`.`plumber`
`ww_billing_adjustment`.*
`ww_billing_adjustment`.`bam_id`
`ww_billing_adjustment`.`bill_id`
`ww_billing_adjustment`.`bam_no`
`ww_billing_adjustment`.`bam_date`
`ww_billing_adjustment`.`accnt_id`
`ww_billing_adjustment`.`acct_no`
`ww_billing_adjustment`.`account_type`
`ww_billing_adjustment`.`bill_date`
`ww_billing_adjustment`.`emp_meter_reader`
`ww_billing_adjustment`.`explnation`
`ww_billing_adjustment`.`date_saved`
`ww_billing_adjustment`.`pay_status`
`ww_billing_adjustment`.`status`
`ww_billing_adjustment`.`prepared_by`
`ww_billing_adjustment`.`cancelled_by`
`ww_billing_adjustment`.`cancelled_date`
`ww_billing_adjustment`.`posted_by`
`ww_billing_adjustment`.`posted_date`
`ww_billing_adjustment`.`JID`
`ww_billing_adjustment`.`bam_amount`
`ww_billing_adjustment`.`oth_credit`
`ww_billing_adjustment`.`with_bill`
`ww_billing_adjustment`.`bill_amount`
`ww_billing_adjustment`.`is_new_rate`
`ww_billing_adjustment_admin_tool`.*
`ww_billing_adjustment_admin_tool`.`bam_id`
`ww_billing_adjustment_admin_tool`.`bill_id`
`ww_billing_adjustment_admin_tool`.`bam_no`
`ww_billing_adjustment_admin_tool`.`bam_date`
`ww_billing_adjustment_admin_tool`.`accnt_id`
`ww_billing_adjustment_admin_tool`.`acct_no`
`ww_billing_adjustment_admin_tool`.`account_type`
`ww_billing_adjustment_admin_tool`.`bill_date`
`ww_billing_adjustment_admin_tool`.`emp_meter_reader`
`ww_billing_adjustment_admin_tool`.`explnation`
`ww_billing_adjustment_admin_tool`.`date_saved`
`ww_billing_adjustment_admin_tool`.`pay_status`
`ww_billing_adjustment_admin_tool`.`status`
`ww_billing_adjustment_admin_tool`.`prepared_by`
`ww_billing_adjustment_admin_tool`.`cancelled_by`
`ww_billing_adjustment_admin_tool`.`cancelled_date`
`ww_billing_adjustment_admin_tool`.`posted_by`
`ww_billing_adjustment_admin_tool`.`posted_date`
`ww_billing_adjustment_admin_tool`.`JID`
`ww_billing_adjustment_admin_tool`.`bam_amount`
`ww_billing_adjustment_admin_tool`.`oth_credit`
`ww_billing_adjustment_admin_tool`.`with_bill`
`ww_billing_adjustment_admin_tool`.`bill_amount`
`ww_billing_adjustment_detail`.*
`ww_billing_adjustment_detail`.`id`
`ww_billing_adjustment_detail`.`bam_id`
`ww_billing_adjustment_detail`.`particular_id`
`ww_billing_adjustment_detail`.`ref_id`
`ww_billing_adjustment_detail`.`original`
`ww_billing_adjustment_detail`.`should_be`
`ww_billing_adjustment_detail`.`adjusted`
`ww_billing_adjustment_detail`.`coa_id`
`ww_billing_adjustment_detail`.`accnt_id`
`ww_billing_adjustment_detail`.`amount`
`ww_billing_adjustment_detail`.`dr_cr`
`ww_billing_adjustment_detail`.`particular`
`ww_billing_adjustment_detail`.`change_class`
`ww_billing_adjustment_detail`.`class_id`
`ww_billing_adjustment_detail`.`date_saved`
`ww_billing_adjustment_detail`.`trans_type`
`ww_billing_adjustment_detail`.`payment_status`
`ww_change_class`.*
`ww_change_class`.`rec_id`
`ww_change_class`.`applicant_no`
`ww_change_class`.`original_accnt`
`ww_change_class`.`change_accnt_no`
`ww_change_class`.`from_class_id`
`ww_change_class`.`to_class_id`
`ww_change_class`.`change_class_date`
`ww_change_class`.`date_save`
`ww_change_meter`.*
`ww_change_meter`.`id`
`ww_change_meter`.`application_no`
`ww_change_meter`.`acct_no`
`ww_change_meter`.`meter_from`
`ww_change_meter`.`meter_idfrom`
`ww_change_meter`.`from_brand`
`ww_change_meter`.`current_reading`
`ww_change_meter`.`previous_reading`
`ww_change_meter`.`cubic_used`
`ww_change_meter`.`prev_date_installed`
`ww_change_meter`.`meter_to`
`ww_change_meter`.`meter_idto`
`ww_change_meter`.`to_brand`
`ww_change_meter`.`installation_date`
`ww_change_meter`.`initial_reading`
`ww_change_meter`.`installed_by`
`ww_change_meter`.`remarks`
`ww_change_meter`.`bill_id`
`ww_change_meter`.`date_save`
`ww_change_meter`.`type`
`ww_change_meter`.`mo_id`
`ww_complaint_billing`.*
`ww_complaint_billing`.`id`
`ww_complaint_billing`.`app_id`
`ww_complaint_billing`.`account_no`
`ww_complaint_billing`.`comp_id`
`ww_complaint_billing`.`complaint_desc`
`ww_complaint_billing`.`date_billed`
`ww_complaint_billing`.`timestamp`
`ww_complaint_billing`.`Status`
`ww_complaint_setup`.*
`ww_complaint_setup`.`complaint_id`
`ww_complaint_setup`.`complaint_desc`
`ww_complaint_setup`.`desc_work_id`
`ww_customer_application`.*
`ww_customer_application`.`Applicant_No`
`ww_customer_application`.`application_date`
`ww_customer_application`.`sequence_no`
`ww_customer_application`.`acct_no`
`ww_customer_application`.`zone_no`
`ww_customer_application`.`book_id`
`ww_customer_application`.`person_code`
`ww_customer_application`.`brgy_id`
`ww_customer_application`.`purok`
`ww_customer_application`.`house_number`
`ww_customer_application`.`street`
`ww_customer_application`.`village_district`
`ww_customer_application`.`district`
`ww_customer_application`.`city`
`ww_customer_application`.`province`
`ww_customer_application`.`route_no`
`ww_customer_application`.`phone_number`
`ww_customer_application`.`meter_id`
`ww_customer_application`.`lib_mter_id`
`ww_customer_application`.`meter_number`
`ww_customer_application`.`meter_size`
`ww_customer_application`.`type`
`ww_customer_application`.`class_id`
`ww_customer_application`.`classification`
`ww_customer_application`.`reading_sched`
`ww_customer_application`.`meter_type`
`ww_customer_application`.`discount`
`ww_customer_application`.`sen_cit`
`ww_customer_application`.`payment_order_id`
`ww_customer_application`.`image`
`ww_customer_application`.`mo_id`
`ww_customer_application`.`date_stat_active`
`ww_customer_application`.`timestamp`
`ww_customer_application`.`type_applied`
`ww_customer_application`.`include_pnalty`
`ww_customer_application`.`status`
`ww_customer_application_details`.*
`ww_customer_application_details`.`id`
`ww_customer_application_details`.`applicant_no`
`ww_customer_application_details`.`acct_no`
`ww_customer_application_details`.`employed`
`ww_customer_application_details`.`employer`
`ww_customer_application_details`.`emp_address`
`ww_customer_application_details`.`emp_status`
`ww_customer_application_details`.`annual_sal`
`ww_customer_application_details`.`spouse`
`ww_customer_application_details`.`other_income`
`ww_customer_application_details`.`other_spec`
`ww_customer_application_details`.`annual_inc`
`ww_customer_application_details`.`no_house_member`
`ww_customer_application_details`.`no_of_fam`
`ww_customer_application_details`.`con_type`
`ww_customer_application_details`.`con_size`
`ww_customer_application_details`.`tapping_desc`
`ww_customer_application_details`.`service_con_before`
`ww_customer_application_details`.`when_scb`
`ww_customer_application_details`.`legal_owner`
`ww_customer_application_details`.`who_own`
`ww_customer_application_details`.`willing_for_con`
`ww_customer_application_details`.`desired_con`
`ww_customer_application_details`.`other_desired`
`ww_customer_application_details`.`bday`
`ww_customer_application_details`.`age`
`ww_customer_application_details`.`civil_stat`
`ww_customer_application_details`.`phone_number`
`ww_customer_application_details`.`status`
`ww_customer_meter_details`.*
`ww_customer_meter_details`.`meter_id`
`ww_customer_meter_details`.`applicant_no`
`ww_customer_meter_details`.`acct_no`
`ww_customer_meter_details`.`customer_id`
`ww_customer_meter_details`.`serial_no`
`ww_customer_meter_details`.`meter_number`
`ww_customer_meter_details`.`meter_size`
`ww_customer_meter_details`.`installation_date`
`ww_customer_meter_details`.`inspection_date`
`ww_customer_meter_details`.`installed_by`
`ww_customer_meter_details`.`inspected_by`
`ww_customer_meter_details`.`OR_number`
`ww_customer_meter_details`.`service_status`
`ww_customer_meter_details`.`status`
`ww_customer_meter_details`.`meter_status`
`ww_customer_meter_details`.`meter_remarks`
`ww_customer_meter_details`.`barangay_address`
`ww_customer_meter_details`.`addressID`
`ww_customer_meter_details`.`OR_date`
`ww_customer_meter_details`.`customer_description`
`ww_customer_meter_details`.`brgy_id`
`ww_customer_meter_details`.`or_amount`
`ww_customer_meter_details`.`date_disconnected`
`ww_customer_meter_details`.`time_disconnected`
`ww_customer_meter_details`.`disconnected_by`
`ww_customer_meter_details`.`classification`
`ww_customer_meter_details`.`subName`
`ww_customer_meter_details`.`brand`
`ww_customer_meter_details`.`first_meter_reading`
`ww_customer_meter_details`.`last_meter_reading`
`ww_customer_meter_details`.`remarks`
`ww_customer_meter_details`.`re_connect`
`ww_customer_meter_details`.`date_re_connect`
`ww_customer_meter_details`.`transferred`
`ww_customer_meter_details`.`date_transferred`
`ww_customer_meter_details`.`timestamp`
`ww_customer_profile`.*
`ww_customer_profile`.`customer_id`
`ww_customer_profile`.`person_profile_id`
`ww_customer_profile`.`classification`
`ww_customer_profile`.`customer_name`
`ww_customer_profile`.`timestatmp`
`ww_desc_work`.*
`ww_desc_work`.`desc_work_id`
`ww_desc_work`.`work_desc`
`ww_desc_work`.`trans_type`
`ww_employee_withbenefit`.*
`ww_employee_withbenefit`.`id`
`ww_employee_withbenefit`.`applicant_no`
`ww_employee_withbenefit`.`emp_number`
`ww_employee_withbenefit`.`cum_benefit`
`ww_employee_withbenefit`.`amount`
`ww_employee_withbenefit`.`remarks`
`ww_employee_withbenefit`.`status`
`ww_employee_withbenefit`.`payroll_period`
`ww_employee_withbenefit`.`to_deduct`
`ww_employee_withbenefit`.`time_stamp`
`ww_guaranty_deposit`.*
`ww_guaranty_deposit`.`gd_id`
`ww_guaranty_deposit`.`applicant_no`
`ww_guaranty_deposit`.`account_id`
`ww_guaranty_deposit`.`guarantee_deposit`
`ww_guaranty_deposit`.`gd_ordate`
`ww_guaranty_deposit`.`gd_ornumber`
`ww_guaranty_deposit`.`status`
`ww_guaranty_deposit_details`.*
`ww_guaranty_deposit_details`.`gd_id_detail`
`ww_guaranty_deposit_details`.`gd_id`
`ww_guaranty_deposit_details`.`account_desc`
`ww_guaranty_deposit_details`.`amount`
`ww_inspectors`.*
`ww_inspectors`.`inspector_id`
`ww_inspectors`.`pp_person_code`
`ww_inspectors`.`inspector_name`
`ww_inspectors`.`date_saved`
`ww_maintenance_order`.*
`ww_maintenance_order`.`mo_id`
`ww_maintenance_order`.`applicant_no`
`ww_maintenance_order`.`person_id`
`ww_maintenance_order`.`type`
`ww_maintenance_order`.`complainant`
`ww_maintenance_order`.`address`
`ww_maintenance_order`.`assigned_from`
`ww_maintenance_order`.`remarks`
`ww_maintenance_order`.`tran_type`
`ww_maintenance_order`.`posted`
`ww_maintenance_order`.`pay_order_id`
`ww_maintenance_order`.`status`
`ww_maintenance_order_details`.*
`ww_maintenance_order_details`.`mo_detail_id`
`ww_maintenance_order_details`.`mo_id`
`ww_maintenance_order_details`.`mo_no`
`ww_maintenance_order_details`.`complaint`
`ww_maintenance_order_details`.`action_taken`
`ww_maintenance_order_details`.`date_of_complaint`
`ww_maintenance_order_details`.`plumber`
`ww_maintenance_order_details`.`date_assigned`
`ww_maintenance_order_details`.`date_accomplished`
`ww_maintenance_order_details`.`time_started`
`ww_maintenance_order_details`.`time_finished`
`ww_maintenance_order_details`.`remarks`
`ww_maintenance_order_details`.`serial_no`
`ww_maintenance_order_details`.`serial_id`
`ww_maintenance_order_details`.`brand`
`ww_maintenance_order_details`.`reading`
`ww_maintenance_order_details`.`last_reading`
`ww_maintenance_order_details`.`estimated_cost`
`ww_maintenance_order_details`.`status`
`ww_maintenance_order_details`.`assigned_to`
`ww_maintenance_order_details`.`foreman_remarks`
`ww_maintenance_order_details`.`area_id`
`ww_maintenance_order_details`.`ref`
`ww_maintenance_order_details`.`error`
`ww_maintenance_order_details`.`late`
`ww_maintenance_order_details`.`time_late`
`ww_maintenance_order_details`.`save_date`
`ww_offset`.*
`ww_offset`.`offset_id`
`ww_offset`.`ref_no`
`ww_offset`.`applicant_no`
`ww_offset`.`guarantee_dep`
`ww_offset`.`arears`
`ww_offset`.`guarantee_deposit_bal`
`ww_offset`.`offsetted_amount`
`ww_offset`.`trans_date`
`ww_offset`.`inc_accont_id`
`ww_offset`.`date_stamp`
`ww_offset`.`offset_stat`
`ww_offset`.`prep_by`
`ww_offset`.`JID`
`ww_offset_details`.*
`ww_offset_details`.`id`
`ww_offset_details`.`offset_id`
`ww_offset_details`.`account_id`
`ww_offset_details`.`particular`
`ww_offset_details`.`amount`
`ww_offset_details_admin_tool`.*
`ww_offset_details_admin_tool`.`id`
`ww_offset_details_admin_tool`.`offset_id`
`ww_offset_details_admin_tool`.`account_id`
`ww_offset_details_admin_tool`.`particular`
`ww_offset_details_admin_tool`.`amount`
`ww_other_charges`.*
`ww_other_charges`.`other_charges_id`
`ww_other_charges`.`ref`
`ww_other_charges`.`bill_no`
`ww_other_charges`.`applicant_no`
`ww_other_charges`.`coa_id`
`ww_other_charges`.`income_account_code`
`ww_other_charges`.`income_account_description`
`ww_other_charges`.`target_month`
`ww_other_charges`.`year`
`ww_other_charges`.`payable_in_months`
`ww_other_charges`.`charge_amount`
`ww_other_charges`.`adjustment`
`ww_other_charges`.`adj_status`
`ww_other_charges`.`date`
`ww_other_charges`.`date_stamp`
`ww_other_charges`.`status`
`ww_other_charges`.`remarks`
`ww_other_charges`.`payment_date`
`ww_other_charges`.`or_id`
`ww_other_charges`.`JID`
`ww_other_charges`.`cap`
`ww_other_charges`.`prep_by`
`ww_other_charges`.`cancelled_by`
`ww_other_charges`.`group_id`
`ww_other_charges_admin_tool`.*
`ww_other_charges_admin_tool`.`other_charges_id`
`ww_other_charges_admin_tool`.`ref`
`ww_other_charges_admin_tool`.`bill_no`
`ww_other_charges_admin_tool`.`applicant_no`
`ww_other_charges_admin_tool`.`coa_id`
`ww_other_charges_admin_tool`.`income_account_code`
`ww_other_charges_admin_tool`.`income_account_description`
`ww_other_charges_admin_tool`.`target_month`
`ww_other_charges_admin_tool`.`year`
`ww_other_charges_admin_tool`.`payable_in_months`
`ww_other_charges_admin_tool`.`charge_amount`
`ww_other_charges_admin_tool`.`adjustment`
`ww_other_charges_admin_tool`.`adj_status`
`ww_other_charges_admin_tool`.`date`
`ww_other_charges_admin_tool`.`date_stamp`
`ww_other_charges_admin_tool`.`status`
`ww_other_charges_admin_tool`.`remarks`
`ww_other_charges_admin_tool`.`payment_date`
`ww_other_charges_admin_tool`.`or_id`
`ww_other_charges_admin_tool`.`JID`
`ww_other_charges_admin_tool`.`cap`
`ww_other_charges_admin_tool`.`prep_by`
`ww_other_charges_admin_tool`.`cancelled_by`
`ww_other_charges_admin_tool`.`group_id`
`ww_other_charges_temp`.*
`ww_other_charges_temp`.`other_charges_id`
`ww_other_charges_temp`.`ref`
`ww_other_charges_temp`.`bill_no`
`ww_other_charges_temp`.`applicant_no`
`ww_other_charges_temp`.`coa_id`
`ww_other_charges_temp`.`income_account_code`
`ww_other_charges_temp`.`income_account_description`
`ww_other_charges_temp`.`target_month`
`ww_other_charges_temp`.`year`
`ww_other_charges_temp`.`payable_in_months`
`ww_other_charges_temp`.`charge_amount`
`ww_other_charges_temp`.`date`
`ww_other_charges_temp`.`date_stamp`
`ww_other_charges_temp`.`status`
`ww_other_charges_temp`.`remarks`
`ww_other_charges_temp`.`payment_date`
`ww_other_charges_temp`.`or_id`
`ww_other_charges_temp`.`JID`
`ww_other_charges_temp`.`cap`
`ww_other_charges_temp`.`prep_by`
`ww_other_charges_temp`.`cancelled_by`
`ww_other_charges_temp`.`group_id`
`ww_payment_employee_dtl`.*
`ww_payment_employee_dtl`.`id`
`ww_payment_employee_dtl`.`main_id`
`ww_payment_employee_dtl`.`jid`
`ww_payment_employee_dtl`.`app_no`
`ww_payment_employee_dtl`.`bill_no`
`ww_payment_employee_dtl`.`coa_id`
`ww_payment_employee_dtl`.`amount`
`ww_payment_employee_dtl`.`trans_date`
`ww_payment_employee_dtl`.`type`
`ww_payment_employee_dtl`.`tmstamp`
`ww_payment_order`.*
`ww_payment_order`.`payment_order_id`
`ww_payment_order`.`reference_no`
`ww_payment_order`.`applicant_no`
`ww_payment_order`.`person_id`
`ww_payment_order`.`type`
`ww_payment_order`.`total`
`ww_payment_order`.`prepared_by`
`ww_payment_order`.`date`
`ww_payment_order`.`remarks`
`ww_payment_order`.`pay_remarks`
`ww_payment_order`.`or_id`
`ww_payment_order`.`date_paid`
`ww_payment_order`.`date_stamp`
`ww_payment_order`.`cap`
`ww_payment_order`.`GID`
`ww_payment_order`.`JID`
`ww_payment_order`.`manual_pay`
`ww_payment_order_detail`.*
`ww_payment_order_detail`.`detail id`
`ww_payment_order_detail`.`payment_order_id`
`ww_payment_order_detail`.`account_id`
`ww_payment_order_detail`.`amount`
`ww_payment_order_detail`.`direct`
`ww_payments_employee`.*
`ww_payments_employee`.`id`
`ww_payments_employee`.`jid`
`ww_payments_employee`.`emp_id`
`ww_payments_employee`.`account_id`
`ww_payments_employee`.`amount`
`ww_payments_employee`.`date_trans`
`ww_payments_employee`.`pep_by`
`ww_payments_employee`.`time_stamp`
`ww_payments_employee`.`status`
`ww_penalty_list`.*
`ww_penalty_list`.`id`
`ww_penalty_list`.`app_id`
`ww_penalty_list`.`bill_no`
`ww_penalty_list`.`no_months`
`ww_penalty_list`.`service_fee`
`ww_penalty_list`.`service_charge`
`ww_penalty_list`.`penalty`
`ww_penalty_list`.`bill_month`
`ww_penalty_list`.`trans_date`
`ww_penalty_list`.`timestamp`
`ww_penalty_list`.`prep_by`
`ww_penalty_setup`.*
`ww_penalty_setup`.`penalty_id`
`ww_penalty_setup`.`penalty_desc`
`ww_penalty_setup`.`penalty_charge`
`ww_plumberaccomplishmenttarget`.*
`ww_plumberaccomplishmenttarget`.`id`
`ww_plumberaccomplishmenttarget`.`ratescale_desc_id`
`ww_plumberaccomplishmenttarget`.`ratescale_desc`
`ww_plumberaccomplishmenttarget`.`plumber`
`ww_plumberaccomplishmenttarget`.`target`
`ww_plumberaccomplishmenttarget`.`date_from`
`ww_plumberaccomplishmenttarget`.`date_to`
`ww_plumbersetup`.*
`ww_plumbersetup`.`id`
`ww_plumbersetup`.`emp_id`
`ww_plumbersetup`.`person_id`
`ww_plumbersetup`.`plumber_name`
`ww_promissory`.*
`ww_promissory`.`promissory_id`
`ww_promissory`.`reference_no`
`ww_promissory`.`applicant_no`
`ww_promissory`.`date`
`ww_promissory`.`date_tobe_paid`
`ww_promissory`.`approved_by`
`ww_promissory`.`status`
`ww_promissory`.`bill_no`
`ww_promissory`.`arrears`
`ww_rating_scale_setup`.*
`ww_rating_scale_setup`.`ratingscale_id`
`ww_rating_scale_setup`.`minimum_rate`
`ww_rating_scale_setup`.`maximum_rate`
`ww_rating_scale_setup`.`score`
`ww_rating_scale_setup`.`rate_desc`
`ww_reconnection`.*
`ww_reconnection`.`rec_id`
`ww_reconnection`.`person_id`
`ww_reconnection`.`applicant_no`
`ww_reconnection`.`type`
`ww_reconnection`.`address`
`ww_reconnection`.`initial_reading`
`ww_reconnection`.`balance`
`ww_reconnection`.`brand`
`ww_reconnection`.`serial_id`
`ww_reconnection`.`serial`
`ww_reconnection`.`reconnected_date`
`ww_reconnection`.`reconnected_by`
`ww_reconnection`.`tmestamp`
`ww_senior_citizen_discount`.*
`ww_senior_citizen_discount`.`sen_cit_id`
`ww_senior_citizen_discount`.`app_no`
`ww_senior_citizen_discount`.`acct_no`
`ww_senior_citizen_discount`.`dis_percentage`
`ww_senior_citizen_discount`.`consumer_id`
`ww_senior_citizen_discount`.`date_applied`
`ww_senior_citizen_discount`.`date_expire`
`ww_senior_citizen_discount`.`approved`
`ww_senior_citizen_discount`.`approved_by`
`ww_senior_citizen_discount`.`status`
`ww_senior_citizen_discount`.`osca_id_no`
`ww_senior_citizen_discount`.`birthdate`
`ww_senior_citizen_discount`.`remarks`
`ww_senior_citizen_discount`.`address`
`ww_senior_citizen_discount_logs`.*
`ww_senior_citizen_discount_logs`.`dtl_id`
`ww_senior_citizen_discount_logs`.`sen_cit_id`
`ww_senior_citizen_discount_logs`.`app_no`
`ww_senior_citizen_discount_logs`.`acct_no`
`ww_senior_citizen_discount_logs`.`dis_percentage`
`ww_senior_citizen_discount_logs`.`consumer_id`
`ww_senior_citizen_discount_logs`.`date_applied`
`ww_senior_citizen_discount_logs`.`date_expire`
`ww_senior_citizen_discount_logs`.`approved`
`ww_senior_citizen_discount_logs`.`approved_by`
`ww_senior_citizen_discount_logs`.`status`
`ww_senior_citizen_discount_logs`.`osca_id_no`
`ww_senior_citizen_discount_logs`.`birthdate`
`ww_senior_citizen_discount_logs`.`remarks`
`ww_senior_citizen_discount_logs`.`address`
`ww_transfer`.*
`ww_transfer`.`transfer_id`
`ww_transfer`.`applicant_no_from`
`ww_transfer`.`applicant_no_to`
`ww_transfer`.`transferred_from`
`ww_transfer`.`transferred_to`
`ww_transfer`.`transferred_date`
`ww_transfer`.`from_type`
`ww_transfer`.`to_type`
`ww_type`.*
`ww_type`.`id`
`ww_type`.`desc`
`ww_type`.`code`
`ww_type`.`type`
`ww_type`.`legend`
`ww_type`.`comment`
`ww_water_billing`.*
`ww_water_billing`.`bill_number`
`ww_water_billing`.`main_id`
`ww_water_billing`.`cust_bill_number`
`ww_water_billing`.`application_no`
`ww_water_billing`.`acct_no`
`ww_water_billing`.`customer_id`
`ww_water_billing`.`meter_id`
`ww_water_billing`.`meter_number`
`ww_water_billing`.`meter_reader_id`
`ww_water_billing`.`guarantee_deposit`
`ww_water_billing`.`advance_amount`
`ww_water_billing`.`bill_from`
`ww_water_billing`.`bill_to`
`ww_water_billing`.`billing_date`
`ww_water_billing`.`due_date`
`ww_water_billing`.`prev_consumption`
`ww_water_billing`.`present_consumption`
`ww_water_billing`.`ave_consumption`
`ww_water_billing`.`prev_meter_reading`
`ww_water_billing`.`present_meter_reading`
`ww_water_billing`.`cut_off_cum`
`ww_water_billing`.`cubic_meter_consumed`
`ww_water_billing`.`last_payment_date`
`ww_water_billing`.`basicCharge`
`ww_water_billing`.`total`
`ww_water_billing`.`total_unpaid_amount`
`ww_water_billing`.`adjustment`
`ww_water_billing`.`adj_status`
`ww_water_billing`.`remarks`
`ww_water_billing`.`pay_remarks`
`ww_water_billing`.`b_or_id`
`ww_water_billing`.`b_or_number`
`ww_water_billing`.`b_or_date`
`ww_water_billing`.`b_or_amount`
`ww_water_billing`.`entry_status`
`ww_water_billing`.`JID`
`ww_water_billing`.`coa_id`
`ww_water_billing`.`date_saved`
`ww_water_billing`.`exp_id`
`ww_water_billing`.`explanation`
`ww_water_billing`.`penalty_date`
`ww_water_billing`.`penalty_stat`
`ww_water_billing`.`cancel_remarks`
`ww_water_billing`.`bill_type`
`ww_water_billing`.`sen_cit`
`ww_water_billing`.`adj_type`
`ww_water_billing`.`adj_reading`
`ww_water_billing_assgn_reader`.*
`ww_water_billing_assgn_reader`.`id`
`ww_water_billing_assgn_reader`.`zone_id`
`ww_water_billing_assgn_reader`.`book_id`
`ww_water_billing_assgn_reader`.`brgy_id`
`ww_water_billing_assgn_reader`.`meter_reader_id`
`ww_water_billing_assgn_reader`.`bill_month`
`ww_water_billing_assgn_reader`.`reding_sche`
`ww_water_billing_assgn_reader`.`date_save`
`ww_water_billing_assgn_reader_dtl`.*
`ww_water_billing_assgn_reader_dtl`.`id`
`ww_water_billing_assgn_reader_dtl`.`main_id`
`ww_water_billing_assgn_reader_dtl`.`app_no`
`ww_water_billing_assgn_reader_dtl`.`bill_number`
`ww_water_billing_assgn_reader_dtl`.`read`
`ww_water_billing_assgn_reader_dtl`.`bill_status`
`ww_water_billing_assgn_reader_dtl`.`date_save`
`ww_ww_cust_list_old`.*
`ww_ww_cust_list_old`.`id`
`ww_ww_cust_list_old`.`acct_no`
`ww_ww_cust_list_old`.`sequence_no`
`ww_ww_cust_list_old`.`consumer_name`
`ww_ww_cust_list_old`.`address`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
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_payment_employee_dtl
ww_payment_order
ww_payment_order_detail
ww_payments_employee
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
SQL query on database
qpsii_waterworks
:
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.