Use this tab to configure the line items table for invoice export.

This tab is available only when the Active setting is selected on the DB Export Settings - Main tab.

DB Line Items Table

The name of the database table where the invoice line item information is written. The line item database export always occurs as an INSERT, and any existing lines for the same document record are deleted first.

DB Line Items Key

The name of the column in the line item export database table that, along with the header level key, represents the key field for each invoice line item record. This is typically set to the invoice line item number, such as 1,2,3, and so on.

The following buttons are available for the above settings.

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.

DB Line Item Mappings

This table lists the line item mappings and has the following columns.

Field Name

The name of the field.

DB Column Name

The database column that represents the field when exported to a database.

The following button is available to edit table entries.

Edit

Opens a selected entry in the table so that you can make changes as needed.

Click to open the DB Line Item Mapping - Edit window.