> For the complete documentation index, see [llms.txt](https://kb.bevica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.bevica.com/bevica-select/bevica-select-data-migration/business-central-bevica-data-structures.md).

# Business Central Bevica data structures

Understand Bevica in Business Central: tenants, environments, companies, extensions, AL objects, and tools like metadata pages and Page Inspection.

This page is intended as an introduction to how Business Central Bevica is technically structured and how to see data and the relationships between that data.

## Prerequisites

* Access to a Business Central environment.

## Infrastructure

Business Central Bevica sits inside the Microsoft ecosystem which provides a hierarchical approach to its structure:

1. Tenant
2. Environments
3. Companies

More information here: [Understanding the Infrastructure of Business Central Online (Microsoft Learn)](https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/tenant-environment-topology)

## Extensions

Features and functionality are provided within an environment by extensions. To see the extensions installed in your environment navigate to **Extension Management**. The primary Business Central extension is provided by Microsoft and is called **Base Application**. All other extensions interact with this primary extension.

## AL Language

AL is the programming language that is used for manipulating data such as retrieving, inserting, and modifying records in an environment. It controls the execution of the various application objects, such as pages, reports, or codeunits. AL provides the business rules to ensure that the data, which is stored in an environment, is meaningful and consistent with the way you do business.

The main application objects are listed here:

<table data-header-hidden="false" data-header-sticky><thead><tr><th>Field</th><th>Note</th><th>Further Information</th></tr></thead><tbody><tr><td>Table</td><td>Tables are the core objects used to store data. No matter how data is registered in the product - from a web service to a finger swipe on the phone app, the results of that transaction will be recorded in a table.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-object">Table object (Microsoft Learn)</a></td></tr><tr><td>Page</td><td>Pages are the main way to display and organise visual data. They are the primary object that a user will interact with and have a different behaviour based on the type of page created. Pages are designed independently of the device they are to be rendered on, and in this way the same page can be reused across phone, tablet, and web clients.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-page-object">Page object (Microsoft Learn)</a></td></tr><tr><td>Report</td><td>Reports are used to print or display information from a database. You can use a report to structure and summarise information, and to print documents, such as sales quotes and invoices. They can also be used to transform data.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-object">Report object (Microsoft Learn)</a></td></tr><tr><td>Codeunit</td><td>A codeunit is a container for AL code that you can use in many application objects.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-codeunit-object">Codeunit object (Microsoft Learn)</a></td></tr><tr><td>Query</td><td>Query objects can retrieve records from one or more tables and then combine the data into rows and columns in a single dataset. Query objects can also perform calculations on data, such as finding the sum or average of all values in a column of the dataset.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-object">Query object (Microsoft Learn)</a></td></tr><tr><td>XMLPorts</td><td>XMLports are used to export and import data between an external source and Business Central Bevica. Sharing data between different computer systems is seamless when it is shared in an XML format.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-xmlport-object">XMLPort object (Microsoft Learn)</a></td></tr><tr><td>Profile</td><td>The profile object contains the rules and other objects to build an individual experience for each user profile. The Profile object performs a validation to check whether the specified role centre page exists, page customization objects exist when a new profile object is created.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-profile-object">Profile object (Microsoft Learn)</a></td></tr><tr><td>Permission Set</td><td>The permission set object lists permissions on objects. Permission sets are building blocks used to compose assignable permission sets and entitlements. Assignable permission sets are permissions that an admin can assign to users in Business Central Bevica, using the Permission Sets page. An entitlement is a collection of permission sets that constitute a set of meaningful permissions for a user.</td><td><a href="https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-permissionset-object">Permission Set object (Microsoft Learn)</a></td></tr></tbody></table>

## Data structures / data schema

The software provides a number of pages to help understand the data structures within the environment you are logging into.

**Table Metadata**

This displays all the tables within the environment with additional information. Where a page exists for any specified table select the ribbon **Run Object** option.

![Business Central “Table Metadata” list page, used to browse tables and open related pages via Run Object.](https://2760122862-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fx3XuahSies5HnodsWowA%2Fuploads%2Fgit-blob-30f41b905933f09ca0af2511ed4082650a20201f%2FE-LfPTEf6yoruNku-Ibq8Zx_uRdEPkB-dg.png?alt=media)

**Table Information**

This shows, for each company in the environment, every table with the number of records in each and allocated database sizes.

![Business Central “Table Information” page showing table record counts and database size by company.](https://2760122862-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fx3XuahSies5HnodsWowA%2Fuploads%2Fgit-blob-c709bc3460cd1008a4c7f23858256a74022249a6%2FZuhNJ0Q7gptFrtZ4IEgo7NdnmwgegIC2AA.png?alt=media)

**Field**

The **Field** Page displays each field and its properties. It also shows the relationship between fields.

![Business Central “Field” page showing field properties and relationships used to understand table schema.](https://2760122862-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fx3XuahSies5HnodsWowA%2Fuploads%2Fgit-blob-f55a64455127ea659a7930fca2c740e0e59b7d01%2F13w6do6QJzO6oAxI4Jbu7JkkukwGLl49TQ.png?alt=media)

**Page Metadata**

This displays all the pages within the environment with additional information. The ribbon, **Run Object** option can be used to open that page.

![Business Central “Page Metadata” list page showing page objects and the Run Object action to open a page.](https://2760122862-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fx3XuahSies5HnodsWowA%2Fuploads%2Fgit-blob-03ed02e0d36cbdf3de3cd5f098f4b6617141b91d%2FNQspxYmGldgRTSw1HetBVEcuYAOjdNJAPQ.png?alt=media)

## Page Inspection

In addition to the above lists, on each page you have the ability to see, normally hidden, table and field information.

From any Page choose the question mark in the top right corner, choose Help & Support, and then choose **Inspect pages and data** or click Ctrl + Alt + F1 to open **Page Inspection**. This displays the Page name, its Id and Type alongside the table it is based on. It also displays all the fields the page has access with the extensions responsible for those fields.

![Business Central “Page Inspection” pane showing page name/type, source table, fields, and extensions providing those fields.](https://2760122862-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fx3XuahSies5HnodsWowA%2Fuploads%2Fgit-blob-ba953a6c7dee95865d1e8894f029571e364ffd7a%2FojD_nB3-fv8Xt4cc_XoeZ7Ylm005b-TyYQ.png?alt=media)

Clicking **Table View** will open the raw table data for read-only access. For larger tables, this can take a time to open and impact system performance.

For more information click here: [Inspecting Pages in Business Central (Microsoft Learn)](https://learn.microsoft.com/en-gb/dynamics365/business-central/across-inspect-page)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://kb.bevica.com/bevica-select/bevica-select-data-migration/business-central-bevica-data-structures.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.