ERP Integration Database Schema

The ERP Integration database stores messages that specify work orders, process orders, and materials. Messages are stored in the erp_integration_inbound_messages table until they are imported into the Plant Applications database. The following table describes the columns in the erp_integration_inbound_messages table.

Column	Description
Id	A system-generated identity value.
Message_Type	The identifier for the type of the record. This column contains one of the following values: workOrder processOrder material materialLot
Media_Type	The MIME type of the message. This column contains one of the following values: application/json application/xml
Key_Data	The information added by the ERP Scheduler service when the record is processed (for example, work order number). The data can be used by system administrators for internal purposes, such as to query how many times the order number has been sent for import.
Inserted_Date	The date and time (in UTC format) when the ERP system added the record to the table.
Process_Start_Date	The date and time (in UTC format) when the ERP Scheduler service started processing the message.
Process_Complete_Date	The date and time (in UTC format) when the ERP Scheduler service completed processing the message.
Response_Code	The HTTP response code from the import process.
Response_Message	The message that contains information about whether the import has been successful.
Message	The record that contains the details of the work order, process order, or material in a JSON, B2MML, or XML format. If the message is in the JSON format, this column contains one of the following files: work order import document (WOID) process order import document (POID) material master import document (MMID)
Inserted_By	The user who created the record.