CONNECT data services types supported by MES
- Last UpdatedAug 29, 2025
- 1 minute read
The following table lists the types in CONNECT data services supported by MES. The last two columns contain the supported actions for the types listed.
|
CONNECT data services Type Id |
MES Table |
Upserts |
Deletes |
|---|---|---|---|
|
Asset |
ent |
Yes |
Yes |
|
MESCustomer |
cust |
Yes |
Yes |
|
MESEquipmentUtilizationHistory |
util_history |
Yes |
Yes |
|
MESEquipmentUtilizationReason |
util_reas |
Yes |
Yes |
|
MESEquipmentUtilizationReasonGroup |
util_reas_grp |
Yes |
Yes |
|
MESEquipmentUtilizationState |
util_state |
Yes |
Yes |
|
MESJobHourlyResponse |
job_hour_history |
Yes |
No |
|
MESJobOrder |
job |
Yes |
Yes |
|
MESJobOrderRoute |
job_route |
Yes |
Yes |
|
MESJobOrderStateHistory |
job_event |
Yes |
No |
|
MESJobResponse |
job_history |
Yes |
No |
|
MESJobResponseState |
job_state |
Yes |
Yes |
|
MESLocation |
site |
Yes |
Yes |
|
MESMaterialClass |
item_class |
Yes |
Yes |
|
MESMaterialConsumedActual |
item_cons |
Yes |
Yes |
|
MESMaterialConsumedActualProperty |
job_event |
Yes |
No |
|
MESMaterialDefinition |
Item |
Yes |
Yes |
|
MESMaterialGrade |
item_grade |
Yes |
Yes |
|
MESMaterialInventory |
item_inv |
Yes |
Yes |
|
MESMaterialInventoryTransfer |
item_transfer |
Yes |
No |
|
MESMaterialLot |
lot |
Yes |
Yes |
|
MESMaterialLotStatus |
item_state |
Yes |
Yes |
|
MESMaterialOrderLine1 |
po_line_so_line |
Yes |
Yes |
|
MESMaterialOrderMovement2 |
receipt_lot_shipment_lot |
Yes |
Yes |
|
MESMaterialProducedActual |
item_prod |
Yes |
Yes |
|
MESMaterialProducedActualProperty |
job_event |
Yes |
No |
|
MESMaterialReason |
item_reas |
Yes |
Yes |
|
MESMaterialReasonGroup |
item_reas_grp |
Yes |
Yes |
|
MESMaterialSublot |
sublot |
Yes |
Yes |
|
MESOperationsMaterialBill |
job_bom |
Yes |
Yes |
|
MESPerson |
user_name |
Yes |
Yes |
|
MESShiftDefinition |
shift |
Yes |
Yes |
|
MESShiftHistory |
shift_history |
Yes |
No |
|
MESStorageLocationMovement |
storage_ent_transfer |
Yes |
Yes |
|
MESTrait |
ent |
Yes |
Yes |
|
MESUnitOfMeasureConversion |
uom_conv |
Yes |
Yes |
|
MESUnitOfMeasureDefinition |
uom |
Yes |
Yes |
|
MESWorkRequest |
wo |
Yes |
Yes |
1po_line_so_line pulls data from the tables po, po_line, so, so_line.
2receipt_lot_shipment_lot pulls data from the tables receipt, receipt_lot, shipment, shipment_lot.