Mapped Fields - Netsuite

1

STYLE FIELDS

2

Style Name

style_name

Display Name/Code

3

Style Number

style_number

Item Name/Number

4

style_identifier

Item Name/Number

5

Description

style_description

Sales Description

6

made_to_order

Inventory Made to Order (JOOR)

7

Division

division

Department

8

Division

division_code

Department

9

Country of Origin

style_country_origin

Manufacturer Country

10

Fabrication

fabrication

Fabrication (JOOR)

11

Fabrication

fabrication_code

12

Measurements

measurements

13

Silhouette

silhouette

Silhouette (JOOR)

14

Silhouette

silhouette_code

15

Source of Materials

source_of_materials

16

Heel Height

heel_height

17

Contains Fur?

contains_fur

Contains Fur? (JOOR)

18

delivery_overwrite

19

Minimum Order Quantity

minimum

Minimum Quantity

20

CATEGORIES FIELDS

21

Category

category_id

External System Category

22

MATERIALS FIELDS

23

Material

material

Material (JOOR)

24

PRICES FIELDS

25

Currency/Price Label

price_label

priceLabel (from entity sync info)

26

Currency/Price Label

price_currency

priceLabel (from entity sync info)

27

Wholesale

price_wholesale

List Price

28

Suggested Retail

price_retail

List Price

29

price_currency_retail

priceLevel - Currency

30

DELIVERIES FIELDS

31

Name of Linesheet

delivery_name

Delivery Name

32

Linesheet Code

delivery_code

Delivery Code

33

style_display_order

Season Name

34

Season

season_name

Season Name

35

Year

season_year

Season Year

36

Code

season_code

Season Code

37

Start Ship Date

date_delivery_start

Delivery Start Date

38

Complete Ship Date

date_delivery_end

Delivery End Date

39

Visible to All My Connections?

public

Is Public?

40

COLOR EXCLUSIONS FIELDS

41

color_name

Excluded Variation

42

color_code

Excluded Variation

43

COLORS FIELDS

44

Color Name

color_name

Matrix Items > Color

45

Code

color_code

Matrix Item Configuration

46

Minimum Order Quantity

minimum

Minimum Quantity

47

color_image

Matrix Items > Color

48

color_hex

49

SIZES FIELDS

50

Size Label

size_name

Matrix Items > Size

51

Code

size_code

Matrix Item Configuration

52

Measurements or Description

size_description

53

size_multiplier

54

casepack_id

55

BADGES FIELDS

56

Badges

badge_name

57

TAGS FIELDS

58

tag_id

Custom Item Attributes

59

tag_group

Custom Item Attributes

60

Tag

tag_name

Custom Item Attributes

61

Value

tag_value

Custom Item Attributes

62

Code

tag_value_code

Custom Item Attributes

63

UPCS FIELDS

64

UPC > Color Code

sku_color_code

Matrix Items > Color

65

UPC > Color Description

sku_color_name

Matrix Item Configuration

66

UPC > Size

sku_size

Matrix Items > Size

67

UPC

upc

UPC Code

1

Warehouse

warehouse

warehouse (from entity sync info)

2

Date

inventory_date

inventory_date (from entity sync info)

3

[Warehouse Details]

style_number

Item Name/Number

4

style_identifier

Item Name/Number

5

[Warehouse Details]

style_id

External System ID

6

[Warehouse Details]

color_code

7

[Warehouse Details]

style_color_id

8

[Warehouse Details]

size

9

[Warehouse Details]

size_code

10

inventory

Location > Inventory

11

upc

UPC Code

12

made_to_order

Inventory Made to Order (JOOR)

1

CUSTOMER FIELDS

2

customer_name

Company Name

3

Customer Code and Alias > Customer Code

customer_code

Company Name

4

Customer Code and Alias > Alias

customer_alias

5

company_number_name

6

company_number_code

7

customer_group_name

8

customer_group_code

9

customer_phone

10

customer_contact

11

customer_contact_email

12

sales_rep_code

13

BUYERS FIELDS

14

Buyers > Buyer Name

buyer_name

Contact > Name

15

buyer_title

16

Buyers > Email Address

buyer_email

Contact > Email

17

buyer_phone

18

buyer_fax

19

SHIPPING ADDRESSES FIELDS

20

Shipping Addresses > Store Name

shipping_name

Default Shipping Address > Addressee

21

Shipping Addresses > Code

shipping_code

Default Shipping Address > Label

22

Shipping Addresses > Phone

shipping_phone

Default Shipping Address > Phone

23

Shipping Addresses > Address 1

shipping_address_1

Default Shipping Address > Address 1

24

Shipping Addresses > Address 2

shipping_address_2

Default Shipping Address > Address 2

25

Shipping Addresses > City

shipping_city

Default Shipping Address > City

26

Shipping Addresses > State

shipping_state

Default Shipping Address > State

27

Shipping Addresses > Zip

shipping_postal_code

Default Shipping Address > Zip

28

Shipping Addresses > Country

shipping_country

Default Shipping Address > Country

29

shipping_create_doors

30

SHIPPING METHODS FIELDS

31

Shipping Methods

shipping_method_name

Standard (default)

32

Shipping Methods

shipping_method_code

Standard (default)

33

BILLING ADDRESSES FIELDS

34

Billing Addresses > Store Name

billing_name

Default Billing Address > Addressee

35

Billing Addresses > Code

billing_code

Default Billing Address > Label

36

Billing Addresses > Phone

billing_phone

Default Billing Address > Phone

37

Billing Addresses > Address 1

billing_address_1

Default Billing Address > Address 1

38

Billing Addresses > Address 2

