* id faas_bldg_id PKTransID floor_no item percent_value base_value area total ts userid cur_userid cur_date cur_uiid

* ID FASSID GUID PKTransID ClassID ActualUseID BldgTypeID StructuralID Taxable ExemptionID ExemptionDesc UnitCost TotalArea TotalBaseAmount BasePercent BaseAmount SubTotalBase DepPercentBase DepAmountBase Additional AdditionalPercent AdditionalAmount TotalDeduction TotalCons MarketValue AssessmentLvl AssessmentAmount mv_override av_override cur_userid cur_date cur_uiid

* FAASID GUID PKTransID FloorNo FloorId Description Area UnitCost Percent TotalCost ts userid cur_userid cur_date cur_uiid

* FaasId FloorId FloorArea UserId ts cur_userid cur_date cur_uiid

* faas_bldg_id faas_id ref_td_id ap_td_no bldg_permit_id cct bldg_age no_of_storey total_flr_area total_land_area uconst_cost prop_app_remarks dep_rate dep_cost addtnl_item dedctnl_item total_const_cost total_prcnt_dep total_market_value description descriptionid others date_constructed date_completed date_occupied date_issued CCI_on COI_on structural_type structural_type_id land_owner 1stflr 2ndflr 3rdflr 4thflr cur_userid cur_date cur_uiid

* id faas_bldg_id PKTransID floor_no deduction_item percentage cur_userid cur_date cur_uiid

* faas_bldg_dtl_id faas_bldg_id no_of_floor area_of_floor roof_material floor_material walls_n_partition ceiling_material structural_parts material_use kind Ucost cur_userid cur_date cur_uiid

* faas_land_id faas_id PKGUID PKTransID sub_classID sub_classification area unit_value percent market_value class_name isCalculated cur_userid cur_date cur_uiid

* faas_land_dtl_id faas_id PKGUID PKTransID kind kindID improvement_area total_no unit_value percent market_value cur_userid cur_date cur_uiid

* dtl_id faas_id PKGUID PKTransID market_value adjustment_factor area perc_adjustment value_adjustment adj_marketvalue adj_type isupdated cur_userid cur_date cur_uiid

* faas_mach_id faas_id PKTransID kindmachinery brand_model qty capacity_hp date_acquired condition conditioned no_of_yrs estimated_yrs remaining_yrs yr_installed yr_operated original_cost conv_factor rcn yrs_used rate_of_depreciation total_dep_prcnt total_dep_value dep_value dep_net_value remarks userid dateSave cur_userid cur_date cur_uiid

* dtl_id faas_id land_tdid land_tdno land_owner land_pinprov land_pincitymun land_pinbrgy land_pinsection land_pinparcel land_pinext bldg_tdid bldg_tdno bldg_owner bldg_pinprov bldg_pincitymun bldg_pinbrgy bldg_pinsection bldg_pinparcel bldg_pinext cur_userid cur_date cur_uiid

* prev_td_dtl_id prev_td_id prev_td_faas_id new_faas_id new_td_id new_TDNo ARPNo TDNo Owner Location LotNo Area PIN Year TitleNo Memo EffectYear MarketValue AssessedValue merge_stat cur_userid cur_date cur_uiid

* faas_id faas_num faas_num_con_sub arp_prov arp_city_mun arp_brgy arp_no pin_prov pin_city_mun pin_brgy pin_section pin_parcel pin_ext owner_name owner_address owner_address_mun owner_address_prov_id owner_tin owner_tel_no beneficial_name beneficial_address beneficial_address_mun beneficial_tin beneficial_tel_no property_address property_address_mun survey_no lot_no cad_lot_no blk_no north south east west prop_type prop_type1 property_classification_id property_classification area_slash total_area_landOrBuilding tot_assessed_value tot_market_value tax_type quarter year prev_td appraised_by date_appraised recommend_by date_recommend approved_by date_approved recorded_by date_recorded PersonRecording PersonRecordingDate memoranda faas_status owner_address_brgy owner_address_city_mun owner_address_prov beneficial_address_brgy beneficial_address_city_mun beneficial_address_prov property_address_brgy property_address_city_mun property_address_prov property_address_brgy_id property_address_city_mun_id property_address_prov_id prev_td_prov prev_td_city_mun prev_td_no prev_td_ext saved_by_id modified_by_id saved_date modified_date octtctcloa_no oct_date new_td_id owner_add_st bene_add_st prop_add_st owner_type fdate_saved annotation annotation_type transaction_code adjustment_reason adjustment_type adjustment_amnt IsImprovement ImprovementDesc previous_tdno present_tdno arp_no1 revision_id rptax_id agri importedID migrated ratbookID for_computation printed_name cur_userid cur_date cur_uiid

* ecao_faas_dtl_id ecao_faas_id PKGUID PKTransID classid classification sub_class_id sub_class actual_use actual_use_id taxable tax_type dtl_area unit_value market_value adjustment_value adj_market_value assessment_level assessed_value isupdated mv_override av_override cur_uiid cur_userid cur_date

select table ecao_bldg_additional_item ecao_bldg_assessment ecao_bldg_construction ecao_bldg_floor_area ecao_faas_bldg ecao_faas_bldg_deduction_item ecao_faas_bldg_dtl ecao_faas_land ecao_faas_land_dtl ecao_faas_land_value_adj ecao_faas_mach ecao_faas_mach_dtl ecao_faas_prevtd_dtl ecao_faas_profile ecao_faas_profile_dtl . 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 ecao_bldg_additional_item ecao_bldg_assessment ecao_bldg_construction ecao_bldg_floor_area ecao_faas_bldg ecao_faas_bldg_deduction_item ecao_faas_bldg_dtl ecao_faas_land ecao_faas_land_dtl ecao_faas_land_value_adj ecao_faas_mach ecao_faas_mach_dtl ecao_faas_prevtd_dtl ecao_faas_profile ecao_faas_profile_dtl .	select column