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 — =