If the coordinating body notices that false data were transmitted or a problem occurred with the data transfer, the Commission has to be informed immediately. All files, which contain incorrect information, are to be indicated. Therefore, the Commission is to be asked to delete these files. Thereafter, in order to avoid an overlapping of computer records or data files, the coordinating body must send the corrected computer files to replace entirely the previous incorrect information.

The coordinating body must send the computer files completely and only once.

The explanatory note shall have the look and feel of an ordinary letter. In particular the identity of the sender or the identity of the paying agency and the name or administrative unit of the addressee shall be clearly marked.

in the case where there are codes used for fields, for which Annex III does not enforce standard codes, in order to explain all these used codes. The STADIUM client includes a specific consignment type for this kind of tabular transfer, i.e. ‘CODE-LIST’.

in the case where there are differences between the annual declaration (2) , as part of the annual financial clearance procedure (not table 104), and the sum of the records in the computer files (Σ F106), in order to explain them by budget heading and subheading. The STADIUM client includes a specific consignment type for this transfer i.e. ‘EXPLANATORY-NOTE’;

In the following cases only, the coordinating body of the Member State must transfer an explanatory note for each paying agency through STATEL/STADIUM:

The computer program for checking the format of computer files before sending them to the Commission (WinCheckCsv) is included in the data transfer program (STADIUM client). The paying agencies are invited to download the check program from CIRCA separately for offline validation purposes.

Data files with the characteristics as described under 2.4 shall be sent with consignment type ‘X-TABLE-DATA’ (see ‘STADIUM client’).

(other data rows with the fields in the same order).

Files satisfying these rules will look like the following (example for financial year 2004):

All fields: no spaces at the beginning or end of a field.

Quotation marks (‘’) are not allowed at the beginning or at the end of the records. The semicolon field separator ‘;’ must not be used in data in text format.

EAGGF budget code (field F109) ABB-format without spaces: ‘999999999999999’ (where ‘9’ stands for any figure between 0 and 9).

Date field: ‘YYYYMMDD’ (year in four digits, month in two digits, day in two digits).

No spaces between digits. No spaces or other signs between thousands.

Fixed number of decimals (the details are set out in the Annex III hereto).

The symbol (+ or –) appears on the far left, followed immediately by the figures. For positive numbers, the ‘+’ sign is optional.

BE, DK, DE, ES, FR, IE, IT, LU, NL, AT, PT, FI, SE and GB

The file is in ASCII coding according to following table. Other codes (such as EBCDIC, TAR, ZIP, etc.) are not accepted:

Records vary in length. Each record ends with a code ‘CR LF’ or ‘Carriage Return — Line Feed’ (in hexadecimal: ‘0D 0A’). The header row never ends with a semicolon. Data rows only end with a semicolon if the last field is empty.

The fields are separated by a semicolon (;). The header row and data rows shall all contain the same number of semicolons. In the data rows, empty fields appear as a double semicolon (;;) within the record, or as a single semicolon (;) at the end of the record.

The following records in the file are data (data rows), in the order indicated by the first record describing the file structure.

The first record in the file (header row) contains the file description. The field names comprise an ‘F’ followed by the field number used in Annex I (the X table). Only field names existing in this Annex are allowed.

The computer files must have the following characteristics:

All information for the same category of payments or receipts must be contained in the same computer file. Separate files relating to the same payments (e.g. for traders or inspections, or for basic and measure data) are not allowed.

The records must have a flat-file structure. If fields have more than one value, separate records containing all data fields are required. Make sure that no double counting occurs (1) .

The Member State must create a computer record for each individual component of the EAGGF (Guarantee Section) payments and receipts. These components are the individual items of which the payment (receipt) to (from) the beneficiary consists.

The coordinating body of the Member State must transfer the computer files and the relating documentation to the Commission through STATEL/STADIUM. The Commission will only support one installation of STATEL/STADIUM per Member State. The latest STADIUM client and more information on the use of STATEL/STADIUM shall be downloaded from the CIRCA website of the EAGGF.

These technical specifications apply in respect of the financial year 2004, which commenced on 16 October 2003.

TECHNICAL SPECIFICATIONS FOR THE TRANSFER OF COMPUTER FILES TO THE EAGGF

