Table 89 "Financial Report User Filters"

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

Keys

Key1: User ID, Financial Report Name (clustered)

Relations

Excel Template Code: TableRelation Table 764 “Fin. Report Excel Template”
FinReportDimPerspectiveName: TableRelation Table 8363 “Dimension Perspective Name”
Financial Report Name: TableRelation Table 88 “Financial Report”

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.