---
id: object/table/334
type: object
title: Table 334 "Column Layout"
summary: Table 334 "Column Layout" in Base Application (Microsoft.Finance.FinancialReports). 28 fields, 4 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC27-29.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "29"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 5acabbb2a2243deafcc3b9e2c5fa811af9609aebbf9e712e4b8d17f2cf57d061
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/ColumnLayout.Table.al
    title: src/Layers/W1/BaseApp/Finance/FinancialReports/ColumnLayout.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/bi-column-definitions
    - https://learn.microsoft.com/dynamics365/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules
    - https://learn.microsoft.com/dynamics365/business-central/bi-how-work-account-schedule
    - https://learn.microsoft.com/dynamics365/business-central/bi-row-definitions
    - https://learn.microsoft.com/dynamics365/business-central/bi-troubleshoot-financial-reports
    - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-faq
    - https://learn.microsoft.com/dynamics365/business-central/walkthrough-making-cash-flow-forecasts-by-using-account-schedules
  objects: []
  features: []
  topics:
    - topic/business-central/analytics-business-intelligence-and-repo/built-in-reports/finance
    - topic/business-central/analytics-business-intelligence-and-repo/kpis-dashboards-and-financial-reports
    - topic/business-central/business-functionality/finance/financial-analytics/financial-reporting
    - topic/business-central/business-functionality/finance/manage-cash-flow
    - topic/business-central/business-functionality/set-up-business-central/set-up-finance
    - topic/business-central/get-started/learn/business-process-walkthroughs
  localizations:
    - localization/ru
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 334
name: Column Layout
namespace: Microsoft.Finance.FinancialReports
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "27"
  - "28"
  - "29"
source_major: "29"
obsolete: null
countries:
  - ru
ms_search_form_ids: []
counts:
  fields: 28
  procedures: 7
  events: 2
  subscribers: 0
relations:
  out: 3
  referenced_by: 1
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 334 "Column Layout"

> Table 334 "Column Layout" in Base Application (Microsoft.Finance.FinancialReports). 28 fields, 4 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC27-29.

Base Application · Microsoft.Finance.FinancialReports · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/ColumnLayout.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 489 "Column Layout"](../page/489.md) (7 Learn pages).

## Properties

