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.
This field is part of the primary key. You can choose any code.
A description of the value translation.
The data type of the data that should be translated.
The source value is text.
(The integer value of this option in the database is 0)
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)
The source value is an integer number.
(The integer value of this option in the database is 2)
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)
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)
Specifies the target data type. The options are identical to the Source Data Type.
Specifies whether the source value can be blank. Setting this to True will allow you to translate the blank value to a target value.
Specifies whether the destination value can be blank. Setting this to True will allow you to create lines with a blank destination value.
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.
This field is part of the primary key. The EDI Value Translation code. This field is not shown and filled automatically.
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.
The desired destination value.
If you want to, you can comment or describe the translation value, to make it easier to understand.