KEEPME_HCIS_HST_CUST_X_CUST_TB_20201119

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_CO_NBR NUMERIC(5,0) 19
2 CUST_ID CHARACTER VARYING(9) 9
3 CUST_TIE_BRKR SMALLINT 2
4 REL_CUST_CO_NBR NUMERIC(5,0) 19
5 REL_CUST_ID CHARACTER VARYING(9) 9
6 REL_CUST_TIE_BRKR SMALLINT 2
7 CUCU_REL_CD CHARACTER VARYING(3) 3
8 RPM_ANALYSIS_IND CHARACTER VARYING(1) 1
9 RPM_PRICING_IND CHARACTER VARYING(1) 1
10 COMBINED_STMT_IND CHARACTER VARYING(1) 1
11 PCS_PLAN_IND CHARACTER VARYING(1) 1
12 TFN_TYPE_IND CHARACTER VARYING(1) 1
13 LINK_TYPE_IND CHARACTER VARYING(1) 1
14 OWNED_PCNT NUMERIC(7,4) 19
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8