Structure of Dynamics 365 Finance data sources for the FEC

In Microsoft Dynamics 365 Finance, you can generate the FEC main (Fichier des écritures comptables) file and the following annexes:

You can also generate an FEC that includes customer and vendor fiscal year opening balances (FEC Main Extended). Use this option for companies that have only a few records during the reporting period. The reporting period must include the beginning of the fiscal year.

As explained in Prerequisites to generate an FEC audit file in France, to accommodate article 100 of BOI-CF-IOR-60-40-20, the numbering must be continuous, consistent, and sequential. Because of these numbering requirements, we recommend that you set the Continuous option to Yes for number sequences. In some scenarios, the consistency of the number sequence for general ledger account entries (voucher) can be interrupted in the FEC Main file for the following reasons:

  • A general ledger account entry is created in accounting but isn't reported in the FEC when the amount is 0.00.
  • A voucher number is used for an inventory transaction that has a zero amount that isn't reflected in the general ledger account entries table.
  • A gap in the number sequence for general ledger account entries occurs because of a technical issue.

As of version 10.0.23 of Finance, use the Missing numbers justification annex to report general ledger account transactions that are missing in the FEC Main file.

The following sections list the data sources that are used in the FEC main file and annexes.

Data sources are described in detail in the Detailed data source descriptions section of this topic.

Main FEC file for the period specified

The following table shows the Main FEC file for the period specified data structure definitions ($GeneralJournalView_FR).

Number Name Type Description (FR) Description (EN) Electronic reporting (ER) data source
1 JournalCode Alphanumérique Le code journal de l'écriture comptable The journal code of the accounting entry. $GeneralJournalView_FR/$JournalCodeText
2 JournalLib Alphanumérique Le libellé journal de l'écriture comptable The journal caption of the accounting entry. $GeneralJournalView_FR/getGeneralJournalEntry()/deJournalLib_FR()
3 EcritureNum Alphanumérique Le numéro sur une séquence continue de l'écriture comptable The number in a continuous sequence for the accounting entry. $GeneralJournalView_FR/GeneralJournalEntrySubledgerVoucher
4 EcritureDate Date La date de comptabilisation de l'écriture comptable The posting date of the accounting entry. $GeneralJournalView_FR/GeneralJournalEntryAccountingDate
5 CompteNum Alphanumérique Le numéro de compte, dont les trois premiers caractères doivent correspondre à des chiffres respectant les normes du plan comptable français The account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts. Information on multiple customers or vendors transactions can be found in respective annexes. $GeneralJournalView_FR/$MainAccountId
6 CompteLib Alphanumérique Le libellé de compte, conformément à la nomenclature du plan comptable français The account name in accordance with the nomenclature of the French chart of accounts. $GeneralJournalView_FR/getGeneralJournalAccountEntry()/getMainAccountName()
7 CompAuxNum Alphanumérique Le numéro de compte auxiliaire (à blanc si non utilisé) The auxiliary account number. This field is blank if it isn't used. $GeneralJournalView_FR/getGeneralJournalAccountEntry()/deCompteAuxNum_FR()
8 CompAuxLib Alphanumérique Le libellé de compte auxiliaire (à blanc si non utilisé) The auxiliary account description. This field is blank if it isn't used. $GeneralJournalView_FR/getGeneralJournalAccountEntry()/deCompteAuxLib_FR()
9 PieceRef Alphanumérique La référence de la pièce justificative The reference of the supporting document. If reference of the supporting document can't be found, this field is populated with EcritureNum. $GeneralJournalView_FR/getGeneralJournalEntry()/dePieceNum_FR()
10 PieceDate Date La date de la pièce justificative The date of the supporting document. $GeneralJournalView_FR/getGeneralJournalEntry()/dePieceDate_FR()
11 EcritureLib Alphanumérique Le libellé de l'écriture comptable The wording of the accounting entry. $GeneralJournalView_FR/$ReplaceIntoDeEcritureLib_FR
12 Montant Numérique Le montant au débit/ au crédit The debit/credit amount. $GeneralJournalView_FR/$AbsAmount
13 Sens Numérique Le sens: "D" au débit; "C" au crédit The direction: D = debit, C = credit $GeneralJournalView_FR/$Direction
14 EcritureLet Alphanumérique Le lettrage de l'écriture comptable (à blanc si non utilisé) The lettering of the accounting entry. This field is blank if it isn't used. $GeneralJournalView_FR/$deEcritureLet
15 DateLet Date La date de lettrage (à blanc si non utilisé) The lettering date. This field is blank if it isn't used. $GeneralJournalView_FR/$deDateLet
16 ValidDate Date La date de validation de l'écriture comptable The validation date of the accounting entry. $GeneralJournalView_FR/GeneralJournalEntryAccountingDate
17 Montantdevise Numérique Le montant en devise (à blanc si non utilisé) The amount in currency. This field is blank if it isn't used. $GeneralJournalView_FR/GeneralJournalAccountEntryTransactionCurrencyAmount
18 Idevise Alphanumérique L'identifiant de la devise (à blanc si non utilisé) The currency identifier. This field is blank if it isn't used. $GeneralJournalView_FR/GeneralJournalAccountEntryTransactionCurrencyCode

