FEC data fields

The FEC data table includes 23 rows that display all transaction details recorded during the accounting year.

FEC table fields

The FEC table contains these columns:

  • Field name: The official name of each field as defined in the FEC specification.
  • Information: A brief description of the business purpose of each field. It explains the business meaning or purpose of the field, such as a journal type, account code, or transaction reference.
  • Field type: These field types are available:
    • Alphanumeric: Accepts letters, numbers, and allowed symbols.
    • Numeric: Uses the character format with a decimal base. Use a comma as the decimal separator. Do not use thousands separators.
    • Date: Use the YYYYMMDD format without separators.
  • SunSystems data field: Maps each FEC field to its corresponding field in SunSystems Cloud.
  • Comments: Provides additional guidance or constraints for each field.

This table shows FEC data fields:

Field number Field name Information Field type SunSystems data field Comments
1 JournalCode Journal type code Alphanumeric Journal Type
2 JournalLib Journal type description Alphanumeric Journal Name Specify in French.
3 EcritureNum Sequential journal number Alphanumeric Journal Number
4 EcritureDate Accounting date Date Entry Date Specify the accounting recognition date within the accounting period.
5 CompteNum Account code Alphanumeric Account Analysis Code

The first three characters of the account analysis code must comply with the French legal Chart of Accounts (COA) standards.

Specify a value from 1 to 10, depending on how the system is implemented.
6 CompteLib Account description Alphanumeric Account Analysis Name

The first three characters of the account analysis code must comply with the French legal Chart of Accounts (COA) standards.

Specify a value from 1 to 10, depending on how the system is implemented.
7 CompAuxNum Customer/Supplier account Alphanumeric Account Code Specify one of these account code types:
  • C for a creditor.
  • D for a debtor.
  • T for a client.

If not applicable, leave the field blank.
8 CompAuxLib Customer/Supplier name Alphanumeric Account Description Specify one of these account code types:
  • C for a creditor.
  • D for a debtor.
  • T for a client.

If not applicable, leave the field blank.
9 PieceRef Voucher reference Alphanumeric Transaction Reference
10 PieceDate Voucher date Date Transaction Date
11 EcritureLib Posted journal line description Alphanumeric Transaction Description
12 Montant Amount Numeric Base Amount Specify an amount in Euro.
13 Sens Direction Alphanumeric Debit or credit marker Specify one of these types:
  • D for a debit amount.
  • C for a credit amount.
14 EcritureLet Allocation Reference Alphanumeric Allocation Reference

Reference linking both sides of matched or allocated transactions.

If not applicable, leave the field blank.
15 DateLet Allocation Date Date Allocation Date

Specify the allocation date (matching date) for the matched transaction.

If not applicable, leave the field blank.
16 ValidDate Journal validation date Date Hard posting date
17 Montantdevise Transaction currency amount Numeric Transaction Amount

If not applicable or if the base currency is used, leave the field blank.
18 Idevise Transaction currency code Alphanumeric Transaction Currency Code

If not applicable or if the base currency is used, leave the field blank.
19 SoldeOuverture Opening Balance flag Alphanumeric Added for derived Opening Balance entries from the journal type Specify 1 in the Opening Balance field.
20 EcrLig Journal line number Numeric Journal Line Number
21 TypeCompte Account type Alphanumeric Account Type
22 Simulés Provisional posting flag Alphanumeric Provisional Posting Flag Yis displayed in the Provisional Posting Flag field to indicate that this line is posted provisionally. Typically, provisional posting is not used in the French implementation, but it shows that the file is not final.
23 Période comptable Accounting period Alphanumeric Accounting Period Use the YYYY/PPP format, for example, 2022/012, in which YYYY indicates a four-digit year and PPP indicates a three-digit posting number.