EDI Mapping Notes: Learn Useful Tips
The content of the data and the format of the data have to make sense to the mapper. If the mapper feels that the input or the output format of the data is unreasonable (e.g. too much unnecessary data) then the mapper should make the case for this concern and not simply map away with unreasonable data formats. This will help prevent troubleshooting and maintaining the map in the future, and should make the data conversion process more efficient.
While EDI mapping:
- Connect elements/segments at the same hierarchical level. For example, connect header level segments on the input side to the header level segments on the output side, detail to detail, and summary to summary.
- Connect elements/segments with the same data type. For example, map the numeric fields to numeric fields, dates to dates, strings to strings. Make the data type in both the input and output section the same whenever possible.
- Set the same maximum usage (loops) on the input and output side of the map.
- Create all segments/elements in the map that will be in the file. For example, if in the CSV file a certain column is not being used, map it anyway. Some translators require all the fields be mapped and this is a good practice for troubleshooting.
- Use standards when possible (ASC X12, EDIFCAT, RosettaNet etc).
EDI mapping is a very important process that requires profound EDI knowledge and expertise. Connecting elements and segments, creating loops for further transaction delivery, require understanding of partner guidelines and standards.
EDI Academy provides sufficient information regarding EDI Mapping at advanced sessions. Register for a webinar bundle and become an experienced certified EDI professional.