ACCOMMIT – Activity Commitments

System
Activity Management (AC)
Prefix
MIT
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE
Fields
19
Updated by
392 programs
Referenced by
9 programs

ACCOMMIT is the Activity Commitments table in Lawson Activity Management (prefix MIT). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE (MITSET1); alternate indexes: MITSET3, MITSET4, MITSET6 and MITSET7. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY and SYSTEMCODE and 1:M to ACCOMMITX. It is updated by AC00.1, AC08.3, AC08.7, AC10.6, AC108, AC120, AC121, AC123 and 384 more and referenced by AC112, AC12.1, AC147, AC19.1, AC297, AC50.1, AC56.1, AC560 and 1 more. The table has 19 fields, 5 indexes and 5 documented relations.

About ACCOMMIT

This file, the Activity Commitments Detail file, and the Activity Transaction file contain commitment information. Commitments are activity transactions released in any originating subsystem but not yet posted to the Activity Management system. This file and the Activity Commitments Detail file contain commitments not yet posted to the general ledger. The Activity Transaction file contains commitments posted to the general ledger but not yet posted to Activity Management. Commitment information is available in the Commitments field of each Activity Group Analysis and Activity Analysis form. This file keeps commitment balances. In addition to the key fields of activity group, activity, account category, fiscal year, period, system, company, and currency code, this file includes variable level, transaction number of decimals, amount balance, and units balance.

Fields (19)

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

Field / columnTypeDescription & valuesUpdated by
MIT-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15Required key. This is the activity group for the commitment information.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the commitment information.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Key field. This is the account category for the commitment information.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Key field. This is the fiscal year for the commitment information.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-PERIOD PK
PERIOD		Numeric 2Required key. This is the fiscal period for the commitment information.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-SYSTEM PK
SYSTEM		Alpha 2Required key. This is the system code for the commitment information. A system code is a two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-COMPANY PK
COMPANY		Numeric 4Required key. This is the company for the commitment information.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-CURRENCY-CODE PK
CURRENCY_CODE		Alpha 5Required key. This field defines the currency code for the commitment.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-VAR-LEVELS
VAR_LEVELS		Alpha 30This is the variable level for the commitment.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-TRAN-ND
TRAN_ND		Numeric 1This is the defined number of decimal positions for the commitment.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-BALANCE-AMOUNT
BALANCE_AMOUNT		Signed 18.2This is the committed amount balance.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-BALANCE-UNIT
BALANCE_UNIT		Signed 17.2This is the committed unit balance.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-BURDEN-AMT
BURDEN_AMT		Signed 18.2—AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-PR-FRINGE-BAL
PR_FRINGE_BAL		DerivedThis field contains an optional, additional cost amount for this commitment balance record. It is the commitment balance amount multiplied by the commitment percent that can be defined on System Codes (GL01.4). The system code on the commitment determines which commit percent is used. This can be for any system that creates commitments, not just PR.—
MIT-PR-COMMIT-BAL
PR_COMMIT_BAL		DerivedThis field contains the sum of the Balance Amount and the PR Fringe Bal fields.—
MIT-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)
MIT-ACCT-CAT-TYPE
ACCT_CAT_TYPE		Derived——
MIT-SUM-ACCT-CAT
SUM_ACCT_CAT		Alpha 5The name of the summary account category.AC108, AC120, AC145, AC190, AC191, AC196, AC311, AC346 +52 more (list truncated in source)

Indexes (5)

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

IndexKeysFlagsConditionUsed in
MITSET1ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODEPrimaryAC00.1, AC08.3, AC08.7, AC10.1, AC10.6, AC108, AC112, AC12.1 +22 more (list truncated in source)
MITSET3ACTIVITY-GRP, ACTIVITY, SYSTEM, COMPANY, CURRENCY-CODE, ACCT-CATEGORY, FISCAL-YEAR, PERIODSubsetWhere (VAR-LEVELS != Spaces)—
MITSET4ACTIVITY-GRP, VAR-LEVELS, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODESubsetWhere (VAR-LEVELS != Spaces)AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
MITSET6ACTIVITY-GRP, ACTIVITY, SUM-ACCT-CAT, SYSTEM, CURRENCY-CODE, FISCAL-YEAR, PERIOD, ACCT-CATEGORY, COMPANYKeyChangeAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
MITSET7ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, SYSTEM, CURRENCY-CODE, FISCAL-YEAR, PERIOD, COMPANYKeyChangeAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredMIT-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequiredMIT-ACTIVITY-GRP → AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequiredMIT-ACTIVITY → ACV-ACTIVITY
SystemcodeSYSTEMCODERequiredMIT-SYSTEM → SYS-SYSTEM

One to many (1) — child tables

RelationTableRulesConditionField map
AccommitxACCOMMITXMIT-ACTIVITY-GRP → MIX-ACTIVITY-GRP, MIT-ACTIVITY → MIX-ACTIVITY, MIT-ACCT-CATEGORY → MIX-ACCT-CATEGORY, MIT-FISCAL-YEAR → MIX-FISCAL-YEAR, MIT-PERIOD → MIX-PERIOD, MIT-SYSTEM → MIX-SYSTEM, MIT-COMPANY → MIX-COMPANY, MIT-CURRENCY-CODE → MIX-CURRENCY-CODE, → MIX-ATN-OBJ-ID

Programs

Updated by (392)

Referenced by (9)