X-ray a vendor master list: duplicates, invalid IBAN and VAT ID, gaps, dormant vendors and risk signals
check_vendor_masterAICTIONBOT™ Vendor Master X-ray by KULIC Advisory. Takes a vendor (creditor) master list and returns duplicate groups with the reason and a suggested leading record, risk signals (one IBAN under two names, one VAT ID or tax number under two names, bank country different from the country of residence, BIC not matching the IBAN), format errors (IBAN check digits and length, VAT ID format per country and the German check digit, postcode, e-mail, BIC, date), gaps in required fields, dormant vendors without activity and a clean-up list with a proposal per record. Column names in German or English are recognised (Kreditor, Name, Straße, PLZ, Ort, Land, USt-IdNr., Steuernummer, IBAN, BIC, E-Mail, Telefon, Letzte Bewegung, Sperre; no, name, street, zip, city, country, vat_id, tax_number, iban, bic, email, phone, last_activity, blocked). Check digits and formats do not prove that an account belongs to the supplier. Up to 1,000 vendors per call; larger lists run in the browser tool on the user's own device. Deterministic, no AI, nothing stored. Needs sign-in: runs with an AICTIONBOT™ Werkbank licence; without a licence one check per connection every 30 days is free (sign in with “Connect without a licence”).
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "check_vendor_master"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | No | Alternative to rows: the list as CSV or tab-separated text. The first line is the header. | |
| rows | No | The vendor master as rows: one object per vendor, column name to value. The name is required. Up to 1,000 vendors per call. | |
| as_of | No | Reference date for dormant vendors, YYYY-MM-DD. Default today. | |
| limit | No | Entries shown per section in the text. Default 10. | |
| language | No | Language of the answer. Default de. | |
| dormant_months | No | Months without activity from which a vendor counts as dormant. Default 24. | |
| similarity_threshold | No | Name similarity from which two records count as duplicates. Default 0.88. |