 |
Lawson Insight Technical Documentation |
|
AMINTER FILE
Asset Interface
This file contains asset information interfaced into the Asset Management
system from Activity Management, Accounts Payable, or a handheld (HHT)
terminal. 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. The
handheld terminal file (x-AMADD.txt) is imported into this file using the
importdb utility.
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
AM154 AP170 AP193 AP30.2 AP30.4 API1.1
API2.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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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. AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.1
AMI-ASSET-TEMPLATE Alpha 10 AC160 AM115
Template This field contains the asset template AM15.1 AM15.2
used to create the asset. Templates AM15.3 AM15.4
default the required information needed AM154 AP170
to create asset records. Asset templates AP193 AP30.2
are defined in the Asset Management AP30.4 API1.1
application, but they can be associated API2.1
with a purchase order and invoice
during the procurement process (in RQ,
PO, or AP), or with an activity and
account category in the Activity
Management application, or with a
scanned asset during the scanning
process.
The template is a way to create assets
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 (Right Justified) AC160 AM115
Vendor This is the identification code for the AM15.1 AM15.2
vendor. AM15.3 AM15.4
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.1
AMI-INVOICE Alpha 22 AC160 AM115
Invoice This number identifies the invoice. AM15.1 AM15.2
AM15.3 AM15.4
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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 AP170 AP193
identify the recurrence value of a AP30.2 AP30.4
recurring invoice. API1.1 API2.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
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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 AP170 AP193
synonymously in the Lawson Activity AP30.2 AP30.4
Management system. Direct costs are API1.1 API2.1
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
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 AP170 AP193
are groupings of costs, revenues, or a AP30.2 AP30.4
combination of both used for reporting API1.1 API2.1
and inquiries for activities in the
Lawson Activity Management system. All
transactions are posted to an account
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 AP170 AP193
Ledger, AC = Activity Management, AM = AP30.2 AP30.4
Asset Management, AP = Accounts Payable, API1.1 API2.1
etc.)
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 AM154 AP170
unit of the item. AP193 AP30.2
AP30.4 API1.1
API2.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
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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. AP170 AP193
AP30.2 AP30.4
API1.1 API2.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
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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 AM154 AP170
the depreciation books. AP193 AP30.2
AP30.4 API1.1
API2.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
AM154 AP170
Note: The in-service date can be AP193 AP30.2
different for each depreciation book AP30.4 API1.1
used. API2.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 AP170 AP193
as a posting accounting unit. AP30.2 AP30.4
API1.1 API2.1
AMI-AU-GROUP Alpha 10 AC160 AM115
Accounting Unit Accounting unit groups group and AM15.1 AM15.2
Group identify the accounting units to use AM15.3 AM15.4
when you create journal entries for AP170 AP193
adding, adjusting, transferring, or AP30.2 AP30.4
disposing of assets. Changes to API1.1 API2.1
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 AP170 AP193
an asset template on AM12.1 (Addition AP30.2 AP30.4
Template). This is the depreciation API1.1 API2.1
expense activity used for posting.
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 AP170 AP193
account category set up for an asset AP30.2 AP30.4
template on AM12.1 (Addition Template). API1.1 API2.1
This is the depreciation expense account
used for posting.
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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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 AP170 AP193
duplicated from asset to asset. AP30.2 AP30.4
API1.1 API2.1
AMI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Item Description This is the item description. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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. AP170 AP193
AP30.2 AP30.4
API1.1 API2.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
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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. AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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 AP170 AP193
this asset was included. AP30.2 AP30.4
API1.1 API2.1
AMI-PO-RELEASE Numeric 4 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). AP170 AP193
AP30.2 AP30.4
API1.1 API2.1
AMI-PO-CODE Alpha 4 AC160 AM115
PO Code This is the purchase order code. AM15.1 AM15.2
AM15.3 AM15.4
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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 AP170 AP193
assets until they are released from AP30.2 AP30.4
hold. API1.1 API2.1
N = No
Y = Yes
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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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
AM154 AP170
AP193 AP30.2
AP30.4 API1.1
API2.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 AM154 AP170
asset information. AP193 AP30.2
AP30.4 API1.1
API2.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
AP170 AP193
AP30.2 AP30.4
API1.1 API2.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-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).
AMI-BAR-CODE Alpha 30 AM115 AM15.1
Bar Code This is the unique bar code assigned to AM15.2 AM15.3
the item. AM15.4 AM154
AMI-ITEM-TYPE Alpha 1 AM154
Item Type This field is used for bar-coded items
to indicate whether the item being
scanned is a parent item (that is, the
first or only item to be scanned for the
asset) or a child item (that is the
second or more of several items scanned
for an asset). Valid values are:
P = Parent
C = Child
AMI-PROD-CAT-CODE Alpha 30 AM154
Prod Cat Code This field contains the name of the
product category, scanned from the
Product Category Workbook.
AMI-TEMPLATE-DESC Derived
Template Desc This field contains the asset template
description.
AMI-ASSET-BAR-CODE Alpha 30 AM154
Asset Bar Code This field contains the asset bar code,
which is the parent item bar code (that
is, the first item of an asset to be
scanned).
AMI-ITEM-LOC-DTL Alpha 14 AM115 AM15.1
Item Loc Dtl This field contains the location detail AM15.2 AM15.3
associated with the asset item. It can AM15.4 AM154
be typed or scanned in.
AMINTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMISET1 COMPANY AM115 AM15.1
SEQ-NUMBER AM15.2 AM15.3
AM15.4 AM154
AMISET2 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere VENDOR != Spaces AM15.1 AM15.2
VENDOR AM15.3 AM15.4
INVOICE AP170 AP193
SUFFIX AP30.2 AP30.4
DIST-SEQ-NBR API1.1 API2.1
SEQ-NUMBER
AMISET3 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere ACTIVITY != Spaces AM15.1 AM15.2
ACTIVITY AM15.3 AM15.4
ACCT-CATEGORY AP170 AP193
SEQ-NUMBER AP30.2 AP30.4
API1.1 API2.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)
|