ULTOTALS – No description in the Lawson data dictionary

System: General Ledger (GL)
Prefix: ULT
Primary key: FISCAL-YEAR, MATRIX-LIST, TRANS-TYPE, BUDGET-NBR, FR-ACCOUNT, TH-ACCOUNT, FR-SUB-ACCT, TH-SUB-ACCT
Fields: 14
Updated by: 128 programs
Referenced by: 0 programs

ULTOTALS is a Lawson General Ledger table (prefix ULT); no description in the lawson data dictionary. It is indexed by FISCAL-YEAR, MATRIX-LIST, TRANS-TYPE, BUDGET-NBR, FR-ACCOUNT, TH-ACCOUNT, FR-SUB-ACCT, TH-SUB-ACCT (ULTSET1). It is updated by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 120 more. The table has 14 fields, 1 index and 0 documented relations.

About ULTOTALS

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the ULT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ULT-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	The fiscal year associated with the total.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-MATRIX-LIST` PK MATRIX_LIST	Alpha 12	The attribute list associated with the total record.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	Identifies whether the total record is amounts or units.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-BUDGET-NBR` PK BUDGET_NBR	Numeric 3	The budget number associated with the total record.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-FR-ACCOUNT` PK FR_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.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-TH-ACCOUNT` PK TH_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.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-FR-SUB-ACCT` PK FR_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.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-TH-SUB-ACCT` PK TH_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.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-DB-BEG-BAL` DB_BEG_BAL	Signed 18.2	—	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-CR-BEG-BAL` CR_BEG_BAL	Signed 18.2	—	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-DB-AMOUNT` DB_AMOUNT	Signed 18.2 Occurs 13 Times ×13	—	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-CR-AMOUNT` CR_AMOUNT	Signed 18.2 Occurs 13 Times ×13	—	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-CALC-DATE` CALC_DATE	Numeric 8 (yyyymmdd)	The date amounts were last calculated.	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)
`ULT-CALC-TIME` CALC_TIME	Numeric 6 (hhmmss)	—	AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +52 more (list truncated in source)

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ULTSET1`	`FISCAL-YEAR`, `MATRIX-LIST`, `TRANS-TYPE`, `BUDGET-NBR`, `FR-ACCOUNT`, `TH-ACCOUNT`, `FR-SUB-ACCT`, `TH-SUB-ACCT`	Primary		AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)

Programs

Updated by (128)

