Table 7118 "Analysis Column"

Base Application · Microsoft.Inventory.Analysis · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Analysis Column
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	Analysis Area	Enum “Analysis Area Type”	—	enum Enum 7130 “Analysis Area Type”
2	Analysis Column Template	Code[10]	—	TableRelation Table 7116 “Analysis Column Template” (“Analysis Column Template”.Name where(“Analysis Area” = field(“Analysis Area”)))
3	Line No.	Integer	—
4	Column No. Δ BC28	Code[10]	Specifies a number for the column in the analysis view.
5	Column Header Δ BC28	Text[50]	Specifies a header for the column as you want it to appear on printed reports.
6	Column Type Δ BC28	Enum “Analysis Column Type”	Specifies the analysis column type, which determines how the amounts in the column are calculated.	enum Enum 7118 “Analysis Column Type”
7	Ledger Entry Type Δ BC28	Option	Specifies the type of ledger entries that will be included in the amounts in the analysis column.	OptionCaption: Item Entries,Item Budget Entries
8	Formula Δ BC28	Code[80]	Specifies a formula for how data is shown in the column when the analysis report is printed.
9	Comparison Date Formula Δ BC28	DateFormula	Specifies a date formula that specifies which dates should be used to calculate the amount in this column.
10	Show Opposite Sign Δ BC28	Boolean	Specifies if you want purchases and positive adjustments to be shown as negative amounts and sales and negative adjustments to be shown as positive amounts.
11	Show Δ BC28	Option	Specifies when you want the amounts in the column to be shown in reports.	OptionCaption: Always,Never,When Positive,When Negative
12	Rounding Factor Δ BC28	Enum “Analysis Rounding Factor”	Specifies a rounding factor for the amounts in the column.	enum Enum 364 “Analysis Rounding Factor”
13	Comparison Period Formula Δ BC28	Code[20]	Specifies a period formula that specifies the accounting periods you want to use to calculate the amount in this column.
14	Analysis Type Code Δ BC28	Code[10]	Specifies the analysis type to apply to the column.	TableRelation Table 7113 “Analysis Type” (Analysis Type)
15	Item Ledger Entry Type Filter Δ BC28	Text[250]	Specifies the filter that applies to the item ledger entry type that you want this column to be calculated from.
16	Value Entry Type Filter Δ BC28	Text[250]	Specifies the filter that applies to the item value entry type that you want this column to be calculated from.
17	Value Type Δ BC28	Enum “Analysis Value Type”	Specifies the source data that the source data type in the Analysis Type Code field, in the Analysis Columns window, is based on.	enum Enum 7113 “Analysis Value Type”
18	Invoiced Δ BC28	Boolean	Specifies if you want the analysis report to be based on invoiced amounts. If left field blank, the report will be based on expected amounts.
30	Comparison Period Formula LCID	Integer	—

Keys

Key1: Analysis Area, Analysis Column Template, Line No. (clustered)

Relations

drill-down page Page 7114 “Analysis Columns”
lookup page Page 7114 “Analysis Columns”
Analysis Type Code: TableRelation Table 7113 “Analysis Type”
Analysis Column Template: TableRelation Table 7116 “Analysis Column Template”

Referenced by

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

Table 771 “Analysis Report Chart Line”: Analysis Column Line No.

Pages and codeunits on this table

Page 7114 “Analysis Columns” (source table)

Recent changes

2026-10-02 #12066 Bugs/remove asm inv mfg clean27 tags for wave2 2026 (main, BC30, obsoletion)

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: "Analysis Column"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.