ConfigurationNAV 4 Field Lengths

NAV 4 Field Lengths

Sana Commerce 8.1
Your provider

B2C Page Changes

  
Each table below refers to the page in the Sana Commerce webshop, where input text fields can be found. NAV tables can be opened using 'Object Designer' (select 'Tools -> Object Designer' in NAV and then choose 'Table' tab). The table header in this document is the name of the page in a webshop. Input text fields that have a different length in NAV 4 and NAV 5 are marked with a different color. 
 
Create New Account (B2C): 
 
Text Field
Name on
Front-end
NAV
Table
Number
NAV
Table
Name
Table
Field
Number
Table
Field
Name
NAV 4
Field
Length
NAV 5
Field
Length
Name 18 Customer 2 Name 30 50
Name 18 Customer 3
Search
Name
30 50
Name 11123304
SC -
ShopAccount
4 Name 50 50
Address 18 Customer 5 Address 30 50
Address 2 18 Customer 6 Address 2 30 50
Zip Code 18 Customer 91 Post Code 20 20
City 18 Customer 7 City 30 30
Phone
Number
18 Customer 9 Phone No. 30 30
E-Mail
Address
18 Customer 102 E-Mail 80 80
E-Mail
Address
11123304
SC -
ShopAccount
2 E-Mail 80 80
Password
(Confirm
Password)
11123304
SC -
ShopAccount
3 Password 30 30
 
Your Details (B2C): 
 
Text Field
Name on
Front-end
NAV
Table
Number
NAV
Table
Name
Table
Field
Number
Table
Field
Name
NAV 4
Field
Length
NAV 5
Field
Length
Name 18 Customer 2 Name 30 50
Name 18 Customer 3
Search
Name
30 50
Name 11123304
SC -
ShopAccount
4 Name 50 50
E-Mail
Address
18 Customer 102 E-Mail 80 80
E-Mail
Address
11123304
SC -
ShopAccount
2 E-Mail 80 80
Address 18 Customer 5 Address 30 50
Address 2 18 Customer 6 Address 2 30 50
Zip Code
18 Customer 9 Phone No. 30 50
City
18 Customer 7 City 30 30
Phone
Number
18
Customer
9 Phone No. 30 30
 
Billing/Shipping (B2C): 
  
There are two options on the 'Billing/Shipping' page for a B2C customer that can be selected using the radio button:
  • 'Deliver the order on the same address as the billing address'. In this case, the billing address of a customer is equal to the shipping address, so all the 'Shipping' input text fields are disabled and data from the 'Billing' fields in a webshop is automatically filled in both the 'Bill-to' and 'Ship-to' fields in NAV.
  • 'Deliver the order on another address'. In this case, a customer can enter the shipping address data himself. It will be stored in the 'Ship-to' fields in NAV separately.
    The tables for each option are different and presented below.
  • 'Deliver the order on the same address as the billing address' option is selected: 
Billing/Shipping Address Fields 
 
Text Field
Name on
Front-end
NAV
Table
Number
NAV
Table
Name
Table
Field
Number
Table
Field
Name
NAV 4
Field
Length
NAV 5
Field
Length
Name 18 Customer 2 Name 30 50
Name 18 Customer 3
Search
Name
30 50
Name 11123304
SC -
Shopaccount
4 Name 50 50
Name 36 Sales Header 79
Sell-to
Customer
Name
30 50
Name 36 Sales Header 5
Bill-to
Name
30 50
Name 36 Sales Header 13
Ship-to
Name
30 50
Address 18 Customer 5 Address 30 50
Address 36 Sales Header 81
Sell-to
Address
30 50
Address
36 Sales Header 7
Bill-to
Address
30 50
Address 36 Sales Header 15
Ship-to
Address
30 50
Address 2
18 Customer 6 Address 2 30 50
Address 2
36
Sales Header
82
Sell-to
Address 2
30 50
Address 2
36
Sales Header
8
Bill-to
Address 2
30 50
Address 2 36 Sales Header 16
Ship-to
Address 2
30 50
Zip Code 18 Customer 91 Post Code 20 20
Zip Code 36 Sales Header 88
Sell-to
Post Code
20 20
Zip Code 36 Sales Header 85
Bill-to
Post Code
20 20
Zip Code 36 Sales Header 91
Ship-to
Post
20 20
City 18 Customer 7 City 30 30
City 36 Sales Header 83
Sell-to
City
30 30
City
36 Sales Header 9
Bill-to
City
30 30
City 36 Sales Header 17
Ship-to
City
30 30
Phone
Number
18 Customer 9 Phone No. 30 30
  • 'Deliver the order on another address' option is selected: 
Billing Address Fields 
 
Text Field
Name on
Front-end
NAV
Table
Number
NAV
Table
Name
Table
Field
Number
Table
Field
Name
NAV 4
Field
Length
NAV 5
Field
Length
Name 18 Customer 2 Name 30 50
Name 18 Customer 3
Search
Name
30 50
Name 11123304
SC -
Shopaccount
4 Name 50 50
Name 36 Sales Header 79
Sell-to
Customer
Name
30 50
Name 36 Sales Header 5
Bill-to
Name
30 50
Address 18 Customer 5 Address 30 50
Address 36 Sales Header 81
Sell-to
Address
30 50
Address
36 Sales Header 7
Bill-to
Address
30 50
Address 2
18 Customer 6 Address 2 30 50
Address 2
36
Sales Header
82
Sell-to
Address 2
30 50
Address 2
36
Sales Header
8
Bill-to
Address 2
30 50
Zip Code 18 Customer 91 Post Code 20 20
Zip Code 36 Sales Header 88
Sell-to
Post Code
20 20
Zip Code 36 Sales Header 85
Bill-to
Post Code
20 20
City 18 Customer 7 City 30 30
City 36 Sales Header 83
Sell-to
City
30 30
City
36 Sales Header 9
Bill-to
City
30 30
Phone
Number
18 Customer 9 Phone No. 30 30
 
Shipping Address Fields 
 
Text Field
Name on
Front-end
NAV
Table
Number
NAV
Table
Name
Table
Field
Number
Table
Field
Name
NAV 4
Field
Length
NAV 5
Field
Length
Name 36
Sales Header
13
Ship-to
Name
30 50
Address 36
Sales Header
15
Ship-to
Address
30 50
Address 2 36
Sales Header
16
Ship-to
Address 2
30 50
Zip Code 36
Sales Header
91
Ship-to
Post Code
20 20
City 36
Sales Header
17
Ship-to
City
30 30
 
 
ConfigurationNAV 4 Field Lengths