CDI_MCFD_RB_TDA

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DPTS_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 PRDT_HOLDNG_ID BIGINT 8
5 CMPY_CODE CHARACTER VARYING(10) 10
6 PRDT_SYS_PRDT_CODE CHARACTER VARYING(20) 20
7 PRDT_SYS_ACCT_NUM CHARACTER VARYING(20) 20
8 PRDT_ID BIGINT 8
9 PRDT_GRP_CODE CHARACTER VARYING(20) 20
10 PRDT_TYP_CODE CHARACTER VARYING(20) 20
11 PRDT_DESC CHARACTER VARYING(100) 100
12 PRDT_SEGMENT_GRP_ID BIGINT 8
13 PRDT_SEGMENT_GRP_CODE CHARACTER VARYING(20) 20
14 PRDT_BRND_ID BIGINT 8
15 PRDT_BRND_CODE CHARACTER VARYING(20) 20
16 PRDT_BRND_DESC CHARACTER VARYING(50) 50
17 CHNL_ID BIGINT 8
18 CHNL_TYP_CODE CHARACTER VARYING(20) 20
19 CHNL_CODE CHARACTER VARYING(10) 10
20 CHNL_DESC CHARACTER VARYING(50) 50
21 SERV_BRCH_ID BIGINT 8
22 SERV_BRCH_CODE CHARACTER VARYING(20) 20
23 SERV_BRCH_DESC CHARACTER VARYING(300) 300
24 ACCT_STAT_ID BIGINT 8
25 ACCT_STAT_CODE CHARACTER VARYING(20) 20
26 ACCT_STAT_DESC CHARACTER VARYING(300) 300
27 INT_CALC_METH_ID BIGINT 8
28 INT_CALC_METH_CODE CHARACTER VARYING(20) 20
29 INT_CALC_METH_DESC CHARACTER VARYING(100) 100
30 INT_WAIVE_RSN_ID BIGINT 8
31 INT_WAIVE_RSN_CODE CHARACTER VARYING(20) 20
32 INT_WAIVE_RSN_DESC CHARACTER VARYING(100) 100
33 STMT_CYC_ID BIGINT 8
34 STMT_CYC_CODE CHARACTER VARYING(10) 10
35 STMT_CYC_DESC CHARACTER VARYING(100) 100
36 PAYT_METH_ID BIGINT 8
37 PAYT_METH_CODE CHARACTER VARYING(10) 10
38 PAYT_METH_DESC CHARACTER VARYING(50) 50
39 INT_PAY_CYC_ID BIGINT 8
40 INT_PAY_CYC_CODE CHARACTER VARYING(10) 10
41 INT_PAY_CYC_DESC CHARACTER VARYING(100) 100
42 CNTL_BRCH_ID BIGINT 8
43 CNTL_BRCH_CODE CHARACTER VARYING(20) 20
44 CNTL_BRCH_DESC CHARACTER VARYING(300) 300
45 SCND_OFCR_ID BIGINT 8
46 SCND_OFCR_CODE CHARACTER VARYING(20) 20
47 SCND_OFCR_DESC CHARACTER VARYING(100) 100
48 ANZSIC_TYP_ID BIGINT 8
49 ANZSIC_TYP_CODE CHARACTER VARYING(20) 20
50 ANZSIC_TYP_DESC CHARACTER VARYING(100) 100
51 DPTS_OPENING_DATE TIMESTAMP 8
52 DPTS_OPENING_AMT NUMERIC(18,6) 19
53 DPTS_CLSD_DATE TIMESTAMP 8
54 CLOSING_RSN_ID BIGINT 8
55 CLOSING_RSN_CODE CHARACTER VARYING(10) 10
56 CLOSING_RSN_DESC CHARACTER VARYING(100) 100
57 ORG_BRCH_ID BIGINT 8
58 ORG_BRCH_CODE CHARACTER VARYING(20) 20
59 ORG_BRCH_DESC CHARACTER VARYING(300) 300
60 COST_CENTRE_CODE CHARACTER VARYING(20) 20
61 BRKR_ID BIGINT 8
62 BRKR_CODE CHARACTER VARYING(10) 10
63 BRKR_DESC CHARACTER VARYING(300) 300
64 SALES_OFCR_ID BIGINT 8
65 SALES_OFCR_CODE CHARACTER VARYING(20) 20
66 SALES_OFCR_DESC CHARACTER VARYING(50) 50
67 APRVL_OFCR_ID BIGINT 8
68 APRVL_OFCR_CODE CHARACTER VARYING(10) 10
69 APRVL_OFCR_DESC CHARACTER VARYING(100) 100
70 PACKAGE_CODE CHARACTER VARYING(20) 20
71 TAX_WITHHOLDING_ID BIGINT 8
72 TAX_WITHHOLDING_CODE CHARACTER VARYING(4) 4
73 TAX_WITHHOLDING_DESC CHARACTER VARYING(100) 100
74 OVERDRAWN_DATE TIMESTAMP 8
75 EFF_STRT_DATE TIMESTAMP 8
76 EFF_END_DATE TIMESTAMP 8
77 DATA_LOAD_DATE TIMESTAMP 8
78 SNPSHT_DATE TIMESTAMP 8
79 SRC_SYS_ID CHARACTER VARYING(5) 5
80 LOAD_ID BIGINT 8
81 AGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
82 CRNT_ISS_DATE TIMESTAMP 8
83 CRNT_TEM_MAT_DATE TIMESTAMP 8
84 FINAL_MAT_DATE TIMESTAMP 8
85 AUTO_REN_CNT BIGINT 8
86 TIMES_RENEWED_CNT BIGINT 8
87 TRM_ID BIGINT 8
88 TRM_CODE CHARACTER VARYING(10) 10
89 TRM_DESC CHARACTER VARYING(50) 50
90 TRM_NO BIGINT 8
91 NGTBL_RT_IND CHARACTER VARYING(3) 3
92 POUT_METH_ID BIGINT 8
93 POUT_METH_CODE CHARACTER VARYING(10) 10
94 POUT_METH_DESC CHARACTER VARYING(50) 50
95 PRNCPL_MEDIA_ID BIGINT 8
96 PRNCPL_MEDIA_CODE CHARACTER VARYING(4) 4
97 PRNCPL_MEDIA_DESC CHARACTER VARYING(100) 100
98 REN_TYP_ID BIGINT 8
99 REN_TYP_CODE CHARACTER VARYING(10) 10
100 REN_TYP_DESC CHARACTER VARYING(100) 100
101 REN_PRDT_TYP_CODE CHARACTER VARYING(10) 10
102 REN_TRM_NUM BIGINT 8
103 REN_TRM_ID BIGINT 8
104 REN_TRM_CODE CHARACTER VARYING(10) 10
105 REN_TRM_DESC CHARACTER VARYING(50) 50
106 EFF_STRT_DATE_TRM_DTL TIMESTAMP 8
107 EFF_END_DATE_TRM_DTL TIMESTAMP 8
108 DATA_LOAD_DATE_TRM_DTL TIMESTAMP 8
109 SNPSHT_DATE_TRM_DTL TIMESTAMP 8
110 SRC_SYS_ID_TRM_DTL CHARACTER VARYING(5) 5
111 LOAD_ID_TRM_DTL BIGINT 8
112 AGGRESSIVE_LOAD_IND_TRM_DTL CHARACTER VARYING(3) 3
113 DATE_ID_DLY BIGINT 8
114 DLY_SNP_DATE TIMESTAMP 8
115 CRNT_ACCT_BAL_AMT NUMERIC(18,6) 19
116 TOT_INT_PAID_AMT NUMERIC(18,6) 19
117 LST_CYC_DATE TIMESTAMP 8
118 LST_STMT_DATE TIMESTAMP 8
119 LST_CUST_CNTCT_DATE TIMESTAMP 8
120 LST_CUST_WDL_DATE TIMESTAMP 8
121 TOT_CUST_DR_TXN_CNT BIGINT 8
122 TOT_PAPER_DR_TXN_CNT BIGINT 8
123 DATA_LOAD_DATE_DLY TIMESTAMP 8
124 SNPSHT_DATE_DLY TIMESTAMP 8
125 SRC_SYS_ID_DLY CHARACTER VARYING(5) 5
126 LOAD_ID_DLY BIGINT 8
127 AGGRESSIVE_LOAD_IND_DLY CHARACTER VARYING(3) 3
128 DATE_ID_MTHY BIGINT 8
129 MTHY_SNP_DATE TIMESTAMP 8
130 CRNT_ACCT_BAL_AMT_MTHY NUMERIC(18,6) 19
131 LST_CYC_DATE_MTHY TIMESTAMP 8
132 LST_STMT_DATE_MTHY TIMESTAMP 8
133 TOT_INT_PAID_AMT_MTHY NUMERIC(18,6) 19
134 OD_DATE TIMESTAMP 8
135 MTD_AGG_BAL_AMT NUMERIC(18,6) 19
136 MTD_AGG_DAY_CNT BIGINT 8
137 MTD_AVG_BAL_AMT NUMERIC(18,6) 19
138 MTD_INT_PAID_AMT NUMERIC(18,6) 19
139 MTD_ACRD_INT_AMT NUMERIC(18,6) 19
140 MTD_OVERDRAWN_AGG_BAL_AMT NUMERIC(18,6) 19
141 MTD_OVERDRAWN_AGG_DAY_CNT BIGINT 8
142 DATA_LOAD_DATE_MTHY TIMESTAMP 8
143 SNPSHT_DATE_MTHY TIMESTAMP 8
144 SRC_SYS_ID_MTHY CHARACTER VARYING(5) 5
145 LOAD_ID_MTHY BIGINT 8
146 AGGRESSIVE_LOAD_IND_MTHY CHARACTER VARYING(3) 3
147 MOF_FLAG CHARACTER VARYING(1) 1
148 MOF_START_DATE TIMESTAMP 8
149 MOF_END_DATE TIMESTAMP 8
150 PLEDGE_ACCT_INT_RT NUMERIC(18,6) 19
151 PLEDGE_ACCT_STRT_DATE TIMESTAMP 8
152 AVG_BAL_30_DAYS NUMERIC(18,6) 19
153 CNT_ATTACHED_PPL BIGINT 8
154 PLEDGE_ACCT_BAL_AMT NUMERIC(18,6) 19
155 TRM_DEPOSIT_SUB_TYP_CODE CHARACTER VARYING(3) 3
156 TRM_DEPOSIT_SUB_TYP_DESC CHARACTER VARYING(20) 20