Clever Geek Handbook

AX / Axapta: getting custom fields via SQL

I am creating a rather dirty business connector here and am having trouble finding those "custom fields" that were created.

They show up in AX, but they are not mentioned in the SQL database at all ... I have a suspicion that all custom fields are stored somewhere else in the database, so the initial state of the tables does not get alterd - but where?

-1


source to share


2 answers


Sorry for raising a dead corpse, but I found out what's going on:

Company, I made this project to get two SQL servers, one is SRVSQL and the other is SQLSRV;) Hehe!



So all custom fields were stored in tables in SRVSQL and I was connected to SQLSRV;)

(Kill the network administrator;)

0


source


Dyamics Ax does not have such fields, but some fields may have a different name in SQL Server than the Axbecause field values ​​for the field name in the case of a long field name. There is a SQLDictionary table for mapping names in Ax and names in SQL



0


source






More articles:


All Articles