DW_GL_SLA_SUBLEDGER_LINKAGE_G

This table contains link between general ledger journals and subledger.

Details

Module: General Ledger

Key Columns

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

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_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL 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_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_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_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_CODE_VALUES_LKP_TL with CODE_TYPE=GL_JOURNAL_STATUS. Possible values are U or P. DW_CODE_VALUES_LKP_TL 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_CODE_VALUES_LKP_TL with CODE_TYPE=JE_BATCH_APPROVAL_STATUS. Possible values are V,R,I,A,J,Z.    
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, 2024, Oracle and/or its affiliates.