IndexDefragmentationPrioritizeTable on the SystemParameters form

Like (2) Share

Report

Posted on 6 Jan 2025 12:54:18 by LB developer

152

Hello experts,

The form data source IndexDefragmentationPrioritizeTable on the SystemParameters form, there are SchemaName and TableIdNumber fields, however these two fields are not on the table level. Where are these two fields coming from?

Thanks

Categories:

Dynamics 365 Finance

All responses (2)

Answers (1)

Verified answer

André Arnaud de Cal... 293,568 Super User 2025 Season 1 on 06 Jan 2025 at 14:00:08

Like (0)

Report

IndexDefragmentationPrioritizeTable on the SystemParameters form

Hi LB Developer,

Development object IDs like Table IDs were used in the past as reference between Dynamics AX and the SQL database. It was then possible to rename a table where the synchronization took care of renaming the SQL table. It also has some downsides, like not having the same table IDs per environment.

In the current architecture, there is no SQL dependency, but the IDs are still used internally. You can check the Table IDs using the system view SysTableIdView.

The SchemaName is maintained by the application itself. E.g. DBO is used for tables related to the F&O application, MR is used for the Financial reporter.
Martin Dráb 232,621 Most Valuable Professional on 06 Jan 2025 at 13:14:04

Like (0)

Report

IndexDefragmentationPrioritizeTable on the SystemParameters form

You seem to mean SystemJobParameters form (instead of SystemParameters).

I don't know any more details, but they look like system fields similar to TableId (which isn't stored in database either).