Understanding Mapping of Fields in the FEC Extractor Output with the JD Edwards EnterpriseOne System
This section contains a list of the fields in the FEC Extractor Output generated through the BIP functionality, mapped with the tables in the JD Edwards EnterpriseOne General Accounting system.
# |
Data Element Description |
JDE EnterpriseOne Source |
TXT Field Name |
Type of Field |
|---|---|---|---|---|
1 |
Journal entry code |
F0911.GLICUT - Batch Type |
JournalCode |
Alphanumeric |
2 |
Journal entry label/name |
Batch Type Description (Description of UDC 98/IT) |
JournalLib |
Alphanumeric |
3 |
Number of the accounting entry (in chronological and sequential numbering) |
If ordered by Date: GLREG# If ordered by Journal Code: GLICUT + GLREG# |
ErictureNum |
Alphanumeric |
4 |
Accounting date |
GL Date (DGJ) |
ErictureDate |
Date |
5 |
Account number, which refers to the appropriate French accounting terminology - the first three characters must meet the French accounting standard |
GLANI or F0901.R021, F0901.R022, F0901.R023 Account Number will be either retrieved from natural account (F0911.ANI) or from Category Code 21, 22 or 23 of the account (F0901.R021, F0901.R022, F0901.R023) depending on the French Chart of Accounts Processing Option setup. |
CompteNum |
Alphanumeric |
6 |
Account heading under the French Accounting Number |
F0911.ANI description (from F0901.DL01) or description of the corresponding Category Code (from UDC 09/21, 09/22 or 09/23). |
CompteLib |
Alphanumeric |
7 |
Subsidiary ledger account number (field must be left empty if not used) |
F0911.AN8 |
CompAuxNum |
Alphanumeric |
8 |
Subsidiary ledger account heading (field must be left empty if not used) |
AN8 Description (from F0101.ALPH) or F0111.WWMLNM (depending on PO) |
CompAuxLib |
Alphanumeric |
9 |
Reference of the relevant supporting document |
If extraction mode = blank (sequence number generated): ICUT + ICU + KCO + DCT+DOC If extraction mode = 1 (order by DOC DCT without sequential number generated): ICUT + ICU + KCO + DOC+DCT |
PieceRef |
Alphanumeric |
10 |
Date of the relevant supporting document |
Invoice Date (GLIDV) whenever this field has a value. And if GLIDV is blank, we'll retrieve the GL Date (GLDGJ) |
Piecedate |
Date |
11 |
Label of the accounting entry |
Explanation Alpha Name + Explanation Remark (GLEXA + GLEXR) |
ErictureLib |
Alphanumeric |
12 |
Debit amount |
Amount (GLAA) if sign = + |
Debit |
Numeric |
13 |
Credit Amount |
Amount (GLAA) if sign = - |
Credit |
Numeric |
14 |
Lettering/Marking of the accounting entry (field must be left empty if not used) |
Reconciliation code(GLRCND) + Reconciliation Number/Reference 3 (GLR3) |
ErictureLet |
Alphanumeric |
15 |
Lettering date (kept blank if unused) |
Check Cleared Date (GLDKC) |
Datelet |
Date |
16 |
Validation date for the journal entry |
GL Date (GLDGJ) |
ValidDate |
Date |
17 |
Amount in currency (blank if unused) |
Amount-Currency (GLACR) |
Montantdevise |
Numeric |
18 |
Identifying code the currency (leave blank if none used) |
Currency Code (GLCRCD) if GLCRCD is different from GLBRCD, if not Blank. |
Idevise |
Alphanumeric |