Objects/Tables/Table 98 General Ledger Setup

Table 98 General Ledger Setup in 23

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

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

Fields, 99 Keys, 1 Procedures, 15 Events, 4

Versions17 18 19 20 21 222324 25 26 27 28 latest

Source29

Fields, 99

Id	Name	Type	Obsolete
1	Primary Key	Code[10]	-
2	Allow Posting From	Date	-
3	Allow Posting To	Date	-
4	Register Time	Boolean	-
5	Allow Deferral Posting From	Date	-
6	Allow Deferral Posting To	Date	-
7	VAT Reporting Date	Enum VAT Reporting Date	-
8	VAT Reporting Date Usage	Enum VAT Reporting Date Usage	-
28	Pmt. Disc. Excl. VAT	Boolean	-
41	Date Filter	Date	-
42	Global Dimension 1 Filter	Code[20]	-
43	Global Dimension 2 Filter	Code[20]	-
44	Cust. Balances Due	Decimal	-
45	Vendor Balances Due	Decimal	-
48	Unrealized VAT	Boolean	-
49	Adjust for Payment Disc.	Boolean	-
50	Post with Job Queue	Boolean	-
51	Job Queue Category Code	Code[10]	-
52	Job Queue Priority for Post	Integer	-
53	Post & Print with Job Queue	Boolean	-
54	Job Q. Prio. for Post & Print	Integer	-
55	Notify On Success	Boolean	-
56	Mark Cr. Memos as Corrections	Boolean	-
57	Local Address Format	Option	-
58	Inv. Rounding Precision (LCY)	Decimal	-
59	Inv. Rounding Type (LCY)	Option	-
60	Local Cont. Addr. Format	Option	-
61	Report Output Type	Enum Setup Report Output Type	-
63	Bank Account Nos.	Code[20]	-
65	Summarize G/L Entries	Boolean	-
66	Amount Decimal Places	Text[5]	-
67	Unit-Amount Decimal Places	Text[5]	-
68	Additional Reporting Currency	Code[10]	-
69	VAT Tolerance %	Decimal	-
70	EMU Currency	Boolean	-
71	LCY Code	Code[10]	-
72	VAT Exchange Rate Adjustment	Enum Exch. Rate Adjustment Type	-
73	Amount Rounding Precision	Decimal	-
74	Unit-Amount Rounding Precision	Decimal	-
75	Appln. Rounding Precision	Decimal	-
79	Global Dimension 1 Code	Code[20]	-
80	Global Dimension 2 Code	Code[20]	-
81	Shortcut Dimension 1 Code	Code[20]	-
82	Shortcut Dimension 2 Code	Code[20]	-
83	Shortcut Dimension 3 Code	Code[20]	-
84	Shortcut Dimension 4 Code	Code[20]	-
85	Shortcut Dimension 5 Code	Code[20]	-
86	Shortcut Dimension 6 Code	Code[20]	-
87	Shortcut Dimension 7 Code	Code[20]	-
88	Shortcut Dimension 8 Code	Code[20]	-
89	Max. VAT Difference Allowed	Decimal	-
90	VAT Rounding Type	Option	-
92	Pmt. Disc. Tolerance Posting	Option	-
93	Payment Discount Grace Period	DateFormula	-
94	Payment Tolerance %	Decimal	-
95	Max. Payment Tolerance Amount	Decimal	-
96	Adapt Main Menu to Permissions	Boolean	Pending 17.0
Replaced with UI Elements Removal feature.
97	Allow G/L Acc. Deletion Before	Date	-
98	Check G/L Account Usage	Boolean	-
99	Payment Tolerance Posting	Option	-
100	Pmt. Disc. Tolerance Warning	Boolean	-
101	Payment Tolerance Warning	Boolean	-
102	Last IC Transaction No.	Integer	-
103	Bill-to/Sell-to VAT Calc.	Enum G/L Setup VAT Calculation	-
104	Block Deletion of G/L Accounts	Boolean	-
110	Acc. Sched. for Balance Sheet	Code[10]	Pending 22.0
Financial Reporting is replacing Account Schedules for financial statements
111	Acc. Sched. for Income Stmt.	Code[10]	Pending 22.0
Financial Reporting is replacing Account Schedules for financial statements
112	Acc. Sched. for Cash Flow Stmt	Code[10]	Pending 22.0
Financial Reporting is replacing Account Schedules for financial statements
113	Acc. Sched. for Retained Earn.	Code[10]	Pending 22.0
Financial Reporting is replacing Account Schedules for financial statements
114	Fin. Rep. for Balance Sheet	Code[10]	-
115	Fin. Rep. for Income Stmt.	Code[10]	-
116	Fin. Rep. for Cash Flow Stmt	Code[10]	-
117	Fin. Rep. for Retained Earn.	Code[10]	-
120	Tax Invoice Renaming Threshold	Decimal	-
130	Req.Country/Reg. Code in Addr.	Boolean	-
150	Print VAT specification in LCY	Boolean	-
151	Prepayment Unrealized VAT	Boolean	-
152	Use Legacy G/L Entry Locking	Boolean	Removed 21.0
Legacy G/L Locking is no longer supported.
160	Payroll Trans. Import Format	Code[20]	-
161	VAT Reg. No. Validation URL	Text[250]	Removed 18.0
This field is obsolete, it has been replaced by Table 248 VAT Reg. No. Srv Config.
162	Local Currency Symbol	Text[10]	-
163	Local Currency Description	Text[60]	-
164	Show Amounts	Option	-
169	Posting Preview Type	Enum Posting Preview Type	-
170	SEPA Non-Euro Export	Boolean	-
171	SEPA Export w/o Bank Acc. Data	Boolean	-
175	Journal Templ. Name Mandatory	Boolean	-
176	Hide Payment Method Code	Boolean	-
177	Enable Data Check	Boolean	-
180	Apply Jnl. Template Name	Code[10]	-
181	Apply Jnl. Batch Name	Code[10]	-
182	Job WIP Jnl. Template Name	Code[10]	-
183	Job WIP Jnl. Batch Name	Code[10]	-
184	Adjust ARC Jnl. Template Name	Code[10]	-
185	Adjust ARC Jnl. Batch Name	Code[10]	-
186	Bank Acc. Recon. Template Name	Code[10]	-
187	Bank Acc. Recon. Batch Name	Code[10]	-
188	Control VAT Period	Enum VAT Period Control	-
189	Allow Query From Consolid.	Boolean	-

