Get Table Id and Field Ids of D365 F&O Table through SQL query

(0) Share

Report

Posted on by Rhushikesh R

758

Hi Everyone,

Using below SQL query I can get the Table Id,

select * from SysTableIdView where Name = 'CustTable'

Can anyone please help me with SQL query to get field Ids of all fields of a particular table? This is possible and I have done this long time back, so unable to recall it.

I don't want to fetch field Id of a single field. I want the list of all field names and their IDs.

Thank you in advance.

I have the same question (2)

All responses (6)

Answers (1)

Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

Try SysTableFieldIdView.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
Thank you Nikolaos for quick response.

I am able to fetch field Ids with below query now.

select * from SysTableFieldIdView where SysTableFieldIdView.Id = '77'

In above Query, SysTableFieldIdView.Id (77) is a Table Id

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (1)

Report

Hi Rhushikesh,

A small additional comment. Note that the IDs can be different in each environment.

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report

Hi Andre,

Then how could we identify the IDs for UAT and Production environment? As we don't have SQL access of UAT and Production in D365, do I need to write X++ job for same?

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (1)

Report

Why would you do that?

Please tell us what you're trying to achieve from business point of view. We can't suggest a meaningful technical design without knowing what you need to achieve.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Table and field IDs are technical IDs that are intended for D365 internal usage. As long as you're working inside D365, you can use the mentioned views in x++ to get the info. And if you're working outside D365, then table and field ids should be irrelevant.

Please let us know what is your functional requirement. Thanks!

Was this reply helpful? Yes No