FCT_BNK_COLLECTION_ARREARS_ACCOUNT_MANAGEMENT_REPORT
Description
Target Objects (CTAS)
INSNZP05_BANK..FCT_BNK_COLLECTION_ARREARS_ACCOUNT_MANAGEMENT_REPORT_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PERIOD_DATE | TIMESTAMP | 8 |
| 2 | COLLECTION_CASE_TYPE | CHARACTER(12) | 12 |
| 3 | COLLECTION_CASE_TYPE_DESCRIPTION | CHARACTER VARYING(60) | 60 |
| 4 | COLLECTION_CASE_STATUS | CHARACTER(12) | 12 |
| 5 | COLLECTION_CASE_STATUS_DESCRIPTION | CHARACTER VARYING(60) | 60 |
| 6 | PRODUCT | CHARACTER VARYING(20) | 20 |
| 7 | DAYS_PAST_ACCOUNT_0_29 | BIGINT | 8 |
| 8 | DAYS_PAST_OD_0_29 | NUMERIC(38,16) | 19 |
| 9 | DAYS_PAST_OS_0_29 | NUMERIC(38,16) | 19 |
| 10 | DAYS_PAST_ACCOUNT_30_59 | BIGINT | 8 |
| 11 | DAYS_PAST_OD_30_59 | NUMERIC(38,16) | 19 |
| 12 | DAYS_PAST_OS_30_59 | NUMERIC(38,16) | 19 |
| 13 | DAYS_PAST_ACCOUNT_60_89 | BIGINT | 8 |
| 14 | DAYS_PAST_OD_60_89 | NUMERIC(38,16) | 19 |
| 15 | DAYS_PAST_OS_60_89 | NUMERIC(38,16) | 19 |
| 16 | DAYS_PAST_ACCOUNT_90_MORE | BIGINT | 8 |
| 17 | DAYS_PAST_OD_90_MORE | NUMERIC(18,2) | 19 |
| 18 | DAYS_PAST_OS_90_MORE | NUMERIC(18,2) | 19 |