FCT_BNK_COLLECTION_ARREARS_ACCOUNT_MANAGEMENT_REPORT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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