This section provides instructions specific to EDI transaction maps.
Adding a new cross-reference
table
Launch ECMap and select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.
On the Cross Reference Tables window, select File > New from the menu. The New Cross Reference Table window displays.
The program automatically populates the Project and Map text boxes.
In the File Name text box, type the name of the new cross-reference table, using 8 characters or fewer. This field is required.
In the Standard Field Number group, select one of the following options listed in Steps 4a and 4b:
Select the No Field Number option if you are creating a cross-reference table that does not use EDI values. Type the following required information in the appropriate text boxes:
Type a value in the Standard Field Length text box. This value is the source field length in an inbound map and the destination field length in an outbound map.
Type a value in Application Field Length text box. This value is the destination field length in an inbound map and the source field length in an outbound map.
The maximum field length of a cross-reference table entry is 100 characters. If an application field length is greater than 100 characters, you receive the following warning:
Standard Field Length Must Be <=100
Select the Select Field Number option if you are creating a cross-reference table that uses EDI values. When you select this option, the Select Element for Cross Reference window displays.
On the Select Element for Cross Reference window, highlight the line containing the element you want to add to the cross-reference table and click OK.
If there are values associated with the element, ECMap inserts them into the Standard Field Length, Application Field Length, and Field Number text boxes.
Type the File Name.
In the Description text box, optionally type a brief description of the EDI data that is associated with the EDI element number or a brief description of the data elements being cross-referenced in the table.
Click Create.
If you are missing the file name or if a field length exceeds 100, you get an error message.
Correct errors and click Create again.
If you have no errors, ECMap creates the cross-reference table, and the Cross Reference Table Properties window displays.
You have now created and defined a cross-reference table, but you have not yet created the entries in the table. You can enter the values for the entries in the cross-reference table now, or you can enter them later. See “Modifying an entry in a cross-reference table”.
For EDI elements with an ID data type, ECMap has the capability to automatically create the entries in a cross-reference table. You must be in the Mapping window to use this feature. Refer to Chapter 13, “Mapping” for detailed instructions.
Deleting a cross-reference
table
On the Cross Reference Tables window, select Edit > Delete from the menu.
The program asks you to confirm that you want to delete the table (file) before it actually removes it.
Click Yes to remove and Cancel to exit the dialog box.
WARNING! If you accidentally remove a table, you must create it again.
Finding a cross-reference
table
On the Cross Reference Table window, select Edit > Find or Find Next from the menu. The Find window displays.
In the Search String text box, type a character string and click Find.
Each time the program finds the character string, click Find Next to search for the next occurrence of the string.
Displaying unreferenced
cross-reference tables
Cross-reference tables are often kept in a common directory where multiple maps can access them. This practice saves mappers the unnecessary work of recreating cross-reference tables and entries. If all cross-reference tables are stored in a common directory, the Directory Scan utility lets mappers view all of the cross-reference tables in the cross-reference directory (for example, the common directory) that the current map is not using. Mappers can then select any of these unreferenced (currently unused) cross-referenced tables and have ECMap automatically define the selected cross-reference tables in the current map.
Unreferenced tables can also occur accidentally when
You use a common directory for all cross-reference tables
You copy maps from one directory to another without using the Copy Map utility
You move files for a particular cross-reference table from one map to another
In these cases, the mxref table for the project/map is not updated, leaving the tables undefined in the map. Follow the steps in the next procedure to display all cross-reference tables in the current map directory that are not linked to an element or rule.
On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.
On the Cross Reference Tables window, select File > Directory Scan from the menu.
If there are no unused cross-reference tables, you receive a message telling you that no unreferenced cross-reference tables were found in the map directory.
If there are unused tables, the Cross Reference Directory Tables window displays.
To have ECMap automatically define a cross-reference table in the current map, highlight the table on the Cross Reference Directory Tables window and click OK.
You can select multiple tables, using the Shift and Ctrl keys:
To select multiple contiguous tables, click to select the first table, press Shift, and click the last table in the list. The entire group of tables is highlighted.
To select non-contiguous tables, click to select the first table, press Ctrl, select the next table, press Ctrl, and so on, until you have highlighted all the tables you want to select.
The selected table or tables are defined and you return to the Cross Reference Tables window.
Adding entries to a cross-reference
table
On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.
On the Cross Reference Table window, highlight a table, right-click it and and select Properties from the submenu. The Cross Reference Table Properties window displays.
If this is an existing cross-reference table, there is a list of all the entries in the highlighted table. If this is a new table, there are no entries.
On the Cross Reference Table Properties window, select File > New from the menu. The New Cross Reference Entries window displays.
In the Table text box, ECMap inserts the name of the current cross-reference table. You cannot change this value; however, you must type entries in the remaining text boxes:
In the EDI Value text box, type a valid EDI code from the code list for the standard used in the current map. For transaction maps, this value is the EDI side of the EDI/application code conversion performed by the cross-reference table. For non-EDI conversions, this is the source or input value.
In the Application Value text box, type the value that corresponds to the EDI value. For transaction maps, this value is the application side of the EDI/application code conversion performed by the cross-reference table. For non-EDI code conversions, this is the destination or output value.
In the Description text box, type a brief description of this entry in the cross-reference table. This is a required field.
Click Next to add another cross-reference entry or OK to return to the Cross Reference Table Properties window. The new entries display in the list of table entries.
Modifying an entry in a
cross-reference table
On ECMap’s main window, select Tools > Cross Reference Tables form the menu. The Cross Reference Tables window displays.
In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.
In the Cross Reference Table Properties window, right-click a table entry and select Properties from the submenu.The Cross Reference Entry Properties window displays.
In the Table text box, ECMap inserts the name of the current cross-reference table. You cannot change this value; however, you will edit the remaining text boxes:
In the EDI Value text box, type a valid EDI code from the code list for the standard used in the current map. For transaction maps, this value is the EDI side of the EDI/application code conversion performed by the cross-reference table. For non-EDI conversions, this is the source or input value.
In the Application Value text box, type the value that corresponds to the EDI value. For transaction maps, this value is the application side of the EDI/application code conversion performed by the cross-reference table. For non-EDI code conversions, this is the destination or output value.
In the Description text box, type a brief description of this entry in the cross-reference table. This is a required field.
Click Next to edit another entry or select OK to return to the Cross Reference Table Properties window.
Deleting an entry in a
cross-reference table
On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.
In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.
Right-click a table entry and select Delete from submenu. The program asks you to confirm your decision before the entry is permanently removed.
WARNING! If you delete an entry in a cross-reference table by mistake, you must re-enter it as a new entry.
Click Yes to delete the table or No to return to the Cross Reference Table Properties window.
Finding an entry in a cross-reference
table
On ECMap’s main window, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.
In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.
On the Cross Reference Table Properties window, select Edit > Find from the menu. The Find window displays.
In the Search String text box, type the character string you want the program to search for and slick Find. Each time the program finds the character string, you can click Find Next to search for the next occurrence of the string.
Populating the fields in
a cross-reference table
To quickly create a cross-reference table, you can automatically populate blank application fields in a cross-reference table entry - with either the description or the EDI code value.
On ECMap’s main menu, select Tools > Cross Reference Tables from the menu. The Cross Reference Tables window displays.
In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.
In the Cross Reference Table Properties window, select Options > Fill Fields From Description or Fill Fields From EDI Value.
Select Description and ECMap populates any blank cross application fields in the Cross Reference column with values from the Description column.
Select EDI Value and ECMap populates any blank application fields in the Cross Reference column with values from the EDI Field Value column.
If you see the warning, One or more descriptions were truncated when filling user value, it means that some of the field lengths you specified on the New Cross Reference Table window exceeded the length of application field being populated.
Toggling between the full
EDI list and an abbreviated list
On ECMap’s main menu, select Tools > Cross Reference Tables from the window. The Cross Reference Tables window displays.
In the Cross Reference Table window, right-click a table and select Properties from the submenu. The Cross Reference Table Properties window displays.
From the menu, select Options > Modify View to toggle back and forth between the full EDI code list and an abbreviated list of only those EDI elements that have corresponding application values in the cross-reference table.
Look at the View text box to see which view you are in. For example, ALL RECORDS shows the full EDI code list, while REFERENCE ONLY displays an abbreviated list.
