bunri

Tables (10)

kbs_receipt (Untitled10)

  • ocr_merged_ck_digit (Key) — Primary key — NOT NULL

t_apt_bunri_notice (Untitled)

  • notice_idx (key) — int — Primary key
  • notifym (Field) — char6 — Primary key
  • sedeid (Key) — char18 — Foreign key → t_apt_bunri_sede_master.sedeid — NOT NULL
  • notice_type (Field17) — char1 — NOT NULL — 1. 정기 생성 2. 가산금계산(자동) - 납기일 경과 후 자동 생성 - 익월 고지서 작업시 자동 생성 3. 요금재계산 4. 환불
  • epn (Field10) — char14
  • elec (Field3) — int
  • elec_exempt_yn (Field4) — char1
  • tvfee (Field13) — int
  • tvdlyfee (Field14) — int
  • tvnofee (Field16) — int
  • reqfee (Field15) — int
  • issueYn (Field18) — char1 — 당 고지서 발송 대상 여부
  • issuedYn (Field19) — char1
  • issue_state (Field28) — char1 — 우편발송업체 인쇄 등 상태 표시
  • customer_name (Field20) — char16
  • address (Field21) — char100
  • dong (Field22) — char4
  • ho (Field23) — char4
  • phone (Field24) — varchar20
  • hphone (Field25) — varchar20
  • zipcode (Field26) — char5
  • tvcnt (Field27) — int
  • chk_rev_addr_use (Field29) — char1
  • rev_customer_name (Field30) — char16
  • rev_address (Field31) — varchar200
  • rev_zipcode (Field32) — varchar10
  • due_day (Field2) — char8
  • createAt (Field6) — time
  • modifyAt (Field7) — time
  • creator (Field8) — char10
  • modifier (Field9) — char10
  • aptid (Key2) — Foreign key → t_apt_goji_ledger.aptid — NOT NULL
  • askway (code) — char4 — Foreign key → t_code_text.code — NOT NULL

t_apt_bunri_notice_memo (Untitled3)

  • createAt (Field2) — time — Primary key
  • sedeid (Key) — char18 — Foreign key → t_apt_bunri_notice.sedeid — NOT NULL
  • notice_idx (key) — int — Foreign key → t_apt_bunri_notice.notice_idx
  • notifym (Field22) — Foreign key
  • memo (Field3) — char200
  • kbscd (Field4) — char4 — 1

t_apt_bunri_receipt (Untitled4)

  • receipt_idx (Key3) — int — Primary key — NOT NULL
  • notice_idx (key) — int — Foreign key → t_apt_bunri_notice.notice_idx
  • sedeid (Key) — char18 — Foreign key → t_apt_bunri_notice.sedeid — NOT NULL
  • notifym (Field22) — Foreign key
  • reqfee (Field2) — int
  • settleamt (Field) — int
  • littleamt (Field4) — int
  • excessamt (Field5) — int
  • realamt (Field3) — int
  • received (Field6) — char8
  • transferd (Field7) — char8
  • receipt_state (code) — char4 — Foreign key → t_code_text.code — NOT NULL
  • ocr_merged_ck_digit (Key2) — Foreign key → kbs_receipt.ocr_merged_ck_digit — NOT NULL
  • createAt (Field8) — time
  • creator (Field9) — char16
  • Field10

t_apt_bunri_sede_master (Untitled2)

  • sedeid (Key) — char18 — Primary key — NOT NULL
  • Field

t_apt_goji_ledger (Untitled7)

  • notifym (Field2) — Primary key
  • mr_dd (Field3) — Primary key
  • kbscd (Field5) — Primary key
  • aptid (Key) — Foreign key → t_apt_master.aptid — NOT NULL
  • duedd (Field4)

t_apt_key_groups (Untitled9)

  • aptid — Foreign key → t_apt_master.aptid — NOT NULL
  • customid (Field) — char10

t_apt_log (Untitled6)

  • log_id (Field2) — Primary key
  • createAt (Field3) — time
  • creator (Field) — char10
  • code (Key) — char4 — Foreign key → t_code_text.code — NOT NULL
  • memo (Field4) — varchar100
  • Field5

t_apt_master (Untitled8)

  • aptid — Primary key — NOT NULL
  • Field

t_code_text (Untitled5)

  • code (Key) — char4 — Primary key — NOT NULL
  • desc (Field) — varchar100
  • Field2