WMS

Tables (42)

TABLE_AGV_REMAIN_QUANTITY

  • PLANT_CODE — int — Primary key — NOT NULL
  • PROCESS_CODE — int — Primary key — NOT NULL
  • WAREHOUSE_CODE — int — Primary key — NOT NULL
  • PALLET_CODE — int — Primary key — NOT NULL
  • QUANTITY — int

TABLE_BREAKDOWN_HISTORY

  • BREAKDOWN_HISTORY_ID — int — Primary key — NOT NULL
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • DEVICE_NAME — varchar
  • BREAKDOWN_OCCURRED_DATE — DateTime
  • BREAKDOWN_CLEAR_DATE — DateTime
  • BREAKDOWN_REASON — varcahr
  • MANAGER — varchar
  • BREAKDOWN_HISTORY_NOTE — varchar

TABLE_COMMON_CODE

  • TYPE — varchar
  • CODE — int
  • DETAIL — string

TABLE_CONNECT_HISOTRY

  • CONNECT_HISTORY_ID — int — Primary key — NOT NULL
  • USER_ID — varchar — Foreign key → TABLE_USER_MANAGEMENT.USER_ID — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_USER_MANAGEMENT.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_USER_MANAGEMENT.WAREHOUSE_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_USER_MANAGEMENT.PLANT_CODE
  • LOGIIN_STATUS — bool
  • DATE — DateTime
  • SYSTEM_TYPE — varchar

TABLE_ECS

  • INTERFACE_ID — int — Primary key — NOT NULL
  • INTERFACE_TYPE — varchar
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • ORDER — int
  • RFID — varchar
  • PALETE_CODE — int
  • QUANTITY — int
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int
  • JOB_NUMBER — int

TABLE_ECS_IN_WORK

  • WORK_ID — int — Primary key — NOT NULL
  • ORDER_ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PALLET_CODE — int
  • QUANTITY — int
  • RFID — varchar
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int
  • STATUS — varchar
  • JOB_NUMBER — int

TABLE_ECS_LOG

  • ID — int — Primary key — NOT NULL
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • DEVICE — varchar
  • MESSAGE — string
  • TIME — datetime

TABLE_ECS_MANUAL_JOB_HISTORY

  • ID — int — Primary key — NOT NULL
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • DEVICE — varchar
  • ORDER_TYPE — varchar
  • JOB_NUMBER — int
  • FROM — varchar
  • TO — int
  • TIME — datetime
  • MANAGER — varchar

TABLE_ECS_OUT_WORK

  • WORK_ID — int — Primary key — NOT NULL
  • ORDER_ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PALLET_CODE — int
  • QUANTITY — int
  • RFID — varchar
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int
  • STATUS — varchar
  • MODIFY_STATUS — int
  • JOB_NUMBER — int

TABLE_ECS_OUT_WORK_EX

  • WORK_ID — int — Primary key — NOT NULL
  • ORDER_ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • ORDER_TYPE — varchar
  • PALLET_CODE — int
  • QUANTITY — int
  • RFID — varchar
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int
  • STATUS — varchar
  • MODIFY_STATUS — int
  • JOB_NUMBER — int

TABLE_ECS_SC_SCHEDULE

  • ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PALLET_CODE — int
  • QUANTITY — int
  • RFID — varchar
  • ORDER_CMD — varchar
  • DONE — varchar
  • ORDER_TYPE — varchar
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int
  • MODIFY_STATUS — int
  • JOB_NUMBER — int
  • PALLET_TYPE — int

TABLE_INTERFACE_HISTORY

  • INTERFACE_HISTORY_ID — int — Primary key — NOT NULL
  • DATE — DateTime
  • INTERFACE_TYPE — varcahr
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • INTERFACE_FROM — varchar
  • INTERFACE_TO — varcahr
  • INTERFACE_NOTE — varchar

TABLE_INVENOTRY_INFORMATION

  • INVENTORY_CODE — int — Primary key — NOT NULL
  • INVENOTRY_REASON — varchar

TABLE_INVENTORY_HISTORY

  • INVENTORY_HISTORY_ID — int — Primary key — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • PALETE_CODE — int — Foreign key → TABLE_SKU.PALETE_CODE — NOT NULL
  • INVENTORY_CODE — int — Foreign key → TABLE_INVENOTRY_INFORMATION.INVENTORY_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PROCESS_CODE.PLANT_CODE
  • PRE_PALETE_CODE — int
  • RACK_TYPE — varchar
  • RFID — varchar
  • PRE_RFID — varc
  • ROW — int
  • PRE_ROW — int
  • BAY — int
  • PRE_BAY — int
  • LEVEL — int
  • PRE_LEVEL — int
  • MODIFY_DATE — DateTime
  • STORE_DATE — DateTime
  • EMBODIMENT_DATE — DateTime
  • INVENETORY_STATUS — boolean
  • PRE_INVENTORY_STATUS — boolean
  • QUANTITY — int
  • PRE_QUANTITY — int
  • MANAGER — varchar
  • INVENTORY_NOTE — varchar