ANNEX III

AIDE-MEMOIRE

2005 financial year

CONTENTS

1. DATA RELATING TO PAYMENTS

F100: Name of paying agency

F101: Reference number of payment

F102: Reference number of previous payment

F103: Type of payment

F103B: Private sector contribution

F105: Payment with sanction

F105A: Reduction pursuant to Articles 3 and 4 of Council Regulation (EC) No 1259/1999

F106: Amount

F107: Currency unit

F108: Date of payment

F109: EAGGF budget code

F110: Marketing year or period

2. DATA RELATING TO BENEFICIARY (APPLICANT)

F200: Identification code

F201: Name

F202A: Applicant’s address (street and number)

F202B: Applicant’s address (international post code)

F202C: Applicant’s address (municipality or city)

F207: Region and subregion

F211: Delivery reference quantity

F212: Direct sales reference quantity

F213: Reference fat content

F214: Purchaser of milk

F217: Date of entry private storage

F218: End date of private storage

F220: Identification code of the intermediate organisation

F221: Name of the intermediate organisation

F222B: Organisation’s address (international post code)

F222C: Organisation’s address (municipality or city)

3. DATA RELATING TO DECLARATION/APPLICATION

F300: Number of declaration/application

F300B: Date of application

F301: Number of contract (where applicable)

F304: Authorising office

F305: Number of certificate/licence

F306: Date of issue of the certificate/licence

F307: Office holding supporting documents

4. DATA RELATING TO SECURITY

F402: Amount of processing security (others than tender securities)

5. DATA RELATING TO PRODUCTS

F500: Product code/rural development submeasure code

F502: Quantity paid (number of animals, hectares, etc.)

F503: Quantity covered by payment application lodged (quantity claimed)

F507: Yield

F508A: Area covered by payment application lodged

F508B: Area covered by payment made

F509A: Area wrongly declared

F510: Community regulation and Article number

F510A: Community rate of financing (%)

F511: EAGGF rate of aid (EUR) per unit of measurement

F512: Conversion rate

F513: EAGGF rate of aid (in currency defined in field F107) per unit of measurement

F515: Gross deliveries

F517: Actual fat content

F518: Adjusted deliveries

F519: Direct sales

F519B: Deliveries after administrative corrections (if any)

F519C: Direct sales after administrative corrections (if any)

F520: Quantities delivered over or under quotas

F521: Direct sales over or under quotas

F522: Additional levy due

F523: Interest due for late payment

F530: Actual alcoholic strength by volume

F531: Total alcoholic strength by volume

F532: Natural alcoholic strength by volume

F533: Wine-growing zone

6. DATA RELATING TO INSPECTIONS

F600: On-farm inspection or remote sensing

F601: Date of inspection

F602: Application reduced

F602B: Recalculation of additional levy payable

F603: Reason for reduction

F604: Council Regulation (EEC) No 386/90 (on-the-spot checks)

F604B: Council Regulation (EEC) No 386/90 (substitution checks)

7. (NOT USED)

8. ADDITIONAL DATA RELATING TO EXPORT REFUNDS

F800: Net weight

F800B: Unit of measurement for field F800

F801: Application number (export refunds: SAD)

F802: Customs office of placing under customs supervision

F802B: Customs office of exit

F804: Export refund code

F805: Code for destination

F808: Date of advance fixing

F809: Last day of validity (advance fixing)

F812: Tender if applicable (advance fixing)

F814: Day of acceptance of payment declaration (COM-7)

F816: Date of acceptance of export declaration

F816B: Date of export from the EU territory

General remark: significance of the X, A and D codes used in Annex I:

All the information marked “X” or “A” is obligatory.

“X” = data element already included in the previous version of this Regulation. “A” = data element to be added compared to the previous version of this Regulation. “D” = data element to be deleted compared to the previous version of this Regulation.

Where a data request makes no sense under particular circumstances or is not applicable for the Member States concerned, then put NULL value, which shall be represented by two consecutive semicolons (;;) in the CSV format data file.

1. DATA RELATING TO PAYMENTS

