MCFD_RB_RSV

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DPTS_PRDT_HOLDNG_ID INTEGER 4
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 PRDT_HOLDNG_ID INTEGER 4
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 INTEGER 4
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 INTEGER 4
15 PRDT_BRND_CODE CHARACTER VARYING(20) 20
16 PRDT_BRND_DESC CHARACTER VARYING(50) 50
17 CHNL_ID INTEGER 4
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 INTEGER 4
22 SERV_BRCH_CODE CHARACTER VARYING(20) 20
23 SERV_BRCH_DESC CHARACTER VARYING(300) 300
24 ACCT_STAT_ID INTEGER 4
25 ACCT_STAT_CODE CHARACTER VARYING(20) 20
26 ACCT_STAT_DESC CHARACTER VARYING(300) 300
27 INT_CALC_METH_ID INTEGER 4
28 INT_CALC_METH_CODE CHARACTER VARYING(20) 20
29 INT_CALC_METH_DESC CHARACTER VARYING(100) 100
30 INT_WAIVE_RSN_ID INTEGER 4
31 INT_WAIVE_RSN_CODE CHARACTER VARYING(20) 20
32 INT_WAIVE_RSN_DESC CHARACTER VARYING(100) 100
33 STMT_CYC_ID INTEGER 4
34 STMT_CYC_CODE CHARACTER VARYING(10) 10
35 STMT_CYC_DESC CHARACTER VARYING(100) 100
36 PAYT_METH_ID INTEGER 4
37 PAYT_METH_CODE CHARACTER VARYING(10) 10
38 PAYT_METH_DESC CHARACTER VARYING(50) 50
39 INT_PAY_CYC_ID INTEGER 4
40 INT_PAY_CYC_CODE CHARACTER VARYING(10) 10
41 INT_PAY_CYC_DESC CHARACTER VARYING(100) 100
42 CNTL_BRCH_ID INTEGER 4
43 CNTL_BRCH_CODE CHARACTER VARYING(20) 20
44 CNTL_BRCH_DESC CHARACTER VARYING(300) 300
45 SCND_OFCR_ID INTEGER 4
46 SCND_OFCR_CODE CHARACTER VARYING(20) 20
47 SCND_OFCR_DESC CHARACTER VARYING(100) 100
48 ANZSIC_TYP_ID INTEGER 4
49 ANZSIC_TYP_CODE CHARACTER VARYING(20) 20
50 ANZSIC_TYP_DESC CHARACTER VARYING(100) 100
51 DPTS_OPENING_DATE DATE 4
52 DPTS_OPENING_AMT NUMERIC(18,6) 19
53 DPTS_CLSD_DATE DATE 4
54 CLOSING_RSN_ID INTEGER 4
55 CLOSING_RSN_CODE CHARACTER VARYING(10) 10
56 CLOSING_RSN_DESC CHARACTER VARYING(100) 100
57 ORG_BRCH_ID INTEGER 4
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 INTEGER 4
62 BRKR_CODE CHARACTER VARYING(10) 10
63 BRKR_DESC CHARACTER VARYING(300) 300
64 SALES_OFCR_ID INTEGER 4
65 SALES_OFCR_CODE CHARACTER VARYING(20) 20
66 SALES_OFCR_DESC CHARACTER VARYING(50) 50
67 APRVL_OFCR_ID INTEGER 4
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 INTEGER 4
72 TAX_WITHHOLDING_CODE CHARACTER VARYING(4) 4
73 TAX_WITHHOLDING_DESC CHARACTER VARYING(100) 100
74 OVERDRAWN_DATE DATE 4
75 EFF_STRT_DATE DATE 4
76 EFF_END_DATE DATE 4
77 DATA_LOAD_DATE DATE 4
78 SNPSHT_DATE DATE 4
79 SRC_SYS_ID CHARACTER VARYING(5) 5
80 LOAD_ID INTEGER 4
81 AGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
82 CRNT_ISS_DATE DATE 4
83 CRNT_TEM_MAT_DATE DATE 4
84 FINAL_MAT_DATE DATE 4
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 DATE 4
107 EFF_END_DATE_TRM_DTL DATE 4
108 DATA_LOAD_DATE_TRM_DTL DATE 4
109 SNPSHT_DATE_TRM_DTL DATE 4
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 INTEGER 4
114 DLY_SNP_DATE DATE 4
115 CRNT_ACCT_BAL_AMT NUMERIC(18,6) 19
116 TOT_INT_PAID_AMT NUMERIC(18,6) 19
117 LST_CYC_DATE DATE 4
118 LST_STMT_DATE DATE 4
119 LST_CUST_CNTCT_DATE DATE 4
120 LST_CUST_WDL_DATE DATE 4
121 TOT_CUST_DR_TXN_CNT INTEGER 4
122 TOT_PAPER_DR_TXN_CNT INTEGER 4
123 DATA_LOAD_DATE_DLY DATE 4
124 SNPSHT_DATE_DLY DATE 4
125 SRC_SYS_ID_DLY CHARACTER VARYING(5) 5
126 LOAD_ID_DLY INTEGER 4
127 AGGRESSIVE_LOAD_IND_DLY CHARACTER VARYING(3) 3
128 DATE_ID_MTHY INTEGER 4
129 MTHY_SNP_DATE DATE 4
130 CRNT_ACCT_BAL_AMT_MTHY NUMERIC(18,6) 19
131 LST_CYC_DATE_MTHY DATE 4
132 LST_STMT_DATE_MTHY DATE 4
133 TOT_INT_PAID_AMT_MTHY NUMERIC(18,6) 19
134 OD_DATE DATE 4
135 MTD_AGG_BAL_AMT NUMERIC(18,6) 19
136 MTD_AGG_DAY_CNT INTEGER 4
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 INTEGER 4
142 DATA_LOAD_DATE_MTHY DATE 4
143 SNPSHT_DATE_MTHY DATE 4
144 SRC_SYS_ID_MTHY CHARACTER VARYING(5) 5
145 LOAD_ID_MTHY INTEGER 4
146 AGGRESSIVE_LOAD_IND_MTHY CHARACTER VARYING(3) 3
147 MOF_FLAG CHARACTER VARYING(1) 1
148 MOF_START_DATE DATE 4
149 MOF_END_DATE DATE 4
150 PLEDGE_ACCT_INT_RT NUMERIC(18,6) 19
151 PLEDGE_ACCT_STRT_DATE DATE 4
152 AVG_BAL_30_DAYS NUMERIC(38,10) 19
153 CNT_ATTACHED_PPL BIGINT 8
154 PLEDGE_ACCT_BAL_AMT NUMERIC(18,6) 19