CDI_TCFDD_MEMBER_LEVEL_CUST_ADDR

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 BRND_CODE CHARACTER VARYING(10) 10
4 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
5 ADDR_TYP_CODE CHARACTER VARYING(20) 20
6 EFF_STRT_DATE TIMESTAMP 8
7 CUST_ID BIGINT 8
8 BRND_ID BIGINT 8
9 ADDR_TYP_ID BIGINT 8
10 INTN_INITIATE_MBR_ID BIGINT 8
11 ADDR_LNE_1 CHARACTER VARYING(50) 50
12 ADDR_LNE_2 CHARACTER VARYING(50) 50
13 ADDR_LNE_3 CHARACTER VARYING(50) 50
14 SBRB_CODE CHARACTER VARYING(50) 50
15 PCODE CHARACTER VARYING(20) 20
16 STATE_DESC CHARACTER VARYING(50) 50
17 CNTRY_ID BIGINT 8
18 CNTRY_CODE CHARACTER VARYING(20) 20
19 DPID CHARACTER VARYING(20) 20
20 DPID_TYP_ID BIGINT 8
21 DPID_TYP_CODE CHARACTER VARYING(4) 4
22 POSTAL_ADDR_TYP_ID BIGINT 8
23 POSTAL_ADDR_TYP_CODE CHARACTER VARYING(20) 20
24 ADDR_STD_ID BIGINT 8
25 ADDR_STD_CODE CHARACTER VARYING(10) 10
26 RTRN_MAIL_FLG CHARACTER VARYING(3) 3
27 EFF_END_DATE TIMESTAMP 8
28 DATA_LOAD_DATE TIMESTAMP 8
29 SNPSHT_DATE TIMESTAMP 8
30 SRC_SYS_ID CHARACTER VARYING(5) 5
31 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
32 LOAD_ID BIGINT 8
33 LST_CUST_ADDR_DATE TIMESTAMP 8
34 RTRN_MAIL_DATE TIMESTAMP 8
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8