CDI_TCFDD_BRAND_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 BRND_CODE CHARACTER VARYING(10) 10
3 ADDR_TYP_CODE CHARACTER VARYING(20) 20
4 EFF_STRT_DATE TIMESTAMP 8
5 CUST_ID BIGINT 8
6 BRND_ID BIGINT 8
7 ADDR_TYP_ID BIGINT 8
8 ADDR_LNE_1 CHARACTER VARYING(50) 50
9 ADDR_LNE_2 CHARACTER VARYING(50) 50
10 ADDR_LNE_3 CHARACTER VARYING(50) 50
11 SBRB_CODE CHARACTER VARYING(50) 50
12 PCODE CHARACTER VARYING(20) 20
13 STATE_DESC CHARACTER VARYING(50) 50
14 CNTRY_ID BIGINT 8
15 CNTRY_CODE CHARACTER VARYING(20) 20
16 DPID CHARACTER VARYING(20) 20
17 DPID_TYP_ID BIGINT 8
18 DPID_TYP_CODE CHARACTER VARYING(4) 4
19 POSTAL_ADDR_TYP_ID BIGINT 8
20 POSTAL_ADDR_TYP_CODE CHARACTER VARYING(20) 20
21 ADDR_STD_ID BIGINT 8
22 ADDR_STD_CODE CHARACTER VARYING(10) 10
23 RTRN_MAIL_FLG CHARACTER VARYING(3) 3
24 EFF_END_DATE TIMESTAMP 8
25 DATA_LOAD_DATE TIMESTAMP 8
26 SNPSHT_DATE TIMESTAMP 8
27 SRC_SYS_ID CHARACTER VARYING(5) 5
28 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
29 LOAD_ID BIGINT 8
30 LST_CUST_ADDR_DATE TIMESTAMP 8
31 RTRN_MAIL_DATE TIMESTAMP 8
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8