Barcode
Tables (3)
BARCODE (바코드)
- BARCODE (바코드번호) — CHAR — Primary key — NOT NULL
- ITEM_CODE (제품코드) — CHAR
- ITEM_NAME (제품명) — CHAR
- CUSTOMER_CODE (거래처코드) — CHAR
- CUSNAME (거래처명) — CHAR
- CUSTOMER_GUBUN (거래처구분) — CHAR
- CREATE_DATE (제품생산일자) — DATE
- PACKING_DATE (제품출하일자) — DATE
- R_PRINT_DATE (최초출력일자) — DATE
- U_PRINT_DATE (최종출력일자) — DATE
- IP (최종 입력/수정 IP) — CHAR
- OS (최종 입력/수정 OS) — CHAR
- MAC (최종 입력/수정 MAC) — CHAR
- RDATE (최초입력일) — DATE
- UDATE (최종수정일) — DATE
CUSTOMER (거래처)
- CUSTOMER_CODE (거래처코드) — CHAR — Primary key — NOT NULL
- CUSTOMER_GUBUN (거래처구분) — CHAR
- CUSNAME (거래처명) — CHAR
- PHONENO (전화번호) — CHAR
- RDATE (최초입력일) — DATE
- UDATE (최종수정일) — DATE
ITEM (제품)
- ITEM_CODE (제품코드) — CHAR — Primary key — NOT NULL
- ITEM_NAME (제품명) — CHAR
- SPEC (규격) — CHAR
- CREATE_CUSCODE (생산거래처코드) — CHAR
- CREATE_CUSNAME (생산거래처명)
- RDATE (최초입력일) — DATE
- UDATE (최종수정일) — DATE