DW_EB_X_EBS_COMMON_W_GL_GROUP_ACCOUNT_D
This dimension table is an aggregate dimension table aggregating from DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D table. The aggregation is based primarily on the GROUP_ACCOUNT_NUM field in DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D. This table is created primarily to allow fact data to be aggregated at GROUP_ACCONT_NUM level instead of at GL account level. GROUP_ACCOUNT_NUM denotes the nature GL accounts. Some of the seeded GROUP_ACCOUNT_NUM values are 'REVENUE', 'CASH', 'RET EARNING' Retained earning, 'ST BORR' short term borrowing, etc.
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 |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate key generated for the GL Group Account | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CHANGED_BY_WID | NUMBER | 38 | ||||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| CREATED_BY_WID | NUMBER | 38 | This column stores the date on which the record was inserted in the data warehouse table. | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| 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, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| 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. | |||
| FIN_STMT_ITEM_CODE | VARCHAR2 | 50 CHAR | The code which determines the nature of account (I.e. revenue,ap,ar etc) | |||
| GL_ACCOUNT_CAT_CODE | VARCHAR2 | 50 CHAR | This code which determines whether the account is Balance Sheet Account or Profit and Loss Account | |||
| GROUP_ACCOUNT_NUM | VARCHAR2 | 50 CHAR | Group account number (Hierarchical Attribute) | |||
| INTEGRATION_ID | VARCHAR2 | 200 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. | |||
| 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. | |||
| 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 |