This file, the Activity Commitments 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 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 detail. In addition to the key fields of activity
group, activity, account category, fiscal year, period, system, company,
currency code, and transaction object ID, this file includes accounting unit,
account, subaccount, transaction amount, and transaction units.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
MIX-ACTIVITY-GRP
Element: Activity Group | Alpha 15
Key field. This is the activity group
for the commitment information.
|
|
MIX-ACTIVITY
Element: Activity | Alpha 15
Key field. This is the activity for the
commitment information.
|
|
MIX-ACCT-CATEGORY
Element: Acct Category | Alpha 5
Key field. This is the account category
for the commitment information.
|
|
MIX-FISCAL-YEAR
Element: Year | Numeric 4
Contains the fiscal year for the data
stored on this record.
|
|
MIX-PERIOD
Element: Period | Numeric 2
Key field. This is the period for the
commitment information.
|
|
MIX-SYSTEM
Element: System | Alpha 2
A two-character code representing an
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
|
|
MIX-COMPANY
Element: Company | Numeric 4
Key field. This is the company for the
commitment information.
|
|
MIX-CURRENCY-CODE
Transaction
Currency Code | Alpha 5
Key field. This field defines the
currency code for the commitment.
|
|
MIX-ATN-OBJ-ID
Element: Object Identifier | Numeric 12
Key field. This is the object
identifier for the committed
transaction.
|
|
MIX-ACCT-UNIT
Element: Acct Unit | Alpha 15
This is the accounting unit for the
commitment.
|
|
MIX-ACCOUNT
Element: Account | Numeric 6
This is the account for the commitment.
|
|
MIX-SUB-ACCOUNT
Element: Sub Acct | Numeric 4
This is the subaccount for the
commitment.
|
|
MIX-TRAN-AMOUNT
Element: Transaction Amount | Signed 18.2
This is the amount in transaction
currency for the commitment.
|
|
MIX-UNIT
Element: Unit | Signed 15.2
This field indicates the number of
units for the commitment.
|
|
MIX-BURDEN-AMT
Element: Intl Amt | Signed 18.2
|
|
MIX-PR-FRINGE-AMT
Element: Pr Fringe Amt | Derived
This field contains an optional,
additional cost amount for this
commitment. It is the Tran 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.
|
|
MIX-PR-COMMIT-AMT
Element: Pr Commit Amt | Derived
This field contains the sum of the Tran
Amount and the PR Fringe Amt fields.
|
|
MIX-ACCT-CAT-TYPE
Element: Acct Cat Type | Derived
|
|
MIX-INVOICE
Element: Invoice | Alpha 22
Used to identify the invoice.
|
|
MIX-ITEM
Element: Item | Alpha 32
This field contains the item
identifier.
|
|
MIX-RESOURCE-CODE
Element: Resource Code | Alpha 10
The code identifying the resource
assigned to the activity or activity
group.
|
|
MIX-RESOURCE-TYPE
Element: Resource Type | Alpha 1
The type of resource. Valid values
include:
P - AC Person
Q - Equipment
E - Employee
V - Vendor
A - Asset
E = Employee
V = Vendor
P = Person
Q = Equipment
A = Asset |
|
MIX-RESOURCE-DESC
Element: Description | Alpha 30 (Lower Case)
This field displays the description.
|
|
MIX-GLT-OBJ-ID
Element: Obj Id | Numeric 12
This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
|
|
MIX-RESOURCE-COMP
Element: Resource Comp | Numeric 4
Required if resource is present in
commitment transaction; capture HR
company if resource is employee, AP
company if resource is vendor and AM
company if resource is asset.
|
|
MIX-TRANS-DATE
Element: Trans Date | Numeric 8 (yyyymmdd)
The date of the transaction.
For payroll commitments created during
salary encumbrance, this is the pay
period end date or the activity period
end date on split transactions (when pay
period spans an activity period end
date).
|
|
MIX-END-DATE
Element: End Date | Numeric 8 (yyyymmdd)
Manual commitment end (or expiration)
date.
|
|
MIX-USER-ID
Element: User | Alpha 10 (Lower Case)
|
|
MIX-SOURCE-CODE
Element: Source Code | Alpha 2
Identifies commitment transactions
created from salary encumbrance
processing (GM110) as labor (LD) or
fringe (FR).
|
|
MIX-GMA-OBJ-ID
Element: Obj Id | Numeric 12
This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
|
|
MIX-GM-SALARY-PCT
Element: Gm Salary Pct | Signed 13.6
|
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Acacctcat |
ACACCTCAT |
Required
| MIX-ACCT-CATEGORY | -> | AAX-ACCT-CATEGORY |
|
| Acacctcatx |
ACACCTCATX |
Not Required
| MIX-ACTIVITY-GRP | -> | AXX-ACTIVITY-GRP |
| MIX-ACTIVITY | -> | AXX-ACTIVITY |
| MIX-ACCT-CATEGORY | -> | AXX-ACCT-CATEGORY |
|
| Acactgrp |
ACACTGRP |
Required
| MIX-ACTIVITY-GRP | -> | AGP-ACTIVITY-GRP |
|
| Acactivity |
ACACTIVITY |
Required
| MIX-ACTIVITY | -> | ACV-ACTIVITY |
|
| Accommit |
ACCOMMIT |
Required
| MIX-ACTIVITY-GRP | -> | MIT-ACTIVITY-GRP |
| MIX-ACTIVITY | -> | MIT-ACTIVITY |
| MIX-ACCT-CATEGORY | -> | MIT-ACCT-CATEGORY |
| MIX-FISCAL-YEAR | -> | MIT-FISCAL-YEAR |
| MIX-PERIOD | -> | MIT-PERIOD |
| MIX-SYSTEM | -> | MIT-SYSTEM |
| MIX-COMPANY | -> | MIT-COMPANY |
| MIX-CURRENCY-CODE | -> | MIT-CURRENCY-CODE |
|
| Apcompany |
APCOMPANY |
Not Required
|
| Coline |
COLINE |
Not Required
| MIX-ATN-OBJ-ID | -> | COL-ATN-OBJ-ID |
|
| Coline Cost |
COLINE |
Not Required
| MIX-ATN-OBJ-ID | -> | COL-ATN-OBJ-ID-C |
|
| Comisc |
COMISC |
Not Required
| MIX-ATN-OBJ-ID | -> | CMC-ATN-OBJ-ID |
|
| Comisc Cost |
COMISC |
Not Required
| MIX-ATN-OBJ-ID | -> | CMC-ATN-OBJ-ID-C |
|
| Gltrans |
GLTRANS |
Required
| MIX-GLT-OBJ-ID | -> | GLT-OBJ-ID |
|
| Gmlabdistx |
GMLABDISTX |
Not Required
| MIX-GMA-OBJ-ID | -> | GMA-OBJ-ID |
|
| Iccompany |
ICCOMPANY |
Not Required
|
| Itemmast |
ITEMMAST |
Not Required
| ICC-ITEM-GROUP | -> | ITE-ITEM-GROUP |
| MIX-ITEM | -> | ITE-ITEM |
|
| Oeinvcline |
OEINVCLINE |
Not Required
| MIX-ATN-OBJ-ID | -> | OIL-ATN-OBJ-ID |
|
| Oeinvcline Cst |
OEINVCLINE |
Not Required
| MIX-ATN-OBJ-ID | -> | OIL-ATN-OBJ-ID-C |
|
| Oeinvcmisc |
OEINVCMISC |
Not Required
| MIX-ATN-OBJ-ID | -> | OIM-ATN-OBJ-ID |
|
| Oeinvcmisc Cst |
OEINVCMISC |
Not Required
| MIX-ATN-OBJ-ID | -> | OIM-ATN-OBJ-ID-C |
|
| Paencumber |
PAENCUMBER |
Required
| MIX-ATN-OBJ-ID | -> | PEN-ATN-OBJ-ID |
|
| Povadist |
POVADIST |
Not Required
| Valid When | | MIX-SYSTEM | = | "PO" | |
| MIX-ATN-OBJ-ID | -> | PVD-ATN-OBJ-ID |
|
| Systemcode |
SYSTEMCODE |
Required
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Amtrans |
AMTRANS |
| MIX-ATN-OBJ-ID | -> | AMT-ATN-OBJ-ID |
| | | AMT-ASSET |
| | | AMT-SEQ-NUMBER |
| | | AMT-COMPANY |
|
| Apapdhist |
APAPDHIST |
| MIX-ATN-OBJ-ID | -> | AH2-ATN-OBJ-ID |
| | | AH2-COMPANY |
| | | AH2-VENDOR |
| | | AH2-INVOICE |
| | | AH2-SUFFIX |
| | | AH2-CANCEL-SEQ |
| | | AH2-DIST-SEQ-NBR |
|
| Apdistrib |
APDISTRIB |
| MIX-ATN-OBJ-ID | -> | APD-ATN-OBJ-ID |
| | | APD-COMPANY |
| | | APD-VENDOR |
| | | APD-INVOICE |
| | | APD-SUFFIX |
| | | APD-CANCEL-SEQ |
| | | APD-DIST-SEQ-NBR |
|
| Cbdistrib |
CBDISTRIB |
| MIX-ATN-OBJ-ID | -> | CBD-ACT-OBJ-ID |
| | | CBD-CASH-CODE |
| | | CBD-BANK-INST-CODE |
| | | CBD-TRANS-IDENT |
| | | CBD-DIST-TYPE |
| | | CBD-SEQ-NBR |
|
| Eedistrib |
EEDISTRIB |
| MIX-ATN-OBJ-ID | -> | EED-ACT-OBJ-ID |
| | | EED-COMPANY |
| | | EED-VENDOR |
| | | EED-EXPENSE-NBR |
| | | EED-SEQ-NBR |
|
| Icmmdist |
MMDIST |
| Valid When | | MIX-SYSTEM | = | "IC" | |
| MIX-ATN-OBJ-ID | -> | MMD-ATN-OBJ-ID |
| | | MMD-COMPANY |
| | | MMD-SYSTEM-CD |
| | | MMD-LOCATION |
| | | MMD-DOC-TYPE |
| | | MMD-DOC-NUMBER |
| | | MMD-DOC-NBR-NUM |
| | | MMD-LINE-NBR |
| | | MMD-COMPONENT-SEQ |
| | | MMD-LINE-SEQ |
|
| Mmdist |
MMDIST |
| MIX-ATN-OBJ-ID | -> | MMD-ATN-OBJ-ID |
| | | MMD-COMPANY |
| | | MMD-SYSTEM-CD |
| | | MMD-LOCATION |
| | | MMD-DOC-TYPE |
| | | MMD-DOC-NUMBER |
| | | MMD-DOC-NBR-NUM |
| | | MMD-LINE-NBR |
| | | MMD-COMPONENT-SEQ |
| | | MMD-LINE-SEQ |
|
| Pommdist |
MMDIST |
| Valid When | | MIX-SYSTEM | = | "PO" | |
| MIX-ATN-OBJ-ID | -> | MMD-ATN-OBJ-ID |
| | | MMD-COMPANY |
| | | MMD-SYSTEM-CD |
| | | MMD-LOCATION |
| | | MMD-DOC-TYPE |
| | | MMD-DOC-NUMBER |
| | | MMD-DOC-NBR-NUM |
| | | MMD-LINE-NBR |
| | | MMD-COMPONENT-SEQ |
| | | MMD-LINE-SEQ |
|
| Povacommit |
POVACOMMIT |
| Valid When | | MIX-SYSTEM | = | "PO" | |
| MIX-ATN-OBJ-ID | -> | PVC-ATN-OBJ-ID |
| | | PVC-PROCURE-GROUP |
| | | PVC-VEN-AGRMT-REF |
| | | PVC-LINE-NBR |
| | | PVC-SYSTEM |
| | | PVC-LINE-SEQ |
| | | PVC-COMMIT-DATE |
|
| Povagrmthd |
POVAGRMTHD |
| Valid When | | MIX-SYSTEM | = | "PO" | |
| MIX-ATN-OBJ-ID | -> | PVH-ATN-OBJ-ID |
| | | PVH-PROCURE-GROUP |
| | | PVH-VEN-AGRMT-REF |
|
| Rqmmdist |
MMDIST |
| Valid When | | MIX-SYSTEM | = | "RQ" | |
| MIX-ATN-OBJ-ID | -> | MMD-ATN-OBJ-ID |
| | | MMD-COMPANY |
| | | MMD-SYSTEM-CD |
| | | MMD-LOCATION |
| | | MMD-DOC-TYPE |
| | | MMD-DOC-NUMBER |
| | | MMD-DOC-NBR-NUM |
| | | MMD-LINE-NBR |
| | | MMD-COMPONENT-SEQ |
| | | MMD-LINE-SEQ |
|
| Timerecord |
TIMERECORD |
| MIX-COMPANY | -> | TRD-COMPANY |
| MIX-ATN-OBJ-ID | -> | TRD-ATN-OBJ-ID |
| | | TRD-TIME-SEQ |
|
