Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Finding Table and Field Information in Microsoft Dynamics AX 2012"

Posted on by Microsoft Employee

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

  • Martin Dráb Profile Picture
    Martin Dráb 224,741 Super User on at
    RE: Finding Table and Field Information in Microsoft Dynamics AX 2012"

    I think that André meant Tabax.

  • DJRM Profile Picture
    DJRM 1,445 on at
    RE: Finding Table and Field Information in Microsoft Dynamics AX 2012"

    Where can I find this tool?

  • Suggested answer
    UmesH@ Profile Picture
    UmesH@ 810 on at
    RE: Finding Table and Field Information in Microsoft Dynamics AX 2012"

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Finding Table and Field Information in Microsoft Dynamics AX 2012"

    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!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Finding Table and Field Information in Microsoft Dynamics AX 2012"

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Finding Table and Field Information in Microsoft Dynamics AX 2012"

    Thanks for your help :)

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,663 Super User on at
    RE: Finding Table and Field Information in Microsoft Dynamics AX 2012"

    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. 

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans