Table access examples

Example 1

When accessing the Document table from the Interchange build map, the information retrieved will be from the last document processed through the Transaction Build map. If an import map updates a unique value to appfield6 for each document and the interchange build map tries to retrieve this information, and if all documents are sent in the same interchange, the only information retrieved in the Interchange Build map will be the information from appfield6 for the last document sent.

To retrieve the value in appfield6 for each document, the documents must be sent in their own interchange. This is set in the outbound partner relationship in the Interchange Definition under advanced settings (Set Max number of documents per interchange must be set to 1).

Example 2

When accessing the Group table from an Export map, the information retrieved will be from the last group processed through the Group Break map. If an inbound interchange file contained two groups: the first group contains 850 information and the second group contains 810 information, the rule in the 850 Export map will retrieve 810 information because the last group processed through the Group Break map was the 810 group.