Customers fiscal year opening balances annex

Customers fiscal year opening transactions are posted as summary transactions in general ledger. To provide detailed information on fiscal year opening transactions by customers, the Customers fiscal year opening balances annex is implemented. This annex collects the amounts of opening balances by customers at the beginning of the fiscal year and provides this information together with the opening transaction voucher from the general ledger.

The following table shows the Customers fiscal year opening balances annex data structure definitions ($CustLedgerBalance).

Number Name Type Description (FR) Description (EN) ER data source
1 JournalCode Alphanumérique Le code journal de l'écriture comptable The journal code of the accounting entry. CustTransGroupedByLedgerAccount/$JournalCodeText
2 JournalLib Alphanumérique Le libellé journal de l'écriture comptable The journal caption of the accounting entry. CustTransGroupedByLedgerAccount/$JournalLibText
3 EcritureNum Alphanumérique Le numéro sur une séquence continue de l'écriture comptable The number in a continuous sequence for the accounting entry. CustTransGroupedByLedgerAccount/$Voucher
4 EcritureDate Date La date de comptabilisation de l'écriture comptable The posting date of the accounting entry. CustTransGroupedByLedgerAccount/$Date
5 CompteNum Alphanumérique Le numéro de compte, dont les trois premiers caractères doivent correspondre à des chiffres respectant les normes du plan comptable français The account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts. CustTransGroupedByLedgerAccount/grouped/$LedgerAccount
6 CompteLib Alphanumérique Le libellé de compte, conformément à la nomenclature du plan comptable français The account name in accordance with the nomenclature of the French chart of accounts. CustTransGroupedByLedgerAccount/$LedgerAccountName
7 CompAuxNum Alphanumérique Le numéro de compte auxiliaire (à blanc si non utilisé) The auxiliary account number. This field is blank if it isn't used. CustTransGroupedByLedgerAccount/grouped/AccountNum
8 CompAuxLib Alphanumérique Le libellé de compte auxiliaire (à blanc si non utilisé) The auxiliary account description. This field is blank if it isn't used. CustTransGroupedByLedgerAccount/$PartyName
9 PieceRef Alphanumérique La référence de la pièce justificative The reference of the supporting document. CustTransGroupedByLedgerAccount/$PieceNum
10 PieceDate Date La date de la pièce justificative The date of the supporting document. CustTransGroupedByLedgerAccount/$PieceDate
11 EcritureLib Alphanumérique Le libellé de l'écriture comptable The wording of the accounting entry. CustTransGroupedByLedgerAccount/$EcritureLib
12 Montant Numérique Le montant au débit/ au crédit The debit/credit amount. CustTransGroupedByLedgerAccount/$AbsAmount
13 Sens Numérique Le sens: "D" au débit; "C" au crédit The direction: D = debit, C = credit CustTransGroupedByLedgerAccount/$Direction
14 EcritureLet Alphanumérique Le lettrage de l'écriture comptable (à blanc si non utilisé) The lettering of the accounting entry. This field is blank if it isn't used. $deEmpty
15 DateLet Date La date de lettrage (à blanc si non utilisé) The lettering date. This field is blank if it isn't used. $deDateNull
16 ValidDate Date La date de validation de l'écriture comptable The validation date of the accounting entry. CustTransGroupedByLedgerAccount/$ValidDate
17 Montantdevise Numérique Le montant en devise (à blanc si non utilisé) The amount in currency. This field is blank if it isn't used. CustTransGroupedByLedgerAccount/aggregated/AmountCur
18 Idevise Alphanumérique L'identifiant de la devise (à blanc si non utilisé) The currency identifier. This field is blank if it isn't used. CustTransGroupedByLedgerAccount/grouped/CurrencyCode

Vendors fiscal year opening balances annex

Vendors fiscal year opening transactions are posted as summary transactions in general ledger. To provide detailed information on fiscal year opening transactions by vendors, the Vendors fiscal year opening balances annex is implemented. This annex collects amounts of opening balances by vendors on the beginning of the fiscal year and represents this information in combination with opening transaction voucher from general ledger.

The following table shows the Vendors fiscal year opening balances annex data structure definitions.

Number Name Type Description (FR) Description (EN) ER data source
1 JournalCode Alphanumérique Le code journal de l'écriture comptable The journal code of the accounting entry. Not included
2 JournalLib Alphanumérique Le libellé journal de l'écriture comptable The journal caption of the accounting entry. VendTransGroupedByLedgerAccount/$JournalLibText
3 EcritureNum Alphanumérique Le numéro sur une séquence continue de l'écriture comptable The number in a continuous sequence for the accounting entry. VendTransGroupedByLedgerAccount/$Voucher
4 EcritureDate Date La date de comptabilisation de l'écriture comptable The posting date of the accounting entry. VendTransGroupedByLedgerAccount/$Date
5 CompteNum Alphanumérique Le numéro de compte, dont les trois premiers caractères doivent correspondre à des chiffres respectant les normes du plan comptable français The account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts. VendTransGroupedByLedgerAccount/grouped/$LedgerAccount
6 CompteLib Alphanumérique Le libellé de compte, conformément à la nomenclature du plan comptable français The account name in accordance with the nomenclature of the French chart of accounts. VendTransGroupedByLedgerAccount/$LedgerAccountName
7 CompAuxNum Alphanumérique Le numéro de compte auxiliaire (à blanc si non utilisé) The auxiliary account number. This field is blank if it isn't used. VendTransGroupedByLedgerAccount/grouped/AccountNum
8 CompAuxLib Alphanumérique Le libellé de compte auxiliaire (à blanc si non utilisé) The auxiliary account description. This field is blank if it isn't used. VendTransGroupedByLedgerAccount/$PartyName
9 PieceRef Alphanumérique La référence de la pièce justificative The reference of the supporting document. VendTransGroupedByLedgerAccount/$PieceNum
10 PieceDate Date La date de la pièce justificative The date of the supporting document. VendTransGroupedByLedgerAccount/$PieceDate
11 EcritureLib Alphanumérique Le libellé de l'écriture comptable The wording of the accounting entry. VendTransGroupedByLedgerAccount/$EcritureLib
12 Montant Numérique Le montant au débit/ au crédit The debit/credit amount. VendTransGroupedByLedgerAccount/$AbsAmount
13 Sens Numérique Le sens: "D" au débit; "C" au crédit The direction: D = debit, C = credit VendTransGroupedByLedgerAccount/$Direction
14 EcritureLet Alphanumérique Le lettrage de l'écriture comptable (à blanc si non utilisé) The lettering of the accounting entry. This field is blank if it isn't used. $deEmpty
15 DateLet Date La date de lettrage (à blanc si non utilisé) The lettering date. This field is blank if it isn't used. $deDateNull
16 ValidDate Date La date de validation de l'écriture comptable The validation date of the accounting entry. VendTransGroupedByLedgerAccount/$ValidDate
17 Montantdevise Numérique Le montant en devise (à blanc si non utilisé) The amount in currency. This field is blank if it isn't used. VendTransGroupedByLedgerAccount/aggregated/AmountCur
18 Idevise Alphanumérique L'identifiant de la devise (à blanc si non utilisé) The currency identifier. This field is blank if it isn't used. VendTransGroupedByLedgerAccount/grouped/CurrencyCode

Customers transactions annex for the period specified

Customers transactions annex for the period specified annex can be requested to provide additional details on customers transactions. For example, in case a company uses Allow multiple transactions within one voucher parameter on the General tab of the General ledger parameters page, one voucher can be assigned to multiple customers transactions. To provide detailed information by customers accounts for such scenario, Customers transactions annex for the period specified annex is implemented.

The following table shows the Customers transactions annex for the period specified data structure definitions.

Number Name Type Description (FR) Description (EN) ER data source
1 JournalCode Alphanumérique Le code journal de l'écriture comptable The journal code of the accounting entry. $CustTrans/$JournalCodeText
2 JournalLib Alphanumérique Le libellé journal de l'écriture comptable The journal caption of the accounting entry. $CustTrans/$JournalLibText
3 EcritureNum Alphanumérique Le numéro sur une séquence continue de l'écriture comptable The number in a continuous sequence for the accounting entry. $CustTrans/Voucher
4 EcritureDate Date La date de comptabilisation de l'écriture comptable The posting date of the accounting entry. $CustTrans/TransDate
5 CompteNum Alphanumérique Le numéro de compte, dont les trois premiers caractères doivent correspondre à des chiffres respectant les normes du plan comptable français The account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts. $CustTrans/deLedgerAccount_FR()
6 CompteLib Alphanumérique Le libellé de compte, conformément à la nomenclature du plan comptable français The account name in accordance with the nomenclature of the French chart of accounts. $CustTrans/deLedgerAccountName_FR()
7 CompAuxNum Alphanumérique Le numéro de compte auxiliaire (à blanc si non utilisé) The auxiliary account number. This field is blank if it isn't used. $CustTrans/AccountNum
8 CompAuxLib Alphanumérique Le libellé de compte auxiliaire (à blanc si non utilisé) The auxiliary account description. This field is blank if it isn't used. $CustTrans/custTableName()
9 PieceRef Alphanumérique La référence de la pièce justificative The reference of the supporting document. $CustTrans/$PieceNum
10 PieceDate Date La date de la pièce justificative The date of the supporting document. $CustTrans/$PieceDate
11 EcritureLib Alphanumérique Le libellé de l'écriture comptable The wording of the accounting entry. $CustTrans/deEcritureLib_FR()
12 Montant Numérique Le montant au débit/ au crédit The debit/credit amount. $CustTrans/$AbsAmount
13 Sens Numérique Le sens: "D" au débit; "C" au crédit The direction: D = debit, C = credit $CustTrans/$Direction
14 EcritureLet Alphanumérique Le lettrage de l'écriture comptable (à blanc si non utilisé) The lettering of the accounting entry. This field is blank if it isn't used. $CustTrans/LastSettleVoucher
15 DateLet Date La date de lettrage (à blanc si non utilisé) The lettering date. This field is blank if it isn't used. $CustTrans/LastSettleDate
16 ValidDate Date La date de validation de l'écriture comptable The validation date of the accounting entry. $CustTrans/createdDateTime
17 Montantdevise Numérique Le montant en devise (à blanc si non utilisé) The amount in currency. This field is blank if it isn't used. $CustTrans/AmountCur
18 Idevise Alphanumérique L'identifiant de la devise (à blanc si non utilisé) The currency identifier. This field is blank if it isn't used. $CustTrans/CurrencyCode

Vendors transactions annex for the period specified

Vendors transactions annex for the period specified annex can be requested to provide additional details on vendors transactions. For example, in case a company uses Allow multiple transactions within one voucher parameter on the General tab of the General ledger parameters page, one voucher can be assigned to multiple vendors transactions. To provide detailed information by vendors accounts for such scenario, Vendors transactions annex for the period specified annex is implemented.

The following table shows the Vendors transactions annex for the period specified data structure definitions.

Number Name Type Description (FR) Description (EN) ER data source
1 JournalCode Alphanumérique Le code journal de l'écriture comptable The journal code of the accounting entry. $VendTrans/$JournalCodeText
2 JournalLib Alphanumérique Le libellé journal de l'écriture comptable The journal caption of the accounting entry. $VendTrans/$JournalLibText
3 EcritureNum Alphanumérique Le numéro sur une séquence continue de l'écriture comptable The number in a continuous sequence for the accounting entry. $VendTrans/Voucher
4 EcritureDate Date La date de comptabilisation de l'écriture comptable The posting date of the accounting entry. $VendTrans/TransDate
5 CompteNum Alphanumérique Le numéro de compte, dont les trois premiers caractères doivent correspondre à des chiffres respectant les normes du plan comptable français The account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts. $VendTrans/deLedgerAccount_FR()
6 CompteLib Alphanumérique Le libellé de compte, conformément à la nomenclature du plan comptable français The account name in accordance with the nomenclature of the French chart of accounts. $VendTrans/deLedgerAccountName_FR()
7 CompAuxNum Alphanumérique Le numéro de compte auxiliaire (à blanc si non utilisé) The auxiliary account number. This field is blank if it isn't used. $VendTrans/AccountNum
8 CompAuxLib Alphanumérique Le libellé de compte auxiliaire (à blanc si non utilisé) The auxiliary account description. This field is blank if it isn't used. $VendTrans/custTableName()
9 PieceRef Alphanumérique La référence de la pièce justificative The reference of the supporting document. $VendTrans/$PieceNum
10 PieceDate Date La date de la pièce justificative The date of the supporting document. $VendTrans/$PieceDate
11 EcritureLib Alphanumérique Le libellé de l'écriture comptable The wording of the accounting entry. $VendTrans/deEcritureLib_FR()
12 Montant Numérique Le montant au débit/ au crédit The debit/credit amount. $VendTrans/$AbsAmount
13 Sens Numérique Le sens: "D" au débit; "C" au crédit The direction: D = debit, C = credit $VendTrans/$Direction
14 EcritureLet Alphanumérique Le lettrage de l'écriture comptable (à blanc si non utilisé) The lettering of the accounting entry. This field is blank if it isn't used. $VendTrans/LastSettleVoucher
15 DateLet Date La date de lettrage (à blanc si non utilisé) The lettering date. This field is blank if it isn't used. $VendTrans/LastSettleDate
16 ValidDate Date La date de validation de l'écriture comptable The validation date of the accounting entry. $VendTrans/createdDateTime
17 Montantdevise Numérique Le montant en devise (à blanc si non utilisé) The amount in currency. This field is blank if it isn't used. $VendTrans/AmountCur
18 Idevise Alphanumérique L'identifiant de la devise (à blanc si non utilisé) The currency identifier. This field is blank if it isn't used. $VendTrans/CurrencyCode

FEC main file including fiscal year opening balances details for customers and vendors

The following table shows the FEC main file including fiscal year opening balances details for customers and vendors data structure definitions.

