# DW_GL_SLA_SUBLEDGER_LINKAGE_G

This table contains link between general ledger journals and subledger.

## Details

Module: General Ledger

## Key Columns

REF_AE_HEADER_ID, JOURNAL_LINE_NUM, TEMP_LINE_NUM, JOURNAL_HEADER_ID, AE_HEADER_ID, DISTRIBUTION_ID, APPLICATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
APPLICATION_ID | NUMBER | 38 | 0 | True | Functional area within a software suite of products. For example, Financials -Payables 200, Receivables 222. |  |
DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Transaction source distribution identifier. |  |
REF_AE_HEADER_ID | NUMBER | 38 | 0 | True | Reversed subledger journal entry header identifier. |  |
TEMP_LINE_NUM | NUMBER | 38 | 0 | True | Intermediary line number generated by the accounting engine when the entries are in most detail form. |  |
AE_HEADER_ID | NUMBER | 38 | 0 | True | Subledger journal entry identifier. |  |
JOURNAL_HEADER_ID | NUMBER | 38 | 0 | True | Journal entry header identifier. |  |
JOURNAL_LINE_NUM | NUMBER | 38 | 0 | True | Line number of the imported journal. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source Record Identifier. Values are derived by concatenating application identifier, distribution identifier, journal header identifier and journal line number. |  |
SUBLEDGER_FACT_NAME | VARCHAR2 | 64 |  |  | Subledger fact name. |  |
SUBLEDGER_GBL_CURR_FACT_NAME | VARCHAR2 | 64 |  |  | Subledger global currency fact name. |  |
SUBLEDGER_LINK_COLUMN | VARCHAR2 | 32 |  |  | Subledger linking column. |  |
LINKAGE_ID | NUMBER | 38 | 0 |  | Sub legder linkage identifier. |  |
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_HEADER_STATUS | VARCHAR2 | 16 |  |  | Journal entry header status. Values are from the table DW_GL_JOURNAL_STATUS_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. | DW_GL_JOURNAL_STATUS_LKP_TL | GL_JOURNAL_STATUS_LKP_CODE
JRNL_HDR_DFLT_EFFECTIVE_DATE | DATE |  |  |  | Journal entry default effective date |  |
JOURNAL_POSTED_DATE | DATE |  |  |  | Date when journal entry header was posted. |  |
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_REVERSAL_STATUS | VARCHAR2 | 16 |  |  | Reversed journal entry status code.Values are from the table DW_GL_JOURNAL_REV_STAT_LKP_TL with CODE_TYPE=JE_REVERSAL_STATUS. | DW_GL_JOURNAL_REV_STAT_LKP_TL | GL_JOURNAL_REV_STAT_LKP_CODE
JOURNAL_HEADER_CREATION_DATE | TIMESTAMP |  |  |  | Date and time of the creation of the journal header row |  |
JOURNAL_HEADER_CREATED_BY_ID | VARCHAR2 | 128 |  |  | Journal header created by user identifier | DW_USER_D | USERNAME
LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier | DW_LEDGER_D | LEDGER_ID
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_GL_JOURNAL_STATUS_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. | DW_GL_JOURNAL_STATUS_LKP_TL | GL_JOURNAL_STATUS_LKP_CODE
JOURNAL_LINE_CREATED_BY_ID | VARCHAR2 | 128 |  |  | Journal line created by user identifier | DW_USER_D | USERNAME
JOURNAL_BATCH_ID | NUMBER |  |  |  | Journal entry batch defining column. |  |
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. Possible values are V,R,I,A,J,Z. | DW_GL_BATCH_APP_STATUS_LKP_TL | GL_BATCH_APP_STATUS_LKP_CODE
JOURNAL_APPROVED_BY | VARCHAR2 | 128 |  |  | Defining column of the employee who submitted the journal batch for approval. |  |
JOURNAL_BATCH_DESCRIPTION | VARCHAR2 | 256 |  |  | Journal entry batch description. |  |
GL_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
GL_FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_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. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
ACCT_PERIOD_END_DATE | DATE |  |  |  | Accounting period end date. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
GL_SL_LINK_ID | NUMBER | 38 | 0 |  | Link to associated subledger data |  |
EVENT_TYPE_CODE | VARCHAR2 | 32 |  |  | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. |  |
EVENT_CLASS_CODE | VARCHAR2 | 32 |  |  | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. |  |
GL_TRANSFER_STATUS_CODE | VARCHAR2 | 32 |  |  | General Ledger transfer status code. |  |
GL_TRANSFER_DATE | DATE |  |  |  | Date when journal entry is transferred to general ledger. |  |
XLA_ACCOUNTING_DATE | DATE |  |  |  | Date used to determine the accounting period for transactions. |  |
XLA_CREATED_BY_USER_ID | VARCHAR2 | 128 |  |  | Indicates the user who created the row. |  |
XDL_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |

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