Config / Advanced Topics / EDI Value Translation

EDI Value Translation

Anveo EDI Connect offers a general concept to translate constant values, for example, from an internal to an external representation. The value translation structure is very simple, you have a list of source values that is translated to a list of target values. Because you can translate different source expressions to the same target expression, the direction cannot be changed. You will need to create two separate translations, if you need to translate in both directions. This structure is very simple and mostly suited for data translations that will not often change.

Setup a New EDI Value Translation

Create a new record in the table EDI Value Translation and choose a code. You can enter a description to describe the function of this translation table. Afterwards please choose the source and target data type. You can then start to create the value translation lines.

Header Fields

Code

This field is part of the primary key. You can choose any code.

Description

A description of the value translation.

Source Data Type

The data type of the data that should be translated.

Text

The source value is text.
(The integer value of this option in the database is 0)

Code

The source value is interpreted as code.

This can also be used on text value to make the value translation case-insensitive.

(The integer value of this option in the database is 1)

Integer

The source value is an integer number.
(The integer value of this option in the database is 2)

Decimal

The source value is a decimal number. Please be aware that due to rounding differences it can be dangerous to work with decimals.Two values that look identical to the user can have a different binary representation.
(The integer value of this option in the database is 3)

Option

The source value is an option. You should enter the option values as integer values. You can optionally use the syntax “0=Option 1”, where you use the equal sign to describe the value. The value after the equal sign is technically ignored.
(The integer value of this option in the database is 4)

Destination Data Type

Specifies the target data type. The options are identical to the Source Data Type.

Source Blank Allowed

Specifies whether the source value can be blank. Setting this to True will allow you to translate the blank value to a target value.

Destination Blank Allowed

Specifies whether the destination value can be blank. Setting this to True will allow you to create lines with a blank destination value.

Last Modified

The date/time this table and/or the line table was modified last.

EDI Value Translation Line

To create or edit lines, navigate to the desired EDI Value Translation and edit the lines on the card page.

Line Fields

Code

This field is part of the primary key. The EDI Value Translation code. This field is not shown and filled automatically.

Source Value

The source value you want to translate to a different target value. The source value has to be unique for one
EDI Value Translation. This field is part of the primary key.

Destination Value

The desired destination value.

Description

If you want to, you can comment or describe the translation value, to make it easier to understand.