You are here: Setting up the system > Solutions > Document specifications and related settings > Table fields: Overview

Table fields: Overview

Note that this information applies to the fields used with document specifications (more information). Fields are also used when preparing invoice profiles (more information).

Many documents include a list of items in the form of a table. Each row in the table represents a single item and contains the same fields. DOCUMENTS can process data contained in such tables.

Examples

ClosedLine items on invoices

Line item tables on an invoice look like this:

Item No.

Quantity

Article No.

Description

Unit Price

Amount

1

5

12345

Screwdriver

3.00

15.00

2

2

9876543

Hammer

9.00

18.00

3

50

9876

Nails

0.05

2.50

The above list contains three line items: one for screwdrivers, one for hammers, and one for nails.

See also: Line items: Overview

ClosedAn address list on a form

An address table on a form might look like this, where each row contains an address:

Street No.

Street

Suburb/City

Postcode

Country

4

South Church Street

Helsingborg

25223

Sweden

5

North Street

Milton Keynes

MK9 1BZ

England

3838

Causeway Blvd.

Metairie

70002

United States

 

What data can DOCUMENTS extract in a table?

You can extract the same kind of data in a list as in other fields (amount, barcode, character, etc.).

You can extract table data that is contained in rows that span just one line or more than one line.

Extracting table data

See Specifying the data to be extracted from table fields.

Tip:Running the DOCUMENTS Knowledge Store Service improves extraction of data from fields, and makes verifying them easier.

Verifying table data

When verifying table data, the Production module shows the extracted values in the Table view at the bottom of the window. See Verifying table fields and Verifying fields using Knowledge Store.

Using fields to extract information from documents: Overview

Defining fields to be extracted: Overview

Tables: Overview