Audit your third-party database and strengthen Trustpair's analysis by sending us your payment history.

2 files to transfer :

Vendor database: Complete extraction of your database, according to the format requested by Trustpair
Payment history: History of payments to your third parties. See on the next page for details.

Naming Convention

The naming convention defined previously by Trustpair includes the name of the scope.
This naming convention must be respected as it is used as the key to affection between environments and modules.
To facilitate monitoring, 2 folders (import and export) have been created.

Type of file	Format	Example	Folder
Files “audit of your vendor database” sent from you information system into Trustpair	pair-NAME_PERIMETER-TIMESTAMP.csv	pair-TRUSTPAIR-2022013122.csv	To put on the following folder —> /import-into-trustpair
Files “restitution of evaluations” sent from Trustpair to your information system	pairs-evaluations-NAME_PERIMETER-TIMESTAMP.csv	pairs-evaluations-TRUSTPAIR-2022013122.csv	To put on the following folder —> /export-from-trustpair

NB : TIMESTAMP corresponds to the date of creation of the file, respecting the POSIX standard (Epoch time). This must contain 10 or 13 digits.

File format and content

File "evaluations of your database" exported from Trustpair

If you are willing to use the SFTP feedback loop, here are the fields that will be included in the export file.

Header / column name	Mandatory content	Expected format	Description	Example
creation_date	Optional	Date, locale format	Creation date of the supplier check	27/01/2022
supplier_id	Yes	String	Unique identifier of the supplier in your database. The supplier identifier must not change	Depending on your company/IS
supplier_type	Optional	Enum	Type of vendor	Legal entity or individuals
company_registration_country_code	Optional	String	Country code in format ISO 3166 (2 char.)	FR
company_country_code_iso3	Optional	String	Country code in format ISO 3166 (3 char.)	FRA
company_registration	Optional	String	National identification number of the vendor	832940670
tax_number	Optional	String	European VAT number	FR40123456824
duns	Optional	String	9-digit identification number issued by the private company Dun & Bradstreet	270243120
company_name	Yes	String	Company name in your database	ABCD Company
db_company_name	Optional	String	Official company name	ABCD Company
db_company_trade_name	Optional	String	Commercial name of the company	ABCD
db_company_address	Optional	String	Complete address of the company	4 rue du lac
db_company_street_number	Optional	String	Street number of the company	4
db_company_street	Optional	String	Street name of the company	rue du lac
db_company_city	Optional	String	City of the company	Paris
db_company_zip_code	Optional	String	Postcode of the company	75010
db_company_state	Optional	String	State/region/province of the company	Ile de France
db_company_country	Optional	String	Country of the company	France
db_company_country_code_iso2	Optional	String	Company country code format ISO 3166 (2 car.)	FR
db_company_country_code_iso3	Optional	String	Company country code format ISO 3166 (3 car.)	FRA
db_company_activity	Optional	String	Company activity	Services
db_company_legal_form	Optional	String	Legal form of the company	SARL
db_company_creation_date	Optional	Date, locale format	Creation date of the company	15/12/1985
db_company_workforce	Optional	String	Number of employees in the company	130
insolvencies	Optional	Boolean	Ongoing collective proceedings
last_insolvency_date	Optional	Date, locale format	Date of the last collective proceedings
last_insolvency_link (coming)	Optional	-	Link to the collective proceedings
first_name	Optional	String	First name	Nadine
last_name	Optional	String	Family name	Comot
other_name	Optional	String	Other name
birthdate	Optional	Date, locale format	Birthdate	23/05/1990
bank_account_country_code	Optional		Bank country code format ISO 3166 (2 car.)	FR
bank_account_country_code_iso3	Optional	String	Bank country code format ISO 3166 (3 car.)	FRA
iban	Optional	String	Supplier's account number in IBAN format	FR7612548029981234567890161
bank_account_number	Optional	String	Bank account number of the vendor	019389857
bic	Optional	String	Account number bic code	WFBIUS6S
routing_number	Optional	String	Routing number or bank code	Depending on countries
control_key	Optional	String	Control key	Depending on countries
db_bank_name	Optional	String	Bank name	Société Générale
db_bank_adress	Optional	String	Address of the bank	10 rue du pont
db_bank_street_number	Optional	String	Street number of the bank	10
db_bank_street	Optional	String	Street name of the bank	rue du pont
db_bank_city	Optional	String	City of the bank	Paris
db_bank_zip_code	Optional	String	Postcode of the bank	75010
db_bank_state	Optional	String	State/region/province of the bank	Ile de France
db_bank_country	Optional	String	Country of the bank	France
db_bank_country_code_iso2	Optional	String	Bank country code format ISO 3166 (2 char.)	FR
db_bank_country_code_iso3	Optional	String	Bank country code format ISO 3166 (3 char.)	FRA
bank_account_blacklisted	Optional	Boolean	If the bank account is in Trustpair blacklist	true/false
global_eval	Yes	Enum	Overall result of the evaluation	Favorable, unfavorable, anomaly, unconfirmed
evaluation_method	Optional	String	Control methodology used for the evaluation
company_eval	Recommended	Enum	Result of the company evaluation	Favorable, unfavorable, anomaly, unconfirmed
company_eval_state	Optional	String
company_eval_details	Recommended	String	Details of the company evaluation	the company is active
bank_account_eval	Recommended	Enum	Result of the bank account evaluation	Favorable, unfavorable, anomaly, unconfirmed
bank_account_eval_state	Optional	String
bank_account_eval_details	Recommended	String	Details of the bank account evaluation	The bank account is closed
correlation_eval	Recommended	Enum	Result of the correlation evaluation	Favorable, unfavorable, anomaly, unconfirmed
correlation_eval_state	Optional	String
correlation_eval_details	Recommended	String	Detail of the correlation evaluation	The bank account doesn't belong to the company
evaluation_before_override	Optional	Enum	Evaluation before override	Unconfirmed
override_request_date	Optional	Date, locale format	Date of the override request	21/09/2022
override_requester	Optional	String	Name of the override requester	Sabine Dupont
override_review_date	Optional	Date, locale format	Date of the override approbation	22/09/2022
override_reviewer	Optional	String	Name of the override reviewer	Charles Laval

❗️
Only definitive status will be displayed in the evaluation file.
If an evaluation is "in progress", the results will be in the file the day of the evaluation

2️⃣ Vendor Database Audit

Naming Convention

File format and content

File "evaluations of your database" exported from Trustpair

Only definitive status will be displayed in the evaluation file.

What’s Next