d
Tables (3)
MTPICK
- detail_id — varchar(12) — Primary key — NOT NULL
- detai_hang — int — Primary key — NOT NULL
- code — varchar(20) — Primary key — NOT NULL
- lot — varchar(12) — Primary key — NOT NULL
- bag — varchar(2) — Primary key — NOT NULL
- sp — varchar(2) — Primary key — NOT NULL
- wrap — varchar(1) — Primary key — NOT NULL
- pick_qty — numeric(10, 3)
- pick_date — varchar(8)
- pick_time — varchar(6)
- loca — varchar(10)
- car_no — varchar(20)
- cancel_flag — char(1)
- sale_no — varchar(10)
- sale_type — varchar(4)
- sale_gubun — varchar(2)
- sale_flag — char(1)
- sale_id — varchar(15)
- sale_date — varchar(8)
- sale_time — varchar(6)
- logid — varchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MTREVD
- revd_detail_id — varchar(14) — Primary key — NOT NULL
- revd_detail_hang — int — Primary key — NOT NULL
- revd_code — varchar(20) — Primary key — NOT NULL
- revd_lot — varchar(12) — Primary key — NOT NULL
- revd_bag — varchar(2) — Primary key — NOT NULL
- revd_sp — varchar(2) — Primary key — NOT NULL
- revd_wrap — varchar(1) — Primary key — NOT NULL
- detail_id (detail_id2) — varchar(12) — Foreign key → MTPICK.detail_id — NOT NULL
- detai_hang — int — Foreign key → MTPICK.detai_hang — NOT NULL
- code (code2) — varchar(20) — Foreign key → MTPICK.code — NOT NULL
- lot (lot2) — varchar(12) — Foreign key → MTPICK.lot — NOT NULL
- bag (bag2) — varchar(2) — Foreign key → MTPICK.bag — NOT NULL
- sp (sp2) — varchar(2) — Foreign key → MTPICK.sp — NOT NULL
- wrap (wrap2) — varchar(1) — Foreign key → MTPICK.wrap — NOT NULL
- revd_date — varchar(8)
- revd_time — varchar(6)
- revd_requ_qty — numeric(10, 3)
- revd_qty — numeric(10, 3)
- revd_oqty — numeric(10, 3)
- revd_car_no — varchar(20)
- revd_cancel_qty — numeric(10, 3)
- revd_sale_no — varchar(10)
- revd_sale_type — varchar(4)
- revd_sale_gubun — varchar(2)
- revd_logid — varchar(10)
- revd_sale_cnt — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MtSiot
- siot_code — varchar(20) — Primary key — NOT NULL
- siot_lot — varchar(12) — Primary key — NOT NULL
- siot_bag — varchar(2) — Primary key — NOT NULL
- siot_sp — varchar(2) — Primary key — NOT NULL
- siot_wrap — varchar(1) — Primary key — NOT NULL
- detail_id — varchar(12) — Foreign key → MTPICK.detail_id — NOT NULL
- detai_hang — int — Foreign key → MTPICK.detai_hang — NOT NULL
- code (code2) — varchar(20) — Foreign key → MTPICK.code — NOT NULL
- lot (lot2) — varchar(12) — Foreign key → MTPICK.lot — NOT NULL
- bag (bag2) — varchar(2) — Foreign key → MTPICK.bag — NOT NULL
- sp (sp2) — varchar(2) — Foreign key → MTPICK.sp — NOT NULL
- wrap (wrap2) — varchar(1) — Foreign key → MTPICK.wrap — NOT NULL
- siot_iwol — numeric(10, 3)
- siot_inpt — numeric(10, 3)
- siot_oupt — numeric(10, 3)
- siot_stok — numeric(10, 3)
- siot_updt — numeric(10, 3)
- siot_yiwol — numeric(10, 3)
- siot_yinpt — numeric(10, 3)
- siot_youpt — numeric(10, 3)
- siot_ystok — numeric(10, 3)
- siot_yupdt — numeric(10, 3)
- siot_ciwol — numeric(10, 3)
- siot_cinpt — numeric(10, 3)
- siot_coupt — numeric(10, 3)
- siot_cstok — numeric(10, 3)
- siot_cupdt — numeric(10, 3)
- siot_stok_revd — numeric(10, 3)
- siot_ystok_revd — numeric(10, 3)
- siot_cstok_revd — numeric(10, 3)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =