Sample Files for a Process Order
Message that Contains a Process Order
Inbound messages are added to the integration database using Microsoft SQL.
Message that Contains a Process Order
INSERT INTO erp_integration_inbound_messages (Message_Type, Media_Type, Message, Inserted_By)
VALUES ('processOrder', 'application/json', '{POID}', '<user name>')
where {POID} is a JSON document that specifies the process order.
Process Order Import Document
A JSON process order import document (POID) contains all the details of a process order, including route and revision or segment definition. The POID constitutes the body of the HTTP POST request of the ERP Import service, which posts the process order to Plant Applications.
POID
{
"schemaVersion": 1,
"plannedQuantity": 10,
"plannedLineName": "Line1",
"producedMaterialName": "weebles1",
"processOrderName": "PO_AUTO_Json_1172",
"bomFormulation": "Bomformulation1",
"plannedStartDate": "2017-04-08T09:22:17.825Z",
"plannedEndDate": "2019-04-08T09:22:17.825Z"
}B2MML File that Contains a Process Order
Instead of a JSON process order import document (POID), you can send all the details of a work order, process order, or material in a B2MML file.
If you want to send a B2MML document, you must also provide an XSL file with the mapping details. The ERP Transformation service uses this XSL file to convert the B2MML document to a JSON file.
Note: When an XML file is processed, some of the special characters are omitted. To prevent this issue, use the escape strings as specified in the following table.
| Special Character | Escape String |
|---|---|
| & | & |
| < | < |
| > | > |
| “ | " |
| ‘ | ' |
B2MML File that Contains a Process Order
<?xml version="1.0" encoding="UTF-8"?>
<ProductionSchedule><ID>0000000112841171</ID><Location><EquipmentID>0288</EquipmentID><EquipmentElementLevel>Site</EquipmentElementLevel><Location><EquipmentID>193</EquipmentID><EquipmentElementLevel>Area</EquipmentElementLevel></Location></Location><ProductionRequest><ID>000900826215</ID><ProductProductionRuleID>0501</ProductProductionRuleID><StartTime>2005-02-25T21:50:58</StartTime><EndTime>2005-02-26T00:00:00</EndTime><SegmentRequirement><ID>1</ID><EarliestStartTime>2005-02-25T21:50:58</EarliestStartTime><LatestEndTime>2005-02-26T00:00:00</LatestEndTime><EquipmentRequirement><EquipmentID>GGMB05</EquipmentID></EquipmentRequirement><MaterialProducedRequirement><MaterialDefinitionID>000000000095052698</MaterialDefinitionID><MaterialLotID>0000429633</MaterialLotID><Description>COM PST MILDMINT 3 STRIPE -WHT BLUE SPEC</Description><Location><EquipmentID>0288</EquipmentID><EquipmentElementLevel>Site</EquipmentElementLevel><Location><EquipmentID>LDFM</EquipmentID><EquipmentElementLevel>StorageZone</EquipmentElementLevel></Location></Location><Quantity><QuantityString>3000</QuantityString><DataType>float</DataType><UnitOfMeasure>KG</UnitOfMeasure></Quantity><Quantity><QuantityString>3000</QuantityString><DataType>float</DataType><UnitOfMeasure>KG</UnitOfMeasure></Quantity><MaterialProducedRequirementProperty/><MaterialProducedRequirementProperty><ID>InspectionLotID</ID><Description/><Value><ValueString>000000000000</ValueString><DataType>string</DataType></Value><Quantity/></MaterialProducedRequirementProperty></MaterialProducedRequirement><MaterialConsumedRequirement><MaterialDefinitionID>000000000011100613</MaterialDefinitionID><Description>CARBOMER 956</Description><Location><EquipmentID>0288</EquipmentID><EquipmentElementLevel>Site</EquipmentElementLevel><Location><EquipmentID>0088</EquipmentID><EquipmentElementLevel>StorageZone</EquipmentElementLevel></Location></Location><Quantity><QuantityString>1.500</QuantityString><DataType>float</DataType><UnitOfMeasure>KG</UnitOfMeasure></Quantity><MaterialConsumedRequirementProperty><ID>MaterialReservationID</ID><Description/><Value><ValueString>0033739080</ValueString><DataType>string</DataType></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty><ID>MaterialReservationSequence</ID><Description/><Value><ValueString>0016</ValueString><DataType>string</DataType></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty><ID>ScrapPercent</ID><Description/><Value><ValueString>0.00</ValueString><DataType>float</DataType><UnitOfMeasure>percent</UnitOfMeasure></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty/><MaterialConsumedRequirementProperty/><MaterialConsumedRequirementProperty/></MaterialConsumedRequirement><MaterialConsumedRequirement><MaterialDefinitionID>000000000011614647</MaterialDefinitionID><Description>TRICLOSAN 50% SOLUTION</Description><Location><EquipmentID>0288</EquipmentID><EquipmentElementLevel>Site</EquipmentElementLevel><Location><EquipmentID>0088</EquipmentID><EquipmentElementLevel>StorageZone</EquipmentElementLevel></Location></Location><Quantity><QuantityString>16.800</QuantityString><DataType>float</DataType><UnitOfMeasure>KG</UnitOfMeasure></Quantity><MaterialConsumedRequirementProperty><ID>MaterialReservationID</ID><Description/><Value><ValueString>0033739080</ValueString><DataType>string</DataType></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty><ID>MaterialReservationSequence</ID><Description/><Value><ValueString>0015</ValueString><DataType>string</DataType></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty><ID>ScrapPercent</ID><Description/><Value><ValueString>0.00</ValueString><DataType>float</DataType><UnitOfMeasure>percent</UnitOfMeasure></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty/><MaterialConsumedRequirementProperty/><MaterialConsumedRequirementProperty/></MaterialConsumedRequirement><MaterialConsumedRequirement><MaterialDefinitionID>000000000011614523</MaterialDefinitionID><Description>BFG 51 HYDRATED SILICA & CI 74160</Description><Location><EquipmentID>0288</EquipmentID><EquipmentElementLevel>Site</EquipmentElementLevel><Location><EquipmentID>0088</EquipmentID><EquipmentElementLevel>StorageZone</EquipmentElementLevel></Location></Location><Quantity><QuantityString>6.750</QuantityString><DataType>float</DataType><UnitOfMeasure>KG</UnitOfMeasure></Quantity><MaterialConsumedRequirementProperty><ID>MaterialReservationID</ID><Description/><Value><ValueString>0033739080</ValueString><DataType>string</DataType></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty><ID>MaterialReservationSequence</ID><Description/><Value><ValueString>0014</ValueString><DataType>string</DataType></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty><ID>ScrapPercent</ID><Description/><Value><ValueString>0.00</ValueString><DataType>float</DataType><UnitOfMeasure>percent</UnitOfMeasure></Value><Quantity/></MaterialConsumedRequirementProperty><MaterialConsumedRequirementProperty/><MaterialConsumedRequirementProperty/><MaterialConsumedRequirementProperty/></MaterialConsumedRequirement></SegmentRequirement></ProductionRequest></ProductionSchedule>
XSL File to Map a Process Order
This topic provides a sample XSL file that is used to map a process order.
XSL File to Map a Process Order
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"><xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/><xsl:strip-space elements="*"/><xsl:template match="ProductionSchedule"><ProductionSchedule><ProductionRequest><xsl:variable select="ProductionRequest" name="ProductionRequest"/><xsl:variable select="Location" name="ProductionRequestLocation"/><xsl:variable select="$ProductionRequest/SegmentRequirement" name="SegmentRequirement"/><ID><xsl:value-of select="$ProductionRequest/ID"/></ID><ProductProductionRuleID><xsl:value-of select="$ProductionRequest/ProductProductionRuleID"/></ProductProductionRuleID><Location><EquipmentID><xsl:value-of select="$SegmentRequirement[ID = 1]/EquipmentRequirement/EquipmentID"/></EquipmentID><EquipmentElementLevel><xsl:value-of select="$ProductionRequestLocation/EquipmentElementLevel"/></EquipmentElementLevel></Location><Priority>0</Priority><SegmentRequirement><ID><xsl:value-of select="ID"/></ID><xsl:if test="$SegmentRequirement/EarliestStartTime"><EarliestStartTime><xsl:value-of select="$SegmentRequirement/EarliestStartTime"/></EarliestStartTime></xsl:if><xsl:if test="$SegmentRequirement/LatestEndTime"><LatestEndTime><xsl:value-of select="$SegmentRequirement/LatestEndTime"/></LatestEndTime></xsl:if><EquipmentRequirement><EquipmentID><xsl:value-of select="$SegmentRequirement/EquipmentRequirement/EquipmentID"/></EquipmentID></EquipmentRequirement><MaterialProducedRequirement><xsl:variable select="$SegmentRequirement/MaterialProducedRequirement" name="MaterialProducedRequirement"/><xsl:variable select="$SegmentRequirement/MaterialProducedRequirement/Quantity" name="Quantity"/><xsl:variable select="$MaterialProducedRequirement/MaterialProducedRequirementProperty" name="MaterialProducedRequirementProperty"/><MaterialDefinitionID><xsl:value-of select="$MaterialProducedRequirement/MaterialDefinitionID"/></MaterialDefinitionID><Quantity><QuantityString><xsl:value-of select="$Quantity/QuantityString"/></QuantityString><DataType><xsl:value-of select="$Quantity/DataType"/></DataType><UnitOfMeasure><xsl:value-of select="$Quantity/UnitOfMeasure"/></UnitOfMeasure></Quantity></MaterialProducedRequirement><xsl:for-each select="$SegmentRequirement/MaterialConsumedRequirement"><MaterialConsumedRequirement><xsl:variable select="$SegmentRequirement/MaterialConsumedRequirement" name="MaterialConsumedRequirement"/><xsl:variable select="$MaterialConsumedRequirement/Quantity" name="Quantity"/><xsl:variable select="$MaterialConsumedRequirement/MaterialConsumedRequirementProperty" name="MaterialConsumedRequirementProperty"/><MaterialDefinitionID><xsl:value-of select="$MaterialConsumedRequirement/MaterialDefinitionID"/></MaterialDefinitionID><Quantity><QuantityString><xsl:value-of select="$Quantity/QuantityString"/></QuantityString><DataType><xsl:value-of select="$Quantity/DataType"/></DataType><UnitOfMeasure><xsl:value-of select="$Quantity/UnitOfMeasure"/></UnitOfMeasure></Quantity></MaterialConsumedRequirement></xsl:for-each></SegmentRequirement></ProductionRequest></ProductionSchedule></xsl:template></xsl:stylesheet>
Standard B2MML File for a Process Order
This topic provides an example of a standard B2MML file that contains the details of a process order.
Standard B2MML File for a Proces Order
<?xml version="1.0"?>
<ProductionSchedule><ProductionRequest><ID>1680481</ID><ProductProductionRuleID>B101</ProductProductionRuleID><Location><EquipmentID>ZXBD</EquipmentID><EquipmentElementLevel>Site</EquipmentElementLevel></Location><Priority>0</Priority><SegmentRequirement><ID>224392962</ID><EarliestStartTime>2007-10-03T07:20:00</EarliestStartTime><LatestEndTime>2007-10-04T00:00:00</LatestEndTime><EquipmentRequirement><EquipmentID>ZXBD</EquipmentID></EquipmentRequirement><MaterialProducedRequirement><MaterialDefinitionID>15886327</MaterialDefinitionID><Quantity><QuantityString>5000.000</QuantityString><DataType>float</DataType><UnitOfMeasure>KG</UnitOfMeasure></Quantity></MaterialProducedRequirement><MaterialConsumedRequirement><MaterialDefinitionID>10000001</MaterialDefinitionID><Quantity><QuantityString>3000.000</QuantityString><DataType>float</DataType><UnitOfMeasure>KG</UnitOfMeasure></Quantity></MaterialConsumedRequirement></SegmentRequirement></ProductionRequest></ProductionSchedule>