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