1️⃣ Supplier Account Check
To check third parties you can use either the form in Trustpair to make unitary checks, or you can check small batchs by importing files (max. 50 lines).
Here is the format and content expected for this file to check batches :
File format and content
Your CSV file must contain all the columns shown below (they may be empty if the content is not mandatory). To ensure proper processing of the file, the headers (without spaces) must be respected.
File "control requests" imported into Trustpair"
Header / column name | Mandatory content | Description | Example |
---|---|---|---|
custom_id | Yes | Unique supplier reference per pair | FG0123 |
company_country_code | Yes (if moral person) | Country code in format ISO 3166 (2 or 3 char.) | FR or FRA |
company_registration | 1 of the 3 ID is mandatory - your choice (if moral person) | National identification number of the third party | 832940670 |
tax_number | 1 of the 3 ID | European VAT number | FR40123456824 |
duns | 1 of the 3 ID | 9-digit identification number issued by the private company Dun & Bradstreet | 270243120 |
company_name | Recommended (outside of UE) | Name of the company | Trustpair |
company_raw_address | Recommended (outside of UE) | Address of the company | 174 quai de Jemmapes 75010 Paris |
iban | Yes, if IBAN zone | Supplier's account number in IBAN format | FR7612548029981234567890161 |
bank_account_country_code | Optional | Country code in format ISO 3166 (2 or 3 char.) | FR or FRA |
bank_account_number | Yes, if non-IBAN zone | Bank account number of the third party | 019389857 |
bic or bic_code | Yes, if non-IBAN zone | Account number bic code | WFBIUS6S |
routing_number | Optional | Routing number or bank code | Depending on countries |
control_key | Optional | Control key | Depending on countries |
natural_person_country_code | Yes (if natural person) | Country code in format ISO 3166 | FR or FRA |
natural_person_tax_number | Optional | Tax ID for natural person | 123345555 |
last_name | Yes (if natural person) | Family name | Dupont |
first_name | Yes (if natural person) | First name | Marie |
other_name | Optional (if natural person) | Other name | |
middle_name | Optional (if natural person) | Middle name | |
birthdate | Optional (if natural person) | Birthdate | JJ/MM/AAAA |
Template & examples
Please reach out to your Customer Success Manager for an example
If needed, we can provide you with a .csv sheet that displays all the columns required with several examples. You can then duplicate it, fill-it with your extraction file informations and name it according to the conventions above.
Updated 11 days ago
What’s Next