ExactOnline / Data mapping

	A	B	C	D	E	F	G	H
1
2		Customers
3		ExactOnline >> LNB
4
5		REFERENCE
6
7		Data transfer type	API (ExactOnline)
8		Data transfer master system	Le New Black
9
10		This mapping is provided on an indicative basis and can be customised for specific customer needs.
11
12		DATA MAPPING
13
14		ExactOnline field	LNB field	LNB object	Type	Validation	Example	Comment
15	✔️	account.Name	retailer.name	retailer	string	Not empty		Commercial name
16		(TBD)	retailer.company	retailer	string			Legal name
17	✔️	account.Code	retailer.reference	retailer	string	Not empty / Retailer identifier
18		pricelist[account.Pricelist].Code	retailer.price_list.code	retailer	string	Identifiant de price list
19		account.AddressLine1	retailer.address_1	retailer	string
20		account.AddressLine2	retailer.address_2	retailer	string
21		account.Postcode	retailer.zipcode	retailer	string
22		account.City	retailer.city	retailer	string
23	✔️	account.Country	retailer.country	retailer	string	Valid ISO code / Fixed length: 2
24		account.Phone	retailer.tel	retailer	string
25		account.Fax	retailer.fax	retailer	string
26		account.AddressLine1	retailer.billing_address.address_1	retailer	string
27		account.AddressLine2	retailer.billing_address.address_2	retailer	string
28		account.Postcode	retailer.billing_address.zipcode	retailer	string
29		account.City	retailer.billing_address.city	retailer	string
30		account.Country	retailer.billing_address.country	retailer	string	Valid ISO code / Fixed length: 2
31		account.Phone	retailer.billing_address.tel	retailer	string
32		address[].ID	retailer.delivery_addresses[].address_reference	dellivery address	string	Not empty / Address identifier
33		address[].AccountName	retailer.delivery_addresses[].name	dellivery address	string
34		address[].AddressLine1	retailer.delivery_addresses[].address_1	dellivery address	string
35		address[].AddressLine2	retailer.delivery_addresses[].address_2	dellivery address	string
36		address[].Postcode	retailer.delivery_addresses[].zipcode	dellivery address	string
37		address[].City	retailer.delivery_addresses[].city	dellivery address	string
38		address[].Country	retailer.delivery_addresses[].country	dellivery address	string	Valid ISO code / Fixed length: 2
39		address[].Phone	retailer.delivery_addresses[].tel	dellivery address	string
40		account[].Email	retailer.buyers[].email	buyer	email	Not empty / Buyer identifier
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100