DIM_CUST_H_SOURCE_CUST_AUX_APR

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
5 PRDT_SYS_CUST_NUM_CDI CHARACTER VARYING(30) 30
6 MKTG_CONSNT_CODE CHARACTER VARYING(4) 4
7 SLNT_HME_PH_FLG CHARACTER VARYING(1) 1
8 SLNT_MOB_PH_FLG CHARACTER VARYING(1) 1
9 CLIENT_TYP_CODE CHARACTER VARYING(4) 4
10 DRVR_IND CHARACTER VARYING(3) 3
11 ELECT_MKTG_CONSNT_CODE CHARACTER VARYING(4) 4
12 INTN_CLIENT_NUM NUMERIC(22,0) 19
13 SRC_SYS_ID CHARACTER VARYING(5) 5
15 EFF_STRT_DATE TIMESTAMP 8
16 EFF_END_DATE TIMESTAMP 8
17 IS_RECORD_CURRENT CHARACTER VARYING(3) 3
18 IS_RECORD_DELETED CHARACTER VARYING(3) 3
19 SNPSHOT_DATE TIMESTAMP 8