Preliminary remark: In this section, the term “payment” refers to both the EAGGF (Guarantee Section) payments and the receipts.

F100: Name of paying agency

Required format: to be expressed by a code (see the code list F100 kept up to date on CAP-ED):

https://awai.cec.eu.int/

F101: Reference number of payment

The reference number identifying the payment clearly in the paying agency's accounts. Removals relating to food aid shall not be considered as sales of intervention products. In this particular case field F101 can be ignored.

F102: Reference number of previous payment

The reference number identifying the payment clearly in the paying agency's accounts as an advance or an amount recovered.

F103: Type of payment

Required format: to be expressed by a one-character code corresponding to the following code list:

Code Significance 0 Food aid 1 Advance or partial payment 2 Final payment (first and single payment, settlement of the balance after advance payment or normal export refund payment) 3 Recovery/reimbursement (following a sanction)/correction 4 Receipt of amounts (not preceded by an advance or final payment) 5 Pre-financing payment export refund 6 No financial transaction

F103B: Private sector contribution

This field is related to field F510A where the Commission asks for the percentage of EAGGF funding. Depending on a country’s interpretation of the percentage under F510A, field F103B might be required or not. If the EAGGF funding is expressed as a percentage as against the total investment, the amount of the private sector contribution shall be given here. Total investment being defined as the total costs eligible under EAGGF. If on the contrary F510A is expressed as a percentage as against the total eligible public expenditure, i.e. national and European, then this field can be ignored.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F105: Payment with sanction

Required format: yes = “Y”; no = “N”.

F105A: Reduction pursuant to Articles 3 and 4 of Council Regulation (EC) No 1259/1999 (OJ L 160, 26.6.1999, p. 113)

The field F105A of the X table must be used to indicate the amounts retained (negative amounts) on the basis of Articles 3 and 4 of Regulation (EC) No 1259/1999. Field F105A must be used for each budget post where a retention has been made.

There is no specific budget post on which to declare payments made using the amounts retained on the basis of Articles 3 and 4 of Regulation (EC) No 1259/1999. These payments shall therefore be indicated in field F105A of the corresponding budget posts (050401054030, 050401064040, 050401084050 and 050401114070). They appear as positive amounts indicating that the expenditure is financed via penalties for non-respect of environmental protection regimes or the system of modulation.

In the domain of arable crops on the other hand, F105A will appear as a negative amount indicating a reduction of the direct aid.

Required format: +99…99.99 or -99…99.99, where 9 stands for any number from 0 to 9 inclusive.

F106: Amount

Amount of each individual item of payment in the currency identified in field F107. The sum of these amounts (F106) by budget code (F109) shall in principle correspond with the amounts declared in Table 104. The amounts in field F106 relate to the EAGGF expenditure only. National expenditure shall not appear under this heading.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F107: Currency unit

Required format: ISO 4217 code: e.g. DKK, EUR, GBP, SEK etc.

See also the code list F107 kept up to date on CAP-ED:

https://awai.cec.eu.int/

F108: Date of payment

The date determining the month of declaration to the EAGGF.

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F109: EAGGF budget code

The full code of the activity-based budgeting structure must be given, including the title, chapter, Article, item and subitem.

Required ABB format without spaces: “999999999999999”, where 9 stands for a digit from 0 to 9. Missing positions shall be filled with zeros (e.g. 05020901160 becomes 050209011600000).

F110: Marketing year or period

For intervention products the Commission needs to know the marketing year to which the product corresponds or the quota period it is to be set off against.

2. DATA RELATING TO BENEFICIARY (APPLICANT)

Preliminary remark: the fields F200, F201, F202A, F202B and F202C must be used to identify the beneficiary of a payment, i.e. the final beneficiary. The fields F220, F221, F222B and F222C must additionally be used if a payment is made to the beneficiary through an intermediate organisation. If the intermediate organisation is also the final beneficiary the same data have to be filled in the fields F220, F221, F222B and F222C as indicated in the fields F200, F201, F202A, F202B and F202C.

The field F207 is only related to the field F200.

F200: Identification code

The individual unique identifier allocated to applicants at Member State level.

F201: Name

The applicant’s last name and first name, or the business name.

F202A: Applicant’s address (street and number)

F202B: Applicant’s address (international post code)

F202C: Applicant’s address (municipality or city)

F207: Region and subregion

Region and subregion code (NUTS 3) is defined by the main activities of the holding of the beneficiary to which the payment is assigned.

The code “Extra Region” (MSZZZ) should only be indicated in cases e.g. where no NUTS 3 code exists.

Required format: NUTS 3 code as specified in the code list F207 on CAP-ED: https://awai.cec.eu.int/

F211: Delivery reference quantity

This relates to the milk quota scheme.

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9.

F212: Direct sales reference quantity

This relates to the milk quota scheme.

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9.

F213: Reference fat content

This relates to the milk quota scheme.

Required format: 9…9.99, where 9 stands for a digit from 0 to 9.

F214: Purchaser of milk

In accordance with Article 5(e) of Council Regulation (EC) No 1788/2003 (OJ L 94, 31.3.2003, p. 71). This relates to the milk quota scheme.

F217: Date of entry private storage

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F218: End date of private storage

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F220: Identification code of the intermediate organisation

The individual unique identifier allocated to intermediate organisations at Member State level.

The payment is made to the beneficiary via the intermediate organisation, i.e. via each intermediate institution or directly to this organisation.

For rural development expenditure this will be basically limited to measures where interest rate subsidies are paid out via intermediate organisations.

F221: Name of the intermediate organisation

The organisation’s name.

F222B: Organisation’s address (international post code)

F222C: Organisation’s address (municipality or city)

3. DATA RELATING TO DECLARATION/APPLICATION

F300: Number of declaration/application

This must enable the declaration/application to be traced through the Member States’ files.

F300B: Date of application

The date of receipt of the application by the paying agency (including any divisional or regional offices thereof).

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F301: Number of contract (where applicable)

F304: Authorising office

This is the office responsible for administrative control and authorisation, e.g. the region. The more decentralised the management of the scheme is, the more important this information becomes.

F305: Number of certificate/licence

F306: Date of issue of the certificate/licence

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F307: Office holding supporting documents

Only where this is not the same as that specified in field F304.

4. DATA RELATING TO SECURITY

F402: Amount of processing security (others than tender securities)

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

5. DATA RELATING TO PRODUCTS

Preliminary remark concerning quantities: as a basic rule, quantities, areas and numbers of animals must only be shown once. In the case of an advance payment followed by a balance payment, the quantity must be shown in the record of the advance payment. Adjustments to quantities, areas and numbers of animals must be shown in the records covering the balance or subsequent payments. In the case of sums recovered, if the amount applied for is reduced because of incorrect quantities, areas or numbers of animals, the adjustments to the quantities must be indicated by a minus sign.

F500: Product code/rural development submeasure code

The Member States must draw up their own lists of codes, to be detailed in the explanatory note to the payment file(s).

In the case of rural development measures, indicate where applicable a code per sub-measure implemented (e.g. type of agri-environmental measure). For the budget line for rural development expenditure in the new Member States (budget post 05040400000) a one-character or two-character code corresponding to the following list must be expressed:

Code Significance A Investment in farms B Start-up assistance for young farmers C Training D Early retirement E Less-favoured areas and areas with environmental restrictions F Agri-environment and animal welfare G Improving the processing and marketing of agricultural products H Afforestation of agricultural land I Other forestry measures J Land improvement K Reparcelling L Setting up farm relief and farm management services, setting-up consulting services in farms and agricultural vulgarisation M Marketing of quality agricultural products N Basic services for the rural economy and population O Renovation and development of villages and protection and conservation of the rural heritage P Diversifying agricultural activities and activities close to agriculture to provide multiple activities or alternative sources of income Q Managing agricultural water resources R Developing and improving infrastructure connected with the development of agriculture S Encouraging tourist and craft activities T Protecting the environment in connection with agriculture, forestry and landscape management and improving animal welfare U Restoring agricultural production potential damaged by natural disasters and introducing appropriate prevention instruments V Financial engineering X Respect of standards Y Recourse of consulting services regarding respect of standards Z Voluntary participation of farmers in food quality systems AA Measures of producer groups in the area of food quality AB Semi-subsistence farms in the restructuring process AC Producer groups AD Technical assistance AE Complements to direct payments AF Complements to State aid in Malta AG Full-time farmers in Malta

