Column Layout #334

Other table in Microsoft Dynamics 365 Business Central. 32 fields, 116 records in Cronus demo.

The Column Layout table (ID 334) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 32 fields, with a primary key of Column Layout Name, Line No.. Use the reference below to explore every field, data type, and table relation.

Fields

116

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Column Layout Name, Line No..

All fields (32)

Column Layout — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Column Layout Name PK	Code	Normal	→ Column Layout Name #333
2	Line No. PK	Integer	Normal
3	Column No.	Code	Normal
4	Column Header	Text	Normal
5	Column Type	Option	Normal
6	Ledger Entry Type	Option	Normal
7	Amount Type	Option	Normal
8	Formula	Code	Normal
9	Comparison Date Formula	DateFormula	Normal
10	Show Opposite Sign	Boolean	Normal
11	Show	Option	Normal
12	Rounding Factor	Option	Normal
13	Show Indented Lines	Option	Normal
14	Comparison Period Formula	Code	Normal
15	Business Unit Totaling	Text	Normal	→ Business Unit #220
16	Dimension 1 Totaling	Text	Normal
17	Dimension 2 Totaling	Text	Normal
18	Dimension 3 Totaling	Text	Normal
19	Dimension 4 Totaling	Text	Normal
20	Cost Center Totaling	Text	Normal
21	Cost Object Totaling	Text	Normal
30	Comparison Period Formula LCID	Integer	Normal
35	Budget Name	Code	Normal	→ G/L Budget Name #95
40	Hide Currency Symbol	Boolean	Normal
41	Include Date in Column Header	Option	Normal
42	G/L Account Totaling	Text	Normal
43	Show in ACY	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (4)

Tables referenced by fields on the Column Layout table through TableRelation properties.

Column Layout Name

#333 · Other · via Column Layout Name

Business Unit

#220 · Other · via Business Unit Totaling

G/L Budget Name

#95 · Other · via Budget Name