Monday, September 07, 2009

AX TableName in AOT and SQL

Well ran into this problem of searching for a table in SQL. I find the table in AX and was not able to find the corresponding table in SQL Server. Finally managed to figure out that AOT does not create table names more than 30 characters in the backend.

This maybe because AX wanted to keep the data structure portable between SQL and Oracle or any other ERP. Thus what AOT does is that if the table name exceeds 30 char it truncated the table name in such a way that when clubbed with the table id it runs into 30 characters

hence, if a table is created in AOT with name = HRPPartyPositionTableRelationship and id = 2226 it would be physically be created as HRPPARTYPOSITIONTABLERELAT2226