These settings indicate how the company code is located and validated. Depending on whether or not you validate the country code using SAP or another database, different settings are available.

Validate From SAP

When selected, the company code is validated against SAP.

Validate From DB

When selected, the company code is validated against a database.

Database Connection Name

Select the database connection name that specifies the company code database connection string from the list.

This setting is available only when Validate From DB is selected above.

DB Schema

Enter the name of a schema to filter the list of database tables available for the selected Database Connection Name.

If this field is left blank, all database tables that you have permission to access, are displayed.

This setting is available only when Validate From DB is selected above.

DB Table Name

Select the name of the company code database table from the list. The list is populated based on the selected Database Connection Name and if used, the specified schema. If the selected table has columns that match the settings below, they are populated automatically.

This setting is mandatory for database lookups.

This setting is available only when Validate From DB is selected above.

Use PO Partition

If selected, the company code database lookup uses a purchase order partition. Purchase order partitions are set against the organization in the Settings > Organizations.

This setting is available only when Validate From DB is selected above.

PO Partition Column

Select the PO Partition ID from the list. Partitions are specified in the Settings > Invoice Processing > Global Settings > Partition Settings > PO Number Partition tab.

This setting is available only when Validate From DB and Use PO Partition are selected above.

DB Column Name

If a value for this field is not populated automatically, select the name of the column in the company code database table that holds the valid company codes, from the list.

This setting is mandatory for database lookups. This list is populated based on the selected DB Table Name.

This setting is available only when Validate From DB is selected above.

DB Country

If a value for this field is not populated automatically, select the name of the column in the company code database table that holds the country where the company is legally based, from the list. This list is populated based on the selected DB Table Name.

This setting is available only when Validate From DB is selected above.

DB Currency

If a value for this field is not populated automatically, select the name of the column in the company code database table that holds the currency for the company code, from the list. This list is populated based on the selected DB Table Name.

This setting is available only when Validate From DB is selected above.

DB VAT Reg Nos

If a value for this field is not populated automatically, select the name of the column in the company code database table that holds the VAT registration numbers for the registered company, from the list. If the company is registered for VAT in more than one country, the database field contains a comma-separated list. This list is populated based on the selected DB Table Name.

This setting is available only when Validate From DB is selected above.

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

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.