GRIMS
Tables (7)
MST_PGT01_STOP_CODE_KB (저해요인 코드 마스터)
- CODE_TYPE (Key) — VARCHAR(01) — Primary key — NOT NULL — 데이터 유형
- PG01K01 (Key2) — CHAR(1) — Primary key — NOT NULL — 레벨
- PG01K05 (Key3) — VARCHAR(1) — Primary key — NOT NULL — 대분류코드
- PG01K03 (Field2) — VARCHAR(2) — 중분류
- PG01K04 (Field3) — VARCHAR(3) — 소분류 코드
- PG01K05 (Field5) — VARCHAR(6) — 중단내역(재분류)
- PG01K06 (Field6) — VARCHAR(30) — 중단내역(중분류)
- PG01K07 (Field8) — VARCHAR(30) — 중단내역(중분류)
- PG01K08 (Field9) — VARCHAR(30) — 중단내역(소분류)
- PLAN_ADJ (Field10) — CHAR(1) — 계획조정 적용
- YET_IN_ADJ (Field11) — CHAR(1) — 미투입 조정
- OP_ADJ (Field12) — CHAR(1) — 미가동 적용
- ACCEPT (Field13) — CHAR(1) — 인정중단 적용
- EQU_ISSUE (Field14) — CHAR(1) — 장비공장 적용
- ROW_ID (Field15) — NUMBER — 가동종합
- ROW_SUM (Field16) — NUMBER — 가종종합 SUB
- ROW_REC1 (Field17) — NUMBER
- ROW_REC2 (Field18) — NUMBER
- ROW_REC3 (Field19) — NUMBER
- ROW_REC4 (Field20) — NUMBER
- PG01K96 (Field) — VARCHAR(20) — 입력일자
- PG01K97 (Field4) — CHAR(8) — 입력사번
- PG01K98 (Field7) — VARCHAR(20) — 수정일자
- PG01K99 (Field21) — CHAR(8) — 수정사번
- PG01K09 (Field22) — CHAR(1) — 프레스 적용
- PG01K10 (Field23) — CHAR(1) — 소재적용
- PG01K11 (Field24) — VARCHAR(8) — 적용시작일
- PG01K12 (Field25) — VARCHAR(8) — 적용완료일
- PG01K13 (Field26) — CHAR(1) — 적용예비4
MST_PGT01_STOP_MAPPING (저해요인 코드 매핑)
- CATEGORY (Key) — VARCHAR(05) — Primary key — 데이터 유형
- VERSION (Key2) — CHAR(02) — Primary key — 레벨
- CODE_TYPE (Key3) — VARCHAR(1) — Primary key — 대분류코드
- PG01K01 (Key5) — CHAR(1) — Primary key — NOT NULL — 레벨
- PG01K02 (Key6) — CHAR(1) — Primary key — NOT NULL — 대분류
- PG01K03 (Key7) — VCHAR(2) — Primary key — NOT NULL — 중분류
- PG01K04 (Key8) — VCHAR(3) — Primary key — NOT NULL — 소분류
- CODE_TYPE (Key4) — VARCHAR(01) — Foreign key → MST_PGT01_STOP_CODE_KB.CODE_TYPE — NOT NULL — 데이터 유형
- PG01K01 (Key22) — CHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K01 — NOT NULL — 레벨
- PG01K05 (Key32) — VARCHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K05 — NOT NULL — 대분류코드
- PG01K05 (Field6) — VARCHAR(02) — NOT NULL — 분류코드 (EX, 중단현황=A)
- PG01K06 (Field8) — NUMBER — NOT NULL — 순서
PGT05_PROD_HISTORY_BB (가동률 실적)
- PG05B01 (Key) — CHAR(8) — Primary key — NOT NULL — 실적 조업일
- PG05B03 (Key3) — CHAR(1) — Primary key — NOT NULL
- ERP_KEY (Key2) — VARCHAR(27) — Primary key — NOT NULL — ERP KEY
- SHOP (Field7) — VARCHAR(1) — SHOP
- LINE (Field8) — VARCHAR(10) — 라인번호
- PG05B04 (Field15) — NUMBER(3) — 작업시간(가동형태)
- PG05B05 (Field16) — NUMBER(5) — 작업시간(정규)
- PG05B06 (Field17) — NUMBER(5) — 작업시간(잔업)
- PG05B07 (Field18) — NUMBER(5) — 휴식(1 SHIFT)
- PG05B08 (Field19) — NUMBER(5) — 특근(1 SHIFT)
- PG05B10 (Field20) — NUMBER(5) — 특근생산계획(1 SHIFT)
- PG05B11 (Field21) — NUMBER(3) — 조업형태(2 SHIFT)
- PG05B12 (Field22) — NUMBER(3) — 정규(2 SHIFT)
- PG05B09 (Field23) — NUMBER(5) — 잔업(2 SHIFT)
- PG05B13 (Field24) — NUMBER(5) — 휴식(2 SHIFT)
- YET_IN_ADJ_REGULAR (Field25) — NUMBER(5) — 특근(2 SHIFT)
- YET_IN_ADJ_OVER (Field26) — NUMBER(5) — 특근생산계획(2 SHIFT)
- YET_IN_ADJ_EXTRA (Field27) — NUMBER(5) — 조업형태(3 SHIFT)
- OP_ADJ_TTL (Field28) — NUMBER(5) — 정규(3 SHIFT)
- OP_ADJ_REGUALR (Field29) — NUMBER(5) — 잔업(3 SHIFT)
- OP_ADJ_OVER (Field30) — NUMBER(5) — 휴식(3 SHIFT)
- OP_ADJ_EXTRA (Field31) — NUMBER(5) — 특근(3 SHIFT)
- PG05B14 (Field32) — NUMBER(5) — 특근생산계획(3 SHIFT)
- ACCEPT_STOP_NORMAL (Field) — NUMBER(5) — GROSS
- ACCEPT_STOP_EXTRA (Field33) — NUMBER(5) — 총가동분
- ACCEPT_STOP_EXTRA (Field34) — NUMBER(5) — 최대능력
- PG05B15 (Field35) — NUMBER(5) — 운영능력(TTL)
- PG05B16 (Field36) — NUMBER(5) — 운영능력(정규)
- PG05B17 (Field37) — NUMBER(5) — 운영능력(잔업)
- PROD_IN_REGULAR (Field38) — NUMBER(5) — 운영능력(특근)
- PROD_IN_OVER (Field39) — NUMBER(5) — 운영능력(평일)
- PROD_IN_EXTRA (Field40) — NUMBER(5) — 운영가동률
- PROD_OUT_TTL (Field41) — NUMBER(5) — 목표가동률
- PROD_OUT_REGULAR (Field42) — NUMBER(5) — T/T'
- PROD_OUT_OVER (Field43) — NUMBER(5) — UPH
- PROD_IN_EXTRA (Field44) — NUMBER(5) — 작업형태(1 SHFT)
- PATTERN (Field45) — VARCHAR(5) — 작업형태(2 SHFT)
- PG05B19 (Field46) — NUMBER(8,4) — 작업형태(3 SHFT)
- PG05B20 (Field2) — NUMBER(8,4)
- PG05B21 (Field3) — NUMBER(8,3)
- PG05B22 (Field4) — NUMBER(8,3)
- INS_USER (Field5) — VARCHAR(20)
- INS_DATE (Field6) — CHAR(8)
- UPD_USER (Field9) — VARCHAR(20)
- UPD_DATE (Field10) — CHAR(8)
- PLAN_REGULAR_TYPE (Field11) — VARCHAR(1)
PGT05_STOP_HISTORY_AB (저해요인 관리)
- PG05A01 (Key) — VARCHAR(08) — Primary key — NOT NULL — 해당일
- PG05A03 (Key2) — VARCHAR(1) — Primary key — NOT NULL — 주야구분
- PG05A04 (Key3) — VARCHAR(6) — Primary key — NOT NULL — 저해요인 코드
- PG05A05 (Key4) — NUMBER(3) — Primary key — NOT NULL — 회차1
- PG05A06 (Key5) — NUMBER(3) — Primary key — NOT NULL — 회차2
- ERP_KEY (Key6) — VARCHAR(27) — Primary key — NOT NULL — ERP KEY
- CODE_TYPE (Key7) — VARCHAR(01) — Foreign key → MST_PGT01_STOP_CODE_KB.CODE_TYPE — NOT NULL — 데이터 유형
- PG01K01 (Key22) — CHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K01 — NOT NULL — 레벨
- PG01K05 (Key32) — VARCHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K05 — NOT NULL — 대분류코드
- SHOP (Field) — VARCHAR(1) — SHOP
- LINE (Field2) — VARCHAR(10) — LINE
- PG05A07 (Field3) — VARCHAR(1) — 계산형태
- PG05A08 (Field4) — VARCHAR(3) — 차종
- PG05A09 (Field5) — VARCHAR(4) — 중단시각(FROM)
- PG05A10 (Field6) — VARCHAR(4) — 중단시각(TO)
- PG05A11 (Field7) — NUMBER(5) — 중단분
- PG05A12 (Field8) — NUMBER(3) — 회수
- PG05A13 (Field9) — NUMBER(12,4)
- PG05A14 (Field10) — VARCHAR(20)
- PG05A15 (Field11) — VARCHAR(4000)
- PG05A16 (Field12) — VARCHAR(210)
- PG05A17 (Field13) — VARCHAR(210)
- PG05A18 (Field14) — VARCHAR(1)
- PG05A19 (Field15) — VARCHAR(1)
- PG05A20 (Field16) — VARCHAR(1)
- PG05A21 (Field17) — VARCHAR(3)
- PG05A22 (Field18) — VARCHAR(3)
- PG05A23 (Field19) — VARCHAR(2)
- PG05A24 (Field20) — NUMBER(10,3)
- PG05A25 (Field21) — VARCHAR(20)
- PG05A30 (Field22) — VARCHAR(100)
- PG05A31 (Field23) — VARCHAR(1)
- INS_USER (Field24) — VARCHAR(20)
- INS_DATE (Field25) — CHAR(8)
- UPD_USER (Field26) — VARCHAR(20)
- UPD_DATE (Field27) — CHAR(8)
- FIL1 (Field28) — VARCHAR(20)
- FIL2 (Field29) — VARCHAR(20)
- CATEGORY (Field30) — VARCHAR(1)
- APMS_SEQ (Field31) — NUMBER(6)
- APMS_LINE (Field32) — VARCHAR(20)
PGT06_ACTION_PLAN_CB (기동률 계획)
- SHOP_DATE (Key) — CHAR(8) — Primary key — NOT NULL — 계획 조업일
- ERP_KEY (Key2) — VARCHAR(27) — Primary key — NOT NULL — ERP KEY
- ERP_CODE (Field6) — VARCHAR(5) — ERP CODE
- SHOP (Field7) — VARCHAR(1) — SHOP
- LINE (Field8) — VARCHAR(10) — 라인번호
- RF_PT (Field9) — CHAR(6) — RF_PT
- PROD_TYPE (Field10) — CHAR(1) — 가동구분
- WORK_TYPE_1_HOUR (Field15) — NUMBER(7,3) — 조업형태(1 SHIFT)
- WORK_TYPE_1_REGULAR_MIN (Field16) — NUMBER(7,3) — 정규(1 SHIFT)
- WORK_TYPE_1_OVER_MIN (Field17) — NUMBER(7,3) — 잔업(1 SHIFT)
- WORK_TYPE_1_BREAK_MIN (Field18) — NUMBER(7,3) — 휴식(1 SHIFT)
- WORK_TYPE_1_EXTRA_MIN (Field19) — NUMBER(7,3) — 특근(1 SHIFT)
- WORK_TYPE_1_EXTRA_PLAN (Field20) — NUMBER(7,3) — 특근생산계획(1 SHIFT)
- WORK_TYPE_2_HOUR (Field21) — NUMBER(7,3) — 조업형태(2 SHIFT)
- WORK_TYPE_2_REGULAR_MIN (Field22) — NUMBER(7,3) — 정규(2 SHIFT)
- WORK_TYPE_2_OVER_MIN (Field23) — NUMBER(7,3) — 잔업(2 SHIFT)
- WORK_TYPE_2_BREAK_MIN (Field24) — NUMBER(7,3) — 휴식(2 SHIFT)
- WORK_TYPE_2_EXTRA_MIN (Field25) — NUMBER(7,3) — 특근(2 SHIFT)
- WORK_TYPE_2_EXTRA_PLAN (Field26) — NUMBER(7,3) — 특근생산계획(2 SHIFT)
- WORK_TYPE_3_HOUR (Field27) — NUMBER(7,3) — 조업형태(3 SHIFT)
- WORK_TYPE_3_REGULAR_MIN (Field28) — NUMBER(7,3) — 정규(3 SHIFT)
- WORK_TYPE_3_OVER_MIN (Field29) — NUMBER(7,3) — 잔업(3 SHIFT)
- WORK_TYPE_3_BREAK_MIN (Field30) — NUMBER(7,3) — 휴식(3 SHIFT)
- WORK_TYPE_3_EXTRA_MIN (Field31) — NUMBER(7,3) — 특근(3 SHIFT)
- WORK_TYPE_3_EXTRA_PLAN (Field32) — NUMBER(7,3) — 특근생산계획(3 SHIFT)
- GROSS_MIN (Field) — NUMBER(7,3) — GROSS
- TOTAL_WORK_MIN (Field33) — NUMBER(10,3) — 총가동분
- MAX_CAPA (Field34) — NUMBER(7,3) — 최대능력
- OP_CAPA_TTL (Field35) — NUMBER(7,3) — 운영능력(TTL)
- OP_CAPA_REGULAR (Field36) — NUMBER(7,3) — 운영능력(정규)
- OP_CAPA_OVER (Field37) — NUMBER(7,3) — 운영능력(잔업)
- OP_CAPA_EXTRA (Field38) — NUMBER(7,3) — 운영능력(특근)
- OP_CAPA_NORMAL (Field39) — NUMBER(7,3) — 운영능력(평일)
- OP_RATE (Field40) — NUMBER(7,3) — 운영가동률
- TARGET (Field41) — NUMBER(7,3) — 목표가동률
- TT (Field42) — NUMBER(8,4) — T/T'
- UPH (Field43) — NUMBER(8,4) — UPH
- PLAN_REGULAR_TYPE_1 (Field44) — VARCHAR(1) — 작업형태(1 SHFT)
- PLAN_REGULAR_TYPE_2 (Field45) — VARCHAR(1) — 작업형태(2 SHFT)
- PLAN_REGULAR_TYPE_3 (Field46) — VARCHAR(1) — 작업형태(3 SHFT)
PGT10_OP_RT_DB (기동률 집계(계획_실적))
- PG10DYYYY (Key) — CHAR(4) — Primary key — NOT NULL — 해당일
- PG10DMM (Key2) — CHAR(2) — Primary key — NOT NULL
- PG10DRECDAY (Key3) — NUMBER — Primary key — NOT NULL — 저해요인 코드
- PG10DTYPE (Key4) — CHAR(2) — Primary key — NOT NULL — 회차1
- PG10DLEVEL (Key5) — NUMBER — Primary key — NOT NULL — 회차2
- PG10DVER (Key6) — NUMBER — Primary key — NOT NULL — 생성버전
- PG10DSEQ (Key7) — NUMBER — Primary key — NOT NULL — SEQ
- PG05A01 (Key8) — VARCHAR(08) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A01 — NOT NULL — 해당일
- PG05A03 (Key22) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A03 — NOT NULL — 주야구분
- PG05A04 (Key32) — VARCHAR(6) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A04 — NOT NULL — 저해요인 코드
- PG05A05 (Key42) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A05 — NOT NULL — 회차1
- PG05A06 (Key52) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A06 — NOT NULL — 회차2
- ERP_KEY (Key62) — VARCHAR(27) — Foreign key → PGT05_STOP_HISTORY_AB.ERP_KEY — NOT NULL — ERP KEY
- CODE_TYPE (Key72) — VARCHAR(01) — Foreign key → PGT05_STOP_HISTORY_AB.CODE_TYPE — NOT NULL — 데이터 유형
- PG01K01 (Key222) — CHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K01 — NOT NULL — 레벨
- PG01K05 (Key322) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K05 — NOT NULL — 대분류코드
- SHOP_DATE (Key9) — CHAR(8) — Foreign key → PGT06_ACTION_PLAN_CB.SHOP_DATE — NOT NULL — 계획 조업일
- ERP_KEY (Key23) — VARCHAR(27) — Foreign key → PGT06_ACTION_PLAN_CB.ERP_KEY — NOT NULL — ERP KEY
- PG05B01 (Key10) — CHAR(8) — Foreign key → PGT05_PROD_HISTORY_BB.PG05B01 — NOT NULL — 실적 조업일
- PG05B03 (Key33) — Foreign key → PGT05_PROD_HISTORY_BB.PG05B03 — NOT NULL
- ERP_KEY (Key24) — VARCHAR(27) — Foreign key → PGT05_PROD_HISTORY_BB.ERP_KEY — NOT NULL — ERP KEY
- SHOP_DATE (Key34) — CHAR(8) — Foreign key → PGT10__OP_STOP_DB.SHOP_DATE — NOT NULL — 조업일자
- CATEGORY (Key43) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.CATEGORY — NOT NULL — 계열
- LOCATION (Key11) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.LOCATION — NOT NULL — 지역
- COMPANY (Key25) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.COMPANY — NOT NULL — 법인
- AREA (Key53) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.AREA — NOT NULL — 지역
- PLANT (Key63) — VARCHAR(5) — Foreign key → PGT10__OP_STOP_DB.PLANT — NOT NULL — 공장번호
- ERP_CODE (Key73) — VARCHAR(5) — Foreign key → PGT10__OP_STOP_DB.ERP_CODE — NOT NULL — ERP CODE
- SHOP (Key82) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.SHOP — NOT NULL — SHOP
- LINE (Key92) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.LINE — NOT NULL — LINE
- DG (Key102) — CHAR(2) — Foreign key → PGT10__OP_STOP_DB.DG — NOT NULL — DG
- LEVEL (Key112) — NUMBER — Foreign key → PGT10__OP_STOP_DB.LEVEL — NOT NULL — LEVEL
- PG05A19 (Key12) — VARCHAR(30) — Foreign key → PGT10__OP_STOP_DB.PG05A19 — NOT NULL — 자타공정 구분
- PG05A23 (Key13) — VARCHAR(5) — Foreign key → PGT10__OP_STOP_DB.PG05A23 — NOT NULL — 저해요인 코드_중분류
- PG05A04 (Key14) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.PG05A04 — NOT NULL — 저해요인 코드_소분류
- PG05A01 (Key15) — VARCHAR(08) — Foreign key → PGT10__OP_STOP_DB.PG05A01 — NOT NULL — 해당일
- PG05A03 (Key223) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.PG05A03 — NOT NULL — 주야구분
- PG05A04 (Key323) — VARCHAR(6) — Foreign key → PGT10__OP_STOP_DB.PG05A04 — NOT NULL — 저해요인 코드
- PG05A05 (Key422) — NUMBER(3) — Foreign key → PGT10__OP_STOP_DB.PG05A05 — NOT NULL — 회차1
- PG05A06 (Key522) — NUMBER(3) — Foreign key → PGT10__OP_STOP_DB.PG05A06 — NOT NULL — 회차2
- ERP_KEY (Key622) — VARCHAR(27) — Foreign key → PGT10__OP_STOP_DB.ERP_KEY — NOT NULL — ERP KEY
- CODE_TYPE (Key722) — VARCHAR(01) — Foreign key → PGT10__OP_STOP_DB.CODE_TYPE — NOT NULL — 데이터 유형
- PG01K01 (Key2222) — CHAR(1) — Foreign key → PGT10__OP_STOP_DB.PG01K01 — NOT NULL — 레벨
- PG01K05 (Key3222) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.PG01K05 — NOT NULL — 대분류코드
- CATEGORY (Field2) — VARCHAR(1) — 계열
- LOCATION (Field3) — VARCHAR(1) — 지역
- COMPANY (Field71) — VARCHAR(10) — 법인
- AREA (Field4) — VARCHAR(10) — 차종
- PLANT (Field5) — VARCHAR(5) — 공장번호
- ERP_CODE (Field6) — VARCHAR(5) — ERP CODE
- SHOP (Field7) — VARCHAR(1) — SHOP
- LINE (Field8) — VARCHAR(10) — 라인번호
- PG10DDISPLAY (Field9) — CHAR(1) — 사용여부
- PG10DEA (Field10) — CHAR(2) — 시간계(TI),대수계(EA),개수계(NO)구분
- PG10DRECSUB (Field11) — NUMBER — 서브코드
- PG10DMODEL (Field12) — CHAR(3) — 차종
- PG10DKFL1 (Field13) — NUMBER — 여유1
- PG10DKFL2 (Field14) — VARCHAR(30) — 여유2
- WORK_TYPE1_1 (Field15) — NUMBER(12,4) — 가동계획_조업형태(1SH)
- WORK_TYPE2_1 (Field16) — NUMBER(12,4) — 가동계획_조업형태(2SH)
- … +55
PGT10__OP_STOP_DB (가동률 집계(저해요인))
- SHOP_DATE (Key3) — CHAR(8) — Primary key — NOT NULL — 조업일자
- CATEGORY (Key4) — VARCHAR(1) — Primary key — NOT NULL — 계열
- LOCATION (Key) — VARCHAR(1) — Primary key — NOT NULL — 지역
- COMPANY (Key2) — VARCHAR(10) — Primary key — NOT NULL — 법인
- AREA (Key5) — VARCHAR(10) — Primary key — NOT NULL — 지역
- PLANT (Key6) — VARCHAR(5) — Primary key — NOT NULL — 공장번호
- ERP_CODE (Key7) — VARCHAR(5) — Primary key — NOT NULL — ERP CODE
- SHOP (Key8) — VARCHAR(1) — Primary key — NOT NULL — SHOP
- LINE (Key9) — VARCHAR(10) — Primary key — NOT NULL — LINE
- DG (Key10) — CHAR(2) — Primary key — NOT NULL — DG
- LEVEL (Key11) — NUMBER — Primary key — NOT NULL — LEVEL
- PG05A19 (Key12) — VARCHAR(30) — Primary key — NOT NULL — 자타공정 구분
- PG05A23 (Key13) — VARCHAR(5) — Primary key — NOT NULL — 저해요인 코드_중분류
- PG05A04 (Key14) — VARCHAR(10) — Primary key — NOT NULL — 저해요인 코드_소분류
- PG05A01 (Key15) — VARCHAR(08) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A01 — NOT NULL — 해당일
- PG05A03 (Key22) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A03 — NOT NULL — 주야구분
- PG05A04 (Key32) — VARCHAR(6) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A04 — NOT NULL — 저해요인 코드
- PG05A05 (Key42) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A05 — NOT NULL — 회차1
- PG05A06 (Key52) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A06 — NOT NULL — 회차2
- ERP_KEY (Key62) — VARCHAR(27) — Foreign key → PGT05_STOP_HISTORY_AB.ERP_KEY — NOT NULL — ERP KEY
- CODE_TYPE (Key72) — VARCHAR(01) — Foreign key → PGT05_STOP_HISTORY_AB.CODE_TYPE — NOT NULL — 데이터 유형
- PG01K01 (Key222) — CHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K01 — NOT NULL — 레벨
- PG01K05 (Key322) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K05 — NOT NULL — 대분류코드
- TI (Field4) — NUMBER(12,4) — TI
- EA (Field5) — NUMBER(12,4) — EA
- NO (Field6) — NUMBER(12,4) — NO