Translate field values using a table: Overview
One use for tables is to translate field values, or change one field value to another, for example:
- When certain values are to be abbreviated
- When a field is often misinterpreted due to punctuation marks
- When you want certain field values to be replaced by spaces in the transfer file
When a field value corresponds to a key value in the specified translation table, Kofax ReadSoft Invoices translates the field value to the corresponding value. If a field value is missing from the translation table or does not have a corresponding value in it in the Translation column, the value is not translated.
Using a translation table for a field is different from indicating a table for Field validation. Using a translation table, a field value is translated if it is found in the table with a corresponding translation value, and no error status is set if it is not found. Using a validation table, the field is given an error status if it is not found in the table. You can indicate the same table name in each place to achieve both functions.
Normally, Kofax ReadSoft Invoices translates fields immediately after interpretation, which means that Kofax ReadSoft Invoices applies validation routines (if you specify any) to translated fields. This means that you can use tables to correct common format errors or un-interpretable punctuation marks or remove unnecessary digits before validation. You can select Translate when transferred to change this.