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