DIM_CUST_GCIS_CUST_ADDR

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CIS_PROFILE_ID INTEGER 4
2 BRND_CODE CHARACTER VARYING(10) 10
3 BRND_ID BIGINT 8
4 ADDR_TYP_CODE CHARACTER VARYING(1) 1
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 ADDR_LNE_4 CHARACTER VARYING(50) 50
10 ADDR_LNE_5 CHARACTER VARYING(50) 50
11 SBRB_CODE CHARACTER VARYING(40) 40
13 STATE_DESC CHARACTER VARYING(30) 30
14 CNTRY_CODE CHARACTER VARYING(2) 2
15 DPID INTEGER 4
16 ADDRESS_IND CHARACTER VARYING(1) 1