임대관리_1
테이블 (22)
mr_calbal (CopyOf임대료관리비 입금내역2)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- mntn_rent_gb — varchar(1) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- bal_amt — int8
- arr_dd — int4
- arr_amt — int8
- arr_rate — float4
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- forcing_yn — varchar(1)
- arrear_amt — int8
mr_calbal (CopyOf임대료관리비 입금내역)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- mntn_rent_gb — varchar(1) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- bal_amt — int8
- arr_dd — int4
- arr_amt — int8
- arr_rate — float4
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- forcing_yn — varchar(1)
- arrear_amt — int8
mr_calbal (임대료관리비 입금내역)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- mntn_rent_gb — varchar(1) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- bal_amt — int8
- arr_dd — int4
- arr_amt — int8
- arr_rate — float4
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- forcing_yn — varchar(1)
- arrear_amt — int8
mr_calitem (월관리비항목별정산내역)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- str_cd — varchar(2) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- mntn_item_cd — varchar(2) — 기본 키 — NOT NULL
- use_qty — float8
- use_amt — int8
- bas_amt — int8
- cost_amt — float8
- fuelset_pr — float8
- discount_amt — int8
- rever_amt — int8
- electr_trans_dis — int8
- pwr_fund — int8
- bas_unit_cut — int4
- tv_amt — int4
- vat_amt — int8
- total_amt — int8
- remark — varchar(2000)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- sum_qty — float8
- mod_use_amt — int8
- use_amt_novat — int8
- use_amt_vat — int8
mr_calmst (월관리비정산내역)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- mntn_cal_yn — varchar(1)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- rent_amt — int8
- rent_vat_amt — int8
- tax_amt — int8
- tax_vat_amt — int8
- ntax_amt — int8
- bal_amt — int8
- arrear_amt — int8
- tot_bal_amt — int8
- chrg_amt — int8
- mod_reas_dt — varchar(8)
- mod_reason — varchar(2)
- mod_emp_no — varchar(10)
- mod_amt — int8
- real_chareg_amt — int8
- pay_term_dt — varchar(8)
- pay_flag — varchar(1)
- sap_if_flag — varchar(1)
- tax_issue_rent — varchar(24)
- tax_issue_mgr — varchar(24)
- tax_issue_mgrntax — varchar(24)
- tax_issue_commis — varchar(24)
- close_yn — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- rent_pay_term_dt — varchar(8)
- mod_arrear_amt — int8
- mod_tot_bal_amt — int8
- rent_bal_amt — int8
- rent_arrear_amt — int8
- rent_tot_bal_amt — int8
- mod_rent_arrear_amt — int8
- mod_rent_tot_bal_amt — int8
- rent_real_chareg_amt — int8
- chrg_dt — varchar(8)
- rent_cal_yn — varchar(1)
- arr_cal_yn — varchar(1)
- arr_rate — float8
- rent_arr_cal_yn — varchar(1)
- rent_arr_rate — float8
- rent_pay_flag — varchar(1)
- rent_sap_if_flag — varchar(1)
- … +4
mr_calmst (CopyOfCopyOf월관리비정산내역2)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- mntn_cal_yn — varchar(1)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- rent_amt — int8
- rent_vat_amt — int8
- tax_amt — int8
- tax_vat_amt — int8
- ntax_amt — int8
- bal_amt — int8
- arrear_amt — int8
- tot_bal_amt — int8
- chrg_amt — int8
- mod_reas_dt — varchar(8)
- mod_reason — varchar(2)
- mod_emp_no — varchar(10)
- mod_amt — int8
- real_chareg_amt — int8
- pay_term_dt — varchar(8)
- pay_flag — varchar(1)
- sap_if_flag — varchar(1)
- tax_issue_rent — varchar(24)
- tax_issue_mgr — varchar(24)
- tax_issue_mgrntax — varchar(24)
- tax_issue_commis — varchar(24)
- close_yn — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- rent_pay_term_dt — varchar(8)
- mod_arrear_amt — int8
- mod_tot_bal_amt — int8
- rent_bal_amt — int8
- rent_arrear_amt — int8
- rent_tot_bal_amt — int8
- mod_rent_arrear_amt — int8
- mod_rent_tot_bal_amt — int8
- rent_real_chareg_amt — int8
- chrg_dt — varchar(8)
- rent_cal_yn — varchar(1)
- arr_cal_yn — varchar(1)
- arr_rate — float8
- rent_arr_cal_yn — varchar(1)
- rent_arr_rate — float8
- rent_pay_flag — varchar(1)
- rent_sap_if_flag — varchar(1)
- … +4
mr_calmst (CopyOf월관리비정산내역)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- mntn_cal_yn — varchar(1)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- rent_amt — int8
- rent_vat_amt — int8
- tax_amt — int8
- tax_vat_amt — int8
- ntax_amt — int8
- bal_amt — int8
- arrear_amt — int8
- tot_bal_amt — int8
- chrg_amt — int8
- mod_reas_dt — varchar(8)
- mod_reason — varchar(2)
- mod_emp_no — varchar(10)
- mod_amt — int8
- real_chareg_amt — int8
- pay_term_dt — varchar(8)
- pay_flag — varchar(1)
- sap_if_flag — varchar(1)
- tax_issue_rent — varchar(24)
- tax_issue_mgr — varchar(24)
- tax_issue_mgrntax — varchar(24)
- tax_issue_commis — varchar(24)
- close_yn — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- rent_pay_term_dt — varchar(8)
- mod_arrear_amt — int8
- mod_tot_bal_amt — int8
- rent_bal_amt — int8
- rent_arrear_amt — int8
- rent_tot_bal_amt — int8
- mod_rent_arrear_amt — int8
- mod_rent_tot_bal_amt — int8
- rent_real_chareg_amt — int8
- chrg_dt — varchar(8)
- rent_cal_yn — varchar(1)
- arr_cal_yn — varchar(1)
- arr_rate — float8
- rent_arr_cal_yn — varchar(1)
- rent_arr_rate — float8
- rent_pay_flag — varchar(1)
- rent_sap_if_flag — varchar(1)
- … +4
mr_calmst (CopyOfCopyOf월관리비정산내역)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- mntn_cal_yn — varchar(1)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- rent_amt — int8
- rent_vat_amt — int8
- tax_amt — int8
- tax_vat_amt — int8
- ntax_amt — int8
- bal_amt — int8
- arrear_amt — int8
- tot_bal_amt — int8
- chrg_amt — int8
- mod_reas_dt — varchar(8)
- mod_reason — varchar(2)
- mod_emp_no — varchar(10)
- mod_amt — int8
- real_chareg_amt — int8
- pay_term_dt — varchar(8)
- pay_flag — varchar(1)
- sap_if_flag — varchar(1)
- tax_issue_rent — varchar(24)
- tax_issue_mgr — varchar(24)
- tax_issue_mgrntax — varchar(24)
- tax_issue_commis — varchar(24)
- close_yn — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- rent_pay_term_dt — varchar(8)
- mod_arrear_amt — int8
- mod_tot_bal_amt — int8
- rent_bal_amt — int8
- rent_arrear_amt — int8
- rent_tot_bal_amt — int8
- mod_rent_arrear_amt — int8
- mod_rent_tot_bal_amt — int8
- rent_real_chareg_amt — int8
- chrg_dt — varchar(8)
- rent_cal_yn — varchar(1)
- arr_cal_yn — varchar(1)
- arr_rate — float8
- rent_arr_cal_yn — varchar(1)
- rent_arr_rate — float8
- rent_pay_flag — varchar(1)
- rent_sap_if_flag — varchar(1)
- … +4
mr_calpay (CopyOf임대료미수관리2)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- mntn_rent_gb — varchar(1) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- pay_seq_no — int2 — 기본 키 — NOT NULL
- pay_dt — varchar(8)
- pay_amt — int8
- pay_arr_amt — int8
- remark — varchar(100)
- sap_if_flag — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
mr_calpay (CopyOf임대료미수관리)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- mntn_rent_gb — varchar(1) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- pay_seq_no — int2 — 기본 키 — NOT NULL
- pay_dt — varchar(8)
- pay_amt — int8
- pay_arr_amt — int8
- remark — varchar(100)
- sap_if_flag — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
mr_calpay (임대료미수관리)
- cal_ym — varchar(6) — 기본 키 — NOT NULL
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- mntn_rent_gb — varchar(1) — 기본 키 — NOT NULL
- cal_type — varchar(1) — 기본 키 — NOT NULL
- pay_seq_no — int2 — 기본 키 — NOT NULL
- pay_dt — varchar(8)
- pay_amt — int8
- pay_arr_amt — int8
- remark — varchar(100)
- sap_if_flag — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
mr_cntrhst (임대계약이력)
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- seq_no — int2 — 기본 키 — NOT NULL
- str_cd — varchar(2)
- ven_cd — varchar(6)
- rent_type — varchar(2)
- rent_flag — varchar(1)
- sap_cntr_id — varchar(20)
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dangi — varchar(40)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- char_name — varchar(40)
- phone1_no — varchar(32)
- phone2_no — varchar(32)
- phone3_no — varchar(32)
- file_path — varchar(100)
- mntn_cal_yn — varchar(1)
- pwr_kind_cd — varchar(2)
- pwr_type — varchar(1)
- pwr_sel_charge — varchar(1)
- pwr_cntr_qty — int4
- pwr_dc_type — varchar(1)
- pwr_rever_rate — float8
- pwr_redu_type — varchar(1)
- wwtr_kind_cd — varchar(2)
- wwtr_charge_yn — varchar(1)
- stm_kind_cd — varchar(2)
- cwtr_kind_cd — varchar(2)
- gas_kind_cd — varchar(2)
- gas_redu_type — varchar(1)
- wtr_kind_cd — varchar(2)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- cntr_can_dt — varchar(8)
- cntr_can_reas_cd — varchar(2)
- rtrn_amt — int8
- add_ded_amt — int8
- add_ded_reason — varchar(200)
- cntr_can_slip_no — varchar(40)
- belong_str_cd — varchar(2)
- div_rate — float4
- wwtr_qty — float8
- cwtr_qty — float8
- stm_qty — float8
- wtr_cal_size — varchar(2)
- pay_flag — varchar(1)
- remark — varchar(100)
- tv_cnt — int2
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- … +13
mr_cntrmst (CopyOfCopyOf임대계약마스터)
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- str_cd — varchar(2)
- ven_cd — varchar(6)
- rent_type — varchar(2)
- rent_flag — varchar(1)
- sap_cntr_id — varchar(20)
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dangi — varchar(40)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- char_name — varchar(40)
- phone1_no — varchar(32)
- phone2_no — varchar(32)
- phone3_no — varchar(32)
- file_path — varchar(100)
- mntn_cal_yn — varchar(1)
- pwr_kind_cd — varchar(2)
- pwr_type — varchar(1)
- pwr_sel_charge — varchar(1)
- pwr_cntr_qty — int4
- pwr_rever_rate — float8
- pwr_dc_type — varchar(1)
- pwr_redu_type — varchar(1)
- wwtr_kind_cd — varchar(2)
- wwtr_charge_yn — varchar(1)
- stm_kind_cd — varchar(2)
- cwtr_kind_cd — varchar(2)
- gas_kind_cd — varchar(2)
- gas_redu_type — varchar(1)
- wtr_kind_cd — varchar(2)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- cntr_can_dt — varchar(8)
- cntr_can_reas_cd — varchar(2)
- rtrn_amt — int8
- add_ded_amt — int8
- add_ded_reason — varchar(200)
- cntr_can_slip_no — varchar(40)
- belong_str_cd — varchar(2)
- wwtr_qty — float8
- cwtr_qty — float8
- stm_qty — float8
- div_rate — float4
- org_cntr_id — varchar(8)
- wtr_cal_size — varchar(2)
- pay_flag — varchar(1)
- remark — varchar(100)
- tv_cnt — int2
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- … +13
mr_cntrmst (CopyOf임대계약마스터)
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- str_cd — varchar(2)
- ven_cd — varchar(6)
- rent_type — varchar(2)
- rent_flag — varchar(1)
- sap_cntr_id — varchar(20)
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dangi — varchar(40)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- char_name — varchar(40)
- phone1_no — varchar(32)
- phone2_no — varchar(32)
- phone3_no — varchar(32)
- file_path — varchar(100)
- mntn_cal_yn — varchar(1)
- pwr_kind_cd — varchar(2)
- pwr_type — varchar(1)
- pwr_sel_charge — varchar(1)
- pwr_cntr_qty — int4
- pwr_rever_rate — float8
- pwr_dc_type — varchar(1)
- pwr_redu_type — varchar(1)
- wwtr_kind_cd — varchar(2)
- wwtr_charge_yn — varchar(1)
- stm_kind_cd — varchar(2)
- cwtr_kind_cd — varchar(2)
- gas_kind_cd — varchar(2)
- gas_redu_type — varchar(1)
- wtr_kind_cd — varchar(2)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- cntr_can_dt — varchar(8)
- cntr_can_reas_cd — varchar(2)
- rtrn_amt — int8
- add_ded_amt — int8
- add_ded_reason — varchar(200)
- cntr_can_slip_no — varchar(40)
- belong_str_cd — varchar(2)
- wwtr_qty — float8
- cwtr_qty — float8
- stm_qty — float8
- div_rate — float4
- org_cntr_id — varchar(8)
- wtr_cal_size — varchar(2)
- pay_flag — varchar(1)
- remark — varchar(100)
- tv_cnt — int2
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- … +13
mr_cntrmst (CopyOfCopyOfCopyOf임대계약마스터)
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- str_cd — varchar(2)
- ven_cd — varchar(6)
- rent_type — varchar(2)
- rent_flag — varchar(1)
- sap_cntr_id — varchar(20)
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dangi — varchar(40)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- char_name — varchar(40)
- phone1_no — varchar(32)
- phone2_no — varchar(32)
- phone3_no — varchar(32)
- file_path — varchar(100)
- mntn_cal_yn — varchar(1)
- pwr_kind_cd — varchar(2)
- pwr_type — varchar(1)
- pwr_sel_charge — varchar(1)
- pwr_cntr_qty — int4
- pwr_rever_rate — float8
- pwr_dc_type — varchar(1)
- pwr_redu_type — varchar(1)
- wwtr_kind_cd — varchar(2)
- wwtr_charge_yn — varchar(1)
- stm_kind_cd — varchar(2)
- cwtr_kind_cd — varchar(2)
- gas_kind_cd — varchar(2)
- gas_redu_type — varchar(1)
- wtr_kind_cd — varchar(2)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- cntr_can_dt — varchar(8)
- cntr_can_reas_cd — varchar(2)
- rtrn_amt — int8
- add_ded_amt — int8
- add_ded_reason — varchar(200)
- cntr_can_slip_no — varchar(40)
- belong_str_cd — varchar(2)
- wwtr_qty — float8
- cwtr_qty — float8
- stm_qty — float8
- div_rate — float4
- org_cntr_id — varchar(8)
- wtr_cal_size — varchar(2)
- pay_flag — varchar(1)
- remark — varchar(100)
- tv_cnt — int2
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- … +13
mr_cntrmst (임대계약마스터)
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- str_cd — varchar(2)
- ven_cd — varchar(6)
- rent_type — varchar(2)
- rent_flag — varchar(1)
- sap_cntr_id — varchar(20)
- cntr_area — float8
- excl_area — float8
- shr_area — float8
- rent_deposit — int8
- mm_rentfee — int8
- cntr_s_dt — varchar(8)
- cntr_e_dt — varchar(8)
- cntr_type — varchar(2)
- dangi — varchar(40)
- dong — varchar(3)
- floor_flag — varchar(2)
- ho — varchar(4)
- char_name — varchar(40)
- phone1_no — varchar(32)
- phone2_no — varchar(32)
- phone3_no — varchar(32)
- file_path — varchar(100)
- mntn_cal_yn — varchar(1)
- pwr_kind_cd — varchar(2)
- pwr_type — varchar(1)
- pwr_sel_charge — varchar(1)
- pwr_cntr_qty — int4
- pwr_rever_rate — float8
- pwr_dc_type — varchar(1)
- pwr_redu_type — varchar(1)
- wwtr_kind_cd — varchar(2)
- wwtr_charge_yn — varchar(1)
- stm_kind_cd — varchar(2)
- cwtr_kind_cd — varchar(2)
- gas_kind_cd — varchar(2)
- gas_redu_type — varchar(1)
- wtr_kind_cd — varchar(2)
- chrg_yn — varchar(1)
- pay_yn — varchar(1)
- cntr_can_dt — varchar(8)
- cntr_can_reas_cd — varchar(2)
- rtrn_amt — int8
- add_ded_amt — int8
- add_ded_reason — varchar(200)
- cntr_can_slip_no — varchar(40)
- belong_str_cd — varchar(2)
- wwtr_qty — float8
- cwtr_qty — float8
- stm_qty — float8
- div_rate — float4
- org_cntr_id — varchar(8)
- wtr_cal_size — varchar(2)
- pay_flag — varchar(1)
- remark — varchar(100)
- tv_cnt — int2
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- … +13
mr_depospay (임대보증금 입금내역)
- cntr_id — varchar(8) — 기본 키 — NOT NULL
- pay_seq_no — int2 — 기본 키 — NOT NULL
- pay_dt — varchar(8)
- pay_amt — int8
- pay_slip_no — varchar(40)
- if_flag — varchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
mr_fclmst (시설별관리기준)
- str_cd — varchar(2) — 기본 키 — NOT NULL
- huse_flag — varchar(1)
- area — float8
- excl_area — float8
- shr_area — float8
- area_flag — varchar(2)
- org_cd — varchar(10)
- use_yn — varchar(1)
- pwr_cal_yn — varchar(1)
- warmwtr_cal_yn — varchar(1)
- steam_cal_yn — varchar(1)
- coldwtr_cal_yn — varchar(1)
- wtrworks_cal_yn — varchar(1)
- graywtr_cal_yn — varchar(1)
- gas_cal_yn — varchar(1)
- pub_div_rate — varchar(1)
- wwtr_cntr_qty — float8
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
mr_mntnitem (관리비항목)
- str_cd — varchar(2) — 기본 키 — NOT NULL
- mntn_item_cd — varchar(2) — 기본 키 — NOT NULL
- mntn_item_nm — varchar(40)
- mntn_type — varchar(2)
- mntn_flag — varchar(1)
- cal_cd — varchar(2)
- cal_type — varchar(1)
- area_unit_prc — int4
- tax_inv_flag — varchar(1)
- sort_no — int4
- auto_div_yn — varchar(1)
- auto_div_item — varchar(2)
- pub_app_rate — float4
- use_yn — bpchar(1)
- reg_id — varchar(10)
- reg_date — timestamp
- mod_id — varchar(10)
- mod_date — timestamp
- remark — varchar(200)
pc_venmst (CopyOf협력사마스터)
- ven_cd — varchar(6) — 기본 키 — NOT NULL
- ven_name — varchar(40)
- ven_short_name — varchar(20)
- buy_sale_flag — varchar(1)
- biz_type — varchar(1)
- biz_flag — varchar(2)
- rep_ven_cd — varchar(6)
- buy_acc_ven_cd — varchar(10)
- sale_acc_ven_cd — varchar(10)
- comp_flag — varchar(1)
- etax_issue_flag — varchar(1)
- rvs_issue_flag — varchar(1)
- ocomp_tax_id — varchar(15)
- edi_yn — varchar(1)
- comp_no — varchar(10)
- corp_no — varchar(13)
- comp_name — varchar(40)
- biz_stat — varchar(40)
- biz_cat — varchar(40)
- rep_name — varchar(40)
- post_no — varchar(6)
- post_seq — int4
- addr — varchar(80)
- dtl_addr — varchar(80)
- phone1_no — varchar(4)
- phone2_no — varchar(4)
- phone3_no — varchar(4)
- fax1_no — varchar(4)
- fax2_no — varchar(4)
- fax3_no — varchar(4)
- biz_s_dt — varchar(8)
- biz_e_dt — varchar(8)
- use_yn — varchar(1)
- sap_del_flag — varchar(1)
- sap_if_date — timestamp
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pc_venmst (CopyOfCopyOf협력사마스터)
- ven_cd — varchar(6) — 기본 키 — NOT NULL
- ven_name — varchar(40)
- ven_short_name — varchar(20)
- buy_sale_flag — varchar(1)
- biz_type — varchar(1)
- biz_flag — varchar(2)
- rep_ven_cd — varchar(6)
- buy_acc_ven_cd — varchar(10)
- sale_acc_ven_cd — varchar(10)
- comp_flag — varchar(1)
- etax_issue_flag — varchar(1)
- rvs_issue_flag — varchar(1)
- ocomp_tax_id — varchar(15)
- edi_yn — varchar(1)
- comp_no — varchar(10)
- corp_no — varchar(13)
- comp_name — varchar(40)
- biz_stat — varchar(40)
- biz_cat — varchar(40)
- rep_name — varchar(40)
- post_no — varchar(6)
- post_seq — int4
- addr — varchar(80)
- dtl_addr — varchar(80)
- phone1_no — varchar(4)
- phone2_no — varchar(4)
- phone3_no — varchar(4)
- fax1_no — varchar(4)
- fax2_no — varchar(4)
- fax3_no — varchar(4)
- biz_s_dt — varchar(8)
- biz_e_dt — varchar(8)
- use_yn — varchar(1)
- sap_del_flag — varchar(1)
- sap_if_date — timestamp
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pc_venmst (협력사마스터)
- ven_cd — varchar(6) — 기본 키 — NOT NULL
- ven_name — varchar(40)
- ven_short_name — varchar(20)
- buy_sale_flag — varchar(1)
- biz_type — varchar(1)
- biz_flag — varchar(2)
- rep_ven_cd — varchar(6)
- buy_acc_ven_cd — varchar(10)
- sale_acc_ven_cd — varchar(10)
- comp_flag — varchar(1)
- etax_issue_flag — varchar(1)
- rvs_issue_flag — varchar(1)
- ocomp_tax_id — varchar(15)
- edi_yn — varchar(1)
- comp_no — varchar(10)
- corp_no — varchar(13)
- comp_name — varchar(40)
- biz_stat — varchar(40)
- biz_cat — varchar(40)
- rep_name — varchar(40)
- post_no — varchar(6)
- post_seq — int4
- addr — varchar(80)
- dtl_addr — varchar(80)
- phone1_no — varchar(4)
- phone2_no — varchar(4)
- phone3_no — varchar(4)
- fax1_no — varchar(4)
- fax2_no — varchar(4)
- fax3_no — varchar(4)
- biz_s_dt — varchar(8)
- biz_e_dt — varchar(8)
- use_yn — varchar(1)
- sap_del_flag — varchar(1)
- sap_if_date — timestamp
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)