ULTOTALS FILE
AU List, Acct Range Totals
This file is used to store totals for an accounting unit list and an account
range.
UPDATED BY
AC121 AC123 AC127 AC130 AC20.1 AC20.2
AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1
ACVW.1 CA10.5 CA110 FB100 FB20.1 FB20.6
FB20.7 FB21.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 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 GLCV.1
GLVW.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ULT-FISCAL-YEAR Numeric 4 AC121 AC123
Fiscal Year The fiscal year associated with the AC127 AC130
total. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-MATRIX-LIST Alpha 12 AC121 AC123
Attribute List The attribute list associated with the AC127 AC130
total record. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-TRANS-TYPE Alpha 1 AC121 AC123
Transaction Type Identifies whether the total record is AC127 AC130
amounts or units. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-BUDGET-NBR Numeric 3 AC121 AC123
Budget The budget number associated with the AC127 AC130
total record. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-FR-ACCOUNT Numeric 6 AC121 AC123
From Account This is the beginning account for a AC127 AC130
range of accounts. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-TH-ACCOUNT Numeric 6 AC121 AC123
Through Account This is the ending account for a range AC127 AC130
of accounts. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-FR-SUB-ACCT Numeric 4 AC121 AC123
From Subaccount This is the beginning subaccount for a AC127 AC130
range of subaccounts. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-TH-SUB-ACCT Numeric 4 AC121 AC123
Through Subaccount This is the ending subaccount for a AC127 AC130
range of subaccounts. AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-DB-BEG-BAL Currency 15.2 AC121 AC123
Debit Beginning The debit beginning balance. AC127 AC130
Balance AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-CR-BEG-BAL Currency 15.2 AC121 AC123
Credit Beginning The credit beginning balance. AC127 AC130
Balance AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-DB-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123
Debit Amount The budget debit amount. AC127 AC130
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-CR-AMOUNT Currency 15.2 Occurs 13 Times AC121 AC123
Credit Amount The budget credit amount. AC127 AC130
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123
Last Date Calculated The date amounts were last calculated. AC127 AC130
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULT-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Last Time Calculated The time amounts were last calculated. AC127 AC130
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.5
CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
ULTOTALS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ULTSET1 FISCAL-YEAR AC121 AC123
MATRIX-LIST AC127 AC130
TRANS-TYPE AC20.1 AC20.2
BUDGET-NBR AC20.3 AC20.4
FR-ACCOUNT AC22.1 AC30.2
TH-ACCOUNT AC30.3 AC32.1
FR-SUB-ACCT ACVW.1 CA10.5
TH-SUB-ACCT CA110 FB100
FB20.1 FB20.6
FB20.7 FB21.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL95.1 GL95.2
GL95.3 GL95.4
...
|