DW_EB_X_EBS_COMMON_W_GL_OTHER_GRPACCOUNT_A_TMP
Temporary working table for general-ledger other group-account attributes.
Details
Module: Common Tables (EBS_COMMON)
Business Name: General Ledger Other Group Account Staging
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| TEMP_KEY | NUMBER | 38 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 38 CHAR | Identifier of the record in the source system. | |||
| BALANCE_TYPE_WID | NUMBER | 38 | ||||
| BALANCING_SEGMENT_WID | NUMBER | 38 | ||||
| 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 | ||||
| COMPANY_ORG_WID | NUMBER | 38 | ||||
| DATASOURCE_NUM_ID | NUMBER | 10 | Identifier of the source system from which the record was extracted. | |||
| DB_CR_IND | VARCHAR2 | 30 CHAR | ||||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| DOC_STATUS_WID | NUMBER | 38 | ||||
| FINANCIAL_GL_FLG | VARCHAR2 | 1 CHAR | ||||
| GL_DATASET_SEC_WID | NUMBER | 38 | ||||
| GROUP_ACCT_WID | NUMBER | 38 | ||||
| GRP_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| LEDGER_WID | NUMBER | 38 | ||||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| MCAL_CAL_WID | NUMBER | 38 | ||||
| OTHER_DOC_AMT | NUMBER | |||||
| OTHER_GLOBAL1_AMT | NUMBER | |||||
| OTHER_GLOBAL2_AMT | NUMBER | |||||
| OTHER_GLOBAL3_AMT | NUMBER | |||||
| OTHER_LOC_AMT | NUMBER | |||||
| POSTED_FLG | VARCHAR2 | 1 CHAR | ||||
| POSTED_ON_DT_WID | NUMBER | 38 | ||||
| PROFIT_CENTER_WID | NUMBER | 38 | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | Identifier of the tenant associated with the record. | |||
| UOM_CODE | VARCHAR2 | 50 CHAR | ||||
| XACT_QTY | NUMBER | 28,10 |