OPIC_ACDW_FATCA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER(2) 2
2 MOVENO CHARACTER(8) 8
3 ACCOUNTNO CHARACTER(15) 15
4 DEPWITHIND CHARACTER(1) 1
5 VDATE TIMESTAMP 8
6 CCYAMT NUMERIC(19,4) 19
7 SETTMEANS CHARACTER(7) 7
8 SETTACCT CHARACTER(15) 15
9 DEALDATE TIMESTAMP 8
10 IOPER CHARACTER(4) 4
11 VOPER CHARACTER(4) 4
12 VERIND CHARACTER(1) 1
13 VERDATE TIMESTAMP 8
14 REVOPER CHARACTER(4) 4
15 REVREASON CHARACTER(2) 2
16 REVDATE TIMESTAMP 8
17 REVTEXT CHARACTER(70) 70
18 SETTAUTHIND CHARACTER(1) 1
19 SETTOPER CHARACTER(4) 4
20 SETTAUTHDTE TIMESTAMP 8
21 INPUTDATE TIMESTAMP 8
22 INPUTTIME CHARACTER(8) 8
23 BRPRCINDTE TIMESTAMP 8
24 DEALNO CHARACTER(8) 8
25 SEQ CHARACTER(4) 4
26 PRODUCT CHARACTER(6) 6
27 TYPE CHARACTER(2) 2
28 DESCRIPTION CHARACTER(140) 140
29 INTBVAMT NUMERIC(19,4) 19
30 INTFLAG CHARACTER(1) 1
31 INTCAP CHARACTER(1) 1
32 LSTMNTDATE TIMESTAMP 8
33 WHTAMT NUMERIC(19,4) 19
34 VATAMT NUMERIC(19,4) 19
35 TRNTAXAMT NUMERIC(19,4) 19
36 ORIGMOVENO CHARACTER(8) 8
37 NEWMOVENO CHARACTER(8) 8
38 LINKMOVENO CHARACTER(8) 8
39 FINCENT CHARACTER(15) 15
40 TASK CHARACTER(4) 4
41 TRANCODE CHARACTER(10) 10
42 CLEARDAYS CHARACTER(2) 2
43 CLEARDATE TIMESTAMP 8
44 CHECKNO CHARACTER(15) 15
45 REGCCIND CHARACTER(1) 1
46 FEEAMT NUMERIC(19,4) 19
47 TRANFEEIND CHARACTER(1) 1
48 ITEMCOUNT NUMERIC(19,4) 19
49 CHGREFIND CHARACTER(1) 1
50 ODOVRREJIND CHARACTER(1) 1
51 ODOVRREJTEXT CHARACTER(70) 70
52 ODOVRREJOPER CHARACTER(4) 4
53 ODOVRREJDATE TIMESTAMP 8
54 CLEARIND CHARACTER(1) 1
55 VERFAILTYPE CHARACTER(4) 4
56 STMTTEXT CHARACTER(34) 34
57 SWFTTRANTYPE CHARACTER(4) 4
58 SWFTOWNERREF CHARACTER(16) 16
59 UPDATECOUNTER NUMERIC(15,0) 19
60 CUSTREFNO CHARACTER(20) 20
61 BROKCCY CHARACTER(3) 3
62 BROKAMT NUMERIC(19,4) 19
63 BROKRATE_8 NUMERIC(18,8) 19
64 WHTAMT2 NUMERIC(19,4) 19
65 WHTAMT3 NUMERIC(19,4) 19
66 TRNTAXAMT2 NUMERIC(19,4) 19
67 TRNTAXAMT3 NUMERIC(19,4) 19
68 SWIFTTRANCODE CHARACTER(10) 10
69 ALTCHKCLRIND CHARACTER(1) 1
70 WHTAMT4 NUMERIC(19,4) 19
71 NETTINGID CHARACTER(15) 15
72 SWIFTMATCHIND CHARACTER(1) 1
73 CUSTCDATE TIMESTAMP 8
74 FEDEALNO CHARACTER(15) 15
75 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
76 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
77 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
78 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8