Table 17 G/L Entry

Base Application, Microsoft.Finance.GeneralLedger.Ledger

76 fields

IdNameTypeVersions
1Entry No.Integer17-29
3G/L Account No.Code[20]17-29
4Posting DateDate17-29
5Document TypeEnum "Gen. Journal Document Type"17-29
6Document No.Code[20]17-29
7DescriptionText[100]17-29
10Bal. Account No.Code[20]17-29
17AmountDecimal17-29
18Source Currency AmountDecimalnew in 24
19Source Currency VAT AmountDecimalnew in 24
20Source Currency CodeCode[10]new in 24
23Global Dimension 1 CodeCode[20]17-29
24Global Dimension 2 CodeCode[20]17-29
27User IDCode[50]17-29
28Source CodeCode[10]17-29
29System-Created EntryBoolean17-29
30Prior-Year EntryBoolean17-29
41Job No.Code[20]17-29
42QuantityDecimal17-29
43VAT AmountDecimal17-29
45Business Unit CodeCode[20]17-29
46Journal Batch NameCode[10]17-29
47Reason CodeCode[10]17-29
48Gen. Posting TypeEnum "General Posting Type"17-29
49Gen. Bus. Posting GroupCode[20]17-29
50Gen. Prod. Posting GroupCode[20]17-29
51Bal. Account TypeEnum "Gen. Journal Account Type"17-29
52Transaction No.Integer17-29
53Debit AmountDecimal17-29
54Credit AmountDecimal17-29
55Document DateDate17-29
56External Document No.Code[35]17-29
57Source TypeEnum "Gen. Journal Source Type"17-29
58Source No.Code[20]17-29
59No. SeriesCode[20]17-29
60Tax Area CodeCode[20]17-29
61Tax LiableBoolean17-29
62Tax Group CodeCode[20]17-29
63Use TaxBoolean17-29
64VAT Bus. Posting GroupCode[20]17-29
65VAT Prod. Posting GroupCode[20]17-29
68Additional-Currency AmountDecimal17-29
69Add.-Currency Debit AmountDecimal17-29
70Add.-Currency Credit AmountDecimal17-29
71Close Income Statement Dim. IDInteger17-29
72IC Partner CodeCode[20]17-29
73ReversedBoolean17-29
74Reversed by Entry No.Integer17-29
75Reversed Entry No.Integer17-29
76G/L Account NameText[100]17-29
78Journal Templ. NameCode[10]new in 20
79VAT Reporting DateDatenew in 21
95G/L Register No.Integernew in 29
480Dimension Set IDInteger17-29
481Shortcut Dimension 3 CodeCode[20]17-29
482Shortcut Dimension 4 CodeCode[20]17-29
483Shortcut Dimension 5 CodeCode[20]17-29
484Shortcut Dimension 6 CodeCode[20]17-29
485Shortcut Dimension 7 CodeCode[20]17-29
486Shortcut Dimension 8 CodeCode[20]17-29
495Last Dim. Correction Entry No.Integernew in 18
496Last Dim. Correction NodeIntegernew in 18
497Dimension Changes CountIntegernew in 18
2678Allocation Account No.Code[20]new in 23
2679Alloc. Journal Line SystemIdGuidnew in 27
5400Prod. Order No.Code[20]17-29
5600FA Entry TypeOption17-29
5601FA Entry No.Integer17-29
5618CommentText[250]new in 19
6200Non-Deductible VAT AmountDecimalnew in 22
6201Non-Deductible VAT Amount ACYDecimalnew in 22
6202Src. Curr. Non-Ded. VAT AmountDecimalnew in 25
8001Account IdGuid17-29
8005Last Modified DateTimeDateTime17-29
10018STE Transaction IDText[20]17-29
10019GST/HSTEnum "GST HST Tax Type"17-29changed in 19