Problem with Table Inheritance supporting tables

Finance and Operations/AX Technical Forum
1

Hello, I am facing an issue related to Table Inheritance.

I have added string field(TestStringField) to companyinfo table,supporting table inheritance.

when i go SQL,to find this field it was showing field name as Partition#48.

This is happening only for tables,supporting inheritance.

Thanks in advance.

2

Please tell us your exact AX version. You should always attach a tag with your version when creating a new thread.

3

2012 R3

4

As far as I know, the database of AX 2012 R3 doesn’t have any CompanyInfo table. Fields of CompanyInfo table (defined in AOT) are in DirPartyTable in database.
Can you confirm what database table are you looking at?

5

Im using following Sql selectstatement to check.
Select * from SQLDICTIONARY;

output is:
for companyinfo table
Testfield11 Partition#80

for AssetRule table
Testfield12 Testfield12

Testfield11 and Testfield12 are new fields.

6

What are you trying to achieve by the select to SqlDictionary table? You shouldn’t worry about such implementation details.

7

Ok.

Thanks

8

Hi vijaybhaskar2015,
I have the same issues with dirPartyTable. Have you found any solution?

Thanks

9

Hi Martin,
I found CompanyInfo table in AX 2012 R3 database.
Note: upgraded from R2.

10

It doesn’t exist in standard AX 2012 R3. If you have it, it’s either a custom table or you have some problem with your installation.