G/L Account (Analysis View) #376

Other table in Microsoft Dynamics 365 Business Central. 61 fields, 0 records in Cronus demo.

The G/L Account (Analysis View) table (ID 376) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 61 fields, with a primary key of No., Account Source, and includes 15 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No., Account Source.

All fields (61)

G/L Account (Analysis View) — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	No. PK	Code	Normal
2	Name	Text	Normal
3	Search Name	Code	Normal
4	Account Type	Option	Normal
5	Account Source PK	Option	Normal
6	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
7	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
9	Income/Balance	Option	Normal
10	Debit/Credit	Option	Normal
11	No. 2	Code	Normal
12	Comment ⚡ FLOW	Boolean	FlowField
13	Blocked	Boolean	Normal
14	Direct Posting	Boolean	Normal
16	Reconciliation Account	Boolean	Normal
17	New Page	Boolean	Normal
18	No. of Blank Lines	Integer	Normal
19	Indentation	Integer	Normal
26	Last Date Modified	Date	Normal
27	Cash Flow Forecast Filter	Code	FlowFilter	→ Cash Flow Forecast #840
28	Date Filter	Date	FlowFilter
29	Global Dimension 1 Filter	Code	FlowFilter	→ Dimension Value #349
30	Global Dimension 2 Filter	Code	FlowFilter	→ Dimension Value #349
31	Balance at Date ⚡ FLOW	Decimal	FlowField
32	Net Change ⚡ FLOW	Decimal	FlowField
33	Budgeted Amount ⚡ FLOW	Decimal	FlowField
34	Totaling	Text	Normal
35	Budget Filter	Code	FlowFilter	→ G/L Budget Name #95
36	Balance ⚡ FLOW	Decimal	FlowField
37	Budgeted at Date ⚡ FLOW	Decimal	FlowField
40	Consol. Debit Acc.	Code	Normal
41	Consol. Credit Acc.	Code	Normal
42	Business Unit Filter	Code	FlowFilter	→ Business Unit #220
43	Gen. Posting Type	Option	Normal
44	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
45	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
47	Debit Amount ⚡ FLOW	Decimal	FlowField
48	Credit Amount ⚡ FLOW	Decimal	FlowField
49	Automatic Ext. Texts	Boolean	Normal
52	Budgeted Debit Amount ⚡ FLOW	Decimal	FlowField
53	Budgeted Credit Amount ⚡ FLOW	Decimal	FlowField
54	Tax Area Code	Code	Normal	→ Tax Area #318
55	Tax Liable	Boolean	Normal
56	Tax Group Code	Code	Normal	→ Tax Group #321
57	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
58	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
60	Additional-Currency Net Change ⚡ FLOW	Decimal	FlowField
61	Add.-Currency Balance at Date ⚡ FLOW	Decimal	FlowField
62	Additional-Currency Balance ⚡ FLOW	Decimal	FlowField
63	Exchange Rate Adjustment	Option	Normal
64	Add.-Currency Debit Amount ⚡ FLOW	Decimal	FlowField
65	Add.-Currency Credit Amount ⚡ FLOW	Decimal	FlowField
66	Analysis View Filter	Code	FlowFilter	→ Analysis View #363
67	Dimension 1 Filter	Code	FlowFilter
68	Dimension 2 Filter	Code	FlowFilter
69	Dimension 3 Filter	Code	FlowFilter
70	Dimension 4 Filter	Code	FlowFilter
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal