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