Pyramid / Data mapping

	B	C	D	E	F	G	H
1
2	Orders
3	LNB >> Pyramid
4
5	REFERENCE
6
7	Data transfer type	Automated file transfer by FTP
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 / ORDER HEADER
13
14	Pyramid (block "1")	LNB field	LNB object	Type	Validation	Example	Comment
15	#12205	order.retailer.reference	retailer	string	Retailer identifier
16	#12211	order.order_mode	order	string	Mapped value		Default values: Preorder:"LP", Instock: "LS"
17	#12214	"PO" + order.id	order	string	Concatened value
18	#12215	order.billing_company	order	string
19	#12227	order.delivery_company	order	string
20	#12230	order.delivery_address_1	order	string
21	#12231	order.delivery_address_2	order	string
22	#12233	""	n-a	string	Empty value
23	#12236	order.delivery_zipcode	order	string
24	#12239	order.delivery_city	order	string
25	#12237	order.delivery_country	order	string
26	#12283	"1"	n-a	string	Constant value
27	#12361	order.delivery_start_week	order	string	Date (yW)
28
29
30	DATA MAPPING / ORDER LINE
31
32	Pyramid (block "11")	LNB field	LNB object	Type	Validation	Example	Comment
33	#12401	order.lines[].sku	order	string	SKU identifier
34	#12441	order.lines[].quantity	order	integer
35	#12451	order.lines[].unit_price	order	float
36	#12453	order.lines[].discount_rate	order	float
37	#12465	order.delivery_start_week	order	string	Date (yW)
38	#12466	order.delivery_start_date	order	string	Date (ymd)
39	¤3452	order line number	n-a	integer	Calculated value
40	¤3453	order.lines[].product_model	order	string
41
42
43	DATA MAPPING / ORDER COMMENT
44
45	Pyramid (block "12")	LNB field	LNB object	Type	Validation	Example	Comment
46	#12434	order.comment	order	string
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