GL_JE_HEADERS
GL_JE_HEADERS contains journal entries. There is a one-to-many relationship between journal entry batches and journal entries. Each row in this table includes the associated batch ID, the journal entry name and description, and other information about the journal entry. This table corresponds to the Journals window of the Enter Journals form. STATUS is 'U' for unposted and 'P' for posted. Other statuses indicate that an error condition was found. A complete list is below. CONVERSION_FLAG equal to 'N' indicates that you manually changed a converted amount in the Journal Entry Lines zone of a foreign currency journal entry. In this case, the posting program does not re-convert your foreign amounts. This can happen only if your user profile option MULTIPLE_RATES_PER_JE is 'Yes'. BALANCING_SEGMENT_VALUE is null if there is only one balancing segment value in your journal entry. If there is more than one, BALANCING_SEGMENT_VALUE is the greatest balancing segment value in your journal entry. Bad rounding account Reserved for country - specific functionality Reserved for country - specific functionality U -- Unposted P -- Posted 1 -- Invalid currency code 2 -- Invalid source 3 -- Invalid category 4 -- Invalid ledger 5 -- Invalid period name 6 -- (Actual) Unopened period 6 -- (Budget) Invalid budget version 6 -- (Encumbrance) Invalid encumbrance type 7 -- Invalid entry 8 -- Invalid entry A -- Code combination does not exist C -- Code combination: detail posting not allowed F -- Code combination not enabled G -- Invalid or inactive suspense account H -- Invalid or inactive reserve for encumbrance account J -- Code combination not yet valid on effective date K -- Unbalanced intercompany journal entry L -- Unbalanced journal entry by account category M -- Code combination past effective date N -- Intercompany processing error O -- Missing conversion rate to replicate journal V -- Multiple lines have code combination errors W -- Frozen budget X -- Frozen budget organization Y -- Frozen budget account Z -- Multiple lines have code combination errors - -- Invalid or inactive rounding differences account < -- Sequence assignment failed > -- Cutoff rule was violated + -- CTA account failed validation b -- No write access to generated ledger account d -- No write access to reporting currency/segment e -- Invalid segment in generated ledger account h -- Invalid account in chart of accounts mapping i -- Unable to determine journal effective date
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_JE_HEADERS_PK |
JE_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| JE_HEADER_ID | NUMBER | 18 | Yes | Journal entry header identifier. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier. Foreign key to GL_LEDGERS. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal Entity defining column. Foreign key to XLE_ENTITY_PROFILES. | |||
| JE_CATEGORY | VARCHAR2 | 25 | Yes | Journal category. Foreign key to GL_JE_CATEGORIES_B. | ||
| JE_SOURCE | VARCHAR2 | 25 | Yes | Journal source. Foreign key to GL_JE_SOURCES_B. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Accounting period type. Foreign key to GL_PERIODS. | ||
| NAME | VARCHAR2 | 100 | Yes | User entered journal header name. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Journal entry currency. Foreign key to FND_CURRENCIES_B. | |||
| STATUS | VARCHAR2 | 1 | Yes | Journal entry header status lookup code. | ||
| DATE_CREATED | DATE | Yes | Who column: indicates the date and time of the creation of the row. | |||
| ACCRUAL_REV_FLAG | VARCHAR2 | 1 | Yes | Whether or not the journal is average balances journal. | ||
| MULTI_BAL_SEG_FLAG | VARCHAR2 | 1 | Yes | Multiple balancing segment flag. | ||
| ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Balance type (Actual, Budget, or Encumbrance). | ||
| CONVERSION_FLAG | VARCHAR2 | 1 | Currency conversion flag on the journal header. | |||
| DEFAULT_EFFECTIVE_DATE | DATE | Yes | Journal entry default effective date. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Encumbrance type defining column. | |||
| BUDGET_VERSION_ID | NUMBER | 18 | Budget version defining column. | |||
| BALANCED_JE_FLAG | VARCHAR2 | 1 | Balanced journal entry flag. Valid values are Yes or No. | |||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | Key flexfield structure balancing segment value. | |||
| JE_BATCH_ID | NUMBER | 18 | Yes | Journal entry batch defining column. | ||
| FROM_RECURRING_HEADER_ID | NUMBER | 18 | Recurring batch header defining column. | |||
| EARLIEST_POSTABLE_DATE | DATE | Earliest date journal entry header can be posted. | ||||
| POSTED_DATE | DATE | Date journal entry header was posted. | ||||
| ACCRUAL_REV_EFFECTIVE_DATE | DATE | Reversed journal entry effective date. | ||||
| ACCRUAL_REV_PERIOD_NAME | VARCHAR2 | 15 | Reversed journal entry reversal period. | |||
| ACCRUAL_REV_STATUS | VARCHAR2 | 1 | Reversed journal entry status code. | |||
| ACCRUAL_REV_JE_HEADER_ID | NUMBER | 18 | Reversed journal entry defining column. | |||
| ACCRUAL_REV_CHANGE_SIGN_FLAG | VARCHAR2 | 1 | Type of reversal. Valid values are 'Change Sign' or 'Switch Debit/Credit'. | |||
| DESCRIPTION | VARCHAR2 | 240 | User entered description of the journal header. | |||
| CONTROL_TOTAL | NUMBER | Journal header control total column. | ||||
| RUNNING_TOTAL_DR | NUMBER | Journal entry running total debits, entered currency. | ||||
| RUNNING_TOTAL_CR | NUMBER | Journal entry running total credits, entered currency. | ||||
| RUNNING_TOTAL_ACCOUNTED_DR | NUMBER | Journal entry running total debits, base currency. | ||||
| RUNNING_TOTAL_ACCOUNTED_CR | NUMBER | Journal entry running total credits, base currency. | ||||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency exchange rate of journal. | ||||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency conversion type of journal. | |||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date of journal. | ||||
| EXTERNAL_REFERENCE | VARCHAR2 | 80 | Oracle internal use only. | |||
| REPLICATION_CODE | VARCHAR2 | 1 | Identifies the eligibility and status of the journal??s asynchronous replication to secondary ledgers. Valid values are blank for not needed, S for selected, I for in process, X for excluded by journal source and category inclusion rules or primary balancing segment value inclusion rules, and R for replicated. Valid values for replication errors are from lookup type MJE_BATCH_STATUS. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Journals (GL_JE_HEADERS) | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | |||
| ATTRIBUTE_CATEGORY2 | VARCHAR2 | 150 | Descriptive flexfield structure defining column. | |||
| DOC_SEQUENCE_ID | NUMBER | Sequential numbering sequence defining column. | ||||
| DOC_SEQUENCE_VALUE | NUMBER | Sequential numbering sequence value. | ||||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| TAX_STATUS_CODE | VARCHAR2 | 1 | Yes | Journal entry header tax status code. | ||
| PARENT_JE_HEADER_ID | NUMBER | 18 | Defining column of the parent journal entry in the source primary ledger. | |||
| REVERSED_JE_HEADER_ID | NUMBER | 18 | Defining column of the journal entry that is reversed by this journal entry. | |||
| ORIGINATING_BAL_SEG_VALUE | VARCHAR2 | 25 | Originating balancing segment value. | |||
| INTERCOMPANY_MODE | NUMBER | 18 | Intercompany mode for the journal. Valid values are 1 through 4. | |||
| DR_BAL_SEG_VALUE | VARCHAR2 | 25 | Balancing segment value used on the debit side of an intercompany journal. This column is meaningful only for intercompany modes 1 and 2. | |||
| CR_BAL_SEG_VALUE | VARCHAR2 | 25 | Balancing segment value used on the credit side of an intercompany journal. This column is meaningful only for intercompany modes 1 and 3. | |||
| REFERENCE_DATE | DATE | Additional date information entered by the user. | ||||
| LOCAL_DOC_SEQUENCE_ID | NUMBER | Sequential numbering sequence defining column for local requirement purposes. | ||||
| LOCAL_DOC_SEQUENCE_VALUE | NUMBER | Sequential numbering sequence value for local requirement purposes. | ||||
| DISPLAY_ALC_JOURNAL_FLAG | VARCHAR2 | 1 | Display reporting currency journal flag. | |||
| JE_FROM_SLA_FLAG | VARCHAR2 | 1 | Journal propagated from subledger flag. | |||
| POSTING_ACCT_SEQ_VERSION_ID | NUMBER | Posting account sequence version defining column. | ||||
| POSTING_ACCT_SEQ_ASSIGN_ID | NUMBER | Posting account sequence assignment defining column. | ||||
| POSTING_ACCT_SEQ_VALUE | NUMBER | Journal accounting sequence value. | ||||
| CLOSE_ACCT_SEQ_VERSION_ID | NUMBER | Close account sequence version defining column. | ||||
| CLOSE_ACCT_SEQ_ASSIGN_ID | NUMBER | Close account sequence assignment defining column. | ||||
| CLOSE_ACCT_SEQ_VALUE | NUMBER | Journal reporting sequence value. | ||||
| MULTI_CURRENCY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this journal contains multiple currencies. | ||
| TAX_LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier of tax legal entity. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| POST_MULTI_CURRENCY_FLAG | VARCHAR2 | 1 | Indicates multicurrency journals which is used in posting. | |||
| POST_CURRENCY_CODE | VARCHAR2 | 15 | Currency code which is used in posting for processing multicurrency journals. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which when combined with the period, determines the database partition in which this journal will be stored. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_JE_HEADERS | gl_ledgers | LEDGER_ID |
| GL_JE_HEADERS | gl_je_headers | PARENT_JE_HEADER_ID |
| GL_JE_HEADERS | gl_je_headers | REVERSED_JE_HEADER_ID |
| GL_JE_HEADERS | gl_je_batches | JE_BATCH_ID |
| GL_JE_HEADERS | gl_je_headers | ACCRUAL_REV_JE_HEADER_ID |
| GL_JE_HEADERS | gl_daily_conversion_types | CURRENCY_CONVERSION_TYPE |
| fun_trx_headers | gl_je_headers | PROVIDER_JE_HEADER_ID |
| fun_trx_headers | gl_je_headers | RECEIVER_JE_HEADER_ID |
| gl_je_headers | gl_je_headers | PARENT_JE_HEADER_ID |
| gl_je_headers | gl_je_headers | REVERSED_JE_HEADER_ID |
| gl_je_headers | gl_je_headers | ACCRUAL_REV_JE_HEADER_ID |
| jl_mx_je_lines_t | gl_je_headers | JE_HEADER_ID |
| gl_interface | gl_je_headers | JE_HEADER_ID |
| gl_je_error_codes | gl_je_headers | JE_HEADER_ID |
| gl_je_action_log | gl_je_headers | JE_HEADER_ID |
| gl_import_references | gl_je_headers | JE_HEADER_ID |
| gl_je_segment_values | gl_je_headers | JE_HEADER_ID |
| gl_interface_history | gl_je_headers | JE_HEADER_ID |
| gl_je_lines | gl_je_headers | JE_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_JE_HEADERS_N1 | Non Unique | Default | JE_BATCH_ID |
| GL_JE_HEADERS_N2 | Non Unique | Default | PERIOD_NAME, JE_CATEGORY |
| GL_JE_HEADERS_N3 | Non Unique | Default | DOC_SEQUENCE_VALUE, DOC_SEQUENCE_ID |
| GL_JE_HEADERS_N4 | Non Unique | Default | PARENT_JE_HEADER_ID |
| GL_JE_HEADERS_U1 | Unique | Default | JE_HEADER_ID |
| GL_JE_HEADERS_U2 | Unique | Default | NAME, JE_BATCH_ID |