> 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/documentation/guides/reference/bevica_database_schema.md). # Bevica Database Schema Explore all tables and fields in Bevica Business Central. Use Schema Tables and Schema Fields to review properties, relationships, and table information for reporting and integrations. The Bevica Database Schema shows you technical Table and Field related information. Used primarily by system administrators, developers, and report writers, it helps to understand the structure behind what Users see and how tables and fields can be used in extending the software's capability. The lists are automatically kept up to date reflecting the currently installed apps. ## Prerequisites * Access to Bevica Business Central * The information reflects the Apps installed in the environment. ## Overview {% embed url="" %} Access the pages below from Bevica Setup, Actions, Admin. Centre, Schema. An overview from Microsoft of object properties can be seen here: [AL Language Reference, Properties Overview](https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-properties) ## Schema Tables This page lists all tables in the database alongside table properties. Page options: * **Run Table:** This displays the data held against that table. Some tables do not have an associated page so you may see a 'No Pages found for this table message'. * **Table fields:** Drilldowns into the fields on the selected table. ## Schema Fields This page lists all fields in the database alongside field properties. Page options: * **Related, Table Information (All):** This displays a record per table/company with additional information such as the No. of Records, Size (KB), and Index Size (KB). Warning: This page is slow to open. More information here: [View table information](https://learn.microsoft.com/en-us/dynamics365/business-central/admin-view-table-information). * **Schema - Table factbox:** Shows table information. The factbox menu has additional options. * **Relation Field factbox:** Where the field has a RelationTable and RelationField, this displays details of that related table and field. The factbox menu has additional options. {% hint style="info" %} Note Your specific user permissions will determine which tables/fields are visible. {% endhint %} --- # 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/documentation/guides/reference/bevica_database_schema.md?ask=&goal= ``` `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.