ConfigurationNAV 4 Field Lengths

NAV 4 Field Lengths

Sana Commerce 8.1
Your provider

Select all
Back Next

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
 
 
Back Next
ConfigurationNAV 4 Field Lengths

Sitemap

Installation

Product Versions

Links

Sana Commerce does not accept any liability for the content of this website, or for the consequences of any actions taken on the basis of the information provided. The information below should be interpreted as an example. No rights can be derived from this information.

Sana Commerce – the integrated e-Commerce solution for Microsoft Dynamics NAV & AX
© 1998 - 2014 Sana Commerce. All rights reserved
Updated: March 2012