DW_EB_X_EBS_COMMON_W_GL_LINKAGE_INFORMATION_G
This table is a helper table that acts as a bridge table to link General Ledger (GL) Journals in DW_EB_X_EBS_COMMON_W_GL_OTHER_F to sub-ledger transactions in sub-ledger fact tables DW_EB_X_EBS_AP_W_AP_XACT_F, DW_EB_X_EBS_AR_W_AR_XACT_F, DW_EB_X_EBS_PR_W_GL_COGS_F or DW_EB_X_EBS_PR_W_GL_REVN_F. It uses SOURCE_DISTRIBUTION_ID to join to the ACCT_DOC_ID in sub-ledger fact tables, and uses JOURNAL_LINE_INTEGRATION_ID to join the GL Journal table.
Details
Module: Common Tables (EBS_COMMON)
Business Name: General Ledger Linkage Information
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances. | |||
| INTEGRATION_ID | VARCHAR2 | 320 CHAR | Unique identifier of the GL linkage information. | |||
| JOURNAL_LINE_INTEGRATION_ID | VARCHAR2 | 80 CHAR | Identifier for a journal line. Joins to the INTEGRATION_ID in GL fact table DW_EB_X_EBS_COMMON_W_GL_OTHER_F | |||
| LEDGER_ID | VARCHAR2 | 80 CHAR | Identifies the ledger the journal is posted to. | |||
| POSTED_ON_DT | TIMESTAMP | 6 | Period End Date to which the journal is posted to | |||
| DB_CR_IND | VARCHAR2 | 10 CHAR | Debit / credit indicator | |||
| DISTRIBUTION_CATEGORY_CODE | VARCHAR2 | 80 CHAR | Source domain to identify subledger distribution categories. | |||
| DISTRIBUTION_SOURCE | VARCHAR2 | 10 CHAR | Identifies the source system that generated the journal. Possible values are: AP, AR, COGS | |||
| GL_ACCOUNT_ID | VARCHAR2 | 240 CHAR | Identifies the GL Account | |||
| GL_STATUS_WID | NUMBER | 38 | Identifies GL statuses (Posted / Unposted / Accounted). | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| JE_BATCH_NAME | VARCHAR2 | 100 CHAR | A name of the batch of the GL journal entry | |||
| JE_HEADER_NAME | VARCHAR2 | 100 CHAR | The journal header name | |||
| JE_LINE_NUM | NUMBER | 15 | The line number of the Journal line | |||
| LEDGER_TYPE | VARCHAR2 | 1 CHAR | Identifies if the ledger is a primary, secondary or reporting currency ledger | |||
| OVERRIDE_LINE_TYPE | VARCHAR2 | 30 CHAR | ||||
| RECON_FLG | VARCHAR2 | 1 CHAR | The flag indicates that the record participates in the GL reconciliation process. | |||
| SLA_TRX_INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of subledger accounting entries.. | |||
| SOURCE_DISTRIBUTION_ID | VARCHAR2 | 320 CHAR | Identifier for a source/subledger transaction distribution. Joins to the ACCT_DOC_ID in subledger fact tables. | |||
| W_DISTRIBUTION_CATEGORY_CODE | VARCHAR2 | 80 CHAR | Warehouse domain to identify subledger distribution categories. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Column used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |