Oracle Fusion · Data dictionary
GL_JE_HEADERS
General LedgerUsed in 2 subject areas34 reporting columns
General Ledger (GL), journal headers. One row per journal entry; grouped into batches via GL_JE_BATCHES.
Primary key: JE_HEADER_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCRUAL_REV_FLAG | ● | Indicator (Y/N) for the accrual rev. | |
| ACTUAL_FLAG | ● | Indicator (Y/N) for the actual. | |
| BALANCING_SEGMENT_VALUE | ● | Balancing segment value. | |
| CLOSE_ACCT_SEQ_VALUE | ● | Close account seq value. | |
| CONTROL_TOTAL | ● | Control total. | |
| CONVERSION_FLAG | ● | Indicator (Y/N) for the conversion. | |
| CR_BAL_SEG_VALUE | ● | Cr balance segment value. | |
| 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. | |
| DATE_CREATED | ● | Date created. | |
| DEFAULT_EFFECTIVE_DATE | ● | Default effective date. | |
| DESCRIPTION | ● | Description. | |
| DOC_SEQUENCE_VALUE | ● | Doc sequence value. | |
| DR_BAL_SEG_VALUE | ● | Dr balance segment value. | |
| JE_FROM_SLA_FLAG | ● | Indicator (Y/N) for the je from sla. | |
| JE_HEADER_ID | PK | ● | Identifier for the je header. |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LOCAL_DOC_SEQUENCE_VALUE | ● | Local doc sequence value. | |
| MULTI_CURRENCY_FLAG | ● | Indicator (Y/N) for the multi currency. | |
| NAME | ● | Name. | |
| ORIGINATING_BAL_SEG_VALUE | ● | Originating balance segment value. | |
| PERIOD_NAME | ● | Name of the period. | |
| POSTED_DATE | ● | Posted date. | |
| POSTING_ACCT_SEQ_VALUE | ● | Posting account seq value. | |
| POST_MULTI_CURRENCY_FLAG | ● | Indicator (Y/N) for the post multi currency. | |
| REVERSED_JE_HEADER_ID | ● | Identifier for the reversed je header. | |
| RUNNING_TOTAL_ACCOUNTED_CR | ● | Running total accounted cr. | |
| RUNNING_TOTAL_ACCOUNTED_DR | ● | Running total accounted dr. | |
| RUNNING_TOTAL_CR | ● | Running total cr. | |
| RUNNING_TOTAL_DR | ● | Running total dr. | |
| STATUS | ● | Status. |
24 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_HEADERS.
- 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
- GL Journal Unposted Report
- Greece Daily Journal Book - Line Descriptions Report
- Italian Journal Book Report
- Journal Entry Reversal Detail 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
- Journals Report
- General Journals Report
- Journals Batch Summary Report
- Journals Details Report
- Journals Day Book 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_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table