Intrastat Jnl. Line Table

  • Article

Specifies details about Intrastat reporting. All EU businesses must report their trade with other EU countries/regions.

You can either enter the entries in the window yourself, or you can have the program import them automatically by clicking Actions, Get Entries in the intrastat journal window. When you do this, the program imports only entries from the Item Ledger Entry table. If you have some G/L entries that should be included in the Intrastat report (for example purchase of office equipment for your own use from another EU country/region), you must enter these entries yourself.

In order for item entries to contain the necessary information when the program imports them to the intrastat journal line, you must have entered that information in the following tables:

  • Country/Region

  • Tariff Number

  • Transport Method

  • Transaction Type

Note

You must fill in these tables before you begin to post.

Before you can use the Intrastat Journal window, you must decide which intrastat journal templates and batches you will use. You do this in the Intrastat Jnl. Template and Intrastat Jnl. Batch windows.

In the Intrastat Journal Templates, you can create several templates if you need several different forms. Because Intrastat is reported monthly, you must create 12 intrastat journals based on the same template. You set up the names of these 12 journals in the Intrastat Jnl. Batches window.

The Intrastat information is entered in the Intrastat Journal window. When you have retrieved the information to the intrastat journal lines, you can print a report or a file to the tax and customs authorities.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
VAT Registration No. Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Service Tariff No. Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Shipment Method Code #1 Field, Intrastat Jnl. Line Table Spain Local Functionality
Statistics Period Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Corrected Intrastat Report No. Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Shipment Method Code Field, Intrastat Jnl. Line Table United Kingdom Local Functionality
Cust. VAT Registration No. Field, Intrastat Jnl. Line Table France Local Functionality
Source Currency Amount Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Shipment Method Code Field, Intrastat Jnl. Line Table France Local Functionality
Group Code Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Currency Code Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Statistical System Field, Intrastat Jnl. Line Table Spain Local Functionality
Custom Office No. Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Payment Method Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Place of Receipt Field, Intrastat Jnl. Line Table Spain Local Functionality
Shipment Method Code #2 Field, Intrastat Jnl. Line Table Spain Local Functionality
Corrective entry Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Reference Period Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Country/Region of Payment Code Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Corrected Document No. Field, Intrastat Jnl. Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Unit of Measure Field, Intrastat Jnl. Line Table Belgium Local Functionality
Quantity 2 Field, Intrastat Jnl. Line Table Finland Local Functionality
No. of Supplementary Units Field, Intrastat Jnl. Line Table Belgium Local Functionality
Unit of Measure Field, Intrastat Jnl. Line Table Finland Local Functionality
Conversion Factor Field, Intrastat Jnl. Line Table Belgium Local Functionality
Quantity Field, Intrastat Jnl. Line Table General Ledger
Type Field, Intrastat Jnl. Line Table General Ledger
Internal Ref. No. Field, Intrastat Jnl. Line Table General Ledger
Country/Region of Origin Code Field, Intrastat Jnl. Line Table General Ledger
Source Entry No. Field, Intrastat Jnl. Line Table General Ledger
Document No. Field, Intrastat Jnl. Line Table General Ledger
Transaction Specification Field, Intrastat Jnl. Line Table General Ledger
Supplementary Units Field, Intrastat Jnl. Line Table General Ledger
Date Field, Intrastat Jnl. Line Table General Ledger
Item Description Field, Intrastat Jnl. Line Table General Ledger
Cost Regulation % Field, Intrastat Jnl. Line Table General Ledger
Statistical Value Field, Intrastat Jnl. Line Table General Ledger
Transport Method Field, Intrastat Jnl. Line Table General Ledger
Corrective entry Field, Intrastat Jnl. Line Table Italy Local Functionality
Item No. Field, Intrastat Jnl. Line Table General Ledger
Tariff No. Field, Intrastat Jnl. Line Table General Ledger
Entry/Exit Point Field, Intrastat Jnl. Line Table General Ledger
Country/Region Code Field, Intrastat Jnl. Line Table General Ledger
Transaction Type Field, Intrastat Jnl. Line Table General Ledger
Total Weight Field, Intrastat Jnl. Line Table General Ledger
Net Weight Field, Intrastat Jnl. Line Table General Ledger
Area Field, Intrastat Jnl. Line Table General Ledger
Journal Batch Name Field, Intrastat Jnl. Line Table General Ledger
Line No. Field, Intrastat Jnl. Line Table General Ledger
Name Field, Intrastat Jnl. Line Table General Ledger
Amount Field, Intrastat Jnl. Line Table General Ledger
Indirect Cost Field, Intrastat Jnl. Line Table General Ledger
Source Type Field, Intrastat Jnl. Line Table General Ledger
Journal Template Name Field, Intrastat Jnl. Line Table General Ledger
Quantity Field, Intrastat Jnl. Line Table General Ledger
Type Field, Intrastat Jnl. Line Table General Ledger
Internal Ref. No. Field, Intrastat Jnl. Line Table General Ledger
Country/Region of Origin Code Field, Intrastat Jnl. Line Table General Ledger
Source Entry No. Field, Intrastat Jnl. Line Table General Ledger
Document No. Field, Intrastat Jnl. Line Table General Ledger
Transaction Specification Field, Intrastat Jnl. Line Table General Ledger
Supplementary Units Field, Intrastat Jnl. Line Table General Ledger
Date Field, Intrastat Jnl. Line Table General Ledger
Item Description Field, Intrastat Jnl. Line Table General Ledger
Cost Regulation % Field, Intrastat Jnl. Line Table General Ledger
Statistical Value Field, Intrastat Jnl. Line Table General Ledger
Transport Method Field, Intrastat Jnl. Line Table General Ledger
Item No. Field, Intrastat Jnl. Line Table General Ledger
Tariff No. Field, Intrastat Jnl. Line Table General Ledger
Entry/Exit Point Field, Intrastat Jnl. Line Table General Ledger
Country/Region Code Field, Intrastat Jnl. Line Table General Ledger
Transaction Type Field, Intrastat Jnl. Line Table General Ledger
Total Weight Field, Intrastat Jnl. Line Table General Ledger
Net Weight Field, Intrastat Jnl. Line Table General Ledger
Area Field, Intrastat Jnl. Line Table General Ledger
Journal Batch Name Field, Intrastat Jnl. Line Table General Ledger
Line No. Field, Intrastat Jnl. Line Table General Ledger
Name Field, Intrastat Jnl. Line Table General Ledger
Amount Field, Intrastat Jnl. Line Table General Ledger
Indirect Cost Field, Intrastat Jnl. Line Table General Ledger
Source Type Field, Intrastat Jnl. Line Table General Ledger
Journal Template Name Field, Intrastat Jnl. Line Table General Ledger
Quantity Field, Intrastat Jnl. Line Table General Ledger
Type Field, Intrastat Jnl. Line Table General Ledger
Internal Ref. No. Field, Intrastat Jnl. Line Table General Ledger
Country/Region of Origin Code Field, Intrastat Jnl. Line Table General Ledger
Source Entry No. Field, Intrastat Jnl. Line Table General Ledger
Document No. Field, Intrastat Jnl. Line Table General Ledger
Transaction Specification Field, Intrastat Jnl. Line Table General Ledger
Supplementary Units Field, Intrastat Jnl. Line Table General Ledger
Date Field, Intrastat Jnl. Line Table General Ledger
Item Description Field, Intrastat Jnl. Line Table General Ledger
Cost Regulation % Field, Intrastat Jnl. Line Table General Ledger
Statistical Value Field, Intrastat Jnl. Line Table General Ledger
Transport Method Field, Intrastat Jnl. Line Table General Ledger
Item No. Field, Intrastat Jnl. Line Table General Ledger
Tariff No. Field, Intrastat Jnl. Line Table General Ledger
Entry/Exit Point Field, Intrastat Jnl. Line Table General Ledger
Country/Region Code Field, Intrastat Jnl. Line Table General Ledger
Transaction Type Field, Intrastat Jnl. Line Table General Ledger
Total Weight Field, Intrastat Jnl. Line Table General Ledger
Net Weight Field, Intrastat Jnl. Line Table General Ledger
Area Field, Intrastat Jnl. Line Table General Ledger
Journal Batch Name Field, Intrastat Jnl. Line Table General Ledger
Line No. Field, Intrastat Jnl. Line Table General Ledger
Name Field, Intrastat Jnl. Line Table General Ledger
Amount Field, Intrastat Jnl. Line Table General Ledger
Indirect Cost Field, Intrastat Jnl. Line Table General Ledger
Source Type Field, Intrastat Jnl. Line Table General Ledger
Journal Template Name Field, Intrastat Jnl. Line Table General Ledger
Corrective entry Field, Intrastat Jnl. Line Table Italy Local Functionality
Quantity Field, Intrastat Jnl. Line Table General Ledger
Type Field, Intrastat Jnl. Line Table General Ledger
Internal Ref. No. Field, Intrastat Jnl. Line Table General Ledger
Country/Region of Origin Code Field, Intrastat Jnl. Line Table General Ledger
Source Entry No. Field, Intrastat Jnl. Line Table General Ledger
Document No. Field, Intrastat Jnl. Line Table General Ledger
Transaction Specification Field, Intrastat Jnl. Line Table General Ledger
Supplementary Units Field, Intrastat Jnl. Line Table General Ledger
Date Field, Intrastat Jnl. Line Table General Ledger
Item Description Field, Intrastat Jnl. Line Table General Ledger
Cost Regulation % Field, Intrastat Jnl. Line Table General Ledger
Statistical Value Field, Intrastat Jnl. Line Table General Ledger
Transport Method Field, Intrastat Jnl. Line Table General Ledger
Item No. Field, Intrastat Jnl. Line Table General Ledger
Tariff No. Field, Intrastat Jnl. Line Table General Ledger
Entry/Exit Point Field, Intrastat Jnl. Line Table General Ledger
Country/Region Code Field, Intrastat Jnl. Line Table General Ledger
Transaction Type Field, Intrastat Jnl. Line Table General Ledger
Total Weight Field, Intrastat Jnl. Line Table General Ledger
Net Weight Field, Intrastat Jnl. Line Table General Ledger
Area Field, Intrastat Jnl. Line Table General Ledger
Journal Batch Name Field, Intrastat Jnl. Line Table General Ledger
Line No. Field, Intrastat Jnl. Line Table General Ledger
Name Field, Intrastat Jnl. Line Table General Ledger
Amount Field, Intrastat Jnl. Line Table General Ledger
Indirect Cost Field, Intrastat Jnl. Line Table General Ledger
Source Type Field, Intrastat Jnl. Line Table General Ledger
Journal Template Name Field, Intrastat Jnl. Line Table General Ledger
Corrective entry Field, Intrastat Jnl. Line Table Italy Local Functionality

See Also

Reference

Country/Region
Tariff Number
Transport Method
Intrastat Jnl. Template
Transaction Type
Intrastat Jnl. Batch

Other Resources

Item Ledger Entry
Intrastat - Form
How to: Report Intrastat on Diskettes