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 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC32.1 AC37.1 AC490
AC50.1 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 CB15.1 CB15.2 EE20.3
GL146 GL165 GL170 GL197 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL70.1
GL70.2 GL70.3 GL70.5 GL70.6 GL75.1 MA65.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 AP193 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 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 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 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
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PA182 PO100 PO101 PO122
PO131 PO150 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.1 PO25.6 PO25.7
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
PO536 POCP.1 POI3.1 POID.1 POIE.1 POIF.1
POII.1 POIJ.1 PR128 PR130 PR131 PR132
PR134 PR136 PR137 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 PR82.1 PR85.1 PRSA.1 UK102
UK330 RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2
RQ140 RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 RQ500 RQIF.1 TA147 TP135
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 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 AP193
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 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
...
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 AP193
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 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
...
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 AP193
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 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
...
MIT-FISCAL-YEAR Numeric 4 AC108 AC120
Element: Last Closed YeKey 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 AP193
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 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
...
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 AP193
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 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
...
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 AP193
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 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
...
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 AP193
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 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
...
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 AP193
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 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
...
MIT-VAR-LEVELS Alpha 30 AC120 AC346
Activity Variable This is the variable level for the AC46.1 AC881
Level commitment. AP125 AP126
AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
...
MIT-TRAN-ND Numeric 1 AC346 AC46.1
Transaction Number This is the defined number of decimal AC881 AP125
of Decimals positions for the commitment. AP126 AP131
AP170 AP193
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 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
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
CB80.1 CXCP.1
DR100 EE135
...
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 AP193
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 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
...
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 AP193
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 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
...
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 AP193
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 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
...
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) AC120 AC346
Element: Maintenance DaThe date last changed. AC46.1 AC881
AP125 AP126
AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
...
MIT-MAINT-TIME Numeric 6 (hhmmss) AC120 AC346
Element: Sys Time The time last changed. AC46.1 AC881
AP125 AP126
AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
...
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
AP193 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
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 CB10.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 AC190
CURRENCY-CODE 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 AC580
...
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 AC46.1 AC90.2
PERIOD AC90.4 AC90.6
SYSTEM AC90.8 AC95.2
COMPANY AC95.4 AC95.6
CURRENCY-CODE ACAC.1 ACVW.1
SE90.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB15.1
...
MITSET6 ACTIVITY-GRP KeyChange AC295 AC40.1
ACTIVITY AC40.4 AC41.1
SUM-ACCT-CAT AC41.4 AC42.1
SYSTEM AC46.1 AC90.2
CURRENCY-CODE AC90.4 AC90.6
FISCAL-YEAR AC90.8 AC95.2
PERIOD AC95.4 AC95.6
ACCT-CATEGORY ACAC.1 ACVW.1
COMPANY SE90.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB15.1
...
MITSET7 ACTIVITY-GRP KeyChange AC295 AC40.1
ACTIVITY AC40.4 AC41.1
ACCT-CATEGORY AC41.4 AC42.1
SYSTEM AC46.1 AC90.2
CURRENCY-CODE AC90.4 AC90.6
FISCAL-YEAR AC90.8 AC95.2
PERIOD AC95.4 AC95.6
COMPANY ACAC.1 ACVW.1
SE90.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB15.1
...
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
Aclevel ACLEVEL Required
MIT-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
MIT-VAR-LEVELS -> LVL-VAR-LEVELS
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
|