OPIC_CUSA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 CUST CHARACTER VARYING(12) 12
3 PRODCODE CHARACTER VARYING(6) 6
4 TYPE CHARACTER VARYING(2) 2
5 ADDRTYPE CHARACTER VARYING(1) 1
6 SEQ CHARACTER VARYING(4) 4
7 BIC CHARACTER VARYING(11) 11
8 CATTN CHARACTER VARYING(35) 35
9 CA1 CHARACTER VARYING(70) 70
10 CA2 CHARACTER VARYING(70) 70
11 CA3 CHARACTER VARYING(70) 70
12 CLOC CHARACTER VARYING(70) 70
13 CCTY CHARACTER VARYING(35) 35
14 CPOST CHARACTER VARYING(10) 10
15 FAX CHARACTER VARYING(20) 20
16 CMEDIA CHARACTER VARYING(1) 1
17 CONFIND CHARACTER VARYING(1) 1
18 LANG CHARACTER VARYING(2) 2
19 LSTMNTDTE TIMESTAMP 8
20 ALTCUSTNAME CHARACTER VARYING(35) 35
21 SR1 CHARACTER VARYING(35) 35
22 SR2 CHARACTER VARYING(35) 35
23 SR3 CHARACTER VARYING(35) 35
24 SR4 CHARACTER VARYING(35) 35
25 ISDADEFINITION CHARACTER VARYING(4) 4
26 ISDAAGREEMENTDATE TIMESTAMP 8
27 BOTHCONFIND CHARACTER VARYING(1) 1
28 SUPPCLSCONFIND CHARACTER VARYING(1) 1
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8