Mapped Fields - Zedonk

1

Action Code

2

LINESHEETS FIELDS

3

Name of Linesheet

Linesheet Name

Catalogue Section 1 "Linesheet Name"

4

Linesheet Code

Linesheet Code

5

Start Ship Date

Linesheet Start Ship Date

6

Complete Ship Date

Linesheet Complete Ship Date

7

Linesheet Cancel Date

8

Season

Linesheet Season Name

Catalogue Section 2 "Linesheet Season Name"

9

Code

Linesheet Season Code

10

Year

Linesheet Season Year

11

Minimum Shipping Window

Linesheet Minimum Delivery Window

12

Linesheet Style Comments

13

Linesheet Style Display Order

14

STYLES FIELDS

15

Style Name

Style Name

Description

16

Style Number

Style Number

Style

17

Description

Style Description

Description

18

Minimum Order Quantity

Style Minimum Order Quantity

19

Material

Style Materials

Textile Content

20

Source of Materials

Style Source of Materials

SKID at product/colour level

21

Country of Origin

Style Country of Origin

Manufacturer Country

22

Fabrication

Style Fabrication

Fabric

23

Fabrication

Style Fabrication Code

24

Silhouette

Style Silhouette

Catalogue Section 6 "Silhouette"

25

Silhouette

Style Silhouette Code

26

Heel Height

Style Heel Height

27

Division

Style Division Name

28

Division

Style Division Code

29

Model Height

Style Model Height

30

Measurements

Style Measurements

31

Category

Style Category Gender

Catalogue Section 3 "Style Category Gender"

32

Category

Style Category

Catalogue Section 4 "Style Category"

33

Category

Style Subcategory

Catalogue Section 5 "Style Subcategory"

34

Contains Fur?

Style Contains Fur

35

Value

Style Tag Value 1

36

Code

Style Tag Value Code 1

38

COLORS FIELDS

39

Color Name

Color Name

Colour

40

Code

Color Code

41

SIZES FIELDS

42

Size Label

Individual Size Name

Size

43

Code

Size Code

44

Measurements or Description

Size Description

45

Size Order

Follows the same order as displayed in UI

46

Active?

Size Active

47

UPC

UPC

Barcode

48

Size Label

Casepack Name

49

Casepack Quantity

50

PRICES FIELDS

51

Currency/Price Label

Price Type Currency 1

52

Currency/Price Label

Price Type Label 1

Currency Name

53

Wholesale

Wholesale Price 1

Wholesale Price

54

Suggested Retail

Suggested Retail Price 1

RRP

55

IMAGES FIELDS

56

FTP Image Directory

57

Image FTP Filename 1

58

Image URL 1

59

Style Color Image FTP Filename

60

Style Color Image URL

61

Style Color Swatch FTP Filename

62

Style Color Swatch URL

1

UPC

Barcode

2

[Warehouse Details]

Quantity

Available to Sell

3

Warehouse

Warehouse

4

Date

Date

5

[Warehouse Details]

Style Number

6

Style ID

7

[Warehouse Details]

Color Name

8

[Warehouse Details]

Color Code

9

Style Color ID

10

[Warehouse Details]

Size Name

11

[Warehouse Details]

Size Code

1

CUSTOMERS FIELDS

2

Profile Name

Customer

3

Customer Code and Alias > Customer Code

Customer Code

Account Number

4

Customer Code and Alias > Customer Alias

Customer Alias

Customer

5

Alternate Name

6

Website

Website

7

Company Number Name

8

Company Number Code

9

Customer Group Name

10

Customer Group Code

11

DISCOUNTS FIELDS

12

Discounts > DISCOUNT %

Discount

Trade Discount

13

Discounts > APPLY DISCOUNT TO

Discount Line Item Level

(always FALSE)

14

SALES REPS FIELDS

15

Assign Sales Reps

Sales Rep Code

16

WAREHOUSE FIELDS

17

Warehouses

Warehouse Name

18

Warehouses

Warehouse Code

19

BUYERS FIELDS

