You’re offline. This is a read only version of the page.
How to finding Table and Field Information in Microsoft Dynamics AX 2012?
*This post is locked for comments
I think that André meant Tabax.
Run this job you will get tables and properties.
You can find System Fields,User Define Fields & Sql Fields.
//A_PO Table Name
Share
Report
All responses (
Answers (
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.
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!
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
Thanks for your help :)
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156