Lawson Insight Technical Documentation |
|
ACCOMMIT
ACCOMMIT FILE
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 AC10.1 AC10.6 AC112
AC12.1 AC121 AC123 AC130 AC19.1 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC32.1 AC37.1
AC490 AC50.1 AC56.1 AC560 AC98.1 AC295
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC90.2
AC90.4 AC90.6 AC90.8 AC95.2 AC95.4 AC95.6
ACAC.1 ACVW.1 SE90.1 BR41.1 BR41.4 BR43.1
EE20.3 GL146 GL165 GL197 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 MA65.1
POIG.1
UPDATED BY
AC108 AC120 AC145 AC190 AC191 AC300
AC310 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 AR115 AR124 AR190 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1
AR32.1 AR34.1 AR42.1 AR42.2 AR42.7 AR43.1
AR560 AR570 AR575 AR580 ARLL.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.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 CXCP.1
EE135 EE35.1 EE35.2 EE520 ET530 ETI2.1
GL170 GL199 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 IFGT.1 LP130 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 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
PO150 PO190 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 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 POCP.1 POD0.1 POI3.1 POID.1
POIF.1 POII.1 POIJ.1 PR128 PR130 PR131
PR132 PR134 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
PR80.1 PR82.1 PR85.1 PR89.1 UK102 UK330
UK560 RQ10.1 RQ10.2 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 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIT-ACTIVITY-GRP Alpha 15 AC108 AC120
Element: Activity GroupRequired key. This is the activity AC145 AC190
group for the commitment information. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-ACTIVITY Alpha 15 AC108 AC120
Element: Activity Required key. This is the activity for AC145 AC190
the commitment information. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-ACCT-CATEGORY Alpha 5 AC108 AC120
Element: Account CategoKey field. This is the account category AC145 AC190
for the commitment information. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-FISCAL-YEAR Numeric 4 AC108 AC120
Element: Year Key field. This is the fiscal year for AC145 AC190
the commitment information. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-PERIOD Numeric 2 AC108 AC120
Element: Period Required key. This is the fiscal period AC145 AC190
for the commitment information. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-SYSTEM Alpha 2 AC108 AC120
Element: System Code Required key. This is the system code AC145 AC190
for the commitment information. A system AC191 AC346
code is a two-character code AC45.1 AC46.1
representing an application used within AC580 AC581
the Lawson system. (i.e.: GL = General AC583 AC881
Ledger, AP = Accounts Payable, etc.) 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-COMPANY Numeric 4 AC108 AC120
Element: Company Required key. This is the company for AC145 AC190
the commitment information. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-CURRENCY-CODE Alpha 5 AC108 AC120
Transaction Required key. This field defines the AC145 AC190
Currency Code currency code for the commitment. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-VAR-LEVELS Alpha 30 AC108 AC120
Activity Variable This is the variable level for the AC145 AC190
Level commitment. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-TRAN-ND Numeric 1 AC108 AC120
Transaction Number This is the defined number of decimal AC145 AC190
of Decimals positions for the commitment. AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-BALANCE-AMOUNT Signed 18.2 AC108 AC120
Element: Amount BalanceThis is the committed amount balance. AC145 AC190
AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-BALANCE-UNIT Signed 17.2 AC108 AC120
Element: Unit Balance This is the committed unit balance. AC145 AC190
AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-BURDEN-AMT Signed 18.2 AC108 AC120
Element: Intl Amt AC145 AC190
AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-PR-FRINGE-BAL Derived
Element: Pr Fringe Bal 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 Derived
Element: Pr Commit Bal This field contains the sum of the
Balance Amount and the PR Fringe Bal
fields.
MIT-MAINT-DATE Numeric 8 (yyyymmdd) AC108 AC120
Element: Maint Date The date last changed. AC145 AC190
AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-MAINT-TIME Numeric 6 (hhmmss) AC108 AC120
Element: Sys Time AC145 AC190
AC191 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
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
...
MIT-ACCT-CAT-TYPE Derived
Element: Acct Cat Type
MIT-SUM-ACCT-CAT Alpha 5 AC108 AC120
Element: Sum Acct Cat The name of the summary account AC145 AC190
category. AC191 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 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
...
ACCOMMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MITSET1 ACTIVITY-GRP AC00.1 AC08.3
ACTIVITY AC08.7 AC10.1
ACCT-CATEGORY AC10.6 AC108
FISCAL-YEAR AC112 AC12.1
PERIOD AC120 AC121
SYSTEM AC123 AC130
COMPANY AC145 AC19.1
CURRENCY-CODE AC190 AC191
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC300
AC310 AC32.1
AC346 AC37.1
AC45.1 AC46.1
AC490 AC50.1
...
MITSET3 ACTIVITY-GRP Subset
ACTIVITY Where (VAR-LEVELS != Spaces )
SYSTEM
COMPANY
CURRENCY-CODE
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
MITSET4 ACTIVITY-GRP Subset AC295 AC40.1
VAR-LEVELS Where (VAR-LEVELS != Spaces ) AC40.4 AC41.1
ACCT-CATEGORY AC41.4 AC42.1
FISCAL-YEAR AC45.4 AC46.1
PERIOD AC90.2 AC90.4
SYSTEM AC90.6 AC90.8
COMPANY AC95.2 AC95.4
CURRENCY-CODE AC95.6 ACAC.1
ACVW.1 SE90.1
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
BR41.1 BR41.4
...
MITSET6 ACTIVITY-GRP KeyChange AC295 AC40.1
ACTIVITY AC40.4 AC41.1
SUM-ACCT-CAT AC41.4 AC42.1
SYSTEM AC45.4 AC46.1
CURRENCY-CODE AC90.2 AC90.4
FISCAL-YEAR AC90.6 AC90.8
PERIOD AC95.2 AC95.4
ACCT-CATEGORY AC95.6 ACAC.1
COMPANY ACVW.1 SE90.1
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
BR41.1 BR41.4
...
MITSET7 ACTIVITY-GRP KeyChange AC295 AC40.1
ACTIVITY AC40.4 AC41.1
ACCT-CATEGORY AC41.4 AC42.1
SYSTEM AC45.4 AC46.1
CURRENCY-CODE AC90.2 AC90.4
FISCAL-YEAR AC90.6 AC90.8
PERIOD AC95.2 AC95.4
COMPANY AC95.6 ACAC.1
ACVW.1 SE90.1
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
BR41.1 BR41.4
...
ACCOMMIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|