DIM_CUST_SOURCE_CUST_ADDR

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
4 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
10 ADDR_TYP_CODE CHARACTER VARYING(1) 1
11 ADDR_TYP_ID BIGINT 8
12 ADDR_LNE_1 CHARACTER VARYING(100) 100
13 ADDR_LNE_2 CHARACTER VARYING(100) 100
14 ADDR_LNE_3 CHARACTER VARYING(100) 100
15 SBRB_CODE CHARACTER VARYING(50) 50
16 PCODE CHARACTER VARYING(12) 12
17 STATE_DESC CHARACTER VARYING(30) 30
18 CNTRY_CODE CHARACTER VARYING(2) 2
19 CNTRY_ID BIGINT 8
20 DPID CHARACTER VARYING(8) 8
21 DPID_TYP_CODE CHARACTER VARYING(1) 1
22 DPID_TYP_ID BIGINT 8
23 RTRN_MAIL_FLG CHARACTER VARYING(1) 1
24 POSTAL_ADDR_TYP_CODE CHARACTER VARYING(20) 20
25 POSTAL_ADDR_TYP_ID BIGINT 8
26 ADDR_STD_CODE CHARACTER VARYING(5) 5
27 ADDR_STD_ID BIGINT 8
28 LST_CUST_ADDR_DATE TIMESTAMP 8
29 RTRN_MAIL_DATE TIMESTAMP 8
30 SRC_SYS_ID CHARACTER VARYING(3) 3