DW_GL_SLA_SUBLEDGER_LINKAGE_G

This table contains link between general ledger journals and subledger.

Details

Module: General Ledger

Key Columns

JOURNAL_HEADER_ID, APPLICATION_ID, TEMP_LINE_NUM, REF_AE_HEADER_ID, AE_HEADER_ID, JOURNAL_LINE_NUM, DISTRIBUTION_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.