Microsoft DynamicsFree referencePDF, Excel, Word exportMicrosoft Dynamics 365 Business Central

Business Central Table Numbers Reference (Searchable List)

Every Business Central and NAV developer or functional consultant ends up asking which table holds a given posting. This list gives the base table number and name for the objects you reach for most often, with a plain description of what each one holds.

Download:

Table no.	Table name	Area	What it holds
15	G/L Account	Finance	Chart of accounts master records
17	G/L Entry	Finance	Posted general ledger entries
45	G/L Register	Finance	One row per posting batch, with from and to entry numbers
18	Customer	Sales	Customer master records
21	Cust. Ledger Entry	Sales	Open and closed customer ledger entries
379	Detailed Cust. Ledg. Entry	Sales	Detail lines behind customer ledger entries (applications, adjustments)
23	Vendor	Purchasing	Vendor master records
25	Vendor Ledger Entry	Purchasing	Open and closed vendor ledger entries
380	Detailed Vendor Ledg. Entry	Purchasing	Detail lines behind vendor ledger entries
270	Bank Account	Cash	Bank account master records
271	Bank Account Ledger Entry	Cash	Posted bank transactions
272	Check Ledger Entry	Cash	Printed and posted check information
254	VAT Entry	Finance	Posted VAT or sales tax amounts
36	Sales Header	Sales	Sales quotes, orders, invoices, credit memos, returns (by Document Type)
37	Sales Line	Sales	Lines of the sales documents
38	Purchase Header	Purchasing	Purchase quotes, orders, invoices, credit memos, returns
39	Purchase Line	Purchasing	Lines of the purchase documents
110	Sales Shipment Header	Sales	Posted sales shipments
112	Sales Invoice Header	Sales	Posted sales invoices
120	Purch. Rcpt. Header	Purchasing	Posted purchase receipts
122	Purch. Inv. Header	Purchasing	Posted purchase invoices
27	Item	Inventory	Item master records
32	Item Ledger Entry	Inventory	Quantity movements of items
5802	Value Entry	Inventory	Cost and sales value behind item ledger entries
339	Item Application Entry	Inventory	Links inbound and outbound item ledger entries for costing
337	Reservation Entry	Inventory	Reservations, tracking lines, lot and serial numbers on open documents
281	Phys. Inventory Ledger Entry	Inventory	Physical inventory journal postings
5740	Transfer Header	Inventory	Transfer orders between locations
14	Location	Inventory	Location master records
7312	Warehouse Entry	Warehouse	Bin level movements for directed put-away and pick
5405	Production Order	Manufacturing	Simulated, planned, firm planned, released and finished orders (by Status)
5406	Prod. Order Line	Manufacturing	Items produced by a production order
5407	Prod. Order Component	Manufacturing	Component lines needed by a production order
5409	Prod. Order Routing Line	Manufacturing	Operations of a production order
5832	Capacity Ledger Entry	Manufacturing	Posted run and setup time, output quantity and scrap
99000763	Routing Header	Manufacturing	Routing master records
99000764	Routing Line	Manufacturing	Operations on a routing
99000771	Production BOM Header	Manufacturing	Production BOM master records
99000772	Production BOM Line	Manufacturing	Component lines on a production BOM
99000754	Work Center	Manufacturing	Work center master records
99000758	Machine Center	Manufacturing	Machine center master records
5600	Fixed Asset	Fixed assets	Fixed asset master records
5601	FA Ledger Entry	Fixed assets	Acquisition, depreciation and disposal entries
167	Job	Projects	Project (job) master records
169	Job Ledger Entry	Projects	Posted project usage and sales entries
203	Res. Ledger Entry	Resources	Posted resource usage entries

Table numbers shown are the base application numbers shared by recent Business Central versions and classic NAV. Table names can differ slightly in the Table Information page of your version. Always confirm in the Object Designer or the All Objects page before writing code.

Query Business Central in plain English

Ask for a short review of how your Business Central data could be queried read-only by an AI assistant.

Optional. The tool and every export work without this. No spam.

How to use this list

Type part of a table name, a number or an area such as Manufacturing into the search box. The result tells you the base table number, the name as it appears in AL and C/AL, and what rows in it mean. Use the number when you open the Table Information page (search for it in Business Central) to see record counts and size, or when you write a Data Upgrade, an ODBC query on an on-premises database, or an AL table extension.

Search by number to confirm a table you saw in an error message
Filter by area to review all the ledger entry tables for a close
Export the full list to Excel for a project wiki

Ledger entries versus documents

Business Central keeps open work in document tables (Sales Header, Purchase Line, Production Order) and records history in ledger entry tables (G/L Entry, Item Ledger Entry, Value Entry). Posted documents also live in their own tables (Sales Invoice Header). A report that needs quantities should read the item ledger entry, while a report that needs cost should read the value entry, because quantity and value are separate by design.

Item Ledger Entry holds quantity, Value Entry holds cost and sales amount
Detailed ledger tables hold applications and adjustments
Production Order is one table for all statuses, separated by the Status field

Manufacturing tables in the 99000000 range

Routings, production BOMs, work centers and machine centers use table numbers starting at 99000000, a historical range from the original manufacturing add-on that is now part of the base application. Production orders themselves sit in the 5400 range. When you move from NAV to Business Central, these numbers are normally unchanged, which makes mapping simple, but check any custom fields added to them.

Common mistakes

The most common mistake is writing SQL directly against a table whose name includes the company prefix and extension suffixes on-premises. In SQL the physical name is the company name plus the table name, and extension fields live in a separate extension table. Another mistake is reading Sales Line without the Document Type filter and mixing quotes with invoices. Finally, do not write directly to ledger entry tables, always post through journals or codeunits.

Frequently Asked Questions

Are Business Central table numbers the same as NAV table numbers?

For the base application, yes. Tables such as G/L Entry 17, Customer 18 and Item 27 kept their numbers from NAV through Business Central. Newer tables were added over time, and custom tables in your own range remain yours, so always check your own extensions.

Where do I find the table number inside Business Central?

Open the Table Information page by searching for it, or use the All Objects page. In a developer session you can also press Ctrl+Alt+F1 on a page to open the About This Page view, which shows the source table and its number.

Why are quantity and cost in different tables?

Item Ledger Entry records the physical movement of quantity, while Value Entry records the cost and sales value that can change later through cost adjustment. Splitting them lets the system revalue inventory without changing quantity history.

Can I edit these tables directly?

You should not. Ledger entry tables are written by posting routines that also update related entries, applications and dimensions. Editing rows with SQL or a data tool breaks that consistency and is unsupported in Business Central online.

If you need answers from these tables without writing queries, we can connect a read-only natural-language layer to your Business Central data, on-premises if required.

Talk to an Expert Explore More Free Tools

Related Tools

Microsoft Dynamics

More Microsoft Dynamics tools

See all

Back to All Tools