› Prepare invoice profiles and associated objects for production › Field profiles: Overview › Settings for field profiles › Translate field values using a table

Translate field values using a table

To create and use a table for translating fields:

  1. Using Manager, select File > New.
  2. Select Table and click OK.
  3. Type a name for the new table. Note that table names are case-sensitive.
  4. Click OK. The Table dialog is displayed.
  5. In the first Update line box, type values that can occur in the field. Type one key value on each line. The Key field can contain up to 63 characters (More detailed instructions).
  6. On the same line, under Translation, type the value that you want to change each key value to. The Translation field can contain up to 99 characters.
  7. Click Close. This saves the table.
  8. Create or edit the field profile in your invoice profile.
  9. In the Table validation settings, select the name of the translation table in the Translation table group box.
  10. Optional: Select Translate value when transferred to translate the value after validation and verification (that is, just before transfer).

    If you do not select Translate value when transferred, translation occurs in Interpret. To avoid validation errors in this case, make sure the format specification of the field being translated matches both the field values and the translation values.

Tungsten ReadSoft Invoices does not support direct translation of different field formats via table translation. For example, you cannot translate a field with a numeric format specification to an alphabetic value. However, you can do this using a connection table connected to an empty field.