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