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 AC10.1 AC112 AC12.1 AC121 AC123
AC130 AC176 AC20.1 AC20.2 AC20.3 AC20.4
AC20.5 AC32.1 AC37.1 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC490 AC50.1 AC98.1 ACAC.1
BR41.1 BR41.4 BR43.1 EE20.3 GL146 GL165
GL170 GL197 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL75.1 MA65.1 POIG.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 CXCP.1 EE135
EE35.1 EE35.2 EE520 GL199 DR100 IC140
IC28.1 IC531 IC83.1 IFGT.1 MA180 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 PO100 PO101 PO122 PO131 PO135
PO150 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.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 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 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 UK560 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ12.1 RQ13.1 RQ140 RQ300 RQ35.1
RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ500
RQD0.1 RQIE.1 RQIF.1 TA147 UK120 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH25.1
WH25.2 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 WO132
WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIT-ACTIVITY-GRP Alpha 15 AC120 AC530
Element: Activity GroupRequired 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
CXCP.1 DR100
EE135 EE35.1
...
MIT-ACTIVITY Alpha 15 AC530 AC541
Element: 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-ACCT-CATEGORY Alpha 5 AC530 AC541
Element: Account CategoKey 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-FISCAL-YEAR Numeric 4 AC530 AC541
Element: Last Closed YeKey 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-PERIOD Numeric 2 AC530 AC541
Element: 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-SYSTEM Alpha 2 AC530 AC541
Element: 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-COMPANY Numeric 4 AC530 AC541
Element: 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
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
CXCP.1 DR100
EE135 EE35.1
...
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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-BALANCE-AMOUNT Signed 17.2 AC530 AC541
Element: Amount BalanceThis 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-BALANCE-UNIT Signed 17.2 AC530 AC541
Element: 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-BURDEN-AMT Signed 15.2 AC530 AC541
Element: 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
...
MIT-PR-FRINGE-BAL Derived
Element: Pr Fringe Bal This field contains the Lawson Payroll
fringe benefit balance for the activity.
MIT-PR-COMMIT-BAL Derived
Element: 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
Element: Date 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
CXCP.1 DR100
EE135 EE35.1
...
MIT-MAINT-TIME Numeric 6 (hhmmss) AC120 AC530
Element: Sys Time 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
CXCP.1 DR100
EE135 EE35.1
...
MIT-ACCT-CAT-TYPE Derived
Element: 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 AC37.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC490
AC50.1 AC530
AC541 AC542
AC881 AC98.1
...
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 AC40.1 AC40.4
ACTIVITY AC41.1 AC41.4
FISCAL-YEAR AC42.1 ACAC.1
PERIOD AP125 AP126
ACCT-CATEGORY AP25.1 AP25.2
SYSTEM AP26.1 AP27.1
COMPANY AP520 BR41.1
CURRENCY-CODE BR41.4 BR43.1
CB10.1 CB191
CB20.1 CB30.1
EE135 EE20.3
EE35.1 EE35.2
EE520 GL146
GL165 GL170
GL197 GL40.1
...
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
|