CMX IT UTIL
Tables (4)
Barcode_block
- PLANT_CODE — nvarchar(30) — Primary key — NOT NULL
- BARCODE_NO — nvarchar(60) — Primary key — NOT NULL
- CHANGETYPE — nvarchar(30) — Primary key — NOT NULL
- GUBUN_CODE — nvarchar(4)
- ITEM_CODE — nvarchar(30)
- ITEM_QTY — decimal(13, 0)
- ITEM_WEIGHT — decimal(13, 2)
- TUIP_QTY — decimal(13, 0)
- TUIP_WEIGHT — decimal(13, 2)
- IN_QTY — decimal(13, 0)
- IN_WEIGHT — decimal(13, 2)
- OUT_QTY — decimal(13, 0)
- OUT_WEIGHT — decimal(13, 2)
- LAST_INPUT_QTY — decimal(13, 0)
- LAST_INPUT_WEIGHT — decimal(13, 2)
- PRV_LOCATION_CODE — nvarchar(30)
- LOCATION_CODE — nvarchar(30) — NOT NULL
- SECTION_CODE — nvarchar(30)
- PO_NO — nvarchar(30)
- WSEQ — decimal(8, 0)
- ITEM_GUBUN — nvarchar(4)
- UNIT_QTY — decimal(9, 0)
- PACKING_QTY — decimal(9, 0)
- ADD_QTY — decimal(9, 0)
- NOW_TICKET_NO — nvarchar(30)
- PARENT_BARCODE_NO — nvarchar(60)
- PALETTE_NO — nvarchar(30)
- USE_YN — char(1)
- USE_GUBUN — char(1)
- TICKET_USE_FLAG — char(1)
- WORK_DATE — nvarchar(8)
- REMARK_1 — nvarchar(max)
- EXTRA_GUBUN_1 — nvarchar(4)
- REG_DATETIME — nvarchar(14)
- REG_WORKER — nvarchar(30)
- MOD_DATETIME — nvarchar(14)
- MOD_WORKER — nvarchar(30)
- DEL_GUBUN — char(1)
- DEL_DATETIME — nvarchar(14)
- DEL_WORKER — nvarchar(30)
- BOX_NO — nvarchar(30) — NOT NULL
- BOX_WEIGHT — decimal(13, 2) — NOT NULL
- LOT_NO — nvarchar(30) — NOT NULL
- GRADE_CODE — nvarchar(4) — NOT NULL
- Remarks — nvarchar(120)
- REGISTDATETIME — nvarchar(30) — NOT NULL
- REGISTUSERID — nvarchar(30) — NOT NULL
- CHANGEDATETIME — nvarchar(30)
- CHANGEUSERID — nvarchar(30)
- CHANGECOMNAME — nvarchar(30)
- CHANGESCREENID — nvarchar(30)
- CHANGEIP — nvarchar(30)
ERPyMES_StockByDay
- ERPoMES — nvarchar(6) — Primary key — NOT NULL
- AppDate — nvarchar(30) — Primary key — NOT NULL
- item_code — nvarchar(60) — Primary key — NOT NULL
- LOCATION_CODE — nvarchar(30) — Primary key — NOT NULL
- REGISTDATETIME — nvarchar(30) — Primary key — NOT NULL
- item_name — nvarchar(60)
- ITEM_QTY — decimal(13, 0) — NOT NULL
- Other_qty — decimal(13, 0)
- Remarks — nvarchar(120)
- REGISTUSERID — nvarchar(30) — NOT NULL
- CHANGEDATETIME — nvarchar(30)
- CHANGEUSERID — nvarchar(30)
- CHANGECOMNAME — nvarchar(30)
- CHANGESCREENID — nvarchar(30)
- CHANGEIP — nvarchar(30)
MES_StockByDay
- ERPoMES — nvarchar(6) — Primary key — NOT NULL
- AppDate — nvarchar(30) — Primary key — NOT NULL
- item_code — nvarchar(60) — Primary key — NOT NULL
- LOCATION_CODE — nvarchar(30) — Primary key — NOT NULL
- REGISTDATETIME — nvarchar(30) — Primary key — NOT NULL
- LD — nvarchar(30) — Primary key — NOT NULL
- SC — nvarchar(30) — Primary key — NOT NULL
- item_name — nvarchar(60)
- ITEM_QTY — decimal(13, 0) — NOT NULL
- Remarks — nvarchar(120)
- REGISTUSERID — nvarchar(30) — NOT NULL
- CHANGEDATETIME — nvarchar(30)
- CHANGEUSERID — nvarchar(30)
- CHANGECOMNAME — nvarchar(30)
- CHANGESCREENID — nvarchar(30)
- CHANGEIP — nvarchar(30)
internet_speed_check
- Time — nvarchar(30) — Primary key — NOT NULL
- Site — nvarchar(30) — Primary key — NOT NULL
- Speed — nvarchar(60)
- Ratio — nvarchar(60)
- Connection — nvarchar(60) — NOT NULL
- REGISTDATETIME — nvarchar(30) — NOT NULL
- Remarks — nvarchar(120) — NOT NULL
- REGISTUSERID — nvarchar(30) — NOT NULL
- CHANGEDATETIME — nvarchar(30)
- CHANGEUSERID — nvarchar(30)
- CHANGECOMNAME — nvarchar(30)
- CHANGESCREENID — nvarchar(30)
- CHANGEIP — nvarchar(30)