Lawson Insight Technical Documentation |
|
AMINTER
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 AP125 AP126 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
API1.1 API2.1 MA41.2 MA41.7 MA43.2 MA61.1
MA70.1 MA75.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMI-COMPANY Numeric 4 AC160 AM115
Element: Company Required key. This is the company AM15.1 AM15.2
number. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-SEQ-NUMBER Numeric 6 AC160 AM115
Element: Sequence NumbeRequired 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 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ASSET-TEMPLATE Alpha 10 AC160 AM115
Element: 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 AP125
to create asset records. Asset templates AP126 AP170
are defined in the Asset Management AP193 AP20.1
application, but they can be associated AP20.2 AP20.3
with a purchase order and invoice AP20.4 AP20.5
during the procurement process (in RQ, AP20.7 AP23.1
PO, or AP), or with an activity and AP25.1 AP25.2
account category in the Activity AP26.1 AP27.1
Management application, or with a AP30.2 AP30.4
scanned asset during the scanning API1.1 API2.1
process. MA41.2 MA41.7
MA43.2 MA61.1
The template is a way to create assets MA70.1 MA75.1
with very little keying; using a MAI1.1
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
Element: Vendor This is the identification code for the AM15.1 AM15.2
vendor. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-INVOICE Alpha 22 AC160 AM115
Element: Invoice This number identifies the invoice. AM15.1 AM15.2
AM15.3 AM15.4
AP125 AP126
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-SUFFIX Numeric 3 AC160 AM115
Element: 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. 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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ACTIVITY Alpha 15 AC160 AM115
Element: 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 AP20.1 AP20.2
posted to activities, and indirect costs AP20.3 AP20.4
are allocated to activities based on AP20.5 AP20.7
activity drivers. AP23.1 AP25.1
AP25.2 AP26.1
Activities are grouped or organized by AP27.1 AP30.2
activity levels. There are two types of AP30.4 API1.1
activities: "posting allowed" and API2.1 MA41.2
"summary only." Use posting level MA41.7 MA43.2
activities to budget and maintain all MA61.1 MA70.1
posted transactions. Summary activities MA75.1 MAI1.1
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
AMI-ACCT-CATEGORY Alpha 5 AC160 AM115
Element: Account CategoThis 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 AP20.1 AP20.2
and inquiries for activities in the AP20.3 AP20.4
Lawson Activity Management system. All AP20.5 AP20.7
transactions are posted to an account AP23.1 AP25.1
category within an activity. You can AP25.2 AP26.1
assign a specific General Ledger account AP27.1 AP30.2
or range of accounts (company, AP30.4 API1.1
accounting unit, account, and API2.1 MA41.2
subaccount) that make up the MA41.7 MA43.2
transactions posted to an account MA61.1 MA70.1
category. MA75.1 MAI1.1
AMI-SYSTEM Alpha 2 AC160 AM115
Element: 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, AP20.1 AP20.2
etc.) AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ITEM-QUANTITY Numeric 8 AC160 AM115
Element: 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 AP125
unit of the item. AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-TAG-NBR Alpha 12 AC160 AM115
Element: Tag This is the user-definable tag number AM15.1 AM15.2
for the asset item. AM15.3 AM15.4
AP125 AP126
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ASSET-GROUP Alpha 10 AC160 AM115
Element: 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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ASSET-DESC Alpha 30 (Lower Case) AC160 AM115
Element: Asset DescriptThis is the asset description. AM15.1 AM15.2
AM15.3 AM15.4
AP125 AP126
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-PURCHASE-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: 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 AP125
the depreciation books. AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-INSRV-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: In-Service DatThis is the in-service date for the AM15.1 AM15.2
asset. AM15.3 AM15.4
AM154 AP125
Note: The in-service date can be AP126 AP170
different for each depreciation book AP193 AP20.1
used. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ACCT-UNIT Alpha 15 AC160 AM115
Element: Accounting UniThis 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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.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 AP125 AP126
adding, adjusting, transferring, or AP170 AP193
disposing of assets. Changes to AP20.1 AP20.2
accounting unit groups are dynamic, AP20.3 AP20.4
affecting all assets using the AP20.5 AP20.7
accounting unit group. Accounting unit AP23.1 AP25.1
group names are user-definable, and AP25.2 AP26.1
accounting unit groups are set up by AP27.1 AP30.2
company. AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
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 AP20.1 AP20.2
expense activity used for posting. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.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). AP20.1 AP20.2
This is the depreciation expense account AP20.3 AP20.4
used for posting. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-COMBINE Alpha 10 AC160 AM115
Element: Combine This field indicates whether to combine AM15.1 AM15.2
items as one asset. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ITEM-NBR Alpha 32 AC160 AM115
Element: 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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Element: Item DescriptiThis is the item description. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.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 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.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 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-CURRENCY-CODE Alpha 5 AC160 AM115
Element: 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 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-PO-RELEASE Numeric 4 AC160 AM115
Element: 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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-PO-CODE Alpha 4 AC160 AM115
Element: PO Code This is the purchase order code. AM15.1 AM15.2
AM15.3 AM15.4
AP125 AP126
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-MODEL-NUMBER Alpha 30 AC160 AM115
Element: Model Number This is the model number of the asset AM15.1 AM15.2
item. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-SERIAL-NUMBER Alpha 30 AC160 AM115
Element: Serial Number This is the serial number of the asset AM15.1 AM15.2
item. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-HOLD-AM Alpha 1 AC160 AM115
Element: 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. AP20.1 AP20.2
N = No AP20.3 AP20.4
Y = Yes AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date This is the creation date for the asset AM15.1 AM15.2
interface record. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time This is the creation time for the asset AM15.1 AM15.2
interface record. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-CREATOR-ID Alpha 10 AC160 AM115
Element: Creator ID This is the identifier of the person AM15.1 AM15.2
who created the asset interface record. AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ASSET-CATEGORY Alpha 1 AM115 AM15.1
Element: 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
Element: Location AM15.1 AM15.2
AM15.3 AM15.4
AM154 AP125
AP126 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
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-DIVISION Alpha 15 AC160 AM115
Element: Division A user-defined division which is used AM15.1 AM15.2
for reporting assets. AM15.3 AM15.4
AP125 AP126
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ASSET-TYPE Alpha 10 AM115 AM15.1
Element: 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
Element: 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
Element: 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
Element: Work in ProcesThe 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Prod Cat Code This field contains the name of the
product category, scanned from the
Product Category Workbook.
AMI-TEMPLATE-DESC Derived
Element: Template Desc This field contains the asset template
description.
AMI-ASSET-BAR-CODE Alpha 30 AM154
Element: Asset Bar CodeThis 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
Element: 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 AP125 AP126
SUFFIX AP170 AP193
DIST-SEQ-NBR AP20.1 AP20.2
SEQ-NUMBER AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.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
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 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.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)
|