Table 1571 "VAT Entry Posting Preview"

Base Application · Microsoft.Finance.VAT.Ledger · captioned “VAT Entry” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	VAT Entry
TableType	Temporary
DataClassification	SystemMetadata

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Entry No.	Integer	—	not editable
2	Gen. Bus. Posting Group Δ BC26	Code[20]	Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group); not editable
3	Gen. Prod. Posting Group Δ BC26	Code[20]	Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group); not editable
4	Posting Date Δ BC26	Date	Specifies the VAT entry’s posting date.	not editable
5	Document No. Δ BC26	Code[20]	Specifies the document number on the VAT entry.	not editable
6	Document Type Δ BC26	Enum “Gen. Journal Document Type”	Specifies the document type that the VAT entry belongs to.	enum Enum 6 “Gen. Journal Document Type”; not editable
7	Type Δ BC26	Enum “General Posting Type”	Specifies the type of the VAT entry.	enum Enum 57 “General Posting Type”; not editable
8	Base Δ BC26 Δ BC28	Decimal	Specifies the amount that the VAT amount (the amount shown in the Amount field) is calculated from.	not editable
9	Amount Δ BC26 Δ BC28	Decimal	Specifies the amount of the VAT entry in LCY.	not editable
10	VAT Calculation Type Δ BC26	Enum “Tax Calculation Type”	Specifies how VAT will be calculated for purchases or sales of items with this particular combination of VAT business posting group and VAT product posting group.	enum Enum 254 “Tax Calculation Type”; not editable
12	Bill-to/Pay-to No. Δ BC26	Code[20]	Specifies the number of the bill-to customer or pay-to vendor that the entry is linked to.	TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (Type = const(Purchase)) Vendor else if (Type = const(Sale)) Customer)
13	EU 3-Party Trade Δ BC26	Boolean	Specifies if the transaction is related to trade with a third party within the EU.
14	User ID	Code[50]	—	not editable
15	Source Code	Code[10]	—	TableRelation Table 230 “Source Code” (Source Code); not editable
16	Reason Code	Code[10]	—	TableRelation Table 231 “Reason Code” (Reason Code); not editable
17	Closed by Entry No. Δ BC26	Integer	Specifies the number of the VAT entry that has closed the entry, if the VAT entry was closed with the Calc. and Post VAT Settlement batch job.	TableRelation Table 254 “VAT Entry” (VAT Entry); not editable
18	Closed Δ BC26	Boolean	Specifies whether the VAT entry has been closed by the Calc. and Post VAT Settlement batch job.	not editable
19	Country/Region Code Δ BC26	Code[10]	Specifies the country/region of the address.	TableRelation Table 9 “Country/Region” (Country/Region)
20	Internal Ref. No. Δ BC26	Text[30]	Specifies the internal reference number for the line.	not editable
21	Transaction No.	Integer	—	not editable
22	Unrealized Amount Δ BC28	Decimal	—	not editable
23	Unrealized Base Δ BC28	Decimal	—	not editable
24	Remaining Unrealized Amount Δ BC28	Decimal	—	not editable
25	Remaining Unrealized Base Δ BC28	Decimal	—	not editable
26	External Document No.	Code[35]	—	not editable
28	No. Series	Code[20]	—	TableRelation Table 308 “No. Series” (No. Series); not editable
29	Tax Area Code	Code[20]	—	TableRelation Table 318 “Tax Area” (Tax Area); not editable
30	Tax Liable	Boolean	—	not editable
31	Tax Group Code	Code[20]	—	TableRelation Table 321 “Tax Group” (Tax Group); not editable
32	Use Tax	Boolean	—	not editable
33	Tax Jurisdiction Code	Code[10]	—	TableRelation Table 320 “Tax Jurisdiction” (Tax Jurisdiction); not editable
34	Tax Group Used	Code[20]	—	TableRelation Table 321 “Tax Group” (Tax Group); not editable
35	Tax Type	Option	—	OptionCaption: Sales Tax,Excise Tax; not editable
36	Tax on Tax	Boolean	—	not editable
37	Sales Tax Connection No.	Integer	—	not editable
38	Unrealized VAT Entry No.	Integer	—	TableRelation Table 254 “VAT Entry” (VAT Entry); not editable
39	VAT Bus. Posting Group Δ BC26	Code[20]	Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group); not editable
40	VAT Prod. Posting Group Δ BC26	Code[20]	Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group); not editable
43	Additional-Currency Amount Δ BC26	Decimal	Specifies the amount of the VAT entry. The amount is in the additional reporting currency.	not editable
44	Additional-Currency Base Δ BC26	Decimal	Specifies the amount that the VAT amount is calculated from if you post in an additional reporting currency.	not editable
45	Add.-Currency Unrealized Amt.	Decimal	—	not editable
46	Add.-Currency Unrealized Base	Decimal	—	not editable
48	VAT Base Discount % Δ BC28	Decimal	—	not editable
49	Add.-Curr. Rem. Unreal. Amount	Decimal	—	not editable
50	Add.-Curr. Rem. Unreal. Base	Decimal	—	not editable
51	VAT Difference Δ BC26 Δ BC28	Decimal	Specifies the difference between the calculated VAT amount and a VAT amount that you have entered manually.	not editable
52	Add.-Curr. VAT Difference Δ BC26	Decimal	Specifies, in the additional reporting currency, the VAT difference that arises when you make a correction to a VAT amount on a sales or purchase document.	not editable
53	Ship-to/Order Address Code Δ BC26	Code[10]	Specifies the address code of the ship-to customer or order-from vendor that the entry is linked to.	TableRelation Table 222 “Ship-to Address”, Table 224 “Order Address” (if (Type = const(Purchase)) “Order Address”.Code where(“Vendor No.” = field(“Bill-to/Pay-to No.”)) else if (Type = const(Sale)) “Ship-to Address”.Code where(“Customer No.” = field(“Bill-to/Pay-to No.”)))
54	Document Date Δ BC26	Date	Specifies the date when the related document was created.	not editable
55	VAT Registration No. Δ BC26	Text[20]	Specifies the VAT registration number of the customer or vendor that the entry is linked to.
56	Reversed Δ BC26	Boolean	Specifies if the entry has been part of a reverse transaction.
57	Reversed by Entry No. Δ BC26	Integer	Specifies the number of the correcting entry. If the field Specifies a number, the entry cannot be reversed again.	TableRelation Table 254 “VAT Entry” (VAT Entry)
58	Reversed Entry No. Δ BC26	Integer	Specifies the number of the original entry that was undone by the reverse transaction.	TableRelation Table 254 “VAT Entry” (VAT Entry)
59	EU Service Δ BC26	Boolean	Specifies if this VAT entry is to be reported as a service in the periodic VAT reports.	not editable
60	Base Before Pmt. Disc. Δ BC28	Decimal	—	not editable
81	Realized Amount Δ BC28	Decimal	—	not editable
82	Realized Base Δ BC28	Decimal	—	not editable
83	Add.-Curr. Realized Amount Δ BC28	Decimal	—	not editable
84	Add.-Curr. Realized Base Δ BC28	Decimal	—	not editable
1570	Indentation	Integer	—
1571	VAT Entry No.	Integer	—

