Using Information from Cross-Reference Tables

Cross-reference tables are used to convert your values to your trading partner's values during outbound processing, or your partner's values to your values during inbound processing. Each Partner Profile and the Internal System Partner Profile can have many lookup tables associated with it. For a screen entry translation object, the system displays a list which allows you to select the entry from the table. For a print translation object, the system prints the information on the report.

To use information from a cross-reference (XREF) table, you must have created that table already in the Sterling Gentran:Server® Partner Editor.

Use this procedure to load information from a Cross-Reference (XREF) Table into a screen entry or print translation object.

  1. Double-click the element to which the standard rule is applied.

    The system displays the Element Properties dialog box (Name tab).

  2. Click the Standard Rule tab.
  3. From the standard rule list, choose Select.
  4. From the table list, select the key from which the system performs the look up. For Cross-Reference Tables, valid selections are:
    • Partner cross-reference by my item
    • Partner cross-reference by partner
    • Division cross-reference by my item (activates Sub Table box)
    • Division cross-reference by partner item (activates Sub Table box)
  5. In the sub table box, type the name of the cross-reference table.
  6. To generate errors if the look up fails, select the compliance error check box.
  7. From the map from list, select the field (My Item, Partner Item, Description, Text 1, Text 2, Text 3, Text 4) from which the contents are mapped.
  8. From the map to list, select the element to which the information from the Partner Editor is mapped.
  9. Click OK to add the standard rule.