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 |