Table 10725 "Hist. G/L Account (An. View)" (ES)

ES country layer · Microsoft · BC29-30 · source at ea08af5e · facts from BC29

An object of the ES localization, not part of W1.

Properties

Property	Value
Caption	Hist. G/L Account (An. View)
DataClassification	CustomerContent
ObsoleteState	Removed
ObsoleteTag	28.0
ObsoleteReason	Obsolete feature

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	No.	Code[20]	—	NotBlank
2	Name	Text[30]	—
3	Search Name	Code[30]	—
4	Account Type	Option	—	OptionCaption: Posting,Heading,Total,Begin-Total,End-Total
6	Global Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
7	Global Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
9	Income/Balance	Option	—	OptionCaption: Income Statement,Balance Sheet
10	Debit/Credit	Option	—	OptionCaption: Both,Debit,Credit
11	No. 2	Code[20]	—
13	Blocked	Boolean	—
14	Direct Posting	Boolean	—
16	Reconciliation Account	Boolean	—
17	New Page	Boolean	—
18	No. of Blank Lines	Integer	—
19	Indentation	Integer	—
26	Last Date Modified	Date	—	not editable
28	Date Filter	Date	—	FlowFilter
29	Global Dimension 1 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); FlowFilter
30	Global Dimension 2 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); FlowFilter
31	Balance at Date	Decimal	—	FlowField: sum(“Analysis View Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”), “Dimension…; not editable
32	Net Change	Decimal	—	FlowField: sum(“Analysis View Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”), “Dimension…; not editable
33	Budgeted Amount	Decimal	—	FlowField: sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value …
34	Totaling	Text[250]	—
35	Budget Filter	Code[10]	—	TableRelation G/L Budget Name; FlowFilter
36	Balance	Decimal	—	FlowField: sum(“Analysis View Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”), “Dimension…; not editable
37	Budgeted at Date	Decimal	—	FlowField: sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value …
40	Consol. Debit Acc.	Code[20]	—
41	Consol. Credit Acc.	Code[20]	—
42	Business Unit Filter	Code[20]	—	TableRelation Business Unit; FlowFilter
43	Gen. Posting Type	Option	—	OptionCaption: ,Purchase,Sale
44	Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group
45	Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group
47	Debit Amount	Decimal	—	FlowField: sum(“Analysis View Entry”.“Debit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”), “D…; not editable
48	Credit Amount	Decimal	—	FlowField: sum(“Analysis View Entry”.“Credit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”), “…; not editable
49	Automatic Ext. Texts	Boolean	—
52	Budgeted Debit Amount	Decimal	—	FlowField: sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value …
53	Budgeted Credit Amount	Decimal	—	FlowField: - sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Valu…
54	Tax Area Code	Code[20]	—	TableRelation Tax Area
55	Tax Liable	Boolean	—
56	Tax Group Code	Code[20]	—	TableRelation Tax Group
57	VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
58	VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group
60	Additional-Currency Net Change	Decimal	—	FlowField: sum(“Analysis View Entry”.“Add.-Curr. Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”…; not editable
61	Add.-Currency Balance at Date	Decimal	—	FlowField: sum(“Analysis View Entry”.“Add.-Curr. Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”…; not editable
62	Additional-Currency Balance	Decimal	—	FlowField: sum(“Analysis View Entry”.“Add.-Curr. Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 Filter”…; not editable
63	Exchange Rate Adjustment	Option	—	OptionCaption: No Adjustment,Adjust Amount,Adjust Additional-Currency Amount
64	Add.-Currency Debit Amount	Decimal	—	FlowField: sum(“Analysis View Entry”.“Add.-Curr. Debit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 F…; not editable
65	Add.-Currency Credit Amount	Decimal	—	FlowField: sum(“Analysis View Entry”.“Add.-Curr. Credit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Old G/L Account No.” = field(“No.”), “Old G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dimension 1 …; not editable
66	Analysis View Filter	Code[10]	—	TableRelation Analysis View; FlowFilter
67	Dimension 1 Filter	Code[20]	—	FlowFilter
68	Dimension 2 Filter	Code[20]	—	FlowFilter
69	Dimension 3 Filter	Code[20]	—	FlowFilter
70	Dimension 4 Filter	Code[20]	—	FlowFilter

Keys

Key1: No. (clustered)

Procedures

GetCurrencyCode(): Code[10]
GetCaptionClass(AnalysisViewDimType: Integer): Text[250]

Deprecations

object: Removed 28.0 (#if not CLEANSCHEMA28), “Obsolete feature”

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: "Hist. G/L Account (An. View)"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A ES country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.