FCT_BNK_TD_BREAKAGE_REASON_CODES_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
2 TRANSACTION_AMOUNT DOUBLE PRECISION 8
3 DEPOSIT_NUMBER DOUBLE PRECISION 8
4 EFFECTIVE_DATE TIMESTAMP 8
5 POSTING_DATE DATE 4
6 PRODUCT_DETAIL CHARACTER VARYING(120) 120
7 REGION CHARACTER VARYING(240) 240
8 BRANCH CHARACTER VARYING(10) 10
9 BRANCH_NAME CHARACTER VARYING(105) 105
10 INTEREST_RATE DOUBLE PRECISION 8
11 REDEMPTION_DATE DATE 4
12 PRIMARY_REASON_CODE CHARACTER VARYING(120) 120
13 SECONDARY_REASON_CODE CHARACTER VARYING(120) 120
14 USER_ID CHARACTER VARYING(50) 50
15 FEES DOUBLE PRECISION 8
16 ECONOMIC_COST DOUBLE PRECISION 8
17 REASON_COMMENTS CHARACTER VARYING(400) 400
18 TELLER_NAME CHARACTER VARYING(201) 201
19 TERM_YEARS DOUBLE PRECISION 8
20 TERM_MONTHS DOUBLE PRECISION 8
21 TERM_DAY DOUBLE PRECISION 8
22 WITHDRAWAL_APPROVAL CHARACTER(1) 1