Tables in D365

 

Tables

Steps: 

·       Create New Project -- Right click and create new table (AttEmployeeTable)

·       Expand the newly created table and you will find a new field’s node.

·       Drag and drop all the extended datatypes which you want as field to field’s node, for all fields - label and help text are important.

             You can even drag and drop the Enum on to the table - it will create a new enum field.

Important properties on the field:

Label

HelpText

Mandatory

AllowEditonCreate

AllowEdit

Visible

EDT

EnumType

 

The system will automatically create 4 new fields in every table:

DataAreaId - current logged in company

Recversion - int64 - for concurrent updates

RecId - int64 - unique record id [when u save a record - interview & certification question]

Partition Id

Why indexes ?

Index will help you for performance for select statements [Improve performance of select statements]. In Ax It also doesn’t allow duplicates

 

How to stop adding duplicates - Restrict the redundancy of data

·       Go to Index node in the table >> right click and new Index >> Drag and drop the EmployeeId field to newly created index.

 

·       Best practise [MS Recommends - ] Index name should Have the prefix as your fieldname and suffix as Idx – EmpoyeedIdx

 

·       Set the allow duplicates property to No

 

Field group:

Grouping up of similar fields for easy identification in one place.

Right click on the field groups >> New Group >> Give the Name as AddressInfo, label as Address information

Drag and drop all address related fields to the newly created field group

 

AutoReport:

AutoReport field group will help to quickly generate a Excel Add-in & report based on the fields whatever you have dragged and dropped in to it

Drag and fields to the AutoReport

Important Tables:

CustTable - The table for basic customer information.

VendTable - The table for basic vendor information.

LedgerTable - The table for the general ledger it have chart of accounts information.

InventTable - The table for the general inventory information.

PurchTable - The table for purchase order creation information.

SalesTable - The table for sales order creation information.