APIS

테이블 (9)

ITEM_MAKER_INFO (TAP_PL_REG_MAKER_MNG)

  • SEQ_PL_REG_MAKER_MNG — NUMBER(20, 0) — 기본 키 — NOT NULL
  • ITEMS — VARCHAR2(15 BYTE) — 외래 키 → iTEM MASTER.ITEMS — NOT NULL
  • MAKER — VARCHAR2(7 BYTE) — NOT NULL — maker
  • LAST_IN_DATE — VARCHAR2(8 BYTE) — last grn date

ITEM_UNIT_PRICE (TAP_PL_SITE_ITEMS)

  • COMP — VARCHAR2(4 BYTE) — 기본 키 — NOT NULL — company
  • SITE — VARCHAR2(4 BYTE) — 기본 키 — NOT NULL — site
  • ITEMS — VARCHAR2(15 BYTE) — 외래 키 → iTEM MASTER.ITEMS — NOT NULL
  • ASSET (ASSET_ID) — VARCHAR2(1 BYTE) — NOT NULL — asset
  • CLOSING DATE (ESTI_YYMM) — VARCHAR2(6 BYTE) — evaluation year-month
  • CURRENCY — VARCHAR2(3 BYTE) — currency
  • UPRICE — NUMBER(18, 2) — NOT NULL — unit price
  • KRW_UPRICE — NUMBER(18, 0) — NOT NULL — krw unit price
  • CREATE_DATE — VARCHAR2(8 BYTE) — NOT NULL — create date
  • LAST_IN_DATE — VARCHAR2(8 BYTE) — last grn date

PROPERTY_DETAIL (TAP_PL_VALUE)

  • SEQ_PL_VALUE — NUMBER(20, 0) — 기본 키 — NOT NULL
  • SEQ_PL_PROP — NUMBER(20, 0) — 외래 키 → PROPERTY_MASTER.SEQ_PL_PROP — NOT NULL
  • TYPE_ID — VARCHAR2(2 BYTE) — NOT NULL — property type T1:formula T2:chemical T3: theory T4:result R1:raw materail..
  • FR_KEY — NUMBER(20, 0) — NOT NULL — connection key value. etc)seq_pl_reg_maker_mng
  • STD_VAL — VARCHAR2(150 CHAR) — value
  • MIN_VAL — NUMBER(18, 6) — min value
  • MAX_VAL — NUMBER(18, 6) — max value
  • TEST_COND — VARCHAR2(100 CHAR) — test condition
  • TEST_METHD — VARCHAR2(100 CHAR) — test method
  • SOURCE_CD — VARCHAR2(3 BYTE) — Sources
  • SOURCE_TEXT — VARCHAR2(300 CHAR) — Sources desc
  • UNIT — VARCHAR2(20 BYTE) — unit
  • REMARK — VARCHAR2(500 CHAR) — remark
  • SPEC_SIZE — VARCHAR2(50 CHAR) — specification size

PROPERTY_MASTER (TAP_PL_PROP)

  • SEQ_PL_PROP — NUMBER(20, 0) — 기본 키 — NOT NULL
  • ENG_NM — VARCHAR2(100 CHAR) — English name
  • KOR_NM — VARCHAR2(100 CHAR) — Korean name
  • TAG — VARCHAR2(500 CHAR) — TAG
  • DESCRIPTION (DESCR) — VARCHAR2(1000 CHAR) — Property Description
  • CALC_YN — VARCHAR2(1 BYTE) — NOT NULL — Theoretical value classification
  • MEAS_YN — VARCHAR2(1 BYTE) — NOT NULL — Measurement value classification
  • INPUT_TYPE — VARCHAR2(1 BYTE) — NOT NULL — A:selective B:Direct input type
  • DATA_TYPE — CHAR(1 BYTE) — NOT NULL — A:Text B:number
  • DEC_LEN — NUMBER(8, 0) — NOT NULL — data max length
  • CALCULATION — VARCHAR2(1000 CHAR) — Calculation formula
  • UNIT — VARCHAR2(20 BYTE) — unit
  • TYPE_ID — VARCHAR2(1 BYTE) — NOT NULL — A:basic property B:component property C:applied property D:formula property
  • USE_YN — CHAR(1 BYTE) — NOT NULL — use status
  • FML_USE — VARCHAR2(1 BYTE) — NOT NULL — Use of compound properties
  • CALC_USE — VARCHAR2(1 BYTE) — NOT NULL — Use of theoretical properties
  • MEAS_USE — VARCHAR2(1 BYTE) — NOT NULL — Use resultant properties
  • R_MOD_ABLE_YN — VARCHAR2(1 BYTE) — NOT NULL — Can modify properties
  • SORT_NO — NUMBER(10, 0) — NOT NULL — sorting no
  • SELF_CALC_YN — VARCHAR2(1 BYTE) — NOT NULL — Self-calculation of input raw material properties

