OPIC_HPCI

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 PRODUCT CHARACTER VARYING(6) 6
3 TYPE CHARACTER VARYING(2) 2
4 DEALNO CHARACTER VARYING(8) 8
5 SEQ CHARACTER VARYING(4) 4
6 PCC CHARACTER VARYING(2) 2
7 ACCTNO CHARACTER VARYING(35) 35
8 BIC CHARACTER VARYING(11) 11
9 C1 CHARACTER VARYING(70) 70
10 C2 CHARACTER VARYING(70) 70
11 C3 CHARACTER VARYING(70) 70
12 C4 CHARACTER VARYING(70) 70
13 SACCT CHARACTER VARYING(15) 15
14 SMEANS CHARACTER VARYING(7) 7
15 SCHDSEQ CHARACTER VARYING(4) 4
16 AMENDOPER CHARACTER VARYING(4) 4
17 AMENDDATE TIMESTAMP 8
18 AMENDTIME CHARACTER VARYING(8) 8
19 AUTHDATE TIMESTAMP 8
20 AUTHOPER CHARACTER VARYING(4) 4
21 AUTHIND CHARACTER VARYING(1) 1
22 INPUTOPER CHARACTER VARYING(4) 4
23 INPUTDATE TIMESTAMP 8
24 EFFDATE TIMESTAMP 8
25 TEXT1 CHARACTER VARYING(15) 15
26 TEXT2 CHARACTER VARYING(15) 15
27 TEXT3 CHARACTER VARYING(15) 15
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8