Table 98 General Ledger Setup

Base Application, Microsoft.Finance.GeneralLedger.Setup

119 fields

IdNameTypeVersions
1Primary KeyCode[10]17-29
2Allow Posting FromDate17-29
3Allow Posting ToDate17-29
4Register TimeBoolean17-29
5Allow Deferral Posting FromDatenew in 20
6Allow Deferral Posting ToDatenew in 20
7VAT Reporting DateEnum "VAT Reporting Date"new in 21
8VAT Reporting Date UsageEnum "VAT Reporting Date Usage"new in 21
28Pmt. Disc. Excl. VATBoolean17-29
41Date FilterDate17-29
42Global Dimension 1 FilterCode[20]17-29
43Global Dimension 2 FilterCode[20]17-29
44Cust. Balances DueDecimal17-29
45Vendor Balances DueDecimal17-29
48Unrealized VATBoolean17-29
49Adjust for Payment Disc.Boolean17-29
50Post with Job QueueBoolean17-29
51Job Queue Category CodeCode[10]17-29
52Job Queue Priority for PostInteger17-29
53Post & Print with Job QueueBoolean17-29
54Job Q. Prio. for Post & PrintInteger17-29
55Notify On SuccessBoolean17-29
56Mark Cr. Memos as CorrectionsBoolean17-29
57Local Address FormatOption17-29
58Inv. Rounding Precision (LCY)Decimal17-29
59Inv. Rounding Type (LCY)Option17-29
60Local Cont. Addr. FormatOption17-29
61Report Output TypeEnum "Setup Report Output Type"17-29changed in 22
63Bank Account Nos.Code[20]17-29
64Spend Request No. SeriesCode[20]new in 29
65Summarize G/L EntriesBoolean17-29
66Amount Decimal PlacesText[5]17-29
67Unit-Amount Decimal PlacesText[5]17-29
68Additional Reporting CurrencyCode[10]17-29
69VAT Tolerance %Decimal17-29
70EMU CurrencyBoolean17-29
71LCY CodeCode[10]17-29
72VAT Exchange Rate AdjustmentEnum "Exch. Rate Adjustment Type"17-29changed in 20
73Amount Rounding PrecisionDecimal17-29
74Unit-Amount Rounding PrecisionDecimal17-29
75Appln. Rounding PrecisionDecimal17-29
79Global Dimension 1 CodeCode[20]17-29
80Global Dimension 2 CodeCode[20]17-29
81Shortcut Dimension 1 CodeCode[20]17-29
82Shortcut Dimension 2 CodeCode[20]17-29
83Shortcut Dimension 3 CodeCode[20]17-29
84Shortcut Dimension 4 CodeCode[20]17-29
85Shortcut Dimension 5 CodeCode[20]17-29
86Shortcut Dimension 6 CodeCode[20]17-29
87Shortcut Dimension 7 CodeCode[20]17-29
88Shortcut Dimension 8 CodeCode[20]17-29
89Max. VAT Difference AllowedDecimal17-29
90VAT Rounding TypeOption17-29
92Pmt. Disc. Tolerance PostingOption17-29
93Payment Discount Grace PeriodDateFormula17-29
94Payment Tolerance %Decimal17-29
95Max. Payment Tolerance AmountDecimal17-29
96Adapt Main Menu to PermissionsBooleangone after 25
Removed, tag 24.0, obsolete since 17: Replaced with UI Elements Removal feature.
97Allow G/L Acc. Deletion BeforeDate17-29
98Check G/L Account UsageBoolean17-29
99Payment Tolerance PostingOption17-29
100Pmt. Disc. Tolerance WarningBoolean17-29
101Payment Tolerance WarningBoolean17-29
102Last IC Transaction No.Integer17-29
103Bill-to/Sell-to VAT Calc.Enum "G/L Setup VAT Calculation"17-29changed in 18
104Block Deletion of G/L AccountsBooleannew in 20
110Acc. Sched. for Balance SheetCode[10]17-29
Removed, tag 25.0, obsolete since 21: Financial Reporting is replacing Account Schedules for financial statements
111Acc. Sched. for Income Stmt.Code[10]17-29
Removed, tag 25.0, obsolete since 21: Financial Reporting is replacing Account Schedules for financial statements
112Acc. Sched. for Cash Flow StmtCode[10]17-29
Removed, tag 25.0, obsolete since 21: Financial Reporting is replacing Account Schedules for financial statements
113Acc. Sched. for Retained Earn.Code[10]17-29
Removed, tag 25.0, obsolete since 21: Financial Reporting is replacing Account Schedules for financial statements
114Fin. Rep. for Balance SheetCode[10]new in 21
115Fin. Rep. for Income Stmt.Code[10]new in 21
116Fin. Rep. for Cash Flow StmtCode[10]new in 21
117Fin. Rep. for Retained Earn.Code[10]new in 21
120Tax Invoice Renaming ThresholdDecimal17-29
130Req.Country/Reg. Code in Addr.Booleannew in 19
150Print VAT specification in LCYBoolean17-29
151Prepayment Unrealized VATBoolean17-29
152Use Legacy G/L Entry LockingBooleangone after 25
Removed, tag 21.0, obsolete since 18: Legacy G/L Locking is no longer supported.
160Payroll Trans. Import FormatCode[20]17-29
161VAT Reg. No. Validation URLText[250]gone after 25
Removed, tag 18.0, obsolete since 17: This field is obsolete, it has been replaced by Table 248 VAT Reg. No. Srv Config.
162Local Currency SymbolText[10]17-29
163Local Currency DescriptionText[60]17-29
164Show AmountsOption17-29
169Posting Preview TypeEnum "Posting Preview Type"new in 19
170SEPA Non-Euro ExportBoolean17-29
171SEPA Export w/o Bank Acc. DataBoolean17-29
175Journal Templ. Name MandatoryBooleannew in 20
176Hide Payment Method CodeBooleannew in 20
177Enable Data CheckBooleannew in 20
178Document Retention PeriodEnum "Docs - Retention Period Def."new in 24
180Apply Jnl. Template NameCode[10]new in 20
181Apply Jnl. Batch NameCode[10]new in 20
182Job WIP Jnl. Template NameCode[10]new in 20
183Job WIP Jnl. Batch NameCode[10]new in 20
184Adjust ARC Jnl. Template NameCode[10]new in 20
185Adjust ARC Jnl. Batch NameCode[10]new in 20
186Bank Acc. Recon. Template NameCode[10]new in 20
187Bank Acc. Recon. Batch NameCode[10]new in 20
188Control VAT PeriodEnum "VAT Period Control"new in 21
189Allow Query From Consolid.Booleannew in 23
190Acc. Receivables CategoryIntegernew in 24
191App. Dimension PostingEnum "Exch. Rate Adjmt. Dimensions"new in 24
192Hide Company Bank AccountBooleannew in 26
193Check Source Curr. ConsistencyBooleannew in 27
194Acc. Payables CategoryIntegernew in 27
195Fin. Rep. Period TypeEnum "Analysis Period Type"new in 28
196Fin. Rep. Neg. Amount FormatEnum "Analysis Negative Format"new in 28
197Fin. Rep. Company Logo Pos.Enum "Fin. Report Logo Position"new in 28
198Fin. Rep. Bal. Sheet RowCode[10]new in 28
199Fin. Rep. Income Stmt. RowCode[10]new in 28
200Fin. Rep. Cash Flow Stmt. RowCode[10]new in 28
201Fin. Rep. Retained Earn. RowCode[10]new in 28
202Fin. Rep. Bal. Sheet ColumnCode[10]new in 28
203Fin. Rep. Net Change ColumnCode[10]new in 28
204DefaultFinancialReportStatusCode[10]new in 28
205Allow Posting From DateFormulaDateFormulanew in 28
206Allow Posting To DateFormulaDateFormulanew in 28
210Use Concurrent PostingBooleannew in 29