DIM_CUST_H_CUST_TO_PRODUCT_REL

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_DIM_CUST_H_CUST_TO_PRODUCT_REL

SDSNZP02_BANK..UBAR_DIM_CUST_H_CUST_TO_PRODUCT_REL

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 CUST_ID BIGINT 8
3 BRND_CODE CHARACTER VARYING(10) 10
4 BRND_DESC CHARACTER VARYING(50) 50
5 BRND_ID BIGINT 8
6 PRDT_SYS_CODE CHARACTER VARYING(10) 10
7 PRDT_SYS_CODE_CDI CHARACTER VARYING(10) 10
8 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
9 PRDT_SYS_CUST_NUM_CDI CHARACTER VARYING(30) 30
10 INTN_INITIATE_MBR_ID INTEGER 4
11 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
12 CDI_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
13 PRDT_LIFECYCLE_STAT_CODE CHARACTER VARYING(1) 1
14 PRDT_LIFECYCLE_STAT_ID BIGINT 8
15 PRDT_LIFECYCLE_STAT_DESC CHARACTER VARYING(50) 50
16 PRDT_ID INTEGER 4
17 PRDT_DESC CHARACTER VARYING(100) 100
18 PRDT_GRP_CODE CHARACTER VARYING(10) 10
19 PRDT_GRP_CODE_CDI CHARACTER VARYING(10) 10
20 PRDT_SEGMENT_GRP_CODE CHARACTER VARYING(20) 20
21 PRDT_TYP_CODE CHARACTER VARYING(10) 10
22 PRDT_TYP_CODE_CDI CHARACTER VARYING(10) 10
23 CUST_PRDT_RSHIP_TYP_ID BIGINT 8
24 CUST_PRDT_RSHIP_TYP_CODE CHARACTER VARYING(20) 20
25 CUST_PRDT_RSHIP_TYP_DESC CHARACTER VARYING(50) 50
26 CUST_PRDT_RSHIP_TYP_RNK NUMERIC(22,0) 19
27 RB_DIRECT_RSHIP_IND CHARACTER VARYING(3) 3
28 BB_DIRECT_RSHIP_IND CHARACTER VARYING(20) 20
29 ROLE_EFF_DATE TIMESTAMP 8
30 ROLE_EXPIRY_DATE TIMESTAMP 8
31 SRC_SYS_ID CHARACTER VARYING(4) 4
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
33 EFF_STRT_DATE TIMESTAMP 8
34 EFF_END_DATE TIMESTAMP 8
35 IS_RECORD_CURRENT CHARACTER VARYING(3) 3
36 IS_RECORD_DELETED CHARACTER VARYING(3) 3
37 SNPSHT_DATE TIMESTAMP 8
38 OLAP_KEY BIGINT 8