DW_EB_X_EBS_COMMON_W_GL_OTHER_GRPACCT_DAY_A
This table stores aggregated general ledger accounting transactions not already covered in AR, AP, Revenue,COGS and Tax facts. This table is an aggregate table of DW_EB_X_EBS_COMMON_W_GL_OTHER_F at day level and various other dimensions. These dimensions include group account, Company, Business Area Org etc.Records from DW_EB_X_EBS_COMMON_W_GL_OTHER_F are aggregated to day level and various other dimensions. For instance, all transactions for a given group account '1001' posted on December 23, 2006 are aggregated into one record. The aggregation is based on POSTED_ON_DT_WID field, which is the trasaction's posting date.Fields such as XACT_QTY indicates the transaction count of this particular aggregation record. For instanace, for the aggregation record of group account 1001, for the date December 23, 2006, the XACT_QTY indicates how many transactions posted on December 23, 2006.
Details
Module: Common Tables (EBS_COMMON)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| BALANCE_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | |||
| BUDGETARY_CONTROL_FLG | VARCHAR2 | 1 CHAR | ||||
| BUDGET_LEDGER_WID | NUMBER | 38 | ||||
| BUDGET_MCAL_CAL_WID | NUMBER | 38 | ||||
| BUDGET_PERIOD_WID | NUMBER | 38 | ||||
| BUDGET_WID | NUMBER | 38 | ||||
| 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 | ||
| COMPANY_ORG_WID | NUMBER | 38 | Key to the Company organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| 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, It is recommended that you define separate unique source IDs for each of your different source instances. | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/Credit Indicator | |||
| DOC_STATUS_WID | NUMBER | 38 | ||||
| FINANCIAL_GL_FLG | VARCHAR2 | 1 CHAR | ||||
| GL_DATASET_SEC_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_DATASET_SEC_D | |||
| GROUP_ACCT_WID | NUMBER | 38 | Group account key | DW_EB_X_EBS_COMMON_W_GL_GROUP_ACCOUNT_D | ||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local currency code | |||
| MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| POSTED_FLG | VARCHAR2 | 1 CHAR | Posted Flag | |||
| POSTED_ON_DT_WID | NUMBER | 38 | Posting Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PROFIT_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | |||
| 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. | |||
| UOM_CODE | VARCHAR2 | 50 CHAR | Unit of Measure | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| OTHER_GLOBAL1_AMT | NUMBER | Amount in group currency1 | ||||
| OTHER_GLOBAL2_AMT | NUMBER | Amount in group currency2 | ||||
| OTHER_GLOBAL3_AMT | NUMBER | Amount in group currency3 | ||||
| OTHER_LOC_AMT | NUMBER | Amount in local currency | ||||
| 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 |