CFD_TCFDD_TRM_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 PRNCPL_ACCT_NUM NUMERIC(16,0) 19
6 INT_TYP_ID BIGINT 8
7 INT_TYP_CODE CHARACTER VARYING(4) 4
8 SERV_CHRG_WAIVER_ID BIGINT 8
9 SERV_CHRG_WAIVER_CODE CHARACTER VARYING(10) 10
10 SERV_CHRG_TYP_ID BIGINT 8
11 SERV_CHRG_TYP_CODE CHARACTER VARYING(10) 10
12 LOCN_CODE CHARACTER VARYING(10) 10
13 EFF_END_DATE TIMESTAMP 8
14 DATA_LOAD_DATE TIMESTAMP 8
15 SNPSHT_DATE TIMESTAMP 8
16 SRC_SYS_ID CHARACTER VARYING(5) 5
17 LOAD_ID BIGINT 8
18 AGGRESSIVE_LOAD_IND CHARACTER(18) 18
19 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
21 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8