Using the IDEP

You can report on the physical movement of goods by interfacing with IDEP. This software package produces an electronic Intrastat declaration of goods. Created by Eurostat (statistical office of the European Commission), IDEP makes it possible to electronically create trading transaction report lines for dispatch or arrival flows during a specific time period.

By using PeopleTools, you generate a flat file to import transactional data into IDEP and send it as an attached email file or by electronic transmission to the customs authority. Before generating the file, use the Intrastat Reporting Details page in the VAT Entity component to assign the following values:

• Process Type: Application Engine

• Process Name: IDEP_INT

• File Layout ID: IDEP

Then, run the Intrastat Report Extract process with the required parameters, use the Application Engine to generate the flat file, and import the file into the IDEP Software.

You have to provide the EC commodity code in the flat file, not an internal item ID. The system creates the name of the IDEP file by using the following convention: IDEP_ReportDate_ProcessInstance_Flow.csv. An example of a name might be IDEP_2002-01-17_109_A.CSV.

Use the following steps to create and use IDEP files:

1. Load Intrastat information into the Intrastat table by using the Intrastat Transaction Loader, or maintain or adjust Intrastat transactions manually by using the Intrastat Transaction Entry pages.

2. Extract Intrastat transactions into reporting tables by using the Intrastat Report Extract page.

3. Generate a text file (type.CSV) by using the Intrastat Reports page. On the Process Scheduler Request page, run the IDEP Intrastat Flat File application engine process (IDEP_INT).

4. Set up customer header information such as VAT registration address, contact person, and obligation level by using the IDEP software package.

5. Set up two import file formats in IDEP for CSV text file (dispatch and arrival flow) with the following specifications:

   • The EC Commodity Code/Item Reference is equal to NC8.

   • Separator equal to ',' (default).

   • Define an ANSI character set, depending on the system.

   • Ignore a column header that is equal to Yes.

   • Use the field order as mapped in the New Order column in the following table.

6. Import the Interface text file into the IDEP software.

The following example shows how you generate a text file (type.CSV) by selecting the IDEP Intrastat Flat File application engine process (IDEP_INT) on the Process Scheduler Request page.

This example illustrates the fields and controls on the Example of Process Scheduler request showing IDEP Intrastat Flat File selected. You can find definitions for the fields and controls later on this page.

The following table defines the IDEP file for import and its mapping to PeopleSoft fields: