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
Comments
Please sign in to leave a comment.