RSS

Dynamics NAV: Field List

29 Aug

The last couple of years I have started to use an new trick to make my everyday life with Dynamics NAV easier.

Usually I have the problems like this:

  • How do I easy see all the locations of a certain field name in the database?
  • How can I quick look up a datatype for a certain field?
  • How can I quick see if a field is a flowfield?
  • How can I search on database fields using captions?

For me the solution became to make a page on the virtual table field (How to: Create a Page to View a Virtual Table).This is real handy when you have an addon table with 355 fields were the captions don’t really match the field names.

Here is the result and now I can filter on all these fields
Field list

And the available fields in the virtual table field are (2015):

Field Description
TableNo The ID number for the table.
No. The number assigned to the field.
Table Name The name of the table.
FieldName The name of the field.
Type The data type assigned to the field, for example, decimal.
Len The length of the field entry in bytes.
Class The class of the field, for example, FlowField.
Enabled Whether the field is enabled.
Type Name The data type assigned to the field. The length of the field entry in bytes is included for Code and Text data types.
Field Caption The caption of the field in the language that has been selected.
RelationTableNo The ID number for the table that the field is related to.
RelationFieldNo The number of the field in another table that the field is related to.
SQLDataType The data type assigned to code fields.
Advertisements
 
Leave a comment

Posted by on 2015-08-29 in Okategoriserade

 

Tags: , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Mark Brummel Blog | Microsoft Dynamics NAV

Master Classes Design Patterns and more...

Vjeko.com

ideas in the cloud

Goprowe AB

Reflections from the ERP field

ArcherPoint Developer Blog

Reflections from the ERP field

The NAV Viking´s Blog

- Sharing my experience in the Dynamics NAV world

Comments for waldo's blog

Reflections from the ERP field

Nav Can Be Fun

Its Really Fun to Work with Microsoft Dynamics Nav

Navision-Girl.Com

Reflections from the ERP field

LET'S TALK NAV

Tips, Tricks, How-To's & News about Microsoft Dynamics NAV & Dynamics 365 for Financials

Kine's Info

Reflections from the ERP field

blog.wibeck.org/

Just another WordPress.com site

NAV/SQL Performance - My Two Cents

Reflections from the ERP field

Hougaard.com – Applied Hacking

Reflections from the ERP field

Kauffmann @ Dynamics NAV

Reflections from the ERP field

Kriki’s Dynamics NAV blog

Reflections from the ERP field

Rashed Amini

Reflections from the ERP field

Olof Simren - Microsoft Dynamics NAV Blog

My blog about Microsoft Dynamic NAV tips and tricks. Remember to Subscribe!

Van Vugt's dynamiXs

Reflections from the ERP field

Navisionary – Dynamics NAV

Reflections from the ERP field

%d bloggers like this: