OPC_HST_REVP
Description
Synonyms
SDSNZP02_BANK..EFS_OPC_HST_REVP
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | BIGINT | 8 |
| 2 | BR | CHARACTER VARYING(2) | 2 |
| 3 | CCY | CHARACTER VARYING(3) | 3 |
| 4 | SPOTRATE_8 | NUMERIC(18,8) | 19 |
| 5 | TERMS | CHARACTER VARYING(1) | 1 |
| 6 | PERIOD1 | CHARACTER VARYING(4) | 4 |
| 7 | RATE1_8 | NUMERIC(18,8) | 19 |
| 8 | PERIOD2 | CHARACTER VARYING(4) | 4 |
| 9 | RATE2_8 | NUMERIC(18,8) | 19 |
| 10 | PERIOD3 | CHARACTER VARYING(4) | 4 |
| 11 | RATE3_8 | NUMERIC(18,8) | 19 |
| 12 | PERIOD4 | CHARACTER VARYING(4) | 4 |
| 13 | RATE4_8 | NUMERIC(18,8) | 19 |
| 14 | PERIOD5 | CHARACTER VARYING(4) | 4 |
| 15 | RATE5_8 | NUMERIC(18,8) | 19 |
| 16 | PERIOD6 | CHARACTER VARYING(4) | 4 |
| 17 | RATE6_8 | NUMERIC(18,8) | 19 |
| 18 | PERIOD7 | CHARACTER VARYING(4) | 4 |
| 19 | RATE7_8 | NUMERIC(18,8) | 19 |
| 20 | PERIOD8 | CHARACTER VARYING(4) | 4 |
| 21 | RATE8_8 | NUMERIC(18,8) | 19 |
| 22 | PERIOD9 | CHARACTER VARYING(4) | 4 |
| 23 | RATE9_8 | NUMERIC(18,8) | 19 |
| 24 | PERIOD10 | CHARACTER VARYING(4) | 4 |
| 25 | RATE10_8 | NUMERIC(18,8) | 19 |
| 26 | PERIOD11 | CHARACTER VARYING(4) | 4 |
| 27 | RATE11_8 | NUMERIC(18,8) | 19 |
| 28 | PERIOD12 | CHARACTER VARYING(4) | 4 |
| 29 | RATE12_8 | NUMERIC(18,8) | 19 |
| 30 | PERIOD13 | CHARACTER VARYING(4) | 4 |
| 31 | RATE13_8 | NUMERIC(18,8) | 19 |
| 32 | PERIOD14 | CHARACTER VARYING(4) | 4 |
| 33 | RATE14_8 | NUMERIC(18,8) | 19 |
| 34 | PERIOD15 | CHARACTER VARYING(4) | 4 |
| 35 | RATE15_8 | NUMERIC(18,8) | 19 |
| 36 | PERIOD16 | CHARACTER VARYING(4) | 4 |
| 37 | RATE16_8 | NUMERIC(18,8) | 19 |
| 38 | PERIOD17 | CHARACTER VARYING(4) | 4 |
| 39 | RATE17_8 | NUMERIC(18,8) | 19 |
| 40 | PERIOD18 | CHARACTER VARYING(4) | 4 |
| 41 | RATE18_8 | NUMERIC(18,8) | 19 |
| 42 | PERIOD19 | CHARACTER VARYING(4) | 4 |
| 43 | RATE19_8 | NUMERIC(18,8) | 19 |
| 44 | PERIOD20 | CHARACTER VARYING(4) | 4 |
| 45 | RATE20_8 | NUMERIC(18,8) | 19 |
| 46 | PERIOD21 | CHARACTER VARYING(4) | 4 |
| 47 | RATE21_8 | NUMERIC(18,8) | 19 |
| 48 | PERIOD22 | CHARACTER VARYING(4) | 4 |
| 49 | RATE22_8 | NUMERIC(18,8) | 19 |
| 50 | PERIOD23 | CHARACTER VARYING(4) | 4 |
| 51 | RATE23_8 | NUMERIC(18,8) | 19 |
| 52 | PERIOD24 | CHARACTER VARYING(4) | 4 |
| 53 | RATE24_8 | NUMERIC(18,8) | 19 |
| 54 | PERIOD25 | CHARACTER VARYING(4) | 4 |
| 55 | RATE25_8 | NUMERIC(18,8) | 19 |
| 56 | PERIOD26 | CHARACTER VARYING(4) | 4 |
| 57 | RATE26_8 | NUMERIC(18,8) | 19 |
| 58 | PERIOD27 | CHARACTER VARYING(4) | 4 |
| 59 | RATE27_8 | NUMERIC(18,8) | 19 |
| 60 | PERIOD28 | CHARACTER VARYING(4) | 4 |
| 61 | RATE28_8 | NUMERIC(18,8) | 19 |
| 62 | PERIOD29 | CHARACTER VARYING(4) | 4 |
| 63 | RATE29_8 | NUMERIC(18,8) | 19 |
| 64 | PERIOD30 | CHARACTER VARYING(4) | 4 |
| 65 | RATE30_8 | NUMERIC(18,8) | 19 |
| 66 | PERIOD31 | CHARACTER VARYING(4) | 4 |
| 67 | RATE31_8 | NUMERIC(18,8) | 19 |
| 68 | PERIOD32 | CHARACTER VARYING(4) | 4 |
| 69 | RATE32_8 | NUMERIC(18,8) | 19 |
| 70 | PERIOD33 | CHARACTER VARYING(4) | 4 |
| 71 | RATE33_8 | NUMERIC(18,8) | 19 |
| 72 | PERIOD34 | CHARACTER VARYING(4) | 4 |
| 73 | RATE34_8 | NUMERIC(18,8) | 19 |
| 74 | PERIOD35 | CHARACTER VARYING(4) | 4 |
| 75 | RATE35_8 | NUMERIC(18,8) | 19 |
| 76 | PERIOD36 | CHARACTER VARYING(4) | 4 |
| 77 | RATE36_8 | NUMERIC(18,8) | 19 |
| 78 | PERIOD37 | CHARACTER VARYING(4) | 4 |
| 79 | RATE37_8 | NUMERIC(18,8) | 19 |
| 80 | PERIOD38 | CHARACTER VARYING(4) | 4 |
| 81 | RATE38_8 | NUMERIC(18,8) | 19 |
| 82 | PERIOD39 | CHARACTER VARYING(4) | 4 |
| 83 | RATE39_8 | NUMERIC(18,8) | 19 |
| 84 | LSTMNTDATE | CHARACTER VARYING(10) | 10 |
| 85 | DELTA_TYPE | CHARACTER VARYING(1) | 1 |
| 86 | EFFECTIVE_STRT_DT | TIMESTAMP | 8 |
| 87 | EFFECTIVE_END_DT | TIMESTAMP | 8 |
| 88 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 89 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 90 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 91 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |