General Ledger Setup #98

Setup table in Microsoft Dynamics 365 Business Central. 110 fields, 1 records in Cronus demo.

110

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: Primary Key.

All fields (110)

General Ledger Setup — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Primary Key PK	Code	Normal
2	Allow Posting From	Date	Normal
3	Allow Posting To	Date	Normal
4	Register Time	Boolean	Normal
5	Allow Deferral Posting From	Date	Normal
6	Allow Deferral Posting To	Date	Normal
7	Default VAT Date	Option	Normal
8	VAT Date Usage	Option	Normal
28	Pmt. Disc. Excl. VAT	Boolean	Normal
41	Date Filter	Date	FlowFilter
42	Global Dimension 1 Filter	Code	FlowFilter	→ Dimension Value #349
43	Global Dimension 2 Filter	Code	FlowFilter	→ Dimension Value #349
44	Cust. Balances Due ⚡ FLOW	Decimal	FlowField
45	Vendor Balances Due ⚡ FLOW	Decimal	FlowField
48	Unrealized VAT	Boolean	Normal
49	Adjust for Payment Disc.	Boolean	Normal
50	Post with Job Queue	Boolean	Normal
51	Job Queue Category Code	Code	Normal	→ Job Queue Category #471
52	Job Queue Priority for Post	Integer	Normal
53	Post & Print with Job Queue	Boolean	Normal
54	Job Q. Prio. for Post & Print	Integer	Normal
55	Notify On Success	Boolean	Normal
56	Mark Cr. Memos as Corrections	Boolean	Normal
57	Local Address Format	Option	Normal
58	Inv. Rounding Precision (LCY)	Decimal	Normal
59	Inv. Rounding Type (LCY)	Option	Normal
60	Local Cont. Addr. Format	Option	Normal
61	Report Output Type	Option	Normal
63	Bank Account Nos.	Code	Normal	→ No. Series #308
65	Summarize G/L Entries	Boolean	Normal
66	Amount Decimal Places	Text	Normal
67	Unit-Amount Decimal Places	Text	Normal
68	Additional Reporting Currency	Code	Normal	→ Currency #4
69	VAT Tolerance %	Decimal	Normal
70	EMU Currency	Boolean	Normal
71	LCY Code	Code	Normal
72	VAT Exchange Rate Adjustment	Option	Normal
73	Amount Rounding Precision	Decimal	Normal
74	Unit-Amount Rounding Precision	Decimal	Normal
75	Appln. Rounding Precision	Decimal	Normal
79	Global Dimension 1 Code	Code	Normal	→ Dimension #348
80	Global Dimension 2 Code	Code	Normal	→ Dimension #348
81	Shortcut Dimension 1 Code	Code	Normal	→ Dimension #348
82	Shortcut Dimension 2 Code	Code	Normal	→ Dimension #348
83	Shortcut Dimension 3 Code	Code	Normal	→ Dimension #348
84	Shortcut Dimension 4 Code	Code	Normal	→ Dimension #348
85	Shortcut Dimension 5 Code	Code	Normal	→ Dimension #348
86	Shortcut Dimension 6 Code	Code	Normal	→ Dimension #348
87	Shortcut Dimension 7 Code	Code	Normal	→ Dimension #348
88	Shortcut Dimension 8 Code	Code	Normal	→ Dimension #348
89	Max. VAT Difference Allowed	Decimal	Normal
90	VAT Rounding Type	Option	Normal
92	Pmt. Disc. Tolerance Posting	Option	Normal
93	Payment Discount Grace Period	DateFormula	Normal
94	Payment Tolerance %	Decimal	Normal
95	Max. Payment Tolerance Amount	Decimal	Normal
97	Check G/L Acc. Deletion After	Date	Normal
98	Check G/L Account Usage	Boolean	Normal
99	Payment Tolerance Posting	Option	Normal
100	Pmt. Disc. Tolerance Warning	Boolean	Normal
101	Payment Tolerance Warning	Boolean	Normal
102	Last IC Transaction No.	Integer	Normal
103	Bill-to/Sell-to VAT Calc.	Option	Normal
104	Block Deletion of G/L Accounts	Boolean	Normal
114	Financial Report for Balance Sheet	Code	Normal	→ Financial Report #88
115	Financial Report for Income Stmt.	Code	Normal	→ Financial Report #88
116	Financial Report for Cash Flow Stmt	Code	Normal	→ Financial Report #88
117	Financial Report for Retained Earn.	Code	Normal	→ Financial Report #88
120	Tax Invoice Renaming Threshold	Decimal	Normal
130	Require Country/Region Code in Address	Boolean	Normal
150	Print VAT specification in LCY	Boolean	Normal
151	Prepayment Unrealized VAT	Boolean	Normal
160	Payroll Trans. Import Format	Code	Normal	→ Data Exch. Def #1222
162	Local Currency Symbol	Text	Normal
163	Local Currency Description	Text	Normal
164	Show Amounts	Option	Normal
165	Show Currency	Option	Normal
166	Currency Symbol Position	Option	Normal
169	Posting Preview Type	Option	Normal
170	SEPA Non-Euro Export	Boolean	Normal
171	SEPA Export w/o Bank Acc. Data	Boolean	Normal
175	Journal Templ. Name Mandatory	Boolean	Normal
176	Hide Payment Method Code	Boolean	Normal
177	Enable Data Check	Boolean	Normal
178	Documents Retention Period	Option	Normal
180	Apply Jnl. Template Name	Code	Normal	→ Gen. Journal Template #80
181	Apply Jnl. Batch Name	Code	Normal
182	Project WIP Jnl. Template Name	Code	Normal	→ Gen. Journal Template #80
183	Project WIP Jnl. Batch Name	Code	Normal
184	Adjust Add. Rep. Currency Jnl. Template Name	Code	Normal	→ Gen. Journal Template #80
185	Adjust Add. Rep. Currency Jnl. Batch Name	Code	Normal
186	Bank Acc. Recon. Template Name	Code	Normal	→ Gen. Journal Template #80
187	Bank Acc. Recon. Batch Name	Code	Normal
188	Control VAT Period	Option	Normal
189	Enable company as subsidiary	Boolean	Normal
190	Account Receivables G/L Account Category	Integer	Normal	→ G/L Account Category #570
191	Dimension Posting	Option	Normal
192	Hide Company Bank Account	Boolean	Normal
193	Check Source Curr. Consistency	Boolean	Normal
194	Account Payables G/L Account Category	Integer	Normal	→ G/L Account Category #570
8051	Dimension Code for Customer Subscription Contract	Code	Normal	→ Dimension #348
10500	Threshold applies	Boolean	Normal
10501	Threshold Amount	Decimal	Normal
10507	Threshold applies	Boolean	Normal
10508	Threshold Amount	Decimal	Normal
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