KSMS AP_Company settings

When adding the AP_Company view 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

CompanyAddressMaster

Columns to Use

Ensure that the following columns and only these columns are selected for Search.

  • CompanyName

  • CompanyAddress

Ensure that the following column and only this column is selected for Filtering.

  • PartitionID

Ignore case

Selected

Database active after import

Selected

Word separation characters

,-; and Space is selected