FCT_BNK_POLICING_TD_REPORT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 KEY_ACCOUNT CHARACTER VARYING(40) 40
2 DEPOSIT_NUMBER DOUBLE PRECISION 8
3 DATE_OPENED DATE 4
4 CC_L5_DESC CHARACTER VARYING(240) 240
5 CC_L6_DESC CHARACTER VARYING(240) 240
6 BRANCH_NAME CHARACTER VARYING(105) 105
7 ICC_INT_RATE DOUBLE PRECISION 8
8 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
9 TERM_YEARS DOUBLE PRECISION 8
10 TERM_MONTHS DOUBLE PRECISION 8
11 TERM_DAY DOUBLE PRECISION 8
12 UDM_RATE DOUBLE PRECISION 8
13 PRICING_ELEMENT_TYPE CHARACTER VARYING(20) 20
14 UDM_REASON CHARACTER VARYING(30) 30
15 UDM_REASON_DESC CHARACTER VARYING(120) 120
16 UDM_COMMENT CHARACTER VARYING(600) 600
17 BASE_RATE DOUBLE PRECISION 8
18 INTEREST_STAGE CHARACTER VARYING(128) 128
19 BALANCE DOUBLE PRECISION 8
20 MATURITY_DATE TIMESTAMP 8