TABLE_LOCATION

  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • LOCATION_ID — int
  • MAX_LOCATION_ID — int — Foreign key → TABLE_MAX_LOCATION.MAX_LOCATION_ID
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • RACK_TYPE — varchar
  • PALETE_CODES — varchar
  • ROW — int
  • BAY — int
  • LEVEL — int
  • MODIFY_USER_ID — varchar
  • PROHIBIT_IN_USE — boolean
  • PROHIBIT_OUT_USE — boolean
  • LOCATION_NOTE — varchar
  • SITE_ID — int
  • DISABLE — boolean
  • PALETE_CODE — int
  • RFID — varchar
  • MODIFY_DATE — DateTime
  • STORE_DATE — DateTime
  • EMBODIMENT_DATE — DateTime
  • INVENTORY_STATUS — boolean
  • QUANTITY — int
  • MANAGER — varchar
  • MODIFY_STATUS — boolean
  • LOCATION_STATUS — varchar
  • START_SEQ_NO — int

TABLE_MANUAL_COMMAND

  • MANUAL_COMMAND_ID — int
  • MANUAL_COMMAND_CONTENT — varchar
  • DATE — DateTime
  • MANAGER — varchar
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • SYSTEM_TYPE — varchar

TABLE_MAX_LOCATION

  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • MAX_LOCATION_ID — int
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • RACK_TYPE — varchar
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int

TABLE_MENU_CODE

  • Key — int — Primary key — NOT NULL
  • Field — varchar

TABLE_MES_SCHEDULE

  • MES_SCHEDULE_ID — int — Primary key — NOT NULL
  • ID_FLAG — varchar
  • SEQ — varchar
  • VIN_HEAD — varchar
  • VIN — varchar
  • VIN_TAIL — varchar
  • CAR_TYPE — varchar
  • SEATER — varchar
  • ENGINE — varchar
  • BODY_TYPE — varchar
  • ROOF — varchar
  • HANDLE — varchar
  • RSV1 — varchar
  • RSV2 — varchar
  • RSV3 — varchar
  • RSV4 — varchar
  • RSV5 — varchar
  • RSV6 — varchar
  • RSV7 — varchar
  • FL — varchar
  • SBW — varchar
  • ACTIVE — varchar
  • RSV8 — varchar
  • RSV9 — varchar
  • RSV10 — varchar
  • RSV11 — varchar
  • RSV12 — varchar
  • RSV13 — varchar
  • RSV14 — varchar
  • RSV15 — varchar
  • RSV16 — varchar
  • RSV17 — varchar
  • RSV18 — varchar
  • RSV19 — varchar
  • RSV20 — varchar
  • RSV21 — varchar
  • RSV22 — varchar
  • RSV23 — varchar
  • RSV24 — varchar
  • RSV25 — varchar
  • RSV26 — varchar
  • RSV27 — varchar
  • RSV28 — varchar
  • SPACE — varchar
  • CAR_TYPE_SYSTEM — varchar
  • BODY_NO — varchar

TABLE_MES_SCHEDULE_ACTIVE

  • MES_SCHEDULE_ID — int — Primary key — NOT NULL
  • CAR_TYPE — varchar
  • BODY_NO — varchar
  • ID_FLAG — varchar
  • SEQ — varchar
  • VIN_HEAD — varchar
  • VIN — varchar
  • VIN_TAIL — varchar
  • SEATER — varchar
  • ENGINE — varchar
  • BODY_TYPE — varchar
  • ROOF — varchar
  • HANDLE — varchar
  • RSV1 — varchar
  • RSV2 — varchar
  • RSV3 — varchar
  • RSV4 — varchar
  • RSV5 — varchar
  • RSV6 — varchar
  • RSV7 — varchar
  • FL — varchar
  • SBW — varchar
  • ACTIVE — varchar
  • RSV8 — varchar
  • RSV9 — varchar
  • RSV10 — varchar
  • RSV11 — varchar
  • RSV12 — varchar
  • RSV13 — varchar
  • RSV14 — varchar
  • RSV15 — varchar
  • RSV16 — varchar
  • RSV17 — varchar
  • RSV18 — varchar
  • RSV19 — varchar
  • RSV20 — varchar
  • RSV21 — varchar
  • RSV22 — varchar
  • RSV23 — varchar
  • RSV24 — varchar
  • RSV25 — varchar
  • RSV26 — varchar
  • RSV27 — varchar
  • RSV28 — varchar
  • SPACE — varchar
  • CAR_TYPE_SYSTEM — varchar

