Virtual Table – AllObj

Hey Friends,

This Post is about Virtual Table – AllObj. AllObj virtual table contains information about all the Objects that NAV consists of. Here you can go and drag information on the Object level. Though there’s exist a virtual Table named Object as well from where you can drag multiple information but this depends on all on all your need and the information you want to pull off.

AllObj

Object Type – Type of the Object – Table Data, Table, Report etc.

Object ID – ID of the Object.

Object Name – Name of the Object.

CHEERS

 

Virtual Table – System Object

 

Hey Friends,

As we all know there are Virtual Tables as well as System Tables. So for recognizing System Objects there’s a Virtual table – System Object. This simply consists of all the System tables which are available in the NAV System.

Untitled

This Virtual Table consists of the above Fields with information as –

Object – Either it’s a Table, Page,Report and so on.

ObjectID – Unique ID of the Object.

Object Name – Name of the Object.

Object Caption – Caption of the Object.

Cheers.

Virtual Table – Key

 

Hey Friends,

This Post is about Virtual Table – KeyKey virtual table contains information about all the keys that are defined in each and every table in the database. Again like if you want to get the complete information of the keys the Standard and the one you created then can hit this virtual table. As we all know Sum Index Fields makes our work a way more easier but it’s too been recommended not to use too much of this as it reduces performance as that of Flow Fields.

So if you want to calculate how much Sum Index Fields you have made in the entire Database then you can hit this virtual table.

Untitled

This virtual table gives you the following Information’s –

TableNo –  ID of the Table.

No. – Its a sequential ID assigned for multiple fields of the same Table.

TableName – Name of the Table.

Key – Combination of Fields that makes the Key.

SumIndexField – SumIndexFields defined for that Key.

SQLIndex –  Actual fields that have been defined in Microsoft Dynamics NAV and are used in the corresponding index on SQL Server instead of those defined in the key.

Enabled – Either the Field is Enabled or not.

MaintainSQLIndex – MaintainSQLIndex property has been activated or not. This field can be modified.

MaintainSIFTIndex – MaintainSIFTIndex property has been activated. This field can be modified.

Clustered – Either the Key is Clustered or not. This field can be modified.

Cheers.

 

Virtual Table – Field

 

Hey Folks,

This Post is about Virtual Table – Field. Field virtual table contains information about all the fields of all the Tables in the Database. If at any time you want the complete specification of the Fields from development perspective then this virtual Table is for you. You can even use this Virtual Table for comparing the fields of different tables for any sort of queries you have.

Untitled

This Table consists of following specifications –

TableNo –  ID of the Table.

No. – Its a sequential ID assigned for multiple fields of the same Table.

TableName – Name of the Table.

FieldName – Name of the Field.

Type – Data Type of the Field.

Len – Length of the field(Bytes).

Class – Class of the field – FlowField,FlowFilter.

Enabled – Whether the field is enabled.

Type Name –  Data type assigned to the field with Length(Code,Text).

Field Caption –  Caption of the field in the language that has been selected.

RelationTableNo – ID of the Table on to which the Field is related.

RelationFieldNo – Number of the field in another table that the field is related to.

SQLDataType – Data type assigned to code fields.

Cheers

Virtual Table – Table Information

 

Hey,

This Post is about a Virtual Table – Table Information. Table Information gives the complete information of the Database Tables. You can Commutatively come to know about the load of each and every Tables of the Database in a single go.

Untitled

Company Name – Name of the Company.

Table No. – Unique ID of the Table.

Table Name – Name of the Table.

No. of Records – Number of Records in the Table.

Record Size – It’s an average size of the Record, calculated as 1024 x Size (KB)/Records.

Size (KB) – Space Occupied by the database in Table(KB).

Cheers

 

Virtual Table – Drive

Hey Friends,

This Post is all about a Virtual Table – Drive. Though many of us might not got the need to have an experience of this but this seems very useful if you have a very least access on your computer Drives and you don’t know which drive has how much of space and either it’s Removable or not.

Let’s see make a Page from the standard Dynamics NAV Wizard.

Untitled

Drive The available Drive in the System.

Removable Indicates whether the disk is removable (a CD-ROM or similar) or a Hard Disk.

Size(KB) – Total size of the disk.

Free(KB) Amount of free space on the disk

CHEERS

Virtual Table – Date

Hey,

Many times we have used Date as our Data Type in Tables and in Variables. Very often or even never we used Date as a Record Variable. This Post is all about using Date as a Record Data and we will see how powerful and helpful it is to use in our daily Programming.

This Virtual Table gives us a full fledge control on:

Period Type – Period Start – Period End – Period No – Period Name

Let’s see one example and make a Page from the standard Dynamics NAV wizard providing Date in the Table Name.

Capture

Currently in the above screenshot we have selected this Period Type as Date which explains –

Period Start – The Date which you have selected.

Period End – The Date which you have selected.

Period No – This shows the Days in Integer like  Monday – 1, Tuesday  – 2, Thursday – 3.

Period NameThis shows the name of respective Days.

Capture

Now in the above screenshot we have selected this Period Type as Week which explains –

Period Start – The Date which you have selected.

Period End – Date when week ends.

Period No – This shows starting week of the year and will continue till the year ends.

Period NameThis too shows the same information as above as week does not have a specific name.

Capture

Now in the above screenshot we have selected this Period Type as Month which explains –

Period Start – The Date which you have selected.

Period End – Date when month ends.

Period No – This shows the month in Integer like January – 1, February – 2, March – 3.

Period NameThis shows the name of respective Months.

Capture

Now in the above screenshot we have selected this Period Type as Quarter which explains –

Period Start – The Date which you have selected.

Period End – Date when quarter ends.

Period No – As we know quarters are of 3 month hence it’s now describing the quarter no..

Period NameThis too shows the same information as above.

Capture

Last but not the least now  we have selected this Period Type as Year which explains –

Period Start – The Date which you have selected.

Period End – Last day of the year..

Period No – Year.

Period NameThis too shows the same information as above.

Cheers.