Object Specifications and Limitations – in Navision 2015

Today I would like to discuss few important information. It always good to know out limitations, so do the limitation of the tools we are using. It helps in planning the design what all are possible and where are the limitations.

This could be also helpful for person taking interviews or appearing for interviews.

Below are the specifications and limitations for the database and application objects.

Specifications for the database

Feature	Characteristic
Maximum number of physical disk files	16
Database file size	256 GB
Maximum number of objects in a database	1,000,000,000
Maximum number of characters in application object names	30
Maximum number of characters in a Database Authentication password	80

Specifications for Tables

Feature	Characteristic
Range for table object ID numbers	1 - 999,999,999
Maximum number of characters in a table name	30
Maximum table size	Depends on available storage
Maximum number of records in a table	Depends on available storage
Maximum record size	8000 bytes
Maximum number of fields in a record	500
Range for field numbers	1 - 999,999,999
Maximum number of keys for a table	40
Maximum size of a Microsoft Dynamics NAV key	900 bytes
Maximum number of distinct fields per key	16
Maximum size of an index	900 bytes
Maximum number of SumIndexFields per key	20
Maximum number of characters in a text or code field	250
Maximum size of a BLOB field	2 GB
Maximum number of characters in a field name	30

 Specifications for Pages and Reports

Feature	Characteristic
Range for page or report object ID numbers	1 - 999,999,999
Maximum number of characters in a caption	1024
Maximum bitmap size in bitmap property	32500 bytes

Specifications for Codeunits

Feature	Characteristic
Range for codeunit object ID numbers	1 - 999,999,999
Maximum number of characters in variable names	30
Maximum number of dimensions in array variables	10
Maximum number of elements in an array variable	1,000,000
Maximum physical size of a codeunit	2 GB
Lower bound of index in an array	1

All application objects are identified by an ID number. There are restrictions, however, on the numbers you can use when you create your own application objects. Check with your Partner License Agreement for more information.