OPIC_HST_ACDW

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 MOVENO CHARACTER VARYING(8) 8
3 ACCOUNTNO CHARACTER VARYING(15) 15
4 DEPWITHIND CHARACTER VARYING(1) 1
5 VDATE TIMESTAMP 8
6 CCYAMT NUMERIC(19,4) 19
7 SETTMEANS CHARACTER VARYING(7) 7
8 SETTACCT CHARACTER VARYING(15) 15
9 DEALDATE TIMESTAMP 8
10 IOPER CHARACTER VARYING(4) 4
11 VOPER CHARACTER VARYING(4) 4
12 VERIND CHARACTER VARYING(1) 1
13 VERDATE TIMESTAMP 8
14 REVOPER CHARACTER VARYING(4) 4
15 REVREASON CHARACTER VARYING(2) 2
16 REVDATE TIMESTAMP 8
17 REVTEXT CHARACTER VARYING(70) 70
18 SETTAUTHIND CHARACTER VARYING(1) 1
19 SETTOPER CHARACTER VARYING(4) 4
20 SETTAUTHDTE TIMESTAMP 8
21 INPUTDATE TIMESTAMP 8
22 INPUTTIME CHARACTER VARYING(8) 8
23 BRPRCINDTE TIMESTAMP 8
24 DEALNO CHARACTER VARYING(8) 8
25 SEQ CHARACTER VARYING(4) 4
26 PRODUCT CHARACTER VARYING(6) 6
27 TYPE CHARACTER VARYING(2) 2
28 DESCRIPTION CHARACTER VARYING(140) 140
29 INTBVAMT NUMERIC(19,4) 19
30 INTFLAG CHARACTER VARYING(1) 1
31 INTCAP CHARACTER VARYING(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 VARYING(8) 8
37 NEWMOVENO CHARACTER VARYING(8) 8
38 LINKMOVENO CHARACTER VARYING(8) 8
39 FINCENT CHARACTER VARYING(15) 15
40 TASK CHARACTER VARYING(4) 4
41 TRANCODE CHARACTER VARYING(10) 10
42 CLEARDAYS CHARACTER VARYING(2) 2
43 CLEARDATE TIMESTAMP 8
44 CHECKNO CHARACTER VARYING(15) 15
45 REGCCIND CHARACTER VARYING(1) 1
46 FEEAMT NUMERIC(19,4) 19
47 TRANFEEIND CHARACTER VARYING(1) 1
48 ITEMCOUNT NUMERIC(19,4) 19
49 CHGREFIND CHARACTER VARYING(1) 1
50 ODOVRREJIND CHARACTER VARYING(1) 1
51 ODOVRREJTEXT CHARACTER VARYING(70) 70
52 ODOVRREJOPER CHARACTER VARYING(4) 4
53 ODOVRREJDATE TIMESTAMP 8
54 CLEARIND CHARACTER VARYING(1) 1
55 VERFAILTYPE CHARACTER VARYING(4) 4
56 STMTTEXT CHARACTER VARYING(34) 34
57 SWFTTRANTYPE CHARACTER VARYING(4) 4
58 SWFTOWNERREF CHARACTER VARYING(16) 16
59 UPDATECOUNTER BIGINT 8
60 CUSTREFNO CHARACTER VARYING(20) 20
61 BROKCCY CHARACTER VARYING(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 VARYING(10) 10
69 ALTCHKCLRIND CHARACTER VARYING(1) 1
70 WHTAMT4 NUMERIC(19,4) 19
71 NETTINGID CHARACTER VARYING(15) 15
72 SWIFTMATCHIND CHARACTER VARYING(1) 1
73 CUSTCDATE TIMESTAMP 8
74 FEDEALNO CHARACTER VARYING(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
79 TRANSFERTYPE CHARACTER VARYING(1) 1
80 TRANSFERLINKMOVENO CHARACTER VARYING(8) 8
81 VOPER1 CHARACTER VARYING(4) 4
82 VERDATE1 TIMESTAMP 8
83 ODTRANSFERIND CHARACTER VARYING(1) 1