TABLE_MES_SCHEDULE_COMPLETE

  • CAR_TYPE — varchar
  • BODY_NO — varchar
  • DATE — datetime — NOT NULL
  • ID_FLAG — varchar
  • SEQ — varchar
  • VIN_HEAD — varchar
  • VIN — varchar
  • VIN_TAIL — varchar
  • SEATER — varchar
  • ENGINE — varchar
  • BODY_TYPE — varchar
  • ROOF — varchar
  • HANDLE — varchar
  • RSV1 — varchar
  • RSV2 — varchar
  • RSV3 — varchar
  • RSV4 — varchar
  • RSV5 — varchar
  • RSV6 — varchar
  • RSV7 — varchar
  • FL — varchar
  • SBW — varchar
  • ACTIVE — varchar
  • RSV8 — varchar
  • RSV9 — varchar
  • RSV10 — varchar
  • RSV11 — varchar
  • RSV12 — varchar
  • RSV13 — varchar
  • RSV14 — varchar
  • RSV15 — varchar
  • RSV16 — varchar
  • RSV17 — varchar
  • RSV18 — varchar
  • RSV19 — varchar
  • RSV20 — varchar
  • RSV21 — varchar
  • RSV22 — varchar
  • RSV23 — varchar
  • RSV24 — varchar
  • RSV25 — varchar
  • RSV26 — varchar
  • RSV27 — varchar
  • RSV28 — varchar
  • SPACE — varchar
  • CAR_TYPE_SYSTEM — varchar

TABLE_MES_SCHEDULE_PARJ_LIST_COMPLETE

  • DATE — datetime
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PALLET_CODE — int
  • SEQ — varchar
  • BODY_NO — varchar
  • CAR_TYPE — varchar

TABLE_MES_SCHEDULE_PART_LIST

  • MES_SCHEDULE_ID — int — Primary key — NOT NULL
  • PALLET_CODE — int
  • BODY_NO — varchar
  • CAR_TYPE — varchar
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • SEQ — varchar
  • RELEASE_ORDER — int
  • STORE_ORDER — int
  • STATUS — varchar

TABLE_PALLET_TYPE

  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PALLET_TYPE — int
  • SIZE — int

TABLE_PLANT_CODE

  • PLANT_CODE — int
  • FACTORY_NAME — varchar

TABLE_PROCESS_CODE

  • PROCESS_CODE — int — Primary key — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • PROCESS_NAME — varchar

TABLE_RELEASE_HISTORY

  • RELEASE_HISTORY_ID — int — Primary key — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • PALETE_CODE — int — Foreign key → TABLE_SKU.PALETE_CODE — NOT NULL
  • RELEASE_CODE — int — Foreign key → TABLE_RELEASE_INFORMATION.RELEASE_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • RFID — varchar
  • ROW — int
  • BAY — iunt
  • LEVEL — int
  • MODIFY_DATE — DateTime
  • RELEASE_DATE — DateTime
  • COUNT — int
  • MANAGER — varchar
  • RELEASE_HISOTRY_NOTE — varchar
  • JOB_NUMBER — int

TABLE_RELEASE_INFORMATION

  • RELEASE_CODE — int — Primary key — NOT NULL
  • RELEASE_REASON — varchar

TABLE_RELEASE_RULE

  • RELEASE_RULE_ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int — NOT NULL
  • RELEASE_RULE_SORT — varchar
  • MANAGER — varchar
  • CREATED_DATE — Datetime

TABLE_RELEASE_RULE_DETAIL

  • RELEASE_RULE_DETAIL_ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int — NOT NULL
  • DETAIL — varchar
  • ENABLE — Boolean
  • SORT_NO — int
  • SORT — varchar

TABLE_RELEASE_SCHEDULE

  • RELEASE_SCHEDULE_ID — int — Primary key — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • PALETE_CODE — int — Foreign key → TABLE_SKU.PALETE_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • RFID — varchar
  • ORDER — int
  • MANAGER — varchar
  • ORDER_STATUS — int
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int

TABLE_RELEASE_SCHEDULE_MANUAL

  • RELEASE_SCHEDULE_ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PALLET_CODE — int
  • RFID — varchar
  • ORDER — int
  • MANAGER — varchar
  • ORDER_STATUS — int
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADINNG_NUMBER — int

