FCT_BNK_BACKDATED_TD_REPORT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
2 DEPOSIT_NUMBER DOUBLE PRECISION 8
3 TRANSACTION_AMOUNT DOUBLE PRECISION 8
4 POSTING_DATE TIMESTAMP 8
5 EFFECTIVE_DATE TIMESTAMP 8
6 VARIANCE_IN_DAYS INTERVAL 12
7 PRODUCT_DETAIL CHARACTER VARYING(30) 30
8 REGION CHARACTER VARYING(240) 240
9 BRANCH_NBR CHARACTER VARYING(10) 10
10 BRANCH_ID CHARACTER VARYING(105) 105
11 INTEREST_RATE DOUBLE PRECISION 8
12 TERM_DEPOSIT_DURATION_YEARS DOUBLE PRECISION 8
13 TERM_DEPOSIT_DURATION_MONTHS DOUBLE PRECISION 8
14 TERM_DEPOSIT_DURATION_DAYS DOUBLE PRECISION 8
15 UDM_RATE DOUBLE PRECISION 8
16 UDM_REASON CHARACTER VARYING(120) 120
17 UDM_COMMENT CHARACTER VARYING(600) 600
18 BASE_RATE DOUBLE PRECISION 8
19 INTEREST_STAGE CHARACTER VARYING(128) 128
20 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
21 ACCOUNT_STATUS CHARACTER VARYING(40) 40
22 DEPOSIT_STATUS CHARACTER VARYING(40) 40
23 ACCOUNT_TITLE CHARACTER VARYING(500) 500
24 TELLER_ID CHARACTER VARYING(254) 254
25 ACCOUNT_OPENING_DATE TIMESTAMP 8