billing_address_2

Default Billing Address > Address 2

39

Billing Addresses > City

billing_city

Default Billing Address > City

40

Billing Addresses > State

billing_state

Default Billing Address > State

41

Billing Addresses > Zip

billing_postal_code

Default Billing Address > Zip

42

Billing Addresses > Country

billing_country

Default Billing Address > Country

43

CUSTOMER LOCATIONS FIELDS

44

location_phone

45

location_address_1

46

location_address_2

47

location_city

48

location_state

49

location_zip

50

location_country

51

PAYMENT METHODS FIELDS

52

Payment Methods

payment_method_name

Standard (default)

53

Payment Methods

payment_method_code

Standard (default)

54

PRICE TYPES FIELDS

55

Currencies

price_type_currency_code

Currencies (from entity sync info)

56

Currencies

price_type_label

57

Currencies

price_type_retail_currency

58

DISCOUNTS FIELDS

59

Discounts > DISCOUNT %

amount

Discount (JOOR)

60

Discounts > APPLY DISCOUNT TO

line_item_level

61

WAREHOUSES FIELDS

62

Warehouses

warehouse_code

63

Warehouses

warehouse_name

1

ORDER FIELDS

2

order_id

PO#

3

Order Type

order_type

4

Order Comments

order_comments

Memo

5

Price Type

order_currency

6

order_currency_retail

7

order_currency_name

8

Discount

order_discount

Rate

9

Discount

order_discount_percent

Rate

10

Total Quantity

order_shipping_total

Shipping Cost

11

Grand Total

order_total

12

Event

order_source

13

Season

order_season_code

14

Order Type

order_type_name

15

order_type_code

16

Event

order_event

Event (JOOR)

17

order_event_code

18

order_delivery_name

19

order_delivery_code

20

Sales Rep

sales_representative

21

sales_representative_code

22

Created Date

date_created

Date

23

Order Date

date_approved

24

date_modified

25

Delivery Window / Shipping Method > Start Ship Date

date_ship_start

26

Delivery Window / Shipping Method > Complete Ship Date

date_ship_end

27

CUSTOMER FIELDS

28

Contact Information

customer_name

Customer

29

Contact Information > Customer Code

customer_code

Customer

30

company_name

31

company_code

32

customer_group_name

33

customer_group_code

34

customer_purchase_order

35

integration_purchase_order

36

Shipping Address > Buyer Name

customer_buyer_name

Default Shipping Address > Addresses

37

LINE ITEMS FIELDS

38

Order Information

item_name

Items > Item

39

Order Information

item_number

40

Order Information

item_style_id

41

item_style_identifier

42

Order Information > Colors

item_color

43

Order Information > Colors

item_color_code

44

item_upc

45

Order Information

item_size

46

Order Information

item_size_code

47

Order Information > Total

item_price

48

Order Information > Wholesale

item_unit_price

Items > Price

49

item_price_adjustment

50

Order Information > Sugg. Retail

item_retail_price

51

Order Information > Qty

item_quantity

Items > Qty

52

Order Information > Qty

item_multiplier

53

item_price_extended

54

item_comment

Line Notes (JOOR)

55

item_color_comment

56

item_door_id

57

STYLE TAGS FIELDS

58

style_tag_group

59

style_tag_name

60

style_tag_code

61

style_tag_value

62

DIVISIONS FIELDS

63

division_name

64

division_code

65

DOOR FIELDS

66

door_id

67

Door

door_name

68

Door

door_code

69

door_deleted

70

ORDER EXPORTS FIELDS

71

[Order View Page] > Export Status

export_success

72

[Order View Page] > Export Status

export_date

73

[Order View Page] > Export Status

export_message

74

SHIPPING FIELDS

75

Shipping Address > Code

shipping_code

Shipping Address > Label

76

Shipping Address > Shipping Name

shipping_name

Shipping Address > Addressee

77

Shipping Address > Phone Number

shipping_phone

Shipping Address > Phone

78

Shipping Address > Address 1

shipping_address_1

Shipping Address > Address 1

79

Shipping Address > Address 2

shipping_address_2

Shipping Address > Address 2

80

Shipping Address > City

shipping_city

Shipping Address > City

81

Shipping Address > State

shipping_region

Shipping Address > State

82

Shipping Address > Zip

shipping_postal_code

Shipping Address > Zip

83

Shipping Address > Country

shipping_country

Shipping Address > Country

84

shipping_country_iso_three

85

shipping_country_iso_two

86

Shipping Method > Ship With

shipping_method_name

Shipping Method

87

shipping_method_code

Shipping Carrier

88

Shipping Address > Email

shipping_email

Shipping Address > Email

89

BILLING FIELDS

90

billing_code

Billing Address > Label

91

Billing Address > Billing Name

billing_name

Billing Address > Addressee

92

Billing Address > Phone Number

billing_phone

Billing Address > Phone

93

Billing Address > Address 1

billing_address_1

Billing Address > Address 1

94

Billing Address > Address 2

billing_address_2

Billing Address > Address 2

95

Billing Address > City

billing_city

Billing Address > City

96

Billing Address > State

billing_region

Billing Address > State

97

Billing Address > Country

billing_country

Billing Address > Country

98

billing_country_iso_three

99

billing_country_iso_two

100

PAYMENT METHOD FIELDS

101

Payment Method > Terms

payment_method_name

Payment Method

102

payment_method_code

103

tax_id_label

104

WAREHOUSE FIELDS

105

warehouse_name

Department

106

warehouse_code

107

OTHER FIELDS

108

created_by_username

109

created_by_email

110

is_personal_order

111

order_internal_comments