OPIC_BRCB

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 BROKNO CHARACTER VARYING(10) 10
3 CCY CHARACTER VARYING(3) 3
4 COSTCENT CHARACTER VARYING(10) 10
5 CCYAMT NUMERIC(19,4) 19
6 CCYAMTYST NUMERIC(19,4) 19
7 LSTMNTDTE TIMESTAMP 8
8 PORT CHARACTER VARYING(4) 4
9 ACCOUNT CHARACTER VARYING(20) 20
10 TDYCOMAMT NUMERIC(19,4) 19
11 YSTCOMAMT NUMERIC(19,4) 19
12 PMECOMAMT NUMERIC(19,4) 19
13 PYECOMAMT NUMERIC(19,4) 19
14 TDYEXECAMT NUMERIC(19,4) 19
15 YSTEXECAMT NUMERIC(19,4) 19
16 PMEEXECAMT NUMERIC(19,4) 19
17 PYEEXECAMT NUMERIC(19,4) 19
18 TDYFEEAMT NUMERIC(19,4) 19
19 YSTFEEAMT NUMERIC(19,4) 19
20 PMEFEEAMT NUMERIC(19,4) 19
21 PYEFEEAMT NUMERIC(19,4) 19
22 TDYREALPL NUMERIC(19,4) 19
23 YSTREALPL NUMERIC(19,4) 19
24 PMEREALPL NUMERIC(19,4) 19
25 PYEREALPL NUMERIC(19,4) 19
26 TDYPREM NUMERIC(19,4) 19
27 YSTPREM NUMERIC(19,4) 19
28 PMEPREM NUMERIC(19,4) 19
29 PYEPREM NUMERIC(19,4) 19
30 TDYUNREALPL NUMERIC(19,4) 19
31 YSTUNREALPL NUMERIC(19,4) 19
32 PMEUNREALPL NUMERIC(19,4) 19
33 PYEUNREALPL NUMERIC(19,4) 19
34 TDYBRCASH NUMERIC(19,4) 19
35 YSTBRCASH NUMERIC(19,4) 19
36 PMEBRCASH NUMERIC(19,4) 19
37 PYEBRCASH NUMERIC(19,4) 19
38 TDYFFVM NUMERIC(19,4) 19
39 YSTFFVM NUMERIC(19,4) 19
40 PMEFFVM NUMERIC(19,4) 19
41 PYEFFVM NUMERIC(19,4) 19
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
44 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
45 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8