Keys, 1

Name	Fields	Obsolete
Key1, clustered	Primary Key	-

Procedures, 15

Name	Parameters	Returns	Access	Obsolete
CheckDecimalPlacesFormat	(var Text[5])		public	-
GetCurrencyCode	(Code[10])	Code[10]	public	-
GetCurrencySymbol	()	Text[10]	public	-
GetRecordOnce	()		public	-
CheckRoundingError	(Text[100])		public	-
IsPostingAllowed	(Date)	Boolean	public	-
JobQueueActive	()	Boolean	public	-
FirstAllowedPostingDate	()	Date	public	-
UpdateDimValueGlobalDimNo	(Code[20], Code[20], Integer)		public	-
UseVat	()	Boolean	public	-
CheckAllowedPostingDates	(Option)		public	-
GetPmtToleranceVisible	()	Boolean	public	-
CheckAllowedDeferralPostingDates	(Option)		public	-
UpdateVATDate	(Date, Enum VAT Reporting Date, var Date)		public	-
GetVATDate	(Date, Date)	Date	public	-

Events, 4

Kind	Name	Parameters	Obsolete
Integration event	OnBeforeCheckRoundingError	(var Boolean)	-
Integration event	OnBeforeFirstAllowedPostingDate	(Record General Ledger Setup, var Date, var Boolean)	-
Integration event	OnAfterIsPostingAllowed	(Record General Ledger Setup, Date, var Boolean)	-
Integration event	OnAfterUpdateDimValueGlobalDimNo	(Integer, Code[20], Code[20])	-