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) — 연+월+일+시+분+초