Use these settings to specify the database settings and create a SQL query string when configuring the AutoValue add-on.
Note: AutoValue works only with a SQL Server database. It does not work with an Oracle database.
|
|
The name or IP address of the computer acting as the database server. |
|
|
The user name for logging on to the database server. |
|
|
The password for logging on to the database server. |
|
|
The name of the database containing the value you want to insert. Click to fill in the box with available databases. |
|
|
The SQL query to be used to retrieve the value from the database. Optionally, you can insert a macro in this box to retrieve INVOICES-specific information. |
| Warning |
|---|
|
If there is an error in your SQL statement, any remaining fields will not receive a value. |