Small and medium business | Business Central, N...

Tabel list for Business Central

(1) Share

Report

Posted on by NB-15051040-0

Hi Experts,

I hope you are able to help me.

Can you provide a list of tables in Business Central?

If this list also can give an insight in the data in each table it would be great.

I have an ODBC access to query tables from our Business Central via the program 'Microsoft Query'.

Currently I am looking for the data in section 'Inventory' on the item card.

Specificly the field 'Customer No.'.

This information is not stored in the table 'Item'.

I know it is possible to export (and import) data via the function 'Configuration Packages' but this is not what I am looking for.

Thanks in advance.

Have a nice day.

Best Regards Naja

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

black_s 328 on at

Like (0)

Report

Hi,

Search for Table Information in Business Central

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (1)

Report

The Table Information page gives you a list of tables per company.

There's no official documentation about the data model or Er-diagram, however this might help:

Work with essential development standards for Microsoft Dynamics 365 Business Central - Training | Microsoft Learn

The inventory field on the Item table is an example of a FlowField, it calculates the sum of quantity in the Item Ledger Entry table. To understand you will require some development knowlege in BC: The Business Central Developer Learning Journey (businesscentralbooster.com)

Do not go directly to the SQL database On Prem. Because in BC Saas you do not get access to the SQL database it would make your solution not BC Saas compatible. Instead use the APIs or develop net APIs.

Out Power BI Booster trainings also cover this in detail:

Business Central Power BI Training - Business Central Booster

Microsoft Business Central Advanced Power BI training (businesscentralbooster.com)

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (1)

Report

You can see here all the tables/pages and their fields in it. Not the most userfriendly approach though
MSDyn365BC.Code.History/BaseApp/Source/Base Application/InventoryMgt/Item.Table.al at 1f3fd8550d80f1c6e79d3492cdea7eeeb96b58a2 · StefanMaron/MSDyn365BC.Code.History · GitHub

You can see the same from Visual Studio Code

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

The only table information that can be obtained in the Business Central client is what you see in the Configuration Package. As Steven mentioned, you can only access real tables in SQL by opening them in local SQL, and SaaS does not support them. And the data in SQL is more complex, for example, you need to manually merge table extensions.

In addition, even if you can see all tables, when linked through external tools, such as Power Bi, you still need to publish them as an API page or web service.

Hope this helps as well.

Thanks

ZHU

Was this reply helpful? Yes No
NB-15051040-0 11 on at

Like (0)

Report

Thank you all for answers.

Now I know there is no official documentation on BC-tables.

As mentioned I use an ODBC access to query tables via the program 'Miscrosoft Query' and it works fine.

However I still haven't found in which table the 'Customer No' on the Item Card is located.

If anyone knows it will be very helpful for me.

Thanks.

Best regards Naja

Was this reply helpful? Yes No
jstockton 16 on at

Like (0)

Report

Did you ever figure this out?

Was this reply helpful? Yes No