Number Name Type Description (FR) Description (EN) ER data source
1 JournalCode Alphanumérique Le code journal de l'écriture comptable The journal code of the accounting entry. $FECExtendedAggregation/$JournalCodeText
2 JournalLib Alphanumérique Le libellé journal de l'écriture comptable The journal caption of the accounting entry. $FECExtendedAggregation/$JournalLibText
3 EcritureNum Alphanumérique Le numéro sur une séquence continue de l'écriture comptable The number in a continuous sequence for the accounting entry. $FECExtendedAggregation/$Voucher
4 EcritureDate Date La date de comptabilisation de l'écriture comptable The posting date of the accounting entry. $FECExtendedAggregation/$Date
5 CompteNum Alphanumérique Le numéro de compte, dont les trois premiers caractères doivent correspondre à des chiffres respectant les normes du plan comptable français The account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts. Information on multiple customers or vendors transactions can be found in respective annexes. $FECExtendedAggregation/$LedgerAccount
6 CompteLib Alphanumérique Le libellé de compte, conformément à la nomenclature du plan comptable français The account name in accordance with the nomenclature of the French chart of accounts. $FECExtendedAggregation/$LedgerAccountName
7 CompAuxNum Alphanumérique Le numéro de compte auxiliaire (à blanc si non utilisé) The auxiliary account number. This field is blank if it isn't used. $FECExtendedAggregation/$AccountNum
8 CompAuxLib Alphanumérique Le libellé de compte auxiliaire (à blanc si non utilisé) The auxiliary account description. This field is blank if it isn't used. $FECExtendedAggregation/$PartyName
9 PieceRef Alphanumérique La référence de la pièce justificative The reference of the supporting document. If reference of the supporting document cannot be found, this field is populated with EcritureNum. $FECExtendedAggregation/$PieceNum
10 PieceDate Date La date de la pièce justificative The date of the supporting document. $FECExtendedAggregation/$PieceDate
11 EcritureLib Alphanumérique Le libellé de l'écriture comptable The wording of the accounting entry. $FECExtendedAggregation/$EcritureLib
12 Montant Numérique Le montant au débit/ au crédit The debit/credit amount. $FECExtendedAggregation/$AbsAmount
13 Sens Numérique Le sens: "D" au débit; "C" au crédit The direction: D = debit, C = credit $FECExtendedAggregation/$Direction
14 EcritureLet Alphanumérique Le lettrage de l'écriture comptable (à blanc si non utilisé) The lettering of the accounting entry. This field is blank if it isn't used. $FECExtendedAggregation/$LastSettleVoucher
15 DateLet Date La date de lettrage (à blanc si non utilisé) The lettering date. This field is blank if it isn't used. $FECExtendedAggregation/$LastSettleDate
16 ValidDate Date La date de validation de l'écriture comptable The validation date of the accounting entry. $FECExtendedAggregation/$ValidDate
17 Montantdevise Numérique Le montant en devise (à blanc si non utilisé) The amount in currency. This field is blank if it isn't used. $FECExtendedAggregation/$AmountCur
18 Idevise Alphanumérique L'identifiant de la devise (à blanc si non utilisé) The currency identifier. This field is blank if it isn't used. $FECExtendedAggregation/$CurrencyCode

Missing numbers justification annex

As of Finance version 10.0.23, the Missing numbers justification annex represents data that is collected from Finance for the following scenarios where the consistency of the number sequence for general ledger account entries (voucher) can be interrupted in the FEC Main file:

  • Scenario 1: A general ledger account entry is created in accounting but isn't reported in the FEC when the amount is 0.00.
  • Scenario 2: A voucher number is used for an inventory transaction that has a zero amount that isn't reflected in the general ledger account entries table.
  • Scenario 3: A gap in the number sequence for general ledger account entries occurs because of a technical issue.

Use the Missing numbers justification annex to report general ledger account transactions that are missing in the FEC Main file for the preceding reasons.

The following table shows the FEC main file including fiscal year opening balances details for customers and vendors data structure definitions.

Number Name Type Description (FR) Description (EN) ER data source
1 JournalCode Alphanumérique Le code journal de l'écriture comptable The journal code of the accounting entry.

$VouchersOmissions/$JournalCodeText

  • Scenario 1: GeneralJournalView_FR.GeneralJournalEntrySubledgerVoucher
  • Scenario 2: InventTrans.VoucherPhysical
  • Scenario 3: Autogenerated missing voucher number
2 JournalLib Alphanumérique Le libellé journal de l'écriture comptable The journal caption of the accounting entry.

$VouchersOmissions/$JournalLib

  • Scenario 1: GeneralJournalView_FR.'getGeneralJournalEntry()'.'deJournalLib_FR()'
  • Scenario 2: "Stock"
  • Scenario 3: Empty value
3 EcritureNum Alphanumérique Le numéro sur une séquence continue de l'écriture comptable The number in a continuous sequence for the accounting entry. $VouchersOmissions/$Voucher
4 EcritureDate Date La date de comptabilisation de l'écriture comptable The posting date of the accounting entry.

$VouchersOmissions/$Date

  • Scenario 1: GeneralJournalView_FR.GeneralJournalEntryAccountingDate
  • Scenario 2: InventTrans.DatePhysical
  • Scenario 3: Empty value
5 CompteNum Alphanumérique Le numéro de compte, dont les trois premiers caractères doivent correspondre à des chiffres respectant les normes du plan comptable français The account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts. Information on multiple customers or vendors transactions can be found in respective annexes.

$VouchersOmissions/$AccountNum

  • Scenario 1: GeneralJournalView_FR.GeneralJournalAccountEntryMainAccount
  • Scenario 2: Empty value
  • Scenario 3: Empty value
6 CompteLib Alphanumérique Le libellé de compte, conformément à la nomenclature du plan comptable français The account name in accordance with the nomenclature of the French chart of accounts.

$VouchersOmissions/$AccountName

  • Scenario 1: GeneralJournalView_FR.'getGeneralJournalAccountEntry()'.getMainAccountName()
  • Scenario 2: Empty value
  • Scenario 3: Empty value
7 CompAuxNum Alphanumérique Le numéro de compte auxiliaire (à blanc si non utilisé) The auxiliary account number. This field is blank if it isn't used.

$VouchersOmissions/$CompteAuxNum

  • Scenario 1: GeneralJournalView_FR.'getGeneralJournalAccountEntry()'.'deCompteAuxNum_FR()'
  • Scenario 2: Not applicable
  • Scenario 3: Not applicable
8 CompAuxLib Alphanumérique Le libellé de compte auxiliaire (à blanc si non utilisé) The auxiliary account description. This field is blank if it isn't used.

$VouchersOmissions/$CompteAuxLib

  • Scenario 1: GeneralJournalView_FR.'getGeneralJournalAccountEntry()'.'deCompteAuxLib_FR()'
  • Scenario 2: Not applicable
  • Scenario 3: Not applicable
9 PieceRef Alphanumérique La référence de la pièce justificative The reference of the supporting document. If reference of the supporting document cannot be found, this field is populated with EcritureNum.

$VouchersOmissions/$PieceRef

  • Scenario 1: GeneralJournalView_FR.'getGeneralJournalEntry()'.'dePieceNum_FR()'
  • Scenario 2: InventTrans.VoucherPhysical
  • Scenario 3: Empty value
10 PieceDate Date La date de la pièce justificative The date of the supporting document.

$VouchersOmissions/$PieceDate

  • Scenario 1: GeneralJournalView_FR.'getGeneralJournalEntry()'.'dePieceDate_FR()'
  • Scenario 2: InventTrans.DatePhysical
  • Scenario 3: Empty value
11 EcritureLib Alphanumérique Le libellé de l'écriture comptable The wording of the accounting entry.

$VouchersOmissions/$EcritureLib

  • Scenario 1: GeneralJournalView_FR.'getGeneralJournalAccountEntry()'
  • Scenario 2: 'InventTrans_' and InventTrans.RecID
  • Scenario 3: Empty value
12 Montant Numérique Le montant au débit/ au crédit The debit/credit amount.

$VouchersOmissions/$AbsAmount

  • Scenario 1: GeneralJournalView_FR.GeneralJournalAccountEntryAccountingCurrencyAmount
  • Scenario 2: InventTrans.CostAmountPhysical
  • Scenario 3: '0.00'
13 Sens Numérique Le sens: "D" au débit; "C" au crédit The direction: D = debit, C = credit

$VouchersOmissions/$Direction

  • Scenario 1: Debit/credit indicator of the financial voucher (GeneralJournalView_FR.GeneralJournalAccountEntryAccountingCurrencyAmount)
  • Scenario 2: Debit/credit indicator of the physical voucher (InventTrans.CostAmountPhysical)
  • Scenario 3: Empty value
14 EcritureLet Alphanumérique Le lettrage de l'écriture comptable (à blanc si non utilisé) The lettering of the accounting entry. This field is blank if it isn't used.

$VouchersOmissions/$EcritureLet

  • Scenario 1: GeneralJournalAccountEntry_Extension.deEcritureLet_FR(GeneralJournalView_FR.'getGeneralJournalAccountEntry()','$Period_DateFrom', '$Period_DateTo')
  • Scenario 2: Not applicable
  • Scenario 3: Not applicable
15 DateLet Date La date de lettrage (à blanc si non utilisé) The lettering date. This field is blank if it isn't used.

$VouchersOmissions/$DateLet

  • Scenario 1: GeneralJournalAccountEntry_Extension.deDateLet_FR(GeneralJournalView_FR.'getGeneralJournalAccountEntry()','$Period_DateFrom','$Period_DateTo')
  • Scenario 2: Not applicable
  • Scenario 3: Not applicable
16 ValidDate Date La date de validation de l'écriture comptable The validation date of the accounting entry.

$VouchersOmissions/$Date

  • Scenario 1: GeneralJournalView_FR.GeneralJournalEntryAccountingDate
  • Scenario 2: InventTrans.DatePhysical
  • Scenario 3: Empty value
17 Montantdevise Numérique Le montant en devise (à blanc si non utilisé) The amount in currency. This field is blank if it isn't used.

$VouchersOmissions/$AmountCur

  • Scenario 1: GeneralJournalView_FR.GeneralJournalAccountEntryTransactionCurrencyAmount
  • Scenario 2: InventTrans.CostAmountPhysical
  • Scenario 3: '0.00'
