Menu Access
Character: EDI 3 7
GUI: Maintenance
Use this function to maintain information about translation information when receiving
and generating EDI data.
To illustrate the usage of translation tables, consider the situation where you are
purchasing item "GTR0001" from your trading partner Global Trading Resources,
which is sold by the case. You have set up the unit of measure "case" as
"CS". Your trading partner, on the other hand, has set up this unit of measure
as "CA". When your trading partner tries to process the transaction set you have
sent it, an error may occur because your trading partner may not be able to process the
information you have sent it.
In order to resolve the situation, you would set up a translation table, called UOM, which
would have a "From" table record of "CS" with its "To" value
set to "CA". The value "CA" would then be placed in the file instead
of "CS" when EDI data is generated. Your trading partner would then be able to
process the transaction set you have generated without any errors.
You will be prompted for a translation table code. You can create a new translation table
code, or copy from an existing record. Use the |UP/DOWN ARROW| keys to browse the
available translation table codes that are on file.
After choosing the translation table code you want to work with, you will be asked for the
translation table code's "from" and "to" values.
After editing the values in the translation table you were working with, you will be given
the option of creating a reversing translation table. A reversing translation
table is used when you need to recreate a translated value. Reversing translation tables
are useful for converting customer numbers back to store numbers or location codes, and
item numbers back to UPC codes.
If you choose to create a reversing translation table, you will be prompted for
the name of the reversing translation table. The name of the reversing translation table
cannot be the same as the translation table that you are creating it from. If records
exist in the reversing translation table, the system will check to see if records already
exist in the reversing translation table. If there are, you will be given the option of
deleting them before the reversing translation table is recreated. Deleting the records
from the reversing translation table ensures that it is an exact copy of the translation
table from which it is created.
Last updated October 20, 2006