TEST
Tables (19)
CI_COMPANY
- COMPANY_CD — VARCHAR2(7 ) — Primary key — NOT NULL
- NATION_CD — VARCHAR2(5 ) — NOT NULL — 국가코드
- COMPANY_NM — VARCHAR2(100 ) — NOT NULL — 회사명
- COMPANY_NM2 — VARCHAR2(50 CHAR) — 회사명외국어
- LANG_CD — VARCHAR2(5 CHAR) — NOT NULL — 언어코드
- EXCH_CD — VARCHAR2(5 CHAR) — NOT NULL — 환종코드
- CORP_FG_CD — VARCHAR2(5 CHAR) — NOT NULL — 법인구분코드
- CORP_TP_CD — VARCHAR2(5 CHAR) — 법인유형코드
- COR_NO — VARCHAR2(20 CHAR) — 법인등록번호
- BIZR_NO — VARCHAR2(20 CHAR) — 사업자등록번호
- BIZTP_TP_CD — VARCHAR2(5 CHAR) — NOT NULL — 업종유형코드
- GAAP_CD — VARCHAR2(5 CHAR) — NOT NULL — GAAP코드
- OPBIZ_DT — VARCHAR2(8 CHAR) — 개업일
- ESTB_DT — VARCHAR2(8 CHAR) — 설립일
- ACCSEQ_SQ — NUMBER(3,0) — 회계기수순번
- ACTG_YR_START_DT — VARCHAR2(8 CHAR) — NOT NULL — 회계연도시작일
- ACTG_YR_END_DT — VARCHAR2(8 CHAR) — NOT NULL — 회계연도종료일
- TEL_NO — VARCHAR2(20 CHAR) — 전화번호
- FAX_NO — VARCHAR2(20 CHAR) — 팩스번호
- CONCORP_FG_CD — VARCHAR2(5 CHAR) — 연결법인구분코드
- UP_COMPANY_CD — VARCHAR2(7 CHAR) — 상위회사코드
- POST_NO — VARCHAR2(10 CHAR) — 우편번호
- BASE_ADDR — VARCHAR2(100 CHAR) — 기본주소
- DTL_ADDR — VARCHAR2(100 CHAR) — 상세주소
- BASE_ADDR2 — VARCHAR2(100 CHAR) — 기본외국주소
- DTL_ADDR2 — VARCHAR2(100 CHAR) — 상세외국주소
- CEO_NM — VARCHAR2(100 CHAR) — 대표자명
- CEO_NM2 — VARCHAR2(50 CHAR) — 대표자명외국어
- RES_NO — VARCHAR2(32 CHAR) — 주민등록번호
- CEO_POST_NO — VARCHAR2(10 CHAR) — 대표자우편번호
- CEO_BASE_ADDR — VARCHAR2(100 CHAR) — 대표자기본주소
- CEO_DTL_ADDR — VARCHAR2(100 CHAR) — 대표자상세주소
- END_DT — VARCHAR2(8 CHAR) — 종료일
- INSERT_ID — VARCHAR2(30 CHAR) — 등록ID
- INSERT_IP — VARCHAR2(200 CHAR) — 등록IP
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR) — 등록맥어드레스명
- INSERT_DTS — DATE — 등록일시
- UPDATE_ID — VARCHAR2(30 CHAR) — 수정ID
- UPDATE_IP — VARCHAR2(200 CHAR) — 수정IP
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR) — 수정맥어드레스명
- UPDATE_DTS — DATE — 수정일시
- KSIC_SQ_NO — VARCHAR2(5 CHAR) — 한국표준산업분류차수번호
- KSIC_CD — VARCHAR2(5 CHAR) — 한국표준산업분류코드
- CEO_EMP_NO — VARCHAR2(20 CHAR) — 대표자사원번호
- RSA_PBLCK_TXT — VARCHAR2(2000 CHAR) — RSA공개키텍스트
- RSA_PRVTK_TXT — VARCHAR2(2000 CHAR) — RSA개인키텍스트
- WEHAGO_KEY_NO — VARCHAR2(10 CHAR) — 위하고키번호
- CERT_TOKN_VR — VARCHAR2(100 CHAR) — 인증토큰문자값
- DMN_SERVICE_KEY_VR — VARCHAR2(100 CHAR) — 도메인서비스키문자값
- WEHAGO_ADM_ID — VARCHAR2(30 CHAR) — 위하고관리자ID
- WEHAGO_SGNT_VR — VARCHAR2(100 CHAR) — 위하고서명문자값
- NOTF_SEND_TXT — VARCHAR2(1000 CHAR) — 알림발송텍스트
- WEHAGO_DEPT_KEY_NO — VARCHAR2(10 CHAR) — 위하고부서키번호
- PARTNER_EXTNO_CD — VARCHAR2(5 CHAR) — 거래처채번코드
FI_ACCSEQ_DTL
- CARR_CLAS_CD — VARCHAR2(5 CHAR) — Primary key — NOT NULL
- ACCSEQ_SQ — NUMBER(3,0) — Foreign key → FI_ACCSEQ_MST.ACCSEQ_SQ — NOT NULL
- CARR_YN — VARCHAR2(1 CHAR)
- LAST_CARR_EMP_NO — VARCHAR2(30 CHAR)
- LAST_CARR_DT — VARCHAR2(8 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- RMK_DC — VARCHAR2(200 CHAR)
FI_ACCSEQ_MST
- ACCSEQ_SQ — NUMBER(3,0) — Primary key — NOT NULL
- MA_COMPANY_CD — Foreign key → MA_COMPANY.MA_COMPANY_CD — NOT NULL
- START_DT — VARCHAR2(8 CHAR)
- END_DT — VARCHAR2(8 CHAR)
- BASE_STOCK_CNT — NUMBER(10,0)
- PRIOR_STOCK_CNT — NUMBER(10,0)
- PRIOR_WEEKVND_AMT — NUMBER(19,4)
- THSTRM_NETPF_INC_AMT — NUMBER(19,4)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- RMK_DC — VARCHAR2(200 CHAR)
FI_BANK_TRADE
- FINPRODUCT_NO — VARCHAR2(32 CHAR) — Primary key — NOT NULL
- TRAN_DT — VARCHAR2(8 CHAR) — Primary key — NOT NULL
- TRAN_TM — VARCHAR2(8 CHAR) — Primary key — NOT NULL
- NO_SQ — NUMBER(38,0) — Primary key — NOT NULL
- BG_CD — VARCHAR2(20 CHAR) — Foreign key → FI_BG_MST.BG_CD — NOT NULL
- COMPANY_CD — VARCHAR2(7 CHAR) — NOT NULL
- TRAN_FG — VARCHAR2(3 CHAR) — NOT NULL
- IAMT_AMT — NUMBER(19,4) — NOT NULL
- WTHDRWL_AMT — NUMBER(19,4) — NOT NULL
- BLNC_AMT — NUMBER(19,4)
- NOTE_DC — VARCHAR2(200 CHAR)
- TRAN_NM — VARCHAR2(100 CHAR)
- PAY_ACNT_NO — VARCHAR2(32 CHAR)
- PAY_BANK_CD — VARCHAR2(20 CHAR)
- PROC_FG — VARCHAR2(3 CHAR)
- VIRT_ACNT_NO — VARCHAR2(32 CHAR)
- CMS_CD — VARCHAR2(50 CHAR)
- BIZR_NO — VARCHAR2(20 CHAR)
- PROC_RST_ST — VARCHAR2(3 CHAR)
- DOCU_PROC_YN — VARCHAR2(1 CHAR)
- INSERT_DT — VARCHAR2(8 CHAR)
- INSERT_TM — VARCHAR2(8 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- PC_CD — VARCHAR2(7 CHAR)
- DEPT_CD — VARCHAR2(20 CHAR)
- DATA_CD — VARCHAR2(20 CHAR)
- PROC_DT — VARCHAR2(8 CHAR)
- DATA_NO — VARCHAR2(50 CHAR)
- DOCU_NO — VARCHAR2(20 CHAR)
- DOLINE_SQ — NUMBER(5,0)
- EXCH_CD — VARCHAR2(5 CHAR)
- EXRT_RT — NUMBER(23,10)
- FMNY_AMT — NUMBER(19,4)
- FMNY_IAMT_AMT — NUMBER(19,4)
- FMNY_OUT_AMT — NUMBER(19,4)
- FMNY_BLNC_AMT — NUMBER(19,4)
- FUND_CD — VARCHAR2(20 CHAR)
- IAMT_ST — VARCHAR2(3 CHAR)
- REQ_NM — VARCHAR2(100 CHAR)
- CNCL_ST — VARCHAR2(3 CHAR)
- FEOTH_ACCT_CD — VARCHAR2(20 CHAR)
- PARTNER_CD — VARCHAR2(20 CHAR)
- BDOCU_NO — VARCHAR2(20 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- ABDOCU_NO — VARCHAR2(20 CHAR)
- RDOLINE_SQ — NUMBER(5,0)
- BIZ_CMNY_DOCUPROC_YN — VARCHAR2(1 CHAR)
- FEE_AMT — NUMBER(19,4)
- FEE_VAT_AMT — NUMBER(19,4)
- STL_AMT — NUMBER(19,4)
- DIVD_YN — VARCHAR2(1 CHAR)
- REVJRNZ_DOCU_NO — VARCHAR2(20 CHAR)
- CMS_DATA_SQ — NUMBER(38,0)
- CHECK_NO — VARCHAR2(20 CHAR)
- … +8
FI_BGACCT_MST
- BGACCT_CD — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- ACCSEQ_SQ — NUMBER(3,0) — Foreign key → FI_ACCSEQ_MST.ACCSEQ_SQ — NOT NULL
- UP_BGACCT_CD — VARCHAR2(20 CHAR)
- BGACCT_NM — VARCHAR2(50 CHAR)
- GRP_CD — VARCHAR2(5 CHAR) — NOT NULL
- BGACCT_NM2 — VARCHAR2(50 CHAR)
- BGACCT_FG_CD — VARCHAR2(5 CHAR)
- BGACCT_LV — NUMBER(3,0) — NOT NULL
- PRINT_SQ — NUMBER(3,0) — NOT NULL
- ABGT_USE_YN — VARCHAR2(1 CHAR)
- BG_EXCTN_USE_YN — VARCHAR2(1 CHAR)
- BGCTRL_FG_CD — VARCHAR2(5 CHAR)
- BGLV_CD — VARCHAR2(5 CHAR)
- DISTDATE_DT — VARCHAR2(8 CHAR)
- BGCTRL_TP_CD — VARCHAR2(5 CHAR)
- MSG_ST_CD — VARCHAR2(5 CHAR)
- COPY_YN — VARCHAR2(1 CHAR)
- ACCT_CD — VARCHAR2(20 CHAR)
- END_YY — VARCHAR2(4 CHAR)
- BG_CARR_USE_YN — VARCHAR2(1 CHAR)
- CONFIG_CD — VARCHAR2(10 CHAR)
- INCOMEXPEN_FG — VARCHAR2(3 CHAR) — NOT NULL
- PRINT_NO — VARCHAR2(40 CHAR)
- PRINT_CD — VARCHAR2(5 CHAR)
- BG_PRG_NO — VARCHAR2(20 CHAR)
- BG_PRG_LV — NUMBER(3,0)
- BGACCT_LST_CD — VARCHAR2(200 CHAR)
- BGADJT_LIMT_TP — VARCHAR2(3 CHAR)
- EDAYEXPNS_YN — VARCHAR2(1 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- FNC_TRAN_CD — VARCHAR2(5 CHAR)
- CONN_YN — VARCHAR2(1 CHAR)
FI_BG_MST
- BG_CD — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- MA_COMPANY_CD — Foreign key → MA_COMPANY.MA_COMPANY_CD — NOT NULL
- BG_NM — VARCHAR2(50 CHAR)
- BG_NM2 — VARCHAR2(50 CHAR)
- BGCTRL_TP_CD — VARCHAR2(5 CHAR)
- BGCTRL_TERMFG_CD — VARCHAR2(5 CHAR)
- ABGT_FG_CD — VARCHAR2(5 CHAR)
- PC_CD — VARCHAR2(7 CHAR)
- END2_YM — VARCHAR2(6 CHAR)
- BG_TP_CD — VARCHAR2(5 CHAR)
- START_YM — VARCHAR2(6 CHAR)
- END_YM — VARCHAR2(6 CHAR)
- USE_YN — VARCHAR2(1 CHAR)
- ACCTLV_CD — VARCHAR2(5 CHAR)
- BGASG_TP_CD — VARCHAR2(5 CHAR)
- NP_YN — VARCHAR2(1 CHAR)
- EMP_NO — VARCHAR2(20 CHAR)
- DEPT_CD — VARCHAR2(20 CHAR)
- START_DT — VARCHAR2(8 CHAR)
- BG_END_DT — VARCHAR2(8 CHAR)
- BG_ST — VARCHAR2(3 CHAR)
- BG_TP — VARCHAR2(3 CHAR)
- BG_DC — VARCHAR2(100 CHAR)
- BG_TXT — VARCHAR2(1000 CHAR)
- BG_ABB_NM — VARCHAR2(100 CHAR)
- BIZ_TP_CD — VARCHAR2(5 CHAR)
- BG_AUTH_TP — VARCHAR2(3 CHAR)
- PJT_CD — VARCHAR2(50 CHAR)
- WBS_NO — VARCHAR2(50 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- BG_UNIT_LV — NUMBER(3,0)
- UP_BG_CD — VARCHAR2(20 CHAR)
- CONN_YN — VARCHAR2(1 CHAR)
- BGACCT_YN — VARCHAR2(1 CHAR)
FI_BIZPLAN_MST
- BIZPLAN_CD — VARCHAR2(50 CHAR) — Primary key
- MA_COMPANY_CD — Foreign key → MA_COMPANY.MA_COMPANY_CD — NOT NULL
- BIZPLAN_NM — VARCHAR2(100 CHAR)
- BIZPLAN_NM2 — VARCHAR2(100 CHAR)
- UP_BIZPLAN_CD — VARCHAR2(20 CHAR)
- PC_CD — VARCHAR2(7 CHAR)
- BIZPLAN_LV_CD — VARCHAR2(5 CHAR)
- BIZPLAN_VER_NO — VARCHAR2(5 CHAR)
- BIZPLAN_TP_CD — VARCHAR2(5 CHAR)
- START_YM — VARCHAR2(6 CHAR)
- END_YM — VARCHAR2(6 CHAR)
- BIZPLAN_LV1_NM — VARCHAR2(50 CHAR)
- BIZPLAN_LV2_NM — VARCHAR2(50 CHAR)
- BIZPLAN_LV3_NM — VARCHAR2(50 CHAR)
- BIZPLAN_LV4_NM — VARCHAR2(50 CHAR)
- BIZPLAN_LV5_NM — VARCHAR2(50 CHAR)
- REQPLC_NM — VARCHAR2(50 CHAR)
- RSPNBER_NM — VARCHAR2(50 CHAR)
- ACNT_NO — VARCHAR2(32 CHAR)
- BIZ_TOT_AMT — NUMBER(19,4)
- PJT_FG_CD — VARCHAR2(5 CHAR)
- BGASG_TP_CD — VARCHAR2(5 CHAR)
- ABGT_TP_CD — VARCHAR2(5 CHAR)
- INSR_YN — VARCHAR2(1 CHAR)
- USE_YN — VARCHAR2(1 CHAR)
- BIZPLAN_TXT — VARCHAR2(1000 CHAR)
- PRINT_SQ — NUMBER(3,0)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- ABGT_USE_YN — VARCHAR2(1 CHAR)
- BG_EXCTN_USE_YN — VARCHAR2(1 CHAR)
- BGCTRL_LV_CD — VARCHAR2(5 CHAR)
- INTL_YN — VARCHAR2(1 CHAR)
FI_CARD_TRADE
- FINPRODUCT_NO — VARCHAR2(32 CHAR) — Primary key — NOT NULL
- TRAN_DT — VARCHAR2(8 CHAR) — Primary key — NOT NULL
- TRAN_TM — VARCHAR2(8 CHAR) — Primary key — NOT NULL
- NO_SQ — NUMBER(38,0) — Primary key — NOT NULL
- APRVL_NO — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- APRVL_YN — VARCHAR2(1 CHAR) — Primary key — NOT NULL
- BG_CD (BG_CD2) — VARCHAR2(20 CHAR) — Foreign key → FI_BG_MST.BG_CD — NOT NULL
- COMPANY_CD — VARCHAR2(7 CHAR) — NOT NULL
- TRAN_AMT — NUMBER(19,4) — NOT NULL
- NOTE_DC — VARCHAR2(200 CHAR)
- TRAN_NM — VARCHAR2(100 CHAR)
- INSM_TERM_DY — NUMBER(7,2)
- INSM_MM — VARCHAR2(2 CHAR)
- DMND_MM — VARCHAR2(2 CHAR)
- DMND_PRRG_DT — VARCHAR2(8 CHAR)
- CMNY_TP — VARCHAR2(3 CHAR)
- BIZR_NO — VARCHAR2(20 CHAR)
- VRFC_FG — VARCHAR2(3 CHAR)
- DOCU_PROC_YN — VARCHAR2(1 CHAR)
- INSERT_DT — VARCHAR2(8 CHAR)
- INSERT_TM — VARCHAR2(8 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- PC_CD — VARCHAR2(7 CHAR)
- DEPT_CD — VARCHAR2(20 CHAR)
- DATA_CD — VARCHAR2(20 CHAR)
- PROC_DT — VARCHAR2(8 CHAR)
- DATA_NO — VARCHAR2(50 CHAR)
- DOCU_NO — VARCHAR2(20 CHAR)
- DOLINE_SQ — NUMBER(5,0)
- APRVL_VAT_AMT — NUMBER(19,4)
- BIZTP_CD — VARCHAR2(5 CHAR)
- BIZTP_NM — VARCHAR2(50 CHAR)
- FRCS_CD — VARCHAR2(20 CHAR)
- TEL_NO — VARCHAR2(20 CHAR)
- POST_NO — VARCHAR2(10 CHAR)
- BASE_ADDR — VARCHAR2(100 CHAR)
- SPPRC_AMT — NUMBER(19,4)
- VAT_AMT — NUMBER(19,4)
- TIP_AMT — NUMBER(19,4)
- DUES_AMT — NUMBER(19,4)
- ARRRG_AMT — NUMBER(19,4)
- EXRT_RT — NUMBER(23,10)
- EXPE_ACCT_CD — VARCHAR2(20 CHAR)
- ACCTTYPE_CD — VARCHAR2(10 CHAR)
- BILL_KEY_NO — VARCHAR2(40 CHAR)
- VAT_CD — VARCHAR2(10 CHAR)
- PAY_DT — VARCHAR2(8 CHAR)
- FRGN_USE_YN — VARCHAR2(1 CHAR)
- EXCH_CD — VARCHAR2(5 CHAR)
- PARTNER_CD — VARCHAR2(20 CHAR)
- DTL_ADDR — VARCHAR2(100 CHAR)
- VAT_PROC_YN — VARCHAR2(1 CHAR)
- FRCS_CEO_NM — VARCHAR2(50 CHAR)
- VAT_TP — VARCHAR2(3 CHAR)
- CAPAPU_NM — VARCHAR2(50 CHAR)
- INCOMEOC_AMT — NUMBER(19,4)
- INCOMEOC_TAX_AMT — NUMBER(19,4)
- CARD_TP — VARCHAR2(3 CHAR)
- PRCH_DT — VARCHAR2(8 CHAR)
- CNCL_DT — VARCHAR2(8 CHAR)
- … +81
FI_DOCU_DAY_SUM
- ACTG_DT — VARCHAR2(8) — Primary key — NOT NULL
- DRCRFG_CD — VARCHAR2(5) — Primary key — NOT NULL
- EXCH_CD — VARCHAR2(5) — Primary key — NOT NULL
- MNGD_CD — VARCHAR2(50) — Primary key — NOT NULL
- PC_CD — VARCHAR2(7) — Primary key — NOT NULL
- SUM_FG — VARCHAR2(3) — Primary key — NOT NULL
- GAAP_CD — VARCHAR2(5 CHAR) — Foreign key — NOT NULL
- MCLS_CD — VARCHAR2(5 CHAR) — Foreign key — NOT NULL
- DOCU_AMT — NUMBER(19,4)
- DOCU_AMT2 — NUMBER(19,4)
- INSERT_DTS — DATE
- INSERT_ID — VARCHAR2(30)
- INSERT_IP — VARCHAR2(200)
- INSERT_MCADDR_NM — VARCHAR2(200)
- MNGD_NM — VARCHAR2(100)
- OTHACCTALT_AMT — NUMBER(19,4)
- OTHACCTALT_SALE_AMT — NUMBER(19,4)
- SETTLALT_AMT — NUMBER(19,4)
- UPDATE_DTS — DATE
- UPDATE_ID — VARCHAR2(30)
- UPDATE_IP — VARCHAR2(200)
- UPDATE_MCADDR_NM — VARCHAR2(200
FI_DOCU_MST
- DOCU_NO — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- PC_CD — VARCHAR2(7 CHAR) — Primary key — NOT NULL
- MA_COMPANY_CD — Foreign key → MA_COMPANY.MA_COMPANY_CD — NOT NULL
- ABDOCU_NO — VARCHAR2(20 CHAR)
- WRT_DT — VARCHAR2(8 CHAR) — NOT NULL
- ACTG_NO — VARCHAR2(20 CHAR) — NOT NULL
- DOCU_CD — VARCHAR2(20 CHAR) — NOT NULL
- CNSUL_DC — VARCHAR2(200 CHAR)
- WRT_DEPT_CD — VARCHAR2(20 CHAR) — NOT NULL
- WRT_EMP_NO — VARCHAR2(20 CHAR) — NOT NULL
- ACTG_DT — VARCHAR2(8 CHAR) — NOT NULL
- GAAP_CD — VARCHAR2(5 CHAR) — NOT NULL
- DOCU_ST_CD — VARCHAR2(5 CHAR) — NOT NULL
- EXCH_CD — VARCHAR2(5 CHAR)
- GWAPRVLST_CD — VARCHAR2(5 CHAR)
- INSR_FG_CD — VARCHAR2(5 CHAR)
- DOCU_FG_CD — VARCHAR2(5 CHAR)
- APRVL_EMP_NO — VARCHAR2(20 CHAR)
- MENU_CD — VARCHAR2(20 CHAR)
- MODULE_MNG_NO — VARCHAR2(100 CHAR)
- ABDOCU_FG_CD — VARCHAR2(5 CHAR)
- GW_YN — VARCHAR2(1 CHAR)
- AUDOFIR_ID — VARCHAR2(30 CHAR)
- ATCH_CHNLNG_VER_VR — VARCHAR2(5 CHAR)
- APRVL_DT — VARCHAR2(8 CHAR)
- REVJRNZ_FG_CD — VARCHAR2(50 CHAR)
- ACCSEQ_SQ — NUMBER(3,0) — NOT NULL
- FILE_ATCH_DC — VARCHAR2(200 CHAR)
- ATCH_FILE_NM — VARCHAR2(100 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- ATHZ_RPTS_CD — VARCHAR2(50 CHAR)
- GWDOCU_NO — VARCHAR2(50 CHAR)
- RMENU_CD — VARCHAR2(20 CHAR)
- CONN_KEY_VR — VARCHAR2(100 CHAR)
FI_FINPRODUCT_MST
- FINPRODUCT_FG — VARCHAR2(3 CHAR) — Primary key — NOT NULL
- FINPRODUCT_CD — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- MA_COMPANY_CD — Foreign key → MA_COMPANY.MA_COMPANY_CD — NOT NULL
- RMENU_CD — VARCHAR2(20 CHAR)
- FINPRODUCT_NO — VARCHAR2(32 CHAR)
- FINPRODUCT_NM — VARCHAR2(50 CHAR) — NOT NULL
- FINPRODUCT_NM2 — VARCHAR2(50 CHAR)
- CONN_FINPRODUCT_CD — VARCHAR2(20 CHAR)
- OWNR_NM — VARCHAR2(50 CHAR)
- CARD_OWNR_NM — VARCHAR2(50 CHAR)
- PARTNER_CD — VARCHAR2(20 CHAR)
- DPSTSE_FG_CD — VARCHAR2(5 CHAR)
- CRCRD_TP_CD — VARCHAR2(5 CHAR)
- CRCRD_FG_CD — VARCHAR2(5 CHAR)
- CRDC_CD — VARCHAR2(5 CHAR)
- EXCH_CD — VARCHAR2(5 CHAR)
- JOIN_DT — VARCHAR2(8 CHAR)
- END_DT — VARCHAR2(8 CHAR)
- PC_CD — VARCHAR2(7 CHAR)
- DEPT_CD — VARCHAR2(20 CHAR)
- EMP_NO — VARCHAR2(20 CHAR)
- FUND_CD — VARCHAR2(20 CHAR)
- RES_NO — VARCHAR2(32 CHAR)
- BG_BIZPLAN_CD — VARCHAR2(20 CHAR)
- ACCT_CD — VARCHAR2(20 CHAR)
- BANK_CD — VARCHAR2(20 CHAR)
- WGS_ACNT_YN — VARCHAR2(1 CHAR)
- BNDS_AMT — NUMBER(19,4)
- INTR_RT — NUMBER(19,6)
- INTR_CAL_MTHD_CD — VARCHAR2(5 CHAR)
- FIRST_PAYMNT_AMT — NUMBER(19,4)
- EXPRTN_INTR_RT — NUMBER(19,6)
- DY_CAL_MTHD_CD — VARCHAR2(5 CHAR)
- INTR_CMNY_FG_DY — NUMBER(7,2)
- FIRST_PYM_DT — VARCHAR2(8 CHAR)
- FIRST_INTR_CMNY_DT — VARCHAR2(8 CHAR)
- INTR_CMNY_PRID_DT — VARCHAR2(2 CHAR)
- PYM_PRID_DY — NUMBER(7,2)
- PAYMNT_CNT — NUMBER(5,0)
- MM_PYM_AMT — NUMBER(19,4)
- TOT_PAYMNT_AMT — NUMBER(19,4)
- EXPRTN_AMT — NUMBER(19,4)
- SRND_DT — VARCHAR2(8 CHAR)
- USE_LIMT_YN — VARCHAR2(1 CHAR)
- USE_YN — VARCHAR2(1 CHAR)
- SRND_REASON_DC — VARCHAR2(100 CHAR)
- GRNTE_DC — VARCHAR2(200 CHAR)
- CLTR_DC — VARCHAR2(200 CHAR)
- RMK_DC — VARCHAR2(200 CHAR)
- VLID_YM — VARCHAR2(6 CHAR)
- CARD_ACNT_NO — VARCHAR2(32 CHAR)
- CRDUSESMM_CD — VARCHAR2(5 CHAR)
- CRDUSESMM_DT — VARCHAR2(2 CHAR)
- CRDUSEEMM_CD — VARCHAR2(5 CHAR)
- CRDUSEEMM_DT — VARCHAR2(2 CHAR)
- CRDPAY_MD_FG_CD — VARCHAR2(5 CHAR)
- CARD_STLM_DT — VARCHAR2(2 CHAR)
- MIRYFC_CD — VARCHAR2(5 CHAR)
- CARD_TYPE_CD — VARCHAR2(5 CHAR)
- RTUN_YN — VARCHAR2(1 CHAR)
- … +39
FI_FUND_MST
- FUND_CD — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- MA_COMPANY_CD — Foreign key → MA_COMPANY.MA_COMPANY_CD — NOT NULL
- FUND_NM — VARCHAR2(50 CHAR)
- FUND_NM2 — VARCHAR2(50 CHAR)
- SUM_CD — VARCHAR2(5 CHAR)
- BALC_FG_CD — VARCHAR2(5 CHAR)
- USE_YN — VARCHAR2(1 CHAR)
- FUNDGRP_CD — VARCHAR2(7 CHAR)
- FUNDGRP_NM — VARCHAR2(50 CHAR)
- ACCT_CD — VARCHAR2(20 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- AGGR_FG — VARCHAR2(5 CHAR)
- LV1_CD — VARCHAR2(20 CHAR)
- LV2_CD — VARCHAR2(20 CHAR)
- LV3_CD — VARCHAR2(20 CHAR)
- BGACCT_CD — VARCHAR2(20 CHAR)
- LV_SQ — NUMBER(3,0)
- FILL_YN — VARCHAR2(1 CHAR)
FI_MNGSUM_MST
- GUID_NO — VARCHAR2(40 CHAR) — Primary key — NOT NULL
- ACCT_CD — VARCHAR2(20 CHAR) — Foreign key → MA_COA_MST.ACCT_CD — NOT NULL — 계정코드
- PC_CD — VARCHAR2(7 CHAR) — NOT NULL
- ACTG_DT — VARCHAR2(8 CHAR) — NOT NULL
- DRCRFG_CD — VARCHAR2(5 CHAR) — NOT NULL
- EXCH_CD — VARCHAR2(5 CHAR) — NOT NULL
- DOCU_AMT — NUMBER(19,4)
- DOCU_AMT2 — NUMBER(19,4)
- OTHACCTALT_AMT — NUMBER(19,4)
- OTHACCTALT_SALE_AMT — NUMBER(19,4)
- HASH_VN — NUMBER(21,6)
- MCLS_CD_TXT — VARCHAR2(4000 CHAR)
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
FI_RDOCU_MST
- PC_CD — VARCHAR2(7 CHAR) — Primary key — NOT NULL
- ABDOCU_NO — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- DOCU_NO — VARCHAR2(20 CHAR)
- WRT_DT — VARCHAR2(8 CHAR) — NOT NULL
- ABDOCU_FG_CD — VARCHAR2(5 CHAR) — NOT NULL
- CNSUL_DC — VARCHAR2(100 CHAR)
- WRT_DEPT_CD — VARCHAR2(20 CHAR) — NOT NULL
- WRT_EMP_NO — VARCHAR2(20 CHAR) — NOT NULL
- ACTG_DT — VARCHAR2(8 CHAR) — NOT NULL
- DOCU_ST_CD — VARCHAR2(5 CHAR) — NOT NULL
- EXCH_CD — VARCHAR2(5 CHAR)
- GWAPRVLST_CD — VARCHAR2(5 CHAR)
- INSR_FG_CD — VARCHAR2(5 CHAR)
- APRVL_EMP_NO — VARCHAR2(20 CHAR)
- MENU_CD — VARCHAR2(20 CHAR)
- ATCH_CHNLNG_VER_VR — VARCHAR2(5 CHAR)
- APRVL_DT — VARCHAR2(8 CHAR)
- ACCSEQ_SQ — NUMBER(3,0) — NOT NULL
- INSERT_ID — VARCHAR2(30 CHAR)
- INSERT_IP — VARCHAR2(200 CHAR)
- INSERT_MCADDR_NM — VARCHAR2(200 CHAR)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_IP — VARCHAR2(200 CHAR)
- UPDATE_MCADDR_NM — VARCHAR2(200 CHAR)
- UPDATE_DTS — DATE
- INTL_SYS_CD — VARCHAR2(20 CHAR)
- ATHZ_RPTS_CD — VARCHAR2(50 CHAR)
- FILE_ATCH_DC — VARCHAR2(200 CHAR)
- ATCH_FILE_NM — VARCHAR2(100 CHAR)
- DOC_ID — NUMBER(11,0)
- MA_COMPANY_CD — Foreign key → MA_COMPANY.MA_COMPANY_CD — NOT NULL
HR_EMP_MST
- EMP_NO — VARCHAR2(20) — Primary key — NOT NULL
- GEMP_NO — VARCHAR2(20)
- KOR_NM — VARCHAR2(50)
- ENG_LNM_NM2 — VARCHAR2(50)
- ENG_FNM_NM2 — VARCHAR2(50)
- CHCRT_NM2 — VARCHAR2(50)
- BIZAREA_CD — VARCHAR2(7)
- DEPT_CD — VARCHAR2(20)
- PLANT_CD — VARCHAR2(7)
- WC_CD — VARCHAR2(7)
- EMP_TP — VARCHAR2(5)
- EMPY_TP_CD — VARCHAR2(5)
- POSI_CD — VARCHAR2(5)
- PSTN_CD — VARCHAR2(5)
- SLST_CD — VARCHAR2(10)
- ODTY_CD — VARCHAR2(5)
- DUTY_CD — VARCHAR2(5)
- OGRP_CD — VARCHAR2(5)
- JKND_CD — VARCHAR2(5)
- RES_NO — VARCHAR2(32)
- SEX_CD — VARCHAR2(5)
- GROUPECNY_DT — VARCHAR2(8)
- JNCO_DT — VARCHAR2(8)
- RETR_DT — VARCHAR2(8)
- RETIRESTDR_DT — VARCHAR2(8)
- HLOF_FG_CD — VARCHAR2(5)
- APNTC_EXPY_DT — VARCHAR2(8)
- TKG_CD — VARCHAR2(10)
- LAST_MLTPLC_DT — VARCHAR2(8)
- LAST_UGRD_DT — VARCHAR2(8)
- RES_UPPT_BIRYYMM_DT — VARCHAR2(8)
- RMK_DC — VARCHAR2(200)
- INSERT_ID — VARCHAR2(30)
- INSERT_IP — VARCHAR2(200)
- INSERT_MCADDR_NM — VARCHAR2(200)
- INSERT_DTS — DATE
- UPDATE_ID — VARCHAR2(30)
- UPDATE_IP — VARCHAR2(200)
- UPDATE_MCADDR_NM — VARCHAR2(200)
- UPDATE_DTS — DATE
- SERI_CD — VARCHAR2(5)
- WEHAGO_USER_KEY_NO — VARCHAR2(10)
- WEHAGO_EMP_KEY_NO — VARCHAR2(10)
- RFLT_YN — VARCHAR2(1)
- PSN_EMP_NO — VARCHAR2(20)
- STATUS_TRNS_DT — VARCHAR2(8)
- BEF_EMP_NO — VARCHAR2(50)
- STATUS_CD — VARCHAR2(10)
MA_COA_MST
- ACCT_CD — VARCHAR2(20 CHAR) — Primary key — NOT NULL — 계정코드
- COMPANY_CD — VARCHAR2(7 ) — Foreign key → CI_COMPANY.COMPANY_CD — NOT NULL
- ACCT_NM — VARCHAR2(50 CHAR) — NOT NULL — 계정명
- ACCT_NM2 — VARCHAR2(50 CHAR) — 계정명외국어
- ACCTLV_CD — VARCHAR2(5 CHAR) — NOT NULL — 계정레벨코드
- DRCRFG_CD — VARCHAR2(5 CHAR) — NOT NULL — 차대구분코드
- FILL_YN — VARCHAR2(1 CHAR) — NOT NULL — 기표여부
- ACCTATTR_CD — VARCHAR2(3 CHAR) — 계정속성코드
- RELACCT_CD — VARCHAR2(20 CHAR) — 관련계정코드
- PARTNER_MNDR_FG_CD — VARCHAR2(5 CHAR) — 거래처필수구분코드
- CC_MNDR_FG_CD — VARCHAR2(5 CHAR) — 비용센터필수구분코드
- PJT_MNDR_FG_CD — VARCHAR2(5 CHAR) — 프로젝트필수구분코드
- BAN_YN — VARCHAR2(1 CHAR) — 반제여부
- EVDN_MNDR_YN — VARCHAR2(1 CHAR) — 증빙필수여부
- FMNY_ACCT_YN — VARCHAR2(1 CHAR) — 외화계정여부
- FUNDPLAN_YN — VARCHAR2(1 CHAR) — 자금계획여부
- DR_NOTE_DC — VARCHAR2(100 CHAR) — 차변적요내역
- CR_NOTE_DC — VARCHAR2(100 CHAR) — 대변적요내역
- RELATION1_CD — VARCHAR2(5 CHAR) — 연동항목1코드
- RELATION2_CD — VARCHAR2(5 CHAR) — 연동항목2코드
- RELATION3_CD — VARCHAR2(5 CHAR) — 연동항목3코드
- RELATION4_CD — VARCHAR2(5 CHAR) — 연동항목4코드
- RELATION5_CD — VARCHAR2(5 CHAR) — 연동항목5코드
- RELATION6_CD — VARCHAR2(5 CHAR) — 연동항목6코드
- RELATION7_CD — VARCHAR2(5 CHAR) — 연동항목7코드
- RELATION8_CD — VARCHAR2(5 CHAR) — 연동항목8코드
- RELATION1_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목1필수여부
- RELATION2_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목2필수여부
- RELATION3_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목3필수여부
- RELATION4_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목4필수여부
- RELATION5_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목5필수여부
- RELATION6_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목6필수여부
- RELATION7_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목7필수여부
- RELATION8_MNDR_YN — VARCHAR2(1 CHAR) — 연동항목8필수여부
- GRPACCTGB_CD — VARCHAR2(5 CHAR) — NOT NULL — 그룹OR계정구분코드
- UP_ACCT_CD — VARCHAR2(20 CHAR) — 상위계정코드
- END_DT — VARCHAR2(8 CHAR) — 종료일
- ACGRP_CD — VARCHAR2(20 CHAR) — 계정그룹코드
- BAN_MNDR_YN — VARCHAR2(1 CHAR) — 반제필수여부
- EXPND_ABDOCU_FG_YN — VARCHAR2(1 CHAR) — 지출결의서구분여부
- ACCSEQ_SQ — NUMBER(3,0) — 회계기수순번
- BAN_MNG1_CD — VARCHAR2(5 CHAR) — 반제관리1코드
- BAN_MNG2_CD — VARCHAR2(5 CHAR) — 반제관리2코드
- BGCTRL_LV_CD — VARCHAR2(5 CHAR) — 예산통제레벨코드
- BGCTRL_FG_CD — VARCHAR2(5 CHAR) — 예산통제구분코드
- BGCTRL_TERM_CD — VARCHAR2(5 CHAR) — 예산통제기간코드
- BG_CARR_YN — VARCHAR2(1 CHAR) — 예산이월여부
- BG_MSG_CD — VARCHAR2(5 CHAR) — 예산메시지코드
- PRMR_ACCT_TP — VARCHAR2(3 CHAR) — 주요계정유형
- DR_FUND_CD — VARCHAR2(20 CHAR) — 차변자금과목코드
- CR_FUND_CD — VARCHAR2(20 CHAR) — 대변자금과목코드
- TB_PRINT_SQ — NUMBER(5,0) — 합계잔액시산표출력순번
- RESTOUTPT_SQ — NUMBER(5,0) — 그외출력순번
- PRINT_TYPE_CD — VARCHAR2(5 CHAR) — 출력성격코드
- TAXAFS_CD — VARCHAR2(5 CHAR) — 세무코드
- USERDEF1_NM — VARCHAR2(50 CHAR) — 사용자정의1명
- USERDEF2_NM — VARCHAR2(50 CHAR) — 사용자정의2명
- USERDEF3_NM — VARCHAR2(50 CHAR) — 사용자정의3명
- IPLUS_ACCT_CD — VARCHAR2(5 CHAR) — 아이플러스계정코드
- CONN_ACCT_CD — VARCHAR2(20 CHAR) — 연결계정코드
- … +14
MA_CODEDTL
- FIELD_CD — VARCHAR2(10) — Primary key — NOT NULL
- MODULE_CD — VARCHAR2(5) — Primary key — NOT NULL
- SYSDEF_CD — VARCHAR2(5) — Primary key — NOT NULL
- COMPANY_CD — VARCHAR2(7 ) — Foreign key → CI_COMPANY.COMPANY_CD — NOT NULL
- BASE_YN — VARCHAR2(1) — NOT NULL
- CD_FLAG1 — VARCHAR2(50)
- CD_FLAG2 — VARCHAR2(50)
- CD_FLAG3 — VARCHAR2(50)
- CD_USRDEF — VARCHAR2(3)
- DISP_SQ — NUMBER(5,0)
- DRS_CD — VARCHAR2(20)
- DTS_INSERT — VARCHAR2(14)
- DTS_UPDATE — VARCHAR2(14)
- END_DT — VARCHAR2(8)
- FG1_SYSCODE — VARCHAR2(1) — NOT NULL
- FLAG_CD — VARCHAR2(50)
- ID_INSERT — VARCHAR2(15)
- ID_UPDATE — VARCHAR2(15)
- INSERT_DTS — DATE
- INSERT_ID — VARCHAR2(30)
- INSERT_IP — VARCHAR2(200)
- INSERT_MCADDR_NM — VARCHAR2(200)
- NM_SYSDEF — VARCHAR2(200)
- NM_SYSDEF_CH — VARCHAR2(200)
- NM_SYSDEF_E — VARCHAR2(200)
- NM_SYSDEF_JP — VARCHAR2(200)
- NM_SYSDEF_L4 — VARCHAR2(200)
- NM_SYSDEF_L5 — VARCHAR2(200)
- NM_USRDEF — VARCHAR2(60)
- NO_ORDER — VARCHAR2(10)
- REL_FLAG_1_CD — VARCHAR2(50)
- REL_FLAG_2_CD — VARCHAR2(50)
- REL_FLAG_3_CD — VARCHAR2(50)
- REL_FLAG_4_CD — VARCHAR2(50)
- REL_FLAG_5_CD — VARCHAR2(50)
- REMARK — VARCHAR2(100)
- RMK_DC — VARCHAR2(200)
- SYSCODE_YN — VARCHAR2(1)
- SYSDEF_NM — VARCHAR2(100) — NOT NULL
- SYSDEF_NM2 — VARCHAR2(100)
- UP_SYSDEF_CD — VARCHAR2(5)
- UPDATE_DTS — DATE
- UPDATE_ID — VARCHAR2(30)
- UPDATE_IP — VARCHAR2(200)
- UPDATE_MCADDR_NM — VARCHAR2(200)
- USE_YN — VARCHAR2(1)
- WEHAGO_KEY_NO — VARCHAR2(10)
MA_CODEDTL_SDTL
- LANG_CD — VARCHAR2(5) — Primary key — NOT NULL
- FIELD_CD — VARCHAR2(10) — Foreign key → MA_CODEDTL.FIELD_CD — NOT NULL
- MODULE_CD — VARCHAR2(5) — Foreign key → MA_CODEDTL.MODULE_CD — NOT NULL
- SYSDEF_CD — VARCHAR2(5) — Foreign key → MA_CODEDTL.SYSDEF_CD — NOT NULL
- FIELD_NM — VARCHAR2(100)
- FLAG_CD — VARCHAR2(50)
- INSERT_DTS — DATE
- INSERT_ID — VARCHAR2(30)
- INSERT_IP — VARCHAR2(200)
- INSERT_MCADDR_NM — VARCHAR2(200)
- RMK_DC — VARCHAR2(200)
- SYSDEF_NM — VARCHAR2(100)
- UPDATE_DTS — DATE
- UPDATE_ID — VARCHAR2(30)
- UPDATE_IP — VARCHAR2(200)
- UPDATE_MCADDR_NM — VARCHAR2(200
MA_COMPANY
- MA_COMPANY_CD — Primary key — NOT NULL
- COMPANY_CD (COMPANY_CD2) — VARCHAR2(7 ) — Foreign key → CI_COMPANY.COMPANY_CD — NOT NULL
- ACCSEQ_SQ — NUMBER(3,0) — NOT NULL
- ACTG_YR_END_DT — VARCHAR2(8) — NOT NULL
- ACTG_YR_START_DT — VARCHAR2(8) — NOT NULL
- ADS_D — VARCHAR2(400)
- ADS_E — VARCHAR2(800)
- ADS_H — VARCHAR2(400)
- ADS_NO — VARCHAR2(15)
- ADS_NO1 — VARCHAR2(15)
- ADS1_D — VARCHAR2(400)
- ADS1_H — VARCHAR2(400)
- BASE_ADDR — VARCHAR2(100)
- BASE_ADDR2 — VARCHAR2(100)
- BIZR_NO — VARCHAR2(20)
- BIZTP_TP_CD — VARCHAR2(5) — NOT NULL
- CD_CEO — VARCHAR2(10)
- CD_COMPANY — VARCHAR2(7) — NOT NULL
- CD_GROUPWARE — VARCHAR2(20)
- CD_GUN — VARCHAR2(4)
- CEO_BASE_ADDR — VARCHAR2(100)
- CEO_DTL_ADDR — VARCHAR2(100)
- CEO_EMP_NO — VARCHAR2(20)
- CEO_NM — VARCHAR2(100)
- CEO_NM2 — VARCHAR2(50)
- CEO_POST_NO — VARCHAR2(10)
- COMPANY_GN — VARCHAR2(1) — NOT NULL
- COMPANY_NM — VARCHAR2(100) — NOT NULL
- COMPANY_NM2 — VARCHAR2(50)
- CONCORP_FG_CD — VARCHAR2(5)
- COR_NO — VARCHAR2(20)
- CORP_FG_CD — VARCHAR2(5) — NOT NULL
- CORP_TP_CD — VARCHAR2(5)
- DT_OPEN — VARCHAR2(8)
- DT_START — VARCHAR2(8)
- DTL_ADDR — VARCHAR2(100)
- DTL_ADDR2 — VARCHAR2(100)
- DTS_INSERT — VARCHAR2(14)
- DTS_UPDATE — VARCHAR2(14)
- EMAIL_NM — VARCHAR2(50)
- EN_COMPANY — VARCHAR2(50)
- ESTB_DT — VARCHAR2(8)
- EXCH_CD — VARCHAR2(5) — NOT NULL
- FAX_NO — VARCHAR2(20)
- FG_ACCT — VARCHAR2(2)
- FG_COMP — VARCHAR2(2)
- FG_CORP — VARCHAR2(1)
- FG_LANG — VARCHAR2(3) — NOT NULL
- FISCAL_ED — VARCHAR2(8)
- FISCAL_SD — VARCHAR2(8)
- FISCAL_YR — NUMBER(3,0)
- GAAP_CD — VARCHAR2(5) — NOT NULL
- ID_INSERT — VARCHAR2(15)
- ID_UPDATE — VARCHAR2(15)
- INSERT_DTS — DATE
- INSERT_ID — VARCHAR2(30)
- INSERT_IP — VARCHAR2(200)
- INSERT_MCADDR_NM — VARCHAR2(200)
- KSIC_CD — VARCHAR2(5)
- KSIC_SQ_NO — VARCHAR2(5)
- … +39