Intrastat is the system for collecting statistics on the trade of goods between members of the European Union. Intrastat requires the reporting of movement statistics within a country. Extrastat is the collection of statistics on the trade of goods between members and nonmembers of the European Union. Statistics are reported to the material tax authorities of the respective countries.

Oracle e-Commerce Gateway supports these requirements by providing Intrastat and Extrastat messages for the automatic extraction and electronic processing of movement statistics.

Subsets of the EDIFACT Customs Declaration (CUSDEC) message are used to report material movement statistics. The CUSDEC subset INSTAT reports movement statistics within the European Union. The CUSDEC subset EXSTAT reports movement statistics outside the European Union.

As data is extracted from e-Commerce Gateway, only movement statistics with the status of Verify or Frozen are extracted. Once data is extracted, the e-Commerce Gateway sets the transaction status to EDI.

For more information on Intrastat, see:

• Movement Statistics, Oracle Purchasing User's Guide

• Defining Economic Zones and Defining Movement Statistic Parameters, Oracle Inventory User's Guide.

Prerequisites

• Create the outbound directory and update the INIT.ORA file. See: Defining Data File Directories, Oracle e-Commerce Gateway Implementation Manual.

• Define the ECE: Outbound file path profile option. See: e-Commerce Gateway Profile Options, Oracle e-Commerce Gateway Implementation Manual.

• Define trading partner relationships and enable EDI transactions for the trading partner. See: Defining Trading Partner Data.

• Define code conversions. See: Defining Code Conversion Categories, Assigning Categories, and Defining Code Conversion Values.

• Customize interface data file layout, if necessary. See: Changing the Interface Data File Record Layout.

To run the INTRASTAT movement statistics (MVSTO) extract program:

1. Navigate to the Run e-Commerce Outbound Process window:

   • Process > Extract Program

   • In the Submit a New Request window, select Single Request to submit an individual request.

2. In the Name field of the Run e-Commerce Outbound Process window, select OUT: Movement Statistics (for INTRASTAT) from the LOV.

3. Select an operating unit from the LOV so that the concurrent program will extract data for the particular operating unit. If you have more than one operating unit linked to your responsibility, then you must specify each operating unit individually for the program in order to extract data for all the operating units.

4. The Parameters window will open. Enter the following parameters as necessary:

   • Output File Path: (Required) Specify and output file path or accept the default.

   • Output File Name: (Required) Enter an output file name or accept the default.

   • Legal Entity: (Required) The legal entity entered must match the setup for movement statistics parameters.

   • Zone Code: (Required) The zone code entered must match the economic zone associated with the legal entity in the movement statistics setup.

   • Stat Type: (Required) Enter INTRASTAT or EXTRASTAT.

   • Period Name: The period name must match the period associated with the legal entity in the movement statistics setup.

   • Movement Type: (Required) Enter the movement type: Arrival, Arrival Adjustment, Dispatch, or Dispatch Adjustment.

   • Include Address: (Required) Indicate whether to include the address in the transaction document.

   • Debug Mode for MVSTO: Set the debug mode to report on debug information. Debug information is written to the concurrent manager log file:

     OFF: No debug information is generated.

     LOW: Summary debug information is written to the concurrent manager log file.

     MEDIUM: Medium level debug information is written to the concurrent manager log file.

     HIGH: High level debug information is written to the concurrent manager log file. (This option generates much information.)

5. Enter any Schedule or Completion options for the request..

6. Choose Submit and make a note of the Request ID.