DIM_CUST_GROUP_CUST_ADDR

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM NUMERIC(19,0) 19
2 CUST_ID BIGINT 8
3 ADDR_TYP_CODE CHARACTER VARYING(1) 1
4 ADDR_TYP_ID BIGINT 8
5 PCODE CHARACTER VARYING(12) 12
6 STATE_DESC CHARACTER VARYING(30) 30
7 CNTRY_CODE CHARACTER VARYING(2) 2
8 CNTRY_ID BIGINT 8
9 DPID CHARACTER VARYING(8) 8
10 DPID_TYP_CODE CHARACTER VARYING(1) 1
11 DPID_TYP_ID BIGINT 8
12 RTRN_MAIL_FLG CHARACTER VARYING(1) 1
13 SRC_SYS_ID CHARACTER VARYING(3) 3