OBP24_HST_FLX_IN_INTEREST_PLAN_ITEMS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_FLX_IN_INTEREST_PLAN_ITEMS

Columns
# Name Data Type Length
1 ARRANGEMENT_NUMBER CHARACTER VARYING(45) 45
2 EFFECTIVE_DATE TIMESTAMP 8
3 INTEREST_CLASS CHARACTER VARYING(50) 50
4 INTEREST_DIVISION CHARACTER VARYING(50) 50
5 PARTY_ID CHARACTER VARYING(40) 40
6 PRODUCT_ID CHARACTER VARYING(40) 40
7 INTEREST_RULE_ID CHARACTER VARYING(10) 10
8 PRODUCT_CLASS CHARACTER VARYING(50) 50
9 RULE_VERSION NUMERIC(10,3) 19
10 INTEREST_CCY CHARACTER VARYING(10) 10
11 INT_PROC_START_DATE TIMESTAMP 8
12 PREV_STAT_BEGIN_DATE TIMESTAMP 8
13 PREV_STAT_END_DATE TIMESTAMP 8
14 SETLMNT_STAT_INT_SETLD_AMT DOUBLE PRECISION 8
15 SETLMNT_STAT_SETLMNT_DATE TIMESTAMP 8
16 SETLMNT_STAT_NEXT_SETLMNT_DATE TIMESTAMP 8
17 SETLMNT_STAT_RND_PRE_TAX_AMT DOUBLE PRECISION 8
18 SETLMNT_STAT_RND_POST_TAX_AMT DOUBLE PRECISION 8
19 CAPTLZN_STAT_INT_CAPTLZD_AMT DOUBLE PRECISION 8
20 CAP_STAT_PRE_TAX_LST_DT_AMT DOUBLE PRECISION 8
21 CAPTLZN_STAT_LAST_CAP_DATE TIMESTAMP 8
22 CAPTLZN_STAT_NXT_SCHD_DATE TIMESTAMP 8
23 CAPTLZN_STAT_NXT_PROC_DATE TIMESTAMP 8
24 CAPTLZN_STAT_NXT_DUE_DATE TIMESTAMP 8
25 CAPTLZN_STAT_RND_PRE_TAX_AMT DOUBLE PRECISION 8
26 CAPTLZN_STAT_RND_POST_TAX_AMT DOUBLE PRECISION 8
27 CURR_STAT_BEGIN_DATE TIMESTAMP 8
28 CURR_STAT_END_DATE TIMESTAMP 8
29 CMP_STAT_INT_CMP_LST_DTE_AMT DOUBLE PRECISION 8
30 CMP_STAT_LST_CMP_DATE TIMESTAMP 8
31 CMP_STAT_LST_LOG_DATE TIMESTAMP 8
32 CMP_STAT_LST_CMP_FACT_AMT DOUBLE PRECISION 8
33 CMP_STAT_INT_CMP_PREV_DAY_AMT DOUBLE PRECISION 8
34 CMP_STAT_INT_CMP_PREV_MNTH_AMT DOUBLE PRECISION 8
35 ACCR_STAT_INT_ACRD_LST_DTE_AMT DOUBLE PRECISION 8
36 ACCR_STAT_PRE_TAX_LST_DT_AMT DOUBLE PRECISION 8
37 ACCR_STAT_INT_SUSPENDED_AMT DOUBLE PRECISION 8
38 ACCR_STAT_LST_ACCR_DATE TIMESTAMP 8
39 ACCR_STAT_NXT_SCHD_DATE TIMESTAMP 8
40 ACCR_STAT_NXT_PROC_DATE TIMESTAMP 8
41 ACCR_STAT_NXT_DUE_DATE TIMESTAMP 8
42 ACCR_STAT_UNRND_PRE_TAX_AMT DOUBLE PRECISION 8
43 ACCR_STAT_RND_PRE_TAX_AMT DOUBLE PRECISION 8
44 ACCR_STAT_RND_POST_TAX_AMT DOUBLE PRECISION 8
45 CMPND_STAT_LST_DT_AMT DOUBLE PRECISION 8
46 CMPND_STAT_PRE_TAX_LST_DT_AMT DOUBLE PRECISION 8
47 CMPND_STAT_LST_CMPND_DATE TIMESTAMP 8
48 CMPND_STAT_NXT_SCHD_DATE TIMESTAMP 8
49 CMPND_STAT_NXT_PROC_DATE TIMESTAMP 8
50 CMPND_STAT_NXT_DUE_DATE TIMESTAMP 8
51 CMPND_STAT_UNRND_PRE_TAX_AMT DOUBLE PRECISION 8
52 CMPND_STAT_RND_PRE_TAX_AMT DOUBLE PRECISION 8
53 CMPND_STAT_RND_POST_TAX_AMT DOUBLE PRECISION 8
54 ACCT_LVL_VRNC_CAPTLZN_FRQ_UNIT CHARACTER VARYING(50) 50
55 ACCT_LVL_VRNC_CAPTLZN_FRQ_TERM DOUBLE PRECISION 8
56 UNR_ADMIN_FEE_AMT DOUBLE PRECISION 8
57 UNR_ECONOMIC_AMT DOUBLE PRECISION 8
58 ACCR_STAT_AMT_ACCR_TILL_DATE DOUBLE PRECISION 8
59 ACCR_STAT_AMT_ACCR_MTD DOUBLE PRECISION 8
60 ACCR_STAT_AMT_ACCR_YTD DOUBLE PRECISION 8
61 ACCR_STAT_PERF_LAST_RFRSH_DATE TIMESTAMP 8
62 CMPND_STAT_AMT_CMPND_TILL_DATE DOUBLE PRECISION 8
63 CMPND_STAT_AMT_CMPND_MTD DOUBLE PRECISION 8
64 CMPND_STAT_AMT_CMPND_YTD DOUBLE PRECISION 8
65 CMPND_STAT_LAST_RFRSH_DATE TIMESTAMP 8
66 CAPTLZN_STAT_AMT_CAP_TILL_DATE DOUBLE PRECISION 8
67 CAPTLZN_STAT_AMT_CAP_MTD DOUBLE PRECISION 8
68 CAPTLZN_STAT_AMT_CAP_YTD DOUBLE PRECISION 8
69 CAPTLZN_STAT_LAST_RFRSH_DATE TIMESTAMP 8
70 SETLMNT_STAT_AMT_STL_TILL_DATE DOUBLE PRECISION 8
71 SETLMNT_STAT_AMT_STL_MTD DOUBLE PRECISION 8
72 SETLMNT_STAT_AMT_STL_YTD DOUBLE PRECISION 8
73 SETLMNT_STAT_LAST_RFRSH_DATE TIMESTAMP 8
74 ACCT_LVL_VRNC_FREQ_TYPE_CODE CHARACTER VARYING(50) 50
75 ACCT_LVL_VRNC_STD_FREQ_CODE CHARACTER VARYING(50) 50
76 ACCT_LVL_VRNC_ANNI_DAY_NUM DOUBLE PRECISION 8
77 ACCT_STATUS CHARACTER VARYING(50) 50
78 IS_SUSP_ACCT CHARACTER VARYING(1) 1
79 BRANCH_CODE CHARACTER VARYING(50) 50
80 HARDSHIP_RELIEF_BEGIN_DATE TIMESTAMP 8
81 HARDSHIP_RELIEF_END_DATE TIMESTAMP 8
82 INTEREST_HARDSHIP_RELEIF_TYPE CHARACTER VARYING(50) 50
83 FREQ_MODIFICATION_FLAG CHARACTER VARYING(1) 1
84 ACCT_OPENING_DATE TIMESTAMP 8
85 OFFSET_BENEFIT_FLAG CHARACTER VARYING(1) 1
86 STATUS_CHANGE_DATE TIMESTAMP 8
87 STOP_INTEREST_FLAG CHARACTER VARYING(1) 1
88 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
89 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
90 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
91 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8