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