Supplier Identity

ID

aluma.supplier_identity

Description

Identity, from a database lookup, of the supplier from whom an invoice was sent.

Fields

DB Supplier ID, DB Supplier Name, DB Supplier Address, DB Supplier Tax ID

Remarks

Parameters

connection_string

The connection string to the database that contains the tables used by this module.

Type: string
Required: True
provider

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

Type: string
Required: True
schema

The schema name for the tables used by this module. If not set, the tables are assumed to be defined within the user's default schema. Only applicable when provider is mssql.

Type: string
Required: False
supplier_table

The name of the table (or view) containing records for all possible suppliers.

Type: string
Required: True
purchase_order_supplier_table

The name of the table (or view) acting as a join between purchase orders and suppliers. Providing this table increases the likelihood of successful supplier identification because the supplier can be identified from the purchase order number in the document.

Type: string
Required: False
customer_table

The name of the table (or view) containing records for all of the customer's own addresses. Providing this table increases the likelihood of successful supplier identification when the customer, or customer's address, is present in the supplier table.

Type: string
Required: False
purchase_order_format

Specifies the format of purchase order numbers to find, as a regular expression. Only used if the Purchase order table name parameter is also set. If set, this increases the likelihood of identifying the supplier by purchase order number lookup where the purchase order in the document does not appear near a heading.

Type: regex
Required: False