This table contains information about journal entries and converted reporting currency.
Module: General Ledger
JOURNAL_LINE_NUM, JOURNAL_HEADER_ID
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. | ||||
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_CODE_VALUES_LKP_TL with CODE_TYPE=JOURNAL_CATEGORY. | DW_CODE_VALUES_LKP_TL | 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_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. | DW_CODE_VALUES_LKP_TL | 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_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. | DW_CODE_VALUES_LKP_TL | 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. | ||||
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Ledger currency code. | ||||
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date. | |||||
GLOBAL_CURRENCY_AMOUNT | BIGDECIMAL | 10 | Amount in global currency. | ||||
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_CODE_VALUES_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. | DW_CODE_VALUES_LKP_TL | CODE | ||
JOURNAL_APPROVAL_STATUS_CODE | VARCHAR2 | 16 | Journal entry batch approval status.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE='JE_BATCH_APPROVAL_STATUS'. | DW_CODE_VALUES_LKP_TL | 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_CODE_VALUES_LKP_TL | 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 base currency. | ||||
JOURNAL_LINE_ACCOUNTED_CR | BIGDECIMAL | 10 | Journal entry line credit amount in base currency. | ||||
JOURNAL_LINE_GLOBAL_DR | BIGDECIMAL | 10 | Journal entry line debit amount in global currency. | ||||
JOURNAL_LINE_GLOBAL_CR | BIGDECIMAL | 10 | Journal entry line credit amount in global currency. | ||||
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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.