ACCOMMIT

Activity Commitments

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.

REFERENCED BY
AC00.1 AC08.3 AC08.7 AC12.1 AC19.1 ACVW.1


UPDATED BY
AC10.1 AC108 AC112 AC120 AC121 AC123
AC130 AC145 AC147 AC190 AC191 AC196
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC295
AC297 AC300 AC311 AC32.1 AC346 AC37.1
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC45.1
AC45.4 AC46.1 AC490 AC50.1 AC56.1 AC560
AC580 AC581 AC583 AC881 AC90.2 AC90.4
AC90.6 AC90.8 AC95.2 AC95.4 AC95.6 AC97.2
AC97.4 AC97.6 AC98.1 ACAC.1 ACDR.1 SE90.1
AP125 AP126 AP131 AP170 AP190 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP520 API1.1 API2.1 ARLL.1
BN150 BN66.1 BR41.1 BR41.4 BR43.1 CB10.1
CB15.1 CB15.2 CB150 CB180 CB191 CB20.1
CB30.1 CB45.1 CB46.1 CB500 CB543 CB544
CB55.1 CB554 CB57.1 CB80.1 CB82.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 EE11.1 EE135 EE20.3
EE35.1 EE35.2 EE520 GL146 GL165 GL170
GL197 GL199 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 GL76.1 PR521 DR100
IC140 IC66.1 IC83.1 EX175 EX542 EX545
EXI2.1 EXI4.1 IFEB.1 IFGT.1 IFUC.1 LP130
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PA182 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO131 PO135 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POD0.1 POI3.1 POID.1
POIF.1 POIG.1 POII.1 POIJ.1 POIK.1 PR128
PR130 PR131 PR132 PR134 PR135 PR136
PR137 PR140 PR189 PR195 PR197 PR198
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR37.1 PR38.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 PR85.1 PR89.1 UK102 UK330 UK560
ZP530 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQD0.1 RQIF.1 TA147
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIT-ACTIVITY-GRP
Element: Activity Group		Alpha 15
Required key. This is the activity group for the commitment information. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-ACTIVITY
Element: Activity		Alpha 15
Required key. This is the activity for the commitment information. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-ACCT-CATEGORY
Element: Account Category		Alpha 5
Key field. This is the account category for the commitment information. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-FISCAL-YEAR
Element: Year		Numeric 4
Key field. This is the fiscal year for the commitment information. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-PERIOD
Element: Period		Numeric 2
Required key. This is the fiscal period for the commitment information. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-SYSTEM
Element: System Code		Alpha 2
Required 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
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-COMPANY
Element: Company		Numeric 4
Required key. This is the company for the commitment information. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-CURRENCY-CODE
Transaction
Currency Code		Alpha 5
Required key. This field defines the currency code for the commitment. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-VAR-LEVELS
Activity Variable
Level		Alpha 30
This is the variable level for the commitment. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-TRAN-ND
Transaction Number
of Decimals		Numeric 1
This is the defined number of decimal positions for the commitment. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-BALANCE-AMOUNT
Element: Amount Balance		Signed 18.2
This is the committed amount balance. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-BALANCE-UNIT
Element: Unit Balance		Signed 17.2
This is the committed unit balance. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-BURDEN-AMT
Element: Intl Amt		Signed 18.2
 ...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-PR-FRINGE-BAL
Element: Pr Fringe Bal		Derived
This 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
Element: Pr Commit Bal		Derived
This field contains the sum of the Balance Amount and the PR Fringe Bal fields.
MIT-MAINT-DATE
Element: Maint Date		Numeric 8 (yyyymmdd)
The date last changed. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-MAINT-TIME
Element: Sys Time		Numeric 6 (hhmmss)
 ...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 AC881
ACDR.1 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
MIT-ACCT-CAT-TYPE
Element: Acct Cat Type		Derived
MIT-SUM-ACCT-CAT
Element: Sum Acct Cat		Alpha 5
The name of the summary account category. 		...
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC346
AC45.1 AC46.1
AC580 AC581
AC583 ACDR.1
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB10.1 CB15.1
CB150 CB180
CB191 CB20.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB57.1 CB80.1
CB82.1 CX100
CX20.1 CX20.2


ACCOMMIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MITSET1 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
SYSTEM
COMPANY
CURRENCY-CODE
...
AC00.1 AC08.3
AC08.7 AC10.1
AC10.6 AC108
AC112 AC12.1
AC120 AC121
AC123 AC130
AC145 AC147
AC19.1 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC300
AC311 AC32.1
AC346 AC37.1
AC45.1 AC46.1
MITSET3 ACTIVITY-GRP
ACTIVITY
SYSTEM
COMPANY
CURRENCY-CODE
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
Subset
Where(VAR-LEVELS !=Spaces)
MITSET4 ACTIVITY-GRP
VAR-LEVELS
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
SYSTEM
COMPANY
CURRENCY-CODE
Subset
Where(VAR-LEVELS !=Spaces)
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC295 AC297
AC32.1 AC37.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 AC490
AC90.2 AC90.4
AC90.6 AC90.8
AC95.2 AC95.4
AC95.6 AC97.2
AC97.4 AC97.6
MITSET6 ACTIVITY-GRP
ACTIVITY
SUM-ACCT-CAT
SYSTEM
CURRENCY-CODE
FISCAL-YEAR
PERIOD
ACCT-CATEGORY
COMPANY
KeyChange
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC295 AC32.1
AC37.1 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.4 AC46.1
AC490 AC90.2
AC90.4 AC90.6
AC90.8 AC95.2
AC95.4 AC95.6
AC97.2 AC97.4
AC97.6 ACAC.1
MITSET7 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
SYSTEM
CURRENCY-CODE
FISCAL-YEAR
PERIOD
COMPANY
KeyChange
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC295 AC32.1
AC37.1 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.4 AC46.1
AC490 AC90.2
AC90.4 AC90.6
AC90.8 AC95.2
AC95.4 AC95.6
AC97.2 AC97.4
AC97.6 ACAC.1


ACCOMMIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
MIT-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
MIT-ACTIVITY-GRP->AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
MIT-ACTIVITY->ACV-ACTIVITY
Systemcode SYSTEMCODE Required
MIT-SYSTEM->SYS-SYSTEM


ACCOMMIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accommitx ACCOMMITX
MIT-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

File created: Thu Jun 09 11:04:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.