practice_3PL

Tables (11)

ITEM_MST (상품마스터)

  • ITEM_CD — string — Primary key — NOT NULL
  • ITEM_NM — string
  • SHIPPER_CD (PKSHIPPER_CD) — string — Foreign key → SHIPPER.SHIPPER_CD — NOT NULL — PK

PLAN_DTL (입고예정디테일)

  • PLAN_NO — string — Foreign key → PLAN_HDR.PLAN_NO — NOT NULL — PK
  • ITEM_CD — string — Foreign key → ITEM_MST.ITEM_CD — NOT NULL
  • PLAN_QTY — int

PLAN_HDR (입고예정마스터)

  • PLAN_NO — string — Primary key — NOT NULL — PK
  • PLAN_DATE — date
  • STATUS — string
  • SHIPPER_CD (PKSHIPPER_CD) — string — Foreign key → SHIPPER.SHIPPER_CD — NOT NULL — PK
  • WH_CD — string — Foreign key → WAREHOUSE.WH_CD — NOT NULL — PK

RECV_RSLT (입고실적)

  • RECV_NO — string — Primary key — NOT NULL
  • PLAN_NO — string — Foreign key → PLAN_DTL.PLAN_NO — NOT NULL — PK
  • ITEM_CD — string — Foreign key → PLAN_DTL.ITEM_CD — NOT NULL
  • ACTUAL_QTY — int
  • INSPECT_RESULT — string

SHIPPER (화주)

  • SHIPPER_CD (PKSHIPPER_CD) — string — Primary key — NOT NULL — PK
  • SHIPPER_NM — string

STOCK (재고마스터)

  • LOC_CD — string — Primary key — NOT NULL
  • WH_CD — string — Foreign key → WAREHOUSE.WH_CD — NOT NULL — PK
  • ITEM_CD — string — Foreign key → ITEM_MST.ITEM_CD — NOT NULL
  • QTY — int

STOCK_ADJ_HIST (재고 조정 이력)

  • ADJ_NO — string — Primary key — NOT NULL
  • LOC_CD — string
  • BEFORE_QTY — int
  • ADJ_QTY — int
  • AFTER_QTY — int
  • REASON — string
  • WH_CD — string — Foreign key → WAREHOUSE.WH_CD — NOT NULL — PK
  • ITEM_CD — string — Foreign key → ITEM_MST.ITEM_CD — NOT NULL

STOCK_COUNT_DTL (재고 실사 디테일)

  • LOC_CD — string — Primary key — NOT NULL
  • ITEM_CD — string — Foreign key → ITEM_MST.ITEM_CD — NOT NULL
  • COUNT_NO — string — Foreign key → STOCK_COUNT_HDR.COUNT_NO — NOT NULL
  • SYSTEM_QTY (STSTEN_QTY) — string
  • COUNT_QTY — string

STOCK_COUNT_HDR (재고 실사 마스터)

  • COUNT_NO — string — Primary key — NOT NULL
  • WH_CD — string — Foreign key → WAREHOUSE.WH_CD — NOT NULL — PK
  • COUNT_DATE — date
  • STATUS — string

STOCK_MOVE_HIST (재고 이동 이력)

  • MOVE_NO — string — Primary key — NOT NULL
  • QTY — int
  • WH_CD — string — Foreign key → WAREHOUSE.WH_CD — NOT NULL — PK
  • ITEM_CD — string — Foreign key → ITEM_MST.ITEM_CD — NOT NULL

WAREHOUSE (창고)

  • WH_CD — string — Primary key — NOT NULL — PK
  • WH_NM — string