DW_EB_X_EBS_COMMON_W_GL_OTHER_GRPACCT_FSCLPRD_A
No table description is available in the supplied metadata.
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 | Key to the Profit Center dimension | 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, Siebel recommends 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 | 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 | Key to the Multi-Calendars dimension | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| MCAL_PERIOD_WID | NUMBER | 38 | Key to the Multi-Calendar Period dimension | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| POSTED_FLG | VARCHAR2 | 1 CHAR | Posted Flag | |||
| 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 | 38,10 | Amount in global currency 1 | |||
| OTHER_GLOBAL2_AMT | NUMBER | 38,10 | Amount in global currency 2 | |||
| OTHER_GLOBAL3_AMT | NUMBER | 38,10 | Amount in global currency 3 | |||
| OTHER_LOC_AMT | NUMBER | 38,10 | 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 |