FCT_BNK_COLLECTION_ACCOUNT_STATUS_MANAGEMENT_REPORT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DT 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 ACCOUNTS NUMERIC(18,2) 19
8 BALANCE_OD NUMERIC(38,2) 19
9 BALANCE_OS NUMERIC(38,2) 19
10 CURED_DURING_DAY NUMERIC(18,2) 19
11 ACTIONED_WITH_CONTACT NUMERIC(18,2) 19
12 ACTIONED_WITH_NO_CONTACT NUMERIC(18,2) 19
13 NO_ACTION NUMERIC(18,2) 19