OPIC_SPLT

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 ORIGDEALNO CHARACTER VARYING(15) 15
7 ORIGSEQ CHARACTER VARYING(4) 4
8 ORIGPRODUCT CHARACTER VARYING(6) 6
9 ORIGPRODTYPE CHARACTER VARYING(2) 2
10 ORIGVDATE TIMESTAMP 8
11 ORIGPRODSYS CHARACTER VARYING(4) 4
12 CNO CHARACTER VARYING(22) 22
13 PAYRECIND CHARACTER VARYING(1) 1
14 IOPER CHARACTER VARYING(4) 4
15 INPUTDATE TIMESTAMP 8
16 VERIND CHARACTER VARYING(1) 1
17 VERDATE TIMESTAMP 8
18 VEROPER CHARACTER VARYING(4) 4
19 PAYRECOPER CHARACTER VARYING(4) 4
20 SETTDATE TIMESTAMP 8
21 CCY CHARACTER VARYING(3) 3
22 SPLITAMT NUMERIC(19,4) 19
23 CCYSMEANS CHARACTER VARYING(7) 7
24 CCYSACCT CHARACTER VARYING(15) 15
25 OFFSETSMEANS CHARACTER VARYING(7) 7
26 OFFSETSACCOUNT CHARACTER VARYING(15) 15
27 CCYRATE_8 NUMERIC(18,8) 19
28 CCYBAMT NUMERIC(19,4) 19
29 COST CHARACTER VARYING(11) 11
30 SIIND CHARACTER VARYING(1) 1
31 SWIFTMATCHIND CHARACTER VARYING(1) 1
32 SPOTFWDIND CHARACTER VARYING(1) 1
33 AUTHIND CHARACTER VARYING(1) 1
34 AUTHOPER CHARACTER VARYING(4) 4
35 AUTHDATE TIMESTAMP 8
36 REVOPER CHARACTER VARYING(4) 4
37 REVDATE TIMESTAMP 8
38 REVREASON CHARACTER VARYING(2) 2
39 REVTEXT CHARACTER VARYING(70) 70
40 DATE1 TIMESTAMP 8
41 DATE2 TIMESTAMP 8
42 AMT1 NUMERIC(19,4) 19
43 AMT2 NUMERIC(19,4) 19
44 RATE1_8 NUMERIC(18,8) 19
45 RATE2_8 NUMERIC(18,8) 19
46 LSTMNTDATE TIMESTAMP 8
47 EXCLUDEACCTNGIND CHARACTER VARYING(1) 1
48 PROCESSIND CHARACTER VARYING(1) 1
49 STATUS CHARACTER VARYING(15) 15
50 LINKDEALNO1 CHARACTER VARYING(15) 15
51 LINKDEALNO2 CHARACTER VARYING(15) 15
52 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
53 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
54 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
55 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8