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:
- Open the locator properties.
- Click the Database tab.
-
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.
-
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.