PENSION,KED,NICE,DART

Tables (16)

ABI_1 (NICE재무제표(IFRS))

  • KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
  • ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
  • STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
  • REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
  • RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
  • TOT_AMT (금액) — VARCHAR(13)
  • CONS_RT (구성비) — VARCHAR(6)
  • PERT_RT (증감율) — VARCHAR(6)
  • REG_DT (등록일시) — DATETIME
  • UPD_DT (수정일시) — DATETIME

ABI_2 (NICE재무비율(IFRS))

  • KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
  • ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
  • STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
  • REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
  • RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
  • PERT (비율) — VARCHAR(17)
  • REG_DT (등록일시) — DATETIME
  • UPD_DT (수정일시) — DATETIME

ABI_9 (계정코드(IFRS))

  • REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
  • RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
  • RECD_NM (항목명(한글)) — VARCHAR(50)
  • RECD_ENG_NM (항목명(영문)) — VARCHAR(80)
  • ... — ...

AB_01 (NICE재무제표)

  • KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
  • ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
  • STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
  • REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
  • RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
  • TOT_AMT (금액) — VARCHAR(13)
  • CONS_RT (구성비) — VARCHAR(6)
  • PERT_RT (증감율) — VARCHAR(6)
  • REG_DT (등록일시) — DATETIME
  • UPD_DT (수정일시) — DATETIME

AB_02 (NICE재무비율)

  • KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
  • ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
  • STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
  • REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
  • RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
  • PERT (비율) — VARCHAR(17)
  • REG_DT (등록일시) — DATETIME
  • UPD_DT (수정일시) — DATETIME

AB_09 (계정코드)

  • REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
  • RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
  • REPO_CD (보고서코드2) — VARCHAR(2) — Foreign key → ABI_9.REPO_CD — NOT NULL
  • RECD_CD (항목코드2) — VARCHAR(4) — Foreign key → ABI_9.RECD_CD — NOT NULL
  • RECD_NM (항목명(한글)) — VARCHAR(50)
  • RECD_ENG_NM (항목명(영문)) — VARCHAR(80)
  • ... — ...

C_303 (기업신용등급(CRI등급))

  • KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
  • GRD_FROM_DT (등급시작일자) — VARCHAR(8) — Primary key — NOT NULL
  • KIS_CD (업체코드2) — VARCHAR(6) — Foreign key → EM_02.KIS_CD — NOT NULL
  • SEQ (일련번호) — VARCHAR(4) — Foreign key → EM_02.SEQ — NOT NULL
  • RGNO (사업자번호2) — VARCHAR(10) — Foreign key → EM_02.RGNO — NOT NULL
  • BZ_IDX (기업번호 INDEX) — BIGINT(20) — Foreign key → EM_02.BZ_IDX — NOT NULL
  • GRD_END_DT (등급종료일자) — VARCHAR(8)
  • CRI_BAT_STD_DT (CRI배치기준일자) — CRI배치기준일자
  • STD_ACCT_DT (기준결산일자) — VARCHAR(8)
  • CRI_GRD (CRI등급) — VARCHAR(4)

DART_ENT_OVW (DART기업개황)

  • CORP_CODE (고유번호) — VARCHAR(8) — Primary key — NOT NULL
  • MODIFY_DATE (기업개황 최종변경일) — DATE — Primary key — NOT NULL
  • CORP_NAME (회사명) — VARCHAR(255)
  • BIZR_NO (사업자등록번호) — VARCHAR(30)
  • STOCK_CODE (상장회사 종목코드) — VARCHAR(6)
  • ... — ...

DART_FIST (DART 재무정보 TXT)

  • REPORT_IDX (보고서코드) — VARCHAR(45) — Primary key — NOT NULL
  • STOCK_CODE (상장회사 종목코드) — VARCHAR(8) — Primary key — NOT NULL
  • CORP_CODE (고유번호) — VARCHAR(8) — Foreign key → DART_ENT_OVW.CORP_CODE — NOT NULL
  • MODIFY_DATE (기업개황 최종변경일) — DATE — Foreign key → DART_ENT_OVW.MODIFY_DATE — NOT NULL
  • ACCOUNT_ID (항몽코드) — VARCHAR(45)
  • ACCOUNT_NM (항목명) — VARCHAR(45)
  • THSTRM_NM (당기명) — VARCHAR(15)
  • THSTRM_AMOUNT (당기금액) — VARCHAR(50)
  • FRMTRM_NM (전기명) — VARCHAR(15)
  • FRMTRM_AMOUNT (전기금액) — VARCHAR(50)
  • ... — ...

DATA_PENSION_MASTER (bz_idx)

  • RGNO (사업자번호) — VARCHAR(10) — Primary key — NOT NULL
  • BZ_IDX (기업번호 INDEX) — BIGINT(20) — Primary key — NOT NULL
  • KEDCD (KED기업번호) — VARCHAR(10)
  • KIS_CD (NICE기업번호) — VARCHAR(45)
  • ...

EM01 (업체개요)

  • KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
  • RG_NO (사업자번호) — VARCHAR(10)
  • ... — ...

EM_02 (업체사업장정보)

  • KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
  • SEQ (일련번호) — VARCHAR(4) — Primary key — NOT NULL
  • RGNO (사업자번호2) — VARCHAR(10) — Foreign key → DATA_PENSION_MASTER.RGNO — NOT NULL
  • BZ_IDX (기업번호 INDEX) — BIGINT(20) — Foreign key → DATA_PENSION_MASTER.BZ_IDX — NOT NULL
  • RG_NO (사업자번호) — VARCHAR(10)
  • ... — ...

KED_2022_TBL0002 (기업개요)

  • KEDCD (KED코드) — VARCHAR(10) — Primary key — NOT NULL
  • BZNO (사업자번호) — VARCHAR(10)
  • ... — ...

KED_EW_HIST (KED 신용등급)

  • RGNO (사업자번호) — VARCHAR(10) — Primary key — NOT NULL
  • REG_DT (기준연월일) — VARCHAR(8) — Primary key — NOT NULL
  • EW_CD (신용등급) — INT
  • MONTH (날짜 (월별)) — VARCHAR(6)

KED_TBL0003 (주요재무정보)

  • KEDCD (KED코드) — VARCHAR(10) — Primary key — NOT NULL
  • ACCT_DT (결산기준연월일) — VARCHAR(8) — Primary key — NOT NULL
  • KEDCD (KED코드2) — VARCHAR(10) — Foreign key → KED_2022_TBL0002.KEDCD — NOT NULL
  • SUMAASSET (총자산) — VARCHAR(50)
  • PAYMENTFUND (납입자본금) — VARCHAR(50)
  • FUNDTOTAL (자본총계) — VARCHAR(50)
  • SALES (매출액) — VARCHAR(50)
  • PROFIT (영업이익) — VARCHAR(50)
  • TERMNETPROFIT (당기순이익) — VARCHAR(50)
  • MONTH (날짜 (월별)) — VARCHAR(6)

PENSION (국민연금 EDA 파일)

  • BZ_RGNO (국민연금 사업자번호 6자리) — VARCHAR(6) — Primary key — NOT NULL
  • BZ_IDX (기업번호 INDEX) — INT — Primary key — NOT NULL
  • BZ_NM (기업명) — VARCHAR(60)
  • MONTH (날짜 (월별)) — INT
  • ...