Lawson Insight Technical Documentation |
|
ULTOTALS
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 AC32.1 AC37.1 AC490 ACVW.1
ATVW.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 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 Numeric 4 AC121 AC123
Element: Year The fiscal year associated with the AC130 AC20.1
total. AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-MATRIX-LIST Alpha 12 AC121 AC123
Element: Matrix List The attribute list associated with the AC130 AC20.1
total record. AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-TRANS-TYPE Alpha 1 AC121 AC123
Element: Trans Type Identifies whether the total record is AC130 AC20.1
amounts or units. AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Nbr The budget number associated with the AC130 AC20.1
total record. AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-FR-ACCOUNT Numeric 6 AC121 AC123
Element: Account This field along with the accounting AC130 AC20.1
unit and subaccount make up the location AC20.2 AC20.3
(account) where amounts and other AC20.4 AC20.5
account information is stored. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-TH-ACCOUNT Numeric 6 AC121 AC123
Element: Account This field along with the accounting AC130 AC20.1
unit and subaccount make up the location AC20.2 AC20.3
(account) where amounts and other AC20.4 AC20.5
account information is stored. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-FR-SUB-ACCT Numeric 4 AC121 AC123
Element: Sub Acct This field contains the subaccount from AC130 AC20.1
your general ledger chart of accounts AC20.2 AC20.3
that was charged with the amount carried AC20.4 AC20.5
on this record. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-TH-SUB-ACCT Numeric 4 AC121 AC123
Element: Sub Acct This field contains the subaccount from AC130 AC20.1
your general ledger chart of accounts AC20.2 AC20.3
that was charged with the amount carried AC20.4 AC20.5
on this record. AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-DB-BEG-BAL Signed 18.2 AC121 AC123
Element: Intl Amt AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-CR-BEG-BAL Signed 18.2 AC121 AC123
Element: Intl Amt AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-DB-AMOUNT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-CR-AMOUNT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Calc Date The date amounts were last calculated. AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
ULT-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Sys Time AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
AM180 ATVW.1
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
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
...
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 AC32.1 AC37.1
TH-ACCOUNT AC490 ACVW.1
FR-SUB-ACCT ATVW.1 AM180
TH-SUB-ACCT 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
...
|