OPC_HST_FFDH
Description
Synonyms
SDSNZP02_BANK..EFS_OPC_HST_FFDH
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | BIGINT | 8 |
| 2 | COST | CHARACTER VARYING(11) | 11 |
| 3 | DEALNO | CHARACTER VARYING(8) | 8 |
| 4 | DELVDATE | CHARACTER VARYING(10) | 10 |
| 5 | IOPER | CHARACTER VARYING(4) | 4 |
| 6 | PORT | CHARACTER VARYING(4) | 4 |
| 7 | REVDATE | CHARACTER VARYING(10) | 10 |
| 8 | BR | CHARACTER VARYING(2) | 2 |
| 9 | CONTCODE | CHARACTER VARYING(10) | 10 |
| 10 | NUMCONT | NUMERIC(19,4) | 19 |
| 11 | PSDEALNO | CHARACTER VARYING(8) | 8 |
| 12 | PRODUCT | CHARACTER VARYING(6) | 6 |
| 13 | PRODTYPE | CHARACTER VARYING(2) | 2 |
| 14 | DEALEXTVAL_8 | NUMERIC(18,8) | 19 |
| 15 | BRPRCINDTE | CHARACTER VARYING(10) | 10 |
| 16 | CASHIND | CHARACTER VARYING(1) | 1 |
| 17 | CCYAMT | NUMERIC(19,4) | 19 |
| 18 | CNO | CHARACTER VARYING(10) | 10 |
| 19 | COMMAMT | NUMERIC(19,4) | 19 |
| 20 | COMMRATE | NUMERIC(19,4) | 19 |
| 21 | CONTPRICE_8 | NUMERIC(18,8) | 19 |
| 22 | CREDITCODE | CHARACTER VARYING(3) | 3 |
| 23 | CUSTACCTNO | CHARACTER VARYING(18) | 18 |
| 24 | CUSTAMT | NUMERIC(19,4) | 19 |
| 25 | CUSTFEECCY | CHARACTER VARYING(3) | 3 |
| 26 | CUSTMARGIN | NUMERIC(19,4) | 19 |
| 27 | CUSTRATE | NUMERIC(19,4) | 19 |
| 28 | DEALDATE | CHARACTER VARYING(10) | 10 |
| 29 | DELIVERYIND | CHARACTER VARYING(1) | 1 |
| 30 | DELVCODE | CHARACTER VARYING(10) | 10 |
| 31 | DISPCONTPRICE_8 | NUMERIC(18,8) | 19 |
| 32 | EFPFWDPOINTS_8 | NUMERIC(18,8) | 19 |
| 33 | EFPIND | CHARACTER VARYING(1) | 1 |
| 34 | EFPSPOTPRICE_8 | NUMERIC(18,8) | 19 |
| 35 | EXCHANGE | CHARACTER VARYING(11) | 11 |
| 36 | EXECCOMMAMT | NUMERIC(19,4) | 19 |
| 37 | EXECCOMMRATE | NUMERIC(19,4) | 19 |
| 38 | FEEAMT | NUMERIC(19,4) | 19 |
| 39 | FEECCY | CHARACTER VARYING(3) | 3 |
| 40 | HDGEFWDPOINTS_8 | NUMERIC(18,8) | 19 |
| 41 | HDGESPOTPRICE_8 | NUMERIC(18,8) | 19 |
| 42 | INTSOURCE | CHARACTER VARYING(20) | 20 |
| 43 | ORIGBROKNO | CHARACTER VARYING(10) | 10 |
| 44 | ORIGDEALEXTVAL_8 | NUMERIC(18,8) | 19 |
| 45 | ORIGDEALNO | CHARACTER VARYING(8) | 8 |
| 46 | ORIGNUMCONT | NUMERIC(19,4) | 19 |
| 47 | PMEUNREALPL | NUMERIC(19,4) | 19 |
| 48 | PS | CHARACTER VARYING(1) | 1 |
| 49 | PSDATE | CHARACTER VARYING(10) | 10 |
| 50 | PSMETHOD | CHARACTER VARYING(4) | 4 |
| 51 | PSOPER | CHARACTER VARYING(4) | 4 |
| 52 | PSSEQ | CHARACTER VARYING(4) | 4 |
| 53 | PURPOSE | CHARACTER VARYING(1) | 1 |
| 54 | PYEUNREALPL | NUMERIC(19,4) | 19 |
| 55 | SEQ | CHARACTER VARYING(4) | 4 |
| 56 | SETACCT | CHARACTER VARYING(15) | 15 |
| 57 | SETMEANS | CHARACTER VARYING(7) | 7 |
| 58 | SPOTCOST | CHARACTER VARYING(11) | 11 |
| 59 | SPOTPORT | CHARACTER VARYING(4) | 4 |
| 60 | SPOTTRAD | CHARACTER VARYING(4) | 4 |
| 61 | TDYREALPL | NUMERIC(19,4) | 19 |
| 62 | TDYUNREALPL | NUMERIC(19,4) | 19 |
| 63 | UPDATECOUNTER | BIGINT | 8 |
| 64 | YSTREALPL | NUMERIC(19,4) | 19 |
| 65 | YSTUNREALPL | NUMERIC(19,4) | 19 |
| 66 | PORTFOLIO_DATE | CHARACTER VARYING(10) | 10 |
| 67 | BROKNO | CHARACTER VARYING(11) | 11 |
| 68 | LSTMNTDTE | CHARACTER VARYING(10) | 10 |
| 69 | INPUTDATE | CHARACTER VARYING(10) | 10 |
| 70 | VERDATE | CHARACTER VARYING(10) | 10 |
| 71 | VERIND | CHARACTER VARYING(1) | 1 |
| 72 | ACCTMETHOD | CHARACTER VARYING(1) | 1 |
| 73 | ALLOCTIME | CHARACTER VARYING(8) | 8 |
| 74 | AMOUNT1 | NUMERIC(19,4) | 19 |
| 75 | AMOUNT2 | NUMERIC(19,4) | 19 |
| 76 | AMOUNT3 | NUMERIC(19,4) | 19 |
| 77 | CHAR1 | CHARACTER VARYING(20) | 20 |
| 78 | CHAR2 | CHARACTER VARYING(20) | 20 |
| 79 | CHAR3 | CHARACTER VARYING(20) | 20 |
| 80 | DATE1 | CHARACTER VARYING(10) | 10 |
| 81 | DATE2 | CHARACTER VARYING(10) | 10 |
| 82 | DEALTEXT | CHARACTER VARYING(70) | 70 |
| 83 | FLAG1 | CHARACTER VARYING(1) | 1 |
| 84 | INPUTTIME | CHARACTER VARYING(8) | 8 |
| 85 | IVATAX | NUMERIC(19,4) | 19 |
| 86 | LINKDEALNO | CHARACTER VARYING(15) | 15 |
| 87 | LINKSEQ | CHARACTER VARYING(4) | 4 |
| 88 | RATE1_8 | NUMERIC(18,8) | 19 |
| 89 | RATE2_8 | NUMERIC(18,8) | 19 |
| 90 | REVCOMMAMT | NUMERIC(19,4) | 19 |
| 91 | REVFEEAMT | NUMERIC(19,4) | 19 |
| 92 | REVMETHOD | CHARACTER VARYING(1) | 1 |
| 93 | REVNUMCONT | NUMERIC(19,4) | 19 |
| 94 | REVOPER | CHARACTER VARYING(4) | 4 |
| 95 | REVPSDATE | CHARACTER VARYING(10) | 10 |
| 96 | REVREASON | CHARACTER VARYING(2) | 2 |
| 97 | REVTEXT | CHARACTER VARYING(70) | 70 |
| 98 | REVTIME | CHARACTER VARYING(8) | 8 |
| 99 | TENOR | CHARACTER VARYING(2) | 2 |
| 100 | TRADER | CHARACTER VARYING(4) | 4 |
| 101 | TRDTIME | CHARACTER VARYING(8) | 8 |
| 102 | UNDACCTNGTYPE | CHARACTER VARYING(10) | 10 |
| 103 | UNDDEALNO | CHARACTER VARYING(8) | 8 |
| 104 | UNDPRODUCT | CHARACTER VARYING(6) | 6 |
| 105 | UNDSECID | CHARACTER VARYING(20) | 20 |
| 106 | UNDSEQ | CHARACTER VARYING(4) | 4 |
| 107 | UNDTENOR | CHARACTER VARYING(2) | 2 |
| 108 | UNDTYPE | CHARACTER VARYING(2) | 2 |
| 109 | VOPER | CHARACTER VARYING(4) | 4 |
| 110 | DELTA_TYPE | CHARACTER VARYING(1) | 1 |
| 111 | EFFECTIVE_STRT_DT | TIMESTAMP | 8 |
| 112 | EFFECTIVE_END_DT | TIMESTAMP | 8 |
| 113 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 114 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 115 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 116 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |