ERP Export Service Tables

The ERP Export service publishes messages in a JSON and/or B2MML format to the following tables:
Events Table
  • mes.erp.outbound.messages.ClockOffEvent
  • mes.erp.outbound.messages.ClockOnEvent
 erp.erp_integration_outbound_laborVouchering_messages
  • mes.erp.outbound.messages.MaterialLotStatusChangedEvent (event generated when the status of a material lot is changed)
  • mes.erp.outbound.messages.OperationCompletedEvent
  • mes.erp.outbound.message.ProcessOrderCompletedEvent
  • mes.erp.outbound.message.ProcessOrderCreatedEvent
  • mes.erp.outbound.message.ProcessOrderDeletedEvent
  • mes.erp.outbound.message.ProcessOrderUpdatedEvent
  • mes.route.releasedRoutes.RouteReleasedEvent
 erp.erp_outbound_integration_standard_messages

The table contains the following columns:

ColumnDescription
Id The ID of the message.
Event_Type The type of the event.
MessageThe body of the message.
Inserted_By The user or system that sent the message.
Inserted_Date The date on which the message was initiated.
Message_Type The format of the message (application/xml or application/JSON).
The following optional fields allow the external integration to track the progress of the integration, and can also be used by support teams to troubleshoot any failed transactions through the integration.
Column Description
Process_Start_Date This property is null unless populated by a custom integration service. It can be used by any custom integration to set the start time when an external process begins accepting or processing this record.
Process_Completion_Date This property is null unless populated by a custom integration service. It can be used by any custom integration to set the completion time when an external process finishes accepting or processing this record.
Response_Code This property is null unless populated by a custom integration service. It can be used by any custom integration to set a response code about the status of the processing of the record.
Response_Message This property is null unless populated by a custom integration service. It can be used by any custom integration to set a response message about the detailed status of the processing of the record.