OPIC_FXDT

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