Table 15 G/L Account in 23

Jonas Paprotka, Base Application 23.5.16502.31399, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Finance.GeneralLedger.Account

Fields, 64 Keys, 10 Procedures, 10 Events, 6

Versions17 18 19 20 21 222324 25 26 27 28 latest

Source29

Fields, 64

Id	Name	Type	Obsolete
1	No.	Code[20]	-
2	Name	Text[100]	-
3	Search Name	Code[100]	-
4	Account Type	Enum G/L Account Type	-
6	Global Dimension 1 Code	Code[20]	-
7	Global Dimension 2 Code	Code[20]	-
8	Account Category	Enum G/L Account Category	-
9	Income/Balance	Option	-
10	Debit/Credit	Option	-
11	No. 2	Code[20]	-
12	Comment	Boolean	-
13	Blocked	Boolean	-
14	Direct Posting	Boolean	-
16	Reconciliation Account	Boolean	-
17	New Page	Boolean	-
18	No. of Blank Lines	Integer	-
19	Indentation	Integer	-
25	Last Modified Date Time	DateTime	-
26	Last Date Modified	Date	-
28	Date Filter	Date	-
29	Global Dimension 1 Filter	Code[20]	-
30	Global Dimension 2 Filter	Code[20]	-
31	Balance at Date	Decimal	-
32	Net Change	Decimal	-
33	Budgeted Amount	Decimal	-
34	Totaling	Text[250]	-
35	Budget Filter	Code[10]	-
36	Balance	Decimal	-
37	Budget at Date	Decimal	-
39	Consol. Translation Method	Option	-
40	Consol. Debit Acc.	Code[20]	-
41	Consol. Credit Acc.	Code[20]	-
42	Business Unit Filter	Code[20]	-
43	Gen. Posting Type	Enum General Posting Type	-
44	Gen. Bus. Posting Group	Code[20]	-
45	Gen. Prod. Posting Group	Code[20]	-
46	Picture	Blob	-
47	Debit Amount	Decimal	-
48	Credit Amount	Decimal	-
49	Automatic Ext. Texts	Boolean	-
52	Budgeted Debit Amount	Decimal	-
53	Budgeted Credit Amount	Decimal	-
54	Tax Area Code	Code[20]	-
55	Tax Liable	Boolean	-
56	Tax Group Code	Code[20]	-
57	VAT Bus. Posting Group	Code[20]	-
58	VAT Prod. Posting Group	Code[20]	-
59	VAT Amt.	Decimal	-
60	Additional-Currency Net Change	Decimal	-
61	Add.-Currency Balance at Date	Decimal	-
62	Additional-Currency Balance	Decimal	-
63	Exchange Rate Adjustment	Enum Exch. Rate Adjustment Type	-
64	Add.-Currency Debit Amount	Decimal	-
65	Add.-Currency Credit Amount	Decimal	-
66	Default IC Partner G/L Acc. No	Code[20]	-
70	Omit Default Descr. in Jnl.	Boolean	-
80	Account Subcategory Entry No.	Integer	-
81	Account Subcategory Descript.	Text[80]	-
82	VAT Reporting Date Filter	Date	-
400	Dimension Set ID Filter	Integer	-
1100	Cost Type No.	Code[20]	-
1700	Default Deferral Template Code	Code[10]	-
8000	Id	Guid	Removed 22.0
This functionality will be replaced by the systemID field
9000	API Account Type	Enum G/L Account Type	-

Keys, 10

Name	Fields	Obsolete
Key1, clustered	No.	-
Key2	Search Name	-
Key3	Reconciliation Account	-
Key4	Gen. Bus. Posting Group	-
Key5	Gen. Prod. Posting Group	-
Key6	Consol. Debit Acc., Consol. Translation Method	-
Key7	Consol. Credit Acc., Consol. Translation Method	-
Key8	Name	-
Key9	Account Type	-
Key10	Account Category	-

Procedures, 10

Name	Parameters	Returns	Access	Obsolete
ShowPriceListLines	(Enum Price Type, Enum Price Amount Type)		public	-
SetupNewGLAcc	(Record G/L Account, Boolean)		public	-
CheckGLAcc	()		public	-
ValidateAccountSubCategory	(Text[80])		public	-
LookupAccountSubCategory	()		public	-
GetCurrencyCode	()	Code[10]	public	-
ValidateShortcutDimCode	(Integer, var Code[20])		public	-
TranslationMethodConflict	(var Record G/L Account)	Boolean	public	-
IsTotaling	()	Boolean	public	-
CheckGenProdPostingGroup	()		public	-

Events, 6

Kind	Name	Parameters	Obsolete
Integration event	OnAfterCheckGLAcc	(var Record G/L Account)	-
Integration event	OnAfterSetupNewGLAcc	(var Record G/L Account)	-
Integration event	OnAfterValidateShortcutDimCode	(var Record G/L Account, var Record G/L Account, Integer, var Code[20])	-
Integration event	OnBeforeValidateShortcutDimCode	(var Record G/L Account, var Record G/L Account, Integer, var Code[20])	-
Integration event	OnBeforeCheckGenProdPostingGroup	(var Record G/L Account, var Boolean)	-
Integration event	OnBeforeOnDelete	(var Record G/L Account, var Boolean)	-