mes - 2022-09-16 01:28:35

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 — NOT NULL — 구매문서번호
  • PRCH_LN (PRCH_LN2) — VARCHAR2(6) — Foreign key — NOT NULL — 구매문서행번
  • RCPT_SUMUP_DT (RCPT_SUMUP_DT2) — VARCHAR2(8) — Foreign key — NOT NULL — 입고기준일자
  • WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign 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) — 자재코드
  • 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 — NOT NULL — 구매문서번호
  • PRCH_LN (PRCH_LN2) — VARCHAR2(6) — Foreign key — NOT NULL — 구매문서행번
  • RCPT_SUMUP_DT (RCPT_SUMUP_DT2) — VARCHAR2(8) — Foreign key — NOT NULL — 입고기준일자
  • WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign 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) — 자재코드
  • 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_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 — NOT NULL — 이송지시번호
  • TRF_ORDER_LN (TRF_ORDER_LN2) — VARCHAR2(6) — Foreign key — NOT NULL — 이송지시행번
  • HEAT_NO (HEAT_NO2) — VARCHAR2(15) — Foreign key — NOT NULL — Heat번호
  • MTL_CD (MTL_CD2) — VARCHAR2(13) — Foreign key — NOT NULL — 자재코드
  • WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign 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_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 — NOT NULL — 구매문서번호
  • PRCH_LN — VARCHAR2(6) — Foreign key — NOT NULL — 구매문서행번
  • RCPT_SUMUP_DT — VARCHAR2(8) — Foreign key — NOT NULL — 입고기준일자
  • WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign key — NOT NULL — 사업장구분
  • HEAT_NO (HEAT_NO2) — VARCHAR2(6) — Foreign key — NOT NULL — HEAT번호
  • UPLOAD_FLAG — VARCHAR2(1) — Foreign key — NOT NULL — Upload구분
  • PRCH_NO (PRCH_NO2) — VARCHAR2(10) — Foreign key — NOT NULL — 구매문서번호
  • PRCH_LN (PRCH_LN2) — VARCHAR2(6) — Foreign key — NOT NULL — 구매문서행번
  • RCPT_SUMUP_DT (RCPT_SUMUP_DT2) — VARCHAR2(8) — Foreign key — NOT NULL — 입고기준일자
  • WORK_TP (WORK_TP22) — VARCHAR2(1) — Foreign key — NOT NULL — 사업장구분
  • WORK_TP (WORK_TP3) — VARCHAR2(1) — Foreign key — NOT NULL — 사업장구분
  • HEAT_NO (HEAT_NO3) — VARCHAR2(6) — Foreign key — NOT NULL — HEAT번호
  • PROC_TP — VARCHAR2(2) — Foreign key — NOT NULL — 공정구분
  • HEAT_RSLT_SEQ — NUMBER(1) — Foreign 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) — 회사코드
  • 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 — NOT NULL — 사업장구분
  • LOT_NO (LOT_NO2) — VARCHAR2(8) — Foreign key — NOT NULL — LOT번호
  • HEAT_LOT_SEQ (HEAT_LOT_SEQ2) — NUMBER(1) — Foreign 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_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 — NOT NULL — 사업장구분
  • LOT_NO (LOT_NO2) — VARCHAR2(8) — Foreign key — NOT NULL — LOT번호
  • PROD_LEN (PROD_LEN2) — NUMBER(8) — Foreign 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_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 — NOT NULL — 사업장구분
  • LOT_NO (LOT_NO2) — VARCHAR2(8) — Foreign key — NOT NULL — LOT번호
  • MECH_LOT_SEQ (MECH_LOT_SEQ2) — NUMBER(2) — Foreign 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_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 — NOT NULL — 검사증명서번호
  • WORK_TP (WORK_TP2) — VARCHAR2(1) — Foreign 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) — 발행기준일자
  • 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,0) — Primary key — NOT NULL — 분석횟수
  • RSMAT_ANLS_COMP_CD — VARCHAR2(2) — Primary key — NOT NULL — 원부재료분석성분코드
  • REC_NO (REC_NO2) — VARCHAR2(8) — Foreign key — NOT NULL — 접수번호
  • ANLS_TIMES (ANLS_TIMES2) — NUMBER(2) — Foreign key — NOT NULL — 분석횟수
  • WORK_TP — VARCHAR2(1) — Foreign key — NOT NULL — 사업장구분
  • CREATED_OBJECT_TYPE — VARCHAR2(1) — 생성Object유형
  • CREATED_OBJECT_ID — VARCHAR2(22) — 생성ObjectID
  • CREATED_PROGRAM_ID — VARCHAR2(22) — 생성프로그램ID
  • CREATION_TIMESTAMP — TIMESTAMP — 생성일시
  • 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 — 최종변경일자
  • 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 — 데이터종료일시
  • ARCHIVE_COMPLETED_FLAG — VARCHAR2(1) — Archive완료여부
  • ARCHIVED_EMPLOYEE_NUM — VARCHAR2(22) — Archive작업자직번
  • ARCHIVED_TIMESTAMP — TIMESTAMP — 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

and 1 more table