-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
624 lines (319 loc) · 202 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
<html data-theme="dark" lang="en">
<head>
<title>NatchOS Importer Definitions</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no, minimum-scale=1, maximum-scale=1">
<!-- See https://minstyle.io/docs/ -->
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/minstyle.io.min.css">
<link rel="stylesheet" href="style.css">
</head>
<body>
<div class="container">
<div class="ms-alert ms-danger">
<h1>NatchOS Importer File Documentation</h1>
</div>
<p>See also <a href="https://docs.esc.be/natchOS/import_text-files">General Documentation</a></p>
<p>This document was generated at 2024-12-11 11:18.</p>
<p><a href='#BlanketOrder' class='no-underline'><span class='ms-label ms-warning'>BlanketOrder</span></a> <a href='#BlanketOrderLine' class='no-underline'><span class='ms-label ms-warning'>BlanketOrderLine</span></a> <a href='#Category' class='no-underline'><span class='ms-label ms-warning'>Category</span></a> <a href='#CategoryML' class='no-underline'><span class='ms-label ms-warning'>CategoryML</span></a> <a href='#CategoryProduct' class='no-underline'><span class='ms-label ms-warning'>CategoryProduct</span></a> <a href='#CategoryProperty' class='no-underline'><span class='ms-label ms-warning'>CategoryProperty</span></a> <a href='#CategoryVoucher' class='no-underline'><span class='ms-label ms-warning'>CategoryVoucher</span></a> <a href='#Customer' class='no-underline'><span class='ms-label ms-warning'>Customer</span></a> <a href='#CustomerCategory' class='no-underline'><span class='ms-label ms-warning'>CustomerCategory</span></a> <a href='#CustomerPhoneNumber' class='no-underline'><span class='ms-label ms-warning'>CustomerPhoneNumber</span></a> <a href='#CustomerPrice' class='no-underline'><span class='ms-label ms-warning'>CustomerPrice</span></a> <a href='#CustomerProduct' class='no-underline'><span class='ms-label ms-warning'>CustomerProduct</span></a> <a href='#CustomerSalesPerson' class='no-underline'><span class='ms-label ms-warning'>CustomerSalesPerson</span></a> <a href='#Document' class='no-underline'><span class='ms-label ms-warning'>Document</span></a> <a href='#DocumentLine' class='no-underline'><span class='ms-label ms-warning'>DocumentLine</span></a> <a href='#EntityExternalData' class='no-underline'><span class='ms-label ms-warning'>EntityExternalData</span></a> <a href='#EntityFile' class='no-underline'><span class='ms-label ms-warning'>EntityFile</span></a> <a href='#EntityStore' class='no-underline'><span class='ms-label ms-warning'>EntityStore</span></a> <a href='#Person' class='no-underline'><span class='ms-label ms-warning'>Person</span></a> <a href='#PersonPhoneNumber' class='no-underline'><span class='ms-label ms-warning'>PersonPhoneNumber</span></a> <a href='#Product' class='no-underline'><span class='ms-label ms-warning'>Product</span></a> <a href='#ProductML' class='no-underline'><span class='ms-label ms-warning'>ProductML</span></a> <a href='#ProductMeasurement' class='no-underline'><span class='ms-label ms-warning'>ProductMeasurement</span></a> <a href='#ProductOverpack' class='no-underline'><span class='ms-label ms-warning'>ProductOverpack</span></a> <a href='#ProductOverpackML' class='no-underline'><span class='ms-label ms-warning'>ProductOverpackML</span></a> <a href='#ProductPropertyValue' class='no-underline'><span class='ms-label ms-warning'>ProductPropertyValue</span></a> <a href='#ProductRelation' class='no-underline'><span class='ms-label ms-warning'>ProductRelation</span></a> <a href='#ProductSurcharge' class='no-underline'><span class='ms-label ms-warning'>ProductSurcharge</span></a> <a href='#Property' class='no-underline'><span class='ms-label ms-warning'>Property</span></a> <a href='#PropertyML' class='no-underline'><span class='ms-label ms-warning'>PropertyML</span></a> <a href='#PropertyValue' class='no-underline'><span class='ms-label ms-warning'>PropertyValue</span></a> <a href='#PropertyValueML' class='no-underline'><span class='ms-label ms-warning'>PropertyValueML</span></a> <a href='#ShippingAddress' class='no-underline'><span class='ms-label ms-warning'>ShippingAddress</span></a> <a href='#ShippingAddressPhoneNumber' class='no-underline'><span class='ms-label ms-warning'>ShippingAddressPhoneNumber</span></a> <a href='#Voucher' class='no-underline'><span class='ms-label ms-warning'>Voucher</span></a> <a href='#VoucherML' class='no-underline'><span class='ms-label ms-warning'>VoucherML</span></a> <a href='#WarehouseProduct' class='no-underline'><span class='ms-label ms-warning'>WarehouseProduct</span></a> <a href='#WebRoleCustomerPerson' class='no-underline'><span class='ms-label ms-warning'>WebRoleCustomerPerson</span></a> <a href='#WebRolePerson' class='no-underline'><span class='ms-label ms-warning'>WebRolePerson</span></a> </p>
<div style='page-break-before: always;' id='BlanketOrder' class='ms-alert ms-info'><h1>BlanketOrder</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAddressCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>BlanketOrderCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>BlanketOrderName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>StartDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>EndDate</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>StoreID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>ContactPersonCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='BlanketOrderLine' class='ms-alert ms-info'><h1>BlanketOrderLine</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>BlanketOrderCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>InitialQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>RemainingQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>DeliveredQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>ToBeDeliveredQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>InvoicedQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnbilledQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitPrice</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OverpackCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OverpackCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>If `OverpackCode` is supplied, all quantities represent the number of overpacks.<br/>Otherwise quantities represent the `SalesUnitOfMeasureCode` of the product.<br/></p></div></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='Category' class='ms-alert ms-info'><h1>Category</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CategoryTypeCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CategoryCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ParentCategoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>InternalName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>InternalDescription</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>512</td></tr><tr><td class='ms-text-left'>Level</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OrigOrderValue</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>AutoCompleteWeight</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Online</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CategoryTypeCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The type of the category structure, e.g. NAVIGATION or BRAND.<br/>Predefined by Natch as a readonly category at the root (level 0).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ParentCategoryCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The code of the parent category.<br/>Will contain the `CategoryTypeCode` for categories at highest level or non hierarchical structure.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Level</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The level of the category in the tree, starting at value `1`.<br/>If the structure is not hierarchical, use value `1`.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OrigOrderValue</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Defines the order in which the categories under a node are placed.<br/>This is a text field, sorting is alphabetical.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>AutoCompleteWeight</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The optional weight of the category to calculate the score in search results of the generic autocomplete.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CategoryML' class='ms-alert ms-info'><h1>CategoryML</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CategoryTypeCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CategoryCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CategoryName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>CategoryDescription</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>512</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MiscML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Synonymlist</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Synonymlist</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>A list of semicolon-separated synonyms for this category, for this language.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>Synonyms</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CategoryProduct' class='ms-alert ms-info'><h1>CategoryProduct</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CategoryTypeCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CategoryCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr><tr><td class='ms-text-left'>Miscellaneous</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CategoryTypeCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The type of the category structure, e.g. NAVIGATION or BRAND.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Misc</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Use JSON in `Miscellaneous` instead. JSON support was added in November 2022.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/>Contact us for more information regarding this change because it might have impact on your implementation.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CategoryProperty' class='ms-alert ms-info'><h1>CategoryProperty</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CategoryCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PropertyCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>IsVisible</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>IsFilter</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>IsSearchable</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bool</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OrderValue</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PropertyFilterTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>IsVisible</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>If true, property is visible in listed properties of product for this category.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>IsFilter</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>If true, property can be used in the asset-filter when this category is selected.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>IsSearchable</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>If true, this field should be included in the search index (e.g. Full-Text Search in SQL or Azure Search).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OrderValue</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Sort-order of the property for a product under this category.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PropertyFilterTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Filter type of the property:<br/>- `1`: Intersect --> evaluated as an `AND` operator within the property values; selecting more options within the property may reduce results<br/>- `2`: Union --> evaluated as an `OR` operator within the property values; selecting more options within the property may increase results<br/>- `3`: Range --> property can be filtered as a range of numerical values, defining minimum and/or maximum<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> </p><p><h6>Default</h6><span class='ms-label ms-medium'>1</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CategoryVoucher' class='ms-alert ms-info'><h1>CategoryVoucher</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CategoryTypeCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CategoryCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>VoucherCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='Customer' class='ms-alert ms-info'><h1>Customer</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Name</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>SearchName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>Name2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>AddressLine1</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>AddressLine2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ZipCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>City</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>TerritoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CountyCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Country_ISO</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>SpatialLocation</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>40</td></tr><tr><td class='ms-text-left'>PhoneNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr><tr><td class='ms-text-left'>FaxNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr><tr><td class='ms-text-left'>OurAccountNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CreditLimit</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>CustomerPriceGroupCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PaymentTermCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Currency_ISO</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>3</td></tr><tr><td class='ms-text-left'>CustomerDiscountCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Blocked</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>NbrOfInvoiceCopies</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>BillToCustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PriorityLevel</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PaymentMethodCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShowPricesIncVAT</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>DepartmentCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>VATRegistrationNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr><tr><td class='ms-text-left'>RequestedVATRegistrationNo</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>VATRegimeCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>LegalFormCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CombineInvoices</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Email</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>Homepage</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>255</td></tr><tr><td class='ms-text-left'>PrimaryContactPersonCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ResponsibilityCenterCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>AllowLineDiscount</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PreferredBankAccountCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>DomiciliationNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>SectorCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>VisitFrequencyCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CustomerShopStatus</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>TemporaryCustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CustomerTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Credit</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Miscellaneous</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Country_ISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/>More info at [www.iso.org](https://www.iso.org/iso-3166-country-codes.html).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SpatialLocation</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Coordinates in `latitude,longitude` format with `.` as decimal point, e.g. `51.09644,3.83194`<br/>for Lochristi, Belgium.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PhoneNo</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Telephone numbers must be sent in a separate file.<br/><br/>If you are currently not sending any data in this field or are already sending a separate file, you can safely remove this field.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>FaxNo</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Telephone numbers must be sent in a separate file.<br/><br/>If you are currently not sending any data in this field or are already sending a separate file, you can safely remove this field.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Currency_ISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Alphabetic ISO 4217 three-letter code, e.g. `EUR` for Euro and `GBP` for Pound Sterling.<br/>More info at [www.iso.org](https://www.iso.org/iso-4217-currency-codes.html).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ShowPricesIncVAT</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>PricesIncVat</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CustomerShopStatus</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>CustomerShopStatusCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TemporaryCustomerCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The temporary code of the record as created by NatchOS before sending to master data.<br/>This code must be sent back to update data accordingly.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>TemporaryCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CustomerTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Default: `1` = Owner of the site, `2` = Normal Customer.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Credit</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>JSON representation of the credit information.<br/><br/>Contains a list of `creditLimits` defined as time-based total amount and/or single basket amount:<br/><br/>- `limitAction` [values: `Approval` or `Block`] (required)<br/>- `periodUnit` [`D`, `W`, `M` or `Y`], `periodCount`, `periodMaximumAmount` (optional as a set, all required if any field specified)<br/>- `basketMaximumAmount` (optional)<br/>- `personCode` (optional)<br/><br/>Optional custom data can be added as `customData` to the root or in the individual items. Example of the value:<br/>```<br/>{"creditLimits":[{"periodUnit": "D","periodCount": 9,"limitAction":"Approval","periodMaximumAmount": 15000.0,"basketMaximumAmount": 1000.0,"personCode": "KHIUH569","customData": null}],"customData": null}<br/>```<br/><br/>Make sure the field uses the recommended text qualifier around the value and characters are escaped (i.e. double quotes must be escaped if using the default text qualifier).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Misc</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Use JSON in `Miscellaneous` instead. JSON support was added in March 2023.<br/><br/>If you are currently not sending any data in this field, you can safely remove it. Contact us for more information regarding this change because it might have impact on your implementation.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CustomerCategory' class='ms-alert ms-info'><h1>CustomerCategory</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CategoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CustomerPhoneNumber' class='ms-alert ms-info'><h1>CustomerPhoneNumber</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PhoneNumberTypeID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PhoneNumber</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PhoneNumberTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Values: `1` = phone; `2` = fax; `3` = mobile.<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CustomerPrice' class='ms-alert ms-info'><h1>CustomerPrice</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>UnitPrice</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MinimumUnits</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CustomerProduct' class='ms-alert ms-info'><h1>CustomerProduct</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CustomerProductCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Ordered</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Favorite</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>AvailableTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>byte</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CustomerProductCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Alternate product number by which the customer knows the product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Ordered</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>*Replaced by data in `DocumentLine`. NatchOS can now automatically infer this from document data. Field has been marked obsolete in November 2023.*<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/><br/>Indicates whether the product was previously bought by the customer. Documents can also be used for this.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Favorite</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>*Master data should not control the favorites per customer. Field has been marked obsolete in November 2023. *<br/><br/>The implementation takes care of storing favorites per person.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div><p><h6>Default</h6><span class='ms-label ms-medium'>0</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>AvailableTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Indicates the availability of a product for the given customer.<br/>- `0`: Not available.<br/>- `1`: Is available.<br/>- `3`: Exclusively available for customers with this value; implicitly not available for other customers.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='CustomerSalesPerson' class='ms-alert ms-info'><h1>CustomerSalesPerson</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PersonCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>OfficeStaff</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MainSalesPerson</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>StoreID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OfficeStaff</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Use 1 for internal/backoffice, 0 for external.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>MainSalesPerson</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Only one person can be set as main salesperson per customer.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>StoreID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Required for multi-store environments.<br/></p></div><p><h6>Default</h6><span class='ms-label ms-medium'>1</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='Document' class='ms-alert ms-info'><h1>Document</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>DocumentHeaderCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>DocumentTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>AmountExcVAT</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>AmountIncVAT</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>SellToCustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>SellToCustomerName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>SellToCustomerName2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>SellToCustomerEmail</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>SellToCustomerLCID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>SellToCustomerAddressLine1</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>SellToCustomerAddressLine2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>SellToCustomerZipCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>SellToCustomerCity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>SellToCustomerTerritoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>SellToCustomerCountyCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>SellToCustomerCountryISO</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>SellToCustomerSpatialLocation</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>40</td></tr><tr><td class='ms-text-left'>SellToCustomerContactName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>VATRegistrationNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr><tr><td class='ms-text-left'>BillToCustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>BillToCustomerName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>BillToCustomerName2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>BillToCustomerEmail</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>BillToCustomerLCID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>BillToCustomerAddressLine1</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>BillToCustomerAddressLine2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>BillToCustomerZipCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>BillToCustomerCity</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>BillToCustomerTerritoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>BillToCustomerCountyCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>BillToCustomerCountryISO</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>BillToCustomerSpatialLocation</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>40</td></tr><tr><td class='ms-text-left'>BillToCustomerContactName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>ShippingAddressCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAddressName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>ShippingAddressName2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>ShippingAddressEmail</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>ShippingAddressLCID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>ShippingAddressAddressLine1</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ShippingAddressAddressLine2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ShippingAddressZipCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>ShippingAddressCity</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ShippingAddressTerritoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAddressCountyCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAddressCountryISO</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>ShippingAddressSpatialLocation</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>40</td></tr><tr><td class='ms-text-left'>ShippingAddressContactName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>ShippingMethodCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAdviceCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ExternalReference</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>InternalComment</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>500</td></tr><tr><td class='ms-text-left'>ExternalComment</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>500</td></tr><tr><td class='ms-text-left'>DocumentDate</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>DocumentTime</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>8</td></tr><tr><td class='ms-text-left'>PaymentTermCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PaymentMethodCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>IncoTerm</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CurrencyFactor</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>CurrencyISO</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>3</td></tr><tr><td class='ms-text-left'>CreatorPersonCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>SalesPersonCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ContactMethodCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ContactMethodDocumentNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>40</td></tr><tr><td class='ms-text-left'>RequestedDeliveryDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>PromisedDeliveryDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>DepartmentCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>SeparateInvoice</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>DocumentStatusCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Open</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>QuoteEndDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>OrderTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OrderDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>OrderTime</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>8</td></tr><tr><td class='ms-text-left'>ShipmentDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>ShipmentTime</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>8</td></tr><tr><td class='ms-text-left'>PaymentDiscountPercent</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>DueDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>InvoiceTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>StoreID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>TrackTrace</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>TransferTypeCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>TransferSubTypeCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>DocumentTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Supported values:<br/>- `1` = Quote<br/>- `2` = Order<br/>- `3` = Shipment<br/>- `4` = Invoice<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> <span class='ms-label ms-medium'>4</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SellToCustomerCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Field has been marked required in January 2024.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SellToCustomerLCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SellToCustomerCountryISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/>More info at [www.iso.org](https://www.iso.org/iso-3166-country-codes.html).<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>SellToCustomerCountryIso</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SellToCustomerSpatialLocation</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Coordinates in `latitude,longitude` format with `.` as decimal point, e.g. `51.09644,3.83194` for Lochristi, Belgium.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>BillToCustomerLCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>BillToCustomerAddressLine1</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>BillToAddressLine1</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>BillToCustomerAddressLine2</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>BillToAddressLine2</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>BillToCustomerCountryISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>BillToCustomerCountryIso</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>BillToCustomerSpatialLocation</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Coordinates in `latitude,longitude` format with `.` as decimal point, e.g. `51.09644,3.83194` for Lochristi, Belgium.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ShippingAddressLCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ShippingAddressCountryISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>ShippingAddressCountryIso</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ShippingAddressSpatialLocation</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Coordinates in `latitude,longitude` format with `.` as decimal point, e.g. `51.09644,3.83194` for Lochristi, Belgium.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ShippingAdviceCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Supported values:<br/>- `complete` = complete order<br/>- `completeorderlines` = complete per orderline<br/>- `partial` = partial orderlines allowed<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>IncoTerm</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>A series of three-letter trade terms Incoterms rules.<br/>International Commercial terms are a series of pre-defined commercial terms published by the<br/>International Chamber of Commerce widely used in international commercial transactions.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CurrencyISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Alphabetic ISO 4217 three-letter code, e.g. `EUR` for Euro and `GBP` for Pound Sterling.<br/>More info at [www.iso.org](https://www.iso.org/iso-4217-currency-codes.html).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SeparateInvoice</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>SeperateInvoice</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>DocumentStatusCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for document type `order`.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>QuoteEndDate</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for document type `quote`.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OrderTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for document type `order`.<br/>Supported values:<br/>- `1` = Normal<br/>- `2` = Return<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OrderDate</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for document type `order`.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ShipmentDate</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for document type `shipment`.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>DueDate</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for document type `invoice`.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>InvoiceTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for document type `invoice`.<br/>Supported values:<br/>- `1` = Invoice<br/>- `2` = Credit note<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>StoreID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Required** for multi-store environments.<br/></p></div><p><h6>Default</h6><span class='ms-label ms-medium'>1</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TrackTrace</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>JSON representation of the track and trace information. Contains a list of `tracking` defined as<br/>`trackingNumber` (required) and either `shippingAgent` or `url` for direct link. Optional custom data can be<br/>added as `customData` to the root or in the individual tracking items. Example of the value:<br/>```<br/>{"tracking":[{"trackingNumber":"123456","shippingAgent":"UPS","url":"https://www.ups.com/?12345789","customData":null}],"customData":null}<br/>```<br/>Make sure the field uses the recommended text qualifier around the value and characters are escaped (i.e. double quotes must be escaped if using the default text qualifier).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='DocumentLine' class='ms-alert ms-info'><h1>DocumentLine</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>DocumentHeaderCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>DocumentTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LineNo</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>AttachedToLineNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LineType</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>ProductNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>VariantProductCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CustomerProductCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>EAN</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>MainVendorProductNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ProducerProductNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ShipmentDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>ShipmentTime</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>8</td></tr><tr><td class='ms-text-left'>ProductName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>Comment</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>UnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>QuantityPerUnitOfMeasure</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Quantity</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OutstandingQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>QuantityToInvoice</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>QuantityToShip</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitPriceIncVAT</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitPriceExcVAT</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>VATPercent</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LineDiscountPercent</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LineDiscountAmount</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LineAmountExcVAT</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LineAmountIncVAT</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>GrossWeight</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>NetWeight</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>WeightUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Volume</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>VolumeUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>RequestedDeliveryDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>PromisedDeliveryDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>PlannedDeliveryDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>PlannedShipmentDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>DepartmentCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>DocumentStatusCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>TrackTrace</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>DocumentTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Supported values:<br/>- `1` = Quote<br/>- `2` = Order<br/>- `3` = Shipment<br/>- `4` = Invoice<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> <span class='ms-label ms-medium'>4</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>DocumentStatusCode</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>DocumentLineStatusCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TrackTrace</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>JSON representation of the track and trace information. Contains a list of `tracking` defined as<br/>`trackingNumber` (required) and either `shippingAgent` or `url` for direct link. Optional custom data can be<br/>added as `customData` to the root or in the individual tracking items. Example of the value:<br/>```<br/>{"tracking":[{"trackingNumber":"123456","shippingAgent":"UPS","url":"https://www.ups.com/?12345789","customData":null}],"customData":null}<br/>```<br/>Make sure the field uses the recommended text qualifier around the value and characters are escaped (i.e. double quotes must be escaped if using the default text qualifier).<br/></p></div></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='EntityExternalData' class='ms-alert ms-info'><h1>EntityExternalData</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>EntityCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ExternalSourceID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>EntityCode</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>CategoryCode</span> <span class='ms-label ms-medium'>CustomerCode</span> <span class='ms-label ms-medium'>DocumentHeaderCode</span> <span class='ms-label ms-medium'>PersonCode</span> <span class='ms-label ms-medium'>ProductCode</span> <span class='ms-label ms-medium'>WarehouseCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/>Can be used to specify both a local specific record or a neutral record without LCID.<br/>If there is no record for a specific LCID, NatchOS will fall back to the record without LCID.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='EntityFile' class='ms-alert ms-info'><h1>EntityFile</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>EntityCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>FilePath</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>FileName</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1024</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>EntityCode</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>CategoryCode</span> <span class='ms-label ms-medium'>CustomerCode</span> <span class='ms-label ms-medium'>DocumentHeaderCode</span> <span class='ms-label ms-medium'>PersonCode</span> <span class='ms-label ms-medium'>ProductCode</span> <span class='ms-label ms-medium'>WarehouseCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>FilePath</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>This determines the file type and must be a known value within NatchOS, configured by Natch.<br/><br/>_Value as Path_<br/>Must start with `\`.<br/>The value is used to create the absolute URL from the relative URL.<br/>Can match a container name in Azure Blob Storage or a bucket name in Amazon S3.<br/>E.g. `\categoryimage`, `\productimage`, `\product-high-resolution`<br/><br/>_Value as Type_<br/>Value does not start with `\`.<br/>The value is only used to indicate/match a type in NathOS.<br/>Will not be used to create the absolute URL - the `URL` field must contain absolute URL.<br/>E.g. `ProductManualLink`.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>FileType</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>FileName</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**A relative or absolute `URL` to the file.**<br/><br/>_Relative_<br/>A path relative to the `FilePath\FileType`.<br/>The value will be prefixed with `Origin` and `FilePath` to construct the absolute URL.<br/>The `Origin` itself is configured in the application.<br/><br/>Examples (using `\categoryimage` as `FilePath\FileType`):<br/>- `/segment-a/x123987.jpg` > `https://natchcloud.com/categoryimage/segment-a/x123987.jpg`<br/>- `/x123987.jpg` > `https://natchcloud.com/categoryimage/x123987.jpg`<br/><br/>_Absolute_<br/>A complete URL, including the origin. The value will be used as-is.<br/>E.g. `https://pim.natch.be/products/thumbnails/x123987.jpg`<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>URL</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The optional locale identifier for the file, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Misc</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Can be used to specify the order in which images or files must be displayed.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='EntityStore' class='ms-alert ms-info'><h1>EntityStore</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>EntityCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>StoreID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Product_TransportCost</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Product_MinimumAmountFreeShipping</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Product_TransferLeadTimeInDays</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Product_PromoTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Miscellaneous</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>EntityCode</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>ProductCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Product_TransportCost</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The transport cost for this product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Product_PromoTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the ID of a promotion type as defined in the metadata.<br/><br/>Values supported by NatchOS:<br/>- `1` = promotion<br/>- `2` = liquidation<br/>- `3` = spotlight<br/>- `4` = bestseller<br/>- `5` = new product<br/><br/>Custom types should have a value greater than 100.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='Person' class='ms-alert ms-info'><h1>Person</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAddressCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PersonCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>FirstName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>MiddleName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>SurName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>SearchName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>NickName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>AddressLine1</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>AddressLine2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ZipCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>City</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>TerritoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CountyCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Country_ISO</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>SpatialLocation</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>40</td></tr><tr><td class='ms-text-left'>Email</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>Email2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>Homepage</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>255</td></tr><tr><td class='ms-text-left'>SalesPersonCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Comment</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>JobTitle</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>OrganizationLevelCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>SalutationCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Initials</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr><tr><td class='ms-text-left'>Gender</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>Login</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>WebRoleCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>TemporaryPersonCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CustomerCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The customer that the person is attached to.<br/><br/>This field was marked optional in December 2023.<br/>Consider the entity `WebRoleCustomerPerson` for linking a person to a customer (which support a multi-customer setup).<br/>If you are currently not sending any data in this field and using a separate file, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>AddressLine1</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Part of address field set. Required if another field in the set is supplied.**<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>AddressLine2</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Part of address field set. Optional.**<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ZipCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Part of address field set. Required if another field in the set is supplied.**<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>City</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Part of address field set. Required if another field in the set is supplied.**<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TerritoryCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Part of address field set. Optional.**<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CountyCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Part of address field set. Optional.**<br/>Code for a geographical region of a country.<br/>Not to be confused with country.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Country_ISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>**Part of address field set. Required if another field in the set is supplied.**<br/>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/>More info at [www.iso.org](https://www.iso.org/iso-3166-country-codes.html).<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>CountryISO</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SpatialLocation</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Coordinates in `latitude,longitude` format with `.` as decimal point, e.g. `51.09644,3.83194` for Lochristi, Belgium.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Gender</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>F</span> <span class='ms-label ms-medium'>Female</span> <span class='ms-label ms-medium'>M</span> <span class='ms-label ms-medium'>Male</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>WebRoleCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>A single web role code.<br/><br/>This field was marked optional in December 2023.<br/>Instead of a single code, we recommend the `WebRoleCustomerPerson.txt` file (previously `WebRolePerson.txt`) with support for many-to-many combinations.<br/>If you are currently not sending any data in this field and using a separate file, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TemporaryPersonCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The temporary code of the record as created by NatchOS before sending to master data.<br/>This code must be sent back to update data accordingly.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>TemporaryCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='PersonPhoneNumber' class='ms-alert ms-info'><h1>PersonPhoneNumber</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>PersonCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PhoneNumberTypeID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PhoneNumber</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PhoneNumberTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Values: `1` = phone; `2` = fax; `3` = mobile.<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='Product' class='ms-alert ms-info'><h1>Product</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>InternalName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>IsModelProduct</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>BaseUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductDiscountGroupCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>AllowInvoiceDiscount</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitPrice</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitCost</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>SizeCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Size</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>SizeUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ColorCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>MainVendorCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>MainVendorProductNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>EAN</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>ProducerProductNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>LeadTimeCalculation</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MOQ</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>IOQ</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitListPrice</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>GrossWeight</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>GrossWeightUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>NetWeight</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>NetWeightUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>UnitVolume</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitVolumeUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Durability</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>15</td></tr><tr><td class='ms-text-left'>TariffNo</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>CountryPurchased_ISO</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>CountryOrigine_ISO</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>Online</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>VATBusinessPostingGroupCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>SalesUnitofMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PriceOnRequest</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PromoTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>byte</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Product_TransportCost</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Product_MinimumAmountFreeShipping</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Product_TransferLeadTimeInDays</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>ConfigurableTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>BaseUnitOfMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the code of a unit of measure as defined in the metadata.<br/><br/>This data should be sent in the `PropertyValue` file instead.<br/>Contact us for more information regarding this change.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SizeCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the code of a size as defined in the metadata.<br/>I.e. sizes of a t-shirt: `XS`, `S`, `M`, `L`, `XL`.<br/><br/>Alternatively, a size can be specified as a measurement with a decimal value and a unit of measure.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Size</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>This data should be sent in the `PropertyValue` file instead.<br/>Contact us for more information regarding this change.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SizeUnitOfMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>This data should be sent in the `PropertyValue` file instead.<br/>Contact us for more information regarding this change.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ColorCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the code of a color as defined in the metadata.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>EAN</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The EAN-13 barcode digits. An EAN-13 barcode (originally European Article Number, but now<br/>renamed International Article Number even though the abbreviation EAN has been retained) is a 13 digit<br/>(12 data and 1 check) barcoding standard.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LeadTimeCalculation</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The average delivery time in days for the main vendor for this product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>GrossWeight</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>This data should be sent in the `PropertyValue` file instead.<br/>Contact us for more information regarding this change.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>GrossWeightUnitOfMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the code of a unit of measure as defined in the metadata.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>NetWeight</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>This data should be sent in the `PropertyValue` file instead.<br/>Contact us for more information regarding this change.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>NetWeightUnitOfMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the code of a unit of measure as defined in the metadata.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>UnitVolume</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>This data should be sent in the `PropertyValue` file instead.<br/>Contact us for more information regarding this change.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>UnitVolumeUnitOfMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the code of a unit of measure as defined in the metadata.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Durability</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Contains the format of an xsd duration type without the time part (max = 100 years). Fex 'P0Y3M20D' = 3 months, 20 days.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TariffNo</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Intrastat code of the product. Intrastat is the system for collecting information and producing statistics on the trade in goods between countries of the European Union (EU).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CountryPurchased_ISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/>More info at [www.iso.org](https://www.iso.org/iso-3166-country-codes.html).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CountryOrigine_ISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/>More info at [www.iso.org](https://www.iso.org/iso-3166-country-codes.html).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SalesUnitofMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>This data should be sent in the `PropertyValue` file instead.<br/>Contact us for more information regarding this change.<br/><br/>If you are currently not sending any data in this field, you can safely remove it.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PromoTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Specify the ID of a promotion type as defined in the metadata.<br/><br/>Values supported by NatchOS:<br/>- `1` = promotion<br/>- `2` = liquidation<br/>- `3` = spotlight<br/>- `4` = bestseller<br/>- `5` = new product<br/><br/>Custom types should have a value greater than 100.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Product_TransportCost</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The transport cost for this product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ProductML' class='ms-alert ms-info'><h1>ProductML</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>ProductSearchName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>FreightType</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>ProductDescription</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Comment</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>Synonyms</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MiscML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ProductMeasurement' class='ms-alert ms-info'><h1>ProductMeasurement</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>MeasurementTypeID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>UnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Amount</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>MeasurementTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Values supported by NatchOS:<br/><br/>- `1`: Base Unit - Unit in which the product is stored (inventory). Requires only the unit of measure.<br/>- `2`: Size - Measurement for a generic size/dimension of the product. Requires both the unit of measure and a value.<br/>- `3`: Gross Weight - Measurement for the gross weight of the product. Requires both the unit of measure and a value.<br/>- `4`: Net Weight - Measurement for the net weight of the product. Requires both the unit of measure and a value.<br/>- `5`: Sales Unit - Unit in which the product is sold. Requires only the unit of measure.<br/>- `6`: Volume - Measurement for the volume of the product. Requires both the unit of measure and a value.<br/>- `7`: Overpack Volume - Measurement for the volume of an overpack of the product. Requires both the unit of measure and a value.<br/>- `8`: Overpack Weight - Measurement for the weight of an overpack of the product. Requires both the unit of measure and a value.<br/>- `9`: Size Length - Measurement for the length of the product. Requires both the unit of measure and a value.<br/>- `10`: Size Width - Measurement for the width of the product. Requires both the unit of measure and a value.<br/>- `11`: Size Height - Measurement for the height of the product. Requires both the unit of measure and a value.<br/>- `12`: Overpack Unit - Unit of one overpack. Requires only the unit of measure.<br/>- `13`: Items per Sales Unit - Describes how many items are contained in a single sales unit. Requires both the unit of measure and a value. (I.e. Number of blisters in one package. Product is sold per package.)<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> <span class='ms-label ms-medium'>4</span> <span class='ms-label ms-medium'>5</span> <span class='ms-label ms-medium'>6</span> <span class='ms-label ms-medium'>7</span> <span class='ms-label ms-medium'>8</span> <span class='ms-label ms-medium'>9</span> <span class='ms-label ms-medium'>10</span> <span class='ms-label ms-medium'>11</span> <span class='ms-label ms-medium'>12</span> <span class='ms-label ms-medium'>13</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>UnitOfMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The code of the unit of measure.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Amount</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The value for the measurement. This is required for some measurement types.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>Value</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ProductOverpack' class='ms-alert ms-info'><h1>ProductOverpack</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>OverpackCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>InternalName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>OverpackWeight</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OverpackWeightUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>OverpackVolume</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OverpackVolumeUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>UnitsPerPack</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OverpackUnitUnitOfMeasureCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Miscellaneous</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>UnitsPerPack</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The number of unit in the overpack.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OverpackUnitUnitOfMeasureCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The unit for the `UnitsPerPack` value.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Misc</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Use JSON in `Miscellaneous` instead. JSON support was added in September 2023.<br/><br/>If you are currently not sending any data in this field, you can safely remove it. Contact us for more information regarding this change because it might have impact on your implementation.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ProductOverpackML' class='ms-alert ms-info'><h1>ProductOverpackML</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>OverpackCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>OverpackName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>OverpackDescription</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MiscML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>MiscellaneousML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>4000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>MiscML</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Use JSON in `MiscellaneousML` instead. JSON support was added in September 2023.<br/><br/>If you are currently not sending any data in this field, you can safely remove it. Contact us for more information regarding this change because it might have impact on your implementation.<br/></p></div></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ProductPropertyValue' class='ms-alert ms-info'><h1>ProductPropertyValue</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PropertyCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PropertyValueCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PropertyValueCode</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>Value1</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ProductRelation' class='ms-alert ms-info'><h1>ProductRelation</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode1</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductRelationType</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr><tr><td class='ms-text-left'>ProductCode2</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>StartDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>StopDate</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>Ratio</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ProductCode1</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The origin product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ProductRelationType</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'><br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ProductCode2</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The related product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>StartDate</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Required for time-bound relations (`TemporaryHasAlternative`). Must be empty for other relations.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>StopDate</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Required for time-bound relations (`TemporaryHasAlternative`). Must be empty for other relations.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Ratio</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The optional count of related product for every origin product.<br/>I.e. A value of `2` for a `MandatoryIncludes` relation specifies that the related product must be bought 2x for every origin product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ProductSurcharge' class='ms-alert ms-info'><h1>ProductSurcharge</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductSurchargeTypeID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>ProductSurchargeQuantity</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>smallint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>ProductSurchargePrice</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Miscellaneous</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>json</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ProductSurchargeTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Type of surcharge. e.g. 1 is Bebat, 2 is Recupel.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ProductSurchargeQuantity</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Multiplier for the `ProductSurchargePrice`, e.g. four batteries per product.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ProductSurchargePrice</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Price for a single surcharge, e.g. for one battery.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='Property' class='ms-alert ms-info'><h1>Property</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>PropertyCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>InternalName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>PropertyValueTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PropertyFilterTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>IsVisible</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>IsFilter</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>IsSearchable</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bool</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>OrderValue</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PropertyClassCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>InternalName</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Internal name of the property. Is used as display text if no translations are provided.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PropertyValueTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Data type of the value of the property:<br/><br/>- `1`: Textual value<br/>- `2`: Numerical value, integer or decimal<br/>- `4`: Boolean value, simple true/false<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>4</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PropertyFilterTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Filter type of the property:<br/><br/>- `1`: Intersect --> evaluated as an `AND` operator within the property values; selecting more options<br/>within the property may reduce results.<br/>- `2`: Union --> evaluated as an `OR` operator within the property values; selecting more options within<br/>the property may increase results.<br/>- `3`: Range --> property can be filtered as a range of numerical values, defining minimum and/or<br/>maximum.<br/><br/>Supported in our latest search engine.<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>IsVisible</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>If true, property is visible in listed properties of product.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>ShowAsProductSpecification</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>IsFilter</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>If true, property will be available as facet filter for product search.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>UseAsFilter</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>IsSearchable</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>If true, the `TextValueML` or `TextValue` of the `PropertyValue` will be included in the search<br/>index.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>OrderValue</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Sort order of the property for a product.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>IncludeInSearchIndex</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PropertyClassCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Code of the class to which the property belongs.<br/><br/>Example: 'Measurements'.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='PropertyML' class='ms-alert ms-info'><h1>PropertyML</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>PropertyCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PropertyName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>128</td></tr><tr><td class='ms-text-left'>PropertyDescription</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>512</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MiscML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='PropertyValue' class='ms-alert ms-info'><h1>PropertyValue</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>PropertyCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PropertyValueCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>TextValue</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>NumericValue</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PropertyValueCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Code of the property value. This should be unique across all property value records.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TextValue</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Display text of the property value.<br/><br/>For properties defined as text: This value is used if no translations are provided via `PropertyValueML`<br/>entity.<br/><br/>For properties defined as numeric: This is used for display and optionally for inclusion in search index<br/>(see property definition), e.g. '10 cm' as text value and '10' as numeric value.<br/><br/>For properties defined as boolean: This must contains one of the follow values: `1`, `true`, `0`,<br/>`false`.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>NumericValue</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Numerical value for the property.<br/><br/>Required if the value type of the property is numeric.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='PropertyValueML' class='ms-alert ms-info'><h1>PropertyValueML</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>PropertyCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PropertyValueCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>TextValueML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>1000</td></tr><tr><td class='ms-text-left'>MiscML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>10000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ShippingAddress' class='ms-alert ms-info'><h1>ShippingAddress</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ShippingAddressCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>MainShippingAddress</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Name</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>SearchName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>Name2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>AddressLine1</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>AddressLine2</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ZipCode</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>20</td></tr><tr><td class='ms-text-left'>City</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>TerritoryCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CountyCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Country_ISO</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>2</td></tr><tr><td class='ms-text-left'>SpatialLocation</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>40</td></tr><tr><td class='ms-text-left'>PrimaryContactPersonCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingMethodCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAgentCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAgentServiceCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingAdviceCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ShippingTimeInDays</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PrintPriceOnShippingDocument</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>DepartmentCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PlaceOfExport</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Email</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>320</td></tr><tr><td class='ms-text-left'>Homepage</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>255</td></tr><tr><td class='ms-text-left'>CombineShippings</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>TemporaryShippingAddressCode</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Misc</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>xml</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Country_ISO</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The two-letter ALPHA-2 ISO 3166 notation of the country code.<br/>More info at [www.iso.org](https://www.iso.org/iso-3166-country-codes.html).<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>SpatialLocation</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Coordinates in `latitude,longitude` format with `.` as decimal point, e.g. `51.09644,3.83194` for Lochristi, Belgium.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ShippingAdviceCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Values supported by NatchOS:<br/><br/>- `complete` = complete order<br/>- `completeorderlines` = complete per orderline<br/>- `partial` = partial orderlines allowed<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Homepage</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>HomePage</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>CombineShippings</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>CombineShipments</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>TemporaryShippingAddressCode</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The temporary code of the record as created by NatchOS before sending to master data.<br/>This code must be sent back to update data accordingly.<br/></p></div><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>TemporaryCode</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='ShippingAddressPhoneNumber' class='ms-alert ms-info'><h1>ShippingAddressPhoneNumber</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>ShippingAddressCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PhoneNumberTypeID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>PhoneNumber</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>50</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>PhoneNumberTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Values: `1` = phone; `2` = fax; `3` = mobile.<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> <span class='ms-label ms-medium'>3</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='Voucher' class='ms-alert ms-info'><h1>Voucher</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>VoucherCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>InternalName</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>Description</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Identification</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>ValidFrom</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>ValidUntil</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>DiscountPercent</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>DiscountAmount</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MaxDiscountValue</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MinimumValue</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>VoucherLimitTypeID</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>tinyint</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MaxAmount</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Combinable</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>bit</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Miscellaneous</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>4000</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>ValidUntil</h3></div><div class='ms-article-text'><p><h6>Alternate Names</h6><span class='ms-label ms-medium'>ValidUntill</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>VoucherLimitTypeID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Defines how `MaxAmount` is applied.<br/><br/>- `1` = Global limit<br/>- `2` = Per user limit<br/></p></div><p><b>Allowed Values</b><span class='ms-label ms-medium'>1</span> <span class='ms-label ms-medium'>2</span> </p></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>MaxAmount</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Maximum number of times a voucher can be used.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='VoucherML' class='ms-alert ms-info'><h1>VoucherML</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>VoucherCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>VoucherName</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>80</td></tr><tr><td class='ms-text-left'>VoucherDescription</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>LCID</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>int</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>MiscellaneousML</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>4000</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>LCID</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>The locale identifier, e.g. `2067` for Dutch (Belgium) [nl-BE].<br/></p></div></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='WarehouseProduct' class='ms-alert ms-info'><h1>WarehouseProduct</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>WarehouseCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>ProductCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>StockDate</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>date</td><td class='ms-text-center'>10</td></tr><tr><td class='ms-text-left'>Stock</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>decimal</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>StockIndication</td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'></td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>StockDate</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Can be used for expected / forecasted stock.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Stock</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>Actual stock count; see `StockIndication` for an alternative.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>StockIndication</h3></div><div class='ms-article-text'><div class='ms-blockquote ms-info'><p class='ms-text-info'>A relative stock indication, e.g. BACKORDER, LOW, MEDIUM, HIGH; see `Stock` for an alternative.<br/></p></div></div></div>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='WebRoleCustomerPerson' class='ms-alert ms-info'><h1>WebRoleCustomerPerson</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>WebRoleCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>CustomerCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PersonCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
<div style='page-break-before: always;' id='WebRolePerson' class='ms-alert ms-info'><h1>WebRolePerson</h1></div>
<table class='ms-table'><tr><th class='ms-text-left'>Field Name</th><th class='ms-text-center'>Key Field</th><th class='ms-text-center'>Required</th><th class='ms-text-center'>Obsolete</th><th class='ms-text-center'>Type</th><th class='ms-text-center'>Max. Length </th></tr><tr><td class='ms-text-left'>WebRoleCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>PersonCode</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>nvarchar</td><td class='ms-text-center'>150</td></tr><tr><td class='ms-text-left'>Action</td><td class='ms-text-center'></td><td class='ms-text-center'>Yes</td><td class='ms-text-center'></td><td class='ms-text-center'>char</td><td class='ms-text-center'>1</td></tr></table>
<div class='ms-article'><div class='ms-article-title'><span class='ms-label ms-success'>Field</span><br/><h3>Action</h3></div><div class='ms-article-text'><p><b>Allowed Values</b><span class='ms-label ms-medium'>I</span> <span class='ms-label ms-medium'>U</span> <span class='ms-label ms-medium'>D</span> </p></div></div>
<hr/><hr/>
</div>
</body>
</html>