Below, you will find the field mapping for each data point.
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Action Code
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
2
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**LINESHEETS FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
3
</td>
<td style={{ textAlign: "left" }}>
Name of Linesheet
</td>
<td style={{ textAlign: "left" }}>
Linesheet Name
</td>
<td style={{ textAlign: "left" }}>
Catalogue Section 1 "Linesheet Name"
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
4
</td>
<td style={{ textAlign: "left" }}>
Linesheet Code
</td>
<td style={{ textAlign: "left" }}>
Linesheet Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
5
</td>
<td style={{ textAlign: "left" }}>
Start Ship Date
</td>
<td style={{ textAlign: "left" }}>
Linesheet Start Ship Date
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
6
</td>
<td style={{ textAlign: "left" }}>
Complete Ship Date
</td>
<td style={{ textAlign: "left" }}>
Linesheet Complete Ship Date
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
7
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Linesheet Cancel Date
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
8
</td>
<td style={{ textAlign: "left" }}>
Season
</td>
<td style={{ textAlign: "left" }}>
Linesheet Season Name
</td>
<td style={{ textAlign: "left" }}>
Catalogue Section 2 "Linesheet Season Name"
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
9
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
Linesheet Season Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
10
</td>
<td style={{ textAlign: "left" }}>
Year
</td>
<td style={{ textAlign: "left" }}>
Linesheet Season Year
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
11
</td>
<td style={{ textAlign: "left" }}>
Minimum Shipping Window
</td>
<td style={{ textAlign: "left" }}>
Linesheet Minimum Delivery Window
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
12
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Linesheet Style Comments
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
13
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Linesheet Style Display Order
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
14
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**STYLES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
15
</td>
<td style={{ textAlign: "left" }}>
Style Name
</td>
<td style={{ textAlign: "left" }}>
Style Name
</td>
<td style={{ textAlign: "left" }}>
Description
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
16
</td>
<td style={{ textAlign: "left" }}>
Style Number
</td>
<td style={{ textAlign: "left" }}>
Style Number
</td>
<td style={{ textAlign: "left" }}>
Style
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
17
</td>
<td style={{ textAlign: "left" }}>
Description
</td>
<td style={{ textAlign: "left" }}>
Style Description
</td>
<td style={{ textAlign: "left" }}>
Description
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
18
</td>
<td style={{ textAlign: "left" }}>
Minimum Order Quantity
</td>
<td style={{ textAlign: "left" }}>
Style Minimum Order Quantity
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
19
</td>
<td style={{ textAlign: "left" }}>
Material
</td>
<td style={{ textAlign: "left" }}>
Style Materials
</td>
<td style={{ textAlign: "left" }}>
Textile Content
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
20
</td>
<td style={{ textAlign: "left" }}>
Source of Materials
</td>
<td style={{ textAlign: "left" }}>
Style Source of Materials
</td>
<td style={{ textAlign: "left" }}>
SKID at product/colour level
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
21
</td>
<td style={{ textAlign: "left" }}>
Country of Origin
</td>
<td style={{ textAlign: "left" }}>
Style Country of Origin
</td>
<td style={{ textAlign: "left" }}>
Manufacturer Country
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
22
</td>
<td style={{ textAlign: "left" }}>
Fabrication
</td>
<td style={{ textAlign: "left" }}>
Style Fabrication
</td>
<td style={{ textAlign: "left" }}>
Fabric
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
23
</td>
<td style={{ textAlign: "left" }}>
Fabrication
</td>
<td style={{ textAlign: "left" }}>
Style Fabrication Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
24
</td>
<td style={{ textAlign: "left" }}>
Silhouette
</td>
<td style={{ textAlign: "left" }}>
Style Silhouette
</td>
<td style={{ textAlign: "left" }}>
Catalogue Section 6 "Silhouette"
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
25
</td>
<td style={{ textAlign: "left" }}>
Silhouette
</td>
<td style={{ textAlign: "left" }}>
Style Silhouette Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
26
</td>
<td style={{ textAlign: "left" }}>
Heel Height
</td>
<td style={{ textAlign: "left" }}>
Style Heel Height
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
27
</td>
<td style={{ textAlign: "left" }}>
Division
</td>
<td style={{ textAlign: "left" }}>
Style Division Name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
28
</td>
<td style={{ textAlign: "left" }}>
Division
</td>
<td style={{ textAlign: "left" }}>
Style Division Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
29
</td>
<td style={{ textAlign: "left" }}>
Model Height
</td>
<td style={{ textAlign: "left" }}>
Style Model Height
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
30
</td>
<td style={{ textAlign: "left" }}>
Measurements
</td>
<td style={{ textAlign: "left" }}>
Style Measurements
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
31
</td>
<td style={{ textAlign: "left" }}>
Category
</td>
<td style={{ textAlign: "left" }}>
Style Category Gender
</td>
<td style={{ textAlign: "left" }}>
Catalogue Section 3 "Style Category Gender"
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
32
</td>
<td style={{ textAlign: "left" }}>
Category
</td>
<td style={{ textAlign: "left" }}>
Style Category
</td>
<td style={{ textAlign: "left" }}>
Catalogue Section 4 "Style Category"
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
33
</td>
<td style={{ textAlign: "left" }}>
Category
</td>
<td style={{ textAlign: "left" }}>
Style Subcategory
</td>
<td style={{ textAlign: "left" }}>
Catalogue Section 5 "Style Subcategory"
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
34
</td>
<td style={{ textAlign: "left" }}>
Contains Fur?
</td>
<td style={{ textAlign: "left" }}>
Style Contains Fur
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
35
</td>
<td style={{ textAlign: "left" }}>
Value
</td>
<td style={{ textAlign: "left" }}>
Style Tag Value 1
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
36
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
Style Tag Value Code 1
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
38
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**COLORS FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
39
</td>
<td style={{ textAlign: "left" }}>
Color Name
</td>
<td style={{ textAlign: "left" }}>
Color Name
</td>
<td style={{ textAlign: "left" }}>
Colour
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
40
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
Color Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
41
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**SIZES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
42
</td>
<td style={{ textAlign: "left" }}>
Size Label
</td>
<td style={{ textAlign: "left" }}>
Individual Size Name
</td>
<td style={{ textAlign: "left" }}>
Size
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
43
</td>
<td style={{ textAlign: "left" }}>
Code
</td>
<td style={{ textAlign: "left" }}>
Size Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
44
</td>
<td style={{ textAlign: "left" }}>
Measurements or Description
</td>
<td style={{ textAlign: "left" }}>
Size Description
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
45
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Size Order
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
Follows the same order as displayed in UI
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
46
</td>
<td style={{ textAlign: "left" }}>
Active?
</td>
<td style={{ textAlign: "left" }}>
Size Active
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
47
</td>
<td style={{ textAlign: "left" }}>
UPC
</td>
<td style={{ textAlign: "left" }}>
UPC
</td>
<td style={{ textAlign: "left" }}>
Barcode
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
48
</td>
<td style={{ textAlign: "left" }}>
Size Label
</td>
<td style={{ textAlign: "left" }}>
Casepack Name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
49
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Casepack Quantity
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
50
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**PRICES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
51
</td>
<td style={{ textAlign: "left" }}>
Currency/Price Label
</td>
<td style={{ textAlign: "left" }}>
Price Type Currency 1
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
52
</td>
<td style={{ textAlign: "left" }}>
Currency/Price Label
</td>
<td style={{ textAlign: "left" }}>
Price Type Label 1
</td>
<td style={{ textAlign: "left" }}>
Currency Name
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
53
</td>
<td style={{ textAlign: "left" }}>
Wholesale
</td>
<td style={{ textAlign: "left" }}>
Wholesale Price 1
</td>
<td style={{ textAlign: "left" }}>
Wholesale Price
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
54
</td>
<td style={{ textAlign: "left" }}>
Suggested Retail
</td>
<td style={{ textAlign: "left" }}>
Suggested Retail Price 1
</td>
<td style={{ textAlign: "left" }}>
RRP
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
55
</td>
<td style={{ textAlign: "left" }}>
<p style="background-color:#5a6f82;color:white;">**IMAGES FIELDS**</p>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
56
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
FTP Image Directory
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
57
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Image FTP Filename 1
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
58
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Image URL 1
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
59
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Style Color Image FTP Filename
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
60
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Style Color Image URL
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
61
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Style Color Swatch FTP Filename
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
62
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Style Color Swatch URL
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
</th>
<th style={{ textAlign: "left" }}>
JOOR UI Field
</th>
<th style={{ textAlign: "left" }}>
JOOR Flat File Field
</th>
<th style={{ textAlign: "left" }}>
Zedonk Field
</th>
<th style={{ textAlign: "left" }}>
Column Name/Number
</th>
<th style={{ textAlign: "left" }}>
Notes
</th>
</tr>
|
1
|
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
UPC
</td>
<td style={{ textAlign: "left" }}>
Barcode
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
2
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
Quantity
</td>
<td style={{ textAlign: "left" }}>
Available to Sell
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
3
</td>
<td style={{ textAlign: "left" }}>
Warehouse
</td>
<td style={{ textAlign: "left" }}>
Warehouse
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
4
</td>
<td style={{ textAlign: "left" }}>
Date
</td>
<td style={{ textAlign: "left" }}>
Date
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
5
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
Style Number
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
6
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Style ID
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
7
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
Color Name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
8
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
Color Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
9
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
Style Color ID
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
10
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
Size Name
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
<tr>
<td style={{ textAlign: "left" }}>
11
</td>
<td style={{ textAlign: "left" }}>
[Warehouse Details]
</td>
<td style={{ textAlign: "left" }}>
Size Code
</td>
<td style={{ textAlign: "left" }}>
*
</td>
<td style={{ textAlign: "left" }}>
</td>
<td style={{ textAlign: "left" }}>
</td>
</tr>
</th>
<th style={{ textAlign: "left" }}>
JOOR UI Field
</th>
<th style={{ textAlign: "left" }}>
JOOR Flat File Field
</th>
<th style={{ textAlign: "left" }}>
Zedonk Field
</th>
<th style={{ textAlign: "left" }}>
Column Name/Number
</th>
<th style={{ textAlign: "left" }}>
Notes
</th>
</tr>
|
1
|
<td>
<p style="background-color:#5a6f82;color:white;">**CUSTOMERS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
2
</td>
<td>
*
</td>
<td>
Profile Name
</td>
<td>
Customer
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
3
</td>
<td>
Customer Code and Alias > Customer Code
</td>
<td>
Customer Code
</td>
<td>
Account Number
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
4
</td>
<td>
Customer Code and Alias > Customer Alias
</td>
<td>
Customer Alias
</td>
<td>
Customer
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
5
</td>
<td>
*
</td>
<td>
Alternate Name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
6
</td>
<td>
*
</td>
<td>
Website
</td>
<td>
Website
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
7
</td>
<td>
*
</td>
<td>
Company Number Name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
8
</td>
<td>
*
</td>
<td>
Company Number Code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
9
</td>
<td>
*
</td>
<td>
Customer Group Name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
10
</td>
<td>
*
</td>
<td>
Customer Group Code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
11
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**DISCOUNTS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
12
</td>
<td>
Discounts > DISCOUNT %
</td>
<td>
Discount
</td>
<td>
Trade Discount
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
13
</td>
<td>
Discounts > APPLY DISCOUNT TO
</td>
<td>
Discount Line Item Level
</td>
<td>
(always FALSE)
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
14
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**SALES REPS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
15
</td>
<td>
Assign Sales Reps
</td>
<td>
Sales Rep Code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
16
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**WAREHOUSE FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
17
</td>
<td>
Warehouses
</td>
<td>
Warehouse Name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
18
</td>
<td>
Warehouses
</td>
<td>
Warehouse Code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
19
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**BUYERS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
20
</td>
<td>
Buyers > Buyer Name
</td>
<td>
Buyer Name
</td>
<td>
Default Contact
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
21
</td>
<td>
Buyers > Email Address
</td>
<td>
Buyer Email
</td>
<td>
Default Contact Email
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
22
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**PAYMENT METHOD FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
23
</td>
<td>
Payment Methods
</td>
<td>
Payment Terms
</td>
<td>
Payment Terms
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
24
</td>
<td>
Payment Methods
</td>
<td>
Payment Terms Code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
25
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**SHIPPING METHOD FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
26
</td>
<td>
Shipping Methods
</td>
<td>
Shipping Terms
</td>
<td>
Shipping Terms
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
27
</td>
<td>
Shipping Methods Code
</td>
<td>
Shipping Terms Code
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
28
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**CURRENCIES FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
29
</td>
<td>
Currencies
</td>
<td>
Price Type Currency
</td>
<td>
Currency Code
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
30
</td>
<td>
Currencies
</td>
<td>
Price Type Name
</td>
<td>
Currency Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
31
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**SHIPPING FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
32
</td>
<td>
Shipping Addresses > Code
</td>
<td>
Shipping Code
</td>
<td>
Delivery Address Description
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
33
</td>
<td>
Shipping Addresses > Store Name
</td>
<td>
Shipping Name
</td>
<td>
Delivery Company Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
34
</td>
<td>
Shipping Addresses > Address 1
</td>
<td>
Shipping Address 1
</td>
<td>
Delivery Address 1
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
35
</td>
<td>
Shipping Addresses > Address 2
</td>
<td>
Shipping Address 2
</td>
<td>
Delivery Address 2
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
36
</td>
<td>
Shipping Addresses > City
</td>
<td>
Shipping City
</td>
<td>
Delivery Town
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
37
</td>
<td>
Shipping Addresses > State
</td>
<td>
Shipping State
</td>
<td>
Delivery State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
38
</td>
<td>
Shipping Addresses > Zip
</td>
<td>
Shipping Zip
</td>
<td>
Delivery Postcode
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
39
</td>
<td>
Shipping Addresses > Country
</td>
<td>
Shipping Country
</td>
<td>
Delivery Country
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
40
</td>
<td>
Shipping Addresses > Email
</td>
<td>
Shipping Email
</td>
<td>
Delivery Email
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
41
</td>
<td>
Shipping Addresses > Phone
</td>
<td>
Shipping Phone
</td>
<td>
Delivery Telephone
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
42
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**CREATE DOORS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
43
</td>
<td>
Doors
</td>
<td>
Create Doors
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
44
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**BILLING FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
45
</td>
<td>
Billing Addresses > Code
</td>
<td>
Billing Code
</td>
<td>
Accounts Address Description
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
46
</td>
<td>
Billing Addresses > Store Name
</td>
<td>
Billing Name
</td>
<td>
Accounts Company Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
47
</td>
<td>
Billing Addresses > Address 1
</td>
<td>
Billing Address 1
</td>
<td>
Accounts Address 1
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
48
</td>
<td>
Billing Addresses > Address 2
</td>
<td>
Billing Address 2
</td>
<td>
Accounts Address 2
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
49
</td>
<td>
Billing Addresses > City
</td>
<td>
Billing City
</td>
<td>
Accounts Town
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
50
</td>
<td>
Billing Addresses > State
</td>
<td>
Billing State
</td>
<td>
Accounts State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
51
</td>
<td>
Billing Addresses > Zip
</td>
<td>
Billing Zip
</td>
<td>
Accounts Postcode
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
52
</td>
<td>
Billing Addresses > Country
</td>
<td>
Billing Country
</td>
<td>
Accounts Country
</td>
<td>
</td>
<td>
</td>
</tr>
</th>
<th>
JOOR UI Field
</th>
<th>
JOOR Flat File Field
</th>
<th>
Zedonk Field
</th>
<th>
Column Name/Number
</th>
<th>
Notes
</th>
</tr>
|
1
|
<td>
<p style="background-color:#5a6f82;color:white;">**ORDERS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
2
</td>
<td>
*
</td>
<td>
order.account\_id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
3
</td>
<td>
Contact Information > Customer Code
</td>
<td>
order.customer\_code
</td>
<td>
Account Code
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
4
</td>
<td>
*
</td>
<td>
order.company\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
5
</td>
<td>
*
</td>
<td>
order.company\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
6
</td>
<td>
*
</td>
<td>
order.customer\_group\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
7
</td>
<td>
*
</td>
<td>
order.customer\_group\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
8
</td>
<td>
Order Date
</td>
<td>
order.date\_approved
</td>
<td>
Confirmation Date
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
9
</td>
<td>
*
</td>
<td>
order.designer\_custom\_url
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
10
</td>
<td>
*
</td>
<td>
order.designer\_id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
11
</td>
<td>
*
</td>
<td>
order.designer\_payment\_method\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
12
</td>
<td>
Contact Information
</td>
<td>
order.designer\_profile\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
13
</td>
<td>
*
</td>
<td>
order.designer\_shipping\_method\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
14
</td>
<td>
Season
</td>
<td>
order.season\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
15
</td>
<td>
Season
</td>
<td>
order.season\_name
</td>
<td>
Season
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
16
</td>
<td>
Season
</td>
<td>
order.season\_year
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
17
</td>
<td>
Season
</td>
<td>
order.seasonname
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
18
</td>
<td>
*
</td>
<td>
order.shipping\_account
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
19
</td>
<td>
Shipping Address > Code
</td>
<td>
order.shipping\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
20
</td>
<td>
Shipping Address > Shipping Name
</td>
<td>
order.shipping\_name
</td>
<td>
Delivery Company Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
21
</td>
<td>
Shipping Address > Address 1
</td>
<td>
order.shipping\_line1
</td>
<td>
Delivery Address 1
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
22
</td>
<td>
Shipping Address > Address 2
</td>
<td>
order.shipping\_line2
</td>
<td>
Delivery Address 2
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
23
</td>
<td>
Shipping Address > City
</td>
<td>
order.shipping\_city
</td>
<td>
Delivery Town
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
24
</td>
<td>
Shipping Address > State
</td>
<td>
order.shipping\_state
</td>
<td>
Delivery State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
25
</td>
<td>
Shipping Address > Zip
</td>
<td>
order.shipping\_zip
</td>
<td>
Delivery Postcode
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
26
</td>
<td>
Shipping Address > Country
</td>
<td>
order.shipping\_country
</td>
<td>
Delivery Country
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
27
</td>
<td>
*
</td>
<td>
order.shipping\_country\_code2
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
28
</td>
<td>
Shipping Address > Phone Number
</td>
<td>
order.shipping\_phone
</td>
<td>
Delivery Telephone
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
29
</td>
<td>
Shipping Address > Email
</td>
<td>
order.shipping\_email
</td>
<td>
Delivery Email
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
30
</td>
<td>
Delivery Window / Shipping Method > Start Ship Date
</td>
<td>
order.shipping\_start
</td>
<td>
Delivery Start
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
31
</td>
<td>
Delivery Window / Shipping Method > Complete Ship Date
</td>
<td>
order.shipping\_complete
</td>
<td>
Delivery Cancel
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
32
</td>
<td>
*
</td>
<td>
order.shipping\_or\_customer\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
33
</td>
<td>
*
</td>
<td>
order.shipping\_company
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
34
</td>
<td>
Shipping Method > Ship With
</td>
<td>
order.shipping\_method\_name
</td>
<td>
Shipping Terms
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
35
</td>
<td>
Shipping Fee
</td>
<td>
order.shipping\_price
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
36
</td>
<td>
*
</td>
<td>
order.billing\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
37
</td>
<td>
Billing Address > Billing Name
</td>
<td>
order.billing\_name
</td>
<td>
Accounts Company Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
38
</td>
<td>
Billing Address > Address 1
</td>
<td>
order.billing\_line1
</td>
<td>
Accounts Address 1
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
39
</td>
<td>
Billing Address > Address 2
</td>
<td>
order.billing\_line2
</td>
<td>
Accounts Address 2
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
40
</td>
<td>
Billing Address > City
</td>
<td>
order.billing\_city
</td>
<td>
Accounts Town
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
41
</td>
<td>
Billing Address > State
</td>
<td>
order.billing\_state
</td>
<td>
Accounts State
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
42
</td>
<td>
Billing Address > Zip
</td>
<td>
order.billing\_zip
</td>
<td>
Accounts Postcode
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
43
</td>
<td>
Billing Address > Country
</td>
<td>
order.billing\_country
</td>
<td>
Accounts Country
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
44
</td>
<td>
*
</td>
<td>
order.billing\_country\_code2
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
45
</td>
<td>
Billing Address > Phone Number
</td>
<td>
order.billing\_phone
</td>
<td>
Accounts Telephone
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
46
</td>
<td>
*
</td>
<td>
order.billing\_company
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
47
</td>
<td>
Shipping Address > Buyer Name
</td>
<td>
order.buyer\_display\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
48
</td>
<td>
*
</td>
<td>
order.buyer\_phone
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
49
</td>
<td>
Price Type
</td>
<td>
order.currency\_code
</td>
<td>
Currency Code
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
50
</td>
<td>
Price Type
</td>
<td>
order. price\_type\_name
</td>
<td>
Currency Name
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
51
</td>
<td>
*
</td>
<td>
order.division\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
52
</td>
<td>
Door
</td>
<td>
order.door\_codes
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
53
</td>
<td>
Door
</td>
<td>
order.door\_names
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
54
</td>
<td>
Order Type
</td>
<td>
order.order\_type
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
55
</td>
<td>
*
</td>
<td>
order.type\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
56
</td>
<td>
Payment Method > Terms
</td>
<td>
order.payment\_method
</td>
<td>
Payment Terms
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
57
</td>
<td>
Shipping Method > PO#
</td>
<td>
order.po\_num
</td>
<td>
Order Reference
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
58
</td>
<td>
*
</td>
<td>
order.integration\_po\_num
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
59
</td>
<td>
*
</td>
<td>
order.public\_id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
60
</td>
<td>
*
</td>
<td>
order.public\_status\_id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
61
</td>
<td>
*
</td>
<td>
order.rep\_cc\_emails
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
62
</td>
<td>
*
</td>
<td>
order.rep\_send\_ipad\_emails
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
63
</td>
<td>
*
</td>
<td>
order.rep\_user\_email
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
64
</td>
<td>
Contact Information
</td>
<td>
order.retailer\_profile\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
65
</td>
<td>
Sales Rep
</td>
<td>
order.sales\_contact
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
66
</td>
<td>
*
</td>
<td>
order.sales\_email
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
67
</td>
<td>
*
</td>
<td>
order.sales\_phone
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
68
</td>
<td>
*
</td>
<td>
order.sales\_rep\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
69
</td>
<td>
Sales Rep
</td>
<td>
order.sales\_rep\_display\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
70
</td>
<td>
*
</td>
<td>
order.sales\_email
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
71
</td>
<td>
Event
</td>
<td>
order.source
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
72
</td>
<td>
Order Comments
</td>
<td>
order.special\_instructions
</td>
<td>
Comments
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
73
</td>
<td>
Internal Note
</td>
<td>
order.internal\_comments
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
74
</td>
<td>
Order Information
</td>
<td>
order.styles
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
75
</td>
<td>
*
</td>
<td>
order.tax\_id\_number
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
76
</td>
<td>
*
</td>
<td>
order.tax\_label
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
77
</td>
<td>
*
</td>
<td>
order.terms
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
78
</td>
<td>
Total Quantity
</td>
<td>
order.total\_units
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
79
</td>
<td>
*
</td>
<td>
order.warehouse\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
80
</td>
<td>
*
</td>
<td>
order.warehouse\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
81
</td>
<td>
*
</td>
<td>
order.retailer\_brand\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
82
</td>
<td>
Event
</td>
<td>
order.event
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
83
</td>
<td>
*
</td>
<td>
order.event\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
84
</td>
<td>
Discount
</td>
<td>
order.order\_discount\_percent
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
85
</td>
<td>
Discount
</td>
<td>
order.discount\_amount
</td>
<td>
Order Discount
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
86
</td>
<td>
Subtotal
</td>
<td>
order.calculated\_order\_subtotal
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
87
</td>
<td>
Grand Total
</td>
<td>
order.calculated\_order\_total
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
88
</td>
<td>
*
</td>
<td>
order.commissions
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
89
</td>
<td>
Created Date
</td>
<td>
order.created
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
90
</td>
<td>
*
</td>
<td>
order.modified
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
91
</td>
<td>
Order Status
</td>
<td>
order.status
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
92
</td>
<td>
[Order View Page] > Export Status
</td>
<td>
order.export\_created
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
93
</td>
<td>
[Order View Page] > Export Status
</td>
<td>
order.export\_description
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
94
</td>
<td>
[Order View Page] > Export Status
</td>
<td>
order.export\_status
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
95
</td>
<td>
[Order View Page] > Export Status
</td>
<td>
order.export\_success
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
96
</td>
<td>
*
</td>
<td>
order.id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
97
</td>
<td>
*
</td>
<td>
order.joor\_web\_status\_id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
98
</td>
<td>
*
</td>
<td>
order.signature\_file
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
99
</td>
<td>
Order Information
</td>
<td>
order.linesheet\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
100
</td>
<td>
*
</td>
<td>
order.linesheet\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
101
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**STYLES FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
102
</td>
<td>
*
</td>
<td>
style.active\_linesheets
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
103
</td>
<td>
Discount
</td>
<td>
style.style\_discount\_percent
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
104
</td>
<td>
Order Information > Sizes
</td>
<td>
style.available\_sizes
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
105
</td>
<td>
Order Information > Country of Origin
</td>
<td>
style.country\_of\_origin
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
106
</td>
<td>
*
</td>
<td>
style.division\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
107
</td>
<td>
Order Information > Silhouette
</td>
<td>
style.silhouette
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
108
</td>
<td>
*
</td>
<td>
style.silhouette\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
109
</td>
<td>
Order Information > Fabrication Name - Code
</td>
<td>
style.fabrication
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
110
</td>
<td>
Order Information > Fabrication Name - Code
</td>
<td>
style.fabrication\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
111
</td>
<td>
Order Information
</td>
<td>
style.id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
112
</td>
<td>
Order Information
</td>
<td>
style.image
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
113
</td>
<td>
Order Information
</td>
<td>
style.linesheet\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
114
</td>
<td>
*
</td>
<td>
style.linesheet\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
115
</td>
<td>
Order Information > Materials
</td>
<td>
style.materials
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
116
</td>
<td>
Order Information
</td>
<td>
style.name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
117
</td>
<td>
Order Information
</td>
<td>
style.number
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
118
</td>
<td>
Order Information > Sugg. Retail
</td>
<td>
style.suggested\_retail\_price
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
119
</td>
<td>
*
</td>
<td>
style.heel\_height
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
120
</td>
<td>
*
</td>
<td>
style.source\_of\_materials
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
121
</td>
<td>
*
</td>
<td>
style.contains\_fur
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
122
</td>
<td>
*
</td>
<td>
style.measurements
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
123
</td>
<td>
*
</td>
<td>
style.description
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
124
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**COLORS FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
125
</td>
<td>
*
</td>
<td>
color.active
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
126
</td>
<td>
Order Information > Colors
</td>
<td>
color.code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
127
</td>
<td>
*
</td>
<td>
color.comment
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
128
</td>
<td>
*
</td>
<td>
color.door\_id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
129
</td>
<td>
*
</td>
<td>
color.door\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
130
</td>
<td>
*
</td>
<td>
color.door\_code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
131
</td>
<td>
*
</td>
<td>
color.id
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
132
</td>
<td>
*
</td>
<td>
color.image
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
133
</td>
<td>
Order Information > Colors
</td>
<td>
color.name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
134
</td>
<td>
*
</td>
<td>
color.sizes
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
135
</td>
<td>
*
</td>
<td>
color.code\_or\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
136
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**SIZES FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
137
</td>
<td>
Order Information > Sizes
</td>
<td>
size.code
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
138
</td>
<td>
Order Information > Wholesale
</td>
<td>
size.item\_price
</td>
<td>
Price
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
139
</td>
<td>
*
</td>
<td>
size.item\_price\_adjustment
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
140
</td>
<td>
*
</td>
<td>
size.item\_price\_extended
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
141
</td>
<td>
*
</td>
<td>
size.color\_comment
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
142
</td>
<td>
Order Information > Style > Comment
</td>
<td>
size.modifications
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
143
</td>
<td>
*
</td>
<td>
size.original\_price
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
144
</td>
<td>
Order Information > Qty
</td>
<td>
size.quantity
</td>
<td>
Quantity
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
145
</td>
<td>
Order Information > Qty
</td>
<td>
size.multiplier
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
146
</td>
<td>
Order Information > Total Units
</td>
<td>
size.total\_units
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
147
</td>
<td>
Order Information
</td>
<td>
size.name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
148
</td>
<td>
*
</td>
<td>
size.code\_or\_name
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
149
</td>
<td>
*
</td>
<td>
size.upc
</td>
<td>
Barcode
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
150
</td>
<td>
<p style="background-color:#5a6f82;color:white;">**OTHER FIELDS**</p>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
151
</td>
<td>
*
</td>
<td>
placeholder.counter\_row
</td>
<td>
*
</td>
<td>
</td>
<td>
</td>
</tr>
</th>
<th>
JOOR UI Field
</th>
<th>
JOOR Flat File Field
</th>
<th>
Zedonk Field
</th>
<th>
Column Name/Number
</th>
<th>
Notes
</th>
</tr>
|
1
|