Table 10721 "Historic G/L Account" (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	Historic G/L Account
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]	—	not editable; NotBlank
2	Name	Text[30]	—	not editable
3	Search Name	Code[30]	—	not editable
4	Account Type	Option	—	OptionCaption: Posting,Heading; not editable
6	Global Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); not editable
7	Global Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); not editable
9	Income/Balance	Option	—	OptionCaption: Income Statement,Balance Sheet,Capital; not editable
10	Debit/Credit	Option	—	OptionCaption: Both,Debit,Credit; not editable
11	No. 2	Code[20]	—	not editable
13	Blocked	Boolean	—	not editable
14	Direct Posting	Boolean	—	not editable
16	Reconciliation Account	Boolean	—	not editable
17	New Page	Boolean	—	not editable
18	No. of Blank Lines	Integer	—	not editable
19	Indentation	Integer	—	not editable
26	Last Date Modified	Date	—	not editable
28	Date Filter	Date	—	FlowFilter; not editable
29	Global Dimension 1 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); FlowFilter; not editable
30	Global Dimension 2 Filter	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); FlowFilter; not editable
31	Balance at Date	Decimal	—	FlowField: sum(“G/L Entry”.Amount where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(upperlimit(“Date Filter”)))); not editable
32	Net Change	Decimal	—	FlowField: sum(“G/L Entry”.Amount where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
33	Budgeted Amount	Decimal	—	FlowField: sum(“G/L Budget Entry”.Amount where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), Date = field(“Date Filter”), “Budget Name” = field(“Budget Filter”))); not editable
34	Totaling	Text[250]	—
35	Budget Filter	Code[10]	—	TableRelation G/L Budget Name; FlowFilter; not editable
36	Balance	Decimal	—	FlowField: sum(“G/L Entry”.Amount where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”))); not editable
37	Budget at Date	Decimal	—	FlowField: sum(“G/L Budget Entry”.Amount where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), Date = field(upperlimit(“Date Filter”)), “Budget Name” = field(“Budget Filter”))); not editable
39	Consol. Translation Method	Option	—	OptionCaption: Average Rate (Manual),Closing Rate,Historical Rate,Composite Rate,Equity Rate; not editable
40	Consol. Debit Acc.	Code[20]	—	not editable
41	Consol. Credit Acc.	Code[20]	—	not editable
42	Business Unit Filter	Code[20]	—	TableRelation Business Unit; FlowFilter; not editable
43	Gen. Posting Type	Option	—	OptionCaption: ,Purchase,Sale; not editable
44	Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group; not editable
45	Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group; not editable
46	Picture	BLOB	—
47	Debit Amount	Decimal	—	FlowField: sum(“G/L Entry”.“Debit Amount” where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
48	Credit Amount	Decimal	—	FlowField: sum(“G/L Entry”.“Credit Amount” where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
49	Automatic Ext. Texts	Boolean	—	not editable
52	Budgeted Debit Amount	Decimal	—	FlowField: sum(“G/L Budget Entry”.Amount where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), Date = field(“Date Filter”), “Budget Name” = field(“Budget Filter”))); not editable
53	Budgeted Credit Amount	Decimal	—	FlowField: - sum(“G/L Budget Entry”.Amount where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), Date = field(“Date Filter”), “Budget Name” = field(“Budget Filter”))); not editable
54	Tax Area Code	Code[20]	—	TableRelation Tax Area; not editable
55	Tax Liable	Boolean	—	not editable
56	Tax Group Code	Code[20]	—	TableRelation Tax Group; not editable
57	VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group; not editable
58	VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group; not editable
60	Additional-Currency Net Change	Decimal	—	FlowField: sum(“G/L Entry”.“Additional-Currency Amount” where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
61	Add.-Currency Balance at Date	Decimal	—	FlowField: sum(“G/L Entry”.“Additional-Currency Amount” where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(upperlimit(“Date Filter”)))); not editable
62	Additional-Currency Balance	Decimal	—	FlowField: sum(“G/L Entry”.“Additional-Currency Amount” where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”))); not editable
63	Exchange Rate Adjustment	Option	—	OptionCaption: No Adjustment,Adjust Amount,Adjust Additional-Currency Amount; not editable
64	Add.-Currency Debit Amount	Decimal	—	FlowField: sum(“G/L Entry”.“Add.-Currency Debit Amount” where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
65	Add.-Currency Credit Amount	Decimal	—	FlowField: sum(“G/L Entry”.“Add.-Currency Credit Amount” where(“Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”))); not editable
66	Default IC Partner G/L Acc. No	Code[20]	—	TableRelation “IC G/L Account”.“No.”; not editable
10700	Income Stmt. Bal. Acc.	Code[20]	—	not editable
10701	Ignore in 347 Report	Boolean	—	not editable
10702	Ignore Discounts	Boolean	—	not editable
10720	Old Balance	Decimal	—

Keys

Key1: No. (clustered)

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: "Historic G/L Account"), 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.