DW_EB_X_EBS_COMMON_W_GL_OTHER_F
This fact table stores GL journal entries. It maintains exchange rates and amounts in document and local currencies
Details
Module: Common Tables (EBS_COMMON)
Business Name: General Ledger Journal Entries
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. | DW_EB_X_EBS_COMMON_W_GL_LINKAGE_INFORMATION_G | ||
| INTEGRATION_ID | VARCHAR2 | 320 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | DW_EB_X_EBS_COMMON_W_GL_LINKAGE_INFORMATION_G | ||
| ACCOUNT_REP_WID | NUMBER | 38 | Key to the Account representative in Business Contacts dimension | |||
| ACCT_DOC_NUM | VARCHAR2 | 30 CHAR | Accounting document number | |||
| ACCT_DOC_SUB_ITEM | NUMBER | 15 | Sub item within a line item of the accounting document | |||
| ACCT_PERIOD_END_DT_KEY | NUMBER | 10 | ||||
| ACCT_PERIOD_END_DT_WID | NUMBER | 38 | Accounting Period End Date key | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| ALLOCATION_NUM | VARCHAR2 | 30 CHAR | Allocation Number | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BALANCE_ID | VARCHAR2 | 320 CHAR | Balance ID | |||
| BALANCE_TYPE_WID | NUMBER | 38 | Key to the Balance Type domain | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the Balancing Segment dimension | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BANK_WID | NUMBER | 38 | Key to the Banks Dimension | |||
| BASELINE_DT_WID | NUMBER | 38 | Base line Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| BUDGETARY_CONTROL_FLG | VARCHAR2 | 1 CHAR | This flag indicates the record is for Public Sector. | |||
| BUDGET_ACCOUNT_WID | NUMBER | 38 | ||||
| BUDGET_LEDGER_WID | NUMBER | 38 | ||||
| BUDGET_MCAL_CAL_WID | NUMBER | 38 | ||||
| BUDGET_PERIOD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | |||
| BUDGET_SEGMENT10_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT1_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT2_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT3_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT4_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT5_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT6_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT7_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT8_WID | NUMBER | 38 | ||||
| BUDGET_SEGMENT9_WID | NUMBER | 38 | ||||
| BUDGET_TRANS_TYPE_INDICATOR | VARCHAR2 | 80 CHAR | ||||
| BUDGET_WID | NUMBER | 38 | Key to the Budget dimension | DW_EB_X_EBS_COMMON_W_BUDGET_D | ||
| BUDGT_ORG_WID | NUMBER | 38 | Key to the Business Organizations dimension for budgeting organization | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| BUSN_AREA_ORG_WID | NUMBER | 38 | Key to the Business Area Organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CLEARED_ON_DT_WID | NUMBER | 38 | Clearing Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CLEARING_DOC_DT_WID | NUMBER | 38 | Clearing Document Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CLEARING_DOC_ITEM | NUMBER | 15 | Clearing Document Item | |||
| CLEARING_DOC_NUM | VARCHAR2 | 30 CHAR | Clearing Document Number | |||
| CLRNG_DOC_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for the clearing document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| CLR_POST_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for type of posting of the clearing document | |||
| COMPANY_LOC_WID | NUMBER | 38 | Key to the Company location in Business Locations dimension | |||
| COMPANY_ORG_WID | NUMBER | 38 | Key to the Company organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CONVERSION_DT_WID | NUMBER | 38 | Conversion date key for currency exchange rate | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| COST_CENTER_WID | NUMBER | 38 | Key to the Cost Center dimension | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CTRL_AREA_ORG_WID | NUMBER | 38 | Key to the Controlling area organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CUSTOMER_BILL_TO_LOC_WID | NUMBER | 38 | Key to the Customer Locations dimension for the customer bill to location | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_CONTACT_WID | NUMBER | 38 | Key to the Customer Contacts dimension | DW_EB_X_EBS_COMMON_W_PARTY_PER_D | ||
| CUSTOMER_PAYER_LOC_WID | NUMBER | 38 | Key to the Customer Locations dimension for the customer payer location | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_SHIP_TO_LOC_WID | NUMBER | 38 | Key to the Customer Locations dimension for the customer ship to location | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_SOLD_TO_LOC_WID | NUMBER | 38 | Key to the Customer Locations dimension for the customer sold to location | DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D | ||
| CUSTOMER_WID | NUMBER | 38 | Key to the Customers dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| CUST_PUR_ORD_ITEM | NUMBER | 15 | Purchase Order Item of Customer | |||
| CUST_PUR_ORD_NUM | VARCHAR2 | 30 CHAR | Purchase Order Number of Customer | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/credit indicator | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the document currency. This typically is the currency in which the transaction occurred. Amounts will be stored in this currency. | |||
| DOC_STATUS_WID | NUMBER | 38 | Key to the Status dimension for document status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| DOC_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for the accounting document | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| ETL_PROC_WID | NUMBER | 38 | Oracle System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| EXCHANGE_DT | TIMESTAMP | 6 | ||||
| FED_BALANCE_ID | VARCHAR2 | 320 CHAR | Fed Balance ID | |||
| FINANCIAL_GL_FLG | VARCHAR2 | 1 CHAR | This flag indicates the record is for GL. | |||
| FIN_AREA_ORG_WID | NUMBER | 38 | Key to the Finance area organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| GLOBAL1_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the first Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the second Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the third Global Currency. The Global currencies are defined in global currency master table. | ||||
| GL_ACCOUNT_WID | NUMBER | 38 | Key to the GL Accounts dimension | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | ||
| GL_DATASET_SEC_WID | NUMBER | 38 | Key to the GL Data Set Security dimension | DW_EB_X_EBS_COMMON_W_GL_DATASET_SEC_D | ||
| GL_JOURNAL_DT | TIMESTAMP | 6 | ||||
| GL_RECONCILED_ON_DT | TIMESTAMP | 6 | Reconciled on Date | |||
| GL_RECONCILED_ON_PROC_WID | NUMBER | 38 | System field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| GL_SEGMENT10_WID | NUMBER | 38 | Key to the GL Segment dimension | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT1_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT2_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT3_WID | NUMBER | 38 | Key to the GL Segment dimension | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT4_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT5_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT6_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT7_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT8_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT9_WID | NUMBER | 38 | Key to the GL Segment dimension. | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| INVENTORY_PRODUCT_WID | NUMBER | 38 | Key to the Manufacturing Products dimension | |||
| INVOICED_ON_DT_WID | NUMBER | 38 | Invoice Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| INVOICE_RECEIPT_DT_WID | NUMBER | 38 | Invoice Receipt Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ISSUE_ORG_WID | NUMBER | 38 | Key to the Issue organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| JOURNAL_BATCH | VARCHAR2 | 255 CHAR | Journal Batch (Document Header Text) | |||
| JOURNAL_CATEGORY | VARCHAR2 | 30 CHAR | Journal Category | |||
| JOURNAL_HEADER | VARCHAR2 | 255 CHAR | Journal Header (Line Item Text) | |||
| JOURNAL_HEADER_DESCR | VARCHAR2 | 240 CHAR | ||||
| JOURNAL_LINE_DESCR | VARCHAR2 | 240 CHAR | ||||
| JOURNAL_LINE_NUM | NUMBER | 15 | Line number within the journal entry | |||
| JOURNAL_LINE_REFERENCE | VARCHAR2 | 30 CHAR | ||||
| JOURNAL_SOURCE_CODE | VARCHAR2 | 30 CHAR | Journal Source (Reference Document Number) | |||
| JOURNAL_SOURCE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_SOURCE_D | |||
| LEDGER_WID | NUMBER | 38 | Key to the Ledger dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the local currency. The local currency typically is the one in which the transaction will be posted to meet legal requirements for Company's Financial reporting. Alternatively, it may be linked to the currency used by local/regional business units for reporting purposes. | |||
| LOC_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the Local Currency. | ||||
| MCAL_CAL_WID | NUMBER | 38 | Key to the Multi-Calendars dimension | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | Key to the Natural Account dimension | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D | ||
| ORDERED_ON_DT_WID | NUMBER | 38 | Sales Order Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| OTHER_DOC_AMT | NUMBER | 32,6 | Amount in document currency | |||
| OTHER_LOC_AMT | NUMBER | 32,6 | Amount in local currency | |||
| PAYMENT_DUE_DT_WID | NUMBER | 38 | Payment Due Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PAYMENT_METHOD_WID | NUMBER | 38 | Key to the Payment methods in the Methods Dimension | DW_EB_X_EBS_COMMON_W_PAYMENT_METHOD_D | ||
| PAY_TERMS_WID | NUMBER | 38 | Key to the Payment terms in the Terms Dimension | DW_EB_X_EBS_COMMON_W_AP_TERMS_D | ||
| PLANNING_DT_WID | NUMBER | 38 | Planning Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PLANT_LOC_WID | NUMBER | 38 | Key to the Plant location in Business Locations dimension | |||
| POSTED_ON_DT_WID | NUMBER | 38 | Posting Date key | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| POSTED_ON_TM_WID | NUMBER | 38 | Posting Time key | W_TIME_OF_DAY_D | ||
| POSTING_TYPE_WID | NUMBER | 38 | Key to Transaction Types dimension for the type of posting of accounting document | |||
| PRODUCT_WID | NUMBER | 38 | Key to the Products dimension | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROFIT_CENTER_WID | NUMBER | 38 | Key to the Profit Center dimension | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | ||
| PURCH_INVOICE_ITEM | NUMBER | 15 | Purchase Invoice Item | |||
| PURCH_INVOICE_NUM | VARCHAR2 | 30 CHAR | Purchase Invoice Number | |||
| PURCH_ORDER_DT_WID | NUMBER | 38 | Purchase Order Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PURCH_ORDER_ITEM | NUMBER | 15 | Purchase Order Item | |||
| PURCH_ORDER_NUM | VARCHAR2 | 30 CHAR | Purchase Order Number | |||
| PURCH_ORG_WID | NUMBER | 38 | Key to the Purchase Organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PURCH_REP_WID | NUMBER | 38 | Key to the Purchase representative in Business Contacts dimension | |||
| RECON_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether the record is used for GL reconciliation. | |||
| REF_DOC_ITEM | NUMBER | 15 | Reference Document Item | |||
| REF_DOC_TYPE_WID | NUMBER | 38 | Key to Reference document type in Transaction Types dimension | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| SALES_GROUP_ORG_WID | NUMBER | 38 | Key to the Sales Group organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_INVOICE_ITEM | NUMBER | 15 | Invoice Document Item | |||
| SALES_INVOICE_NUM | VARCHAR2 | 30 CHAR | Invoice Document Number | |||
| SALES_OFC_LOC_WID | NUMBER | 38 | Key to the Sales Office location in Business Locations dimension | |||
| SALES_ORDER_ITEM | NUMBER | 15 | Sales Order Item | |||
| SALES_ORDER_NUM | VARCHAR2 | 30 CHAR | Sales Order Number | |||
| SALES_ORG_WID | NUMBER | 38 | Key to the Sales organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_PRODUCT_WID | NUMBER | 38 | Key to the Sales Products dimension | |||
| SALES_REP_WID | NUMBER | 38 | Key to the Sales representative in Business Contacts dimension | |||
| SALES_SCH_LINE | NUMBER | 15 | Sales Schedule Line Number | |||
| SEG_PROGRAM_WID | NUMBER | 38 | ||||
| SEG_PROJECT_WID | NUMBER | 38 | ||||
| SERVICE_REP_WID | NUMBER | 38 | Key to the Service representative in Business Contacts dimension | |||
| SPLR_ORDER_ITEM | NUMBER | 15 | Sales Order Item of Supplier | |||
| SPLR_ORDER_NUM | VARCHAR2 | 30 CHAR | Sales Order Number of Supplier | |||
| SUPPLIER_ACCOUNT_WID | NUMBER | 38 | Key to the Supplier Accounts dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SUPPLIER_ORDER_DT_WID | NUMBER | 38 | Suppliers Order Date Key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| SUPPLIER_PRODUCT_WID | NUMBER | 38 | Key to the Supplier Products dimension | |||
| SUPPLIER_WID | NUMBER | 38 | Key to the Suppliers dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| TAX_WID | NUMBER | 38 | Key to the Tax Types Dimension | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| TRANSACTION_DT_WID | NUMBER | 38 | Transaction Date key | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| TRANSACTION_TM_WID | NUMBER | 38 | Transaction Time key | W_TIME_OF_DAY_D | ||
| TREASURY_SYMBOL_WID | NUMBER | 38 | Key to the Treasury Symbol dimension | DW_EB_X_EBS_COMMON_W_TREASURY_SYMBOL_D | ||
| UOM_CODE | VARCHAR2 | 50 CHAR | Unit of Measure | |||
| XACT_QTY | NUMBER | 28,10 | Transaction Quantity | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |