Oracle Fusion · Data dictionary
GL_JE_LINES
General LedgerUsed in 2 subject areas26 reporting columns
General Ledger (GL), journal lines. Debit/credit lines of each journal; the sum within a journal must net to zero.
Primary key: JE_HEADER_ID, JE_LINE_NUM
Joins (inferred from key columns): JE_HEADER_ID → GL_JE_HEADERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTED_CR | ● | Accounted cr. | |
| ACCOUNTED_DR | ● | Accounted dr. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CURRENCY_CONVERSION_DATE | ● | Currency conversion date. | |
| CURRENCY_CONVERSION_RATE | ● | Currency conversion rate. | |
| CURRENCY_CONVERSION_TYPE | ● | Type of currency conversion. | |
| DESCRIPTION | ● | Description. | |
| EFFECTIVE_DATE | ● | Effective date. | |
| ENTERED_CR | ● | Entered cr. | |
| ENTERED_DR | ● | Entered dr. | |
| JE_HEADER_ID | PK | ● | Identifier for the je header. |
| JE_LINE_NUM | PK | ● | Je line number. |
| LINE_TYPE_CODE | ● | Code identifying the line type. | |
| PERIOD_NAME | ● | Name of the period. | |
| REFERENCE_1 | ● | Reference 1. | |
| REFERENCE_10 | ● | Reference 10. | |
| REFERENCE_2 | ● | Reference 2. | |
| REFERENCE_3 | ● | Reference 3. | |
| REFERENCE_4 | ● | Reference 4. | |
| REFERENCE_5 | ● | Reference 5. | |
| REFERENCE_6 | ● | Reference 6. | |
| REFERENCE_7 | ● | Reference 7. | |
| REFERENCE_8 | ● | Reference 8. | |
| REFERENCE_9 | ● | Reference 9. | |
| STAT_AMOUNT | ● | Status amount. | |
| SUBLEDGER_DOC_SEQUENCE_VALUE | ● | Subledger doc sequence value. |
26 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to GL_JE_LINES.
- Cash to General Ledger Reconciliation Report
- Manual Subledger Journals Report
- Account Analysis Report
- Account Ledger by Account Greece Report
- China Account Analysis Detail Report
- France GL Extract for ETAFI Report
- GL Detail by Budget Center with Project Detail
- Greece Daily Journal Book - Line Descriptions Report
- Italian Journal Book Report
- Journal Voucher Report for China Secondary Ledger Report
- Libro Partitario Report
- Pending Transaction Detail Report
- Revaluation Report
- Vietnam Journal Voucher Report
- Yevmiye Defteri - Electronic
- Audit Report for France
- General Ledger Account Details Report
- Account Analysis for Contra Account Report
- Journals Report
- General Journals Report
- Journals Batch Summary Report
- Journals Details Report
- Journals Day Book Report
- Reconciled Transactions Report
- Unreconciled Transactions Report
- Journal and Transaction Details Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
Need the extract + dbt staging for GL_JE_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table