OEB_GL_DAILY_BALANCES_B
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | LEDGER_ID | BIGINT | 8 |
| 2 | CODE_COMBINATION_ID | BIGINT | 8 |
| 3 | CURRENCY_CODE | CHARACTER VARYING(15) | 15 |
| 4 | CURRENCY_TYPE | CHARACTER VARYING(1) | 1 |
| 5 | ACTUAL_FLAG | CHARACTER VARYING(1) | 1 |
| 6 | PERIOD_NAME | CHARACTER VARYING(15) | 15 |
| 7 | PERIOD_START_DATE | TIMESTAMP | 8 |
| 8 | PERIOD_END_DATE | TIMESTAMP | 8 |
| 9 | QUARTER_START_DATE | TIMESTAMP | 8 |
| 10 | YEAR_START_DATE | TIMESTAMP | 8 |
| 11 | CREATION_DATE | TIMESTAMP | 8 |
| 12 | CREATED_BY | BIGINT | 8 |
| 13 | LAST_UPDATE_DATE | TIMESTAMP | 8 |
| 14 | LAST_UPDATED_BY | BIGINT | 8 |
| 15 | LAST_UPDATE_LOGIN | BIGINT | 8 |
| 16 | CONVERTED_FROM_CURRENCY | CHARACTER VARYING(15) | 15 |
| 17 | PERIOD_TYPE | CHARACTER VARYING(15) | 15 |
| 18 | PERIOD_YEAR | BIGINT | 8 |
| 19 | PERIOD_NUM | BIGINT | 8 |
| 20 | TEMPLATE_ID | BIGINT | 8 |
| 21 | OPENING_PERIOD_AGGREGATE | NUMERIC(18,2) | 19 |
| 22 | OPENING_QUARTER_AGGREGATE | NUMERIC(18,2) | 19 |
| 23 | OPENING_YEAR_AGGREGATE | NUMERIC(18,2) | 19 |
| 24 | PERIOD_AGGREGATE1 | NUMERIC(18,2) | 19 |
| 25 | PERIOD_AGGREGATE2 | NUMERIC(18,2) | 19 |
| 26 | PERIOD_AGGREGATE3 | NUMERIC(18,2) | 19 |
| 27 | PERIOD_AGGREGATE4 | NUMERIC(18,2) | 19 |
| 28 | PERIOD_AGGREGATE5 | NUMERIC(18,2) | 19 |
| 29 | PERIOD_AGGREGATE6 | NUMERIC(18,2) | 19 |
| 30 | PERIOD_AGGREGATE7 | NUMERIC(18,2) | 19 |
| 31 | PERIOD_AGGREGATE8 | NUMERIC(18,2) | 19 |
| 32 | PERIOD_AGGREGATE9 | NUMERIC(18,2) | 19 |
| 33 | PERIOD_AGGREGATE10 | NUMERIC(18,2) | 19 |
| 34 | PERIOD_AGGREGATE11 | NUMERIC(18,2) | 19 |
| 35 | PERIOD_AGGREGATE12 | NUMERIC(18,2) | 19 |
| 36 | PERIOD_AGGREGATE13 | NUMERIC(18,2) | 19 |
| 37 | PERIOD_AGGREGATE14 | NUMERIC(18,2) | 19 |
| 38 | PERIOD_AGGREGATE15 | NUMERIC(18,2) | 19 |
| 39 | PERIOD_AGGREGATE16 | NUMERIC(18,2) | 19 |
| 40 | PERIOD_AGGREGATE17 | NUMERIC(18,2) | 19 |
| 41 | PERIOD_AGGREGATE18 | NUMERIC(18,2) | 19 |
| 42 | PERIOD_AGGREGATE19 | NUMERIC(18,2) | 19 |
| 43 | PERIOD_AGGREGATE20 | NUMERIC(18,2) | 19 |
| 44 | PERIOD_AGGREGATE21 | NUMERIC(18,2) | 19 |
| 45 | PERIOD_AGGREGATE22 | NUMERIC(18,2) | 19 |
| 46 | PERIOD_AGGREGATE23 | NUMERIC(18,2) | 19 |
| 47 | PERIOD_AGGREGATE24 | NUMERIC(18,2) | 19 |
| 48 | PERIOD_AGGREGATE25 | NUMERIC(18,2) | 19 |
| 49 | PERIOD_AGGREGATE26 | NUMERIC(18,2) | 19 |
| 50 | PERIOD_AGGREGATE27 | NUMERIC(18,2) | 19 |
| 51 | PERIOD_AGGREGATE28 | NUMERIC(18,2) | 19 |
| 52 | PERIOD_AGGREGATE29 | NUMERIC(18,2) | 19 |
| 53 | PERIOD_AGGREGATE30 | NUMERIC(18,2) | 19 |
| 54 | PERIOD_AGGREGATE31 | NUMERIC(18,2) | 19 |
| 55 | PERIOD_AGGREGATE32 | NUMERIC(18,2) | 19 |
| 56 | PERIOD_AGGREGATE33 | NUMERIC(18,2) | 19 |
| 57 | PERIOD_AGGREGATE34 | NUMERIC(18,2) | 19 |
| 58 | PERIOD_AGGREGATE35 | NUMERIC(18,2) | 19 |
| 59 | END_OF_DAY1 | NUMERIC(18,2) | 19 |
| 60 | END_OF_DAY2 | NUMERIC(18,2) | 19 |
| 61 | END_OF_DAY3 | NUMERIC(18,2) | 19 |
| 62 | END_OF_DAY4 | NUMERIC(18,2) | 19 |
| 63 | END_OF_DAY5 | NUMERIC(18,2) | 19 |
| 64 | END_OF_DAY6 | NUMERIC(18,2) | 19 |
| 65 | END_OF_DAY7 | NUMERIC(18,2) | 19 |
| 66 | END_OF_DAY8 | NUMERIC(18,2) | 19 |
| 67 | END_OF_DAY9 | NUMERIC(18,2) | 19 |
| 68 | END_OF_DAY10 | NUMERIC(18,2) | 19 |
| 69 | END_OF_DAY11 | NUMERIC(18,2) | 19 |
| 70 | END_OF_DAY12 | NUMERIC(18,2) | 19 |
| 71 | END_OF_DAY13 | NUMERIC(18,2) | 19 |
| 72 | END_OF_DAY14 | NUMERIC(18,2) | 19 |
| 73 | END_OF_DAY15 | NUMERIC(18,2) | 19 |
| 74 | END_OF_DAY16 | NUMERIC(18,2) | 19 |
| 75 | END_OF_DAY17 | NUMERIC(18,2) | 19 |
| 76 | END_OF_DAY18 | NUMERIC(18,2) | 19 |
| 77 | END_OF_DAY19 | NUMERIC(18,2) | 19 |
| 78 | END_OF_DAY20 | NUMERIC(18,2) | 19 |
| 79 | END_OF_DAY21 | NUMERIC(18,2) | 19 |
| 80 | END_OF_DAY22 | NUMERIC(18,2) | 19 |
| 81 | END_OF_DAY23 | NUMERIC(18,2) | 19 |
| 82 | END_OF_DAY24 | NUMERIC(18,2) | 19 |
| 83 | END_OF_DAY25 | NUMERIC(18,2) | 19 |
| 84 | END_OF_DAY26 | NUMERIC(18,2) | 19 |
| 85 | END_OF_DAY27 | NUMERIC(18,2) | 19 |
| 86 | END_OF_DAY28 | NUMERIC(18,2) | 19 |
| 87 | END_OF_DAY29 | NUMERIC(18,2) | 19 |
| 88 | END_OF_DAY30 | NUMERIC(18,2) | 19 |
| 89 | END_OF_DAY31 | NUMERIC(18,2) | 19 |
| 90 | END_OF_DAY32 | NUMERIC(18,2) | 19 |
| 91 | END_OF_DAY33 | NUMERIC(18,2) | 19 |
| 92 | END_OF_DAY34 | NUMERIC(18,2) | 19 |
| 93 | END_OF_DAY35 | NUMERIC(18,2) | 19 |
| 94 | QUARTER_AGGREGATE1 | NUMERIC(18,2) | 19 |
| 95 | QUARTER_AGGREGATE2 | NUMERIC(18,2) | 19 |
| 96 | QUARTER_AGGREGATE3 | NUMERIC(18,2) | 19 |
| 97 | QUARTER_AGGREGATE4 | NUMERIC(18,2) | 19 |
| 98 | QUARTER_AGGREGATE5 | NUMERIC(18,2) | 19 |
| 99 | QUARTER_AGGREGATE6 | NUMERIC(18,2) | 19 |
| 100 | QUARTER_AGGREGATE7 | NUMERIC(18,2) | 19 |
| 101 | QUARTER_AGGREGATE8 | NUMERIC(18,2) | 19 |
| 102 | QUARTER_AGGREGATE9 | NUMERIC(18,2) | 19 |
| 103 | QUARTER_AGGREGATE10 | NUMERIC(18,2) | 19 |
| 104 | QUARTER_AGGREGATE11 | NUMERIC(18,2) | 19 |
| 105 | QUARTER_AGGREGATE12 | NUMERIC(18,2) | 19 |
| 106 | QUARTER_AGGREGATE13 | NUMERIC(18,2) | 19 |
| 107 | QUARTER_AGGREGATE14 | NUMERIC(18,2) | 19 |
| 108 | QUARTER_AGGREGATE15 | NUMERIC(18,2) | 19 |
| 109 | QUARTER_AGGREGATE16 | NUMERIC(18,2) | 19 |
| 110 | QUARTER_AGGREGATE17 | NUMERIC(18,2) | 19 |
| 111 | QUARTER_AGGREGATE18 | NUMERIC(18,2) | 19 |
| 112 | QUARTER_AGGREGATE19 | NUMERIC(18,2) | 19 |
| 113 | QUARTER_AGGREGATE20 | NUMERIC(18,2) | 19 |
| 114 | QUARTER_AGGREGATE21 | NUMERIC(18,2) | 19 |
| 115 | QUARTER_AGGREGATE22 | NUMERIC(18,2) | 19 |
| 116 | QUARTER_AGGREGATE23 | NUMERIC(18,2) | 19 |
| 117 | QUARTER_AGGREGATE24 | NUMERIC(18,2) | 19 |
| 118 | QUARTER_AGGREGATE25 | NUMERIC(18,2) | 19 |
| 119 | QUARTER_AGGREGATE26 | NUMERIC(18,2) | 19 |
| 120 | QUARTER_AGGREGATE27 | NUMERIC(18,2) | 19 |
| 121 | QUARTER_AGGREGATE28 | NUMERIC(18,2) | 19 |
| 122 | QUARTER_AGGREGATE29 | NUMERIC(18,2) | 19 |
| 123 | QUARTER_AGGREGATE30 | NUMERIC(18,2) | 19 |
| 124 | QUARTER_AGGREGATE31 | NUMERIC(18,2) | 19 |
| 125 | QUARTER_AGGREGATE32 | NUMERIC(18,2) | 19 |
| 126 | QUARTER_AGGREGATE33 | NUMERIC(18,2) | 19 |
| 127 | QUARTER_AGGREGATE34 | NUMERIC(18,2) | 19 |
| 128 | QUARTER_AGGREGATE35 | NUMERIC(18,2) | 19 |
| 129 | YEAR_AGGREGATE1 | NUMERIC(18,2) | 19 |
| 130 | YEAR_AGGREGATE2 | NUMERIC(18,2) | 19 |
| 131 | YEAR_AGGREGATE3 | NUMERIC(18,2) | 19 |
| 132 | YEAR_AGGREGATE4 | NUMERIC(18,2) | 19 |
| 133 | YEAR_AGGREGATE5 | NUMERIC(18,2) | 19 |
| 134 | YEAR_AGGREGATE6 | NUMERIC(18,2) | 19 |
| 135 | YEAR_AGGREGATE7 | NUMERIC(18,2) | 19 |
| 136 | YEAR_AGGREGATE8 | NUMERIC(18,2) | 19 |
| 137 | YEAR_AGGREGATE9 | NUMERIC(18,2) | 19 |
| 138 | YEAR_AGGREGATE10 | NUMERIC(18,2) | 19 |
| 139 | YEAR_AGGREGATE11 | NUMERIC(18,2) | 19 |
| 140 | YEAR_AGGREGATE12 | NUMERIC(18,2) | 19 |
| 141 | YEAR_AGGREGATE13 | NUMERIC(18,2) | 19 |
| 142 | YEAR_AGGREGATE14 | NUMERIC(18,2) | 19 |
| 143 | YEAR_AGGREGATE15 | NUMERIC(18,2) | 19 |
| 144 | YEAR_AGGREGATE16 | NUMERIC(18,2) | 19 |
| 145 | YEAR_AGGREGATE17 | NUMERIC(18,2) | 19 |
| 146 | YEAR_AGGREGATE18 | NUMERIC(18,2) | 19 |
| 147 | YEAR_AGGREGATE19 | NUMERIC(18,2) | 19 |
| 148 | YEAR_AGGREGATE20 | NUMERIC(18,2) | 19 |
| 149 | YEAR_AGGREGATE21 | NUMERIC(18,2) | 19 |
| 150 | YEAR_AGGREGATE22 | NUMERIC(18,2) | 19 |
| 151 | YEAR_AGGREGATE23 | NUMERIC(18,2) | 19 |
| 152 | YEAR_AGGREGATE24 | NUMERIC(18,2) | 19 |
| 153 | YEAR_AGGREGATE25 | NUMERIC(18,2) | 19 |
| 154 | YEAR_AGGREGATE26 | NUMERIC(18,2) | 19 |
| 155 | YEAR_AGGREGATE27 | NUMERIC(18,2) | 19 |
| 156 | YEAR_AGGREGATE28 | NUMERIC(18,2) | 19 |
| 157 | YEAR_AGGREGATE29 | NUMERIC(18,2) | 19 |
| 158 | YEAR_AGGREGATE30 | NUMERIC(18,2) | 19 |
| 159 | YEAR_AGGREGATE31 | NUMERIC(18,2) | 19 |
| 160 | YEAR_AGGREGATE32 | NUMERIC(18,2) | 19 |
| 161 | YEAR_AGGREGATE33 | NUMERIC(18,2) | 19 |
| 162 | YEAR_AGGREGATE34 | NUMERIC(18,2) | 19 |
| 163 | YEAR_AGGREGATE35 | NUMERIC(18,2) | 19 |
| 164 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 165 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 166 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 167 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |