DW_EB_X_EBS_PR_W_GL_REVN_GRPACCT_FSCLPRD_A
This table stores General Ledger Group Account transactions for revenue.This table is an aggregate table of DW_EB_X_EBS_PR_W_GL_REVN_F at fiscal month level and various other dimensions. These dimensions include group account, Company, Business Area Org etc.Records from DW_EB_X_EBS_PR_W_GL_REVN_F are aggregated at fiscal month level and various REVN dimensions. For instance, all revenue transactions for a given group account '1001' posted in 1st fiscal month of fiscal year 2006 are aggregated into one record. The aggregation is based on POSTED_ON_DT_WID field of DW_EB_X_EBS_PR_W_GL_REVN_F, which is the trasaction's posting date.The fields POSTED_FROM_DT_WID and POSTED_TO_DT_WID indicates the fiscal month start date and fiscal month end date of this aggregation record.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 1st fical month of fiscal year 2006, the XACT_QTY indicates how many revenue transactions posted during the 1st fical month of fiscal year 2006.
Details
Module: Profitability (EBS_PR)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ACCT_DOC_TYPE_WID | NUMBER | 38 | ACCT_DOC_TYPE_WID | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the Profit Centers dimension | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_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 | ||
| COMPANY_ORG_WID | NUMBER | 38 | Key to the Company organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CUSTOMER_ACCNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | |||
| CUSTOMER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | 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. | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | Debit/Credit Indicator | |||
| 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 | Key to the Ledger dimension | 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 | |||
| MCAL_PERIOD_WID | NUMBER | 38 | Posting From Date key | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| POSTED_FLG | VARCHAR2 | 1 CHAR | Posted Flag | |||
| PRODUCT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PRODUCT_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. | |||
| REVENUE_GLOBAL1_AMT | NUMBER | 38,10 | Amount in group currency1 | |||
| REVENUE_GLOBAL2_AMT | NUMBER | 38,10 | Amount in group currency2 | |||
| REVENUE_GLOBAL3_AMT | NUMBER | 38,10 | Amount in group currency3 | |||
| REVENUE_LOC_AMT | NUMBER | 38,10 | ||||
| XACT_QTY | NUMBER | 28,10 | ||||
| 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 |