Reading upon this documentation about AOT tables:
"Tables store business data. Each table in the AOT has a corresponding table in the underlying Microsoft SQL Server database."
https://learn.microsoft.com/en-us/dynamicsax-2012/developer/tables-views-and-maps
However, upon doing some select queries in SQL Server, there is one derived table in AOT, that is NOT reflecting in the SQL Server database.
As I do select query for this table, it results to
Msg 208, Level 16, State 1, Line 45
Invalid object name 'BaseTableName'
Hope to get some light about this issue, if this is some db synchronization issue or base table (which extends to other derived table) from AOT does not really reflect in the SQL Server database counterpart.
All fields defined in Dynamics AX in derived tables are placed directly in base table in database.
The derived tables exist as independent objects in application layer only.
Since all the derived tables data are stored in base table, AX differentiate them by a column InstanceRelationType which is RelationType EDT. Values in InstanceRelationType represents table IDs.