 |
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 AC30.2 AC30.3 AC32.1 AC490 AC50.1
AC720 AC98.1 ACAC.1 AC06.1 AC61.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
AC741 AC742 GR741 GR742 AP170 AP193
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 CB10.1 CB180 CB191
CB20.1 CB30.1 CB80.1 EE135 EE35.1 EE35.2
EE520 GL199 IFGT.1 POIF.1 PR128 PR131
PR132 PR134 PR136 PR137 PR195 PR197
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 PR530 PR82.1
PR85.1 PRSA.1 UK102 UK330 UK120
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. AC741 AP170
AP193 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB80.1
EE135 EE35.1
EE35.2 EE520
GL199 GR741
IFGT.1 POIF.1
PR128 PR131
PR132 PR134
PR136 PR137
PR195 PR197
PR32.1 PR32.2
PR33.1 PR33.2
...
MIT-ACTIVITY Alpha 15 AC530 AC541
Activity Required key. This is the activity for AC542 AC741
the commitment information. AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-ACCT-CATEGORY Alpha 5 AC530 AC541
Account Category Key field. This is the account category AC542 AC741
for the commitment information. AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-FISCAL-YEAR Numeric 4 AC530 AC541
Fiscal Year Key field. This is the fiscal year for AC542 AC741
the commitment information. AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-PERIOD Numeric 2 AC530 AC541
Period Required key. This is the fiscal period AC542 AC741
for the commitment information. AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-SYSTEM Alpha 2 AC530 AC541
System Code Required key. This is the system code AC542 AC741
for the commitment information. A system AP170 AP193
code is a two-character code AP30.2 AP30.4
representing an application used within AP32.2 AP520
the Lawson system. (i.e.: GL = General API1.1 API2.1
Ledger, AP = Accounts Payable, etc.) 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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-COMPANY Numeric 4 AC530 AC541
Company Required key. This is the company for AC542 AC741
the commitment information. AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-CURRENCY-CODE Alpha 5 AC530 AC541
Transaction Required key. This field defines the AC542 AC741
Currency Code currency code for the commitment. AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-VAR-LEVELS Alpha 30 AC120 AC530
Activity Variable This is the variable level for the AC541 AC542
Level commitment. AC741 AP170
AP193 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB80.1
EE135 EE35.1
EE35.2 EE520
GL199 GR741
IFGT.1 POIF.1
PR128 PR131
PR132 PR134
PR136 PR137
PR195 PR197
PR32.1 PR32.2
PR33.1 PR33.2
...
MIT-TRAN-ND Numeric 1 AC530 AC541
Transaction Number This is the defined number of decimal AC542 AC741
of Decimals positions for the commitment. AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
MIT-BALANCE-AMOUNT Signed 17.2 AC530 AC541
Amount Balance This is the committed amount balance. AC542 AC741
AC742 AP170
AP193 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB80.1
EE135 EE35.1
EE35.2 EE520
GL199 GR741
GR742 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
...
MIT-BALANCE-UNIT Signed 17.2 AC530 AC541
Unit Balance This is the committed unit balance. AC542 AC741
AC742 AP170
AP193 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB80.1
EE135 EE35.1
EE35.2 EE520
GL199 GR741
GR742 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
...
MIT-BURDEN-AMT Signed 15.2 AC530 AC541
Burden Amt AC542 AC741
AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 IFGT.1
POIF.1 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
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
AC741 AC742
AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 GR742
IFGT.1 POIF.1
PR128 PR131
PR132 PR134
PR136 PR137
PR195 PR197
PR32.1 PR32.2
...
MIT-MAINT-TIME Numeric 6 (hhmmss) AC120 AC530
Maintenance Time The time last changed. AC541 AC542
AC741 AC742
AP170 AP193
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB80.1 EE135
EE35.1 EE35.2
EE520 GL199
GR741 GR742
IFGT.1 POIF.1
PR128 PR131
PR132 PR134
PR136 PR137
PR195 PR197
PR32.1 PR32.2
...
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 AC30.2 AC30.3
AC300 AC310
AC32.1 AC490
AC50.1 AC530
AC541 AC542
AC720 AC741
AC742 AC98.1
ACAC.1 GR741
...
MITSET2 ACTIVITY-GRP AC06.1 AC61.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
|