New Requirements in Movement Stats - Germany Related Intrastat (Doc ID 3001624.1)

Last updated on JANUARY 31, 2024

Applies to:

Goal

Due to new government reporting regulations from EU member Germany, there are required modifications to the MOVEMENT STATISTICS INTRASTAT report. The new requirements from the German government are found in document with title is "INTRA-COMMUNITY TRADE STATISTICS GENERAL GUIDE". The attachment is provided for viewing. Here are the new requirements:

1. Report values required "rounding" to whole number with no fraction on these report attributes > "WEIGHT", "STATISTICAL VALUE", "TRANSACTION VALUE"(the report does already have "rounding" in effect for the report column WEIGHT. The new regulations are request for the same "rounding" to report columns  STATISTICAL vale, TRANSACTION VALUE.)

2. The new regulation is request for report column "Country of Dest/Dispatch" to be  two-letter code only. Current report values are examples "003-NL", "061-CZ", "001-FR". The new requirement is for 2 letter only as "NL", "CZ", "FR".

3. Report column "ORIGIN" to now detail the German region. Germany now appears as "004-DE". New requirement is to display Germany in one of the 16 "federal states" as shown in document page 44 Annex 1 country nomenclature for external trade statistics.

Examples are  02-Hamburg, 04=Bremen.

Solution provides answers to several questions regarding New Requirements in Movement Stats - Germany Related Intrastat

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.