NAV Team: Table Data Type values (used in Record Links)

[Blog bot]

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