Design details: table structure

项目
04/02/2024

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

通过