DW_EB_X_EBS_FA_W_FA_BALANCE_F
No table description is available in the supplied metadata.
Details
Module: Fixed Assets (EBS_FA)
Business Name: Fixed Assets Balance
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 | ||||
| INTEGRATION_ID | VARCHAR2 | 320 CHAR | ||||
| ACC_DEPRN_DOC_AMT | NUMBER | 38,10 | ||||
| ACC_DEPRN_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| ACC_DEPRN_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| ACC_DEPRN_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| ACC_DEPRN_LOC_AMT | NUMBER | 38,10 | ||||
| ASSET_BOOK_WID | NUMBER | 38 | DW_EB_X_EBS_FA_W_ASSET_BOOK_D | |||
| ASSET_CATEGORY_WID | NUMBER | 38 | DW_EB_X_EBS_FA_W_ASSET_CATEGORY_D | |||
| ASSET_LOCATION_WID | NUMBER | 38 | DW_EB_X_EBS_FA_W_ASSET_LOCATION_D | |||
| ASSET_WID | NUMBER | 38 | DW_EB_X_EBS_FA_W_FIXED_ASSET_D | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| BALANCE_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D | |||
| CHANGED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | ||||
| COST_CENTER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | |||
| CREATED_BY_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_USER_D | |||
| CREATED_ON_DT | TIMESTAMP | 6 | ||||
| CURRENT_COST_DOC_AMT | NUMBER | 38,10 | ||||
| CURRENT_COST_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| CURRENT_COST_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| CURRENT_COST_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| CURRENT_COST_LOC_AMT | NUMBER | 38,10 | ||||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| DEPRN_ADJUSTMENT_DOC_AMT | NUMBER | 38,10 | ||||
| DEPRN_ADJUSTMENT_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| DEPRN_ADJUSTMENT_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| DEPRN_ADJUSTMENT_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| DEPRN_ADJUSTMENT_LOC_AMT | NUMBER | 38,10 | ||||
| DEPRN_DOC_AMT | NUMBER | 38,10 | ||||
| DEPRN_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| DEPRN_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| DEPRN_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| DEPRN_LOC_AMT | NUMBER | 38,10 | ||||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| EMPLOYEE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| ETL_PROC_WID | NUMBER | 38 | ||||
| FULLY_RETIRED_DT_WID | NUMBER | 38 | ||||
| GL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| INEFFECTIVE_DT_WID | NUMBER | 38 | ||||
| INTEGRATION_ID_TMP | VARCHAR2 | 320 CHAR | ||||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | ||||
| PROFIT_CENTER_WID | NUMBER | 38 | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| TOTAL_DEPRN_DOC_AMT | NUMBER | 38,10 | ||||
| TOTAL_DEPRN_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| TOTAL_DEPRN_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| TOTAL_DEPRN_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| TOTAL_DEPRN_LOC_AMT | NUMBER | 38,10 | ||||
| W_INSERT_DT | TIMESTAMP | 6 | ||||
| W_UPDATE_DT | TIMESTAMP | 6 | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| YTD_DEPRN_DOC_AMT | NUMBER | 38,10 | ||||
| YTD_DEPRN_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| YTD_DEPRN_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| YTD_DEPRN_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| YTD_DEPRN_LOC_AMT | NUMBER | 38,10 | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |