Creation Of Table In Microsoft Dynamics 365 BC

Table Creation In Microsoft Dynamics 365 BC

Step-01: 

• Right Click on the .vscode and select New File.

Step-02:

• Enter the Name of the table as shown.
• Note while naming the table .al extension is mandatory. 

Step-03:

• Type tt for creating a new table.
• ”t” is the prefix for finding the objects in VS.

Step-04:

• After step 03, table structure has been created.  

Step-05:

• In the above screenshot, the red underline is shown, this means that you have to specify the Id range of object while creating any object in the VS Code.
• For specifying the id ranges, go to the app.json file and enter the object id range.

Step-06:

• After the step 5, go to the Myfirst.Table.al file and see the result.

Step-07:

• Enter the Field Id and Field Name and it’s type.

Step-08:

• If you scroll-down , you can define primary key and triggers.

Learn more about Tables from the below link:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-tables-overview