Field Settings

These settings determine which fields are active for a given profile. It also includes their field types and validation settings. It is possible to add multiple entries for these settings. As a result, the settings are displayed in a table.

Any changes made to these settings are applied to new documents only. Documents that are already in-progress use the settings that were in-place when their processing began.

The following settings are available.

Class Name

The class name of the document. This determines which field settings are applied. Typically, settings are provided for the INVOICES class which is the base class for all invoices. However, subclasses can have different settings. If subclass settings are provided, these override the base class settings.

When adding new fields, you must use uppercase for the Class Name.

A common value for this setting is INVOICES.

Field Name

The name of the Kofax AP Agility field that is used in Transformation Designer and is displayed on the Validation activity form.

If you add settings for a custom field, enter the Transformation Designer field name here.

Do not change the standard field names. This causes problems with the Transformation Designer form and other configuration settings.

Active

If selected, the field is active for a profile. This means that the field is extracted and displayed in the Validation activity.

If you are using the AP Workflow for the selected organization you can synchronized the field visibility on the Organizations - Field Configuration tab.

Required In Server

If selected, and no value for the field is extracted in Transformation Designer, the field is invalid.

Required In Validation

If selected, the field is mandatory in the Validation activity. This means that an empty field is invalid.

It is possible to mark a field Required in Server but not as Required in Validation. This forces the user to confirm all empty fields.

You cannot select Required in Validation without selecting Required in Server first.

Country Filter

The comma-separated list of country ISO-codes that marks a field mandatory for specific countries.

This setting is used in conjunction with Required In Server and Required In Validation settings. If a field is mandatory for either of these settings, and the vendor country of origin is not specified in the list, then the field reverts to optional.

Field Type

The type of a field. Select one of the following types.

  • AMOUNT

  • DATE

  • TEXT

  • TABLE

Force Validation

When selected, a field is always marked as invalid and sent to the Validation activity for review.

Fixed Value

This is a predefined value that is applied to the corresponding field and overwrites the extracted value, or a value entered manually by a user during production.

For example, if you process documents in the American dollar currency only, you can set the Fixed Value for the Currency field to USD. This means that the Currency field always has the USD value even if another value is extracted or entered by a user manually.

Default If Nothing Extracted

The default value of a field if the system does not automatically extract a value from a document.

Substitution Rule

Select the field substitution rule from the list for text fields.

Substitution rules are configured in the Settings > Invoice Processing > Global Settings > Substitution Rules.

Min Length

The minimum text field length.

Max Length

The maximum text field length.

Right Justify

If selected, the system pads the field using the Pad Char character from the left, until the Max Length is reached.

Pad Character

The padding character applied to a text field if it does not meet the maximum length.

Remove All Specials

If selected, all special characters are removed from a text field. This means that all characters that are not letters, digits, or whitespace, are removed.

Exceptions are defined in Keep Certain Specials below.

Remove Spaces

If selected, spaces are removed from a text field.

Keep Certain Specials

A non-delimited list of special characters that are retained if Remove All Specials is enabled.

Remove Start End

If selected, all special characters are removed from the beginning and from the end of an extracted text value. The Keep Certain Specials list is not applied here. All characters that are not letters, digits, or whitespace, are removed, regardless of the special characters listed in Keep Certain Specials.

Substring Start Position

The starting character used in conjunction with the "Substring Length" when trimming an extracted value. Positive numbers start from the left while negative numbers start from the right.

For example, an invoice number can only be five characters, but the extracted value is "123456789." A "Substring Start Position" value of "-5" and a "Substring Length" value of "5" means that the end result is "56789."

Substring Length

The length of a substring.

Remove Leading Zeros

If selected, any leading zeros are removed from an extracted text value.

Decimal Places

The number of decimal places for an amount field.

Negative Type

Controls the output during export if the extracted value for an amount field is less than zero.

Choose one of the following settings.

  1. Absolute value - This value means that the specified value without a leading or trailing minus sign, is sent during export.

    This is represented as a 0 in the Field Settings summary table.

  2. Trailing minus - This value means that the minus sign is displayed after the amount, such as 100.00-.

    This is represented as a 1 in the Field Settings summary table.

  3. Leading minus - This value means that the minus sign is displayed before the amount, such as -100.00.

    This is represented as a 2 in the Field Settings summary table.

  4. In parentheses - The value means that the minus sign is not displayed, but the related value is displayed in parentheses. For example, 1 (100.00).

    This is represented as a 3 in the Field Settings summary table.

Output For Zero

The amount value that is output during export if a zero value is found.

Substitute Value If Over 0

The amount value that is output during export for an extracted amount value that is greater than zero.

Future Days

The number of days in the future that an extracted date is considered valid. For example, today is March 20 and an extracted date is March 31. If the value is set to 10, then the system marks the field invalid as the extracted date is 11 days in the future.

If future dates are not permitted, set the column value to zero. To disable the check, set the value to -1.

In the Validation activity, the user can pass any value as long as it is a valid date.

No. Days In Past

The numerical value that indicates the number of days in the past that an extracted date is considered valid.

For example, today is March 20 and an extracted date is March 9. The value is set to 10, so the system marks the field invalid as the extracted date is 11 days in the past.

If past dates are not permitted, set the value to zero. To disable the check entirely, set the column value to -1.

In the Validation activity, the user can pass any value as long as it is a valid date.

Date Only in Current Month

If selected, an extracted date that is not in the current month is marked invalid and the document is sent to the Validation activity.

In the Validation activity, the user can pass any value as long as it is a valid date.

Field Mask

A comma-separated list of characters allowed in the extracted or user-entered value.

For example, if the content of this column is set to ABCD,WXYZ only values ABCD or WXYZ are permitted.

Wildcard characters are also permitted, where # represents any number, an @ represents any letter, and a ? represents either a number or a letter.

Extraction Profile ID

Use this for custom fields that are set up to use the configurable extraction feature. The content of this column corresponds to an "Extraction Profile ID" value that is configured in the Settings > Invoice Processing > Global Settings > Custom Extraction Profiles > Extraction Profiles.

A value of zero means that no configurable extraction is required for this field.

This setting is available for Custom 1-5 fields only.

The following buttons are available at the bottom of the window.

Edit

Opens a selected entry in the table so that you can make changes as needed.

Click to open the Field Settings - Edit window.

Add

Adds an entry to the table.

Click to open the Field Settings - New window.

Activate

This setting is available for a field that is not Active only.

You can select multiple fields and use this button to activate the fields all at once.

Deactivate

This setting is available for a field that is Active only.

You can select multiple fields and use this button to deactivate the fields all at once.