DW_GL_SLA_SUBLEDGER_LINKAGE_G

This table contains link between general ledger journals and subledger.

Details

Module: General Ledger

Key Columns

DISTRIBUTION_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID, APPLICATION_ID, JOURNAL_HEADER_ID, JOURNAL_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     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.