Share via

VAT Entry Table

  • Article

Specifies the VAT entry if you post a line in the general ledger, sales, or purchases application area, and the entry contains a VAT code.

VAT ledger entries are created by the following: the posting of a sales order, invoice, credit memo or journal line; the posting of a purchase order, invoice, credit memo, or journal line; and the Calc. and Post VAT Settlement batch job.

List of Fields in the Table

The following table lists the fields in this table.

Field Location
Reversed Entry No. Field, VAT Entry Table General Ledger
First Name Field, VAT Entry Table Italy Local Functionality
Ship-to/Order Address Code Field, VAT Entry Table General Ledger
Tax Group Code Field, VAT Entry Table General Ledger
Document Type Field, VAT Entry Table General Ledger
Payment Method Field, VAT Entry Table Italy Local Functionality
EU 3-Party Trade Field, VAT Entry Table General Ledger
Add. Curr. Nondeductible Amt. Field, VAT Entry Table Italy Local Functionality
Unrealized Base Field, VAT Entry Table General Ledger
Add.-Curr. Rem. Unreal. Amount Field, VAT Entry Table General Ledger
Place of Birth Field, VAT Entry Table Italy Local Functionality
Reason Code Field, VAT Entry Table General Ledger
Gen. Prod. Posting Group Field, VAT Entry Table General Ledger
Include in VAT Transac. Rep. Field, VAT Entry Table Italy Local Functionality
Blacklisted Field, VAT Entry Table Italy Local Functionality
Transport Method Field, VAT Entry Table Italy Local Functionality
Add.-Currency Unrealized Base Field, VAT Entry Table General Ledger
Contract No. Field, VAT Entry Table Italy Local Functionality
Plafond Entry Field, VAT Entry Table Italy Local Functionality
Reverse Sales VAT Field, VAT Entry Table Italy Local Functionality
Activity Code Field, VAT Entry Table Italy Local Functionality
Fiscal Code Field, VAT Entry Table Italy Local Functionality
BAS Doc. No. Field, VAT Entry Table New Zealand Local Functionality
STE Transaction ID Field, Tax Entry Table United States Local Functionality
Tax Exemption No. Field, Tax Entry Table United States Local Functionality
Year Field, VAT Entry Table Belgium Local Functionality
VAT Identifier Field, VAT Entry Table Italy Local Functionality
Posting Date Field, VAT Entry Table General Ledger
Base Before Pmt. Disc. Field, VAT Entry Table Belgium Local Functionality
Settlement Adjustment Field, VAT Entry Table New Zealand Local Functionality
VAT % Field, VAT Entry Table Italy Local Functionality
BAS Adjustment Field, VAT Entry Table New Zealand Local Functionality
Sett. Rem. Unrealized Amount Field, VAT Entry Table New Zealand Local Functionality
G/L Account No. Field, VAT Entry Table Germany Local Functionality
Sett. Unrealized Base Field, VAT Entry Table New Zealand Local Functionality
Transaction No. Field, VAT Entry Table General Ledger
Amount Field, VAT Entry Table General Ledger
Country/Region Code Field, VAT Entry Table General Ledger
Tax Representative No. Field, VAT Entry Table Italy Local Functionality
Journal Template Name Field, VAT Entry Table Belgium Local Functionality
VAT Period Field, VAT Entry Table Italy Local Functionality
Blacklist Amount Field, VAT Entry Table Italy Local Functionality
Last Name Field, VAT Entry Table Italy Local Functionality
Enterprise No. Field, VAT Entry Table Belgium Local Functionality
Internal Ref. No. Field, VAT Entry Table General Ledger
Month/Quarter Field, VAT Entry Table Belgium Local Functionality
Currency Code Field, VAT Entry Table New Zealand Local Functionality
Sett. Rem. Unrealized Base Field, VAT Entry Table New Zealand Local Functionality
Date of Birth Field, VAT Entry Table Italy Local Functionality
Resident Field, VAT Entry Table Italy Local Functionality
Operation Occurred Date Field, VAT Entry Table Italy Local Functionality
GST/HST Field, Tax Entry Table United States Local Functionality
VAT Bus. Posting Group Field, VAT Entry Table General Ledger
Add.-Curr. Rem. Unreal. Base Field, VAT Entry Table General Ledger
External Document No. Field, VAT Entry Table General Ledger
Sales Tax Connection No. Field, VAT Entry Table General Ledger
Unrealized Amount Field, VAT Entry Table General Ledger
Sett. Unrealised Base (FCY) Field, VAT Entry Table New Zealand Local Functionality
Individual Person Field, VAT Entry Table Italy Local Functionality
Add. Curr. Nondeductible Base Field, VAT Entry Table Italy Local Functionality
Consol. BAS Doc. No. Field, VAT Entry Table New Zealand Local Functionality
Nondeductible Base Field, VAT Entry Table Italy Local Functionality
Document Date Field, VAT Entry Table General Ledger
Sett. Unrealised Amount (FCY) Field, VAT Entry Table New Zealand Local Functionality
Related Entry No. Field, VAT Entry Table Italy Local Functionality
Generated Autodocument Field, VAT Entry Table Spain Local Functionality
Unrealized VAT Entry No. Field, VAT Entry Table General Ledger
Tax Representative Type Field, VAT Entry Table Italy Local Functionality
Refers To Period Field, VAT Entry Table Italy Local Functionality
Adjustment Field, VAT Entry Table New Zealand Local Functionality
Nondeductible Amount Field, VAT Entry Table Italy Local Functionality
Tax Group Used Field, VAT Entry Table General Ledger
Remaining Unrealized Amount Field, VAT Entry Table General Ledger
Sett. Payment Entry No. Field, VAT Entry Table New Zealand Local Functionality
Consol. Version No. Field, VAT Entry Table New Zealand Local Functionality
Source Code Field, VAT Entry Table General Ledger
No. Series Field, VAT Entry Table General Ledger
Bill-to/Pay-to No. Field, VAT Entry Table General Ledger
Reversed by Entry No. Field, VAT Entry Table General Ledger
Service Tariff No. Field, VAT Entry Table Italy Local Functionality
Sett. Unrealized Amount Field, VAT Entry Table New Zealand Local Functionality
EC % Field, VAT Entry Table Spain Local Functionality
Deductible % Field, VAT Entry Table Italy Local Functionality
VAT % Field, VAT Entry Table Spain Local Functionality
BAS Version Field, VAT Entry Table New Zealand Local Functionality
Delivery Operation Code Field, VAT Entry Table Spain Local Functionality
VAT Calculation Type Field, VAT Entry Table General Ledger
Gen. Bus. Posting Group Field, VAT Entry Table General Ledger
Additional-Currency Amount Field, VAT Entry Table General Ledger
Tax Jurisdiction Code Field, VAT Entry Table General Ledger
VAT Difference Field, VAT Entry Table General Ledger
Entry No. Field, VAT Entry Table General Ledger
Tax on Tax Field, VAT Entry Table General Ledger
Tax Type Field, VAT Entry Table General Ledger
Remaining Unrealized Base Field, VAT Entry Table General Ledger
Add.-Currency Unrealized Amt. Field, VAT Entry Table General Ledger
Add.-Curr. VAT Difference Field, VAT Entry Table General Ledger
Use Tax Field, VAT Entry Table General Ledger
User ID Field, VAT Entry Table General Ledger
Reversed Field, VAT Entry Table General Ledger
VAT Prod. Posting Group Field, VAT Entry Table General Ledger
Document No. Field, VAT Entry Table General Ledger
VAT Registration No. Field, VAT Entry Table General Ledger
Type Field, VAT Entry Table General Ledger
Tax Area Code Field, VAT Entry Table General Ledger
EU Service Field, VAT Entry Table General Ledger
VAT Base Discount % Field, VAT Entry Table General Ledger
VAT Settlement Part Field, VAT Entry Table Russia Local Functionality
For Document Type Field, VAT Entry Table Russia Local Functionality
Initial VAT Transaction No. Field, VAT Entry Table Russia Local Functionality
Adjusted VAT Entry No. Field, VAT Entry Table Russia Local Functionality
Positive Field, VAT Entry Table Russia Local Functionality
CV Ledg. Entry No. Field, VAT Entry Table Russia Local Functionality
VAT Reinstatement Field, VAT Entry Table Russia Local Functionality
VAT Settlement Type Field, VAT Entry Table Russia Local Functionality
VAT Charge Accept. Field, VAT Entry Table Russia Local Functionality
VAT Allocation Type Field, VAT Entry Table Russia Local Functionality
Amt. Diff. VAT Entry No. Field, VAT Entry Table Deleted Topics
For Document No. Field, VAT Entry Table Russia Local Functionality
VAT Agent Field, VAT Entry Table Russia Local Functionality
Object Type Field, VAT Entry Table Russia Local Functionality
Include In Other VAT Ledger Field, VAT Entry Table Russia Local Functionality
Manual VAT Settlement Field, VAT Entry Table Russia Local Functionality
Amount To Allocate Field, VAT Entry Table Russia Local Functionality
Additional VAT Ledger Sheet Field, VAT Entry Table Russia Local Functionality
Adj. Transaction No. Field, VAT Entry Table Deleted Topics
VAT Correction Field, VAT Entry Table Russia Local Functionality
Prepmt. Diff. Field, VAT Entry Table Russia Local Functionality
Correction Field, VAT Entry Table Russia Local Functionality
Tax Invoice Amount Type Field, VAT Entry Table Russia Local Functionality
Corrected Document Date Field, VAT Entry Table Russia Local Functionality
Document Line No. Field, VAT Entry Table Russia Local Functionality
Amt. Diff. VAT Field, VAT Entry Table Deleted Topics
Object No. Field, VAT Entry Table Russia Local Functionality
FA Ledger Entry No. Field, VAT Entry Table Russia Local Functionality
Prepayment Field, VAT Entry Table Russia Local Functionality
Amount Difference in TA Field, VAT Entry Table Deleted Topics
Exchange Rate Adjustment Field, VAT Entry Table Switzerland Local Functionality
Currency Factor Field, VAT Entry Table Switzerland Local Functionality
Unadjusted Exchange Rate Field, VAT Entry Table Switzerland Local Functionality
Currency Code Field, VAT Entry Table Switzerland Local Functionality
Base (FCY) Field, VAT Entry Table Switzerland Local Functionality
Amount (FCY) Field, VAT Entry Table Switzerland Local Functionality
VAT % Field, VAT Entry Table Switzerland Local Functionality
VAT Code Field, VAT Entry Table Norway Local Functionality
Add.-Curr. Inv.tax Base Field, VAT Entry Table Norway Local Functionality
Add.-Curr. Inv.tax Amount Field, VAT Entry Table Norway Local Functionality
VAT Settlement Part Field, VAT Entry Table Russia Local Functionality
For Document Type Field, VAT Entry Table Russia Local Functionality
Initial VAT Transaction No. Field, VAT Entry Table Russia Local Functionality
Adjusted VAT Entry No. Field, VAT Entry Table Russia Local Functionality
Base Amount Type Field, VAT Entry Table Norway Local Functionality
Positive Field, VAT Entry Table Russia Local Functionality
CV Ledg. Entry No. Field, VAT Entry Table Russia Local Functionality
VAT Reinstatement Field, VAT Entry Table Russia Local Functionality
VAT Settlement Type Field, VAT Entry Table Russia Local Functionality
VAT Charge Accept. Field, VAT Entry Table Russia Local Functionality
VAT Allocation Type Field, VAT Entry Table Russia Local Functionality
For Document No. Field, VAT Entry Table Russia Local Functionality
VAT Agent Field, VAT Entry Table Russia Local Functionality
Object Type Field, VAT Entry Table Russia Local Functionality
Include In Other VAT Ledger Field, VAT Entry Table Russia Local Functionality
Manual VAT Settlement Field, VAT Entry Table Russia Local Functionality
Amount To Allocate Field, VAT Entry Table Russia Local Functionality
Additional VAT Ledger Sheet Field, VAT Entry Table Russia Local Functionality
VAT Correction Field, VAT Entry Table Russia Local Functionality
Prepmt. Diff. Field, VAT Entry Table Russia Local Functionality
Correction Field, VAT Entry Table Russia Local Functionality
Tax Invoice Amount Type Field, VAT Entry Table Russia Local Functionality
Corrected Document Date Field, VAT Entry Table Russia Local Functionality
Document Line No. Field, VAT Entry Table Russia Local Functionality
Object No. Field, VAT Entry Table Russia Local Functionality
FA Ledger Entry No. Field, VAT Entry Table Russia Local Functionality
Prepayment Field, VAT Entry Table Russia Local Functionality
Year Field, VAT Entry Table Belgium Local Functionality
Base Before Pmt. Disc. Field, VAT Entry Table Belgium Local Functionality
Journal Template Name Field, VAT Entry Table Belgium Local Functionality
Enterprise No. Field, VAT Entry Table Belgium Local Functionality
Month/Quarter Field, VAT Entry Table Belgium Local Functionality
Closed Field, VAT Entry Table General Ledger
Closed by Entry No. Field, VAT Entry Table General Ledger
Additional-Currency Base Field, VAT Entry Table General Ledger
Tax Liable Field, VAT Entry Table General Ledger
Base Field, VAT Entry Table General Ledger
Reversed Entry No. Field, VAT Entry Table General Ledger
Ship-to/Order Address Code Field, VAT Entry Table General Ledger
Tax Group Code Field, VAT Entry Table General Ledger
Document Type Field, VAT Entry Table General Ledger
EU 3-Party Trade Field, VAT Entry Table General Ledger
Unrealized Base Field, VAT Entry Table General Ledger
Add.-Curr. Rem. Unreal. Amount Field, VAT Entry Table General Ledger
Reason Code Field, VAT Entry Table General Ledger
Gen. Prod. Posting Group Field, VAT Entry Table General Ledger
Add.-Currency Unrealized Base Field, VAT Entry Table General Ledger
Posting Date Field, VAT Entry Table General Ledger
Transaction No. Field, VAT Entry Table General Ledger
Amount Field, VAT Entry Table General Ledger
Country/Region Code Field, VAT Entry Table General Ledger
Internal Ref. No. Field, VAT Entry Table General Ledger
VAT Bus. Posting Group Field, VAT Entry Table General Ledger
Add.-Curr. Rem. Unreal. Base Field, VAT Entry Table General Ledger
External Document No. Field, VAT Entry Table General Ledger
Sales Tax Connection No. Field, VAT Entry Table General Ledger
Unrealized Amount Field, VAT Entry Table General Ledger
Document Date Field, VAT Entry Table General Ledger
Unrealized VAT Entry No. Field, VAT Entry Table General Ledger
Tax Group Used Field, VAT Entry Table General Ledger
Remaining Unrealized Amount Field, VAT Entry Table General Ledger
Source Code Field, VAT Entry Table General Ledger
No. Series Field, VAT Entry Table General Ledger
Bill-to/Pay-to No. Field, VAT Entry Table General Ledger
Reversed by Entry No. Field, VAT Entry Table General Ledger
VAT Calculation Type Field, VAT Entry Table General Ledger
Gen. Bus. Posting Group Field, VAT Entry Table General Ledger
Additional-Currency Amount Field, VAT Entry Table General Ledger
Tax Jurisdiction Code Field, VAT Entry Table General Ledger
VAT Difference Field, VAT Entry Table General Ledger
Closed Field, VAT Entry Table General Ledger
Entry No. Field, VAT Entry Table General Ledger
Tax on Tax Field, VAT Entry Table General Ledger
Tax Type Field, VAT Entry Table General Ledger
Closed by Entry No. Field, VAT Entry Table General Ledger
Remaining Unrealized Base Field, VAT Entry Table General Ledger
Add.-Currency Unrealized Amt. Field, VAT Entry Table General Ledger
Add.-Curr. VAT Difference Field, VAT Entry Table General Ledger
Use Tax Field, VAT Entry Table General Ledger
User ID Field, VAT Entry Table General Ledger
Reversed Field, VAT Entry Table General Ledger
Additional-Currency Base Field, VAT Entry Table General Ledger
VAT Prod. Posting Group Field, VAT Entry Table General Ledger
Document No. Field, VAT Entry Table General Ledger
VAT Registration No. Field, VAT Entry Table General Ledger
Tax Liable Field, VAT Entry Table General Ledger
Type Field, VAT Entry Table General Ledger
Tax Area Code Field, VAT Entry Table General Ledger
EU Service Field, VAT Entry Table General Ledger
Base Field, VAT Entry Table General Ledger
VAT Base Discount % Field, VAT Entry Table General Ledger
G/L Account No. Field, VAT Entry Table Switzerland Local Functionality
STE Transaction ID Field, Tax Entry Table United States Local Functionality
Tax Exemption No. Field, Tax Entry Table United States Local Functionality
BAS Doc. No. Field, VAT Entry Table New Zealand Local Functionality
Settlement Adjustment Field, VAT Entry Table New Zealand Local Functionality
BAS Adjustment Field, VAT Entry Table New Zealand Local Functionality
Sett. Rem. Unrealized Amount Field, VAT Entry Table New Zealand Local Functionality
Sett. Unrealized Base Field, VAT Entry Table New Zealand Local Functionality
First Name Field, VAT Entry Table Italy Local Functionality
Payment Method Field, VAT Entry Table Italy Local Functionality
GST/HST Field, Tax Entry Table United States Local Functionality
VAT Code Field, VAT Entry Table Norway Local Functionality
Add. Curr. Nondeductible Amt. Field, VAT Entry Table Italy Local Functionality
Add.-Curr. Inv.tax Base Field, VAT Entry Table Norway Local Functionality
Currency Code Field, VAT Entry Table New Zealand Local Functionality
Add.-Curr. Inv.tax Amount Field, VAT Entry Table Norway Local Functionality
VAT Settlement Part Field, VAT Entry Table Russia Local Functionality
Sett. Rem. Unrealized Base Field, VAT Entry Table New Zealand Local Functionality
Generated Autodocument Field, VAT Entry Table Spain Local Functionality
Place of Birth Field, VAT Entry Table Italy Local Functionality
Include in VAT Transac. Rep. Field, VAT Entry Table Italy Local Functionality
Blacklisted Field, VAT Entry Table Italy Local Functionality
Transport Method Field, VAT Entry Table Italy Local Functionality
EC % Field, VAT Entry Table Spain Local Functionality
Contract No. Field, VAT Entry Table Italy Local Functionality
For Document Type Field, VAT Entry Table Russia Local Functionality
Initial VAT Transaction No. Field, VAT Entry Table Russia Local Functionality
VAT % Field, VAT Entry Table Spain Local Functionality
Adjusted VAT Entry No. Field, VAT Entry Table Russia Local Functionality
Sett. Unrealised Base (FCY) Field, VAT Entry Table New Zealand Local Functionality
Plafond Entry Field, VAT Entry Table Italy Local Functionality
Reverse Sales VAT Field, VAT Entry Table Italy Local Functionality
Consol. BAS Doc. No. Field, VAT Entry Table New Zealand Local Functionality
Activity Code Field, VAT Entry Table Italy Local Functionality
Fiscal Code Field, VAT Entry Table Italy Local Functionality
Delivery Operation Code Field, VAT Entry Table Spain Local Functionality
Positive Field, VAT Entry Table Russia Local Functionality
Sett. Unrealised Amount (FCY) Field, VAT Entry Table New Zealand Local Functionality
Adjustment Field, VAT Entry Table New Zealand Local Functionality
CV Ledg. Entry No. Field, VAT Entry Table Russia Local Functionality
VAT Identifier Field, VAT Entry Table Italy Local Functionality
Base Amount Type Field, VAT Entry Table Norway Local Functionality
VAT % Field, VAT Entry Table Italy Local Functionality
Sett. Payment Entry No. Field, VAT Entry Table New Zealand Local Functionality
Consol. Version No. Field, VAT Entry Table New Zealand Local Functionality
VAT Reinstatement Field, VAT Entry Table Russia Local Functionality
Sett. Unrealized Amount Field, VAT Entry Table New Zealand Local Functionality
Tax Representative No. Field, VAT Entry Table Italy Local Functionality
VAT Period Field, VAT Entry Table Italy Local Functionality
BAS Version Field, VAT Entry Table New Zealand Local Functionality
Blacklist Amount Field, VAT Entry Table Italy Local Functionality
Last Name Field, VAT Entry Table Italy Local Functionality
Date of Birth Field, VAT Entry Table Italy Local Functionality
Resident Field, VAT Entry Table Italy Local Functionality
Operation Occurred Date Field, VAT Entry Table Italy Local Functionality
VAT Settlement Type Field, VAT Entry Table Russia Local Functionality
VAT Charge Accept. Field, VAT Entry Table Russia Local Functionality
VAT Allocation Type Field, VAT Entry Table Russia Local Functionality
Individual Person Field, VAT Entry Table Italy Local Functionality
Add. Curr. Nondeductible Base Field, VAT Entry Table Italy Local Functionality
Nondeductible Base Field, VAT Entry Table Italy Local Functionality
Related Entry No. Field, VAT Entry Table Italy Local Functionality
Tax Representative Type Field, VAT Entry Table Italy Local Functionality
Refers To Period Field, VAT Entry Table Italy Local Functionality
Nondeductible Amount Field, VAT Entry Table Italy Local Functionality
Service Tariff No. Field, VAT Entry Table Italy Local Functionality
Deductible % Field, VAT Entry Table Italy Local Functionality
For Document No. Field, VAT Entry Table Russia Local Functionality
VAT Agent Field, VAT Entry Table Russia Local Functionality
Object Type Field, VAT Entry Table Russia Local Functionality
Include In Other VAT Ledger Field, VAT Entry Table Russia Local Functionality
Manual VAT Settlement Field, VAT Entry Table Russia Local Functionality
Amount To Allocate Field, VAT Entry Table Russia Local Functionality
Additional VAT Ledger Sheet Field, VAT Entry Table Russia Local Functionality
VAT Correction Field, VAT Entry Table Russia Local Functionality
Prepmt. Diff. Field, VAT Entry Table Russia Local Functionality
Correction Field, VAT Entry Table Russia Local Functionality
Tax Invoice Amount Type Field, VAT Entry Table Russia Local Functionality
Corrected Document Date Field, VAT Entry Table Russia Local Functionality
Document Line No. Field, VAT Entry Table Russia Local Functionality
Object No. Field, VAT Entry Table Russia Local Functionality
FA Ledger Entry No. Field, VAT Entry Table Russia Local Functionality
Prepayment Field, VAT Entry Table Russia Local Functionality
Exchange Rate Adjustment Field, VAT Entry Table Switzerland Local Functionality
Currency Factor Field, VAT Entry Table Switzerland Local Functionality
Unadjusted Exchange Rate Field, VAT Entry Table Switzerland Local Functionality
Currency Code Field, VAT Entry Table Switzerland Local Functionality
Base (FCY) Field, VAT Entry Table Switzerland Local Functionality
Amount (FCY) Field, VAT Entry Table Switzerland Local Functionality
VAT % Field, VAT Entry Table Switzerland Local Functionality

See Also

Other Resources

Calc. and Post VAT Settlement
How to: View VAT Entries
How to: Record VAT