XCC_BUDGET_ENTRY_INTERFACE
This table is used by the Budget Upload ADFdi, not for customers.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
XCC_BUDGET_ENTRY_INT_PK |
BUDGET_ENTRY_INT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTROL_BUDGET_ID | NUMBER | 18 | Yes | The control budget for which budget amounts are entered in the spreadsheet | |
| LINE_NUMBER | NUMBER | 18 | Yes | Unique row for source application, source budget and dataset | |
| BUDGET_YEAR | NUMBER | 18 | Yes | The budget year for which the budget data is entered in the spreadsheet | |
| BUDGET_CCID | NUMBER | 18 | Yes | The budget account code combination id. | |
| SEGMENT1 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT11 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT12 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT13 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT14 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT15 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT16 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT17 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT18 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT19 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT20 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT21 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT22 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT23 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT24 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT25 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT26 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT27 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT28 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT29 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT30 | VARCHAR2 | 50 | Key Flexfield: segment of the key flexfield. | ||
| AMOUNT1 | NUMBER | The budget amount for the 1st period of the budget year | |||
| AMOUNT2 | NUMBER | The budget amount for the 2nd period of the budget year | |||
| AMOUNT3 | NUMBER | The budget amount for the 3rd period of the budget year | |||
| AMOUNT4 | NUMBER | The budget amount for the 4th period of the budget year | |||
| AMOUNT5 | NUMBER | The budget amount for the 5th period of the budget year | |||
| AMOUNT6 | NUMBER | The budget amount for the 6th period of the budget year | |||
| AMOUNT7 | NUMBER | The budget amount for the 7th period of the budget year | |||
| AMOUNT8 | NUMBER | The budget amount for the 8th period of the budget year | |||
| AMOUNT9 | NUMBER | The budget amount for the 9th period of the budget year | |||
| AMOUNT10 | NUMBER | The budget amount for the 10th period of the budget year | |||
| AMOUNT11 | NUMBER | The budget amount for the 11th period of the budget year | |||
| AMOUNT12 | NUMBER | The budget amount for the 12th period of the budget year | |||
| AMOUNT13 | NUMBER | The budget amount for the 13th period of the budget year | |||
| AMOUNT14 | NUMBER | The budget amount for the 14th period of the budget year | |||
| AMOUNT15 | NUMBER | The budget amount for the 15th period of the budget year | |||
| AMOUNT16 | NUMBER | The budget amount for the 16th period of the budget year | |||
| AMOUNT17 | NUMBER | The budget amount for the 17th period of the budget year | |||
| AMOUNT18 | NUMBER | The budget amount for the 18th period of the budget year | |||
| AMOUNT19 | NUMBER | The budget amount for the 19th period of the budget year | |||
| AMOUNT20 | NUMBER | The budget amount for the 20th period of the budget year | |||
| AMOUNT21 | NUMBER | The budget amount for the 21st period of the budget year | |||
| AMOUNT22 | NUMBER | The budget amount for the 22nd period of the budget year | |||
| AMOUNT23 | NUMBER | The budget amount for the 23rd period of the budget year | |||
| AMOUNT24 | NUMBER | The budget amount for the 24th period of the budget year | |||
| AMOUNT25 | NUMBER | The budget amount for the 25th period of the budget year | |||
| AMOUNT26 | NUMBER | The budget amount for the 26th period of the budget year | |||
| AMOUNT27 | NUMBER | The budget amount for the 27th period of the budget year | |||
| AMOUNT28 | NUMBER | The budget amount for the 28th period of the budget year | |||
| AMOUNT29 | NUMBER | The budget amount for the 29th period of the budget year | |||
| AMOUNT30 | NUMBER | The budget amount for the 30th period of the budget year | |||
| AMOUNT31 | NUMBER | The budget amount for the 31st period of the budget year | |||
| AMOUNT32 | NUMBER | The budget amount for the 32nd period of the budget year | |||
| AMOUNT33 | NUMBER | The budget amount for the 33rd period of the budget year | |||
| AMOUNT34 | NUMBER | The budget amount for the 34th period of the budget year | |||
| AMOUNT35 | NUMBER | The budget amount for the 35th period of the budget year | |||
| AMOUNT36 | NUMBER | The budget amount for the 36th period of the budget year | |||
| AMOUNT37 | NUMBER | The budget amount for the 37th period of the budget year | |||
| AMOUNT38 | NUMBER | The budget amount for the 38th period of the budget year | |||
| AMOUNT39 | NUMBER | The budget amount for the 39th period of the budget year | |||
| AMOUNT40 | NUMBER | The budget amount for the 40th period of the budget year | |||
| AMOUNT41 | NUMBER | The budget amount for the 41st period of the budget year | |||
| AMOUNT42 | NUMBER | The budget amount for the 42nd period of the budget year | |||
| AMOUNT43 | NUMBER | The budget amount for the 43rd period of the budget year | |||
| AMOUNT44 | NUMBER | The budget amount for the 44th period of the budget year | |||
| AMOUNT45 | NUMBER | The budget amount for the 45th period of the budget year | |||
| AMOUNT46 | NUMBER | The budget amount for the 46th period of the budget year | |||
| AMOUNT47 | NUMBER | The budget amount for the 47th period of the budget year | |||
| AMOUNT48 | NUMBER | The budget amount for the 48th period of the budget year | |||
| AMOUNT49 | NUMBER | The budget amount for the 49th period of the budget year | |||
| AMOUNT50 | NUMBER | The budget amount for the 50th period of the budget year | |||
| AMOUNT51 | NUMBER | The budget amount for the 51st period of the budget year | |||
| AMOUNT52 | NUMBER | The budget amount for the 52nd period of the budget year | |||
| AMOUNT53 | NUMBER | The budget amount for the 53rd period of the budget year | |||
| AMOUNT54 | NUMBER | The budget amount for the 54th period of the budget year | |||
| AMOUNT55 | NUMBER | The budget amount for the 55th period of the budget year | |||
| AMOUNT56 | NUMBER | The budget amount for the 56th period of the budget year | |||
| AMOUNT57 | NUMBER | The budget amount for the 57th period of the budget year | |||
| AMOUNT58 | NUMBER | The budget amount for the 58th period of the budget year | |||
| AMOUNT59 | NUMBER | The budget amount for the 59th period of the budget year | |||
| AMOUNT60 | NUMBER | The budget amount for the 60th period of the budget year | |||
| AMOUNT61 | NUMBER | The budget amount for the 61st period of the budget year | |||
| AMOUNT62 | NUMBER | The budget amount for the 62nd period of the budget year | |||
| AMOUNT63 | NUMBER | The budget amount for the 63rd period of the budget year | |||
| AMOUNT64 | NUMBER | The budget amount for the 64th period of the budget year | |||
| AMOUNT65 | NUMBER | The budget amount for the 65th period of the budget year | |||
| AMOUNT66 | NUMBER | The budget amount for the 66th period of the budget year | |||
| AMOUNT67 | NUMBER | The budget amount for the 67th period of the budget year | |||
| AMOUNT68 | NUMBER | The budget amount for the 68th period of the budget year | |||
| AMOUNT69 | NUMBER | The budget amount for the 69th period of the budget year | |||
| AMOUNT70 | NUMBER | The budget amount for the 70th period of the budget year | |||
| AMOUNT71 | NUMBER | The budget amount for the 71st period of the budget year | |||
| AMOUNT72 | NUMBER | The budget amount for the 72nd period of the budget year | |||
| AMOUNT73 | NUMBER | The budget amount for the 73rd period of the budget year | |||
| AMOUNT74 | NUMBER | The budget amount for the 74th period of the budget year | |||
| AMOUNT75 | NUMBER | The budget amount for the 75th period of the budget year | |||
| AMOUNT76 | NUMBER | The budget amount for the 76th period of the budget year | |||
| AMOUNT77 | NUMBER | The budget amount for the 77th period of the budget year | |||
| AMOUNT78 | NUMBER | The budget amount for the 78th period of the budget year | |||
| AMOUNT79 | NUMBER | The budget amount for the 79th period of the budget year | |||
| AMOUNT80 | NUMBER | The budget amount for the 80th period of the budget year | |||
| AMOUNT81 | NUMBER | The budget amount for the 81st period of the budget year | |||
| AMOUNT82 | NUMBER | The budget amount for the 82nd period of the budget year | |||
| AMOUNT83 | NUMBER | The budget amount for the 83rd period of the budget year | |||
| AMOUNT84 | NUMBER | The budget amount for the 84th period of the budget year | |||
| AMOUNT85 | NUMBER | The budget amount for the 85th period of the budget year | |||
| AMOUNT86 | NUMBER | The budget amount for the 86th period of the budget year | |||
| AMOUNT87 | NUMBER | The budget amount for the 87th period of the budget year | |||
| AMOUNT88 | NUMBER | The budget amount for the 88th period of the budget year | |||
| AMOUNT89 | NUMBER | The budget amount for the 89th period of the budget year | |||
| AMOUNT90 | NUMBER | The budget amount for the 90th period of the budget year | |||
| AMOUNT91 | NUMBER | The budget amount for the 91st period of the budget year | |||
| AMOUNT92 | NUMBER | The budget amount for the 92nd period of the budget year | |||
| AMOUNT93 | NUMBER | The budget amount for the 93rd period of the budget year | |||
| AMOUNT94 | NUMBER | The budget amount for the 94th period of the budget year | |||
| AMOUNT95 | NUMBER | The budget amount for the 95th period of the budget year | |||
| AMOUNT96 | NUMBER | The budget amount for the 96th period of the budget year | |||
| AMOUNT97 | NUMBER | The budget amount for the 97th period of the budget year | |||
| AMOUNT98 | NUMBER | The budget amount for the 98th period of the budget year | |||
| AMOUNT99 | NUMBER | The budget amount for the 99th period of the budget year | |||
| AMOUNT100 | NUMBER | The budget amount for the 100th period of the budget year | |||
| AMOUNT101 | NUMBER | The budget amount for the 101st period of the budget year | |||
| AMOUNT102 | NUMBER | The budget amount for the 102nd period of the budget year | |||
| AMOUNT103 | NUMBER | The budget amount for the 103rd period of the budget year | |||
| AMOUNT104 | NUMBER | The budget amount for the 104th period of the budget year | |||
| AMOUNT105 | NUMBER | The budget amount for the 105th period of the budget year | |||
| AMOUNT106 | NUMBER | The budget amount for the 106th period of the budget year | |||
| AMOUNT107 | NUMBER | The budget amount for the 107th period of the budget year | |||
| AMOUNT108 | NUMBER | The budget amount for the 108th period of the budget year | |||
| AMOUNT109 | NUMBER | The budget amount for the 109th period of the budget year | |||
| AMOUNT110 | NUMBER | The budget amount for the 110th period of the budget year | |||
| AMOUNT111 | NUMBER | The budget amount for the 111th period of the budget year | |||
| AMOUNT112 | NUMBER | The budget amount for the 112th period of the budget year | |||
| AMOUNT113 | NUMBER | The budget amount for the 113th period of the budget year | |||
| AMOUNT114 | NUMBER | The budget amount for the 114th period of the budget year | |||
| AMOUNT115 | NUMBER | The budget amount for the 115th period of the budget year | |||
| AMOUNT116 | NUMBER | The budget amount for the 116th period of the budget year | |||
| AMOUNT117 | NUMBER | The budget amount for the 117th period of the budget year | |||
| AMOUNT118 | NUMBER | The budget amount for the 118th period of the budget year | |||
| AMOUNT119 | NUMBER | The budget amount for the 119th period of the budget year | |||
| AMOUNT120 | NUMBER | The budget amount for the 120th period of the budget year | |||
| AMOUNT121 | NUMBER | The budget amount for the 121st period of the budget year | |||
| AMOUNT122 | NUMBER | The budget amount for the 122nd period of the budget year | |||
| AMOUNT123 | NUMBER | The budget amount for the 123rd period of the budget year | |||
| AMOUNT124 | NUMBER | The budget amount for the 124th period of the budget year | |||
| AMOUNT125 | NUMBER | The budget amount for the 125th period of the budget year | |||
| AMOUNT126 | NUMBER | The budget amount for the 126th period of the budget year | |||
| AMOUNT127 | NUMBER | The budget amount for the 127th period of the budget year | |||
| AMOUNT128 | NUMBER | The budget amount for the 128th period of the budget year | |||
| AMOUNT129 | NUMBER | The budget amount for the 129th period of the budget year | |||
| AMOUNT130 | NUMBER | The budget amount for the 130th period of the budget year | |||
| AMOUNT131 | NUMBER | The budget amount for the 131st period of the budget year | |||
| AMOUNT132 | NUMBER | The budget amount for the 132nd period of the budget year | |||
| AMOUNT133 | NUMBER | The budget amount for the 133rd period of the budget year | |||
| AMOUNT134 | NUMBER | The budget amount for the 134th period of the budget year | |||
| AMOUNT135 | NUMBER | The budget amount for the 135th period of the budget year | |||
| AMOUNT136 | NUMBER | The budget amount for the 136th period of the budget year | |||
| AMOUNT137 | NUMBER | The budget amount for the 137th period of the budget year | |||
| AMOUNT138 | NUMBER | The budget amount for the 138th period of the budget year | |||
| AMOUNT139 | NUMBER | The budget amount for the 139th period of the budget year | |||
| AMOUNT140 | NUMBER | The budget amount for the 140th period of the budget year | |||
| AMOUNT141 | NUMBER | The budget amount for the 141st period of the budget year | |||
| AMOUNT142 | NUMBER | The budget amount for the 142nd period of the budget year | |||
| AMOUNT143 | NUMBER | The budget amount for the 143rd period of the budget year | |||
| AMOUNT144 | NUMBER | The budget amount for the 144th period of the budget year | |||
| AMOUNT145 | NUMBER | The budget amount for the 145th period of the budget year | |||
| AMOUNT146 | NUMBER | The budget amount for the 146th period of the budget year | |||
| AMOUNT147 | NUMBER | The budget amount for the 147th period of the budget year | |||
| AMOUNT148 | NUMBER | The budget amount for the 148th period of the budget year | |||
| AMOUNT149 | NUMBER | The budget amount for the 149th period of the budget year | |||
| AMOUNT150 | NUMBER | The budget amount for the 150th period of the budget year | |||
| AMOUNT151 | NUMBER | The budget amount for the 151st period of the budget year | |||
| AMOUNT152 | NUMBER | The budget amount for the 152nd period of the budget year | |||
| AMOUNT153 | NUMBER | The budget amount for the 153rd period of the budget year | |||
| AMOUNT154 | NUMBER | The budget amount for the 154th period of the budget year | |||
| AMOUNT155 | NUMBER | The budget amount for the 155th period of the budget year | |||
| AMOUNT156 | NUMBER | The budget amount for the 156th period of the budget year | |||
| AMOUNT157 | NUMBER | The budget amount for the 157th period of the budget year | |||
| AMOUNT158 | NUMBER | The budget amount for the 158th period of the budget year | |||
| AMOUNT159 | NUMBER | The budget amount for the 159th period of the budget year | |||
| AMOUNT160 | NUMBER | The budget amount for the 160th period of the budget year | |||
| AMOUNT161 | NUMBER | The budget amount for the 161st period of the budget year | |||
| AMOUNT162 | NUMBER | The budget amount for the 162nd period of the budget year | |||
| AMOUNT163 | NUMBER | The budget amount for the 163rd period of the budget year | |||
| AMOUNT164 | NUMBER | The budget amount for the 164th period of the budget year | |||
| AMOUNT165 | NUMBER | The budget amount for the 165th period of the budget year | |||
| AMOUNT166 | NUMBER | The budget amount for the 166th period of the budget year | |||
| AMOUNT167 | NUMBER | The budget amount for the 167th period of the budget year | |||
| AMOUNT168 | NUMBER | The budget amount for the 168th period of the budget year | |||
| AMOUNT169 | NUMBER | The budget amount for the 169th period of the budget year | |||
| AMOUNT170 | NUMBER | The budget amount for the 170th period of the budget year | |||
| AMOUNT171 | NUMBER | The budget amount for the 171st period of the budget year | |||
| AMOUNT172 | NUMBER | The budget amount for the 172nd period of the budget year | |||
| AMOUNT173 | NUMBER | The budget amount for the 173rd period of the budget year | |||
| AMOUNT174 | NUMBER | The budget amount for the 174th period of the budget year | |||
| AMOUNT175 | NUMBER | The budget amount for the 175th period of the budget year | |||
| AMOUNT176 | NUMBER | The budget amount for the 176th period of the budget year | |||
| AMOUNT177 | NUMBER | The budget amount for the 177th period of the budget year | |||
| AMOUNT178 | NUMBER | The budget amount for the 178th period of the budget year | |||
| AMOUNT179 | NUMBER | The budget amount for the 179th period of the budget year | |||
| AMOUNT180 | NUMBER | The budget amount for the 180th period of the budget year | |||
| AMOUNT181 | NUMBER | The budget amount for the 181st period of the budget year | |||
| AMOUNT182 | NUMBER | The budget amount for the 182nd period of the budget year | |||
| AMOUNT183 | NUMBER | The budget amount for the 183rd period of the budget year | |||
| AMOUNT184 | NUMBER | The budget amount for the 184th period of the budget year | |||
| AMOUNT185 | NUMBER | The budget amount for the 185th period of the budget year | |||
| AMOUNT186 | NUMBER | The budget amount for the 186th period of the budget year | |||
| AMOUNT187 | NUMBER | The budget amount for the 187th period of the budget year | |||
| AMOUNT188 | NUMBER | The budget amount for the 188th period of the budget year | |||
| AMOUNT189 | NUMBER | The budget amount for the 189th period of the budget year | |||
| AMOUNT190 | NUMBER | The budget amount for the 190th period of the budget year | |||
| AMOUNT191 | NUMBER | The budget amount for the 191st period of the budget year | |||
| AMOUNT192 | NUMBER | The budget amount for the 192nd period of the budget year | |||
| AMOUNT193 | NUMBER | The budget amount for the 193rd period of the budget year | |||
| AMOUNT194 | NUMBER | The budget amount for the 194th period of the budget year | |||
| AMOUNT195 | NUMBER | The budget amount for the 195th period of the budget year | |||
| AMOUNT196 | NUMBER | The budget amount for the 196th period of the budget year | |||
| AMOUNT197 | NUMBER | The budget amount for the 197th period of the budget year | |||
| AMOUNT198 | NUMBER | The budget amount for the 198th period of the budget year | |||
| AMOUNT199 | NUMBER | The budget amount for the 199th period of the budget year | |||
| AMOUNT200 | NUMBER | The budget amount for the 200th period of the budget year | |||
| AMOUNT201 | NUMBER | The budget amount for the 201st period of the budget year | |||
| AMOUNT202 | NUMBER | The budget amount for the 202nd period of the budget year | |||
| AMOUNT203 | NUMBER | The budget amount for the 203rd period of the budget year | |||
| AMOUNT204 | NUMBER | The budget amount for the 204th period of the budget year | |||
| AMOUNT205 | NUMBER | The budget amount for the 205th period of the budget year | |||
| AMOUNT206 | NUMBER | The budget amount for the 206th period of the budget year | |||
| AMOUNT207 | NUMBER | The budget amount for the 207th period of the budget year | |||
| AMOUNT208 | NUMBER | The budget amount for the 208th period of the budget year | |||
| AMOUNT209 | NUMBER | The budget amount for the 209th period of the budget year | |||
| AMOUNT210 | NUMBER | The budget amount for the 210th period of the budget year | |||
| AMOUNT211 | NUMBER | The budget amount for the 211th period of the budget year | |||
| AMOUNT212 | NUMBER | The budget amount for the 212th period of the budget year | |||
| AMOUNT213 | NUMBER | The budget amount for the 213th period of the budget year | |||
| AMOUNT214 | NUMBER | The budget amount for the 214th period of the budget year | |||
| AMOUNT215 | NUMBER | The budget amount for the 215th period of the budget year | |||
| AMOUNT216 | NUMBER | The budget amount for the 216th period of the budget year | |||
| AMOUNT217 | NUMBER | The budget amount for the 217th period of the budget year | |||
| AMOUNT218 | NUMBER | The budget amount for the 218th period of the budget year | |||
| AMOUNT219 | NUMBER | The budget amount for the 219th period of the budget year | |||
| AMOUNT220 | NUMBER | The budget amount for the 220th period of the budget year | |||
| AMOUNT221 | NUMBER | The budget amount for the 221st period of the budget year | |||
| AMOUNT222 | NUMBER | The budget amount for the 222nd period of the budget year | |||
| AMOUNT223 | NUMBER | The budget amount for the 223rd period of the budget year | |||
| AMOUNT224 | NUMBER | The budget amount for the 224th period of the budget year | |||
| AMOUNT225 | NUMBER | The budget amount for the 225th period of the budget year | |||
| AMOUNT226 | NUMBER | The budget amount for the 226th period of the budget year | |||
| AMOUNT227 | NUMBER | The budget amount for the 227th period of the budget year | |||
| AMOUNT228 | NUMBER | The budget amount for the 228th period of the budget year | |||
| AMOUNT229 | NUMBER | The budget amount for the 229th period of the budget year | |||
| AMOUNT230 | NUMBER | The budget amount for the 230th period of the budget year | |||
| AMOUNT231 | NUMBER | The budget amount for the 231st period of the budget year | |||
| AMOUNT232 | NUMBER | The budget amount for the 232nd period of the budget year | |||
| AMOUNT233 | NUMBER | The budget amount for the 233rd period of the budget year | |||
| AMOUNT234 | NUMBER | The budget amount for the 234th period of the budget year | |||
| AMOUNT235 | NUMBER | The budget amount for the 235th period of the budget year | |||
| AMOUNT236 | NUMBER | The budget amount for the 236th period of the budget year | |||
| AMOUNT237 | NUMBER | The budget amount for the 237th period of the budget year | |||
| AMOUNT238 | NUMBER | The budget amount for the 238th period of the budget year | |||
| AMOUNT239 | NUMBER | The budget amount for the 239th period of the budget year | |||
| AMOUNT240 | NUMBER | The budget amount for the 240th period of the budget year | |||
| AMOUNT241 | NUMBER | The budget amount for the 241st period of the budget year | |||
| AMOUNT242 | NUMBER | The budget amount for the 242nd period of the budget year | |||
| AMOUNT243 | NUMBER | The budget amount for the 243rd period of the budget year | |||
| AMOUNT244 | NUMBER | The budget amount for the 244th period of the budget year | |||
| AMOUNT245 | NUMBER | The budget amount for the 245th period of the budget year | |||
| AMOUNT246 | NUMBER | The budget amount for the 246th period of the budget year | |||
| AMOUNT247 | NUMBER | The budget amount for the 247th period of the budget year | |||
| AMOUNT248 | NUMBER | The budget amount for the 248th period of the budget year | |||
| AMOUNT249 | NUMBER | The budget amount for the 249th period of the budget year | |||
| AMOUNT250 | NUMBER | The budget amount for the 250th period of the budget year | |||
| AMOUNT251 | NUMBER | The budget amount for the 251st period of the budget year | |||
| AMOUNT252 | NUMBER | The budget amount for the 252nd period of the budget year | |||
| AMOUNT253 | NUMBER | The budget amount for the 253rd period of the budget year | |||
| AMOUNT254 | NUMBER | The budget amount for the 254th period of the budget year | |||
| AMOUNT255 | NUMBER | The budget amount for the 255th period of the budget year | |||
| AMOUNT256 | NUMBER | The budget amount for the 256th period of the budget year | |||
| AMOUNT257 | NUMBER | The budget amount for the 257th period of the budget year | |||
| AMOUNT258 | NUMBER | The budget amount for the 258th period of the budget year | |||
| AMOUNT259 | NUMBER | The budget amount for the 259th period of the budget year | |||
| AMOUNT260 | NUMBER | The budget amount for the 260th period of the budget year | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| DATA_SET | VARCHAR2 | 500 | Yes | Set of records to be imported by the budget import process. | |
| BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 18 | The budget chart of accounts of the control budget | ||
| BUDGET_ENTRY_INT_ID | NUMBER | 18 | Yes | Internal identifier for budget import processing | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| STATUS_CODE | VARCHAR2 | 30 | The status of the row - NEW, SUBMITTED or FAILED | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ANNOTATION_TXT | VARCHAR2 | 1000 | General comment for a budget amount, such as explanation, justification, formula, or itemization. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XCC_BUDGET_ENTRY_INTERFACE_N1 | Non Unique | Default | CONTROL_BUDGET_ID, DATA_SET |
| XCC_BUDGET_ENTRY_INT_U1 | Unique | Default | BUDGET_ENTRY_INT_ID |