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