DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D
Financial Resource dimension table holds expenditure types or event types, which are used to classify revenue and cost transactions. It contains expenditure type attributes like Expenditure Category, Revenue Category etc and event type attributes like Event Type Class , Revenue Category 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 to uniquely identify a record. | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel 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 | Siebel 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 | Siebel 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 | Siebel 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. | |||
| 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. | |||
| 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. | |||
| 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 | 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. | |||
| END_DATE_ACTIVE | TIMESTAMP | 6 | Last effective date of the financial resource type. | |||
| 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. | |||
| EVENT_TYPE_CLASS_CODE | VARCHAR2 | 50 CHAR | The classification of the event type to drive system processing of events of the event type | |||
| EVENT_TYPE_CLASS_NAME | VARCHAR2 | 255 CHAR | The name of the classification of the event type to drive system processing of events of the event type | |||
| EXPENDITURE_CATEGORY_CODE | VARCHAR2 | 50 CHAR | The expenditure category that classifies the expenditure type into a cost group. | |||
| EXPENDITURE_CATEGORY_NAME | VARCHAR2 | 255 CHAR | The name of expenditure category that classifies the expenditure type into a cost group | |||
| EXPENDITURE_SUBCATEGORY_CODE | VARCHAR2 | 50 CHAR | For future use | |||
| EXPENDITURE_SUBCATEGORY_NAME | VARCHAR2 | 255 CHAR | For future use | |||
| INTEGRATION_ID | VARCHAR2 | 80 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. | |||
| RESOURCE_TYPE_CODE | VARCHAR2 | 80 CHAR | Expenditure type OR Event type. | |||
| RESOURCE_TYPE_NAME | VARCHAR2 | 255 CHAR | Name of the expenditure type OR the event type. | |||
| REVENUE_CATEGORY_CODE | VARCHAR2 | 50 CHAR | The revenue category that classifies the expenditure type or the event type into a revenue group | |||
| REVENUE_CATEGORY_NAME | VARCHAR2 | 255 CHAR | The revenue category name that classifies the expenditure type or the event type into a revenue group | |||
| START_DATE_ACTIVE | TIMESTAMP | 6 | First effective date of the financial resource type. | |||
| 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. | |||
| UNIT_OF_MEASURE | VARCHAR2 | 30 CHAR | The unit by which to measure amounts entered for the expenditure type | |||
| W_RESOURCE_TYPE_CODE | VARCHAR2 | 80 CHAR | ||||
| W_REVENUE_CATEGORY_CODE | VARCHAR2 | 80 CHAR | ||||
| 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 |