FCT_CUST_H_DOMICILE_MASTER

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_DOM_ID BIGINT 8
2 CUST_NUM BIGINT 8
3 CUST_ID BIGINT 8
4 ENTITY_TYP_CODE CHARACTER VARYING(4) 4
5 DOM_CODE CHARACTER VARYING(10) 10
6 DOM_NAME CHARACTER VARYING(100) 100
7 CUST_DOM_RULE_ID DOUBLE PRECISION 8
8 DOM_METH_CODE CHARACTER VARYING(20) 20
9 DOM_PRDT_HRCHY_CODE DOUBLE PRECISION 8
10 DOM_ALLOCTN_CODE CHARACTER VARYING(100) 100
11 DOM_DSTNCE_VAL NUMERIC(38,6) 19
12 SCNDRY_DOM_CODE CHARACTER VARYING(20) 20
13 SCNDRY_DOM_DSTNCE_VAL NUMERIC(18,6) 19
14 EFF_STRT_DATE TIMESTAMP 8
15 EFF_END_DATE TIMESTAMP 8
16 SNPSHT_DATE TIMESTAMP 8
17 DATA_LOAD_DATE TIMESTAMP 8
18 SRC_SYS_ID CHARACTER VARYING(4) 4
19 CRM_QUEUE_NAME CHARACTER VARYING(100) 100