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 NameData TypeComment
1IDInteger>0.0 is reserved for the empty dimension set. References field 3 in table 481.
2Dimension CodeCode 20Table relation to table 348.
3Dimension Value CodeCode 20Table relation to table 349.
4Dimension Value IDIntegerReferences field 12 in table 349. It's the secondary key that is used when traversing table 481.
5Dimension NameText 30CalcField. Lookup to table 348.
6Dimension Value NameText 30CalcField. 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 NameData TypeComment
1Parent Dimension Set IDInteger0 for top level node.
2Dimension Value IDIntegerTable relation to field 12 in table 349.
3Dimension Set IDIntegerAutoIncrement. Used in field 1 in table 480.
4In UseBooleanFalse 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 NameData TypeComment
1Dimension CodeCode 20Table relation to table 348.
2Dimension Value CodeCode 20Table relation to table 349.
3Dimension Value IDIntegerReferences field 12 in table 349.
4New Dimension Value CodeCode 20Table relation to table 349.
5New Dimension Value IDIntegerReferences field 12 in table 349.
6Dimension NameText 30CalcField. Lookup to table 348.
7Dimension Value NameText 30CalcField. Lookup to table 349.
8New Dimension Value NameText 30CalcField. Lookup to table 349.

Transaction and Budget Tables

In addition to other dimension fields in the table, this field is important:

Field No.Field NameData TypeComment
480Dimension Set IDIntegerReferences 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 NameData TypeComment
480Dimension Set IDIntegerReferences field 1 in table 480.
481New Dimension Set IDIntegerReferences 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 NameData TypeComment
12Dimension Value IDIntegerAutoIncrement. 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
17G/L Entry
21Cust. Ledger Entry
25Vendor Ledger Entry
32Item Ledger Entry
110Sales Shipment Header
111Sales Shipment Line
112Sales Invoice Header
113Sales Invoice Line
114Sales Cr.Memo Header
115Sales Cr.Memo Line
120Purch. Rcpt. Header
121Purch. Rcpt. Line
122Purch. Inv. Header
123Purch. Inv. Line
124Purch. Cr. Memo Hdr.
125Purch. Cr. Memo Line
169Job Ledger Entry
203Res. Ledger Entry
271Bank Account Ledger Entry
281Phys. Inventory Ledger Entry
297Issued Reminder Header
304Issued Fin. Charge Memo Header
5107Sales Header Archive
5108Sales Line Archive
5109Purchase Header Archive
5110Purchase Line Archive
5601FA Ledger Entry
5625Maintenance Ledger Entry
5629Ins. Coverage Ledger Entry
5744Transfer Shipment Header
5745Transfer Shipment Line
5746Transfer Receipt Header
5747Transfer Receipt Line
5802Value Entry
5832Capacity Ledger Entry
5907Service Ledger Entry
5908Service Header
5933Service Order Posting Buffer
5970Filed Service Contract Header
5990Service Shipment Header
5991Service Shipment Line
5992Service Invoice Header
5993Service Invoice Line
5994Service Cr. Memo Header
5995Service Cr. Memo Line
6650Return Shipment Header
6651Return Shipment Line
6660Return Receipt Header
6661Return Receipt Line

Field 480 is editable in the following tables.

Table No.Table Name
36Sales Header
37Sales Line
38Purchase Header
39Purchase Line
81Gen. Journal Line
83Item Journal Line
89BOM Journal Line
96G/L Budget Entry
207Res. Journal Line
210Project Journal Line
221Gen. Jnl. Allocation
246Requisition Line
295Reminder Header
302Finance Charge Memo Header
5405Production Order
5406Prod. Order Line
5407Prod. Order Component
5615FA Allocation
5621FA Journal Line
5635Insurance Journal Line
5740Transfer Header
5741Transfer Line
5900Service Header
5901Service Item Line
5902Service Line
5965Service Contract Header
5997Standard Service Line
7134Item Budget Entry
99000829Planning Component

Field 480 exists in the following buffer tables.

Table No.Table Name
49Invoice Post. Buffer
212Project Posting Buffer
372Payment Buffer
382CV Ledger Entry Buffer
461Prepayment Inv. Line Buffer
5637FA G/L Posting Buffer
7136Item Budget Buffer

Dimension Set Entries Overview
Design Details: Searching for Dimension Combinations