Define and map purchase order database columns

To retrieve data from the purchase order database, define the type of content for the database fields.

Map the listed definitions "Purchase Order Number", "Quantity", "Description", "Unit Price", "Total Price", "Purchase Order Item Number" and "Vendor ID" to a corresponding database column. This mapping step is essential to the performance of the Line Item Matching Locator.

The Table Model Columns list displays the names of all columns defined within the selected table model, except the columns listed above. You can map these additional table model columns to database columns in the purchase order database that are not necessarily printed on the invoice. For example, a BudgetCode.

To check whether the entry of a purchase order database column is the same as the content of the corresponding column printed on the invoice, define an additional custom column in the table model. For example, you can check the result from "Description", that is extracted from the invoice, against the result of the "PODescription" database entry.

When testing the locator, the results retrieved from the database are displayed for these columns.

You can configure database mapping by following these steps:

  1. Open the locator properties.
  2. Click the Database tab.
  3. From the list, select the Purchase order database.

    If the database to configure is not available, click Databases to access Project Settings and add a new database.

  4. In the "Define purchase order database columns" table, map the Definition table fields to the corresponding Database Columns by selecting a value in the list.
    Note The Purchase Order Item Number, listed in the Definition column, refers to a Unique Line Item Index Value or a Match Position Index.