Linking of vendor master data (edoc master data matching service)

A document can be linked to the appropriate vendor using master data matching. The vendor of a document can only be determined if the document has already been linked to a company. If the comparison with the vendor master data is successful, the vendor ID, for example, is written to the properties of the document.

The vendor master data in edoc invoice is retrieved via the following endpoint: POST http://<invoice-service>/capture/{client}/creditors/search

As there can be a large amount of vendor master data, the vendor master data is filtered during retrieval. The following properties serve as filter criteria, whereby at least one of the properties must be filled in a document for edoc invoice to return potential vendors:

• Vendor ID

• Purchase order numbers

• VAT identification number

• Tax ID

• IBAN

• Account number

• Zip code

The more properties are filled in the document, the better the filter works.

If edoc invoice only returns one potential vendor, the document is linked to this vendor. The vendor data is written to the properties of the invoice.

Relevant vendor properties for master data matching

If edoc invoice returns more than one potential vendor, the document properties are compared with the vendor master data. Depending on how unique a property is, it is weighted differently. Further information on the evaluation of properties can be found here: Master data matching methods (edoc master data matching service)

The vendor is determined on the basis of the following properties:

• Vendor ID: Weighting: high.

• Vendor name: Weighting: medium.

• Tax number: Weighting: high.

• VAT identification number: Weighting: very high. The VAT identification number is included in the evaluation above a certain threshold value during fuzzy matching.

• Account number: Weighting: high.

• Purchase order numbers: Weighting: high.

• Addresses: If there are several addresses for a vendor, the address with the highest score (rating) is preferred.

  • Street: Weighting: low.

  • Zip code: Weighting: high.

  • City: Weighting: medium.

  • Country: Weighting: low.

• Bank details: If there is more than one bank account for a vendor, the bank account with the highest score is preferred.

  • IBAN: Weighting: very high. The IBAN is included in the evaluation from a certain threshold value during fuzzy matching.

  • BIC: Weighting: medium.

  • Account number: Weighting: high.

  • Bank code: Weighting: medium.

Written back vendor data

If the vendor of the invoice has been recognized and linked, the document properties in edoc documents are filled and updated with the following vendor data:

• Vendor ID

• Vendor name

• Account number

• Tax ID

• VAT identification number

• Highest rated address:

  • Street

  • Zip code

  • City

  • Country

• Highest rated bank account:

  • IBAN

  • BIC

  • Account number

  • Bank code