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