 |
Lawson Insight Technical Documentation |
|
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 AC10.1 AC112 AC12.1 AC121 AC123
AC130 AC176 AC20.1 AC20.2 AC20.3 AC20.4
AC20.5 AC32.1 AC490 AC50.1 AC98.1 ACAC.1
AC06.1 AC295 AC297 AC90.2 AC90.4 AC90.6
AC90.8 AC95.2 AC95.4 AC95.6 AC97.2 AC97.4
AC97.6 ACVW.1 SE90.1
UPDATED BY
AC120 AC300 AC310 AC530 AC541 AC542
AC881 AP125 AP126 AP131 AP170 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP32.2 AP520 API1.1 API2.1 AR115
AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3
AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1
AR42.2 AR42.7 AR43.1 AR560 AR570 AR575
AR580 BN150 BN66.1 CB10.1 CB180 CB191
CB20.1 CB30.1 CB500 CB80.1 EE135 EE35.1
EE35.2 EE520 GL199 IC28.1 IFGT.1 MA180
MA41.2 MA43.2 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POIF.1 POII.1 POIJ.1
PR128 PR130 PR131 PR132 PR134 PR136
PR137 PR140 PR189 PR195 PR197 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
PR36.1 PR37.1 PR38.1 PR45.1 PR529 PR530
PR560 PR80.1 PR82.1 PR85.1 PR89.1 PRSA.1
UK102 UK330 RQ10.1 RQ10.2 TA147 UK120
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIT-ACTIVITY-GRP Alpha 15 AC120 AC530
Activity Group Required key. This is the activity AC541 AC542
group for the commitment information. AC881 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
...
MIT-ACTIVITY Alpha 15 AC530 AC541
Activity Required key. This is the activity for AC542 AC881
the commitment information. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-ACCT-CATEGORY Alpha 5 AC530 AC541
Account Category Key field. This is the account category AC542 AC881
for the commitment information. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-FISCAL-YEAR Numeric 4 AC530 AC541
Fiscal Year Key field. This is the fiscal year for AC542 AC881
the commitment information. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-PERIOD Numeric 2 AC530 AC541
Period Required key. This is the fiscal period AC542 AC881
for the commitment information. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-SYSTEM Alpha 2 AC530 AC541
System Code Required key. This is the system code AC542 AC881
for the commitment information. A system AP125 AP126
code is a two-character code AP131 AP170
representing an application used within AP193 AP20.1
the Lawson system. (i.e.: GL = General AP20.2 AP20.3
Ledger, AP = Accounts Payable, etc.) AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-COMPANY Numeric 4 AC530 AC541
Company Required key. This is the company for AC542 AC881
the commitment information. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-CURRENCY-CODE Alpha 5 AC530 AC541
Transaction Required key. This field defines the AC542 AC881
Currency Code currency code for the commitment. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-VAR-LEVELS Alpha 30 AC120 AC530
Activity Variable This is the variable level for the AC541 AC542
Level commitment. AC881 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
...
MIT-TRAN-ND Numeric 1 AC530 AC541
Transaction Number This is the defined number of decimal AC542 AC881
of Decimals positions for the commitment. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-BALANCE-AMOUNT Signed 17.2 AC530 AC541
Amount Balance This is the committed amount balance. AC542 AC881
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-BALANCE-UNIT Signed 17.2 AC530 AC541
Unit Balance This is the committed unit balance. AC542 AC881
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-BURDEN-AMT Signed 15.2 AC530 AC541
Burden Amt AC542 AC881
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
BN150 BN66.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
...
MIT-PR-FRINGE-BAL Derived
Pr Fringe Bal This field contains the Lawson Payroll
fringe benefit balance for the activity.
MIT-PR-COMMIT-BAL Derived
Pr Commit Bal This field contains the Lawson Payroll
commitments balance for the activity --
activity transactions released in the
Payroll system but not yet posted to the
Activity Management system.
MIT-MAINT-DATE Numeric 8 (yyyymmdd) AC120 AC530
Maintenance Date The date last changed. AC541 AC542
AC881 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
...
MIT-MAINT-TIME Numeric 6 (hhmmss) AC120 AC530
Maintenance Time The time last changed. AC541 AC542
AC881 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
...
MIT-ACCT-CAT-TYPE Derived
Acct Cat Type
ACCOMMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MITSET1 ACTIVITY-GRP AC00.1 AC10.1
ACTIVITY AC112 AC12.1
ACCT-CATEGORY AC120 AC121
FISCAL-YEAR AC123 AC130
PERIOD AC176 AC20.1
SYSTEM AC20.2 AC20.3
COMPANY AC20.4 AC20.5
CURRENCY-CODE AC300 AC310
AC32.1 AC490
AC50.1 AC530
AC541 AC542
AC881 AC98.1
ACAC.1 AP125
AP126 AP131
AP170 AP193
...
MITSET2 ACTIVITY-GRP AC06.1
ACCT-CATEGORY
ACTIVITY
FISCAL-YEAR
PERIOD
SYSTEM
COMPANY
CURRENCY-CODE
MITSET3 ACTIVITY-GRP Subset
ACTIVITY Where (VAR-LEVELS != Spaces )
SYSTEM
COMPANY
CURRENCY-CODE
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
MITSET4 ACTIVITY-GRP Subset AC295 AC297
VAR-LEVELS Where (VAR-LEVELS != Spaces ) AC90.2 AC90.4
ACCT-CATEGORY AC90.6 AC90.8
FISCAL-YEAR AC95.2 AC95.4
PERIOD AC95.6 AC97.2
SYSTEM AC97.4 AC97.6
COMPANY ACVW.1 SE90.1
CURRENCY-CODE
MITSET5 ACTIVITY-GRP ACAC.1
ACTIVITY
FISCAL-YEAR
PERIOD
ACCT-CATEGORY
SYSTEM
COMPANY
CURRENCY-CODE
MITSET6 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR*
PERIOD
SYSTEM
COMPANY
CURRENCY-CODE
ACCOMMIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
MIT-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
MIT-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
MIT-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
MIT-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
MIT-VAR-LEVELS -> LVL-VAR-LEVELS
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
|