FCT_OEB_BANK_GL_MEASURES_BALANCES_HIST_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SET_OF_BOOKS_ID | SMALLINT | 2 |
| 2 | CODE_COMBINATION_ID | BIGINT | 8 |
| 3 | ENTITY_CODE | CHARACTER VARYING(150) | 150 |
| 4 | COST_CENTRE_CODE | CHARACTER VARYING(150) | 150 |
| 5 | ACCOUNT_CODE | CHARACTER VARYING(150) | 150 |
| 6 | CATEGORY_CODE | CHARACTER VARYING(150) | 150 |
| 7 | STATE_CODE | CHARACTER VARYING(25) | 25 |
| 8 | PRODUCT_CODE | CHARACTER VARYING(150) | 150 |
| 9 | REMAPPED_PRODUCT_CODE | CHARACTER VARYING(150) | 150 |
| 10 | CLASS_CODE | CHARACTER VARYING(25) | 25 |
| 11 | CHANNEL_CODE | CHARACTER VARYING(25) | 25 |
| 12 | PROJECT_CODE | CHARACTER VARYING(25) | 25 |
| 13 | CURRENCY_CODE | CHARACTER VARYING(15) | 15 |
| 14 | INTERCOMPANY_CODE | CHARACTER VARYING(25) | 25 |
| 15 | SPARE_CODE | CHARACTER VARYING(25) | 25 |
| 16 | PERIOD_NAME | CHARACTER VARYING(15) | 15 |
| 17 | FIN_YEAR | SMALLINT | 2 |
| 18 | FIN_YEAR_LABEL | CHARACTER VARYING(4) | 4 |
| 19 | FIN_MONTH | BYTEINT | 1 |
| 20 | FIN_YEAR_MONTH | INTEGER | 4 |
| 21 | DAY_OF_FIN_YEAR | SMALLINT | 2 |
| 22 | DAYS_IN_FIN_YEAR | INTEGER | 4 |
| 23 | CAL_YEAR | SMALLINT | 2 |
| 24 | CAL_YEAR_LABEL | CHARACTER VARYING(4) | 4 |
| 25 | CAL_MONTH | BYTEINT | 1 |
| 26 | CAL_YEAR_MONTH | INTEGER | 4 |
| 27 | DAYS_IN_CAL_MONTH | BYTEINT | 1 |
| 28 | MTD_ACTUAL | NUMERIC(20,2) | 19 |
| 29 | YTD_ACTUAL | NUMERIC(20,2) | 19 |
| 30 | MTD_GROWTH | NUMERIC(21,2) | 19 |
| 31 | YTD_GROWTH | NUMERIC(38,2) | 19 |
| 32 | MTD_AVERAGE_BALANCE | NUMERIC(14,2) | 19 |
| 33 | YTD_AVERAGE_BALANCE | NUMERIC(14,2) | 19 |
| 34 | MTD_PMB | DOUBLE PRECISION | 8 |
| 35 | YTD_PMB | DOUBLE PRECISION | 8 |
| 36 | MTD_GROWTH_PMB | INTEGER | 4 |
| 37 | YTD_GROWTH_PMB | INTEGER | 4 |
| 38 | AVGBAL_MTD_PMB | INTEGER | 4 |
| 39 | AVGBAL_YTD_PMB | INTEGER | 4 |
| 40 | INSIGHT_CREATED_TIMESTAMP | TIMESTAMP | 8 |