sqlaxaptabusiness-connector

AX / Axapta: Retrieve Custom fields via SQL


I'm creating a rather "dirty" business connector of my own here, and I'm having trouble finding those "custom fields" that have been created.

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


Solution

  • Sorry for bringing up a dead corpse, but I found out what was going on:

    The company I did this project for got two SQL-server, one is SRVSQL, and another one named SQLSRV ;) Hehe!

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

    (Blame the network admin ;)