CFD_TCFDD_DEMAND_DEPOSIT_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
3 EFF_STRT_DATE TIMESTAMP 8
4 DPTS_PRDT_HOLDNG_ID BIGINT 8
5 SERV_CHRG_CALC_METH_ID BIGINT 8
6 SERV_CHRG_CALC_METH_CODE CHARACTER VARYING(10) 10
7 SERV_CHRG_WAIVER_ID BIGINT 8
8 SERV_CHRG_WAIVER_CODE CHARACTER VARYING(10) 10
9 SERV_CHRG_CYC_ID BIGINT 8
10 SERV_CHRG_CYC_CODE CHARACTER VARYING(10) 10
11 DR_INT_ID BIGINT 8
12 DR_INT_CODE CHARACTER VARYING(10) 10
13 DR_INT_PAY_CYC_ID BIGINT 8
14 DR_INT_PAY_CYC_CODE CHARACTER VARYING(10) 10
15 STMT_BRCH_ID BIGINT 8
16 STMT_BRCH_CODE CHARACTER VARYING(20) 20
17 PNDG_PACKAGE_CODE CHARACTER VARYING(10) 10
18 PACKAGE_ROLE_ID BIGINT 8
19 PACKAGE_ROLE_CODE CHARACTER VARYING(10) 10
20 OFFSET_ASSC_ACCT_NUM INTEGER 4
21 PNDG_OFFSET_DATE TIMESTAMP 8
22 PNDG_MTGE_OFFSET_FLG CHARACTER VARYING(3) 3
23 BUS_MTGE_OFFSET_ID BIGINT 8
24 BUS_MTGE_OFFSET_CODE CHARACTER VARYING(4) 4
25 WAIVE_CODE_EXPIRY_DATE TIMESTAMP 8
26 RESERVE_WAIVE_ID BIGINT 8
27 RESERVE_WAIVE_CODE CHARACTER VARYING(10) 10
28 RESERVE_WAIVE_CODE_EXPIRY_DATE TIMESTAMP 8
29 WRITE_OFF_AMT NUMERIC(18,6) 19
30 WRITE_OFF_RSN_ID BIGINT 8
31 WRITE_OFF_RSN_CODE CHARACTER VARYING(10) 10
32 DR_INT_WAIVE_ID BIGINT 8
33 DR_INT_WAIVE_CODE CHARACTER VARYING(10) 10
34 BAL_PSTG_TYP_ID BIGINT 8
35 BAL_PSTG_TYP_CODE CHARACTER VARYING(10) 10
36 ACRDTD_BRKR_ID BIGINT 8
37 ACRDTD_BRKR_CODE CHARACTER VARYING(20) 20
38 OD_SERV_FEE_WAIVE_APPLD_DATE TIMESTAMP 8
39 PROMOTIONAL_BONUS_INT_RT NUMERIC(18,6) 19
40 PROMOTIONAL_BONUS_STRT_DATE TIMESTAMP 8
41 PROMOTIONAL_BONUS_END_DATE TIMESTAMP 8
42 PROMOTIONAL_INT_RT_ID BIGINT 8
43 PROMOTIONAL_INT_RT_CODE CHARACTER VARYING(4) 4
44 ACCT_BAL_XS_DATE TIMESTAMP 8
45 EFF_END_DATE TIMESTAMP 8
46 SNPSHT_DATE TIMESTAMP 8
47 DATA_LOAD_DATE TIMESTAMP 8
48 SRC_SYS_ID CHARACTER VARYING(5) 5
49 LOAD_ID BIGINT 8
50 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
51 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
52 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
53 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
54 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8