Structure of Dynamics 365 Finance data sources for the FEC

Статия
09/29/2023

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

Customers balance: Customers fiscal year opening balances annex
Vendors balance: Vendors fiscal year opening balances annex
Customers transactions: Customers transactions annex for a specified period
Vendors transactions: Vendors transactions annex for a specified period

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:

If the transaction originates from a ledger journal transaction, the value is collected from the Name field of the LedgerJournalName table.
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.
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:

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.
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.
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:

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.
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.
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:

The Text field of the GeneralJournalAccountEntry table record that is related to each reporting transaction.
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.
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:

If AccountingCurrencyAmount = 0 in the record that is related to the reporting transaction, this field represents the value of the IsCredit field of GeneralJournalAccountEntry.
If AccountingCurrencyAmount < 0 and IsCorrection = No, this field represents "C".
If AccountingCurrencyAmount > 0 and IsCorrection = Yes, this field represents "C".
In other cases where IsCredit = Yes and IsCorrection = Yes, this field represents "D".
In other cases where IsCredit = No and IsCorrection = No, this field represents "D".
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:

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.
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:

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.
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.

Споделяне чрез