OPIC_BRCH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 DEALNO CHARACTER VARYING(8) 8
3 SEQ CHARACTER VARYING(4) 4
4 PRODUCT CHARACTER VARYING(6) 6
5 PRODTYPE CHARACTER VARYING(2) 2
6 BROKNO CHARACTER VARYING(10) 10
7 CNO CHARACTER VARYING(10) 10
8 COSTCENT CHARACTER VARYING(10) 10
9 CCY CHARACTER VARYING(3) 3
10 CCYAMT NUMERIC(19,4) 19
11 DEALDATE TIMESTAMP 8
12 INPUTDATE TIMESTAMP 8
13 IOPER CHARACTER VARYING(4) 4
14 INPUTTIME CHARACTER VARYING(8) 8
15 LSTMNTDATE TIMESTAMP 8
16 PORTFOLIO CHARACTER VARYING(4) 4
17 REVDATE TIMESTAMP 8
18 REVOPER CHARACTER VARYING(4) 4
19 REVREASON CHARACTER VARYING(2) 2
20 REVTEXT CHARACTER VARYING(70) 70
21 TRAD CHARACTER VARYING(4) 4
22 VDATE TIMESTAMP 8
23 VERDATE TIMESTAMP 8
24 VERIND CHARACTER VARYING(1) 1
25 VOPER CHARACTER VARYING(4) 4
26 PAYRECIND CHARACTER VARYING(1) 1
27 SETTMEANS CHARACTER VARYING(7) 7
28 SETTACCT CHARACTER VARYING(15) 15
29 SETTAUTHIND CHARACTER VARYING(1) 1
30 SETTAUTHDATE TIMESTAMP 8
31 SETTOPER CHARACTER VARYING(4) 4
32 UPDATECOUNTER BIGINT 8
33 SETTADDSIIND CHARACTER VARYING(1) 1
34 SETTAUTHOPER CHARACTER VARYING(4) 4
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8