OBP24_FLX_TD_DEPOSIT_STATISTICS_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 DEPOSIT_ID DOUBLE PRECISION 8
3 TOTAL_TXN_NUM DOUBLE PRECISION 8
4 LAST_TXN_AMT DOUBLE PRECISION 8
5 LAST_TXN_AMT_CCY CHARACTER VARYING(3) 3
6 TOTAL_TXN_AMT_TO_DATE DOUBLE PRECISION 8
7 TOTAL_TXN_AMT_TO_DATE_CCY CHARACTER VARYING(3) 3
8 LAST_TXN_DATE TIMESTAMP 8
9 TOTAL_FEE_AMT DOUBLE PRECISION 8
10 TOTAL_FEE_CCY CHARACTER VARYING(3) 3
11 TOTAL_FEE_AMT_YTD DOUBLE PRECISION 8
12 TOTAL_FEE_AMT_YTD_CCY CHARACTER VARYING(3) 3
13 TOTAL_TAX_DEDUCTED_AMT DOUBLE PRECISION 8
14 TOT_TAX_DEDUCTED_AMT_CCY CHARACTER VARYING(3) 3
15 TOTAL_INT_PAID_AMT DOUBLE PRECISION 8
16 TOTAL_INT_PAID_CCY CHARACTER VARYING(3) 3
17 TOTAL_INT_PAID_AMT_YTD DOUBLE PRECISION 8
18 TOTAL_INT_PAID_YTD_CCY CHARACTER VARYING(3) 3
19 LAST_INT_PAID_DATE TIMESTAMP 8
20 LAST_INT_PAID_AMT DOUBLE PRECISION 8
21 LAST_INT_PAID_AMT_CCY CHARACTER VARYING(3) 3
22 REDEEM_PENALTY_AMT DOUBLE PRECISION 8
23 REDEEM_PENALTY_AMT_CCY CHARACTER VARYING(3) 3
24 TOTAL_PRINC_REDEEM_AMT DOUBLE PRECISION 8
25 TOTAL_PRINC_AMT_REDEEM_CCY CHARACTER VARYING(3) 3
26 TOTAL_INT_REDEEM_AMT DOUBLE PRECISION 8
27 TOTAL_INT_AMT_REDM_CCY CHARACTER VARYING(3) 3
28 TOTAL_REDEEM_PENALTY_AMT DOUBLE PRECISION 8
29 TOTAL_REDEEM_PENALTY_AMT_CCY CHARACTER VARYING(3) 3
30 TOTAL_REDEEM_AMT DOUBLE PRECISION 8
31 TOTAL_REDEEM_AMT_CCY CHARACTER VARYING(3) 3
32 LAST_REDEEMED_DATE TIMESTAMP 8
33 LAST_REDEEMED_AMT DOUBLE PRECISION 8
34 LAST_REDEEMED_AMT_CCY CHARACTER VARYING(3) 3
35 TOTAL_PRINC_PAID DOUBLE PRECISION 8
36 TOTAL_PRINC_PAID_CCY CHARACTER VARYING(3) 3
37 TOTAL_PRINC_PAID_YTD DOUBLE PRECISION 8
38 TOTAL_PRINC_PAID_YTD_CCY CHARACTER VARYING(3) 3
39 LAST_PRINC_PAID_DATE TIMESTAMP 8
40 LAST_PRINC_PAID_AMT DOUBLE PRECISION 8
41 LAST_PRINC_PAID_AMT_CCY CHARACTER VARYING(3) 3
42 LAST_PRINC_REDEEM_DATE TIMESTAMP 8
43 LAST_PRINC_REDEEM_AMT DOUBLE PRECISION 8
44 LAST_PRINC_REDEEMED_AMT_CCY CHARACTER VARYING(3) 3
45 LAST_INT_REDEEMED_DATE TIMESTAMP 8
46 LAST_INT_REDEEMED_AMT DOUBLE PRECISION 8
47 LAST_INT_REDEEMED_AMT_CCY CHARACTER VARYING(3) 3
48 VALUE_DATE TIMESTAMP 8
49 INTEREST_START_DATE TIMESTAMP 8
50 LAST_TRANSACTION_TYPE CHARACTER VARYING(40) 40
51 PAYIN_AMT DOUBLE PRECISION 8
52 PAYIN_AMT_CURR_ID CHARACTER VARYING(3) 3
53 LAST_TOP_UP_DATE TIMESTAMP 8
54 LAST_TOP_UP_AMT_CURR_ID CHARACTER VARYING(3) 3
55 LAST_TOP_UP_AMT DOUBLE PRECISION 8
56 TOT_TOP_UP_AMT_TODATE DOUBLE PRECISION 8
57 TOT_TOP_UP_AMT_TODATE_CURR_ID CHARACTER VARYING(3) 3
58 LAST_STMT_DATE TIMESTAMP 8
59 LAST_STMT_OPN_BAL_AMT DOUBLE PRECISION 8
60 LAST_STMT_OPN_BAL_CCY CHARACTER VARYING(3) 3
61 LAST_STMT_CLO_BAL_AMT DOUBLE PRECISION 8
62 LAST_STMT_CLO_BAL_CCY CHARACTER VARYING(3) 3
63 LAST_INT_CAP_AMT DOUBLE PRECISION 8
64 LAST_INT_CAP_CURR_ID CHARACTER VARYING(3) 3
65 TOT_INT_CAP_AMT DOUBLE PRECISION 8
66 TOT_INT_CAP_CURR_ID CHARACTER VARYING(3) 3
67 LAST_INT_CAP_DATE TIMESTAMP 8
68 LAST_INT_SETTL_AMT DOUBLE PRECISION 8
69 LAST_INT_SETTL_CURR_ID CHARACTER VARYING(3) 3
70 TOT_INT_SETTL_AMT DOUBLE PRECISION 8
71 TOT_INT_SETTL_CURR_ID CHARACTER VARYING(3) 3
72 LAST_INT_SETTL_DATE TIMESTAMP 8
73 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
74 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
75 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
76 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8