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.
UPDATED BY
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 BN150
BN66.1 CB10.1 CB15.1 CB15.2 CB150 CB180
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 CB80.1 CB82.1
EE135 EE35.1 EE35.2 EE520 GL170 GL199
GL70.1 GL70.2 GL70.3 GL70.5 GL70.6 GL75.1
PR521 EX175 EX542 EXI2.1 EXI4.1 IFGT.1
IFUC.1 LP130 LP140 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MAI1.1 PA182 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POIF.1 POII.1 POIJ.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 TA147 AC00.1 AC10.1 ACAC.1 ACVW.1
EE11.1 EE20.3 GL146 GL165 GL197 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
EX545 IFEB.1 POIG.1

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. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-ACTIVITY
Element: Activity		Alpha 15
Required key. This is the activity for the commitment information. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-ACCT-CATEGORY
Element: Account Category		Alpha 5
Key field. This is the account category for the commitment information. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-FISCAL-YEAR
Element: Year		Numeric 4
Key field. This is the fiscal year for the commitment information. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-PERIOD
Element: Period		Numeric 2
Required key. This is the fiscal period for the commitment information. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
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.) 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-COMPANY
Element: Company		Numeric 4
Required key. This is the company for the commitment information. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-CURRENCY-CODE
Transaction
Currency Code		Alpha 5
Required key. This field defines the currency code for the commitment. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-VAR-LEVELS
Activity Variable
Level		Alpha 30
This is the variable level for the commitment. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-TRAN-ND
Transaction Number
of Decimals		Numeric 1
This is the defined number of decimal positions for the commitment. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-BALANCE-AMOUNT
Element: Amount Balance		Signed 18.2
This is the committed amount balance. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-BALANCE-UNIT
Element: Unit Balance		Signed 17.2
This is the committed unit balance. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-BURDEN-AMT
Element: Intl Amt		Signed 18.2
 ...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
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. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
MIT-MAINT-TIME
Element: Sys Time		Numeric 6 (hhmmss)
 ...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130
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. 		...
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 BN150
BN66.1 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 EE135
EE35.1 EE35.2
EE520 EX175
EX542 EXI2.1
EXI4.1 GL170
GL199 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 IFGT.1
IFUC.1 LP130


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 AC10.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 BN150
BN66.1 CB10.1
CB15.1 CB150
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)
...
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
MITSET6 ACTIVITY-GRP
ACTIVITY
SUM-ACCT-CAT
SYSTEM
CURRENCY-CODE
FISCAL-YEAR
PERIOD
ACCT-CATEGORY
COMPANY
KeyChange
...
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
MITSET7 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
SYSTEM
CURRENCY-CODE
FISCAL-YEAR
PERIOD
COMPANY
KeyChange
...
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.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: Wed Jun 08 20:46:55 2016

Home
Contact Us



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