20

Buyers > Buyer Name

Buyer Name

Default Contact

21

Buyers > Email Address

Buyer Email

Default Contact Email

22

PAYMENT METHOD FIELDS

23

Payment Methods

Payment Terms

Payment Terms

24

Payment Methods

Payment Terms Code

25

SHIPPING METHOD FIELDS

26

Shipping Methods

Shipping Terms

Shipping Terms

27

Shipping Methods Code

Shipping Terms Code

28

CURRENCIES FIELDS

29

Currencies

Price Type Currency

Currency Code

30

Currencies

Price Type Name

Currency Name

31

SHIPPING FIELDS

32

Shipping Addresses > Code

Shipping Code

Delivery Address Description

33

Shipping Addresses > Store Name

Shipping Name

Delivery Company Name

34

Shipping Addresses > Address 1

Shipping Address 1

Delivery Address 1

35

Shipping Addresses > Address 2

Shipping Address 2

Delivery Address 2

36

Shipping Addresses > City

Shipping City

Delivery Town

37

Shipping Addresses > State

Shipping State

Delivery State

38

Shipping Addresses > Zip

Shipping Zip

Delivery Postcode

39

Shipping Addresses > Country

Shipping Country

Delivery Country

40

Shipping Addresses > Email

Shipping Email

Delivery Email

41

Shipping Addresses > Phone

Shipping Phone

Delivery Telephone

42

CREATE DOORS FIELDS

43

Doors

Create Doors

44

BILLING FIELDS

45

Billing Addresses > Code

Billing Code

Accounts Address Description

46

Billing Addresses > Store Name

Billing Name

Accounts Company Name

47

Billing Addresses > Address 1

Billing Address 1

Accounts Address 1

48

Billing Addresses > Address 2

Billing Address 2

Accounts Address 2

49

Billing Addresses > City

Billing City

Accounts Town

50

Billing Addresses > State

Billing State

Accounts State

51

Billing Addresses > Zip

Billing Zip

Accounts Postcode

52

Billing Addresses > Country

Billing Country

Accounts Country

1

ORDERS FIELDS

2

order.account_id

3

Contact Information > Customer Code

order.customer_code

Account Code

4

order.company_name

5

order.company_code

6

order.customer_group_name

7

order.customer_group_code

8

Order Date

order.date_approved

Confirmation Date

9

order.designer_custom_url

10

order.designer_id

11

order.designer_payment_method_code

12

Contact Information

order.designer_profile_name

13

order.designer_shipping_method_code

14

Season

order.season_code

15

Season

order.season_name

Season

16

Season

order.season_year

17

Season

order.seasonname

18

order.shipping_account

19

Shipping Address > Code

order.shipping_code

20

Shipping Address > Shipping Name

order.shipping_name

Delivery Company Name

21

Shipping Address > Address 1

order.shipping_line1

Delivery Address 1

22

Shipping Address > Address 2

order.shipping_line2

Delivery Address 2

23

Shipping Address > City

order.shipping_city

Delivery Town

24

Shipping Address > State

order.shipping_state

Delivery State

25

Shipping Address > Zip

order.shipping_zip

Delivery Postcode

26

Shipping Address > Country

order.shipping_country

Delivery Country

27

order.shipping_country_code2

28

Shipping Address > Phone Number

order.shipping_phone

Delivery Telephone

29

Shipping Address > Email

order.shipping_email

Delivery Email

30

Delivery Window / Shipping Method > Start Ship Date

order.shipping_start

Delivery Start

31

Delivery Window / Shipping Method > Complete Ship Date

order.shipping_complete

Delivery Cancel

32

order.shipping_or_customer_code

33

order.shipping_company

34

Shipping Method > Ship With

order.shipping_method_name

Shipping Terms

35

Shipping Fee

order.shipping_price

36

order.billing_code

37

Billing Address > Billing Name

order.billing_name

Accounts Company Name

38

Billing Address > Address 1

order.billing_line1

Accounts Address 1

39

Billing Address > Address 2

