Invoice Line Items

ID

aluma.invoice_line_items

Description

Items in a purchase order that match the items in an invoice, from a database lookup.

Fields

Line Items

Remarks

Parameters

connection_string

The connection string to the database that contains the purchase order line items table.

Type: string
Required: True
provider

The type of database that contains the table used by this module. Valid values are mssql and mysql.

Type: string
Required: True
schema

The schema name for the purchase order line items table. If not set, the table is assumed to be defined within the user's default schema. Only applicable when provider is mssql.

Type: string
Required: False
line_items_table

The name of the table/view that contains purchase order line items.

Type: string
Required: True
purchase_order_format

The format of purchase order numbers contained in the invoice, as a regular expression. If set, this increases the likelihood of identifying the line items by purchase order lookup where the purchase order number in the document does not appear near a heading.

Type: regex
Required: False