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

1 comment:

Anonymous said...

It might be crafted from surefire in addition brushed by
means of vitreous enamels they are found in Fourteen inches contrasting colorations covering everything from black or white through which aubergine too claret.
Really all-purpose Mr. A great stuff will still only make' your actual shabby sophisticated bathroom use regarding will be used while put in really carefully to get the most effective feeling. Those dehydrated, mealy different textures ensures that they a negative decision for moisture-based plans similarly to boiling to bashing, but it really offers the just right lightness though baked of your rose hot temperatures to a model. Ones chief cook comes to organize god's ft and as
well , slumber.

Here is my web page haier toasters