FCT_OEB_GL_MEASURES_BALANCES_INSIGHT
Description
Synonyms
SDSNZP02_BANK..EFS_FCT_OEB_GL_MEASURES_BALANCES_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SET_OF_BOOKS_ID | BIGINT | 8 |
| 2 | ENTITY_CODE | CHARACTER VARYING(25) | 25 |
| 3 | COST_CENTRE_CODE | CHARACTER VARYING(25) | 25 |
| 4 | ACCOUNT_CODE | CHARACTER VARYING(25) | 25 |
| 5 | CATEGORY_CODE | CHARACTER VARYING(25) | 25 |
| 6 | STATE_CODE | CHARACTER VARYING(25) | 25 |
| 7 | PRODUCT_CODE | CHARACTER VARYING(25) | 25 |
| 8 | CLASS_CODE | CHARACTER VARYING(25) | 25 |
| 9 | CHANNEL_CODE | CHARACTER VARYING(25) | 25 |
| 10 | PROJECT_CODE | CHARACTER VARYING(25) | 25 |
| 11 | CURRENCY_CODE | CHARACTER VARYING(15) | 15 |
| 12 | INTERCOMPANY_CODE | CHARACTER VARYING(25) | 25 |
| 13 | SPARE_CODE | CHARACTER VARYING(25) | 25 |
| 14 | PERIOD_NAME | CHARACTER VARYING(200) | 200 |
| 15 | CAL_YEAR | BIGINT | 8 |
| 16 | CAL_YEAR_LABEL | CHARACTER VARYING(4) | 4 |
| 17 | CAL_MONTH | BIGINT | 8 |
| 18 | CAL_YEAR_MONTH | BIGINT | 8 |
| 19 | FIN_YEAR | BIGINT | 8 |
| 20 | FIN_YEAR_LABEL | CHARACTER VARYING(4) | 4 |
| 21 | FIN_MONTH | BIGINT | 8 |
| 22 | FIN_YEAR_MONTH | BIGINT | 8 |
| 23 | MTD_ACTUAL | DOUBLE PRECISION | 8 |
| 24 | MTD_PROJECTED_ACTUAL | DOUBLE PRECISION | 8 |
| 25 | MTD_BUDGET | DOUBLE PRECISION | 8 |
| 26 | MTD_FORECAST | DOUBLE PRECISION | 8 |
| 27 | YTD_ACTUAL | NUMERIC(38,2) | 19 |
| 28 | YTD_BUDGET | DOUBLE PRECISION | 8 |
| 29 | YTD_FORECAST | DOUBLE PRECISION | 8 |
| 30 | FY_ACTUAL | DOUBLE PRECISION | 8 |
| 31 | FY_PROJECTED_ACTUAL | DOUBLE PRECISION | 8 |
| 32 | FY_BUDGET | DOUBLE PRECISION | 8 |
| 33 | FY_FORECAST | DOUBLE PRECISION | 8 |
| 34 | PCP_MTD_ACTUAL | DOUBLE PRECISION | 8 |
| 35 | PCP_MTD_BUDGET | DOUBLE PRECISION | 8 |
| 36 | PCP_MTD_FORECAST | DOUBLE PRECISION | 8 |
| 37 | ORACLE_LAST_UPDATE_TIMESTAMP | TIMESTAMP | 8 |
| 38 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 39 | PCP_YTD_ACTUAL | NUMERIC(38,2) | 19 |
| 40 | PCP_YTD_BUDGET | DOUBLE PRECISION | 8 |
| 41 | PCP_YTD_FORECAST | DOUBLE PRECISION | 8 |
| 42 | MTD_BUDGET_VARIANCE | DOUBLE PRECISION | 8 |
| 43 | MTD_FORECAST_VARIANCE | DOUBLE PRECISION | 8 |
| 44 | YTD_BUDGET_VARIANCE | DOUBLE PRECISION | 8 |
| 45 | YTD_FORECAST_VARIANCE | DOUBLE PRECISION | 8 |
| 46 | FY_BUDGET_VARIANCE | DOUBLE PRECISION | 8 |
| 47 | FY_FORECAST_VARIANCE | DOUBLE PRECISION | 8 |
| 48 | PCP_MTD_ACTUAL_VARIANCE | DOUBLE PRECISION | 8 |
| 49 | PCP_YTD_ACTUAL_VARIANCE | NUMERIC(38,2) | 19 |