It is not uncommon to encounter situations where you need additional data that is not generally available either from your EDI application/interface (outbound) or from your trading partner (inbound).
Consider the situation where your trading partner sends purchase orders but omits the item descriptions…this item description being a necessary piece of information for processing the received orders. One option is to require that your trading partner includes this description for each item on the order – good luck trying to persuade a buyer to accommodate your request. Another option is to modify your application to eliminate this requirement – this may require a considerable amount of redevelopment.
The solution: Create an external table to host descriptions for each partner item that can be accessed during the translation process. Continue reading