Skip to main content
When using an external database, you can use data sets with the Commercial Invoice Document Definition to detect company details for the vendor and consignee. Before you can use a data set, you need to connect it to your external database (for detailed instructions, see Using vendor and business unit databases). You can use the following data sets with the Commercial Invoice Document Definition:
Data setDescription
VariantsA data set for detecting document issuers when using an external database.
BusinessUnitsA data set for detecting business units when using an external database.
To connect a data set to your external database:
  1. Open the Document Definition Editor.
  2. Open the properties of the Commercial Invoice Document Definition.
  3. Click the Data Sets tab, select the desired data set, and click Set Up…
  4. In the Data Set dialog box, provide the connection string to be used to connect to your external database and configure the columns, search options, refresh period, and other settings.