CLMS_LEADSHFNONCLMS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 LEADNO CHARACTER VARYING(8) 8
4 BNCPROD CHARACTER VARYING(4) 4
5 BNCACCNT CHARACTER VARYING(10) 10
6 BNCBAL INTEGER 4
7 BNCELIM INTEGER 4
8 BNCARRS INTEGER 4
9 BNCPLIM INTEGER 4
10 BNCITYP INTEGER 4
11 BNCIMARG NUMERIC(12,3) 19
12 BNCREXPDTE TIMESTAMP 8
13 BNCTERM INTEGER 4
14 BNCEXPDTE TIMESTAMP 8
15 DELTA_TYPE CHARACTER VARYING(1) 1
16 EFFECTIVE_STRT_DT TIMESTAMP 8
17 EFFECTIVE_END_DT TIMESTAMP 8
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8