This table contains link between general ledger journals and subledger.
Module: General Ledger
AE_HEADER_ID, REF_AE_HEADER_ID, DISTRIBUTION_ID, JOURNAL_HEADER_ID, JOURNAL_LINE_NUM, APPLICATION_ID, TEMP_LINE_NUM
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.