Supply chain collaborationEDI mapping Meet embedded SpicY™ AI

SPICE™ Glossary / EDI mapping

EDI mapping

EDI mapping is the set of rules that links each field in an EDI document to a field in another format, such as your ERP's, so data translates automatically.

A map tells translation software where to find each piece of data and where to put it. The purchase order number in the BEG segment of an 850 becomes the order number in your ERP; the item and quantity in each PO1 segment become order lines. Maps also convert codes, units of measure and date formats, apply defaults and handle repeating groups such as multiple ship-to locations.

EDI translation is the process that runs the map: it reads an inbound ANSI X12 or EDIFACT file, checks its syntax and produces the target format, or does the reverse for outbound documents. Mapping is the design work; translation is the execution. A mapping specification documents the rules, usually based on each trading partner’s implementation guide.

Mapping is where much of the cost of EDI sits. Each trading partner’s version of a transaction set can differ, so companies often maintain many maps for the same document. When a trading partner changes its requirements or you change ERPs, maps must be updated and retested. A map can also produce a perfectly valid file with the wrong data, which is why testing and certification matter.

How SPICE™ handles it

SPICE™ translates each transaction into the structure the receiving system expects, then validates it against your master data, the original order and your business rules, so problems become exceptions instead of errors in your ERP. See process orchestration. With SPICE Connect™, the SPICE™ team designs and builds the maps and interfaces to your ERP, WMS and TMS, and keeps them current as trading partners change.

FAQ

Frequently asked questions

What is the difference between EDI mapping and EDI translation?

Mapping defines the rules for how fields in one format correspond to fields in another. Translation is the software process that applies those rules to each document. You build a map once, and translation runs it every time a document arrives or leaves.

Why do I need different maps for different trading partners?

Trading partners use different versions of the standards and publish their own implementation guides with specific segments, codes and rules. A map built for one trading partner's purchase order may not work for another's. Standardizing where you can reduces the number of maps to maintain.