# DW_GL_JOURNAL_CF

This table contains information about actual & encumbrance journal entries and converted reporting currency.

## Details

Module: General Ledger

## Key Columns

JOURNAL_HEADER_ID, JOURNAL_LINE_NUM

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
JOURNAL_HEADER_ID | NUMBER | 38 | 0 | True | Journal entry header identifier. |  |
JOURNAL_LINE_NUM | NUMBER | 38 | 0 | True | Journal line number. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of journal entry header identifier and journal line number. |  |
ACTUAL_FLAG | VARCHAR2 | 16 |  |  | Actual or encumbrance flag |  |
ENCUMBRANCE_TYPE_ID | NUMBER | 38 | 0 |  | Encumbrance Type Identifier |  |
JOURNAL_BATCH_ID | NUMBER | 38 | 0 |  | Journal entry batch defining column. |  |
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
ACCT_PERIOD_START_DATE | DATE |  |  |  | Accounting period start date. |  |
ACCT_PERIOD_END_DATE | DATE |  |  |  | Accounting period end date. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
JOURNAL_BATCH_NAME | VARCHAR2 | 128 |  |  | User-defined journal batch name. |  |
JOURNAL_HEADER_NAME | VARCHAR2 | 128 |  |  | User-entered journal header name. |  |
JOURNAL_HEADER_DESCRIPTION | VARCHAR2 | 256 |  |  | User-entered journal header description. |  |
JOURNAL_BATCH_DESCRIPTION | VARCHAR2 | 256 |  |  | Journal entry batch description. |  |
JOURNAL_HEADER_STATUS | VARCHAR2 | 16 |  |  | Journal header status | DW_GL_JOURNAL_STATUS_LKP_TL | GL_JOURNAL_STATUS_LKP_CODE
JOURNAL_BATCH_STATUS | VARCHAR2 | 16 |  |  | Journal batch status | DW_GL_JOURNAL_STATUS_LKP_TL | GL_JOURNAL_STATUS_LKP_CODE
JOURNAL_POSTED_DATE | DATE |  |  |  | Date when journal entry header was posted. |  |
JOURNAL_HEADER_CREATION_DATE | TIMESTAMP |  |  |  | Date and time of the creation of the journal header row |  |
JRNL_HDR_DFLT_EFFECTIVE_DATE | DATE |  |  |  | Journal header effective date. |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier. | DW_LEDGER_D | LEDGER_ID
JOURNAL_CATEGORY | VARCHAR2 | 32 |  |  | Journal category code. Journal entry is assigned a journal entry category to identify its purpose. Values are from the table DW_JOURNAL_CATEGORY_LKP_TL with CODE_TYPE=JOURNAL_CATEGORY. | DW_JOURNAL_CATEGORY_LKP_TL | JOURNAL_CATEGORY_LKP_CODE
JOURNAL_SOURCE | VARCHAR2 | 32 |  |  | Journal source. Journal entry is assigned a source name to indicate how it was created. Values are from the table DW_JOURNAL_SOURCE_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. | DW_JOURNAL_SOURCE_LKP_TL | JOURNAL_SOURCE_LKP_CODE
JOURNAL_LINE_DESCRIPTION | VARCHAR2 | 256 |  |  | User-entered journal line description. |  |
JOURNAL_LINE_STATUS | VARCHAR2 | 16 |  |  | Journal entry line status. Values are from the table DW_JOURNAL_STATUS_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. | DW_JOURNAL_STATUS_LKP_TL | GL_JOURNAL_STATUS_LKP_CODE
DEBIT_CREDIT_IND | VARCHAR2 | 32 |  |  | Indicates debit or credit |  |
TRANSACTION_CURRENCY_AMOUNT | BIGDECIMAL |  | 10 |  | Amount in transaction currency. |  |
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Transaction currency code. |  |
LEDGER_CURRENCY_AMOUNT | BIGDECIMAL |  | 10 |  | Amount in ledger currency. This column is not populated for Statistical currency rows. |  |
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger currency code. |  |
CURRENCY_CONVERSION_DATE | DATE |  |  |  | Currency conversion date. |  |
GLOBAL_CURRENCY_AMOUNT | BIGDECIMAL |  | 10 |  | Amount in global currency. This column is not populated for Statistical currency rows. |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global currency code. |  |
GLOBAL_CURRENCY_EXCH_RATE | BIGDECIMAL |  | 10 |  | Ledger currency to global currency conversion rate. |  |
CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Account key flexfield combination identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
COST_CENTER_SEGMENT | VARCHAR2 | 32 |  |  | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 |  |  | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT | VARCHAR2 | 32 |  |  | Balancing segment. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 |  |  | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
JOURNAL_REVERSAL_STATUS | VARCHAR2 | 16 |  |  | Reversed journal entry status code.Values are from the table DW_JOURNAL_REV_STAT_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. | DW_JOURNAL_REV_STAT_LKP_TL | GL_JOURNAL_REV_STAT_LKP_CODE
JOURNAL_APPROVAL_STATUS_CODE | VARCHAR2 | 16 |  |  | Journal entry batch approval status.Values are from the table DW_GL_BATCH_APP_STATUS_LKP_TL with CODE_TYPE='JE_BATCH_APPROVAL_STATUS'. | DW_GL_BATCH_APP_STATUS_LKP_TL | GL_BATCH_APP_STATUS_LKP_CODE
JOURNAL_HEADER_CREATED_BY_ID | VARCHAR2 | 128 |  |  | Journal header created by user identifier | DW_USER_D | USERNAME
JOURNAL_HEADER_UPDATED_BY_ID | VARCHAR2 | 128 |  |  | Journal header updated by user identifier | DW_USER_D | USERNAME
JOURNAL_LINE_CREATED_BY_ID | VARCHAR2 | 128 |  |  | Journal line created by user identifier | DW_USER_D | USERNAME
JOURNAL_LINE_UPDATED_BY_ID | VARCHAR2 | 128 |  |  | Journal line updated by user identifier | DW_USER_D | USERNAME
JOURNAL_APPROVED_BY | VARCHAR2 | 128 |  |  | Defining column of the employee who submitted the journal batch for approval. |  |
LEDGER_CATEGORY_CODE | VARCHAR2 | 128 |  |  | Ledger category. | DW_INSERT_LEDGER_CAT_LKP_TL | INSERT_LEDGER_CAT_LKP_CODE
RELATIONSHIP_TYPE_CODE | VARCHAR2 | 32 |  |  | Relationship type code. |  |
JGZZ_RECON_REF | VARCHAR2 | 256 |  |  | Reconciliation reference. |  |
JOURNAL_LINE_ENTERED_DR | BIGDECIMAL |  | 10 |  | Journal entry line debit amount in entered currency. |  |
JOURNAL_LINE_ENTERED_CR | BIGDECIMAL |  | 10 |  | Journal entry line credit amount in entered currency. |  |
JOURNAL_LINE_ACCOUNTED_DR | BIGDECIMAL |  | 10 |  | Journal entry line debit amount in ledger currency. This column is not populated for Statistical currency rows. |  |
JOURNAL_LINE_ACCOUNTED_CR | BIGDECIMAL |  | 10 |  | Journal entry line credit amount in ledger currency. This column is not populated for Statistical currency rows. |  |
JOURNAL_LINE_GLOBAL_DR | BIGDECIMAL |  | 10 |  | Journal entry line debit amount in global currency. This column is not populated for Statistical currency rows. |  |
JOURNAL_LINE_GLOBAL_CR | BIGDECIMAL |  | 10 |  | Journal entry line credit amount in global currency. This column is not populated for Statistical currency rows. |  |
JRNL_LINE_EFFECTIVE_DATE | DATE |  |  |  | Journal entry line effective date. |  |
ACCOUNT_TYPE | VARCHAR2 | 16 |  |  | Account type |  |
ACCOUNT_FLAG | VARCHAR2 | 16 |  |  | BS or IS based on account type |  |
CONCAT_SEGMENTS | VARCHAR2 | 999 |  |  | Concatenated segments. |  |
JE_FROM_SLA_FLAG | VARCHAR2 | 16 |  |  | Journal propagated from subledger flag. |  |
JOURNAL_LINE_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
JOURNAL_HEADER_CREATION_DATE_1 | DATE |  |  |  | Date of the creation of the journal header row |  |
IS_POSTED_FLAG | VARCHAR2 | 16 |  |  | Flag to identify Posted Lines. |  |
JOURNAL_POSTED_DATETIME | TIMESTAMP |  |  |  | Date and Time of journal entry header was posted. |  |
ACCRUAL_REV_EFFECTIVE_DATE | DATE |  |  |  | Reversed journal entry effective date. |  |
ACCRUAL_REV_PERIOD_NAME | VARCHAR2 | 16 |  |  | Reversed journal entry reversal period. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.