In the case of the restructuration and conversion of vineyard (budget post 050209071650) measures codes must be expressed. These codes refer to the definitions of the measures defined by the competent authorities of the Member States in accordance with Article 13(2)(a) of Commission Regulation (EC) No 1227/2000 (OJ L 143, 16.6.2000, p. 1).

In the case of export refunds: F500 is only required if F804 contains ingredients for which the export refund is fixed. Then in F500, the code of the goods (in principle the CN code declared in box 33 of the SAD; eight digits) must be indicated for non-Annex I goods, or the product code for the final processed agricultural products.

For the small farmer scheme the following code list should be employed:

Code Where the flat-rate payment contains: A an area aid element B an animal premium element C both an animal premium and area aid element

F502: Quantity paid (number of animals, hectares, etc.)

See preliminary remarks in heading 5 (data relating to products).

For rural development the quantity paid shall be expressed in the unit appropriate to the agri-environmental submeasure mentioned in F500. A table of correspondence between the submeasure code (e.g. input reduction) used in F500 and the unit for calculating the premium (e.g. ha) used in F502 shall be included in the explanatory note to the payment file(s).

For the wine sector, the products obtained after distillation shall be expressed by alcoholic strength.

For all other sectors, the quantity paid shall be expressed in the unit, which is laid down in the Regulation as the basis for the premium payment.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant. (maximum 6).

F503: Quantity covered by payment application lodged (quantity claimed)

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant. (maximum 6).

F507: Yield

Representative yield used to calculate the compensatory payment (under the regionalisation plan in accordance with Article 3 of Council Regulation (EC) No 1251/1999 (OJ L 160, 16.6.1999, p. 1)).

Required format: 9…9.999, where 9 stands for a digit from 0 to 9.

F508A: Area covered by payment application lodged

The area covered by the application.

See preliminary remark in heading 5 (data relating to products).

For budget post 050404000000 (Rural Development in the new Member States) this field is required only for the measures E, F and H.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F508B: Area covered by payment made

The area on which the payment is made.

For budget post 050404000000 (Rural Development in the new Member States) this field is required only for the measures E, F and H.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F509A: Area wrongly declared

The difference between the area declared and that found. Overstatement being the area declared exceeding the area found and reported with a positive figure. Understatement being the area found exceeding the area declared and reported with a negative figure.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F510: Community regulation and Article number

In the case of intervention goods, the ad hoc instrument published in the Official Journal of the European Union is required.

F510A: Community rate of financing (%)

Percentage of the overall aid, which is EAGGF funded: This percentage can be calculated, as against the total investment, being the total costs eligible under EAGGF, including the private-sector contribution (see F103B). Alternatively as against the total public costs eligible under EAGGF i.e. excluding the private-sector contribution.

Required format: +99.99, where 9 stands for a digit from 0 to 9.

F511: EAGGF rate of aid (EUR) per unit of measurement

Except where there is no change in fields F511 or F512 throughout the marketing year.

Required format: 9…9.999999, where 9 stands for a digit from 0 to 9.

The use of six decimal places may seem odd but some regulations like Council Regulation (EC) No 660/1999 (OJ L 83, 27.3.1999, p. 10) fix the premium with up to five decimals even when using euro. To cover all possibilities the number of decimals has been raised to six.

F512: Conversion rate

The agricultural rate applied in respect of the payment (except where there is no change in fields F511 or F512 throughout the marketing year).

Required format: 9…9.999999, where 9 stands for a digit from 0 to 9.

F513: EAGGF rate of aid (in currency defined in field F107) per unit of measurement

Required format: 9…9.999999, where 9 stands for a digit from 0 to 9 (see comment under F511).

F515: Gross deliveries

“Gross deliveries” covers all quantities of milk and milk products delivered as defined in Article 5(f) of Regulation (EC) No 1788/2003, without any adjustment for the fat content.

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9. With the possibility of increasing the number of decimals if significant (maximum 6).

F517: Actual fat content

As shown by the laboratory analysis findings, expressed as a percentage rather than in grams or kilograms.

