We are going to segregate the data types into several groups. We will first look at Fundamental data types, then Complex data types.
Fundamental data types are the basic components from which the complex data types are formed. They are grouped into Numeric, String, and Date/Time data types.
Just like other systems, NAV supports several numeric data types. The specifications for each NAV data type are defined for NAV independent of the support SQL Server database rule. But some data types are stored and handled somewhat differently from a SQL Server technician point of view than how they appear to us as NAV developers and users. For more details on the SQL Server-specific representations of various data elements, you should refer to Developer and IT Pro Help. Our discussion will focus on the NAV representation and handling for each data type.
The various numeric data types are as follows: