D365FO - How to get the correct database table and field names

(0) Share

Report

Posted on by MarinaAX

730

Hi there,

Could you please advise how to determine the names of the related database and fields for the purpose of the FDD writing?

Right now I am getting the unexpected form name "ProjCategory" whereas I know that this form is "Cost category".

8244.Info.png

Many thanks, in advance!

Categories:

Finance and Operations

All responses (9)

Answers (1)

Sort by

Verified answer

André Arnaud de Cal... 307,301 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Marina,

In your provided example, you can click 'Form name: ProjCategory'. Then you get a slider at the right side of the form. Then open the Administration fast tab. You will find two fields called 'Datasource' and 'Data field'. The name between brackets in the datasource is the table name. The data field is the field name used.
MarinaAX 730 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for the informative reply, André!

I tried your solution on the different page which was of my original largest interest - Security configuration form, however it does not contain the Datasource and Data field fields populated. The query statement Query object ebacbdd0: SELECT FIRSTFAST FORUPDATE * FROM SysSecUnpublishedObjects(SysSecUnpublishedObjects) USING INDEX TypeIdentifierIdx does not have explicit query. Would you be so kind to assist me in getting the names of the tables which contain details on roles, duties and privileges? Do I need to create a new question or we can continue the discussion in the present page?

The animated image below is clickable.

Thank you very much for your help and attention, in advance!
André Arnaud de Cal... 307,301 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Marina,

I think you clicked on a white space on the form to get the form information. Try to right-click on an existing control. Furthermore, like Sukrut mentioned, the data is temporary. It reads from application metadata as well as configuration tables where changes to the standard are maintained.
MarinaAX 730 on at

Like (0)

Report
Copy link

Link copied!

André, thank you very much for the advice! I tried to click on different places of the form, but was able to access the form details only following the above mentioned path. Would you be so kind, if possible, to show on the screenshot where should I click, please?

Many thanks, in advance!
MarinaAX 730 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for the information, Sukrut!

Would you be so kind to advise how to use the tables and classes in order to build a report which provides the output of roles, duties and privileges assignment for the current D365FO instance?

Many thanks, in advance!
MarinaAX 730 on at

Like (0)

Report
Copy link

Link copied!
Thank you very much, Sukrut! Unfortunately, the Add-ins approach shows only Roles and Duties, but does not show the privileges (which are the most interested part of the security model) and I have access to test on Platform 7 only. In addition to that, the SysSecRoleLookup, SysSecDutyLookup, and SysSecPrivilуgelookup contained only the list of potentially existing roles, duties and privileges, but I was unable to decipher the class in order to create a meaningful report. So, may be you would be kind enough to advise me how to create a report myself. The report should show 3 columns:

Roles (which roles exist)

Duties (for each existing role)

Privileges (for each existing duty or role if the privilege is not attached to the duty)

Many thanks for your help, in advance!!!
Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Hi MarinaAX,

It could be a good idea to download Update 9 VM and check how existing report works instead of inventing your own bicycle.
MarinaAX 730 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for the wise advice, Ievgen! But unfortunately I have access to the PU7 only. So may be anybody else had success with resolving the similar issue and will be kind enough to share his/her recommendations.