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