Some imporant points Summary Post 2 Tables from

Hi,

You can have a look for Tables in MS Dynamics NAV from the below link. I am summarising the

concept below. If you like then do comment and subscribe to my blog post.

Tables by microsoft.

Note 1.

RECORDID Datatype :- It Stores RECORD ID and Primary key values.

Note 2.

ExtendedDataType property

When you select the Phone No. field without closing the No. -

Property window, notice that now the Phone No. – Property window is shown.

By selecting a value in the ExtendedDataType property, you will change the layout

and behavior of controls on a page. Use the value to add an icon next to an input

field to indicate whether the field relates to a phone number, email address, or URL.

Note 3.

Why we use Field Groups in Navision?

Note: If you do not define any Field Groups for the drop-down control, by

default, you will only see data from two fields in the source table: the primary key

and description fields, because these are indexed automatically.

Note 4.

Up to 40 keys can be associated to a table, and the first on the list is the primary

key. All other keys are secondary keys and optional.

The primary key is composed of up to 20 fields in a record. The combination of

values in fields in the primary key makes it possible for Microsoft SQL Server to

perform a unique identification of each record. The primary key determines the

logical order in which records are stored, regardless of their physical placement on

a disk.

Secondary keys are used to view records in an order that differs from the one in

which they are sorted, according to the primary key fields.

Note 5.

Note: The field ID that is specified in the TableRelation property must be in

the primary key of the table that is specified by the table ID in the property. If the

specified field is not the first field in the primary key, the other fields that are listed

before it in the key must be filtered to one value.

Note 6.

7 types of flowfields Sum, Average,Lookup,Exist,Min, Max,Count

Note 7.

SumIndexFields

A SumIndexField is a decimal field that can be attached to a key definition. This is

the fundamental feature of the Microsoft Dynamics NAV that constructs the basis

for FlowFields. SumIndexFields enable fast calculation of numeric columns in

tables,

Note 8.
Each key can have at most 20 SumIndexFields. During database design, a decimal field can

be associated with a key as a SumIndexField.

The type of SumIndexField must be numeric (Decimal, BigInteger, Integer or Duration).