Welcome > Configure Kofax AP Agility > Manage Invoice Processing > Validation Activity configuration > Database lookups > Kofax Search and Matching Server databases > KSMS BRWVendorMaster settings

KSMS BRWVendorMaster settings

When adding the BRWVendorMaster database to KSMS, ensure that the following settings are applied. Without this configuration, the database lookup does not work as expected.

Setting	Value
Connection Type	Microsoft SQL Server
Connection String	Connection string for the APAgility database
Relational database object	BRWVendorMaster
Columns to Use	Ensure that the following columns and only these columns are selected for Search. ID SiteID Name Address1 Address2 City Zip State Country POBox POBoxZip Ensure that the following columns and only these columns are selected for Filtering. PartitionID InterCompany
Ignore case	Selected
Database active after import	Selected
Word separation characters	,-; and Space is selected
String Substitution Search Text	To include a pre-defined list of string substitutions, import the SubstitutionStrings_AP_Vendor.xml file from the KSMS directory in the Kofax AP Agility installation files. Refer to the Kofax AP Agility Installation Guide for more information on the installation files.