CDI_TCFDD_CUSTOMER_AUX_NPR

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 BRND_CODE CHARACTER VARYING(10) 10
3 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
4 EFF_STRT_DATE TIMESTAMP 8
5 BRND_ID BIGINT 8
6 MKTG_CONSNT_ID BIGINT 8
7 MKTG_CONSNT_CODE CHARACTER VARYING(4) 4
8 MKTG_CONSNT_PH_PREF_ID BIGINT 8
9 MKTG_CONSNT_PH_PREF_CODE CHARACTER VARYING(3) 3
10 MKTG_CONSNT_CROSS_SELL_FLG CHARACTER VARYING(1) 1
11 MOB_NUM_1 CHARACTER VARYING(20) 20
12 MOB_CNTCT_PREF_ID_1 BIGINT 8
13 MOB_CNTCT_PREF_CODE_1 CHARACTER VARYING(4) 4
14 MOB_NUM_2 CHARACTER VARYING(20) 20
15 MOB_CNTCT_PREF_ID_2 BIGINT 8
16 MOB_CNTCT_PREF_CODE_2 CHARACTER VARYING(4) 4
17 INTN_CLIENT_NUM BIGINT 8
18 CLIENT_TYP_ID BIGINT 8
19 CLIENT_TYP_CODE CHARACTER VARYING(4) 4
20 DRVR_IND CHARACTER VARYING(3) 3
21 CORP_PARTNER_ID BIGINT 8
22 CORP_PARTNER_CODE CHARACTER VARYING(4) 4
23 EFF_END_DATE TIMESTAMP 8
24 DATA_LOAD_DATE TIMESTAMP 8
25 SNPSHT_DATE TIMESTAMP 8
26 SRC_SYS_ID CHARACTER VARYING(5) 5
27 LOAD_ID BIGINT 8
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8