--- id: object/table/7118 type: object title: Table 7118 "Analysis Column" summary: Table 7118 "Analysis Column" in Base Application (Microsoft.Inventory.Analysis). 19 fields. Present since at least BC23, still in BC30, changed in BC24, BC27-28. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "28" 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: fe77489891b9b624bc6196e3ba02a43441cfc3b02ade1d4d39e653dfc1e69677 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisColumn.Table.al title: src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisColumn.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] changes: - change/bcapps/12066 object_type: table object_id: 7118 name: Analysis Column namespace: Microsoft.Inventory.Analysis 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" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 19 procedures: 0 events: 0 subscribers: 0 relations: out: 4 referenced_by: 1 pages: 1 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 7118 "Analysis Column" > Table 7118 "Analysis Column" in Base Application (Microsoft.Inventory.Analysis). 19 fields. Present since at least BC23, still in BC30, changed in BC24, BC27-28. Base Application · Microsoft.Inventory.Analysis · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisColumn.Table.al) · 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"](../enum/7130.md) | | 2 | Analysis Column Template | Code[10] | — | TableRelation [Table 7116 "Analysis Column Template"](../table/7116.md) ("Analysis Column Template".Name where("Analysis Area" = field("Analysis Area"))) | | 3 | Line No. | Integer | — | | | 4 | Column No. | Code[10] | Specifies a number for the column in the analysis view. | | | 5 | Column Header | Text[50] | Specifies a header for the column as you want it to appear on printed reports. | | | 6 | Column Type | 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"](../enum/7118.md) | | 7 | Ledger Entry Type | 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 | Code[80] | Specifies a formula for how data is shown in the column when the analysis 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 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 | 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 | Enum "Analysis Rounding Factor" | Specifies a rounding factor for the amounts in the column. | enum [Enum 364 "Analysis Rounding Factor"](../enum/364.md) | | 13 | 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. | | | 14 | Analysis Type Code | Code[10] | Specifies the analysis type to apply to the column. | TableRelation [Table 7113 "Analysis Type"](../table/7113.md) (Analysis Type) | | 15 | Item Ledger Entry Type Filter | 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 | 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 | 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"](../enum/7113.md) | | 18 | Invoiced | 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"](../page/7114.md) - lookup page [Page 7114 "Analysis Columns"](../page/7114.md) - Analysis Type Code: TableRelation [Table 7113 "Analysis Type"](../table/7113.md) - Analysis Column Template: TableRelation [Table 7116 "Analysis Column Template"](../table/7116.md) ## Referenced by 1 fields in 1 objects relate to this table (TableRelation or CalcFormula). - [Table 771 "Analysis Report Chart Line"](../table/771.md): Analysis Column Line No. ## Pages and codeunits on this table - [Page 7114 "Analysis Columns"](../page/7114.md) (source table) ## Recent changes - 2026-10-02 [#12066 Bugs/remove asm inv mfg clean27 tags for wave2 2026](../../changes/bcapps/12066.md) (main, BC30, obsoletion) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC27-28 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: "Analysis Column")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.