Keys

Key1: Entry No. (clustered)

Procedures

1 local procedures, no public ones.

Relations

Bill-to/Pay-to No.: TableRelation Table 18 “Customer” (conditional)
Ship-to/Order Address Code: TableRelation Table 222 “Ship-to Address” (conditional)
Ship-to/Order Address Code: TableRelation Table 224 “Order Address” (conditional)
Bill-to/Pay-to No.: TableRelation Table 23 “Vendor” (conditional)
Source Code: TableRelation Table 230 “Source Code”
Reason Code: TableRelation Table 231 “Reason Code”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Closed by Entry No.: TableRelation Table 254 “VAT Entry”
Reversed by Entry No.: TableRelation Table 254 “VAT Entry”
Reversed Entry No.: TableRelation Table 254 “VAT Entry”
Unrealized VAT Entry No.: TableRelation Table 254 “VAT Entry”
No. Series: TableRelation Table 308 “No. Series”
Tax Area Code: TableRelation Table 318 “Tax Area”
Tax Jurisdiction Code: TableRelation Table 320 “Tax Jurisdiction”
Tax Group Code: TableRelation Table 321 “Tax Group”
Tax Group Used: TableRelation Table 321 “Tax Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Country/Region Code: TableRelation Table 9 “Country/Region”

Pages and codeunits on this table

Page 1572 “VAT Entries Preview Subform” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "VAT Entry Posting Preview"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.