18 Idevise Alphanumérique L'identifiant de la devise (à blanc si non utilisé) The currency identifier. This field is blank if it isn't used.

$VouchersOmissions/$Currency

  • Scenario 1: GeneralJournalView_FR.GeneralJournalAccountEntryTransactionCurrencyCode
  • Scenario 2: InventTrans.CurrencyCode
  • Scenario 3: Not applicable

Detailed data source descriptions

This section explains the data sources of the fields in FEC of the "Main" type in terms of Finance tables and fields.

JournalCode – Journal code of the accounting entry

The value of the JournalCode field represents the text part of the prefix that is specified for the number sequence of the general ledger voucher that the general ledger transaction uses when it's posted. The algorithm for extracting the prefix is based on the rule that must be applied during the setup of the number sequences, as described in Prerequisites for generating an FEC audit file. For example, if the voucher series for vendor invoice journals is defined as FRSIFACF-########, the value FRSIFACF is reported in the JournalCode field in the FEC.

JournalLib – Journal caption of the accounting entry

The value of the JournalLib field is collected from several data sources in Finance:

  1. If the transaction originates from a ledger journal transaction, the value is collected from the Name field of the LedgerJournalName table.
  2. If the transaction doesn't originate from a ledger journal transaction, the value is collected from the label in the French language of the LedgerTransType enumeration (enum) from the JournalCategory field of the GeneralJournalEntry table.
  3. If the LedgerTransType enum value isn't defined, Finance returns the description of TransactionLog from TransactionLog.Type in the French language that is related to generalJournalEntry.CreatedTransactionId.

EcritureNum – Number in a continuous sequence for the accounting entry

The EcritureNum field represents the value of the SubledgerVoucher field of the GeneralJournalEntry table record that is related to each reporting transaction. In the Finance user interface (UI), this field value can be viewed in the Voucher field of general ledger transactions.

EcritureDate – Posting date of the accounting entry

The EcritureDate field represents the value of the AccountingDate field of the GeneralJournalEntry table record that is related to each reporting transaction. In the Finance UI, this field value can be viewed in the Date field of general ledger transactions.

CompteNum – Account number, the first three characters of which must correspond to figures that respect the standards of the French chart of accounts

The CompteNum field represents the value of the MainAccountID field of the MainAccount table record that is related to the MainAccount field of the GeneralJournalAccountEntry table that is related to each reporting transaction. In the Finance UI, this field value can be viewed in the Main account field of general ledger transactions.

CompteLib – Account name in accordance with the nomenclature of the French chart of accounts

The CompteLib field represents the value in the French language of the Name field of the MainAccount table that is related to the MainAccount field of the GeneralJournalAccountEntry table that related to each reporting transaction. The French translation is collected from the MainAccountTranslation table record that is related to the record of the MainAccount table. If no translation is stored for a MainAccount table record, the value of the Name field of the MainAccount table is reported. In the Finance UI, this field value can be viewed in the Account name field of general ledger transactions.

CompAuxNum – Auxiliary account number

The value of the CompAuxNum field is collected from several data sources in Finance:

  1. For reporting transactions of the Customer balance, Customer settlement, or Customer reimbursement posting type, this field represents the AccountNum field of the CustTable table record that is related by AccountNum value to the CustTrans table record that is related by the value of the subledgerVoucher and AccountingDate fields to the record of the GeneralJournalEntry table, or related by the value of the Voucher and AccountingDate fields of GeneralJournalEntry table to the record of the subledgerVoucherGeneralJournalEntry table, where the subledgerVoucherGeneralJournalEntry table record is connected with the GeneralJournalEntry table record by generalJournalEntry.RecId value. In the Finance UI, this field value can be viewed in the Account field of customer master data.
  2. For reporting transactions of the Vendor balance or Vendor settlement posting type, this field represents the AccountNum field of the VendTable table record that is related by AccountNum value to the VendTrans table record that is related by the value of the subledgerVoucher and AccountingDate fields to the record of the GeneralJournalEntry table, or related by the value of the Voucher and AccountingDate fields of the GeneralJournalEntry table to the record of the subledgerVoucherGeneralJournalEntry table, where the subledgerVoucherGeneralJournalEntry table record is connected with the GeneralJournalEntry table record by generalJournalEntry.RecId value. In the Finance UI, this field value is shown in Account field of vendor master data.
  3. For reporting transactions of other posting types, this field value is blank.

CompAuxLib – Auxiliary account description

The CompAuxLib field represents the Name field of the dirPartyTable table record that is related to the value that is defined for the CompAuxNum field of the report, where the dirPartyTable table is connected to CustTable and VendTable via the Party field. In the Finance UI, this field value can be viewed in the Name field of customer or vendor master data.

PieceRef – Reference of the supporting document

