Share
ReportWhy cannot I find it in SQL, I could see it in AOT but not in SQL. Why?
*This post is locked for comments
You’re offline. This is a read only version of the page.
1,146
Why cannot I find it in SQL, I could see it in AOT but not in SQL. Why?
*This post is locked for comments
Hi Andre,
Thanks for showing me the correct way. I've been using most of my legal entity queries using the ax.CompanyInfo on SQL Server. I just checked that both company info tables (retail and FO) have the same RecId per DataArea, probably that's why I've never found anomalies when fetching data.
Hi Danyal,
The tables with "ax" as prefix are tables used for retail. This is a complete different table. The answer from Sukrut is correct.
Hi Kumar_Sat,
I am not sure about AX 2012 (since I've never used it), but same thing happens in D365FO as well, I'd have to add ax. prefix before I can actually query the CompanyInfo table.
select * from ax.CompanyInfo
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (