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.
(0x2E ‘+’ 0)
(0x2E ‘+’ 1)
(0x2E ‘+’ 22)
(0x13 ‘+’ 125)
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).
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?
Also having trouble using a field type "date" in the RecordID, I found the following resource on the formatting of date datatype within NAV, haven't been able to work out how to encode it in SQL though.
Excerpt from link:
The format of a normal date is <MMDDYY>D
The format of a closing date is <MMDDYY>C
http:// msdn.microsoft.com /en-us/library/dd301245.aspx <-- take out spaces
Any update on these for NAV 2015?