order.billing_line2

Accounts Address 2

40

Billing Address > City

order.billing_city

Accounts Town

41

Billing Address > State

order.billing_state

Accounts State

42

Billing Address > Zip

order.billing_zip

Accounts Postcode

43

Billing Address > Country

order.billing_country

Accounts Country

44

order.billing_country_code2

45

Billing Address > Phone Number

order.billing_phone

Accounts Telephone

46

order.billing_company

47

Shipping Address > Buyer Name

order.buyer_display_name

48

order.buyer_phone

49

Price Type

order.currency_code

Currency Code

50

Price Type

order. price_type_name

Currency Name

51

order.division_code

52

Door

order.door_codes

53

Door

order.door_names

54

Order Type

order.order_type

55

order.type_code

56

Payment Method > Terms

order.payment_method

Payment Terms

57

Shipping Method > PO#

order.po_num

Order Reference

58

order.integration_po_num

59

order.public_id

60

order.public_status_id

61

order.rep_cc_emails

62

order.rep_send_ipad_emails

63

order.rep_user_email

64

Contact Information

order.retailer_profile_name

65

Sales Rep

order.sales_contact

66

order.sales_email

67

order.sales_phone

68

order.sales_rep_code

69

Sales Rep

order.sales_rep_display_name

70

order.sales_email

71

Event

order.source

72

Order Comments

order.special_instructions

Comments

73

Internal Note

order.internal_comments

74

Order Information

order.styles

75

order.tax_id_number

76

order.tax_label

77

order.terms

78

Total Quantity

order.total_units

79

order.warehouse_name

80

order.warehouse_code

81

order.retailer_brand_code

82

Event

order.event

83

order.event_code

84

Discount

order.order_discount_percent

85

Discount

order.discount_amount

Order Discount

86

Subtotal

order.calculated_order_subtotal

87

Grand Total

order.calculated_order_total

88

order.commissions

89

Created Date

order.created

90

order.modified

91

Order Status

order.status

92

[Order View Page] > Export Status

order.export_created

93

[Order View Page] > Export Status

order.export_description

94

[Order View Page] > Export Status

order.export_status

95

[Order View Page] > Export Status

order.export_success

96

order.id

97

order.joor_web_status_id

98

order.signature_file

99

Order Information

order.linesheet_name

100

order.linesheet_code

101

STYLES FIELDS

102

style.active_linesheets

103

Discount

style.style_discount_percent

104

Order Information > Sizes

style.available_sizes

105

Order Information > Country of Origin

style.country_of_origin

106

style.division_code

107

Order Information > Silhouette

style.silhouette

108

style.silhouette_code

109

Order Information > Fabrication Name - Code

style.fabrication

110

Order Information > Fabrication Name - Code

style.fabrication_code

111

Order Information

style.id

112

Order Information

style.image

113

Order Information

style.linesheet_name

114

style.linesheet_code

115

Order Information > Materials

style.materials

116

Order Information

style.name

117

Order Information

style.number

118

Order Information > Sugg. Retail

style.suggested_retail_price

119

style.heel_height

120

style.source_of_materials

121

style.contains_fur

122

style.measurements

123

style.description

124

COLORS FIELDS

125

color.active

126

Order Information > Colors

color.code

127

color.comment

128

color.door_id

129

color.door_name

130

color.door_code

131

color.id

132

color.image

133

Order Information > Colors

color.name

134

color.sizes

135

color.code_or_name

136

SIZES FIELDS

137

Order Information > Sizes

size.code

138

Order Information > Wholesale

size.item_price

Price

139

size.item_price_adjustment

140

size.item_price_extended

141

size.color_comment

142

Order Information > Style > Comment

size.modifications

143

size.original_price

144

Order Information > Qty

size.quantity

Quantity

145

Order Information > Qty

size.multiplier

146

Order Information > Total Units

size.total_units

147

Order Information

size.name

148

size.code_or_name

149

size.upc

Barcode

150

OTHER FIELDS

151

placeholder.counter_row