Table 254 VAT Entry

Base Application, Microsoft.Finance.VAT.Ledger

78 fields

IdNameTypeVersions
1Entry No.Integer17-29
2Gen. Bus. Posting GroupCode[20]17-29
3Gen. Prod. Posting GroupCode[20]17-29
4Posting DateDate17-29
5Document No.Code[20]17-29
6Document TypeEnum "Gen. Journal Document Type"17-29
7TypeEnum "General Posting Type"17-29
8BaseDecimal17-29
9AmountDecimal17-29
10VAT Calculation TypeEnum "Tax Calculation Type"17-29
12Bill-to/Pay-to No.Code[20]17-29
13EU 3-Party TradeBoolean17-29
14User IDCode[50]17-29
15Source CodeCode[10]17-29
16Reason CodeCode[10]17-29
17Closed by Entry No.Integer17-29
18ClosedBoolean17-29
19Country/Region CodeCode[10]17-29
20Internal Ref. No.Text[30]17-29
21Transaction No.Integer17-29
22Unrealized AmountDecimal17-29
23Unrealized BaseDecimal17-29
24Remaining Unrealized AmountDecimal17-29
25Remaining Unrealized BaseDecimal17-29
26External Document No.Code[35]17-29
28No. SeriesCode[20]17-29
29Tax Area CodeCode[20]17-29
30Tax LiableBoolean17-29
31Tax Group CodeCode[20]17-29
32Use TaxBoolean17-29
33Tax Jurisdiction CodeCode[10]17-29
34Tax Group UsedCode[20]17-29
35Tax TypeOption17-29
36Tax on TaxBoolean17-29
37Sales Tax Connection No.Integer17-29
38Unrealized VAT Entry No.Integer17-29
39VAT Bus. Posting GroupCode[20]17-29
40VAT Prod. Posting GroupCode[20]17-29
43Additional-Currency AmountDecimal17-29
44Additional-Currency BaseDecimal17-29
45Add.-Currency Unrealized Amt.Decimal17-29
46Add.-Currency Unrealized BaseDecimal17-29
48VAT Base Discount %Decimal17-29
49Add.-Curr. Rem. Unreal. AmountDecimal17-29
50Add.-Curr. Rem. Unreal. BaseDecimal17-29
51VAT DifferenceDecimal17-29
52Add.-Curr. VAT DifferenceDecimal17-29
53Ship-to/Order Address CodeCode[10]17-29
54Document DateDate17-29
55VAT Registration No.Text[20]17-29
56ReversedBoolean17-29
57Reversed by Entry No.Integer17-29
58Reversed Entry No.Integer17-29
59EU ServiceBoolean17-29
60Base Before Pmt. Disc.Decimal17-29
70Source Currency VAT AmountDecimalnew in 24
71Source Currency VAT BaseDecimalnew in 24
74Source Currency CodeCode[10]new in 24
75Source Currency FactorDecimalnew in 24
78Journal Templ. NameCode[10]new in 20
79Journal Batch NameCode[10]new in 20
81Realized AmountDecimal17-29
82Realized BaseDecimal17-29
83Add.-Curr. Realized AmountDecimal17-29
84Add.-Curr. Realized BaseDecimal17-29
85G/L Acc. No.Code[20]new in 19
86VAT Reporting DateDatenew in 21
95G/L Register No.Integernew in 29
6200Non-Deductible VAT %Decimalnew in 22
6201Non-Deductible VAT BaseDecimalnew in 22
6202Non-Deductible VAT AmountDecimalnew in 22
6203Non-Deductible VAT Base ACYDecimalnew in 22
6204Non-Deductible VAT Amount ACYDecimalnew in 22
6205Non-Deductible VAT Diff.Decimalnew in 22
6206Non-Deductible VAT Diff. ACYDecimalnew in 22
10015Tax Exemption No.Text[30]17-29
10018STE Transaction IDText[20]17-29
10019GST/HSTEnum "GST HST Tax Type"17-29changed in 19