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).
Источник:
http://feedproxy.google.com/~r/Micro...ord-links.aspx