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