FCT_OBP_CL_TD_ACCOUNT_BALANCE_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 DEPOSIT_NUMBER DOUBLE PRECISION 8
4 ACCOUNT_OPENING_DATE TIMESTAMP 8
5 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
6 DEPOSIT_OPENING_DATE TIMESTAMP 8
7 DEPOSIT_CLOSURE_DATE TIMESTAMP 8
8 DEPOSIT_MATURITY_DATE TIMESTAMP 8
9 PRODUCT_CODE CHARACTER VARYING(30) 30
10 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
11 CREDIT_INT_RATE DOUBLE PRECISION 8
12 OFFER_ID CHARACTER VARYING(30) 30
13 BALANCE DOUBLE PRECISION 8
14 CURRENT_BALANCE DOUBLE PRECISION 8
15 CAPTIAL_BALANCE NUMERIC(1,0) 19
16 UNDRAWN_AMOUNT INTEGER 4
17 TOTAL_ARREARS_AMOUNT DOUBLE PRECISION 8
18 AVAILABLE_REDRAW_BALANCE INTEGER 4
19 MATURITY_AMOUNT DOUBLE PRECISION 8
20 INT_EXPENSE_ACCRUED_CTD DOUBLE PRECISION 8
21 CURRENCY_CODE CHARACTER VARYING(3) 3
22 NEXT_INT_PAYOUT_DATE TIMESTAMP 8
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4