Required format: 9…9.99, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant (maximum 6).

F518: Adjusted deliveries

Quantities delivered, adjusted for the fat content in accordance with Article 10(1) of Commission Regulation (EC) No 595/2004 (OJ L 94, 31.3.2004, p. 22).

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant (maximum 6).

F519: Direct sales

Milk and milk equivalent as defined in Article 5(g) of Regulation (EC) No 1788/2003.

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant (maximum 6).

F519B: Deliveries after administrative corrections (if any)

Milk sector:“administrative corrections” means adjustments made by the paying agency to the quantities declared by purchasers. Such changes must always be shown separately from the quantities declared by the purchasers. Corrections may be positive or negative. The net changes must be shown as compared with the situation before the correction. There is no provision for including flat-rate corrections here.

Corrections following on-the-spot checks, required under Article 21 of Commission Regulation (EC) No 595/2004, must be recorded in fields F600 to F603.

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant (maximum 6).

F519C: Direct sales after administrative corrections (if any)

For the definition of administrative corrections, see field F519B.

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant (maximum 6).

F520: Quantities delivered over or under quotas

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9.

F521: Direct sales over or under quotas

Required format: +99…99.999 or -99…99.999, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant (maximum 6).

F522: Additional levy due

For deliveries or direct sales (a distinction is to be made through the budget code (field F109)).

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F523: Interest due for late payment

For deliveries or direct sales (to be distinguished by means of the budget code in field F109).

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F530: Actual alcoholic strength by volume

Expressed in % vol/hl.

Required format: 99.99, where 9 stands for a digit from 0 to 9.

F531: Total alcoholic strength by volume

Expressed in % vol/hl.

Required format: 99.99, where 9 stands for a digit from 0 to 9.

F532: Natural alcoholic strength by volume

Expressed in % vol/hl.

Required format: 99.99, where 9 stands for a digit from 0 to 9.

F533: Wine-growing zone

Wine-growing zone as defined in Annex III to Council Regulation (EC) No 1493/1999 (OJ L 179, 14.7.1999, p. 1).

Required format: to be expressed by one of the following codes: A, B, CIA, CIB, CII, CIIIA, CIIIB.

6. DATA RELATING TO INSPECTIONS

The Commission needs to know the number of inspections carried out and the number of cases where penalties have been applied as a result. Where the premium is withheld or recovered in full, zero payments must be indicated with the date of the decision in F108.

F600: On-farm inspection or remote sensing

The “on-the-spot checks” mentioned here are those referred to in the relevant regulations (3). They include physical visits of the farm and/or checks by remote sensing. Fields F601 to F603 need only be completed where an on-the-spot check is indicated in field F600. Every record, be it the advance or balance payment or other, that can be related to a particular inspection, shall have the appropriate code (see below) in field F600.

Administrative checks, within the meaning of the abovementioned regulations (see footnote below), shall not be mentioned in F600. They are not mentioned as such in any field. Nevertheless, the penalties imposed shall be given in F105, whether they originate from an administrative check or on-the-spot check.

Required format: “N” = no inspection,“F” = on-farm inspection and “T” = inspection by remote sensing. The code “FT” must be shown where both remote sensing and physical visits of the farm were used.

F601: Date of inspection

This field must be completed when an on-the-spot inspection is indicated in field F600. This field is not required for remote sensing checks.

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F602: Application reduced

If the application has been reduced as a result of an inspection, this must be indicated here. This field must be completed when an on-the-spot inspection is indicated in field F600.

Required format: yes = “Y”; no = “N”.

F602B: Recalculation of additional levy payable

For instance, after on-the-spot inspections.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9.

F603: Reason for reduction

Where there is more than one reason indicate the one justifying the highest penalty. This field must be completed when an on-the-spot inspection is indicated in field F600.

For the small farmer scheme the following code list will apply:

Code Reason A Blocked areas not available for farmer’s personal use B Non-respect of bovine ceiling C Non-respect of good agricultural conditions

Required format: to be expressed by a code; the codes must be explained in the accompanying letter.

F604: Council Regulation (EEC) No 386/90 (OJ L 42, 16.2.1990, p. 6) (on-the-spot checks)

