DW_EB_X_EBS_FA_W_FA_XACT_GRPACCT_FSCLPRD_A
No table description is available in the supplied metadata.
Details
Module: Fixed Assets (EBS_FA)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| 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 | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | BALANCING_SEGMENT_WID | |||
| COST_CENTER_WID | NUMBER | 38 | ||||
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| DB_CR_IND | VARCHAR2 | 30 CHAR | ||||
| DOC_STATUS_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_STATUS_D | |||
| DOC_TYPE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | |||
| EMPLOYEE_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | |||
| GROUP_ACCT_WID | NUMBER | 38 | ||||
| LEDGER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_LEDGER_D | |||
| MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| MCAL_PERIOD_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | |||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | ||||
| SUPPLIER_WID | NUMBER | 38 | ||||
| ETL_PROC_WID | NUMBER | 38 | ||||
| FA_GLOBAL1_AMT | NUMBER | 38,10 | ||||
| FA_GLOBAL2_AMT | NUMBER | 38,10 | ||||
| FA_GLOBAL3_AMT | NUMBER | 38,10 | ||||
| FA_LOC_AMT | NUMBER | 38,10 | ||||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | ||||
| POSTED_FLG | VARCHAR2 | 1 CHAR | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | ||||
| XACTS_COUNT | NUMBER | 10 | ||||
| XACT_UNITS | NUMBER | 10 | ||||
| X_CUSTOM | VARCHAR2 | 10 CHAR | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |