ULTOTALS

This file is used to store totals for an accounting unit list and an account range.
UPDATED BY
ACVW.1 AM180 CA10.5 CA110 FB100 FB11.1
FB111 FB160 FB20.1 FB20.6 FB20.7 FB21.1
FB211 FB296 FB60.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL298 GL299 GL90.6
GL94.1 GL94.2 GL94.3 GL94.4 GL94.5 GL94.6
GL94.7 GL95.1 GL95.2 GL95.3 GL95.4 GL95.5
GL95.6 GL95.7 GL95.8 GL95.9 GL96.1 GL96.2
GL96.3 GL96.4 GL96.5 GL97.1 GL97.2 GL97.3
GL97.4 GL97.5 GL97.6 GL97.7 GL97.8 GL97.9
GL98.1 GL98.2 GL98.3 GL98.4 GL98.5 GL99.1
GL99.2 GL99.3 GL99.4 GL99.5 GL99.6 RW100
RW230 RW270 RW30.1 RW70.1 GLAV.1 GLCV.1
GLVW.1 SLVW.1 SNOA.1 SNRA.1 SNSA.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ULT-FISCAL-YEAR
Element: Year
Numeric 4
The fiscal year associated with the total.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-MATRIX-LIST
Element: Matrix List
Alpha 12
The attribute list associated with the total record.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-TRANS-TYPE
Element: Trans Type
Alpha 1
Identifies whether the total record is amounts or units.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-BUDGET-NBR
Element: Budget Nbr
Numeric 3
The budget number associated with the total record.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-FR-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-TH-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-FR-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-TH-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-DB-BEG-BAL
Element: Intl Amt
Signed 18.2
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-CR-BEG-BAL
Element: Intl Amt
Signed 18.2
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-DB-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-CR-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-CALC-DATE
Element: Calc Date
Numeric 8 (yyyymmdd)
The date amounts were last calculated.
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1
ULT-CALC-TIME
Element: Sys Time
Numeric 6 (hhmmss)
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
GL98.1 GL98.2
GL98.3 GL98.4
GL98.5 GL99.1


ULTOTALS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ULTSET1 FISCAL-YEAR
MATRIX-LIST
TRANS-TYPE
BUDGET-NBR
FR-ACCOUNT
TH-ACCOUNT
FR-SUB-ACCT
TH-SUB-ACCT
...
ACVW.1 AM180
CA10.5 CA110
FB100 FB11.1
FB111 FB160
FB20.1 FB20.6
FB20.7 FB21.1
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6


File created: Wed Jun 08 20:48:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.