oms

Tables (6)

nvnt_bss_hstr (기초재고 이력)

  • id (Key) — varchar(36) — Primary key — NOT NULL
  • bss_id (Field) — varchar(36)
  • stck_yn (Field2) — char(1)
  • hstr_type_code (Field3) — varchar(14)
  • rgst_id (Field5) — varchar(12)
  • rgst_date (Field6) — datetime

nvnt_bss_hstr_dtl (재고관리 라벨 기초재고 이력 상세)

  • id (Key) — varchar(36) — Primary key — NOT NULL
  • hstr_id (Field) — varchar(36)
  • stck_yn (Field13) — char(1)
  • str_id (Field12) — varchar(12)
  • hstr_type_code (Field10) — varchar(14)
  • move_drc_code (Field11) — varchar(14)
  • item_id (Field2) — varchar(36)
  • lbl_id (Field3) — varchar(36)
  • ncdc_type_code (Field4) — varchar(14)
  • qntt (Field5) — int
  • cntr_str_id (Field6) — varchar(12)
  • cntr_stck_yn (Field7) — char(1)
  • rgst_id (Field8) — varchar(12)
  • rgst_date (Field9) — datetime

nvnt_bss_hstr_dts (기초재고 이력 상세)

  • id (Key) — varchar(36) — Primary key — NOT NULL
  • hstr_id (Field) — varchar(36)
  • item_id (Field2) — varchar(36)
  • lbl_id (Field3) — varchar(36)
  • ncdc_type_code (Field4) — varchar(14)
  • qntt (Field5) — int
  • cntr_str_id (Field6) — varchar(12)
  • rgst_id (Field7) — varchar(12)
  • rgst_date (Field8) — datetime

nvnt_bss_mngm (기초재고 관리)

  • id (Key) — varchar(36) — Primary key — NOT NULL
  • str_id (Field) — varchar(12)
  • rgst_id (Field5) — varchar(12)
  • rgst_date (Field8) — datetime

nvnt_lbl_bss_hstr (재고관리 라벨 기초재고 이력)

  • id (Key) — varchar(36) — Primary key — NOT NULL
  • str_id (Field) — varchar(12)
  • rgst_id (Field5) — varchar(12)
  • rgst_date (Field8) — datetime

nvnt_lbl_bss_stck (재고관리 라벨 기초재고)

  • str_id (Key) — varchar(36) — Primary key — NOT NULL
  • item_id (Key2) — varchar(36) — Primary key — NOT NULL
  • bss_qntt (Field) — int
  • base_date (Field2) — date
  • rgst_id (Field3) — varchar(12)
  • rgst_date (Field4) — datetime
  • modfc_id (Field5) — varchar(12)
  • mdfc_date (Field6) — datetime