세금계산서
테이블 (3)
company_info
- basic_info_no — int(10) — 기본 키 — NOT NULL
- number (사업자등록번호) — varchar(20) — NOT NULL
- tnumber — varchar(4)
- name — varchar(255) — NOT NULL
- master — varchar(255)
- bcondition — varchar(100)
- item (업태) — varchar(100)
- kind (업종) — enum('P','C') — NOT NULL
- address (소재지) — varchar(300)
- setting_type — int(11)
- setting_xml — text
- auto_send_date — varchar(5)
- is_ssn (인증여부) — tinyint(4)
- ssn_regist_date (최초인증일) — datetime
- ssn_update_date (재인증일) — datetime
document
- no — int(10) — 기본 키 — NOT NULL
- basic_info_no (basic_info_no2) — int(10) — 외래 키 → company_info.basic_info_no — NOT NULL
- basic_info_no — int(10) — NOT NULL
- document_id — varchar(255)
- fk_user_info_no — int(10) — NOT NULL
- book_no — varchar(20)
- serial — varchar(20)
- issue_date — date — NOT NULL
- remark — text
- d_type — enum('A', 'B', 'C', 'D', 'M', 'N', 'TA', 'TM')
- s_number — varchar(50)
- s_tnumber — varchar(4)
- s_name — varchar(255) — NOT NULL
- s_master — varchar(255)
- s_condition — varchar(100)
- s_item — varchar(100)
- s_address — varchar(300)
- r_number — varchar(50)
- r_tnumber — varchar(4)
- r_name — varchar(255) — NOT NULL
- r_master — varchar(255)
- r_condition — varchar(100)
- r_item — varchar(100)
- r_address — varchar(300)
- c_name — varchar(255)
- c_email — varchar(255) — NOT NULL
- c_cell — varchar(20)
- c_phone — varchar(20)
- c_senddate — datetime
- ems_index — varchar(32)
- c_name2 — varchar(255)
- c_email2 — varchar(255)
- c_cell2 — varchar(20)
- c_phone2 — varchar(20)
- c_senddate2 — datetime
- ems_index2 — varchar(32)
- supplyprice — bigint(20)
- tax — bigint(20)
- memo — text
- money — bigint(20)
- moneycheck — bigint(20)
- bill — bigint(20)
- uncollect — bigint(20)
- document_type — enum('S', 'R', 'A', 'B') — NOT NULL
- write_date — datetime — NOT NULL
- p_type — enum('C', 'R')
- t_type — enum('A', 'B', 'D')
- sc_name — varchar(255)
- sc_email — varchar(255)
- sc_cell — varchar(20)
- sc_phone — varchar(20)
- attach_document — tinyint(3)
- org_issue_id — varchar(30) — NOT NULL
- is_manual — varchar(1) — 직접 작성 여부
- business_type_code — varchar(2) — 사업자 구분 코드
document_sign
- no — int(10) — 기본 키 — NOT NULL
- no (no2) — int(10) — 외래 키 → document.no — NOT NULL
- basic_info_no (basic_info_no2) — int(10) — 외래 키 → document.basic_info_no — NOT NULL
- basic_info_no — int(10) — NOT NULL
- document_no — int(10) — NOT NULL
- document_id — varchar(255)
- fk_document_id — varchar(255)
- signdata — text
- r_value — varchar(255)
- originaldata — text
- cert_value — text
- cert_algorithm — varchar(10)
- digest_value — varchar(255)
- b_memo — text — 반려 사유
- now_state — enum('W', 'T', 'R', 'S', 'B', 'C', 'A') — W:미발송, T:미열람, R:열람, S:승인, B:반려, C:승인취소요청, A:승인취소완료
- read_state — enum('C', 'R')
- declare_status — tinyint(4) — NOT NULL
- declare_status_code — varchar(10)
- issue_id — varchar(30)
- modify_type — tinyint(4)
- asp_mail — varchar(255)
- auto_send_date — varchar(5)
- SmtpStep — tinyint(4) — NOT NULL
- SmtpCode — smallint(6) — NOT NULL
- Explain — varchar(200)
- ResultCode — smallint(6)
- sign_date_str — varchar(14)
- created_from — varchar(15) — 20.08.03. 데이터 유입 경로 : API,WEB,AGENT,LEGACY,ETC..
- accepted_channel — varchar(15) — 20.08.03. 차감 수단 : PASS,FREE,PAID,POINT,ETC..
- reseller_code — varchar(30) — 20.08.03. API 리셀러 코드