TAP_PL_CHEM_MAIL_DTL

  • SEQ (SEQ_PL_CHEM_MAIL_DTL) — NUMBER(20,0) — 기본 키 — NOT NULL
  • SEQ (SEQ_PL_CHEM_MAIL_HIST) — NUMBER(20,0) — 외래 키 → TAP_PL_CHEM_MAIL_HIST.SEQ — NOT NULL
  • 문서종류 (DOC_ID) — VARCHAR(2 BYTE) — [11]MSDS[12]TDS(Technical Data Sheet)[13]COA[14]성분내역서[15]ISO 9001[16]ETC.[21]중금속성적서[22]원재료규격서[23]GPC[24]ETC.[25]저장기간 증빙…
  • 등록자 (REG_EMPNO) — VARCHAR2(8 BYTE)
  • 등록일시 (REG_DATETIME) — DATE
  • 삭제자 (DEL_EMPNO) — VARCHAR2(8 BYTE)
  • 삭제일시 (DEL_DATETIME) — DATE

TAP_PL_CHEM_MAIL_HIST

  • SEQ (SEQ_PL_CHEM_MAIL_HIST) — NUMBER(20,0) — 기본 키 — NOT NULL
  • 품목 (ITEMS) — VARCHAR2(8 BYTE)
  • 제조사 (MAKER) — VARCHAR2(7 BYTE)
  • 공급업체 (CUST) — VARCHAR2(7 BYTE)
  • 메일내용 (MAIL_CNTS) — VARCHAR2(500 CHAR)
  • 등록자 (REG_EMPNO) — VARCHAR2(8 BYTE)
  • 등록일시 (REG_DATETIME) — DATE
  • 삭제자 (DEL_EMPNO) — VARCHAR2(8 BYTE)
  • 삭제일시 (DEL_DATETIME) — DATE

TAP_PL_CHEM_RATE

  • 안전_승인일자 (CFRM_DATETIME) — DATE
  • 품질_승인여부 (QC_CFRM_YN) — VARCHAR2(1 BYTE)
  • 품질_승인일자 (QC_CFRM_DATETIME) — DATE
  • 안전_반송사유 (REJECT_REMARK) — VARCHAR2(500 CHAR)
  • 품질_반송사유 (QC_REJECT_REMARK) — VARCHAR2(500 CHAR)
  • 최근 반송 SEQ (SEQ_PL_CHEM_MAIL_HIST) — NUMBER(20,0)
  • 최근 반송 SEQ_품질 (QC_SEQ_PL_CHEM_MAIL_HIST) — NUMBER(20,0)

iTEM MASTER (TS03_STD_ITEMS_MAST)

  • ITEMS — VARCHAR2(15 BYTE) — 기본 키 — NOT NULL
  • ITEMS_NM — VARCHAR2(500 CHAR) — NOT NULL — item name
  • ASSET_ID — VARCHAR2(1 BYTE) — NOT NULL — asset type
  • UNIT — VARCHAR2(6 BYTE) — NOT NULL — unit
  • STORE_TERM — NUMBER(3,0) — storage term
  • CFRM_DATE — VARCHAR2(8 BYTE) — confirm date

과제/기술 변경이력 (TAP_TASK_HISTORY)

  • SEQ (SEQ_TASK_HISTORY) — NUMBER(20,0) — 기본 키 — NOT NULL
  • 타입 (TYPE_CD) — VARCHAR2(10 BYTE) — 과제(N01), 기술지원(N03)
  • 소스 (SOURCE_CD) — VARCHAR2(20 BYTE) — 과제, 기술지원 관리번호
  • 변경구분 (JOB_ID) — VARCHAR2(10 BYTE) — 원료(R), 시험방법(T), SPEC(S), 설비(F)
  • 제목 (TITLE) — VARCHAR2(200 CHAR)
  • 내용 (CONTS) — VARCHAR2(1000 CHAR)
  • 변경일자 (APPLY_DATE) — VARCHAR2(8 BYTE)
  • 변경승인 여부 (APPR_ID) — VARCHAR2(5 BYTE) — 내부(IN) 외부(OUT)
  • 파일 (FILE_ID) — VARCHAR2(100 BYTE)
  • 등록자 (REG_EMPNO) — VARCHAR2(8 BYTE)
  • 등록일자 (REG_DATETIME) — DATE
  • 수정자 (MOD_EMPNO) — VARCHAR2(8 BYTE)
  • 수정일자 (MOD_DATETIME) — DATE
  • 삭제자 (DEL_EMPNO) — VARCHAR2(8 BYTE)
  • 삭제일자 (DEL_DATETIME) — DATE