AMINTER FILE
Asset Interface
This file contains asset information interfaced into the Asset Management
system from Activity Management and Accounts Payable. AC160 (Asset Interface)
interfaces asset information from Activity Management. Various Accounts
Payable programs interface asset information from Accounts Payable when
invoices containing assets are released.
You can view and adjust interfaced asset information in the AM15 forms: AM15.1
(Single Invoice Interface), AM15.2 (Combine Invoice Interface), AM15.3 (Single
Activity Interface), and AM15.4 (Combine Activity Interface). AM115
(Mass Additions) updates Asset Management with adjustments to the interfaced
asset information.
UPDATED BY
AC160 AM115 AM15.1 AM15.2 AM15.3 AM15.4
AP125 AP126 AP170 AP193 AP25.1 AP25.2
AP26.1 AP30.2 AP30.4 MA530 MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMI-COMPANY Numeric 4 AC160 AM115
Company Required key. This is the company AM15.1 AM15.2
number. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-SEQ-NUMBER Numeric 6 AC160 AM115
Sequence Number Required key. The sequence number is a AM15.1 AM15.2
unique number assigned to each AM15.3 AM15.4
transaction in the Lawson system. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ASSET-TEMPLATE Alpha 10 AC160 AM115
Template You can use an asset template to define AM15.1 AM15.2
assets for use in the Asset Management, AM15.3 AM15.4
Accounts Payable, or Activity Management AP125 AP126
systems. Templates identify the required AP170 AP193
information needed to create asset AP25.1 AP25.2
records. AP26.1 AP30.2
AP30.4 MA530
The template is a way to create assets MA540 PO31.1
with very little keying; using a
template lets you default many of the
data items associated with a new asset.
An asset template is required when you
define a new asset as the result of
transactions from the Lawson Purchase
Order or Accounts Payable systems.
AMI-VENDOR Alpha 9 AC160 AM115
Vendor This is the identification code for the AM15.1 AM15.2
vendor. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-INVOICE Alpha 22 AC160 AM115
Invoice This number identifies the invoice. AM15.1 AM15.2
AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-SUFFIX Numeric 3 AC160 AM115
Suffix This is the suffix for the invoice. It AM15.1 AM15.2
represents the occurrence value of the AM15.3 AM15.4
invoice. The suffix can be used to AP125 AP126
identify the recurrence value of a AP170 AP193
recurring invoice. AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-DIST-SEQ-NBR Numeric 4 AC160 AM115
Distribution This is a unique distribution sequence AM15.1 AM15.2
Sequence Number number. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ACTIVITY Alpha 15 AC160 AM115
Activity This is the activity asset from the AM15.1 AM15.2
Activity Management system. Activities AM15.3 AM15.4
and cost object activities are used AP125 AP126
synonymously in the Lawson Activity AP170 AP193
Management system. Direct costs are AP25.1 AP25.2
posted to activities, and indirect costs AP26.1 AP30.2
are allocated to activities based on AP30.4 MA530
activity drivers. MA540 PO31.1
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
AMI-ACCT-CATEGORY Alpha 5 AC160 AM115
Account Category This is the account category associated AM15.1 AM15.2
with an activity from the Activity AM15.3 AM15.4
Management system. Account categories AP125 AP126
are groupings of costs, revenues, or a AP170 AP193
combination of both used for reporting AP25.1 AP25.2
and inquiries for activities in the AP26.1 AP30.2
Lawson Activity Management system. All AP30.4 MA530
transactions are posted to an account MA540 PO31.1
category within an activity. You can
assign a specific General Ledger account
or range of accounts (company,
accounting unit, account, and
subaccount) that make up the
transactions posted to an account
category.
AMI-SYSTEM Alpha 2 AC160 AM115
System The system code is a two-character code AM15.1 AM15.2
representing an application used within AM15.3 AM15.4
the Lawson system. (i.e.: GL = General AP125 AP126
Ledger, AC = Activity Management, AM = AP170 AP193
Asset Management, AP = Accounts Payable, AP25.1 AP25.2
etc.) AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ITEM-QUANTITY Numeric 8 AC160 AM115
Item Quantity This is the number of units that make AM15.1 AM15.2
up the asset item. Each unit of an item AM15.3 AM15.4
must be exactly the same as every other AP125 AP126
unit of the item. AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-TAG-NBR Alpha 12 AC160 AM115
Tag This is the user-definable tag number AM15.1 AM15.2
for the asset item. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ASSET-GROUP Alpha 10 AC160 AM115
Asset Group This is the asset group for the asset. AM15.1 AM15.2
An asset group represents a parent asset AM15.3 AM15.4
used to group assets for reporting. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ASSET-DESC Alpha 30 (Lower Case) AC160 AM115
Asset Description This is the asset description. AM15.1 AM15.2
AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-PURCHASE-DATE Numeric 8 (yyyymmdd) AC160 AM115
Purchase Date This is the date the asset was AM15.1 AM15.2
purchased. The purchase date can be AM15.3 AM15.4
different from the in-service dates for AP125 AP126
the depreciation books. AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-INSRV-DATE Numeric 8 (yyyymmdd) AC160 AM115
In-Service Date This is the in-service date for the AM15.1 AM15.2
asset. AM15.3 AM15.4
AP125 AP126
Note: The in-service date can be AP170 AP193
different for each depreciation book AP25.1 AP25.2
used. AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ACCT-UNIT Alpha 15 AC160 AM115
Accounting Unit This is the accounting unit for the AM15.1 AM15.2
asset. The accounting unit must be AM15.3 AM15.4
defined in the General Ledger Names file AP125 AP126
as a posting accounting unit. AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-AU-GROUP Alpha 10 AM115 AM15.1
Accounting Unit Accounting unit groups group and AM15.2 AM15.3
Group identify the accounting units to use AM15.4
when you create journal entries for
adding, adjusting, transferring, or
disposing of assets. Changes to
accounting unit groups are dynamic,
affecting all assets using the
accounting unit group. Accounting unit
group names are user-definable, and
accounting unit groups are set up by
company.
AMI-DEP-EXP-ACTVTY Alpha 15 AC160 AM115
Depreciation This is the override depreciation AM15.1 AM15.2
Expense Activity expense activity, which overrides any AM15.3 AM15.4
depreciation expense activity set up for AP125 AP126
an asset template on AM12.1 (Addition AP170 AP193
Template). This is the depreciation AP25.1 AP25.2
expense activity used for posting. AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-DEP-ACCT-CAT Alpha 5 AC160 AM115
Depr Expense This is the override depreciation AM15.1 AM15.2
Account Category expense account category, which AM15.3 AM15.4
overrides any depreciation expense AP125 AP126
account category set up for an asset AP170 AP193
template on AM12.1 (Addition Template). AP25.1 AP25.2
This is the depreciation expense account AP26.1 AP30.2
used for posting. AP30.4 MA530
MA540 PO31.1
AMI-COMBINE Alpha 10 AC160 AM115
Combine This field indicates whether to combine AM15.1 AM15.2
items as one asset. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ITEM-NBR Alpha 32 AC160 AM115
Item Number The user-defined number assigned to the AM15.1 AM15.2
asset item. The item number must be AM15.3 AM15.4
unique within an asset, but can be AP125 AP126
duplicated from asset to asset. AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Item Description This is the item description. AM15.1 AM15.2
AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ITEM-COST-BASE Signed 15.2 AC160 AM115
Item Cost Base This is the cost for the item in AM15.1 AM15.2
Currency General Ledger base currency. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ITEM-TAX-BASE Signed 15.2 AC160 AM115
Item Tax Base This is the tax on the item in General AM15.1 AM15.2
Currency Ledger base currency. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ITEM-COST-TRAN Signed 15.2 AC160 AM115
Item Cost This is the transaction associated with AM15.1 AM15.2
Transaction Currency the item, which is in General Ledger AM15.3 AM15.4
base currency. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ITEM-TAX-TRAN Signed 15.2 AC160 AM115
Item Tax This is the tax transaction associated AM15.1 AM15.2
Transaction Currency with the item. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-BASE-ND Numeric 1 AC160 AM115
Base Number of This is the number of decimal positions AM15.1 AM15.2
Decimals defined for the company base currency. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-TRAN-ND Numeric 1 AC160 AM115
Transaction Number This is the defined number of decimal AM15.1 AM15.2
of Decimals positions used for the transaction. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-CURRENCY-CODE Alpha 5 AC160 AM115
Currency Code This is the base currency defined for AM15.1 AM15.2
the company in the Lawson General Ledger AM15.3 AM15.4
system. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-PO-NBR Alpha 14 AC160 AM115
Purchase Order The Purchase Order Number field is for AM15.1 AM15.2
Number your reference. It contains the number AM15.3 AM15.4
of the original purchase order on which AP125 AP126
this asset was included. AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-PO-RELEASE Numeric 6 AC160 AM115
PO Release Used to identify a purchase order AM15.1 AM15.2
release (created from a Blanket or AM15.3 AM15.4
Standing order). AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-PO-CODE Alpha 4 AC160 AM115
PO Code This is the purchase order code. AM15.1 AM15.2
AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-MODEL-NUMBER Alpha 30 AC160 AM115
Model Number This is the model number of the asset AM15.1 AM15.2
item. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-SERIAL-NUMBER Alpha 30 AC160 AM115
Serial Number This is the serial number of the asset AM15.1 AM15.2
item. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-HOLD-AM Alpha 1 AC160 AM115
Hold This field indicates whether to hold AM15.1 AM15.2
the asset in the Asset Interface file. AM15.3 AM15.4
Being held keeps items from becoming AP125 AP126
assets until they are released from AP170 AP193
hold. AP25.1 AP25.2
N = No AP26.1 AP30.2
Y = Yes AP30.4 MA530
MA540 PO31.1
AMI-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Creation Date This is the creation date for the asset AM15.1 AM15.2
interface record. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Creation Time This is the creation time for the asset AM15.1 AM15.2
interface record. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-CREATOR-ID Alpha 10 AC160 AM115
Creator ID This is the identifier of the person AM15.1 AM15.2
who created the asset interface record. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ASSET-CATEGORY Alpha 1 AM115 AM15.1
Category The value in this field overrides the AM15.2 AM15.3
category value defined for the asset in AM15.4
AM12.1 (Addition Template).
AMI-LOCATION-NAME Alpha 15 AC160 AM115
Location A user-defined location name which AM15.1 AM15.2
represents where an asset is physically AM15.3 AM15.4
located. Locations are used to report AP125 AP126
asset information. AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-DIVISION Alpha 15 AC160 AM115
Division A user-defined division which is used AM15.1 AM15.2
for reporting assets. AM15.3 AM15.4
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMI-ASSET-TYPE Alpha 10 AM115 AM15.1
Asset Type An asset type represents a grouping of AM15.2 AM15.3
like assets. Asset types are used to AM15.4
group assets into reporting classes and
to default common asset definition data.
AMI-SUB-TYPE Alpha 10 AM115 AM15.1
Subtype An asset subtype represents a more AM15.2 AM15.3
detailed grouping of assets within an AM15.4
asset type grouping. Asset subtypes are
used to group assets into reporting
classes and allow common asset
definition data to default. Subtypes
must be unique within an asset type.
AMI-ACCT-GRP Alpha 10 AM115 AM15.1
Account Group A user-defined account group which AM15.2 AM15.3
identifies the general ledger accounts AM15.4
that are used to create journal entries
when assets are processed (added,
adjusted, transferred, or disposed of).
AMI-SEGMENT-BLOCK Alpha 103 AM115 AM15.1
User Analysis This field identifies the user analysis AM15.2 AM15.3
values included in the transaction. AM15.4
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
AMI-WORK-IN-PROC Alpha 1 AM115 AM15.1
Work in Process The value in this field overrides the AM15.2 AM15.3
work-in-process value defined for the AM15.4
asset in AM12.1 (Addition Template).
AMI-SIMULATED Alpha 1 AM115 AM15.1
Simulated The value in this field overrides the AM15.2 AM15.3
Simulated value defined for the asset AM15.4
in AM12.1 (Addition Template).
AMI-TAX-EXEMPT Alpha 1 AM115 AM15.1
Tax Exempt The value in this field overrides the AM15.2 AM15.3
tax exempt value defined for the asset AM15.4
in AM12.1 (Addition Template).
AMI-USED Alpha 1 AM115 AM15.1
Used The value in this field overrides the AM15.2 AM15.3
Used value defined for the asset in AM15.4
AM12.1 (Addition Template).
AMINTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMISET1 COMPANY AM115 AM15.1
SEQ-NUMBER AM15.2 AM15.3
AM15.4
AMISET2 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere VENDOR != Spaces AM15.1 AM15.2
VENDOR AM15.3 AM15.4
INVOICE AP125 AP126
SUFFIX AP170 AP193
DIST-SEQ-NBR AP25.1 AP25.2
SEQ-NUMBER AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMISET3 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere ACTIVITY != Spaces AM15.1 AM15.2
ACTIVITY AM15.3 AM15.4
ACCT-CATEGORY AP125 AP126
SEQ-NUMBER AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMISET4 COMPANY KeyChange, Subset AM115 AM15.1
ASSET-TEMPLATEWhere VENDOR != Spaces AM15.2 AM15.3
COMBINE And COMBINE != Spaces AM15.4
VENDOR
INVOICE
SUFFIX
DIST-SEQ-NBR
SEQ-NUMBER
AMISET5 COMPANY KeyChange, Subset AM115 AM15.1
ASSET-TEMPLATEWhere ACTIVITY != Spaces AM15.2 AM15.3
COMBINE And COMBINE != Spaces AM15.4
ACTIVITY
ACCT-CATEGORY
SEQ-NUMBER
AMISET6 SYSTEM KeyChange, Subset
COMPANY Where COMBINE != Spaces
ASSET-TEMPLATE
COMBINE
SEQ-NUMBER
AMINTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amtemplate AMTEMPLATE Required
AMI-ASSET-TEMPLATE -> ATM-ASSET-TEMPLATE (ATMSET1)
|