Intrastat Transactions (tccom7171m000)

Use this session to view the transaction data that has been logged for the Intrastat declaration and to make any corrections that are necessary. You can only correct data that is not yet processed.

The department type and code of the department for which the report is generated are displayed in the Declarant section.

All the invoice values are expressed in the transaction currencies. When you export the data, LN converts the amounts to the local currency, using the currency rate that is effective on the transaction date.

  • To enter transactions that are not registered in LN, click the New button. LN creates a new record and sets the order origin to Manual Transaction.
  • To make corrections, select a line and click the Duplicate button. LN creates a new record with the copied data and sets the order origin to Manual Correction. To correct the reported data, you can enter a transaction with values that correct the copied transaction.
Note: 
  • The Intrastat data must reflect the actual transaction data as it is recorded in Financials. If you want to change the data related to the quantity and the invoice value, such as the Invoice Value Transaction Currency and the Exchange Rate Type, the order origin must be Manual Transaction or Manual Correction. For other order origins, you can only change the fields that are related to logistic data.
  • You cannot change the fields values of the extra Intrastat info fields linked to a transaction. If other values are required, you must link a different extra Intrastat info set to the transaction.

Field Information

General
Declarant
Entity Type

The key entity type of the department for which the report is generated.

Office

The department code of the department for which the report is generated.

Enterprise Unit

enterprise unit.

Financial Company

The financial company that submits the Intrastat declaration.

The department's enterprise unit is linked to this financial company.

Local Currency

The financial company's local currency, which is used for the Intrastat declaration.

VAT Number

The tax ID of the department that submits the Intrastat declaration.

The department's tax ID is the same as the financial company's tax ID.

This field is not displayed if the Registration by Tax Country parameter is set to Active in the Global Registration Parameters (tctax2100m000) session. Instead, the department's tax ID, which can be different from the financial company's tax ID, is displayed in the Own Identification Number field in the lines section of the current session.

Country

The country of the department in which you submit the Intrastat declaration.

This is the same country as the financial company's country.

This field is not displayed if the Registration by Tax Country parameter is set to Active in the Global Registration Parameters (tctax2100m000) session. Instead, the country in which the Intrastat declaration is submitted, which can be different from the financial company's country, is displayed in the Declaration Country field in the lines section of the current session.

General
Order Origin

The order line type, indicating the order's origin.

If the order origin is Manual Transaction or Manual Correction, you can change the fields that are related to the quantity and the invoice value, such as the Invoice Value Transaction Currency and the Exchange Rate Type. For other order origins, you can only change the fields that are related to logistic data.

If you use Find a record to search for Intrastat declaration data, you can select all the available order types.

Order

The purchase order or sales order that results in the import or export of the item.

Position

the position number of the order line.

Sequence No.

The sequence number of the order line.

Flow

Indicates whether the item was imported or exported.

Reporting Status
Awaiting Final Shipment
Not Applicable
Blocked for Reporting
Ready for Reporting
Processed

Item (PSI)

The standard-item code of the order line. LN records import/export data of customized items under the item from which the customized item is derived.

If you selected either the value Always or the value If HS Code Filled in the Method of Logging Cost/Service Items field of the Intrastat Parameters (tccom7100s000) session, the item can also be:

Transaction Date

The warehouse order date.

Harmonized System Code

The item's commodity code that you assigned to the item in the Item Base Data module.

Reference

The warehouse order reference.

Quantity

The goods quantity on the order, expressed in the inventory unit.

Unit

inventory unit

Supplementary Unit Quantity

The goods quantity on the order, expressed in the supplementary unit.

If no supplementary unit is required, this field is zero.

Unit

supplementary unit

Weight

The weight of the goods. LN multiplies the quantity expressed in the inventory unit by the weight defined for the item in the Item Base Data module to calculate the weight.

Weight Unit

The item's base weight unit.

Declaration Country

The country in which the Intrastat declaration is submitted.

This field is not displayed if the Registration by Tax Country parameter is set to Inactive or In Preparation in the Global Registration Parameters (tctax2100m000) session. Instead, the country in which the Intrastat declaration is submitted is displayed in the Country field in the header section of the current session.

Own Identification Number

The own identification number associated with the intrastat transaction.

Note: 

This field is enabled only if the Extended Registration Management field is other than Active in the Global Registration Parameters (tctax2100m000) session.

This field is enabled only if the Declaration Country is specified.

Own Identification Number

The tax number of the entity for which the tax declaration is submitted.

