Table models

A table model consists of a set global columns or user-defined columns. Table models define the types of data for the locator to extract from a table. Once you define a table model, the locator uses the column structure to extract data from the table.

You define table models based on your business needs. For example, you might define an order table with columns such as Article Code, Quantity, Discount, and Unit Price.

Because a table model becomes a subset of the column pool, you can use columns in more than one table model. For example, use the Quantity column in an invoice table model, as well as, the order table model.

For each column used by a table model, you can define a default value. Do this by selecting a cell in the Default Value column and typing a value.

Use the following toolbar to manage table models.

Setting

Name and Description

Add New Table Model icon
Add New Table Model:

Inserts a new table model.

Delete Table Model icon
Delete Selected Table Model:

Deletes the currently selected table model from the project.

Properties icon
Edit Table Model Properties:

Edits the selected table model properties.

More info