Microsoft Dynamics AX (Archived)

Finding Table and Field Information in Microsoft Dynamics AX 2012"

(0) Share

Report

Posted on by Community Member

How to finding Table and Field Information in Microsoft Dynamics AX 2012?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your help :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

UmesH@ 810 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
DJRM 1,447 on at

Like (0)

Report

Where can I find this tool?

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

I think that André meant Tabax.

Was this reply helpful? Yes No