mes
Tables (25)
TB_MQC_BLT_DLY_STOCK
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- STOCK_SUMUP_DT — VARCHAR2(8) — Primary key — NOT NULL — 재고기준일자
- STR_LOC — VARCHAR2(4) — Primary key — NOT NULL — 저장위치
- MTL_CD — VARCHAR2(13) — Primary key — NOT NULL — 자재코드
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- USB_STOCK_BD_QTY — NUMBER(6) — 가용재고번들수량
- USB_STOCK_PIECE_QTY — NUMBER(6) — 가용재고개별수량
- USB_STOCK_WGT — NUMBER(12,3) — 가용재고중량
- HLD_STOCK_BD_QTY — NUMBER(6) — 보류재고번들수량
- HLD_STOCK_PIECE_QTY — NUMBER(6) — 보류재고개별수량
- HLD_STOCK_WGT — NUMBER(12,3) — 보류재고중량
- TOT_STOCK_BD_QTY — NUMBER(6) — 번들수량합계
- TOT_STOCK_PIECE_QTY — NUMBER(6) — 개별수량합계
- TOT_STOCK_WGT — NUMBER(12,3) — 중량합계
TB_MQC_BLT_HEAT_RSLT
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- HEAT_NO — VARCHAR2(6) — Primary key — NOT NULL — HEAT번호
- PROC_TP — VARCHAR2(2) — Primary key — NOT NULL — 공정구분
- HEAT_RSLT_SEQ — NUMBER(1) — Primary key — NOT NULL — HEAT성분실적순서
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- OP_TP — VARCHAR2(1) — 조업구분
- OP_FACTR_TP — VARCHAR2(2) — 조업공장구분
- MTL_CD — VARCHAR2(13) — 자재코드
- INSP_NO — VARCHAR2(15) — 검사번호
- INSP_SUMUP_DT — VARCHAR2(8) — 검사기준일자
- INSP_DT — DATE — 검사일자
- INSP_OP_SFT — VARCHAR2(2) — 검사근무조
- INST_GRAD_CD — VARCHAR2(20) — 지시강종
- GRAD_CD — VARCHAR2(20) — 강종
- BLT_COMP_C — NUMBER(5,1) — C
- C_JUDG_FLAG — VARCHAR2(1) — C판정결과
- BLT_COMP_SI — NUMBER(5,1) — Si
- SI_JUDG_FLAG — VARCHAR2(1) — Si판정결과
- BLT_COMP_MN — NUMBER(5,1) — Mn
- MN_JUDG_FLAG — VARCHAR2(1) — Mn판정결과
- BLT_COMP_P — NUMBER(5,1) — P
- P_JUDG_FLAG — VARCHAR2(1) — P판정결과
- BLT_COMP_S — NUMBER(5,1) — S
- S_JUDG_FLAG — VARCHAR2(1) — S판정결과
- BLT_COMP_CU — NUMBER(5,1) — Cu
- CU_JUDG_FLAG — VARCHAR2(1) — Cu판정결과
- BLT_COMP_CR — NUMBER(5,1) — Cr
- CR_JUDG_FLAG — VARCHAR2(1) — Cr판정결과
- BLT_COMP_NI — NUMBER(5,1) — Ni
- NI_JUDG_FLAG — VARCHAR2(1) — Ni판정결과
- BLT_COMP_V — NUMBER(5,1) — V
- V_JUDG_FLAG — VARCHAR2(1) — V판정결과
- BLT_COMP_PB — NUMBER(5,1) — Pb
- PB_JUDG_FLAG — VARCHAR2(1) — Pb판정결과
- BLT_COMP_SN — NUMBER(5,1) — Sn
- SN_JUDG_FLAG — VARCHAR2(1) — Sn판정결과
- BLT_COMP_MO — NUMBER(5,1) — Mo
- MO_JUDG_FLAG — VARCHAR2(1) — Mo판정결과
- BLT_COMP_B — NUMBER(5,1) — B
- B_JUDG_FLAG — VARCHAR2(1) — B판정결과
- BLT_COMP_AL — NUMBER(5,1) — Al
- AL_JUDG_FLAG — VARCHAR2(1) — Al판정결과
- BLT_COMP_TI — NUMBER(5,1) — Ti
- … +16
TB_MQC_BLT_PUR_DETL
- PRCH_NO — VARCHAR2(10) — Primary key — NOT NULL — 구매문서번호
- PRCH_LN — VARCHAR2(6) — Primary key — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT — VARCHAR2(8) — Primary key — NOT NULL — 입고기준일자
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- HEAT_NO — VARCHAR2(6) — Primary key — NOT NULL — HEAT번호
- UPLOAD_FLAG — VARCHAR2(1) — Primary key — NOT NULL — Upload구분
- PRCH_NO (PRCH_NO2) — VARCHAR2(10) — Foreign key → TB_MQC_BLT_PUR_MAST.PRCH_NO — NOT NULL — 구매문서번호
- PRCH_LN (PRCH_LN2) — VARCHAR2(6) — Foreign key → TB_MQC_BLT_PUR_MAST.PRCH_LN — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT (RCPT_SUMUP_DT2) — VARCHAR2(8) — Foreign key → TB_MQC_BLT_PUR_MAST.RCPT_SUMUP_DT — NOT NULL — 입고기준일자
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_BLT_PUR_MAST.WORK_TP — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- PROD_KIND — VARCHAR2(4) — 품종
- MTL_CD — VARCHAR2(13) — 자재코드
- PUCH_HEAT_NO — VARCHAR2(14) — 구입HEAT번호
- OP_TP — VARCHAR2(1) — 조업구분
- OP_FACTR_TP — VARCHAR2(2) — 조업공장구분
- GRAD_CD — VARCHAR2(20) — 강종
- BLT_SIZE_CD — VARCHAR2(3) — 빌릿치수코드
- BLT_LEN — NUMBER(5) — 빌릿길이
- BLT_UNIT_WGT — NUMBER(6,3) — 빌릿단중
- HEAT_BLT_QTY — NUMBER(5) — HEAT빌릿수량
- HEAT_BLT_WGT — NUMBER(6) — HEAT빌릿중량
- HEAT_METHOD — VARCHAR2(1) — 제강방식
- RADIATION_POLLUTION — VARCHAR2(1) — Radiation
- DOME_SCRP_RT — NUMBER(3) — 국내고철비율
- BLT_COMP_C — NUMBER(5,1) — C
- C_JUDG_FLAG — VARCHAR2(1) — C판정결과
- BLT_COMP_SI — NUMBER(5,1) — Si
- SI_JUDG_FLAG — VARCHAR2(1) — Si판정결과
- BLT_COMP_MN — NUMBER(5,1) — Mn
- MN_JUDG_FLAG — VARCHAR2(1) — Mn판정결과
- BLT_COMP_P — NUMBER(5,1) — P
- P_JUDG_FLAG — VARCHAR2(1) — P판정결과
- BLT_COMP_S — NUMBER(5,1) — S
- S_JUDG_FLAG — VARCHAR2(1) — S판정결과
- BLT_COMP_CU — NUMBER(5,1) — Cu
- CU_JUDG_FLAG — VARCHAR2(1) — Cu판정결과
- BLT_COMP_CR — NUMBER(5,1) — Cr
- CR_JUDG_FLAG — VARCHAR2(1) — Cr판정결과
- BLT_COMP_NI — NUMBER(5,1) — Ni
- NI_JUDG_FLAG — VARCHAR2(1) — Ni판정결과
- BLT_COMP_V — NUMBER(5,1) — V
- V_JUDG_FLAG — VARCHAR2(1) — V판정결과
- … +22
TB_MQC_BLT_PUR_MAST
- PRCH_NO — VARCHAR2(10) — Primary key — NOT NULL — 구매문서번호
- PRCH_LN — VARCHAR2(6) — Primary key — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT — VARCHAR2(8) — Primary key — NOT NULL — 입고기준일자
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- PROD_KIND — VARCHAR2(4) — 품종
- MTL_CD — VARCHAR2(13) — 자재코드
- REG_SUMUP_DT — VARCHAR2(8) — 등록기준일자
- ACPT_INSP_SUMUP_DT — VARCHAR2(8) — 인수검사기준일자
- UPLOAD_FLAG — VARCHAR2(1) — Upload구분
- RECV_FLAG — VARCHAR2(1) — 수신여부
- VENDOR_CD — VARCHAR2(6) — 입고업체코드
- GRAD_CD — VARCHAR2(20) — 강종
- BLT_SIZE_CD — VARCHAR2(3) — 빌릿치수코드
- BLT_LEN — NUMBER(5) — 빌릿길이
- RCPT_QTY — NUMBER(6) — 입고수량
- RCPT_WGT — NUMBER(8) — 입고중량
- ACPT_INSP_TIMES — NUMBER(2) — 인수검사대상수
- ACPT_INSP_JUDG_FLAG — VARCHAR2(1) — 인수검사판정결과
- INEX_BLT_FLAG — VARCHAR2(1) — 내외부빌릿구분
- REG_DT — DATE — 등록일자
- REG_EMPNO — VARCHAR2(22) — 등록자
- ACPT_INSP_DT — DATE — 인수검사일자
- ACPT_INSP_EMPNO — VARCHAR2(22) — 인수검사자
- CHK_EMPNO — VARCHAR2(22) — 검토자
- APRV_EMPNO — VARCHAR2(22) — 승인자
TB_MQC_BLT_PUR_MEAS
- PRCH_NO — VARCHAR2(10) — Primary key — NOT NULL — 구매문서번호
- PRCH_LN — VARCHAR2(6) — Primary key — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT — VARCHAR2(8) — Primary key — NOT NULL — 입고기준일자
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- SEQ_NO — VARCHAR2(2) — Primary key — NOT NULL — SEQ번호
- PRCH_NO (PRCH_NO2) — VARCHAR2(10) — Foreign key → TB_MQC_BLT_PUR_MAST.PRCH_NO — NOT NULL — 구매문서번호
- PRCH_LN (PRCH_LN2) — VARCHAR2(6) — Foreign key → TB_MQC_BLT_PUR_MAST.PRCH_LN — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT (RCPT_SUMUP_DT2) — VARCHAR2(8) — Foreign key → TB_MQC_BLT_PUR_MAST.RCPT_SUMUP_DT — NOT NULL — 입고기준일자
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_BLT_PUR_MAST.WORK_TP — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- PROD_KIND — VARCHAR2(4) — 품종
- MTL_CD — VARCHAR2(13) — 자재코드
- STRATNS — NUMBER(3) — 직진도
- CUT_PL_STATUS — VARCHAR2(1) — 절단면상태
- SURFACE_CRACK — NUMBER(5,2) — 표면흠
- BURR — NUMBER(4,1) — Burr
- SURFACE_STATUS — VARCHAR2(1) — 표면상태
- WIDTH_MEAS_RSLT — NUMBER(4,1) — 가로측정실적
- WIDTH_MEAS_DEV — NUMBER(3,1) — 가로측정편차
- HEIGHT_MEAS_RSLT — NUMBER(4,1) — 세로측정실적
- HEIGHT_MEAS_DEV — NUMBER(3,1) — 세로측정편차
- LEN_MEAS_RSLT — NUMBER(5) — 길이측정실적
- LEN_MEAS_DEV — NUMBER(4) — 길이측정편차
- OPST_ANGLE — NUMBER(3) — 대각
- RADIATION_POLLUTION — VARCHAR2(1) — Radiation
- DOME_SCRP_RT — NUMBER(3) — 국내고철비
- HEAT_DP_FLAG — VARCHAR2(1) — HEAT표시여부
- MEAS_COMP_C — NUMBER(5,1) — 인수검사C
- C_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수C판정결과
- MEAS_COMP_SI — NUMBER(5,1) — 인수검사Si
- SI_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수Si판정결과
- MEAS_COMP_MN — NUMBER(5,1) — 인수검사Mn
- MN_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수Mn판정결과
- MEAS_COMP_P — NUMBER(5,1) — 인수검사P
- P_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수P판정결과
- MEAS_COMP_S — NUMBER(5,1) — 인수검사S
- S_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수S판정결과
- MEAS_COMP_CU — NUMBER(5,1) — 인수검사Cu
- CU_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수Cu판정결과
- MEAS_COMP_CR — NUMBER(5,1) — 인수검사Cr
- CR_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수Cr판정결과
- MEAS_COMP_V — NUMBER(5,1) — 인수검사V
- V_MEAS_JUDG_FLAG — VARCHAR2(1) — 인수V판정결과
- … +8
TB_MQC_BLT_PUR_RCV
- PRCH_NO — VARCHAR2(10) — Primary key — NOT NULL — 구매문서번호
- PRCH_LN — VARCHAR2(6) — Primary key — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT — VARCHAR2(8) — Primary key — NOT NULL — 입고기준일자
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- HEAT_NO — VARCHAR2(6) — Primary key — NOT NULL — HEAT번호
- BLT_NO — VARCHAR2(15) — Primary key — NOT NULL — 빌릿번호
- UPLOAD_FLAG — VARCHAR2(1) — Primary key — NOT NULL — Upload구분
- PRCH_NO (PRCH_NO2) — VARCHAR2(10) — Foreign key → TB_MQC_BLT_PUR_MAST.PRCH_NO — NOT NULL — 구매문서번호
- PRCH_LN (PRCH_LN2) — VARCHAR2(6) — Foreign key → TB_MQC_BLT_PUR_MAST.PRCH_LN — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT (RCPT_SUMUP_DT2) — VARCHAR2(8) — Foreign key → TB_MQC_BLT_PUR_MAST.RCPT_SUMUP_DT — NOT NULL — 입고기준일자
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_BLT_PUR_MAST.WORK_TP — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- PROD_KIND — VARCHAR2(4) — 품종
- MTL_CD — VARCHAR2(13) — 자재코드
- PUCH_HEAT_NO — VARCHAR2(14) — 구입HEAT번호
- GRAD_CD — VARCHAR2(20) — 강종
- BLT_SIZE_CD — VARCHAR2(3) — 빌릿치수코드
- BLT_LEN — NUMBER(5) — 빌릿길이
- BLT_QTY — NUMBER(5) — 빌릿수량
- BLT_WGT — NUMBER(6) — 빌릿중량
TB_MQC_BLT_TRF
- TRF_ORDER_NO — VARCHAR2(10) — Primary key — NOT NULL — 이송지시번호
- TRF_ORDER_LN — VARCHAR2(6) — Primary key — NOT NULL — 이송지시행번
- HEAT_NO — VARCHAR2(15) — Primary key — NOT NULL — Heat번호
- MTL_CD — VARCHAR2(13) — Primary key — NOT NULL — 자재코드
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- TRF_ORDER_QTY — NUMBER(6) — 이송지시수량
- TRF_ORDER_WGT — NUMBER(12,3) — 이송지시중량
- DELY_SUMUP_DT — VARCHAR2(8) — 납품일
- TRF_TGT_FAC — VARCHAR2(1) — 이송대상공장
- STR_LOC — VARCHAR2(4) — 저장위치
- REQ_SUMUP_DT — VARCHAR2(8) — 요청기준일자
- REQ_DT — DATE — 요청일자
- REQ_EMPNO — VARCHAR2(22) — 요청자
- TRF_ORDER_FLAG — VARCHAR2(1) — 이송오더진행구분
TB_MQC_BLT_TRF_HIS
- TRF_ORDER_NO — VARCHAR2(10) — Primary key — NOT NULL — 이송지시번호
- TRF_ORDER_LN — VARCHAR2(6) — Primary key — NOT NULL — 이송지시행번
- HEAT_NO — VARCHAR2(15) — Primary key — NOT NULL — Heat번호
- MTL_CD — VARCHAR2(13) — Primary key — NOT NULL — 자재코드
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- HIS_SEQ — NUMBER(2) — Primary key — NOT NULL — 이력SEQ
- TRF_ORDER_NO (TRF_ORDER_NO2) — VARCHAR2(10) — Foreign key → TB_MQC_BLT_TRF.TRF_ORDER_NO — NOT NULL — 이송지시번호
- TRF_ORDER_LN (TRF_ORDER_LN2) — VARCHAR2(6) — Foreign key → TB_MQC_BLT_TRF.TRF_ORDER_LN — NOT NULL — 이송지시행번
- HEAT_NO (HEAT_NO2) — VARCHAR2(15) — Foreign key → TB_MQC_BLT_TRF.HEAT_NO — NOT NULL — Heat번호
- MTL_CD (MTL_CD2) — VARCHAR2(13) — Foreign key → TB_MQC_BLT_TRF.MTL_CD — NOT NULL — 자재코드
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_BLT_TRF.WORK_TP — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- TRF_ORDER_QTY — NUMBER(6) — 이송지시수량
- TRF_ORDER_WGT — NUMBER(12,3) — 이송지시중량
- DELY_SUMUP_DT — VARCHAR2(8) — 납품일
- TRF_TGT_FAC — VARCHAR2(1) — 이송대상공장
- STR_LOC — VARCHAR2(4) — 저장위치
- REQ_SUMUP_DT — VARCHAR2(8) — 요청기준일자
- REQ_DT — DATE — 요청일자
- REQ_EMPNO — VARCHAR2(22) — 요청자
- TRF_ORDER_FLAG — VARCHAR2(1) — 이송오더진행구분
TB_MQC_HEAT_MAST
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- HEAT_NO — VARCHAR2(6) — Primary key — NOT NULL — HEAT번호
- PRCH_NO — VARCHAR2(10) — Foreign key → TB_MQC_BLT_PUR_DETL.PRCH_NO — NOT NULL — 구매문서번호
- PRCH_LN — VARCHAR2(6) — Foreign key → TB_MQC_BLT_PUR_DETL.PRCH_LN — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT — VARCHAR2(8) — Foreign key → TB_MQC_BLT_PUR_DETL.RCPT_SUMUP_DT — NOT NULL — 입고기준일자
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_BLT_PUR_DETL.WORK_TP — NOT NULL — 사업장구분
- HEAT_NO (HEAT_NO2) — VARCHAR2(6) — Foreign key → TB_MQC_BLT_PUR_DETL.HEAT_NO — NOT NULL — HEAT번호
- UPLOAD_FLAG — VARCHAR2(1) — Foreign key → TB_MQC_BLT_PUR_DETL.UPLOAD_FLAG — NOT NULL — Upload구분
- PRCH_NO (PRCH_NO2) — VARCHAR2(10) — Foreign key → TB_MQC_BLT_PUR_DETL.PRCH_NO — NOT NULL — 구매문서번호
- PRCH_LN (PRCH_LN2) — VARCHAR2(6) — Foreign key → TB_MQC_BLT_PUR_DETL.PRCH_LN — NOT NULL — 구매문서행번
- RCPT_SUMUP_DT (RCPT_SUMUP_DT2) — VARCHAR2(8) — Foreign key → TB_MQC_BLT_PUR_DETL.RCPT_SUMUP_DT — NOT NULL — 입고기준일자
- WORK_TP (WORK_TP22) — VARCHAR2(1) — Foreign key → TB_MQC_BLT_PUR_DETL.WORK_TP — NOT NULL — 사업장구분
- WORK_TP (WORK_TP3) — VARCHAR2(1) — Foreign key → TB_MQC_BLT_HEAT_RSLT.WORK_TP — NOT NULL — 사업장구분
- HEAT_NO (HEAT_NO3) — VARCHAR2(6) — Foreign key → TB_MQC_BLT_HEAT_RSLT.HEAT_NO — NOT NULL — HEAT번호
- PROC_TP — VARCHAR2(2) — Foreign key → TB_MQC_BLT_HEAT_RSLT.PROC_TP — NOT NULL — 공정구분
- HEAT_RSLT_SEQ — NUMBER(1) — Foreign key → TB_MQC_BLT_HEAT_RSLT.HEAT_RSLT_SEQ — NOT NULL — HEAT성분실적순서
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- BLT_COMP_C — NUMBER(5,1) — C
- BLT_COMP_SI — NUMBER(5,1) — Si
- BLT_COMP_MN — NUMBER(5,1) — Mn
- BLT_COMP_P — NUMBER(5,1) — P
- BLT_COMP_S — NUMBER(5,1) — S
- BLT_COMP_CU — NUMBER(5,1) — Cu
- BLT_COMP_CR — NUMBER(5,1) — Cr
- BLT_COMP_NI — NUMBER(5,1) — Ni
- BLT_COMP_V — NUMBER(5,1) — V
- BLT_COMP_PB — NUMBER(5,1) — Pb
- BLT_COMP_SN — NUMBER(5,1) — Sn
- BLT_COMP_MO — NUMBER(5,1) — Mo
- BLT_COMP_B — NUMBER(5,1) — B
- BLT_COMP_AL — NUMBER(5,1) — Al
- BLT_COMP_TI — NUMBER(5,1) — Ti
- BLT_COMP_CO — NUMBER(5,1) — Co
- BLT_COMP_NB — NUMBER(5,1) — Nb
- BLT_COMP_N — NUMBER(5,1) — N
- BLT_COMP_MCC — NUMBER(5,1) — MCC
- BLT_COMP_CEQ — NUMBER(5,1) — CEQ
TB_MQC_NEFFC_LIST
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- NEFFC_PROC — VARCHAR2(1) — Primary key — NOT NULL — 부적합공정
- NEFFC_TP — VARCHAR2(1) — Primary key — NOT NULL — 부적합구분
- PROD_SUMUP_DT — VARCHAR2(8) — Primary key — NOT NULL — 생산기준일자
- GRAD_CD — VARCHAR2(20) — Primary key — NOT NULL — 강종
- SIZE_CD — VARCHAR2(3) — Primary key — NOT NULL — 사이즈
- PROD_LEN — NUMBER(8) — Primary key — NOT NULL — 제품길이
- NEFFC_LAR_CLS — VARCHAR2(2) — Primary key — NOT NULL — 부적합대분류
- NEFFC_MID_CLS — VARCHAR2(3) — Primary key — NOT NULL — 부적합중분류
- NEFFC_SML_CLS — VARCHAR2(1) — Primary key — NOT NULL — 부적합소분류
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- OCR_WGT — NUMBER(8) — 발생량
- NOR_WGT — NUMBER(8) — 정상품량
- JUDG_WAIT_WGT — NUMBER(8) — 판정대기량
- DUSE_WGT — NUMBER(8) — 폐기량
- NEFFC_NTC_SUMUP_DT — VARCHAR2(8) — 부적합통보일자
- CORACT_RPY_SUMUP_DT — VARCHAR2(8) — 시정조치회신일자
- EFFC_VRF_SUMUP_DT — VARCHAR2(8) — 유효성검증완료일자
- NEFFC_RPT_ATCM1 — VARCHAR2(180) — 부적합보고서첨부1
- NEFFC_RPT_ATCM2 — VARCHAR2(180) — 부적합보고서첨부2
- NEFFC_RPT_ATCM3 — VARCHAR2(180) — 부적합보고서첨부3
TB_MQC_NEFFC_RSLT
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- PROD_NO — VARCHAR2(20) — Primary key — NOT NULL — 제품번호
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- MTL_TP — VARCHAR2(1) — 자재유형
- NEFFC_PROC — VARCHAR2(1) — 부적합공정
- NEFFC_TP — VARCHAR2(1) — 부적합구분
- JUDG_FLAG — VARCHAR2(1) — 판정구분
- JUDG_RSLT — VARCHAR2(1) — 판정결과
- LOT_NO — VARCHAR2(20) — LOT번호
- PROD_SUMUP_DT — VARCHAR2(8) — 생산기준일자
- MTL_CD — VARCHAR2(13) — 자재코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- PROD_PCS_QTY — NUMBER(3) — 제품본수
- PROD_WGT — NUMBER(5) — 제품중량
- NEFFC_LAR_CLS — VARCHAR2(2) — 부적합대분류
- NEFFC_MID_CLS — VARCHAR2(3) — 부적합중분류
- NEFFC_SML_CLS — VARCHAR2(1) — 부적합소분류
- NEFFC_REG_DT — DATE — 부적합등록일자
- NEFFC_REG_EMPNO — VARCHAR2(22) — 부적합등록담당자
- NEFFC_JUDG_DT — DATE — 부적합판정일자
- NEFFC_JUDG_EMPNO — VARCHAR2(22) — 부적합판정담당자
- CHG_MTL_CD — VARCHAR2(13) — 변경자재코드
TB_MQC_PROD_HEAT
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- LOT_NO — VARCHAR2(8) — Primary key — NOT NULL — LOT번호
- HEAT_LOT_SEQ — NUMBER(1) — Primary key — NOT NULL — 성분LOT
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- INPUT_METHOD — VARCHAR2(1) — 입력방식
- INSP_DT — DATE — 검사일자
- INSP_EMPNO — VARCHAR2(22) — 검사자
- PROD_COMP_C — NUMBER(5,1) — C
- PROD_COMP_SI — NUMBER(5,1) — Si
- PROD_COMP_MN — NUMBER(5,1) — Mn
- PROD_COMP_P — NUMBER(5,1) — P
- PROD_COMP_S — NUMBER(5,1) — S
- PROD_COMP_CU — NUMBER(5,1) — Cu
- PROD_COMP_CR — NUMBER(5,1) — Cr
- PROD_COMP_NI — NUMBER(5,1) — Ni
- PROD_COMP_V — NUMBER(5,1) — V
- PROD_COMP_PB — NUMBER(5,1) — Pb
- PROD_COMP_SN — NUMBER(5,1) — Sn
- PROD_COMP_MO — NUMBER(5,1) — Mo
- PROD_COMP_B — NUMBER(5,1) — B
- PROD_COMP_AL — NUMBER(5,1) — Al
- PROD_COMP_TI — NUMBER(5,1) — Ti
- PROD_COMP_CO — NUMBER(5,1) — Co
- PROD_COMP_NB — NUMBER(5,1) — Nb
- PROD_COMP_N — NUMBER(5,1) — N
- PROD_COMP_MCC — NUMBER(5,1) — MCC
- PROD_COMP_CEQ — NUMBER(5,1) — CEQ
TB_MQC_PROD_HEAT_HIS
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- LOT_NO — VARCHAR2(8) — Primary key — NOT NULL — LOT번호
- HEAT_LOT_SEQ — NUMBER(1) — Primary key — NOT NULL — 성분LOT
- HIS_SEQ — NUMBER(2) — Primary key — NOT NULL — 이력SEQ
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_PROD_HEAT.WORK_TP — NOT NULL — 사업장구분
- LOT_NO (LOT_NO2) — VARCHAR2(8) — Foreign key → TB_MQC_PROD_HEAT.LOT_NO — NOT NULL — LOT번호
- HEAT_LOT_SEQ (HEAT_LOT_SEQ2) — NUMBER(1) — Foreign key → TB_MQC_PROD_HEAT.HEAT_LOT_SEQ — NOT NULL — 성분LOT
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- INPUT_METHOD — VARCHAR2(1) — 입력방식
- INSP_DT — DATE — 검사일자
- INSP_EMPNO — VARCHAR2(22) — 검사자
- PROD_COMP_C — NUMBER(5,1) — C
- PROD_COMP_SI — NUMBER(5,1) — Si
- PROD_COMP_MN — NUMBER(5,1) — Mn
- PROD_COMP_P — NUMBER(5,1) — P
- PROD_COMP_S — NUMBER(5,1) — S
- PROD_COMP_CU — NUMBER(5,1) — Cu
- PROD_COMP_CR — NUMBER(5,1) — Cr
- PROD_COMP_NI — NUMBER(5,1) — Ni
- PROD_COMP_V — NUMBER(5,1) — V
- PROD_COMP_PB — NUMBER(5,1) — Pb
- PROD_COMP_SN — NUMBER(5,1) — Sn
- PROD_COMP_MO — NUMBER(5,1) — Mo
- PROD_COMP_B — NUMBER(5,1) — B
- PROD_COMP_AL — NUMBER(5,1) — Al
- PROD_COMP_TI — NUMBER(5,1) — Ti
- PROD_COMP_CO — NUMBER(5,1) — Co
- PROD_COMP_NB — NUMBER(5,1) — Nb
- PROD_COMP_N — NUMBER(5,1) — N
- PROD_COMP_MCC — NUMBER(5,1) — MCC
- PROD_COMP_CEQ — NUMBER(5,1) — CEQ
TB_MQC_PROD_MAST
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- LOT_NO — VARCHAR2(8) — Primary key — NOT NULL — LOT번호
- PROD_LEN — NUMBER(8) — Primary key — NOT NULL — 제품길이
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- INST_GRAD_CD — VARCHAR2(20) — 지시강종
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- BLT_GRAD_CD — VARCHAR2(20) — 투입소재강종
- PROD_NM_CD — VARCHAR2(1) — 제품구분
- BLT_EXT_TEMP — NUMBER(4) — 빌릿추출온도
- PROD_SUMUP_DT — VARCHAR2(8) — 생산기준일자
- PROD_DT — DATE — 생산일자
- PROD_OP_SFT — VARCHAR2(2) — 생산근무조
- JUDG_DT — DATE — 판정일자
- JUDG_EMPNO — VARCHAR2(22) — 판정담당자
- HEAT_INSP_CNT — NUMBER(1) — 성분검사수
- MECH_INSP_CNT — NUMBER(2) — 재질검사수
- MTC_MECH_CNT — NUMBER(1) — MTC재질검사표기수
- HEAT_SEQ1_MECH_CNT — NUMBER(1) — 성분SEQ1매칭재질검사수
- MANAGER_FLAG — VARCHAR2(1) — 담당자확인
- QC_EMPNO — VARCHAR2(22) — 품질담당자
TB_MQC_PROD_MEAS
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- LOT_NO — VARCHAR2(8) — Primary key — NOT NULL — LOT번호
- PROD_LEN — NUMBER(8) — Primary key — NOT NULL — 제품길이
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- INSP_DT — DATE — 검사일자
- INSP_EMPNO — VARCHAR2(22) — 검사자
- COIL_TYPE — VARCHAR2(1) — 코일TYPE
- GR_THEORY_WGT — NUMBER(7,3) — 1조이론중량
- GR_REAL_WGT — NUMBER(7,3) — 1조실중량
- GR_WGT_TOL — NUMBER(3,1) — 1조무게허용차
- UNIT_THEORY_WGT — NUMBER(5,3) — 1개이론중량
- UNIT_REAL_WGT — NUMBER(5,3) — 1개실중량
- UNIT_WGT_TOL — NUMBER(3,1) — 1개무게허용차
- PROD_REAL_LEN — NUMBER(5) — 제품실길이
- PROD_LEN_TOL — NUMBER(5) — 길이허용차
- JOINT_SPACE — NUMBER(3,1) — 마디간격
- JOINT_HEIGHT — NUMBER(3,1) — 마디높이
- GAP_SUM — NUMBER(3,1) — 틈합계
- JOINT_AXIS_ANGLE — NUMBER(4,1) — 마디축선각도
- JOINT_HEIGHT2 — NUMBER(3,1) — 1/4_3/4마디높이
- JOINT_SIDE_INC_ANGLE — NUMBER(4,1) — 마디측면경사각도
- RIB_HEIGHT — NUMBER(3,1) — 리브높이
- JOINT_WIDTH — NUMBER(3,1) — 마디폭
- RLT_RIB_AREA — NUMBER(4,3) — 상대리브면적
- BUNDLE_STATUS — VARCHAR2(1) — 묶음상태
- SHAPE — VARCHAR2(1) — 모양
- APPEARANCE — VARCHAR2(1) — 겉모양
- MARK_STATUS — VARCHAR2(1) — 표시상태
- RADIATION_MEAS — NUMBER(3,2)
TB_MQC_PROD_MEAS_HIS
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- LOT_NO — VARCHAR2(8) — Primary key — NOT NULL — LOT번호
- PROD_LEN — NUMBER(8) — Primary key — NOT NULL — 제품길이
- HIS_SEQ — NUMBER(2) — Primary key — NOT NULL — 이력SEQ
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_PROD_MEAS.WORK_TP — NOT NULL — 사업장구분
- LOT_NO (LOT_NO2) — VARCHAR2(8) — Foreign key → TB_MQC_PROD_MEAS.LOT_NO — NOT NULL — LOT번호
- PROD_LEN (PROD_LEN2) — NUMBER(8) — Foreign key → TB_MQC_PROD_MEAS.PROD_LEN — NOT NULL — 제품길이
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- INSP_DT — DATE — 검사일자
- INSP_EMPNO — VARCHAR2(22) — 검사자
- COIL_TYPE — VARCHAR2(1) — 코일TYPE
- GR_THEORY_WGT — NUMBER(7,3) — 1조이론중량
- GR_REAL_WGT — NUMBER(7,3) — 1조실중량
- GR_WGT_TOL — NUMBER(3,1) — 1조무게허용차
- UNIT_THEORY_WGT — NUMBER(5,3) — 1개이론중량
- UNIT_REAL_WGT — NUMBER(5,3) — 1개실중량
- UNIT_WGT_TOL — NUMBER(3,1) — 1개무게허용차
- PROD_REAL_LEN — NUMBER(5) — 제품실길이
- PROD_LEN_TOL — NUMBER(5) — 길이허용차
- JOINT_SPACE — NUMBER(3,1) — 마디간격
- JOINT_HEIGHT — NUMBER(3,1) — 마디높이
- GAP_SUM — NUMBER(3,1) — 틈합계
- JOINT_AXIS_ANGLE — NUMBER(4,1) — 마디축선각도
- JOINT_HEIGHT2 — NUMBER(3,1) — 1/4_3/4마디높이
- JOINT_SIDE_INC_ANGLE — NUMBER(4,1) — 마디측면경사각도
- RIB_HEIGHT — NUMBER(3,1) — 리브높이
- JOINT_WIDTH — NUMBER(3,1) — 마디폭
- RLT_RIB_AREA — NUMBER(4,3) — 상대리브면적
- BUNDLE_STATUS — VARCHAR2(1) — 묶음상태
- SHAPE — VARCHAR2(1) — 모양
- APPEARANCE — VARCHAR2(1) — 겉모양
- MARK_STATUS — VARCHAR2(1) — 표시상태
- RADIATION_MEAS — NUMBER(3,2)
TB_MQC_PROD_MECH
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- LOT_NO — VARCHAR2(8) — Primary key — NOT NULL — LOT번호
- MECH_LOT_SEQ — NUMBER(2) — Primary key — NOT NULL — 재질LOT
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- HEAT_LOT_SEQ — NUMBER(1) — 성분LOT
- NOTE — VARCHAR2(300) — 비고
- INSP_DT — DATE — 검사일자
- INSP_EMPNO — VARCHAR2(22) — 검사자
- TSL_TS_RSLT — NUMBER(5,1) — 인장시험TS실적
- TSL_YP_RSLT — NUMBER(5,1) — 인장시험YP실적
- TSL_EL_RSLT — NUMBER(5,1) — 인장시험EL실적
- TSL_YR_RSLT — NUMBER(6,2) — 인장시험항복비실적
- BEND_DIA — VARCHAR2(3) — 굴곡시험굴곡반경
- BEND_ANGLE — VARCHAR2(1) — 굴곡시험굴곡각도
- BEND_RSLT — VARCHAR2(1) — 굴곡시험결과
- REBEND_DIA — VARCHAR2(2) — 재굴곡시험굴곡반경
- REBEND_ANGLE — VARCHAR2(1) — 재굴곡시험굴곡각도
- REBEND_RSLT — VARCHAR2(1) — 재굴곡시험결과
- AGING_START_DT — DATE — AgingMethod시작일시
- AGING_FINISH_DT — DATE — AgingMethod종료일시
- AGING_TIME — NUMBER(4) — AgingMethod시간
- AGING_TEMP — NUMBER(4) — AgingMethod온도
TB_MQC_PROD_MECH_HIS
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- LOT_NO — VARCHAR2(8) — Primary key — NOT NULL — LOT번호
- MECH_LOT_SEQ — NUMBER(2) — Primary key — NOT NULL — 재질LOT
- HIS_SEQ — NUMBER(2) — Primary key — NOT NULL — 이력SEQ
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_PROD_MECH.WORK_TP — NOT NULL — 사업장구분
- LOT_NO (LOT_NO2) — VARCHAR2(8) — Foreign key → TB_MQC_PROD_MECH.LOT_NO — NOT NULL — LOT번호
- MECH_LOT_SEQ (MECH_LOT_SEQ2) — NUMBER(2) — Foreign key → TB_MQC_PROD_MECH.MECH_LOT_SEQ — NOT NULL — 재질LOT
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- HEAT_LOT_SEQ — NUMBER(1) — 성분LOT
- NOTE — VARCHAR2(300) — 비고
- INSP_DT — DATE — 검사일자
- INSP_EMPNO — VARCHAR2(22) — 검사자
- TSL_TS_RSLT — NUMBER(5,1) — 인장시험TS실적
- TSL_YP_RSLT — NUMBER(5,1) — 인장시험YP실적
- TSL_EL_RSLT — NUMBER(5,1) — 인장시험EL실적
- TSL_YR_RSLT — NUMBER(6,2) — 인장시험항복비실적
- BEND_DIA — VARCHAR2(3) — 굴곡시험굴곡반경
- BEND_ANGLE — VARCHAR2(1) — 굴곡시험굴곡각도
- BEND_RSLT — VARCHAR2(1) — 굴곡시험결과
- REBEND_DIA — VARCHAR2(2) — 재굴곡시험굴곡반경
- REBEND_ANGLE — VARCHAR2(1) — 재굴곡시험굴곡각도
- REBEND_RSLT — VARCHAR2(1) — 재굴곡시험결과
- AGING_START_DT — DATE — AgingMethod시작일시
- AGING_FINISH_DT — DATE — AgingMethod종료일시
- AGING_TIME — NUMBER(4) — AgingMethod시간
- AGING_TEMP — NUMBER(4) — AgingMethod온도
TB_MQC_QMTC_BLT
- CERTIFICATE_NO — VARCHAR2(14) — Primary key — NOT NULL — 검사증명서번호
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- BLT_NO — VARCHAR2(20) — Primary key — NOT NULL — 빌릿번호
- CERTIFICATE_NO (CERTIFICATE_NO2) — VARCHAR2(14) — Foreign key → TB_MQC_QMTC_MAST.CERTIFICATE_NO — NOT NULL — 검사증명서번호
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_QMTC_MAST.WORK_TP — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- TRF_ORDER_NO — VARCHAR2(10) — 이송지시번호
- TRF_ORDER_LN — VARCHAR2(6) — 이송지시행번
- CMP_CD — VARCHAR2(4) — 회사코드
- ISS_SUMUP_DT — VARCHAR2(8) — 발행기준일자
- HEAT_NO — VARCHAR2(20) — HEAT번호
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- BLT_LEN — NUMBER(8) — 길이
- MTC_BUNDLE_QTY — NUMBER(1) — 빌릿수
- MTC_WGT — NUMBER(7,3) — 빌릿중량
- C_RSLT — NUMBER(5,1) — C
- SI_RSLT — NUMBER(5,1) — Si
- MN_RSLT — NUMBER(5,1) — Mn
- P_RSLT — NUMBER(5,1) — P
- S_RSLT — NUMBER(5,1) — S
- CU_RSLT — NUMBER(5,1) — Cu
- CR_RSLT — NUMBER(5,1) — Cr
- NI_RSLT — NUMBER(5,1) — Ni
- V_RSLT — NUMBER(5,1) — V
- PB_RSLT — NUMBER(5,1) — Pb
- SN_RSLT — NUMBER(5,1) — Sn
- MO_RSLT — NUMBER(5,1) — Mo
- B_RSLT — NUMBER(5,1) — B
- N_RSLT — NUMBER(5,1) — N
- NB_RSLT — NUMBER(5,1) — Nb
- CEQ_RSLT — NUMBER(5,1) — Ceq
- CEQ_FORMULA — VARCHAR2(1) — Ceq계산식
- CEQ_FORMULA_CONTENTS — VARCHAR2(60) — Ceq계산식내용
- DIMENSION — VARCHAR2(1) — 치수
- RADIATION_POLLUTION — VARCHAR2(1) — Radiation
- DOME_SCRP_RT — NUMBER(3) — 국내고철비율
TB_MQC_QMTC_MAST
- CERTIFICATE_NO — VARCHAR2(14) — Primary key — NOT NULL — 검사증명서번호
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- TRF_ORDER_NO — VARCHAR2(10) — 이송지시번호
- TRF_ORDER_LN — VARCHAR2(6) — 이송지시행번
- CMP_CD — VARCHAR2(4) — 회사코드
- ISS_SUMUP_DT — VARCHAR2(8) — 발행기준일자
- INVOICE_NO — VARCHAR2(50) — INVOICE번호
- LC_NO — VARCHAR2(20) — LC번호
- MTL_CD — VARCHAR2(13) — 자재코드
- COMM_NM — VARCHAR2(60) — 품명
- GRAD_CD — VARCHAR2(20) — 강종
- CUST_CD — VARCHAR2(6) — 고객사코드
- CUST_NM — VARCHAR2(90) — 고객사명
- MTC_TOT_QTY — NUMBER(5) — MTC총수량
- MTC_TOT_WGT — NUMBER(10) — MTC총중량
- MTC_STAT — VARCHAR2(1) — 증명서상태
- MTC_MAKE_DT — DATE — MTC생성일자
- MTC_DP_FLAG — VARCHAR2(1) — MTC표시구분
- MTC_FILE_NM — VARCHAR2(60) — MTC파일명
- QC_EMPNO — VARCHAR2(22) — 품질담당자
TB_MQC_QMTC_RSLT
- LOT_NO — VARCHAR2(20) — Primary key — NOT NULL — LOT번호
- LOT_SEQ — VARCHAR2(2) — Primary key — NOT NULL — LOT
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- CMP_CD — VARCHAR2(4) — 회사코드
- DOM_EXP_FLAG — VARCHAR2(1) — 내수수출구분
- COMM_NM — VARCHAR2(30) — 품명
- GRAD_CD — VARCHAR2(20) — 강종
- SIZE_CD — VARCHAR2(3) — 사이즈
- PROD_LEN — NUMBER(8) — 제품길이
- C_RSLT — NUMBER(5,1) — C
- SI_RSLT — NUMBER(5,1) — Si
- MN_RSLT — NUMBER(5,1) — Mn
- P_RSLT — NUMBER(5,1) — P
- S_RSLT — NUMBER(5,1) — S
- CU_RSLT — NUMBER(5,1) — Cu
- CR_RSLT — NUMBER(5,1) — Cr
- NI_RSLT — NUMBER(5,1) — Ni
- V_RSLT — NUMBER(5,1) — V
- PB_RSLT — NUMBER(5,1) — Pb
- SN_RSLT — NUMBER(5,1) — Sn
- MO_RSLT — NUMBER(5,1) — Mo
- B_RSLT — NUMBER(5,1) — B
- N_RSLT — NUMBER(5,1) — N
- NB_RSLT — NUMBER(5,1) — Nb
- CEQ_RSLT — NUMBER(5,1) — Ceq
- CEQ_FORMULA — VARCHAR2(1) — Ceq계산식
- CEQ_FORMULA_CONTENTS — VARCHAR2(60) — Ceq계산식내용
- TSL_TS_RSLT — NUMBER(5,1) — 인장시험TS실적
- TSL_YP_RSLT — NUMBER(5,1) — 인장시험YP실적
- TSL_YR_RSLT — NUMBER(6,2) — 인장시험항복비실적
- TSL_EL_RSLT — NUMBER(5,1) — 인장시험EL실적
- BEND_RSLT — VARCHAR2(1) — 굴곡시험결과
- REBEND_RSLT — VARCHAR2(1) — 재굴곡시험결과
- APPEARANCE — VARCHAR2(1) — 겉모양
- DIMENSION — VARCHAR2(1) — 치수
- WGT_TOL — VARCHAR2(1) — 무게허용차
- HEAT_METHOD — VARCHAR2(1) — 제강방식
- RADIATION_POLLUTION — VARCHAR2(1) — Radiation
- DOME_SCRP_RT — NUMBER(3) — 국내고철비율
TB_MQC_RSMAT_TEST_CMPR
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- INSP_DT — VARCHAR2(8) — Primary key — NOT NULL
- ITEM_NO — VARCHAR2(13) — Primary key — NOT NULL
- VENDOR_CD — VARCHAR2(6) — Primary key — NOT NULL — 입고업체코드
- CREATED_OBJECT_TYPE — VARCHAR2(1) — 생성Object유형
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(50) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(50) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(50) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- RSMAT_ANLS_COMP_CD — VARCHAR2(5) — 원부재료분석성분코드
- QUAL_AGENCY_CD — VARCHAR2(1) — 공인기관코드
- SELF_RSLT — NUMBER(6,3) — 사내실적
- SELF_JUDG_FLAG — VARCHAR2(1) — 사내판정결과
- QUAL_AGENCY_RSLT — NUMBER(6,3) — 공인기관실적
- QUAL_AGENCY_JUDG_FLAG — VARCHAR2(1) — 공인기관판정결과
- INSP_RSLT_DEV — NUMBER(6,3) — 검사결과편차
- TOTAL_JUDG_FLAG — VARCHAR2(1) — 전체판정결과
TB_MQC_RSMAT_TEST_DETL
- REC_NO — VARCHAR2(8) — Primary key — NOT NULL — 접수번호
- ANLS_TIMES — NUMBER(2) — Primary key — NOT NULL — 분석횟수
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- MTL_CD — VARCHAR2(13) — Primary key — NOT NULL — 자재코드
- RSMAT_ANLS_COMP_CD — VARCHAR2(2) — Primary key — NOT NULL — 원부재료분석성분코드
- REC_NO (REC_NO2) — VARCHAR2(8) — Foreign key → TB_MQC_RSMAT_TEST_MAST.REC_NO — NOT NULL — 접수번호
- ANLS_TIMES (ANLS_TIMES2) — NUMBER(2) — Foreign key → TB_MQC_RSMAT_TEST_MAST.ANLS_TIMES — NOT NULL — 분석횟수
- WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key → TB_MQC_RSMAT_TEST_MAST.WORK_TP — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- VENDOR_RSLT — NUMBER(6,3) — 납품업체검사결과
- VENDOR_JUDG_FLAG — VARCHAR2(1) — 납품업체판정결과
- SELF_RSLT — NUMBER(6,3) — 사내검사결과
- SELF_JUDG_FLAG — VARCHAR2(1) — 사내판정결과
- INSP_RSLT_DEV — NUMBER(6,3) — 검사결과편차
TB_MQC_RSMAT_TEST_MAST
- REC_NO — VARCHAR2(8) — Primary key — NOT NULL — 접수번호
- ANLS_TIMES — NUMBER(2) — Primary key — NOT NULL — 분석횟수
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP(6) — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(22) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(22) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP(6) — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(22) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(22) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP(6) — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP(6) — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(22) — Archive프로그램ID
- REC_SUMUP_DT — VARCHAR2(8) — 접수기준일자
- RCPT_SUMUP_DT — VARCHAR2(8) — 입고기준일자
- SMP_SUMUP_DT — VARCHAR2(8) — 채취기준일자
- ANLS_SUMUP_DT — VARCHAR2(8) — 분석기준일자
- CMP_CD — VARCHAR2(4) — 회사코드
- TEST_REQ_TP — VARCHAR2(1) — 시험의뢰여부
- PRCH_NO — VARCHAR2(10) — 구매문서번호
- PRCH_LN — VARCHAR2(6) — 구매문서행번
- PROD_KIND — VARCHAR2(4) — 품종
- MTL_CD — VARCHAR2(13) — 자재코드
- RECV_FLAG — VARCHAR2(1) — 수신여부
- VENDOR_CD — VARCHAR2(6) — 입고업체코드
- RCPT_WGT — NUMBER(8) — 입고중량
- JUDG_FLAG — VARCHAR2(1) — 판정결과
- ANLS_FLAG — VARCHAR2(1) — 분석유무
- RSMAT_ANLS_NOTE — VARCHAR2(1) — 원부재료분석비고
- NOTE — VARCHAR2(300) — 비고
- REC_DT — DATE — 접수일자
- REC_EMPNO — VARCHAR2(22) — 접수자
- VENDOR_RSLT_DT — DATE — 납품업체실적등록일자
- VENDOR_RSLT_EMPNO — VARCHAR2(22) — 납품업체실적등록자
- ANLS_DT — DATE — 분석일자
- ANLS_EMPNO — VARCHAR2(22) — 분석자
- TOTAL_ANLS_TIMES — NUMBER(2) — 총분석횟수
TB_MQC_SLAG_RSLT
- WORK_TP — VARCHAR2(1) — Primary key — NOT NULL — 사업장구분
- ANLS_DT — VARCHAR2(8) — Primary key — NOT NULL
- HEAT_NO — VARCHAR2(6) — Primary key — NOT NULL — HEAT번호
- SLAG_SAMPLE_COL_LOC — VARCHAR2(2) — Primary key — NOT NULL
- CREATED_OBJECT_TYPE — VARCHAR2(1)
- CREATED_OBJECT_ID — VARCHAR2(50) — 생성ObjectID
- CREATED_PROGRAM_ID — VARCHAR2(50) — 생성프로그램ID
- CREATION_TIMESTAMP — TIMESTAMP — 생성일시
- LAST_UPDATED_OBJECT_TYPE — VARCHAR2(1) — 최종변경Object유형
- LAST_UPDATED_OBJECT_ID — VARCHAR2(50) — 최종변경ObjectID
- LAST_UPDATE_PROGRAM_ID — VARCHAR2(50) — 최종변경프로그램ID
- LAST_UPDATE_TIMESTAMP — TIMESTAMP — 최종변경일자
- DATA_END_STATUS — VARCHAR2(1) — 데이터종료여부
- DATA_END_OBJECT_TYPE — VARCHAR2(1) — 데이타종료Object유형
- DATA_END_OBJECT_ID — VARCHAR2(50) — 데이타종료ObjectID
- DATA_END_PROGRAM_ID — VARCHAR2(50) — 데이타종료프로그램ID
- DATA_END_TIMESTAMP — TIMESTAMP — 데이터종료일시
- ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
- ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
- ARCHIVED_TIMESTAMP — TIMESTAMP — Archive작업일자
- ARCHIVE_PROGRAM_ID — VARCHAR2(50) — Archive프로그램ID
- PROD_DT — VARCHAR2(8)
- SPEC_CD — VARCHAR2(20)
- SLAG_SAMPLE_METHOD — VARCHAR2(1)
- INSP_EMP_NO — VARCHAR2(40)
- TEST_RESULT — VARCHAR2(1)
- NOTE — VARCHAR2(1000) — 비고
- SLAG_COMP_CAO — NUMBER(6,3) — CaO
- SLAG_COMP_SIO2 — NUMBER(6,3) — SiO2
- SLAG_COMP_MGO — NUMBER(6,3) — MgO
- SLAG_COMP_AL2O3 — NUMBER(6,3)
- SLAG_COMP_FE — NUMBER(6,3) — Fe
- SLAG_COMP_MNO — NUMBER(6,3) — MnO
- SLAG_COMP_P2O5 — NUMBER(6,3) — P2O5
- SLAG_COMP_SO3 — NUMBER(6,3) — SO3
- SLAG_COMP_CR2O3 — NUMBER(6,3) — Cr2O3
- SLAG_COMP_TIO2 — NUMBER(6,3) — TiO2
- SLAG_COMP_K2O — NUMBER(6,3) — K2O
- SLAG_COMP_FE2O3 — NUMBER(6,3) — Fe2O3
- SLAG_COMP_MN — NUMBER(6,3) — Mn
- SLAG_COMP_P — NUMBER(6,3) — P
- SLAG_COMP_S — NUMBER(6,3) — S
- SLAG_COMP_V — NUMBER(6,3) — V
- SLAG_BASICITY1 — NUMBER(6,3) — 염기도1
- SLAG_BASICITY2 — NUMBER(6,3) — 염기도2