CFD_TCFDD_CARD_DETAIL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 CRD_CMPY_CODE CHARACTER VARYING(20) 20
3 CRD_NUM CHARACTER VARYING(20) 20
4 CRD_PRDT_CODE CHARACTER VARYING(20) 20
5 EFF_STRT_DATE TIMESTAMP 8
6 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
7 CNTL_ACCT_CMPY_CODE CHARACTER VARYING(20) 20
8 CNTL_ACCT_NUM CHARACTER VARYING(20) 20
9 CNTL_ACCT_PRDT_CODE CHARACTER VARYING(20) 20
10 PRIM_REL_ACCT_CMPY_CODE CHARACTER VARYING(20) 20
11 PRIM_REL_ACCT_NUM CHARACTER VARYING(30) 30
12 PRIM_REL_ACCT_PRDT_CODE CHARACTER VARYING(20) 20
13 CRD_CRNT_STAT_CODE CHARACTER VARYING(10) 10
14 CNTL_ACCT_STAT_CODE CHARACTER VARYING(10) 10
15 CRD_TYP_CODE CHARACTER VARYING(10) 10
16 CRD_OPEN_DATE TIMESTAMP 8
17 CRD_CLOSE_DATE TIMESTAMP 8
18 CRD_VALID_FROM_DATE TIMESTAMP 8
19 CRD_EXPIRY_DATE TIMESTAMP 8
20 CRD_LST_ISS_DATE TIMESTAMP 8
21 EMP_IND CHARACTER VARYING(3) 3
22 CNTL_ACCT_IND CHARACTER VARYING(3) 3
23 LST_TXN_DATE TIMESTAMP 8
24 TFR_EFF_DATE TIMESTAMP 8
25 CRD_BLOCKED_CODE CHARACTER VARYING(10) 10
26 CRD_SUB_CLASS_CODE CHARACTER VARYING(10) 10
27 CRD_PLAS_ACTV_DATE TIMESTAMP 8
28 CRD_REWARD_LVL_CODE CHARACTER VARYING(10) 10
29 CRD_REWARD_TYP_CODE CHARACTER VARYING(10) 10
30 CRD_REWARD_STRT_DATE TIMESTAMP 8
31 LST_REWARD_LVL_CHG_DATE TIMESTAMP 8
32 CRD_REWARD_CLOSE_DATE TIMESTAMP 8
33 CRD_PLAS_STOCK_CODE CHARACTER VARYING(10) 10
34 EFF_END_DATE TIMESTAMP 8
35 DATA_LOAD_DATE TIMESTAMP 8
36 SNPSHT_DATE TIMESTAMP 8
37 SRC_SYS_ID CHARACTER VARYING(5) 5
38 LOAD_ID BIGINT 8
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8