FCT_BNK_CRHDS_REPO_ACCOUNT_DETAIL_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CASE_STATUS CHARACTER(12) 12
2 CASE_ID CHARACTER(10) 10
3 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
4 REPO_DATE CHARACTER VARYING(50) 50
5 REPO_ACCT_BAL CHARACTER VARYING(50) 50
6 WRITEOFF_VALUE NUMERIC(36,18) 19
7 WRITEOFF_DATE TIMESTAMP 8
8 BANKRUPT CHARACTER VARYING(5) 5
9 OUTSOURCE_DEBT CHARACTER VARYING(3) 3
10 OUTSOURCE_AGENCY CHARACTER VARYING(3) 3
11 OUTSOURCE_AMOUNT CHARACTER VARYING(50) 50
12 RECOVERED_DEBT CHARACTER VARYING(50) 50
13 RECOVERED_STILL_DUE NUMERIC(38,6) 19
14 RECOVERED_NOTES CHARACTER VARYING(1) 1
15 RECOVERED_CLOSE_DATE CHARACTER VARYING(50) 50