Note: This field is enabled only if the Extended Registration Management field is other than Active in the Global Registration Parameters (tctax2100m000) session and the Order Origin is other than Manual.
Business Partner

The business partner that represents the non-declaring party of the current Intrastat transaction.

For import Intrastat transactions, that is, transactions for which the delivery method is Receipt, the non-declaring party is the buy-from business partner or the internal business partner representing the issuing warehouse, work center, or project.

For export Intrastat transactions, that is, transactions for which the delivery method is Shipment, the non-declaring party is the sold-to business partner or the internal business partner representing the receiving warehouse, work center, or project.

Vat Number

The VAT number of the entity for which the Intrastat declaration is submitted.

This field is not displayed if the Registration by Tax Country parameter is set to Inactive or In Preparation in the Global Registration Parameters (tctax2100m000) session. Instead, the VAT number is displayed in the VAT Number field in the header section of the current session.

Goods Flow
Goods Flow
Delivery Method

Indicates whether the transaction concerns a warehouse delivery or a warehouse receipt.

If no warehouse order exists, select Not Applicable.

Delivery Order

The order number of the warehouse delivery or the warehouse receipt.

Delivery Order Line

The delivery order sequence number.

Delivery Terms

The delivery terms of the order.

Point of Title Passage

The point of title passage defined for the delivery terms.

Carrier/LSP

The carrier who transports the goods.

Mode of Transport

The type of transport used.

Allowed values

Transport by Sea
Not Applicable
Transport by Sea (Container)
Transport by Rail
Transport by Rail (Container)
Transport by Road
Transport by Road (Container)
Transport by Air
Transport by Air (Charter)
Consignments by Post
Contract Carrier
Transport by Customer Pickup
Less than Truck Load
Mail
Intermodal
Consolidation
Fixed Transport Installations
Transport by Inland Waterway
Express Air
Express Truck
Express Rail
Own Propulsion
Pool Point
Milk Run
Piggy Back
Note: LN defaults the value specified in the Pick-up Means of Transport field in the Loads (whinh4140m000) session. If not defined, LN defaults the value specified in the Delivery Means of Transport in the same session.
Ship-from Address

The address from which the goods were shipped.

Ship-to Address

The address to which the goods were shipped.

Partner Country

The country of issue (for import) or the destination country (for export).

Home State/Province

The state/province to which the goods are exported or from where the goods are imported.

Home Area

The area to which the goods are exported or from where the goods are imported.

Country of Origin

The item's country of origin, as you have defined it in the Item Base Data module.

Financial Data Internal
Amounts and Internal Exchange Rates
Business Partner Identification Number

The business partner's tax ID.

Invoice-from Address

The address from which the invoice is sent.

This is the address of the invoice-from business partner, or your own company's address.

Invoice-to Address

The address to which the invoice is sent.

This is the address of the invoice-to business partner, or your own company's address.

Transaction Currency

The transaction currency.

Exchange Rate Type

The exchange rate type that applies to the order.

If the value of the Order Origin field is Manual Transaction or Manual Correction, you can enter an exchange rate type. Otherwise LN uses the exchange rate type specified in the Internal field in the Companies (tcemm1170m000) session.

Exchange Rate

LN uses this currency exchange rate to convert the amount in the transaction currency to the reference currency.

If you have not defined an internal exchange rate for the company and you do not enter an exchange rate here, LN sets this field to one (1).

per

The rate factor of the exchange rate.

Declaration Expres in Base Currency

If this check box is selected, LN uses the currency exchange rate to convert the base currency into the foreign currencies.

If this check box is cleared, LN uses the currency exchange rate to convert the foreign currencies into the base currency.

Invoice Value Transaction Currency

The value of the goods, in the transaction currency, at the moment when they cross the border.

This must be the net invoice amount, which includes the transportation cost to the border. As LN cannot calculate the transportation costs to the border, by default this field contains the net goods value on the order, expressed in the transaction currency.

Invoice Value

The invoice value in the local currency of the current company (usually in euros). LN uses the currency rate that is effective on the transaction date.

Statistical Value Transaction Amount

The statistical value of the goods, in the transaction currency, at the moment when they cross the border.

Because LN cannot calculate the statistical value of the goods, by default this field contains the invoice amount.

Statistical Value

The statistical value in the local currency of the current company (usually in euros). LN uses the currency rate that is effective on the transaction date.

Valuation Price

The valuation price entered by LN in case of staggered consignments.

Currency

