Appendix 1: Technical details

This sections describes how the Nature of Transaction codes and Country of Origin are calculated for exports.

• NoTCs 11 and 12 split:

  • For deliveries, if the BP is identified as a natural person, NoTC 12 is used instead of 11.

  • For transactions corresponding to other operations, the Nature of Transaction code is exported when it is stored in the EU exchange declaration - DEB table.

• Country of Origin:

  • If there is a value for the Country of Origin in the EU exchange declaration - DEB table, the value is exported as-is. Otherwise, it defaults to the country of the delivery site.

Patch content as of the end of November 2021

Settings	Transaction nature function (GESTEC), TABEECNAT table. New list of values for France and Germany.
	Movement rules and natures function (GESDRN), DEBREGNAT table. New rules regarding the determination of the Nature of Transaction .
Scripts	TRT - Script IMPDEB associated with the import/export templates (IDES and FREECEXP).
	TRT - Script FUNDEBSPA for the Spanish export.
	ADX - Script FUNDEBPOR for the Portuguese export.
	TRT - Script EDIDEB_RSTD for the French EDI export.
	EMI and ACl - Examples of the Database mass update (AMIEXE) and Control tables (GESACL) to update when possible for specific NoTCs in the Intrastat records extracted for 2022. You can adjust as needed.