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