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.
And the available fields in the virtual table field are (2015):
|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.|