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).
