Sometime ago I have promised to publish the numbers used in NAV for the data types. These numbers are used all over the system, but are more visible when encoding record links (please refer to my post about encoding record links). This list contains the data types that are available in Tables in NAV 2009 SP1.
|
Data type |
ID |
Comment |
|
Integer |
00 86 |
|
|
Text |
00 88 |
|
|
Code |
00 89 |
|
|
Decimal |
00 32 |
|
|
Option |
00 8B |
|
|
Boolean |
00 85 |
|
|
Date |
00 2E |
(0x2E ‘+’ 0) |
|
Time |
01 2E |
(0x2E ‘+’ 1) |
|
Binary |
N/A |
|
|
BLOB |
N/A |
|
|
DateFormula |
16 2E |
(0x2E ‘+’ 22) |
|
TableFilter |
N/A |
|
|
BigInteger |
00 8D |
|
|
Duration |
00 90 |
|
|
GUID |
00 91 |
|
|
RecordID |
7D 13 |
(0x13 ‘+’ 125) |
|
DateTime |
00 92 |
|
Internally some types are “extensions” of other types, and therefore are composed as a base type and subtype ID. As an example Time (2E ‘+’ 1) is a “subtype” of Date (2E ‘+’ 0).