Table Data Type values (used in Record Links)

Table Data Type values (used in Record Links)

  • Comments 1

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

Leave a Comment
  • Please add 2 and 7 and type the answer here:
  • Post
  • Just curious how you would handle the date part of a record link key in SQL. I have tried convert(varbinary,[Entry Date]) and a lot of different versions of that, but have had no luck. Can you point me in the right direction?

Page 1 of 1 (1 items)