OPIC_ACDW
Description
Synonyms
SDSNZP02_BANK..ATOCRS_OPIC_ACDW
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 |