222222

Tables (3)

BARCODE_REGISTER_HD

  • BARCODE_PK — VARCHAR(255) — Primary key — NOT NULL
  • BALJU_ID — VARCHAR(15)
  • PARKING_QUANTITY — NUMERIC(8, 2)
  • PARKING_UNIT — VARCHAR(8)
  • BARCODE_NUMBER — INTEGER — 20240510시간으로??
  • PRODUCTRELEASE — VARCHAR(10) — 20240510
  • LABEL_PUBLISH — VARCHAR(20) — 2024-05-10 14:00
  • PRODUCT_LOT — INTEGER — 202040510(출하일자같음)
  • BARCODE_NOTE — VARCHAR(100)
  • BARCODE_DELETE — VARCHAR(8) — Y, N
  • BALJU_DAN — NUMERIC(8, 2)
  • BALJU_GONG — numeric(8, 2)
  • BALJU_VAT — numeric(8, 2)
  • BALJU_NAMT — numeric(8, 2)

RETURN_MANAGE

  • return_pk — character — Primary key — NOT NULL
  • bad_id — bigint
  • order_id — character
  • lot_no — character
  • inout_bcode — character
  • prod_cd — character
  • prod_nm — character
  • return_quantity — numeric(12, 6)
  • custo_name — character — mtrlcode에 거래처 컬럼명 확인 필요
  • bad_type — character — 입고불량/제품불량/반품
  • bad_info — character — 스크래치/찢김/인쇄불량/중량/매수 등
  • return_info — character
  • return_code — character — 등록필요 반품등록/반품진행/반품완료 등
  • reg_date — character
  • reg_update — character

SCM_OUT

  • BALJU_ID — VARCHAR(15) — Primary key — NOT NULL
  • OUT_DATE — VARCHAR(10)
  • OUT_JAN — NUMERIC(8, 2) — 발주량-출고량
  • OUT_NO — NUMERIC(8, 2)
  • IN_NO — NUMERIC(8, 2) — 출고량과 같음(일단)
  • OUT_STATE — VARCHAR(20) — 입고중, 대기
  • OUT_INFO — VARCHAR(100)
  • OUT_CHECK_DATE — VARCHAR(20) — 확인, 취소 버튼
  • OUT_CHECK_RESULT — VARCHAR(50) — 발주확인완료, 확인취소
  • OUT_BCODE — VARCHAR(20) — 임시
  • OUT_PK — VARCHAR(20) — 연+월+일+시+분+초