You’re offline. This is a read only version of the page.
Announcements
75
Hello guys,
I need to find the table names, table ID and so on of some tables in AX12. I used the table SQLDICTIONARY to find the required info. It works fine, however I noticed, that some of the tables are missing in SQLDICTIONARY, for example table AifOutboundPort. This table exists in AOT, but I can not get the table ID and name from SQLDICTIONARY, the table is just not there.
Is there please any reason, why some of the tables are missing in SQLDICTIONARY? And is there some other table that might be used to get required data? I need to get the data using SQL, not x++ code.
Many thanks, regards Sayid.
Ask if needed, I do have some idea about table inheritance.
It would likely mean creating a new thread; the question of missing tables seems to be answered.
Accessing the database directly is strongly discouraged for many reasons and you now see one of them. In your case, you're making a mistake by thinking that what you see in the application can be seen in database in the same way. You could easily use tables like EcoResCatalogControl if you did the right thing and implemented your logic in the application layer, but no such table indeed exists in the database. If you want to access the data, you'll need to learn some implementation details about how AX deals with table inheritance.
There is just one table for the whole inheritance hierarchy, with the name of the root table. Different types of records are distinguished there by InstanceRelationType field. You can learn more in Developing with Table Inheritance.
I am sorry, the AifOutboundPort was a bad example. Yes, I do, I can see for example EcoResCatalogControl, EcoResCategoryInstanceValue... Those tables I can see in AOT in ax12, they have configuration key inserted, but they are missing in SQLDICTIONARY, so I do not know, how to get their table name, table id... using sql.
I wonder why you want to access AifOutboundPort table if it's disabled and it doesn't really exist.
Do you see any of those tables (that aren't in SqlDictionary) actually in the database?
I see, thanks :) Unfortunately I am not allowed to change it, I was just asked to get the data using sql... I try to get the data from the old env (where the tables are missing in sqldictionary) to import them into new one and I am not able to change the old one. On the other hand, there are many tables missing in sqldictionary but having configuration key. Isn't it possible that something else causes it?
Yes, I meant the confirutation key. The key word (pun intended) got lost somewhere. :)
How can I check it, please? I am sorry, I am new at ax12 at all, did you mean to check configuration key of the table? For this table, the configuration key is not inserted, it is disabled. On the other hand, there are some tables that are missing in sqldictionary but have the configuration key enabled/filled.
Isn't the configuration of AifOutboundPort table disabled? I don't remember if such tables are in SqlDictionary. My guess is that they aren't.
#1
André Arnaud de Cal...
294,125
Super User 2025 Season 1
#2
Martin Dráb
232,871
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
