Understanding the Purge Process

The Intrastat Revision table (F0018T) is a temporary workfile that stores information that is used to generate monthly or quarterly Intrastat declarations. After the declarations have been accepted by the tax authority, the data in this file continues to accumulate. You do not need to store this data.

You can purge records from table F0018T. You can use data selection to purge all of the records in the file or purge only selected records. You can specify selection criteria based on the invoice date, general ledger date, procurement date, or shipment date. For example, you might purge records with shipment dates between March 1, 2005 and May 1, 2005.

You can run Intrastat Workfile Purge (R0018TP) in proof mode or final mode. Run the program in proof mode to review which records will be deleted. No records are deleted until you run the report in final mode.