OPIC_FXTH

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 AMENDDATE TIMESTAMP 8
5 AMENDTIME CHARACTER VARYING(8) 8
6 AMENDOPER CHARACTER VARYING(4) 4
7 DISAGGCCYRATE_8 NUMERIC(18,8) 19
8 DISAGGCCYPD_8 NUMERIC(18,8) 19
9 DISAGGCCYSPREAD_8 NUMERIC(18,8) 19
10 DISAGGCCYTERMS CHARACTER VARYING(1) 1
11 DISAGGCCY CHARACTER VARYING(3) 3
12 DISAGGCTR CHARACTER VARYING(3) 3
13 INTERBRANCHNO CHARACTER VARYING(2) 2
14 INTERBRANCHSPOTTRAD CHARACTER VARYING(4) 4
15 INTERBRANCHFWDTRAD CHARACTER VARYING(4) 4
16 INTERBRANCHDEALNO CHARACTER VARYING(15) 15
17 INTERBRANCHCORPDEALNO CHARACTER VARYING(15) 15
18 LSTMNTDTE TIMESTAMP 8
19 AMOUNT1 NUMERIC(19,4) 19
20 AMOUNT2 NUMERIC(19,4) 19
21 TRAD1 CHARACTER VARYING(4) 4
22 TRAD2 CHARACTER VARYING(4) 4
23 TRAD3 CHARACTER VARYING(4) 4
24 TRAD4 CHARACTER VARYING(4) 4
25 CCYINTRATE_8 NUMERIC(18,8) 19
26 CTRINTRATE_8 NUMERIC(18,8) 19
27 RATE3_8 NUMERIC(18,8) 19
28 RATE4_8 NUMERIC(18,8) 19
29 CCYLINKDEALNO CHARACTER VARYING(15) 15
30 CTRLINKDEALNO CHARACTER VARYING(15) 15
31 DATE1 TIMESTAMP 8
32 DATE2 TIMESTAMP 8
33 INTERBRANCHPLDEALNO CHARACTER VARYING(8) 8
34 INTERBRANCHCORPPLDEALNO CHARACTER VARYING(8) 8
35 FEDEALNO CHARACTER VARYING(15) 15
36 FECORPDEALNO CHARACTER VARYING(15) 15
37 FEPLDEALNO CHARACTER VARYING(15) 15
38 FECORPPLDEALNO CHARACTER VARYING(15) 15
39 INTERFACEDEALNO CHARACTER VARYING(15) 15
40 NDFFIXDATE TIMESTAMP 8
41 REVTIME CHARACTER VARYING(8) 8
42 DISAGGCORPSPOTTRAD CHARACTER VARYING(4) 4
43 DISAGGCORPSPOTPORT CHARACTER VARYING(4) 4
44 DISAGGCORPSPOTCOST CHARACTER VARYING(10) 10
45 DISAGGCORPFWDTRAD CHARACTER VARYING(4) 4
46 DISAGGCORPFWDPORT CHARACTER VARYING(4) 4
47 DISAGGCORPFWDCOST CHARACTER VARYING(10) 10
48 UPDATECOUNTER BIGINT 8
49 INTERFACESERVER CHARACTER VARYING(15) 15
50 DEALCCYNPVAMT NUMERIC(19,4) 19
51 DEALCTRNPVAMT NUMERIC(19,4) 19
52 SPOTCTRBAMT NUMERIC(19,4) 19
53 SPOTCTRAMT NUMERIC(19,4) 19
54 CCYFWDPREMAMT NUMERIC(19,4) 19
55 FWDPREMCCY CHARACTER VARYING(3) 3
56 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
57 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
58 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
59 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8