TABLE_SKU

  • PALETE_CODE — int — Primary key — NOT NULL
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PART_NAME — varchar
  • STORAGE_DAYS — int
  • MAX_STORAGE_COUNT — int
  • MES_WAITING_NUMBER — int
  • RESTORE_QUANTITY — int
  • CAR_TYPE — varchar
  • SEATER — varchar
  • ENGINE — varchar
  • BODY_TYPE — varchar
  • ROOF — varchar
  • HANDLE — varchar
  • RSV1 — varchar
  • RSV2 — varchar
  • RSV3 — varchar
  • RSV4 — varchar
  • RSV5 — varchar
  • RSV6 — varchar
  • RSV7 — varchar
  • FL — varchar
  • SBW — varchar
  • ACTIVE — varchar
  • RSV8 — varchar
  • RSV9 — varchar
  • RSV10 — varchar
  • RSV11 — varchar
  • RSV12 — varchar
  • RSV13 — varchar
  • RSV14 — varchar
  • RSV15 — varchar
  • RSV16 — varchar
  • RSV17 — varchar
  • RSV18 — varchar
  • RSV19 — varchar
  • RSV20 — varchar
  • RSV21 — varchar
  • RSV22 — varchar
  • RSV23 — varchar
  • RSV24 — varchar
  • RSV25 — varchar
  • RSV26 — varchar
  • RSV27 — varchar
  • RSV28 — varchar
  • SPACE — varchar
  • LOADING_START_NO — varchar
  • LOADING_END_NO — varchar
  • UNLOADING_START_NO — varchar
  • UNLOADING_END_NO — varchar
  • PALLET_TYPE — varchar

TABLE_STOER_SCHEDULE_MANUAL

  • STORE_ID — int
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • PALLET_CODE — int
  • RFID — varchar
  • ORDER — int
  • MANAGER — string
  • ORDER_STATUS — int
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int

TABLE_STORE_HISOTRY

  • STORE_HISOTRY_ID — int — Primary key — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • PALETE_CODE — int — Foreign key → TABLE_SKU.PALETE_CODE — NOT NULL
  • STORE_CODE — int — Foreign key → TABLE_STORE_INFORMATION.STORE_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • RFID — varchar
  • ROW — int
  • BAY — iunt
  • LEVEL — int
  • MODIFY_DATE — DateTime
  • STORE_DATE — DateTime
  • QUANTITY — int
  • MANAGER — varchar
  • STORE_HISOTRY_NOTE — varchar
  • JOB_NUMBER — int

TABLE_STORE_INFORMATION

  • STORE_CODE — int — Primary key — NOT NULL
  • STORE_REASON — varchar

TABLE_STORE_SCHEDULE

  • STORE_ID — int — Primary key — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • PALETE_CODE — int — Foreign key → TABLE_SKU.PALETE_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • ORDER — int
  • MANAGER — varchar
  • ORDER_STATUS — int
  • START_ROW — int
  • START_BAY — int
  • START_LEVEL — int
  • END_ROW — int
  • END_BAY — int
  • END_LEVEL — int
  • LOADING_NUMBER — int
  • UNLOADING_NUMBER — int

TABLE_USER_MANAGEMENT

  • USER_ID — varchar — Primary key — NOT NULL
  • Key — int — Foreign key → TABLE_MENU_CODE.Key — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • WAREHOUSE_CODE — int — Foreign key → TABLE_WAREHOUSE_CODE.WAREHOUSE_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PLANT_CODE.PLANT_CODE
  • PASSWORD — varchar
  • LOGOUT_TIME — DateTime
  • LEVEL — int
  • LOGIN_STATUS — bool
  • CURRENT_PAGE — varchar
  • SYSTEM_TYPE — varchar

TABLE_WAREHOUSE_CODE

  • WAREHOUSE_CODE — int — Primary key — NOT NULL
  • PROCESS_CODE — int — Foreign key → TABLE_PROCESS_CODE.PROCESS_CODE — NOT NULL
  • PLANT_CODE — int — Foreign key → TABLE_PROCESS_CODE.PLANT_CODE
  • WAREHOUSE_NAME — varchar
  • WAREHOUSE_TYPE — varchar

TABLE_WMS

  • INTERFACE_ID — int — Primary key — NOT NULL
  • INTERFACE_TYPE — varchar
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • ORDER — int
  • RFID — varchar
  • PALETE_CODE — int
  • QUANTITY — int

TABLE_WMS_INTERFACE_PROCESSING

  • INTERFACE_ID — int — Primary key — NOT NULL
  • INTERFACE_TYPE — varchar

TABLE_WMS_LOG

  • ID — int — Primary key — NOT NULL
  • TIME — datetime
  • PLANT_CODE — int
  • PROCESS_CODE — int
  • WAREHOUSE_CODE — int
  • MESSAGE — string