---
id: object/table/89
type: object
title: Table 89 "Financial Report User Filters"
summary: Table 89 "Financial Report User Filters" in Base Application (Microsoft.Finance.FinancialReports). 22 fields. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28.
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: 0dcfa44f08d6722d020e78a1993738afbc85e74262876191efd4e622332199c1
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/FinancialReportUserFilters.Table.al
    title: src/Layers/W1/BaseApp/Finance/FinancialReports/FinancialReportUserFilters.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 89
name: Financial Report User Filters
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"
  - "26"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 22
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 3
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 89 "Financial Report User Filters"

> Table 89 "Financial Report User Filters" in Base Application (Microsoft.Finance.FinancialReports). 22 fields. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28.

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

## Properties

| Property | Value |
|---|---|
| Caption | Financial Report User Filters |
| 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 | User ID | Code[50] | — | TableRelation User; DataClassification EndUserPseudonymousIdentifiers |
| 2 | Financial Report Name | Code[10] | — | TableRelation [Table 88 "Financial Report"](../table/88.md) (Financial Report); DataClassification SystemMetadata |
| 3 | UseAmountsInAddCurrency | Boolean | Use Amounts in Additional Currency <small>caption</small> | DataClassification SystemMetadata |
| 4 | PeriodType | Enum "Analysis Period Type" | Period Type <small>caption</small> | obsolete Pending 28.0; #if not CLEANSCHEMA30; enum [Enum 362 "Analysis Period Type"](../enum/362.md); DataClassification SystemMetadata |
| 5 | ShowLinesWithShowNo | Boolean | Show All Lines <small>caption</small> | DataClassification SystemMetadata |
| 6 | Dim1Filter | Text[2048] | Dimension 1 Filter <small>caption</small> | DataClassification SystemMetadata |
| 7 | Dim2Filter | Text[2048] | Dimension 2 Filter <small>caption</small> | DataClassification SystemMetadata |
| 8 | Dim3Filter | Text[2048] | Dimension 3 Filter <small>caption</small> | DataClassification SystemMetadata |
| 9 | Dim4Filter | Text[2048] | Dimension 4 Filter <small>caption</small> | DataClassification SystemMetadata |
| 10 | CostCenterFilter | Text[2048] | Cost Center Filter <small>caption</small> | DataClassification SystemMetadata |
| 11 | CostObjectFilter | Text[2048] | Cost Object Filter <small>caption</small> | DataClassification SystemMetadata |
| 12 | CashFlowFilter | Text[2048] | Cash Flow Filter <small>caption</small> | DataClassification SystemMetadata |
| 13 | GLBudgetFilter | Text[2048] | G/L Budget Filter <small>caption</small> | DataClassification SystemMetadata |
| 14 | CostBudgetFilter | Text[2048] | Cost Budget Filter <small>caption</small> | DataClassification SystemMetadata |
| 15 | DateFilter | Text[2048] | Date Filter <small>caption</small> | DataClassification SystemMetadata |
| 16 | Excel Template Code | Code[50] | — | TableRelation [Table 764 "Fin. Report Excel Template"](../table/764.md) ("Fin. Report Excel Template"."Code" where("Financial Report Name" = field("Financial Report Name"))); DataClassification SystemMetadata |
| 17 | NegativeAmountFormat | Enum "Analysis Negative Format" | Negative Amount Format <small>caption</small> | obsolete Pending 28.0; #if not CLEANSCHEMA30; enum [Enum 5001 "Analysis Negative Format"](../enum/5001.md); DataClassification SystemMetadata |
| 18 | PeriodTypeDefault | Enum "Financial Report Period Type" | Specifies by which period amounts are displayed. | enum [Enum 1080 "Financial Report Period Type"](../enum/1080.md); DataClassification SystemMetadata |
| 19 | NegativeAmountFormatDefault | Enum "Fin. Report Negative Format" | Specifies the default negative amount format for this financial report. | enum [Enum 1083 "Fin. Report Negative Format"](../enum/1083.md); DataClassification SystemMetadata |
| 51 | Row Definition | Code[10] | — | DataClassification SystemMetadata |
| 52 | Column Definition | Code[10] | — | DataClassification SystemMetadata |
| 60 | FinReportDimPerspectiveName | Code[10] | Dimension Perspective <small>caption</small> | TableRelation [Table 8363 "Dimension Perspective Name"](../table/8363.md) (Dimension Perspective Name); DataClassification SystemMetadata |

## Keys

- Key1: User ID, Financial Report Name (clustered)

## Relations

- Excel Template Code: TableRelation [Table 764 "Fin. Report Excel Template"](../table/764.md)
- FinReportDimPerspectiveName: TableRelation [Table 8363 "Dimension Perspective Name"](../table/8363.md)
- Financial Report Name: TableRelation [Table 88 "Financial Report"](../table/88.md)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26, BC28

## Deprecations

- field NegativeAmountFormat: Pending 28.0 (#if not CLEANSCHEMA30), "This field has been replaced by the NegativeAmountFormatDefault field."
- field PeriodType: Pending 28.0 (#if not CLEANSCHEMA30), "This field has been replaced by the PeriodTypeDefault field."

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: "Financial Report User Filters")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.