# Design details: Table structure
To understand how dimension entries are stored and posted, it's important to understand the table structure.
## Table 480, Dimension Set Entry
You can't change this table. After data is written to the table, you can't delete or edit it.
Field No.|Field Name|Data Type|Comment
1|ID|Integer|>0.0 is reserved for the empty dimension set. References field 3 in table 481.
2|Dimension Code|Code 20|Table relation to table 348.
3|Dimension Value Code|Code 20|Table relation to table 349.
4|Dimension Value ID|Integer|References field 12 in table 349. It's the secondary key that is used when traversing table 481.
5|Dimension Name|Text 30|CalcField. Lookup to table 348.
6|Dimension Value Name|Text 30|CalcField. Lookup to table 349.
## Table 481, Dimension Set Tree Node
You can't change this table. It's used to search for a dimension set. If the dimension set isn't found, a new set is created.
Field No.|Field Name|Data Type|Comment
1|Parent Dimension Set ID|Integer|0 for top level node.
2|Dimension Value ID|Integer|Table relation to field 12 in table 349.
3|Dimension Set ID|Integer|AutoIncrement. Used in field 1 in table 480.
4|In Use|Boolean|False if not in use.
## Table 482 Reclas. Dimension Set Buffer
This table is used when you change a dimension value code, for example, on an item ledger entry by using the Item Reclassification Journal page.
Field No.|Field Name|Data Type|Comment
1|Dimension Code|Code 20|Table relation to table 348.
2|Dimension Value Code|Code 20|Table relation to table 349.
3|Dimension Value ID|Integer|References field 12 in table 349.
4|New Dimension Value Code|Code 20|Table relation to table 349.
5|New Dimension Value ID|Integer|References field 12 in table 349.
6|Dimension Name|Text 30|CalcField. Lookup to table 348.
7|Dimension Value Name|Text 30|CalcField. Lookup to table 349.
8|New Dimension Value Name|Text 30|CalcField. Lookup to table 349.
## Transaction and Budget Tables
In addition to other dimension fields in the table, this field is important:
Field No.|Field Name|Data Type|Comment
480|Dimension Set ID|Integer|References field 1 in table 480.
### Table 83, Item Journal Line
In addition to other dimension fields in the table, these fields are important.
Field No.|Field Name|Data Type|Comment
480|Dimension Set ID|Integer|References field 1 in table 480.
481|New Dimension Set ID|Integer|References field 1 in table 480.
### Table 349, Dimension Value
In addition to other dimension fields in the table, these fields are important.
Field No.|Field Name|Data Type|Comment
12|Dimension Value ID|Integer|AutoIncrement. Used for references in table 480 and table 481.
### Tables That Contain the Dimension Set ID Field
The Dimension Set ID field (480) exists in the following tables. For the tables that store posted data, the field only provides a noneditable display of dimensions, which is marked as Drill-down. For the tables that store working documents, the field is editable. The buffer tables that are used internally don't need editable or noneditable capabilities.
Field 480 is noneditable in the following tables.
Table No.|Table Name
17|G/L Entry
21|Cust. Ledger Entry
25|Vendor Ledger Entry
32|Item Ledger Entry
110|Sales Shipment Header
111|Sales Shipment Line
112|Sales Invoice Header
113|Sales Invoice Line
114|Sales Cr.Memo Header
115|Sales Cr.Memo Line
120|Purch. Rcpt. Header
121|Purch. Rcpt. Line
122|Purch. Inv. Header
123|Purch. Inv. Line
124|Purch. Cr. Memo Hdr.
125|Purch. Cr. Memo Line
169|Job Ledger Entry
203|Res. Ledger Entry
271|Bank Account Ledger Entry
281|Phys. Inventory Ledger Entry
297|Issued Reminder Header
304|Issued Fin. Charge Memo Header
5107|Sales Header Archive
5108|Sales Line Archive
5109|Purchase Header Archive
5110|Purchase Line Archive
5601|FA Ledger Entry
5625|Maintenance Ledger Entry
5629|Ins. Coverage Ledger Entry
5744|Transfer Shipment Header
5745|Transfer Shipment Line
5746|Transfer Receipt Header
5747|Transfer Receipt Line
5802|Value Entry
5832|Capacity Ledger Entry
5907|Service Ledger Entry
5908|Service Header
5933|Service Order Posting Buffer
5970|Filed Service Contract Header
5990|Service Shipment Header
5991|Service Shipment Line
5992|Service Invoice Header
5993|Service Invoice Line
5994|Service Cr. Memo Header
5995|Service Cr. Memo Line
6650|Return Shipment Header
6651|Return Shipment Line
6660|Return Receipt Header
6661|Return Receipt Line
Field 480 is editable in the following tables.
Table No.|Table Name
36|Sales Header
37|Sales Line
38|Purchase Header
39|Purchase Line
81|Gen. Journal Line
83|Item Journal Line
89|BOM Journal Line
96|G/L Budget Entry
207|Res. Journal Line
210|Project Journal Line
221|Gen. Jnl. Allocation
246|Requisition Line
295|Reminder Header
302|Finance Charge Memo Header
5405|Production Order
5406|Prod. Order Line
5407|Prod. Order Component
5615|FA Allocation
5621|FA Journal Line
5635|Insurance Journal Line
5740|Transfer Header
5741|Transfer Line
5900|Service Header
5901|Service Item Line
5902|Service Line
5965|Service Contract Header
5997|Standard Service Line
7134|Item Budget Entry
99000829|Planning Component
Field 480 exists in the following buffer tables.
Table No.|Table Name
49|Invoice Post. Buffer
212|Project Posting Buffer
372|Payment Buffer
382|CV Ledger Entry Buffer
461|Prepayment Inv. Line Buffer
5637|FA G/L Posting Buffer
7136|Item Budget Buffer
## Related information
design-details-dimension-set-entries-overview
design-details-searching-for-dimension-combinations

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-table-structure, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/design-details-table-structure/
