DW_EB_X_EBS_GL_W_ACCT_BUDGET_F
This fact table stores the budget data.
Details
Module: General Ledger (EBS_GL)
Business Name: Budget Fact
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, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| 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. | |||
| ADJUSTMENT_DOC_AMT | NUMBER | |||||
| ADJUSTMENT_LOC_AMT | 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. | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | Key to the Profit Center dimension | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | ||
| BUDGETARY_CONTROL_FLG | VARCHAR2 | 1 CHAR | ||||
| BUDGET_ACCOUNT_WID | NUMBER | 38 | ||||
| BUDGET_DOC_AMT | NUMBER | Budget Amount in document currency | ||||
| BUDGET_GRP_AMT | NUMBER | Budget Amount in group currency | ||||
| BUDGET_LEDGER_WID | NUMBER | 38 | Key to the Budget Ledger dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| BUDGET_LOC_AMT | NUMBER | Budget Amount in local currency | ||||
| 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_WID | NUMBER | 38 | Key to the Budget dimension | DW_EB_X_EBS_COMMON_W_BUDGET_D | ||
| BUDG_BUSN_AREA_ORG_WID | NUMBER | 38 | Key to the Business Area Organization in Business Organization dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| BUDG_CTRL_AREA_ORG_WID | NUMBER | 38 | Key to the Controlling Area Organization in Business Organization dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| BUDG_FIN_AREA_ORG_WID | NUMBER | 38 | Key to the Financial Area Organization in Business Organization dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CARRY_FORWARD_DOC_AMT | NUMBER | |||||
| CARRY_FORWARD_LOC_AMT | NUMBER | |||||
| 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. | |||
| COMPANY_ORG_WID | NUMBER | 38 | Key to the Company organization in Business Organizations dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_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. | |||
| 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. | |||
| 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. | |||
| FINANCIAL_GL_FLG | VARCHAR2 | 1 CHAR | ||||
| 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 | GL_DATASET_SEC_WID | DW_EB_X_EBS_COMMON_W_GL_DATASET_SEC_D | ||
| GL_SEGMENT10_WID | NUMBER | 38 | Key to the GL Segment 10 in GL Segment dimension | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GL_SEGMENT1_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT2_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT3_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT4_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT5_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT6_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT7_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT8_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | |||
| GL_SEGMENT9_WID | NUMBER | 38 | Key to the GL Segment 9 in GL Segment dimension | DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D | ||
| GRP_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the group currency. | |||
| 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. | |||
| 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 | DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D | |||
| PERIOD_BEGIN_DT_WID | NUMBER | 38 | Period Begin Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PERIOD_END_DT_KEY | NUMBER | 10 | ||||
| PERIOD_END_DT_WID | NUMBER | 38 | Period End Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| POSTED_ON_DT_WID | NUMBER | 38 | Posting Date key | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PRODUCT_WID | NUMBER | 38 | Key to the Products dimension | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROFIT_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | |||
| PROJECT_WID | NUMBER | 38 | Key to the Projects dimension | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| SEG_PROGRAM_WID | NUMBER | 38 | ||||
| SEG_PROJECT_WID | NUMBER | 38 | ||||
| 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 |