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