CFD_TCFDD_OVERDRAFT_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OD_DETL_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 DPTS_PRDT_HOLDNG_ID BIGINT 8
5 PRDT_SRC_SYS_CODE CHARACTER VARYING(10) 10
6 SUB_PRDT_CODE CHARACTER VARYING(10) 10
7 OD_LIM_AMT NUMERIC(18,6) 19
8 OD_CLASS_ID BIGINT 8
9 OD_CLASS_CODE CHARACTER VARYING(10) 10
10 OD_TYP_ID BIGINT 8
11 OD_TYP_CODE CHARACTER VARYING(10) 10
12 OD_APPL_BRCH_ID BIGINT 8
13 OD_APPL_BRCH_CODE CHARACTER VARYING(20) 20
14 OD_STRT_DATE TIMESTAMP 8
15 OD_RVW_DATE TIMESTAMP 8
16 OD_LST_RVW_DATE TIMESTAMP 8
17 OD_LST_CYC_DATE TIMESTAMP 8
18 OD_DATE TIMESTAMP 8
19 OD_REF_DESC CHARACTER VARYING(50) 50
20 OD_JURISDICTION_STATE_CODE CHARACTER VARYING(10) 10
21 OD_REGULATED_FLG CHARACTER VARYING(4) 4
22 OD_NEGOTIATED_INT_FLG CHARACTER VARYING(4) 4
23 OD_NEGOTIATED_BASIS_PT NUMERIC(7,2) 19
24 OD_NEGOTIATED_INT_STRT_DATE TIMESTAMP 8
25 OD_SECURED_IND CHARACTER VARYING(10) 10
26 OD_PEAK_DEBT_AMT NUMERIC(18,6) 19
27 DR_INT_CYC_ID BIGINT 8
28 DR_INT_CYC_CODE CHARACTER VARYING(10) 10
29 DR_INT_TYP_ID BIGINT 8
30 DR_INT_TYP_CODE CHARACTER VARYING(10) 10
31 OD_INT_PAYT_METH_ID BIGINT 8
32 OD_INT_PAYT_METH_CODE CHARACTER VARYING(10) 10
33 OD_SERV_TYP_ID BIGINT 8
34 OD_SERV_TYP_CODE CHARACTER VARYING(10) 10
35 OD_SERV_CYC_ID BIGINT 8
36 OD_SERV_CYC_CODE CHARACTER VARYING(10) 10
37 OD_SERV_CHRG_WAIVE_ID BIGINT 8
38 OD_SERV_CHRG_WAIVE_CODE CHARACTER VARYING(10) 10
39 OD_TLRNC_AMT NUMERIC(18,6) 19
40 OD_SD_EXMPTN_AMT NUMERIC(18,6) 19
41 OD_OVERLIMIT_DATE TIMESTAMP 8
42 OD_MULTI_STATE_IND CHARACTER VARYING(10) 10
43 OD_SMILE_APPL_NUM BIGINT 8
44 OD_TRMINATION_DATE TIMESTAMP 8
45 OD_TRMINATION_RSN_ID BIGINT 8
46 OD_TRMINATION_RSN_CODE CHARACTER(18) 18
47 OD_INS_IND CHARACTER VARYING(10) 10
48 OD_SEC_TYP_ID BIGINT 8
49 OD_SEC_TYP_CODE CHARACTER VARYING(10) 10
50 OD_DOCUMENT_TYP_CODE CHARACTER VARYING(20) 20
51 OD_ANZSIC_CODE CHARACTER VARYING(10) 10
52 TEMP_OD_LIM_AMT NUMERIC(18,6) 19
53 TEMP_OD_EXPIRY_DATE TIMESTAMP 8
54 DR_INT_ID BIGINT 8
55 DR_INT_CODE CHARACTER VARYING(4) 4
56 DR_INT_RT_PCTAGE NUMERIC(18,6) 19
57 LOYALTY_MRGN_IND CHARACTER VARYING(4) 4
58 LOYALTY_MRGN_ELGBL_DATE TIMESTAMP 8
59 LOYALTY_TENURE_MONTHS BIGINT 8
60 LOYALTY_CONDUCT_MONTHS BIGINT 8
61 OD_LN_APPL_NUM BIGINT 8
62 OD_COLL_RSHIP_ID CHARACTER(18) 18
63 OD_COLL_RSHIP_CODE CHARACTER VARYING(10) 10
64 EFF_STRT_DATE TIMESTAMP 8
65 EFF_END_DATE TIMESTAMP 8
66 DATA_LOAD_DATE TIMESTAMP 8
67 SNPSHT_DATE TIMESTAMP 8
68 SRC_SYS_ID CHARACTER VARYING(5) 5
69 LOAD_ID BIGINT 8
70 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
71 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
72 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
73 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
74 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8