CFD_TCFDD_DEPOSIT_PLEDGE_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DPTS_PLEDGE_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 PLEDGE_ACCT_SEQ_NUM BIGINT 8
6 PLEDGE_INTNT_BNKING_TYP_ID BIGINT 8
7 PLEDGE_INTNT_BNKING_TYP_CD CHARACTER VARYING(20) 20
8 PLEDGE_ACCT_TRM_ID BIGINT 8
9 PLEDGE_ACCT_TRM_CODE CHARACTER VARYING(20) 20
10 PLEDGE_ACCT_TRM_NUM BIGINT 8
11 PLEDGE_ACCT_REN_TYP_ID BIGINT 8
12 PLEDGE_ACCT_REN_TYP_CODE CHARACTER VARYING(20) 20
13 PLEDGE_ACCT_BAL_AMT NUMERIC(18,6) 19
14 PLEDGE_ACCT_INT_RT NUMERIC(18,6) 19
15 PLEDGE_ACCT_STRT_DATE TIMESTAMP 8
16 PLEDGE_ACCT_END_DATE TIMESTAMP 8
17 PLEDGE_ACCT_REN_END_DATE TIMESTAMP 8
18 EFF_STRT_DATE TIMESTAMP 8
19 EFF_END_DATE TIMESTAMP 8
20 DATA_LOAD_DATE TIMESTAMP 8
21 SNPSHT_DATE TIMESTAMP 8
22 SRC_SYS_ID CHARACTER VARYING(5) 5
23 LOAD_ID BIGINT 8
24 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8