VAT Entry #254

Ledger Entries table in Microsoft Dynamics 365 Business Central. 79 fields, 532 records in Cronus demo.

Fields

532

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (79)

VAT Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
3	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
4	Posting Date	Date	Normal
5	Document No.	Code	Normal
6	Document Type	Option	Normal
7	Type	Option	Normal
8	Base	Decimal	Normal
9	Amount	Decimal	Normal
10	VAT Calculation Type	Option	Normal
12	Bill-to/Pay-to No.	Code	Normal
13	EU 3-Party Trade	Boolean	Normal
14	User ID	Code	Normal
15	Source Code	Code	Normal	→ Source Code #230
16	Reason Code	Code	Normal	→ Reason Code #231
17	Closed by Entry No.	Integer	Normal	→ VAT Entry #254
18	Closed	Boolean	Normal
19	Country/Region Code	Code	Normal	→ Country/Region #9
20	Internal Ref. No.	Text	Normal
21	Transaction No.	Integer	Normal
22	Unrealized Amount	Decimal	Normal
23	Unrealized Base	Decimal	Normal
24	Remaining Unrealized Amount	Decimal	Normal
25	Remaining Unrealized Base	Decimal	Normal
26	External Document No.	Code	Normal
28	No. Series	Code	Normal	→ No. Series #308
29	Tax Area Code	Code	Normal	→ Tax Area #318
30	Tax Liable	Boolean	Normal
31	Tax Group Code	Code	Normal	→ Tax Group #321
32	Use Tax	Boolean	Normal
33	Tax Jurisdiction Code	Code	Normal	→ Tax Jurisdiction #320
34	Tax Group Used	Code	Normal	→ Tax Group #321
35	Tax Type	Option	Normal
36	Tax on Tax	Boolean	Normal
37	Sales Tax Connection No.	Integer	Normal
38	Unrealized VAT Entry No.	Integer	Normal	→ VAT Entry #254
39	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
40	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
43	Additional-Currency Amount	Decimal	Normal
44	Additional-Currency Base	Decimal	Normal
45	Add.-Currency Unrealized Amt.	Decimal	Normal
46	Add.-Currency Unrealized Base	Decimal	Normal
48	VAT Base Discount %	Decimal	Normal
49	Add.-Curr. Rem. Unreal. Amount	Decimal	Normal
50	Add.-Curr. Rem. Unreal. Base	Decimal	Normal
51	VAT Difference	Decimal	Normal
52	Add.-Curr. VAT Difference	Decimal	Normal
53	Ship-to/Order Address Code	Code	Normal
54	Document Date	Date	Normal
55	VAT Registration No.	Text	Normal
56	Reversed	Boolean	Normal
57	Reversed by Entry No.	Integer	Normal	→ VAT Entry #254
58	Reversed Entry No.	Integer	Normal	→ VAT Entry #254
59	EU Service	Boolean	Normal
60	Base Before Pmt. Disc.	Decimal	Normal
70	Source Currency VAT Amount	Decimal	Normal
71	Source Currency VAT Base	Decimal	Normal
74	Source Currency Code	Code	Normal	→ Currency #4
75	Source Currency Factor	Decimal	Normal
78	Journal Template Name	Code	Normal
79	Journal Batch Name	Code	Normal
81	Realized Amount	Decimal	Normal
82	Realized Base	Decimal	Normal
83	Add.-Curr. Realized Amount	Decimal	Normal
84	Add.-Curr. Realized Base	Decimal	Normal
85	G/L Account No.	Code	Normal	→ G/L Account #15
86	VAT Date	Date	Normal
6200	Non-Deductible VAT %	Decimal	Normal
6201	Non-Deductible VAT Base	Decimal	Normal
6202	Non-Deductible VAT Amount	Decimal	Normal
6203	Non-Deductible VAT Base ACY	Decimal	Normal
6204	Non-Deductible VAT Amount ACY	Decimal	Normal
6205	Non-Deductible VAT Difference	Decimal	Normal
6206	Non-Deductible VAT Difference ACY	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