비교용 자재
테이블 (11)
반입 (TM_RETSTK)
- INP_NO — 외래 키 → 입고자재.INP_NO — NOT NULL
- MAT_CD
- BSN_CD
- RET_TYPE
- RET_QTY
- RET_UNIT
- RET_DEPT
- RET_PRACD
- STK_CD
- LOC_CD
- RET_DT
- RET_EMPNO
- INP_RMK
- INP_PRICE
- INP_PUNIT
- INP_PRODDT
반품 (TM_RETVENDOR)
- OUT_NO — 기본 키 — NOT NULL
- INP_NO — 외래 키 → 입고자재.INP_NO — NOT NULL
- MAT_CD
- BSN_CD
- RV_QTY
- RV_UNIT
- VENDOR
- STK_CD
- RV_DT
- RV_EMPNO
- OUT_RMK
- RV_TYPE
선매입 입고자재 DTL (TM_MATINPUT_PREDTL)
- PRE_NO — 기본 키 — NOT NULL
- PRE_LOTNO
- PRE_QTY
- OUT_QTY
- STK_QTY
입고 (TM_MATINPUT)
- INP_NO — 기본 키 — NOT NULL
- MAT_CD
- BSN_CD
- INP_SEC
- INP_TYPE
- INP_SLIPNO
- INP_QTY
- INP_UNIT
- INP_PRICE
- INP_PUNIT
- INSP_NO
- INSP_YN
- STK_CD
- LOC_CD
- INP_PDT
- INP_PEMPNO
- INP_CDT
- INP_CEMPNO
- OUT_QTY
- STK_QTY
- INP_USEYN
- INP_RMK
- INP_LOTNO
- INP_LOT_QTY
- ITEM_MCD
- SHIP_RESULT
- IQC_RESULT
- IQC_INPUTDT
- IQC_DOCNO
- IQC_REASON
- INP_LONGTERMSEC
- INP_MATEND
- INP_PRODDT
- INP_ORDNO
- INP_PRESEC
- INP_PRENO
- INP_EXTDT
- INP_DISNO
- INP_DIS_QTY
- INSP_PRCTYPE
- INP_ADNO
입고자재 (TM_MATINPUT_DTL)
- INP_LOTNO — 기본 키 — NOT NULL
- INP_NO — 외래 키 → 입고.INP_NO — NOT NULL
- IND_QTY
- IND_TOP
- IND_YN
- OUT_QTY
- STK_QTY
- IND_DISNO
- IND_DIS_QTY
- IND_MATEND
자재마스터 (TM_MATMAS)
- BSN_CD — 기본 키 — NOT NULL
- MAT_CD — 기본 키 — NOT NULL
- MAT_NM
- MAT_LCD
- MAT_MCD
- MAT_SCD
- MAT_SNO
- MAT_DESC
- MAT_SEC
- CMP_CD
- MAT_SAFEQTY
- MINPOQTY
- MAT_UNIT
- MAT_PAKQTY
- MAT_PAKDESC
- MAT_PRICE
- MAT_CURCD
- MAT_ORIGIN
- MAT_VALIDITY
- MAT_COMSEC
- MAT_POMTHD
- MAT_USEYN
- MAT_ABC
- MAT_POEMPNO
- MAT_LOSSRATE
- MAT_POYN
- MAT_INPYN
- MAT_EMP_NO
- MAT_DT
- STOCK_CD
- LOCATION_CD
- MAT_DCD
- MAT_INPITEM
- ITEM_MCD
- MAT_TYPE
- MAT_MATCH
- MAT_USAGE
- MAT_GRADE
- MAT_SPEC
- MAT_APP_DT
- MAT_ICP_NO
- MAT_BIGO
- MAT_ICP_DT1
- MAT_ICP_DT2
- MAT_MSDS_NO
- MAT_QYN
- MAT_ICP_FILE
- MAT_PPAP_DT
- MAT_MSDS_FILE
- ITEM_LDFRAME
- BSN_SEC
- MAT_VALIDITYSEC
- MAT_BASEUNIT
- MAT_BASEQTY
- MAT_BASEUNIT2
- MAT_BASEQTY2
- MAT_STOCKSEC
- ITEM_EMC
자재출고 (TM_MATOUTPUT)
- OUT_SEQ — 기본 키 — NOT NULL
- OTR_NO — 외래 키 → 자재출고요청.OTR_NO — NOT NULL
- MAT_CD — 외래 키 → 자재출고요청.MAT_CD — NOT NULL
- BSN_CD
- INP_NO
- OUT_SLIPNO
- OUT_TYPE
- OUT_DPTCD
- OUT_PRACD
- OUT_QTY
- OUT_UNIT
- OUT_DT
- OUT_EMPNO
- OUT_RMK
- INP_LONGTERMSEC
자재출고DTL (TM_MATOUTPUT_DTL)
- OUT_LOTNO — 기본 키 — NOT NULL
- OTR_NO — 외래 키 → 자재출고.OTR_NO — NOT NULL
- MAT_CD — 외래 키 → 자재출고.MAT_CD — NOT NULL
- OUT_SEQ — 외래 키 → 자재출고.OUT_SEQ — NOT NULL
- INP_NO
- OUT_PREQTY
- OUT_QTY
- OUT_STKQTY
- OUT_UNIT
- OUT_DT
- OUT_EMPNO
- OUT_RMK
자재출고요청 (TM_OUTPUTREQ)
- OTR_NO — 기본 키 — NOT NULL
- MAT_CD — 기본 키 — NOT NULL
- BSN_CD
- OTR_TYPE
- OTR_QTY
- OTR_UNIT
- OTR_DT
- OTR_DPTCD
- OTR_EMPNO
- OTR_OUTQTY
- OTR_OUTYN
- OTR_OUTEMPNO
- OTR_OUTDT
- OTR_RMK
- OTR_BOX
- OTR_PALLET
자재코드구분 (X)
- LEV
- CODE
- NAME
폐기 (TM_MATDISUSE)
- DISUSE_NO — 기본 키 — NOT NULL
- DISUSE_SEQ — 기본 키 — NOT NULL
- BSN_CD
- MAT_CD
- DISUSE_DT
- DISUSE_QTY
- DISUSE_UNIT
- DISUSE_EACH_PRICE
- DISUSE_PUNIT
- DISUSE_EXPDT
- DISUSE_SEC
- DISUSE_REASON
- DISUSE_FILELINK
- DISUSE_YN
- DISUSE_RMK
- DISUSE_INPUTDT (DISUSE_INPUTDTe)
- DISUSE_INPUTEMPNO