1. Localizations for European Reporting and SEPA Processing Implementation Guide
  2. Transaction Eligibility

Transaction Eligibility

Sales order transactions are not eligible for Intrastat reporting if either the Sold To country or the Ship To country is the same as the Declarant country, or if any of these countries (Sold To, Ship To, or Declarant) is not in the European Union.

Procurement transactions are not eligible for Intrastat reporting if either the Supplier country or the Ship From country is the same as the Declarant country, or if any of these countries (Supplier, Ship From, or Declarant) is not in the European Union.

The system retrieves the Ship To country from the Order Address Information table (F4006) if a record exists. Otherwise, the system retrieves the Ship To country from the Sales Order Detail File table (F4211).

The system retrieves the Ship From country by searching these tables in sequence:

  1. Country (CTR) in the Address by Date table (F0116), using the supplier's address book record

  2. Country (CTR) in the Order Address Information table (F4006)

  3. Country of Origin (ORIG) in the Intrastat Supplier/Item Cross Reference table (F744101)

In table F744101, the Country of Origin (ORIG) is used to determine transaction eligibility for Intrastat reporting. The Original Country of Origin (ORGO) is for information only. The Original Country of Origin field is populated by the Country of Origin (ORIG) field in the Item Branch File table (F4102) when you generate table F0018T.

Important: (Release 9.2 Update) For the Netherlands, if the lot number is enabled for the item, the system retrieves the value in the Original Country of Origin field from the Lot Master table (F4108). If the lot number is not enabled, the system retrieves country of origin from F4102.

You must include codes for all European Union countries as valid values on UDC 74/EC (European Community Members).

Important: Changes to transaction eligibility that occur after you generate table F0018T are not recognized when you regenerate table F0018T using the processing option to refresh it. Oracle recommends that you generate table F0018T only after you have completed all relevant changes to shipping and receiving information for the reporting period. If you must override addresses and change the transaction eligibility after generating table F0018T, you should clear and completely regenerate table F0018T.