Global columns

Invoices and other business documents frequently have a common set of columns with meanings such as quantity, unit price, or description. A column like Quantity is not just a column with an arbitrary set of characters in each cell, but rather has a value that signifies the quantity of a line item.

When you create a project, a set of fifteen global, predefined columns that are commonly used for invoice and purchase order line items, are generated automatically.

You can add global columns to a table model, and then map the columns to a table locator field. You cannot delete a global column, but you can rename the column name. Global columns are highlighted yellow while user-defined columns have no highlighting.

If you need additional columns, you can add a user-defined column to the column pool.

To use automatic table detection to find data on your invoice documents, use the default global columns. The automatic algorithm cannot calculate user-defined columns.

A global column has an English name by default. Names can be added for different languages as needed.

The following default global columns are available:

Position:

The line item number of the item invoiced, provided by the supplier.

Quantity:

The quantity invoiced.

Description:

Text that describes the item invoiced.

Unit Price:

The unit price, which may be discounted.

Total Price:

The total price, which may be discounted.

Unit Measure:

The unit of quantity. The package size of a unit is predefined for 1, 10, or 1000 items per package. This column does not stand for quantity units, such as kilograms, inches or liters.

Article Code:

The buyer’s article code for the line item. This code usually differs from the suppliers article code for the same item.

Supplier Article Code:

The article code used for the selected line item allocated by the supplier.

Order Number:

The purchase order number of the ordered line item.

Purchase Order Item Number:

The line item ID of the matching item in the purchase order.

Delivery Note Number:

The number of the delivery note enclosed with the delivery when this line item was delivered.

Tax:

A percentage rate.

Tax Amount:

A monetary amount.

Discount:

A percentage rate.

Discount Amount:

A monetary amount. The discount amount is a reduction applied to the total price and does not refer on the unit price.

More info