CDI_TCFDD_CUSTOMER_ADDRESS

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

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