AX / Dynamics 365 For Finance and Operations blog

AX / D365FO – Get TableId from TableName using SQL

Use this command.
Select * from SysTableIdView Where SystableIdView.Name = ‘PurchTable’
You will get Table id

More Posts

19.03

How to Increase the Number of Decimal Places in a Numeric Field in a Form (Dynamics 365 / AX)
16.12

How to Join Multiple Data Sources on Multiple Fields in a D365FO Form Query
24.10

SQL Azure DB – Creating a Restricted User in Azure SQL Who Owns Only Their Schema
23.10

AX / D365FO – Converting Enums to Text in SQL Views: The X++ Way
29.08

AX / D365FO – How to Call One Form from Another in Dynamics 365 Finance & Operations
11.06

AX / D365FO – Handling Time Zone Offsets and Daylight Saving in D365FO with X++

Leave a comment Cancel reply