AC121 Budget Calculation
AC123 Budget Copy
AC130 Allocation Calculation
AC20.1 Life Only Budget
AC20.2 Annual Budget
AC20.3 Period Budget
AC20.4 Activity Budgets by Activity
AC20.5 Activity Budgets by Account Category
AC32.1 Allocation Pool
AC37.1 Allocation Group
AC490 Activity Reconciliation
ACVW.1 Build GL Accounting Unit View
AD191 Cost of Funds
AM180 Depreciation Calculation and Listing
ATVW.1 Build Account Category View
CA10.5 Allocation Calculation
CA110 Allocation Calculation
FB100 Budget Calculation - Computes
FB11.1 Budget Edit Group
FB111 Budget Edit Group Build
FB160 Budget Edit Group Interface
FB20.1 Period Budget, Rate
FB20.6 Period Budget, Amounts
FB20.7 Period Budget, Units
FB21.1 Budget by Period
FB211 Budget Edit Group Listing
FB296 Budget Audit
FB60.1 Budget Edit Group Interface Maintenance
FB95.1 Budget Analysis
FB95.2 Account, Period
FB95.3 Account, Year to Date
FB95.4 Accounting Unit, Period
FB95.5 Accounting Unit, Year to Date
FB95.6 Totals
GL298 GL Commitment Analysis Report
GL299 GL and AC History commitment
GL90.6 Compare Transaction Analysis
GL94.1 Commitment Analysis
GL94.2 Account
GL94.3 Account Totals
GL94.4 Accounting Unit
GL94.5 Accounting Unit Totals
GL94.6 Commitment Account Detail
GL94.7 Commitment Accounting Unit Detail
GL95.1 Account Analysis
GL95.2 Fiscal Year Summary
GL95.3 Totals
GL95.4 Chart Query
GL95.5 Periods versus Year to Date
GL95.6 Year to Date Current Year versus Last Year
GL95.7 Periods Current Year versus Last Year
GL95.8 Year to Date Actual versus Budget
GL95.9 Periods Actual versus Budget
GL96.1 Accounting Units
GL96.2 Year to Date Current Year versus Last Year
GL96.3 Periods Current Year versus Last Year
GL96.4 Year to Date Actual versus Budget
GL96.5 Periods Actual versus Budget
GL97.1 Accounts
GL97.2 Year to Date Current Year versus Last Year
GL97.3 Periods Current Year versus Last Year
GL97.4 Year to Date Actual versus Budget
GL97.5 Periods Actual versus Budget
GL97.6 Year to Date Account Currencies
GL97.7 Periods Account Currencies
GL97.8 Fiscal Year Summary
GL97.9 Totals
GL98.1 Companies
GL98.2 Year to Date Current Year versus Last Year
GL98.3 Periods Current Year versus Last Year
GL98.4 Year to Date Actual versus Budget
GL98.5 Periods Actual versus Budget
GL99.1 Organization Query
GL99.2 Periods versus Year to Date
GL99.3 Year to Date Current Year versus Last Year
GL99.4 Periods Current Year versus Last Year
GL99.5 Year to Date Actual versus Budget
GL99.6 Periods Actual versus Budget
GLAV.1 Build GL Accounting Unit View
GLCV.1 General Ledger Chart View Build
GLVW.1 Build GL Accounting Unit View
ML94.1 Ytd Ml and Gl Actuals
ML94.2 Period ML and GL Actuals
ML94.3 YTD ML and GL Actuals
ML94.4 Period ML and GL Actuals
ML95.1 Ledger Account Analysis
ML95.2 Fiscal Year Summary
ML95.3 Totals
ML95.4 Ledger Chart Query
ML95.5 Periods vs. YTD
ML95.6 YTD Current Year vs. Last Year
ML95.7 Periods Current Year vs. Last Year
ML95.8 YTD Actual vs. Budget
ML95.9 Periods Actual vs. Budget
ML96.1 Accounting Units
ML96.2 YTD Current Year vs. Last Year
ML96.3 Periods Current Year vs. Last Year
ML96.4 YTD Actual vs. Budget
ML96.5 Periods Actual vs. Budget
ML97.1 Accounts
ML97.2 YTD Current Year vs. Last Year
ML97.3 Periods Current Year vs. Last Year
ML97.4 YTD Actual vs. Budget
ML97.5 Periods Actual vs. Budget
ML97.6 YTD Account Currencies
ML97.7 Periods Account Currencies
ML97.8 Fiscal Year Summary
ML97.9 Totals
ML98.1 Companies
ML98.2 YTD Current Year vs. Last Year
ML98.3 Periods Current Year vs. Last Year
ML98.4 YTD Actual vs. Budget
ML98.5 Periods Actual vs. Budget
ML99.1 Organization Query
ML99.2 Periods vs. YTD
ML99.3 YTD Current Year vs. Last Year
ML99.4 Periods Current Year vs. Last Year
ML99.5 YTD Actual vs. Budget
ML99.6 Periods Actual vs. Budget
RW100 Report Generation
RW230 Ratio Listing
RW270 Total Name Listing
RW30.1 Ratio Definition
RW70.1 Total Names
SLVW.1 Build SL Accounting Unit View
SNOA.1 RETRIEVE ACTUALS
SNRA.1 RETRIEVE ACTUALS
SNSA.1 RETRIEVE ACTUALS