Announcements
No record found.
How to finding Table and Field Information in Microsoft Dynamics AX 2012?
*This post is locked for comments
How do I have to interpret your question?
Within the help of AX (and on technet) some descriptions of the table and the fields are available.
If you want to find out from a form which table/field is used, you can right click on a control and click the 'Personalize' menu-item. Information of the datasource (table) and field used is available in the field 'System name'.
The tab query contains the structure of tables used on this form.
Also a tool was/is available on internet where with a key combination ('Shift+Enter') the table and field names are being displayed.
Thanks for your help :)
You may try also to press 'F1' while focusing on particular field; menu will then appear, chose 'quick info' and you will see table/field name. Regaring both methods - be aware that not always you will have real table/field name, as in some cases temporary tables are being used (name shown may be then name of table which does not exisi on SQL server)
regards
Tomasz
I would like to be able to find the table that stores the warehouse field found in the Where Used table. I have tried BOM, BOM Table, BOMVersion and am not able to find it. I have tried using the INVDIM column in these tables and comparing it to Inv DIM but doing that method shows that all of the formulas listed have a warehouse specified in the Where Used screen which I know is not the case. Where can I find this info?
Thanks!
Run this job you will get tables and properties.
You can find System Fields,User Define Fields & Sql Fields.
//A_PO Table Name
static void SystemClassesFields(Args _args) { SysDictTable dictTable; DictField dictField; Common common; Counter counter; ; dictTable = new SysDictTable(tableNum(A_PO)); for (counter=1; counter<=dictTable.fieldCnt(); counter++) { dictField = new DictField(dictTable.id(), dictTable.fieldCnt2Id(counter)); if (dictField.isSystem()) { info(strfmt("System field: %1", dictField.label())); info(strfmt("System field: %1", dictField.name())); } else info(strfmt("User field: %1", dictField.label())); } if(dictField.isSql()) { info(strfmt("sql field: %1", dictField.label())); } }
Thanks.
Where can I find this tool?
I think that André meant Tabax.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
