ApparelMagic / Data mapping

	B	C	D	E	F	G	H
1
2	Customers
3	ApparelMagic >> LNB
4
5	REFERENCE
6
7	Data transfer type	API (ApparelMagic)
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	ApparelMagic field	LNB field	LNB object	Type	Validation	Example	Comment
15	customer_name	retailer.name	retailer	string
16	account_number	retailer.reference	retailer	string	Retailer identifier
17	price_group	retailer.price_list.code	retailer	string	Price list identifier
18	address_1	retailer.address_1	retailer	string
19	address_2	retailer.address_2	retailer	string
20	postal_code	retailer.zipcode	retailer	string
21	city	retailer.city	retailer	string
22	Orgin	retailer.country	retailer	string (ISO 2 car)
23	phone	retailer.tel	retailer	string
24	fax	retailer.fax	retailer	string
25	address_1	retailer.billing_address.address_1	retailer	string
26	address_2	retailer.billing_address.address_1	retailer	string
27	postal_code	retailer.billing_address.zipcode	retailer	string
28	city	retailer.billing_address.city	retailer	string
29	country	retailer.billing_address.country	retailer	string (ISO 2 car)
30	phone	retailer.billing_address.tel	retailer	string
31	website	retailer.website	retailer	string
32	notes	retailer.follow_up	retailer	string
33	locations[].dc_reference	retailer.delivery_addresses[].address_reference	dellivery address	string	Address identifier
34	locations[].name	retailer.delivery_addresses[].name	dellivery address	string
35	locations[].address_1	retailer.delivery_addresses[].address_1	dellivery address	string
36	locations[].address_2	retailer.delivery_addresses[].address_2	dellivery address	string
37	locations[].postal_code	retailer.delivery_addresses[].zipcode	dellivery address	string
38	locations[].city	retailer.delivery_addresses[].city	dellivery address	string
39	locations[].country	retailer.delivery_addresses[].country	dellivery address	string (ISO 2 car)
40	locations[].phone	retailer.delivery_addresses[].tel	dellivery address	string
41	email	retailer.buyers[].email	buyer	email	Buyer identifier
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