The value of the PieceRef field is collected from several data sources in Finance:

  1. The Invoice field value of the VendorTrans table that is related to the GeneralJournalEntry table record by the subledgerVoucher and AccountingDate fields of the GeneralJournalEntry table. In the Finance UI, this field value can be viewed in the Invoice field of the invoice journal in the Accounts payable module.
  2. The Invoice field value of the CustTrans table that is related to the GeneralJournalEntry table record by the subledgerVoucher and AccountingDate fields of the GeneralJournalEntry table. In the Finance UI, this field value can be viewed in the Invoice field of the invoice journal in the Accounts receivable module.
  3. The DocumentNumber field or, if the DocumentNumber field is blank, the subledgerVoucher field of the GeneralJournalEntry table. In the Finance UI, this field value can be viewed in the Document field or, if the Document field is blank, the Voucher field of general ledger transactions.

PieceDate – Date of the supporting document

The value of PieceDate field is collected from the DocumentDate or AccountingDate field of the GeneralJournalEntry table in Finance. In the Finance UI, this field value can be viewed in the Document date or Date field of general ledger transactions.

EcritureLib – Wording of the accounting entry

The value of the EcritureLib field is collected from several data sources in Finance:

  1. The Text field of the GeneralJournalAccountEntry table record that is related to each reporting transaction.
  2. If the Text field of the GeneralJournalAccountEntry table is blank, Finance collects the Text field value from the TransactionLogTable table that is connected by the createdTransactionId field of the GeneralJournalAccountEntry table.
  3. If both Text fields are blank, this field value is "N/A".

If char(10) or char(32) is included in the Text value in Finance, it's excluded for the value in reporting.

In the Finance UI, this field value can be viewed in the Description field of general ledger transactions.

Montant – Debit or credit amount

The value of the Montant field represents the absolute value of the AccountingCurrencyAmount field of the GeneralJournalAccountEntry table record that is related to each reporting transaction. In the Finance UI, this field value can be viewed in the Amount field of general ledger transactions.

Sens – Direction (D = debit, C = credit)

The value of the Sens field is calculated in the following way:

  1. If AccountingCurrencyAmount = 0 in the record that is related to the reporting transaction, this field represents the value of the IsCredit field of GeneralJournalAccountEntry.
  2. If AccountingCurrencyAmount < 0 and IsCorrection = No, this field represents "C".
  3. If AccountingCurrencyAmount > 0 and IsCorrection = Yes, this field represents "C".
  4. In other cases where IsCredit = Yes and IsCorrection = Yes, this field represents "D".
  5. In other cases where IsCredit = No and IsCorrection = No, this field represents "D".
  6. In all other cases, this field represents "C".

EcritureLet – Lettering of the accounting entry

The value of the EcritureLet field is reported for general ledger transactions of the Customer balance or Vendor balance posting type. It's collected from several data sources in Finance:

  1. If the value of the JournalCategory field of the GeneralJournalEntry table record is Payment, the payment voucher is represented in the EcritureLet field by the same value that is used in the EcritureNum field of the report.
  2. For other values of the JournalCategory field of the GeneralJournalEntry table record, Finance represents the value of the OffsetTransVoucher field of the VendSettlement table or CustSettlement table that is related by the RecId, AccountNum and DataAreaID fields to the VendTrans table or CustTrans table if there is a record in the VendSettlement table or CustSettlement table during the reporting period. In the Finance UI, this field value can be viewed in the Voucher field of general ledger transactions that were posted for the latest settled payment during the reporting period. If several vouchers are included in the settlement, they are separated by a comma.

DateLet – Lettering date

The value of the DateLet field is reported for general ledger transactions of the Customer balance or Vendor balance posting type. It's collected from several data sources in Finance:

  1. If the value of the JournalCategory field of the GeneralJournalEntry table record is Payment, the field represents the same value as the EcritureDate field of the report.
  2. For other values of the JournalCategory field of the GeneralJournalEntry table record, Finance represents the latest value during the reporting period of the TransDate field from CustSettlement.TransDate, the VendSettlement.TransDate field (settlement posting date) from the VendSettlement table or CustSettlement table that is related to the record of the VendSettlement table or CustSettlement table that is related by the RecId, AccountNum, and DataAreaID fields to the VendTrans table or CustTrans table if there is a record in the VendSettlement table or CustSettlement table during the reporting period. In the Finance UI, this field value can be viewed in the Date field of the latest settled payment during the reporting period.

ValidDate – Validation date of the accounting entry

The ValidDate field represents the value of the CreatedDateTime field of the GeneralJournalEntry table record that is related to each reporting transaction. General ledger transactions are ordered by this date on the report of operating types. In the Finance UI, this field value can be viewed in the Created date and time field of general ledger transactions.

Montantdevise – Amount in currency

The Montantdevise field represents the value of the TransactionCurrencyAmount field of the GeneralJournalAccountEntry table record that is related to each reporting transaction. In the Finance UI, this field value can be viewed in the Amount in transaction currency field of general ledger transactions.

Idevise – Currency identifier

The Idevise field represents the value of the TransactionCurrencyCode field of the GeneralJournalAccountEntry table record that is related to each reporting transaction. In the Finance UI, this field value can be viewed in the Currency field of general ledger transactions.