Company Code

Derive From

This setting enables you to configure a preference for how the Company Code is derived from the printed addresses on an invoice. In order for the successful extraction of these addresses, corresponding labels are required. For example, "Bill to" or "Ship to." The confidence of a locator alternative is either increased or decreased based on the keywords found next to an address.

The possible values for this setting are:

• Any address. (Default: Selected)

  Select this value if you have no preference or typically have a single recipient address on your invoices.

• Bill-to address.

  Select this value if you want to use the bill-to address for the Company Code address.

• Ship-to address.

  Select this value if you want to use the ship-to address for the Company Code address.

Always.

Validate From SAP ECC

When selected, the company code is validated against SAP ECC.

Always.

Validate From DB

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

Always.

Database Connection Name

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

Only when Validate From DB is selected.

DB Schema

Enter the name of the schema to filter the list of database tables available for the selected Database Connection Name. (Default: Cleared)

Only when Validate From DB is selected.

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. (Mandatory)

Only when Validate From DB is selected.

Use PO Partition

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

Only when Validate From DB is selected.

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.

Only when Validate From DB and Use PO Partition are selected.

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 list is populated based on the selected DB Table Name.

Only when Validate From DB is selected.

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.

Only when Validate From DB is selected.

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.

Only when Validate From DB is selected.

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.

Only when Validate From DB is selected.

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.