Required format: yes = “Y”; no = “N”.

F604B: Regulation (EEC) No 386/90 (substitution checks)

Required format: yes = “Y”; no = “N”.

7. (NOT USED)

8. ADDITIONAL DATA RELATING TO EXPORT REFUNDS

F800: Net weight

See preliminary remark in heading 5 (data relating to products).

In the case of processed products (non-Annex I goods or processed agricultural products): the quantity of the ingredient eligible for funding. If the code of the goods (F500) contains more than one ingredient eligible for funding (F804), then multiple records with corresponding amounts (F106) and quantities (F800) must be created.

Required format: +99…99.99 or -99…99.99, where 9 stands for a digit from 0 to 9. With a possibility to increase the number of decimals if significant (maximum 6).

F800B: Unit of measurement for field F800

Required format: to be expressed by a one-character code corresponding to the following table:

Code Meaning K Kilogram L Litre P Piece (item)

F801: Application number (export refunds: SAD)

F802: Customs office of placing under customs supervision

The Member States must use the transit customs office list (COL (4)). This is the list of authorised customs offices for Community/common transit operations. It may be that, due to its objective of “transit operations”, some of the customs offices might be missing although this will be the exception. In that case the Member State shall provide the name of the customs office in full.

Required format: The format of the COL code consists of two positions to denote the country followed by six numeric positions that define the customs office. For instance, “NL146123”.

F802B: Customs office of exit

Indicate the customs office which certifies that products covered by refund applications have left the customs territory of the Community. The Member States must use the transit customs office list (COL). This is the list of authorised customs offices for Community/common transit operations. It may be that due to its objective of “transit operations” some of the customs offices might be missing although this will be the exception. In that case the Member State shall provide the name of the customs office in full.

This information is vital for the auditors in connection with the application of Regulation (EEC) No 386/90 concerning substitution checks. The information is available in T5 or equivalent documents.

Required format: The format of the COL code consists of two positions to denote the country followed by six numeric positions that define the customs office. For instance, “NL146123”.

F804: Export refund code

In the case of non-processed agricultural products: The 12-digit product code, for which export refund is fixed.

In cases of processed products (non-Annex I goods or processed agricultural products): the CN code(s) of the ingredient(s) for which the export refund is fixed. In this case, F500 must be completed with the code of the final product. See also the explanatory note to F800 for the procedure to follow where more than one ingredient of a processed product is eligible for refund.

F805: Code for destination

Required format: “XX”, where X stands for a letter between A and Z (codes of the nomenclature of countries and territories for the external trade statistics of the Community. See Commission Regulation (EC) No 2020/2001 (OJ L 273, 16.10.2001, p. 6) and subsequent updates).

In view of harmonisation, the Member States shall also use the miscellaneous category (codes Q*) of the nomenclature of countries and territories for the external trade statistics. It is known that that nomenclature does not cover all special export refund cases but the Commission does not require that kind of detail. Member States shall therefore convert their special national codes to the broader categories of the nomenclature of countries and territories for the external trade statistics before sending their data to the Commission.

F808: Date of advance fixing

If fixed in advance, the date on which the rate of refund was set.

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F809: Last day of validity (advance fixing)

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F812: Tender if applicable (advance fixing)

The procedure stipulated in Article 5 of Commission Regulation (EC) No 1501/95 (OJ L 147, 30.6.1995, p. 7) or similar procedure for other sectors. The Commission needs the reference of the invitation to tender.

F814: Day of acceptance of payment declaration (COM-7)

For the beef sector: in the case of pre-financing, complete field F814 only (disregarding fields F816 and F816B); if pre-financing is not involved, complete fields F816 and F816B (disregarding field F814).

Required format:“YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F816: Date of acceptance of export declaration

Date within the meaning of Article 5(1) of Commission Regulation (EC) No 800/1999 (OJ L 102, 17.4.1999, p. 11).

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).

F816B: Date of export from the EU territory

Date of export as indicated on the export declaration or on the T5. See also Article 7(1) of Regulation (EC) No 800/1999.

Required format: “YYYYMMDD” (year in four digits, month in two digits, day in two digits).