The currency in which the valuation price is expressed. LN uses the currency rate that is effective on the transaction date.

Financial Data External
Amounts and Declaration Exchange Rates
Declaration Exchange Rate Type

The exchange rate type used for the report.

If you selected the Recalculate Amounts with Declarant Exchange Rates check box in the Process Intrastat Transactions (tccom7271m000) session, LN displays the exchange rate type that you selected in the Process Intrastat Transactions (tccom7271m000) session.

Declaration Exchange Rate

The exchange rate used for the report.

Declaration Invoice Value

The value of the goods, in the transaction currency, at the moment when they cross the border.

This must be the net invoice amount, which includes the transportation cost to the border. Because LN cannot calculate the transportation costs to the border, by default this field contains the net goods value on the order, expressed in the transaction currency.

Declaration Statistical Value

The statistical value of the goods, in the transaction currency, at the moment when they cross the border.

Because LN cannot calculate the statistical value of the goods, by default this field contains the invoice amount.

Declaration Currency

The currency in which intrastat reporting is processed.

Note: 
  • LN follows this search sequence to default the value:
    • The tax currency specified in the Tax Parameters by Country (tctax0101m000) session, or
    • The tax currency specified in the Tax Parameters (tctax0100m000) session, or
    • The local currency of the financial company.
  • If this field is applicable, specifying a value is mandatory.
  • This field can be empty for historical data. If empty, the local currency of the financial company must be used during processing / printing of reports.
Declaration Exchange Rate Type

The exchange-rate type used for tax declaration reporting.

Note: 
  • When the tax currency is same as the home currency and the delivery is invoiced, this field must be updated with the tax currency rate type used in the invoice. However, only the Exchange Rate Type for which the Used for Tax Reporting check box is cleared in the Exchange Rate Types (tcmcs0140m000) session, are allowed.
  • When the tax currency is not same as the home currency and the delivery or receipt is invoiced, this field must be updated with the tax currency rate type used in the invoice. However, only the Exchange Rate Type for which the Used for Tax Reporting check box is selected in the Exchange Rate Types (tcmcs0140m000) session, is allowed.
  • When declaration currency is same as home currency, LN defaults the value in this sequence:
    • the External rate type, or
    • the internal rate type, or
    • The exchange rate type of the transaction.
  • When declaration currency is not same as home currency, LN defaults the value in this sequence:
    • The exchange rate type specified in the Tax Parameters by Country (tctax0101m000) session, or
    • The exchange rate type specified in the Tax Parameters (tctax0100m000) session, or
    • The exchange rate type of the transaction.
  • This field is mandatory if the Registration by Tax Country is set to Active in the Global Registration Parameters (tctax2100m000) session.

The description or name of the code.

Declaration Exchange Rate

The currency exchange rate determined based on the declaration exchange rate type and transaction date.

Note: 
  • You must specify this value if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
  • When a delivery or a receipt is invoiced this field is updated with the tax currency rate used in the invoice.
per

The rate factor of the declaration exchange rate.

Declaration Expressed in Base Currency

Indicates if the declaration are expressed in the base currency. This is determined based on the declaration exchange rate type and transaction date.

Note: 
  • This field is mandatory if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
  • When a delivery or a receipt is invoiced, this field is updated with the tax currency express in base value, that is used in the invoice.
Declaration Invoice Value

This is the invoice value in the declaration currency which has been converted from the transaction currency, based on the declaration rate.

Note: 
  • This value must be specified if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
  • When a delivery or a receipt is invoiced, this value is recalculated based on the rate specified in the invoice.

The code of the local currency.

Declaration Statistical Value

The is the statistical value in the declaration currency which has been converted from the declaration currency, based on the declaration rate.

Note: 
  • This value must be specified if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
  • When a delivery or a receipt is invoiced, this value is recalculated based on the rate specified in the invoice.

The description or name of the code.

Extra Intrastat Info
Operational Company

The logistic company in which the order originated.

Extra Intrastat Info

The extra Intrastat info set linked to the order.

Field Name

The field name according to the rules for Intrastat declarations.

Field Value

The value of the field.

A value cannot exceed the length defined for the field in the Extra Intrastat Info Definition (tccom7104m000) session. The actual value and the type of value (numeric or alphanumeric) is determined by the rules for Intrastat declarations and the type of business.

If you generate the import/export statistics for sales orders and purchase orders or projects to which you have linked this extra Intrastat info, the values of these fields are included in the statistical report data.

Field Value Description

The description of the field according to the rules for Intrastat declarations.