물류수불부, 구매
테이블 (10)
INPUT_SHEET
- INPUT_SHEET_ID — NUMBER(, ) — 기본 키 — NOT NULL — 고유키
- OFFICE_ID — VARCHAR2(3) — NOT NULL — 회사코드
- ORG_ID — VARCHAR2(3) — NOT NULL — 사업장코드
- IN_CODE — VARCHAR2(2) — NOT NULL — 품목구분
- IN_SLIP — VARCHAR2(3) — NOT NULL
- IN_DATE — VARCHAR2(8) — NOT NULL — 입고일자
- IN_NO — VARCHAR2(12) — NOT NULL — 입고번호
- IN_SEQ — NUMBER(3, 0) — NOT NULL — 입고seq
- MATCODE — VARCHAR2(16) — 품목코드
- QTY — NUMBER(14, 4) — 입고수량
- PRICE — NUMBER(14, 4) — 입고단가(EA)
- AMT — NUMBER(16, 4) — 공급가
- VAT — NUMBER(16, 4) — 부가세
- YOUNGDO — VARCHAR2(100) — 적요사항
- BIGO — VARCHAR2(250) — 상세품목명
- CURRENCY — VARCHAR2(3) — 통화
- CUSTNO — VARCHAR2(6) — 거래처코드
- MAT_GB — VARCHAR2(1) — 내외자구분
- MUSANG — VARCHAR2(30) — 부가세구분
- CAR_NO — VARCHAR2(20)
- TRNS_GB — VARCHAR2(2)
- CAR_CNT — NUMBER(3, 0)
- TRNS_CUSTNO — VARCHAR2(6) — 운송회사
- TRNS_QTY — NUMBER(14, 4)
- TRNS_PRICE — NUMBER(16, 4) — 단가(Box)
- TRNS_AMT — NUMBER(16, 4)
- TRNS_VAT — NUMBER(16, 4)
- MAN_GB — VARCHAR2(6)
- FA_GB — VARCHAR2(1)
- DVS_GB — VARCHAR2(2)
- JO_CODE — VARCHAR2(10)
- JO_DSCR — VARCHAR2(40)
- KPO_NO — VARCHAR2(15)
- KPO_OSEQ — NUMBER(3, 0)
- MAGAM — VARCHAR2(1)
- PORT_GB — VARCHAR2(1)
- NO_MAX — NUMBER(3, 0)
- CST_CDE — VARCHAR2(4) — 공정코드
- DIV_1 — VARCHAR2(1)
- DIV_2 — VARCHAR2(1)
- DIV_SANG — VARCHAR2(1)
- HWANIP_YN — VARCHAR2(1)
- VAT_CHK — VARCHAR2(1)
- VAT_RATE — NUMBER(10, 2)
- VAT_SUM — NUMBER(16, 2)
- USD_EXG — NUMBER(17, 5) — 환율
- USD_AMT — NUMBER(17, 5) — 외화금액
- PO_NO — VARCHAR2(13) — 구매결의 번호
- ETC_AMT — NUMBER(14, 2) — 기타비용
- OUT_CHECK — VARCHAR2(1) — 검사필수여부
- JAN_QTY — NUMBER(14, 4)
- JAN_AMT — NUMBER(16, 4)
- JAN_VAT — NUMBER(16, 4)
- REMARK — VARCHAR2(300)
- USER_ID — VARCHAR2(20) — 최종수정자
- WRK_DATE — DATE — 최종수정일
- RAP_DEPT — VARCHAR2(3)
- CHK_YEAR_MTH — VARCHAR2(6) — 검수연월
- CHK_NBR — VARCHAR2(50) — 검수번호
- CHK_NBR_SEQ — NUMBER(3, 0) — 검수seq
- … +50
MTL_LOT_TMP
- OFFICE_ID — VARCHAR2(3) — NOT NULL
- ORG_ID — VARCHAR2(3) — NOT NULL
- DIRECTION_CODE — VARCHAR2(20) — NOT NULL
- CUSTNO — VARCHAR2(6) — NOT NULL
- SHIP_CUSTNO — VARCHAR2(30) — NOT NULL
- MATCODE — VARCHAR2(20) — NOT NULL
- SUBINV — VARCHAR2(20) — NOT NULL
- LOT_NO — VARCHAR2(30) — NOT NULL
- LOT_SEQ — NUMBER(,) — NOT NULL
- QTY — NUMBER(12,5)
- ACT_QTY — NUMBER(12,5)
- CHK_YN — VARCHAR2(1)
- ORD_TYPE — VARCHAR2(3) — NOT NULL
- SHIP_NO — VARCHAR2(20) — NOT NULL
- SHIP_DATE — VARCHAR2(8) — NOT NULL
- SHIP_SEQ — NUMBER(,) — NOT NULL
- SHIP_DEPT — VARCHAR2(3) — NOT NULL
- SHIP_YN — VARCHAR2(1)
- WRK_DATE — DATE
- WRK_USER — VARCHAR2(10)
MTL_ONHAND
- OFFICE_ID — VARCHAR2(3) — NOT NULL
- ORG_ID — VARCHAR2(3) — NOT NULL
- MATCODE — VARCHAR2(20) — NOT NULL
- SUBINV — VARCHAR2(20) — NOT NULL
- LOT_NO — VARCHAR2(30) — NOT NULL
- LOC_NO — VARCHAR2(30) — NOT NULL
- SER_NO — VARCHAR2(30) — NOT NULL
- UOM — VARCHAR2(10)
- QTY — NUMBER(16,5)
- DATE_RECEIVED — DATE
- LAST_UPDATE_DATE — DATE
- LAST_UPDATE_BY — VARCHAR2(20)
- CREATION_DATE — DATE
- CREATION_BY — VARCHAR2(20)
- CREATE_IP — VARCHAR2(20)
- UPDATE_IP — VARCHAR2(20)
- CREATE_WIN_ID — VARCHAR2(20)
- UPDATE_WIN_ID — VARCHAR2(20)
- WIP_QTY — NUMBER(,)
- MOVE_QTY — NUMBER(16,5)
MTL_TRANS
- OFFICE_ID — VARCHAR2(3) — 기본 키 — NOT NULL
- ORG_ID — VARCHAR2(3) — 기본 키 — NOT NULL
- T_TYPE_ID — VARCHAR2(3) — 기본 키 — NOT NULL
- T_ACTION_ID — VARCHAR2(3) — 기본 키 — NOT NULL — I 입고, O 출고
- T_SOURCE_TYPE_ID — VARCHAR2(3) — 기본 키 — NOT NULL — inv.cmcode = 'TXNSRCTYP' 에서 참고
- T_SOURCE_ID — VARCHAR2(3) — 기본 키 — NOT NULL — inv.cmcode = 'TXNSRCID' 참고
- T_CODE — VARCHAR2(2) — 기본 키 — NOT NULL — inv.cmcode = 'ITMKND' 참고
- T_SLIP — VARCHAR2(3) — 기본 키 — NOT NULL
- T_DATE — VARCHAR2(8) — 기본 키 — NOT NULL
- T_NO — VARCHAR2(20) — 기본 키 — NOT NULL
- T_SEQ — NUMBER(3, 0) — 기본 키 — NOT NULL
- SEQ — NUMBER(, 0) — 기본 키 — NOT NULL
- T_YYYYMMDD — VARCHAR2(8) — 년월일
- T_YYMM — VARCHAR2(6) — 년월
- T_SOURCE_NAME — VARCHAR2(30) — t_sou
- CUSTNO — VARCHAR2(12) — T_source_type_id 의 한글명
- MATCODE — VARCHAR2(16)
- ACC_CDE — VARCHAR2(7) — 회계코드
- CST_CDE — VARCHAR2(4) — 공정코드
- TRNAS_DEPT — VARCHAR2(3) — 수불발생부서
- ITEM_GROUP_CODE — VARCHAR2(4)
- SUBINVENTORY_CODE — VARCHAR2(20) — 창고코드
- LOT_NO — VARCHAR2(30) — 로트넘버
- LOC_NO — VARCHAR2(30)
- CURRENCY — VARCHAR2(5)
- CURRENCY_RATE — NUMBER(17, 5)
- CURRENCY_TYPE — VARCHAR2(30)
- CURRENCY_DATE — DATE
- VAT_TYPE — VARCHAR2(20)
- QTY — NUMBER(15, 5) — 수량
- PRICE — NUMBER(16, 4) — 단가
- AMT — NUMBER(16, 3) — 금액
- AMT_FOR — NUMBER(16, 3)
- TAX — NUMBER(16, 3)
- TAX_RATE — NUMBER(10, 4)
- TAX_TYPE — VARCHAR2(30)
- HAP_AMT — NUMBER(16, 3)
- KPONO — VARCHAR2(15) — po 넘버
- OSEQ — NUMBER(3, 0)
- REQNO — VARCHAR2(15)
- RSEQ — NUMBER(3, 0)
- PJ_DEPT — VARCHAR2(3)
- ENTPR_INFM_TYPE — VARCHAR2(1)
- PJ_CDE — VARCHAR2(12)
- IDATE — VARCHAR2(8)
- IPGOGB — VARCHAR2(1)
- IN_SLIP — VARCHAR2(3)
- IN_NO — VARCHAR2(12)
- IN_SEQ — NUMBER(3, 0)
- PUR_QTY — NUMBER(13, 5)
- PUR_PRICE — NUMBER(16, 3)
- PUR_AMT — NUMBER(16, 3)
- OFC_DEPT — VARCHAR2(3)
- SALE_MAN — VARCHAR2(20)
- RAP_KIND — VARCHAR2(3) — sale.saetc = 'ORDTYP' 참고
- MKT_TYPE — VARCHAR2(3)
- RGN_CDE — VARCHAR2(3)
- OUT_LOC_TYPE — VARCHAR2(1)
- OUT_LOC — VARCHAR2(20)
- DGP_CDE — VARCHAR2(6)
- … +71
MTL_TRANS_LOT
- MTL_LOT_ID — NUMBER(, ) — NOT NULL — MTL_LOT_ID 단순 시퀀스
- OFFICE_ID — VARCHAR2(3) — NOT NULL
- ORG_ID — VARCHAR2(3) — NOT NULL
- T_TYPE_ID — VARCHAR2(3) — NOT NULL
- T_ACTION_ID — VARCHAR2(3) — NOT NULL — I 입고, O 출고
- T_SOURCE_TYPE_ID — VARCHAR2(3) — NOT NULL — inv.cmcode = 'TXNSRCTYP' 에서 참고
- T_SOURCE_ID — VARCHAR2(3) — NOT NULL — inv.cmcode = 'TXNSRCID' 참고
- T_CODE — VARCHAR2(2) — NOT NULL — inv.cmcode = 'ITMKND' 참고
- T_SLIP — VARCHAR2(3) — NOT NULL
- T_DATE — VARCHAR2(8) — NOT NULL
- T_NO — VARCHAR2(12) — NOT NULL — 시퀀스와 또다른 NO
- T_SEQ — NUMBER(3, 0) — NOT NULL — NO-> SEQ 순서
- SEQ — NUMBER(3, 0) — NOT NULL
- MATCODE — VARCHAR2(16) — NOT NULL
- SUBINVENTORY_CODE — VARCHAR2(20) — NOT NULL — 창고코드
- LOT_NO — VARCHAR2(30) — NOT NULL — 로트넘버
- LOC_NO — VARCHAR2(30) — NOT NULL
- SER_NO — VARCHAR2(30) — NOT NULL
- QTY — NUMBER(15, 5) — 수량
- STATUS — VARCHAR2(1) — 상태
- REM — VARCHAR2(50) — 적요
- DATE_RECEIVED — DATE
- LAST_UPDATE_DATE — DATE
- LAST_UPDATE_BY — VARCHAR2(20)
- CREATION_DATE — DATE
- CREATION_BY — VARCHAR2(20)
- CREATE_IP — VARCHAR2(20)
- UPDATE_IP — VARCHAR2(20)
- CREATE_WIN_ID — VARCHAR2(20)
- UPDATE_WIN_ID — VARCHAR2(20)
- TRANS_MTL_LOT_ID — NUMBER(, )
- SEQUENCE_ID — NUMBER(13, 0) — 또다른 단순 시퀀스
OUTPUT_SHEET
- OUTPUT_SHEET_ID — NUMBER(13,0) — NOT NULL
- OFFICE_ID — VARCHAR2(3) — NOT NULL
- ORG_ID — VARCHAR2(3) — NOT NULL
- OUT_CODE — VARCHAR2(3) — NOT NULL
- OUT_SLIP — VARCHAR2(3) — NOT NULL
- OUT_DATE — VARCHAR2(8) — NOT NULL
- OUT_NO — VARCHAR2(12) — NOT NULL
- OUT_SEQ — NUMBER(3,0) — NOT NULL
- OUT_TYPE_ID — VARCHAR2(5)
- OUT_REQ_ID — NUMBER(13,0)
- CUSTNO — VARCHAR2(20)
- SALE_GB — VARCHAR2(2)
- MATCODE — VARCHAR2(16)
- QTY — NUMBER(17,5)
- PRICE — NUMBER(16,4)
- AMT — NUMBER(17,2)
- TAX — NUMBER(17,2)
- TRNS_CUSTNO — VARCHAR2(6)
- TRNS_QTY — NUMBER(17,5)
- TRNS_PRICE — NUMBER(15,4)
- TRNS_AMT — NUMBER(17,2)
- YOUNGDO — VARCHAR2(80)
- BIGO — VARCHAR2(50)
- CURRENCY — VARCHAR2(3)
- MAT_GB — VARCHAR2(1)
- MAN_GB — VARCHAR2(6)
- OUT_GB — VARCHAR2(1)
- JO_CODE — NUMBER(3,1)
- JO_DSCR — VARCHAR2(10)
- OUT_DEPT — VARCHAR2(3)
- CST_CDE — VARCHAR2(4)
- MO_SHIPNO — VARCHAR2(10)
- DONG_GB — VARCHAR2(10)
- MAT_REQ — VARCHAR2(14)
- MAT_REQ_SEQ — NUMBER(3,0)
- IO_NO — VARCHAR2(20)
- MAGAM — VARCHAR2(1)
- PORT_GB — VARCHAR2(1)
- NO_MAX — NUMBER(3,0)
- PACK_GB — VARCHAR2(2)
- GITA_CHK — VARCHAR2(1)
- CARNO — VARCHAR2(7)
- DELIVERY_GB — VARCHAR2(1)
- ADD_YN — VARCHAR2(4)
- JASAN_CHK — VARCHAR2(1)
- MON_CHK — VARCHAR2(1)
- CH_CODE — VARCHAR2(1)
- T_BIGO — VARCHAR2(100)
- T_DO — VARCHAR2(100)
- TRANS_GB — VARCHAR2(1)
- USER_ID — VARCHAR2(30)
- WRK_DATE — DATE
- RAP_DEPT — VARCHAR2(3)
- CHK_YEAR_MTH — VARCHAR2(6)
- CHK_NBR — VARCHAR2(5)
- CHK_NBR_SEQ — NUMBER(3,0)
- CHK_DATE — VARCHAR2(8)
- LC_NBR — VARCHAR2(20)
- LC_DGRE — NUMBER(3,0)
- RAP_KIND — VARCHAR2(2)
- … +39
OUT_REQ
- OUT_REQ_ID — NUMBER(13,0) — NOT NULL
- OFFICE_ID — VARCHAR2(3) — NOT NULL
- ORG_ID — VARCHAR2(3) — NOT NULL
- OUT_NO — VARCHAR2(15) — NOT NULL
- OUT_SEQ — NUMBER(3,0) — NOT NULL
- OUT_TYPE — VARCHAR2(1)
- MATCODE — VARCHAR2(20)
- OUT_DATE — VARCHAR2(8)
- CUS_CDE — VARCHAR2(20)
- QTY — NUMBER(15,3)
- OUT_NO_MAX — NUMBER(3,0)
- OUT_YN — VARCHAR2(1)
- JASAN_CHK — VARCHAR2(3)
- CST_CDE — VARCHAR2(4)
- YOUNGDO — VARCHAR2(300)
- OUTPUT_SLIP — VARCHAR2(3)
- OUTPUT_NO — VARCHAR2(12)
- OUTPUT_SEQ — NUMBER(3,0)
- OUT_DEPT — VARCHAR2(3)
- OUT_PRICE — NUMBER(15,4)
- OUT_AMT — NUMBER(15,2)
- ACC_CDE — VARCHAR2(20)
- RAP_WRH — VARCHAR2(20)
- RAPLOC — NUMBER(,)
- LOT_NO — VARCHAR2(30)
- TO_SUBINV — VARCHAR2(20)
- CAR_PER_QTY — NUMBER(15,3)
- CARTON_QTY — NUMBER(15,3)
- PLT_PER_QTY — NUMBER(15,3)
- PLT_QTY — NUMBER(15,3)
- BIGO — VARCHAR2(500)
- USER_ID — VARCHAR2(20) — NOT NULL
- TRML_ID — VARCHAR2(20)
- WIN_ID — VARCHAR2(20) — NOT NULL
- WRK_DATE — DATE
- DUE_DATE — VARCHAR2(8)
- PRO_MATCODE — VARCHAR2(20)
PURKPO
- PURKPO_ID — NUMBER(13, 0) — 기본 키 — NOT NULL
- OFFICE_ID — VARCHAR2(3) — NOT NULL
- ORG_ID — VARCHAR2(3) — NOT NULL
- KPONO — VARCHAR2(15) — NOT NULL — 구매번호
- OSEQ — NUMBER(3,0) — NOT NULL — 순번
- PURREQ_ID — NUMBER(13,0)
- REQREF — VARCHAR2(20)
- MATCODE — VARCHAR2(16) — 입고품목코드
- RPART — VARCHAR2(3)
- ODATE — VARCHAR2(8) — 결의일자
- CUSTNO — VARCHAR2(6) — 거래처
- SHIPNO — VARCHAR2(20)
- IDATE — VARCHAR2(8) — 납기일자
- PAYMENT — VARCHAR2(50)
- INQNO — VARCHAR2(10)
- PROJECT — VARCHAR2(40)
- SHIPPING — VARCHAR2(20)
- RQTY — NUMBER(15,3) — 요청수량
- QTY — NUMBER(15,3) — 결의수량
- PRICE — NUMBER(15,4) — 결의단가
- AMT — NUMBER(17,2) — 결의금액
- TAX — NUMBER(17,2) — 결의부가세
- TAX_RATE — NUMBER(2,0) — 세율
- AMOUNTGB — VARCHAR2(1) — 인도조건
- IPGOYN — VARCHAR2(1) — 입고
- CURRENCY — VARCHAR2(3)
- LDATE — VARCHAR2(8)
- KPONOSEQ — NUMBER(3,0)
- STOCK_GB — VARCHAR2(20)
- BIGO — VARCHAR2(100) — 상세품목
- CST_CDE — VARCHAR2(4) — 원가공정
- OLD_KPONO — VARCHAR2(12)
- USER_ID — VARCHAR2(10)
- WRK_DATE — DATE
- IPGOGB — VARCHAR2(1) — 승인여부
- IN_SLIP — VARCHAR2(3)
- IN_NO — VARCHAR2(12) — 입고번호
- IN_SEQ — NUMBER(3,0)
- DEMD_BRCH — VARCHAR2(3) — 수요사업장
- RSLN_DEPT — VARCHAR2(3)
- PRCRM_NTNL — VARCHAR2(3)
- PRC_TERM — VARCHAR2(3)
- STLM_TERM — VARCHAR2(30) — 결제조건
- LMT_PDATE — VARCHAR2(8)
- CNTR_ORGN_CDE — VARCHAR2(3)
- DLVRY_TERM — VARCHAR2(1)
- CVY_TYPE — VARCHAR2(2) — 운송구분
- LDG_TYPE — VARCHAR2(5)
- PRCRM_MTHD — VARCHAR2(1) — 내자,외자구분
- VAT_TYPE — VARCHAR2(1)
- PAY_TYPE — VARCHAR2(1)
- STLM_DATE — NUMBER(3,0)
- OTHER_CHARGE — NUMBER(15,3)
- PJ_DEPT — VARCHAR2(3)
- ENTPR_INFM_TYPE — VARCHAR2(30) — 부가세유형
- PJ_CDE — VARCHAR2(6)
- CONST_CDE — VARCHAR2(4)
- MNFTU_CO — VARCHAR2(6)
- ACC_CDE — VARCHAR2(7) — 계정코드
- ITEM_GROUP_CODE — VARCHAR2(4)
- … +22
PURREQ
- PURREQ_ID — NUMBER(13, 0) — 기본 키 — NOT NULL — 요청ID
- OFFICE_ID — VARCHAR2(3) — NOT NULL
- ORG_ID — VARCHAR2(3) — NOT NULL
- REQNO — VARCHAR2(15) — NOT NULL — 요청NO
- RSEQ — NUMBER(3,0) — NOT NULL — 요청순번
- MATCODE — VARCHAR2(16) — NOT NULL — 품목코드
- RDATE — VARCHAR2(8) — 요청일자
- DEPT_CDE — VARCHAR2(3) — 요청부서
- RQTY — NUMBER(15,3) — 신청수량
- WDATE — VARCHAR2(8) — 입고요청일
- PDATE — VARCHAR2(8)
- HDATE — VARCHAR2(8)
- STOCK_GB — VARCHAR2(5) — 재고구분
- USSAGE — VARCHAR2(100) — 용도
- BIGO — VARCHAR2(100) — 상세규격
- REQNOSEQ — NUMBER(3,0)
- HEAD_FACTORY — VARCHAR2(1)
- KPO_YN — VARCHAR2(1)
- KPONO — VARCHAR2(15)
- OSEQ — NUMBER(3,0)
- URGENT_YN — VARCHAR2(1)
- CANCEL_YN — VARCHAR2(1)
- AUTO_YN — VARCHAR2(1) — 신청상태
- CST_CDE — VARCHAR2(4) — 원가공정
- SIGN_YN — VARCHAR2(1)
- OLD_REQNO — VARCHAR2(13)
- USER_ID — VARCHAR2(10)
- WRK_DATE — DATE
- ACC_CDE — VARCHAR2(7) — 계정과목
- ORD_NO — NUMBER(,)
- REM1 — VARCHAR2(250)
- REM2 — VARCHAR2(250)
- CUSTNO — VARCHAR2(50) — 거래처
- PRICE — NUMBER(15,4) — 예상단가
- AMT — NUMBER(17,2) — 예상금액
- APP_SEQ — NUMBER(,)
SUPPLIER_PRICE
- OFFICE_ID — VARCHAR2(3) — 기본 키 — NOT NULL
- ORG_ID — VARCHAR2(3) — 기본 키 — NOT NULL
- CUSTNO — VARCHAR2(30) — 기본 키 — NOT NULL — 거래처코드
- MATCODE — VARCHAR2(20) — 기본 키 — NOT NULL — 품목코드
- START_DATE — DATE — 기본 키 — NOT NULL — 시작일자
- PRICE_ID — NUMBER(13, 0) — NOT NULL — 의미없는 시퀀스(primary code) 사용위해
- PRICE_GU — VARCHAR2(5) — NOT NULL — 구매단가표 100, 외주단가표
- CURRENCY — VARCHAR2(3) — NOT NULL — 통화단위
- MATUNIT — VARCHAR2(10) — NOT NULL — 단위
- END_DATE — DATE — 종료일자
- UNIT_PRICE — NUMBER(15,4) — 단가
- BOX_PRICE — NUMBER(15,4)
- UNDER_UNIT_PRICE — NUMBER(15,4)
- OVER_UNIT_PRICE — NUMBER(15,4)
- QUANTITY — NUMBER(15,4)
- QUANTITY_EXPOSURE — NUMBER(15,4)
- ACTIVE_FLAG — VARCHAR2(30) — 사용여부
- ATTRIBUTE1 — VARCHAR2(500) — 비고사항
- ATTRIBUTE2 — VARCHAR2(150) — 면(53)과세(51)
- ATTRIBUTE3 — VARCHAR2(150)
- ATTRIBUTE4 — VARCHAR2(150)
- ATTRIBUTE5 — VARCHAR2(150)
- USER_ID — VARCHAR2(30)
- WRK_DATE — DATE