| Property | Value |
|---|---|
| Caption | Column Layout |
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Column Layout Name | Code[10] | — | TableRelation [Table 333 "Column Layout Name"](../table/333.md) (Column Layout Name) |
| 2 | Line No. | Integer | Specifies the line number for the financial report column. |  |
| 3 | Column No. | Code[10] | Specifies a number for the column in the analysis view. |  |
| 4 | Column Header | Text[30] | Specifies a header for the column. |  |
| 5 | Column Type | Enum "Column Layout Type" | Specifies the analysis column type, which determines how the amounts in the column are calculated. | enum [Enum 331 "Column Layout Type"](../enum/331.md) |
| 6 | Ledger Entry Type | Enum "Column Layout Entry Type" | Specifies the type of ledger entries that will be included in the amounts in the financial report column. | enum [Enum 332 "Column Layout Entry Type"](../enum/332.md) |
| 7 | Amount Type | Enum "Account Schedule Amount Type" | Specifies the type of entries that will be included in the amounts in the financial report column. | enum [Enum 333 "Account Schedule Amount Type"](../enum/333.md) |
| 8 | Formula | Code[80] | Specifies a formula. The result of the formula will appear in the column when the financial report is printed. |  |
| 9 | Comparison Date Formula | DateFormula | Specifies a date formula that specifies which dates should be used to calculate the amount in this column. |  |
| 10 | Show Opposite Sign | Boolean | Specifies whether to show debits in reports as negative amounts (that is, with a minus sign) and credits as positive amounts. |  |
| 11 | Show | Enum "Column Layout Show" | Specifies when you want the amounts in the column to be shown in reports. | enum [Enum 334 "Column Layout Show"](../enum/334.md) |
| 12 | Rounding Factor | Enum "Analysis Rounding Factor" | Specifies a rounding factor for amounts in the column. | enum [Enum 364 "Analysis Rounding Factor"](../enum/364.md) |
| 13 | Show Indented Lines | Option | Specifies that indented lines are shown. | OptionCaption: All,Indented Only,Non-Indented Only |
| 14 | Comparison Period Formula | Code[20] | Specifies a period formula that specifies the accounting periods you want to use to calculate the amount in this column. |  |
| 15 | Business Unit Totaling | Text[80] | Specifies which business unit amounts will be totaled in this column. | TableRelation [Table 220 "Business Unit"](../table/220.md) (Business Unit) |
| 16 | Dimension 1 Totaling | Text[80] | Specifies which dimension value amounts will be totaled in this column. If the column type of the column is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. |  |
| 17 | Dimension 2 Totaling | Text[80] | Specifies which dimension value amounts will be totaled in this column. If the column type of the column is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. |  |
| 18 | Dimension 3 Totaling | Text[80] | Specifies which dimension value amounts will be totaled in this column. If the column type is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. |  |
| 19 | Dimension 4 Totaling | Text[80] | Specifies which dimension value amounts will be totaled in this column. If the column type is Formula, you must not enter anything in this field. Also, if you do not wish the amounts on the line to be filtered by dimension, you should leave this field blank. |  |
| 20 | Cost Center Totaling | Text[80] | Specifies which cost center amounts will be totaled in this column. |  |
| 21 | Cost Object Totaling | Text[80] | Specifies which cost object amounts will be totaled in this column. |  |
| 30 | Comparison Period Formula LCID | Integer | — |  |
| 35 | Budget Name | Code[10] | Specifies which budget amounts will be totaled in this column. | TableRelation [Table 95 "G/L Budget Name"](../table/95.md) (G/L Budget Name) |
| 40 | Hide Currency Symbol | Boolean | Specifies whether to hide currency symbols when a calculated result is not a currency. |  |
| 41 | Include Date In Header | Enum ColumnHeaderDateType | Specifies how the ending date of the Date Filter applied to the column is displayed on the Column Header. | enum [Enum 764 "ColumnHeaderDateType"](../enum/764.md) |
| 42 | G/L Account Totaling | Text[250] | Specifies which G/L accounts will be totalled in this column. Note that this filter will be applied in addition to any G/L account filters from the row definition lines. |  |
| 43 | Show in ACY | Boolean | Specifies whether amounts are shown in the Additional Reporting Currency. |  |
| 44 | Internal Description | Text[500] | Specifies the internal description for the column definition line that highlights complex logic or areas needing review for the next report designer. |  |

## Keys

- Key1: Column Layout Name, Line No. (clustered)

## Events published

- `OnBeforeGetCaptionClass(var ColumnLayout: Record "Column Layout"; ColumnLayoutName: Record "Column Layout Name"; AnalysisViewDimType: Integer; var Result: Text[250]; var IsHandled: Boolean)` (integration): Integration event raised before retrieving caption class for dimension field display.
- `OnBeforeLookUpDimFilter(var ColumnLayout: Record "Column Layout"; DimNo: Integer; var Text: Text[250]; ColumnLayoutName: Record "Column Layout Name"; var Result: Boolean; var IsHandled: Boolean; var AnalysisView: Record "Analysis View")` (integration): Integration event raised before opening dimension filter lookup dialog.

## Procedures

- `LookUpDimFilter(DimNo: Integer; var Text: Text[250]): Boolean`: Opens dimension value lookup dialog and returns selected dimension filter expression. Handles both standard dimensions and cost accounting dimension mappings.
- `GetCaptionClass(AnalysisViewDimType: Integer): Text[250]`: Retrieves caption class text for dimension field captions based on analysis view configuration. Supports dynamic field captioning for dimensions 1-4 in financial reporting interfaces.
- `LookupGLAccountTotaling()`
- `GetPeriodName(): Code[10]` (obsolete 27.0: Moved to codeunit Period Formula Parser): Retrieves current period name for display purposes in financial reporting.

Plus 1 local procedures.

## Relations

- Business Unit Totaling: TableRelation [Table 220 "Business Unit"](../table/220.md)
- Column Layout Name: TableRelation [Table 333 "Column Layout Name"](../table/333.md)
- Budget Name: TableRelation [Table 95 "G/L Budget Name"](../table/95.md)

## Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

- [Table 763 "Acc. Sched. Chart Setup Line"](../table/763.md): Column Layout Line No.

## Pages and codeunits on this table

- [Page 489 "Column Layout"](../page/489.md) (source table)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC27-29

## Countries that replace it

[RU](../../localizations/ru.md)

## Deprecations

- procedure GetPeriodName: Pending 27.0 (#if not CLEAN27), "Moved to codeunit Period Formula Parser"

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Column Layout")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.