BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 334 "Column Layout"

Base Application · Microsoft.Finance.FinancialReports

Open in Claude334.mdSource on GitHub

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25-26unchanged
  4. BC2710 procedures removed, 3 fields added
  5. BC281 fields changed, 1 fields added
  6. BC2922 fields changed, 1 procedures added
  7. BC30unchanged

Neighbourhood 12 connected objects and pages

Table 220 "Business Unit" (relates to)Business UnitTable 333 "Column Layout Name" (relates to)Column Layout NameTable 95 "G/L Budget Name" (relates to)G/L Budget NamePage 489 "Column Layout" (pages and codeunits on it)Column LayoutTable 763 "Acc. Sched. Chart Setup Line" (referenced by)Acc. Sched. Chart Setup LineBuild financial reports using financial data and account categories (Learn pages)Build financial reports usin…Column definitions in Financial Reporting (Learn pages)Column definitions in Financ…Financial Reporting FAQ (Learn pages)Make cash flow forecasts using financial reports (Learn pages)Make cash flow forecasts usi…Row definitions in Financial Reporting (Learn pages)Row definitions in Financial…Set Up and Publish KPI Web Services Based on Financial Reports (Learn pages)Set Up and Publish KPI Web S…Troubleshoot Financial Reporting (Learn pages)Troubleshoot Financial Repor…

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Finance.FinancialReports · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 489 “Column Layout” (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” (Column Layout Name)
2 Line No. Δ BC29 Integer Specifies the line number for the financial report column.
3 Column No. Δ BC29 Code[10] Specifies a number for the column in the analysis view.
4 Column Header Δ BC29 Text[30] Specifies a header for the column.
5 Column Type Δ BC29 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”
6 Ledger Entry Type Δ BC29 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”
7 Amount Type Δ BC29 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”
8 Formula Δ BC29 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 Δ BC29 DateFormula Specifies a date formula that specifies which dates should be used to calculate the amount in this column.
10 Show Opposite Sign Δ BC29 Boolean Specifies whether to show debits in reports as negative amounts (that is, with a minus sign) and credits as positive amounts.
11 Show Δ BC29 Enum “Column Layout Show” Specifies when you want the amounts in the column to be shown in reports. enum Enum 334 “Column Layout Show”
12 Rounding Factor Δ BC29 Enum “Analysis Rounding Factor” Specifies a rounding factor for amounts in the column. enum Enum 364 “Analysis Rounding Factor”
13 Show Indented Lines Δ BC29 Option Specifies that indented lines are shown. OptionCaption: All,Indented Only,Non-Indented Only
14 Comparison Period Formula Δ BC29 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 Δ BC29 Text[80] Specifies which business unit amounts will be totaled in this column. TableRelation Table 220 “Business Unit” (Business Unit)
16 Dimension 1 Totaling Δ BC29 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 Δ BC29 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 Δ BC29 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 Δ BC29 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 Δ BC29 Text[80] Specifies which cost center amounts will be totaled in this column.
21 Cost Object Totaling Δ BC29 Text[80] Specifies which cost object amounts will be totaled in this column.
30 Comparison Period Formula LCID Integer —
35 Budget Name Δ BC29 Code[10] Specifies which budget amounts will be totaled in this column. TableRelation Table 95 “G/L Budget Name” (G/L Budget Name)
40 Hide Currency Symbol Δ BC29 Boolean Specifies whether to hide currency symbols when a calculated result is not a currency.
41 Include Date In Header + BC27 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”
42 G/L Account Totaling + BC27 Δ BC28 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 + BC27 Boolean Specifies whether amounts are shown in the Additional Reporting Currency.
44 Internal Description + BC28 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() + BC29
  • GetPeriodName(): Code[10] Δ BC27 (obsolete 27.0: Moved to codeunit Period Formula Parser): Retrieves current period name for display purposes in financial reporting.

Plus 1 local procedures.

Relations

Referenced by

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

Pages and codeunits on this table

Countries that replace it

RU

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.

Evidence 1 sources