FCT_OEB_BANK_GL_BALANCE_MEASURES_RRR_INSIGHT
Description
Synonyms
SDSNZP02_BANK..EFS_FCT_OEB_BANK_GL_BALANCE_MEASURES_RRR_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PERIOD_NAME_MONYY | CHARACTER VARYING(15) | 15 |
| 2 | PERIOD_NUM | BIGINT | 8 |
| 3 | PERIOD_NAME_YYYYP | CHARACTER VARYING(45) | 45 |
| 4 | PERIOD_YEAR | BIGINT | 8 |
| 5 | SET_OF_BOOKS_IDENTIFER | SMALLINT | 2 |
| 6 | ENTITY_CODE | CHARACTER VARYING(25) | 25 |
| 7 | INTERCOMPANY_CODE | CHARACTER VARYING(25) | 25 |
| 8 | ACCOUNT_CODE | CHARACTER VARYING(25) | 25 |
| 9 | CATEGORY_CODE | CHARACTER VARYING(25) | 25 |
| 10 | PRODUCT_CODE | CHARACTER VARYING(25) | 25 |
| 11 | COST_CENTRE_CODE | CHARACTER VARYING(25) | 25 |
| 12 | CODE_COMBINATION_ID | BIGINT | 8 |
| 13 | YEAR_OPEN_BALANCE | NUMERIC(25,2) | 19 |
| 14 | OPENING_BALANCE_AMOUNT | NUMERIC(25,2) | 19 |
| 15 | SIGNED_NET_AMOUNT | NUMERIC(38,2) | 19 |
| 16 | CLOSING_BALANCE_AMOUNT | NUMERIC(38,2) | 19 |
| 17 | YTD_DEBIT_AMOUNT | NUMERIC(38,2) | 19 |
| 18 | YTD_CREDIT_AMOUNT | NUMERIC(38,2) | 19 |
| 19 | CREDIT_AMOUNT | NUMERIC(38,2) | 19 |
| 20 | DEBIT_AMOUNT | NUMERIC(38,2) | 19 |
| 21 | CHANGED_DATE | TIMESTAMP | 8 |