Working with cross-reference tables

Cross-reference tables provide a quick and easy way to convert data during mapping. They can be used to produce preassigned EDI codes when application data does not meet the EDI standard format, or for any other one-to-one conversion. The most common reason for needing to modify a cross-reference table in a map is to account for the differences in internal application codes when that same map is being run for multiple trading partners.

Creating a cross-reference table

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, select File > New.

   When the New Cross Reference Tables dialog appears, the Project and Map names reflect those of the map currently in the workspace.

3. In the File Name box, type the name of the new cross-reference table.

   File names must be 8 characters or less.

4. What happens next depends on the value you choose in the Standard Field Number group

   Choose this...	To do this...
   No Field Number	Create a cross-reference table that does not use EDI values. If you choose this option, you must specify the following values: Standard Field Length Application Field Length
   Select Field Number	Open a dialog box and choose an element from the map that you want to cross reference. When the element selection window appears, click the row with the element you want to add, click OK. ECRTP/TP updates these values on the New Cross Reference Tables dialog Standard Field Length Application Field Length Field Number

5. In the Description box, describe the EDI data associated with the element number, or a brief general description of the data elements being cross-referenced in the table.

Adding elements to a cross-reference table

After you create a table, use these instructions to add elements to an existing cross-reference table.

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, right-click the table you want to change and choose Properties from the submenu.

3. In the Cross Reference Table property sheet, select File > New.

4. In the Cross Reference Entries dialog, add the following values:

   For this field...	Do this...
   EDI Value	Type a value from the code list for the standard used in the current map. For both inbound and outbound maps, this value is the EDI side of the EDI/application code conversion done by the cross-reference table. For non-EDI conversions in an outbound or any-to-any map, this is the source or input value.
   Application Value	Type the value in the application data that corresponds to the value in the EDI Value textbox. For both inbound and outbound maps, this value is the application side of the EDI/application code conversion done by the cross-reference table. For non-EDI code conversions in an inbound map, this is the destination or output value.
   Description	Description the cross-reference entry you want to create.

5. Do one of the following:

   • Click Next to add another entry or

   • Click OK to return to the Cross Reference Table properties sheet

Automatically creating entries in a cross-reference table

Use these instructions to populate all blank application fields in a cross- reference table entry with either the description or the EDI code value.

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, right-click the table you want to change and choose Properties from the submenu.

3. In the Cross Reference Table property sheet, select one of the following:

   • Options > Fill Fields from > Description

   • Options > Fill Fields from > EDI Value

4. What happens next depends on how you chose to populate the table.

   If you chose...	The program does this
   Description	Populates any blank cross application fields in the Cross Reference column with values from the Description column.
   EDI Value	Populates any blank application fields in the Cross Reference column with values from the EDI Field Value column.

Importing cross-reference data from file

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, click the table where you want to insert the data.

3. Click File > Import and choose either Delimited File or Fixed Length File.:

4. In the Import window, choose the file you want to import.

Viewing EDI Elements with values in a cross-reference tables

Use these instructions to toggle views between a full EDI code list and an abbreviated list of only those EDI elements that have corresponding application values in the cross-reference table.

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, select Options > Modify View.

3. What happens next depends on the current view.

   If the current view is...	ECRTP displays...
   ALL RECORDS	A full EDI code list
   REFERENCE ONLY	An abbreviated list of EDI elements with corresponding application values in the cross-reference table

Searching cross-reference tables for values

Use the Find function to search for values in a cross-reference table.

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, right-click the table you want to change and choose Properties from the submenu.

3. In the Cross Reference Table property sheet, select Edit > Find.

4. In the Find dialog, Type a Search String in the text box.

   To search for additional occurrences of the string, click Find Next.

Deleting an entry in a cross-reference table

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, right-click the table you want to change and choose Properties from the submenu.

3. In the Cross Reference Table property sheet, right-click the element you want to delete and choose Delete from the submenu.

Scanning a directory for unreferenced tables

Use these instructions to scan unreferenced cross-reference tables stored in a common directory.

1. In the main ECRTP/TP window, select Tools > Cross Reference Tables.

2. In the Cross Reference Tables window, select File > Directory Scan.

3. In the Cross Reference Table property sheet, select Edit > Find.

4. Select any of the unreferenced tables you want to use.

   • To select a single table, click the row that contains the table.

   • To select multiple contiguous tables, click the row with the first table, press Shift, then click the last table.

   • To select non-contiguous tables, click row with the first table, press Ctrl, then click the next table. Repeat this until you have selected all the tables you want.

5. Click OK.

---

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF