Tradesimple: CSV Specification: Trading Relationship Load

Overview

The trading relationship load allows for the creation of trading relationships en-masse, as opposed to application singularly via the Purchasing (formerly known as Trade Simple) web interface. This load is particularly useful when new suppliers are integrated or a large number of new sites have been created and require new trading relationships to be formed.

A full list of articles covering the creation of other CSV files that can be loaded to Purchasing can be found here P2P&I - Purchase to Pay CSV Specification - Contents Page

Format

Field	M/O	Column	Notes
Line Number	M	A	1, 2, 3, etc
Supplier Code	M	B	The organisation's code for the supplier
Unit Code	M	C	The code for the unit/cost-centre/location
Supplier Account Code	M	D	The supplier code for the unit/cost-centre/location

Example

1,00041842,8552,H777519

2,00041842,8576,H051664

3,00041842,8578,F051669

4,00041842,8805,E017287

5,00041842,8772,G791170

6,00041842,8566,D050268

7,00041842,8537,A718233

8,00041842,8705,J803296

9,00041842,8662,G558005

10,00041842,8586,H658935

11,00041842,8654,G775624

12,00041842,8713,A098826

13,00041842,8514,C060257

14,00041842,8543,J060282

Overview

Format

Field

M/O

Column

Notes

Example

Related articles