OPC_HST_SRHR
Description
Synonyms
SDSNZP02_BANK..EFS_OPC_HST_SRHR
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | BIGINT | 8 |
| 2 | BR | CHARACTER VARYING(2) | 2 |
| 3 | CCY | CHARACTER VARYING(3) | 3 |
| 4 | SPOTRATE1_8 | NUMERIC(18,8) | 19 |
| 5 | SPOTRATE10_8 | NUMERIC(18,8) | 19 |
| 6 | SPOTRATE11_8 | NUMERIC(18,8) | 19 |
| 7 | SPOTRATE12_8 | NUMERIC(18,8) | 19 |
| 8 | SPOTRATE13_8 | NUMERIC(18,8) | 19 |
| 9 | SPOTRATE14_8 | NUMERIC(18,8) | 19 |
| 10 | SPOTRATE15_8 | NUMERIC(18,8) | 19 |
| 11 | SPOTRATE16_8 | NUMERIC(18,8) | 19 |
| 12 | SPOTRATE17_8 | NUMERIC(18,8) | 19 |
| 13 | SPOTRATE18_8 | NUMERIC(18,8) | 19 |
| 14 | SPOTRATE19_8 | NUMERIC(18,8) | 19 |
| 15 | SPOTRATE2_8 | NUMERIC(18,8) | 19 |
| 16 | SPOTRATE20_8 | NUMERIC(18,8) | 19 |
| 17 | SPOTRATE21_8 | NUMERIC(18,8) | 19 |
| 18 | SPOTRATE22_8 | NUMERIC(18,8) | 19 |
| 19 | SPOTRATE23_8 | NUMERIC(18,8) | 19 |
| 20 | SPOTRATE24_8 | NUMERIC(18,8) | 19 |
| 21 | SPOTRATE25_8 | NUMERIC(18,8) | 19 |
| 22 | SPOTRATE26_8 | NUMERIC(18,8) | 19 |
| 23 | SPOTRATE27_8 | NUMERIC(18,8) | 19 |
| 24 | SPOTRATE28_8 | NUMERIC(18,8) | 19 |
| 25 | SPOTRATE29_8 | NUMERIC(18,8) | 19 |
| 26 | SPOTRATE3_8 | NUMERIC(18,8) | 19 |
| 27 | SPOTRATE30_8 | NUMERIC(18,8) | 19 |
| 28 | SPOTRATE31_8 | NUMERIC(18,8) | 19 |
| 29 | SPOTRATE4_8 | NUMERIC(18,8) | 19 |
| 30 | SPOTRATE5_8 | NUMERIC(18,8) | 19 |
| 31 | SPOTRATE6_8 | NUMERIC(18,8) | 19 |
| 32 | SPOTRATE7_8 | NUMERIC(18,8) | 19 |
| 33 | SPOTRATE8_8 | NUMERIC(18,8) | 19 |
| 34 | SPOTRATE9_8 | NUMERIC(18,8) | 19 |
| 35 | TERMS1 | CHARACTER VARYING(1) | 1 |
| 36 | TERMS10 | CHARACTER VARYING(1) | 1 |
| 37 | TERMS11 | CHARACTER VARYING(1) | 1 |
| 38 | TERMS12 | CHARACTER VARYING(1) | 1 |
| 39 | TERMS13 | CHARACTER VARYING(1) | 1 |
| 40 | TERMS14 | CHARACTER VARYING(1) | 1 |
| 41 | TERMS15 | CHARACTER VARYING(1) | 1 |
| 42 | TERMS16 | CHARACTER VARYING(1) | 1 |
| 43 | TERMS17 | CHARACTER VARYING(1) | 1 |
| 44 | TERMS18 | CHARACTER VARYING(1) | 1 |
| 45 | TERMS19 | CHARACTER VARYING(1) | 1 |
| 46 | TERMS2 | CHARACTER VARYING(1) | 1 |
| 47 | TERMS20 | CHARACTER VARYING(1) | 1 |
| 48 | TERMS21 | CHARACTER VARYING(1) | 1 |
| 49 | TERMS22 | CHARACTER VARYING(1) | 1 |
| 50 | TERMS23 | CHARACTER VARYING(1) | 1 |
| 51 | TERMS24 | CHARACTER VARYING(1) | 1 |
| 52 | TERMS25 | CHARACTER VARYING(1) | 1 |
| 53 | TERMS26 | CHARACTER VARYING(1) | 1 |
| 54 | TERMS27 | CHARACTER VARYING(1) | 1 |
| 55 | TERMS28 | CHARACTER VARYING(1) | 1 |
| 56 | TERMS29 | CHARACTER VARYING(1) | 1 |
| 57 | TERMS3 | CHARACTER VARYING(1) | 1 |
| 58 | TERMS30 | CHARACTER VARYING(1) | 1 |
| 59 | TERMS31 | CHARACTER VARYING(1) | 1 |
| 60 | TERMS4 | CHARACTER VARYING(1) | 1 |
| 61 | TERMS5 | CHARACTER VARYING(1) | 1 |
| 62 | TERMS6 | CHARACTER VARYING(1) | 1 |
| 63 | TERMS7 | CHARACTER VARYING(1) | 1 |
| 64 | TERMS8 | CHARACTER VARYING(1) | 1 |
| 65 | TERMS9 | CHARACTER VARYING(1) | 1 |
| 66 | YRMONTH | CHARACTER VARYING(7) | 7 |
| 67 | LSTMNTDTE | CHARACTER VARYING(10) | 10 |
| 68 | DELTA_TYPE | CHARACTER VARYING(1) | 1 |
| 69 | EFFECTIVE_STRT_DT | TIMESTAMP | 8 |
| 70 | EFFECTIVE_END_DT | TIMESTAMP | 8 |
| 71 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 72 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 73 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 74 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |