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 and localize 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.
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:
The line item number of the item invoiced, provided by the supplier.
The quantity invoiced.
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.
A percentage rate.
- Tax Amount
A monetary amount.
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.