2️⃣ Audit of your third-party database
Audit your third-party database and strengthen Trustpair's analysis by sending us your payment history.
There are 2 files that you can transfer:
- Third-party database: Complete extraction of your database, according to the format requested by Trustpair (described below).
- Payment history : History of payments to your third-parties. Details of the format in the next page.
File format and content
Your CSV file must contain all the columns described 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 "audit of the Third party database" imported into Trustpair
Please find below an example of import file:
Header / column name | Mandatory content | Description | Example |
---|---|---|---|
company_country_code | Yes (if moral person) | Country code in format ISO 3166 (2 or 3 car.) | FR or FRA |
company_name | Yes (if moral person) | Name of the company | Trustpair |
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 |
natural_person_country_code | Yes (if natural person) | Country code in format ISO 3166 (2 or 3 car.) | FR or FRA |
natural_person_tax_number | Optional | Used for countries with tax ID for natural persons | 12345678 |
last_name | Yes (if natural person) | Family name | Dupont |
first_name | Yes (if natural person) | First name | Marie |
other_name | Optional | Other name | |
birthdate | Optional | birthdate | JJ/MM/AAAA |
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 car.) | FR or FRA |
bank_account_number | Yes, if non-IBAN zone | Bank account number of the third party | 123550679 |
bic or bic_code | Yes, if non-IBAN zone | Account number bic code | 019389857 |
routing_number | Optional | Routing number or bank code | Depending on countries |
control_key | Optional | Control key | Depending on countries |
supplier_id | Yes | Unique identifier of the supplier in your database > Its content should never change for a supplier | Specific to your company |
supplier_status | Optional | Status of the supplier in the database allowing to indicate a deactivated supplier but still present in the supplier database | 2 types of values are accepted: empty - provider has not been disabled disabled - supplier disabled |
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 about 1 month ago
What’s Next