OPIC_CUST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_OPIC_CUST

Columns
# Name Data Type Length
1 CNO CHARACTER VARYING(11) 11
2 CMNE CHARACTER VARYING(20) 20
3 BIC CHARACTER VARYING(11) 11
4 CCODE CHARACTER VARYING(2) 2
5 SIC CHARACTER VARYING(10) 10
6 SN CHARACTER VARYING(80) 80
7 CFN1 CHARACTER VARYING(70) 70
8 CFN2 CHARACTER VARYING(70) 70
9 CA1 CHARACTER VARYING(70) 70
10 CA2 CHARACTER VARYING(70) 70
11 CA3 CHARACTER VARYING(70) 70
12 CA4 CHARACTER VARYING(70) 70
13 CA5 CHARACTER VARYING(35) 35
14 CTYPE CHARACTER VARYING(1) 1
15 CPOST CHARACTER VARYING(10) 10
16 LSTMNTDTE TIMESTAMP 8
17 UCCODE CHARACTER VARYING(2) 2
18 BIRTHDATE TIMESTAMP 8
19 TAXID CHARACTER VARYING(15) 15
20 ACCTNGTYPE CHARACTER VARYING(10) 10
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8