#1 Dynamics NAV - Table Object

Table Object In NAV 2013 R2

Table Overview

         Tables are the most fundamental objects in Microsoft Dynamics NAV. They store records that are collected through pages. for example customers, sales, and inventories. These records are then presented to users through pages and reports.

About Table

       Records in Microsoft Dynamics NAV databases are stored in tables. A table can be visualized as a two-dimensional matrix, consisting of columns and rows. Each row is a single record, and each column is a field in that record.

    A table consists of table data and the table description. The table data contains the actual records and their fields. The table description specifies the layout and properties of the table and the fields.

     The table description is not directly visible to the user. When a developer creates a table, he or she assigns the table name, ID number, and fields. This establishes the table description.

      Field characteristics, such as field name, ID number, data type, and initial value together with the primary and secondary keys (used to sequence data) are also part of the table description.

    The table description contains properties, triggers, fields, and keys. The “Table Components and Their Relation” figure shows components of the table description and how they are related.

Table Description

Properties of Table

  Field No, Name, Caption, CaptionML, Datatype, Field Class, Min-Max Value, Table Relation, EDT(Extended data type), Width, etc
  this are important properties to work on table object.

Data Type

BLOB, Boolean, Code, Date, Decimal, Integer, Option, RecordID, Text, TableFilter, etc.

How to create Table in Object designer:

Steps:

1. Go-to tool menu: > Click Object Designer> Click table object> New table
2. In table window appears has fields that enters data in fields i.e

               1) Field No.

               2) field Name 

               3) Data Type & Length

               4) Description 

   and Save Table ID & Table Name.

Customer Table in Table Designer

Customer table and its Property 

Save the ID of table in between 50,000 to 90,000 any where save. this are customize tables & other table ID's are standard tables i.e parent level tables OR predefined tables.

Save the table and run it(Ctrl+R)