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
Updated about 3 years ago