Navigating the Portal
      Back to home
      1. Knowledge Base
      2. The Partner Portal
      3. Navigating the Portal

      The Cross-References Page

      This page hosts the Cross Reference Tables that allow you to transform consistently occurring words or phrases (input) into a preferred words or phrases (output).

      To view your cross reference tables, click View Cross-Reference Table from the left side of the second section of the Customer Details Page. 

      29e Picture1 (2)

      When you go to the Cross Reference Screen, you will notice a number of features. Those without names are listed in the table with numbers that correspond to those in the image:

      153 Cross Ref 1a (1)

       
      1. Name of cross-reference table. Click to select from the drop-down menu of existing tables. 
      2. Edit icon. Click to make changes to individual factors on individual rows. 
      3. Delete icon. Click to delete a specific row in the table. 
      4. Copy row (plus +) icon. Click to create a copy of a specific row. 
      5. Search field. Enter letters to find a pre-existing table. 
      6. Download icon. Click to export the table to a CSV file for use in a spreadsheet. 
      7. Filter icon. Click to display the Filter dialog box for ease in browsing pre-existing tables. 
      8. Add row (plus +) icon. Click to create a new row. 

      Cross-Reference tables can be applied at the Global Level (impacts all trading partners) or at the Individual Level (impacts a single trading partner). 

      At their most basic level, cross references allow you to transform individual terms. That is, when you want every occurrence of a specific term (input) to be consistently expressed as if it was a different specific term (output), you can set up that relationship as a cross reference.

      For example, you can create a table entry that directs the input “Part Number A” to always be output as “Part Number B”; or “ABC123” as “DEF567.”

      However, cross references can also perform other functions. Among other things, with them you can convert Part Numbers, units of measure, quantities, or names; you can compare a price against a pricing list or a set pricing; or you can use address lookups to find Ship To, Bill To, or Remit to IDs, to name only some examples.

      114 fix 1

      In the image above, the cross-references are simple abbreviations:

      • The Input “Package” is produced as the Output “PKG”

      • The Input “Dozen” is produced as the Output “DZ”

      • The Input “Case” is produced as the Output “CS”

      • The Input “Each” is produced as the Output “EA”

      Each table can be very different. In next example, a new cross reference table is shown in development. The input of “Document UOM” is transformed to the output “ERP UOM” so that the unit of measure that the trading partner document that were originally used can be expressed in a way that is acceptable to the customer’s ERP.

      115 Picture1

      You can view and manage your cross-reference tables through the Partner Portal. If you have permissions, you can add, edit, or delete entries. However, in designing and creating cross reference tables, work with your Conexiom representative, because strict parameters and limits can apply.

      To learn more about creating, modifying and other actions associated with cross-reference tables, follow the links below:

      • Basic Cross-Reference Table Actions
      • Creating a New Cross-Reference Table
      • Working with Cross Reference Tables