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 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM154 AM19.1 AM19.2 AP115 AP125
AP126 AP131 AP170 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP305 AP520 API1.1 API2.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMI-COMPANY Numeric 4 AC160 AM115
Element: Company Required key. This is the company AM117 AM15.1
number. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-SEQ-NUMBER Numeric 6 AC160 AM115
Element: Sequence NumbeRequired key. The sequence number is a AM117 AM15.1
unique number assigned to each AM15.2 AM15.3
transaction in the Lawson system. AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-ASSET-TEMPLATE Alpha 10 AC160 AM115
Element: Template This field contains the asset template AM117 AM15.1
used to create the asset. Templates AM15.2 AM15.3
default the required information needed AM15.4 AM154
to create asset records. Asset templates AM19.1 AM19.2
are defined in the Asset Management AP115 AP125
application, but they can be associated AP126 AP131
with a purchase order and invoice AP170 AP193
during the procurement process (in RQ, AP20.1 AP20.2
PO, or AP), or with an activity and AP20.3 AP20.4
account category in the Activity AP20.5 AP20.7
Management application, or with a AP21.1 AP220
scanned asset during the scanning AP23.1 AP25.1
process. AP25.2 AP26.1
AP27.1 AP30.2
The template is a way to create assets AP30.4 AP305
with very little keying; using a AP520 API1.1
template lets you default many of the API2.1 BL120
data items associated with a new asset. BL122 BL130
An asset template is required when you BL20.1 BL20.3
define a new asset as the result of BL21.2 BL21.5
transactions from the Lawson Purchase BL29.1 BL29.2
Order or Accounts Payable systems. BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Vendor This is the identification code for the AM117 AM15.1
vendor. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-INVOICE Alpha 22 AC160 AM115
Element: Invoice This number identifies the invoice. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-SUFFIX Numeric 3 AC160 AM115
Element: Suffix This is the suffix for the invoice. It AM117 AM15.1
represents the occurrence value of the AM15.2 AM15.3
invoice. The suffix can be used to AM15.4 AM19.1
identify the recurrence value of a AM19.2 AP115
recurring invoice. AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-DIST-SEQ-NBR Numeric 6 AC160 AM115
Distribution This is a unique distribution sequence AM117 AM15.1
Sequence Number number. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ACTIVITY Alpha 15 AC160 AM115
Element: Activity This is the activity asset from the AM117 AM15.1
Activity Management system. Activities AM15.2 AM15.3
and cost object activities are used AM15.4 AM19.1
synonymously in the Lawson Activity AM19.2 AP115
Management system. Direct costs are AP125 AP126
posted to activities, and indirect costs AP131 AP170
are allocated to activities based on AP193 AP20.1
activity drivers. AP20.2 AP20.3
AP20.4 AP20.5
Activities are grouped or organized by AP20.7 AP21.1
activity levels. There are two types of AP220 AP23.1
activities: "posting allowed" and AP25.1 AP25.2
"summary only." Use posting level AP26.1 AP27.1
activities to budget and maintain all AP30.2 AP30.4
posted transactions. Summary activities AP305 AP520
or macro activities combine information API1.1 API2.1
and balances from lower level activities BL120 BL122
for reporting and inquiries. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ACCT-CATEGORY Alpha 5 AC160 AM115
Element: Account CategoThis is the account category associated AM117 AM15.1
with an activity from the Activity AM15.2 AM15.3
Management system. Account categories AM15.4 AM19.1
are groupings of costs, revenues, or a AM19.2 AP115
combination of both used for reporting AP125 AP126
and inquiries for activities in the AP131 AP170
Lawson Activity Management system. All AP193 AP20.1
transactions are posted to an account AP20.2 AP20.3
category within an activity. You can AP20.4 AP20.5
assign a specific General Ledger account AP20.7 AP21.1
or range of accounts (company, AP220 AP23.1
accounting unit, account, and AP25.1 AP25.2
subaccount) that make up the AP26.1 AP27.1
transactions posted to an account AP30.2 AP30.4
category. AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-SYSTEM Alpha 2 AC160 AM115
Element: System The system code is a two-character code AM117 AM15.1
representing an application used within AM15.2 AM15.3
the Lawson system. (i.e.: GL = General AM15.4 AM19.1
Ledger, AC = Activity Management, AM = AM19.2 AP115
Asset Management, AP = Accounts Payable, AP125 AP126
etc.) AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ITEM-QUANTITY Numeric 8 AC160 AM115
Element: Item Quantity This is the number of units that make AM117 AM15.1
up the asset item. Each unit of an item AM15.2 AM15.3
must be exactly the same as every other AM15.4 AM154
unit of the item. AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-TAG-NBR Alpha 12 AC160 AM115
Element: Tag This is the user-definable tag number AM117 AM15.1
for the asset item. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ASSET-GROUP Alpha 10 AC160 AM115
Element: Asset Group This is the asset group for the asset. AM117 AM15.1
An asset group represents a parent asset AM15.2 AM15.3
used to group assets for reporting. AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ASSET-DESC Alpha 30 (Lower Case) AC160 AM115
Element: Asset DescriptThis is the asset description. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-PURCHASE-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Purchase Date This is the date the asset was AM117 AM15.1
purchased. The purchase date can be AM15.2 AM15.3
different from the in-service dates for AM15.4 AM154
the depreciation books. AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-INSRV-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: In-Service DatThis is the in-service date for the AM117 AM15.1
asset. AM15.2 AM15.3
AM15.4 AM154
Note: The in-service date can be AM19.1 AM19.2
different for each depreciation book AP115 AP125
used. AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-POSTING-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Trans Date The date of the transaction. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-ACCT-UNIT Alpha 15 AC160 AM115
Element: Accounting UniThis is the accounting unit for the AM117 AM15.1
asset. The accounting unit must be AM15.2 AM15.3
defined in the General Ledger Names file AM15.4 AM19.1
as a posting accounting unit. AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-AU-GROUP Alpha 10 AC160 AM115
Accounting Unit Accounting unit groups group and AM117 AM15.1
Group identify the accounting units to use AM15.2 AM15.3
when you create journal entries for AM15.4 AM19.1
adding, adjusting, transferring, or AM19.2 AP115
disposing of assets. Changes to AP125 AP126
accounting unit groups are dynamic, AP131 AP170
affecting all assets using the AP193 AP20.1
accounting unit group. Accounting unit AP20.2 AP20.3
group names are user-definable, and AP20.4 AP20.5
accounting unit groups are set up by AP20.7 AP21.1
company. AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-DEP-EXP-ACTVTY Alpha 15 AC160 AM115
Depreciation This is the override depreciation AM117 AM15.1
Expense Activity expense activity, which overrides any AM15.2 AM15.3
depreciation expense activity set up for AM15.4 AM19.1
an asset template on AM12.1 (Addition AM19.2 AP115
Template). This is the depreciation AP125 AP126
expense activity used for posting. AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-DEP-ACCT-CAT Alpha 5 AC160 AM115
Depr Expense This is the override depreciation AM117 AM15.1
Account Category expense account category, which AM15.2 AM15.3
overrides any depreciation expense AM15.4 AM19.1
account category set up for an asset AM19.2 AP115
template on AM12.1 (Addition Template). AP125 AP126
This is the depreciation expense account AP131 AP170
used for posting. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-COMBINE Alpha 10 AC160 AM115
Element: Combine This field indicates whether to combine AM117 AM15.1
items as one asset. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-ITEM-NBR Alpha 32 AC160 AM115
Element: Item Number The user-defined number assigned to the AM117 AM15.1
asset item. The item number must be AM15.2 AM15.3
unique within an asset, but can be AM15.4 AM19.1
duplicated from asset to asset. AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Element: Item DescriptiThis is the item description. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-ITEM-COST-BASE Signed 18.2 AC160 AM115
Item Cost Base This is the cost for the item in AM117 AM15.1
Currency General Ledger base currency. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ITEM-TAX-BASE Signed 18.2 AC160 AM115
Item Tax Base This is the tax on the item in General AM117 AM15.1
Currency Ledger base currency. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ITEM-COST-TRAN Signed 18.2 AC160 AM115
Item Cost This is the transaction associated with AM117 AM15.1
Transaction Currency the item, which is in General Ledger AM15.2 AM15.3
base currency. AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ITEM-TAX-TRAN Signed 18.2 AC160 AM115
Item Tax This is the tax transaction associated AM117 AM15.1
Transaction Currency with the item. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-BASE-ND Numeric 1 AC160 AM115
Base Number of This is the number of decimal positions AM117 AM15.1
Decimals defined for the company base currency. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-TRAN-ND Numeric 1 AC160 AM115
Transaction Number This is the defined number of decimal AM117 AM15.1
of Decimals positions used for the transaction. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-CURRENCY-CODE Alpha 5 AC160 AM115
Element: Currency Code This is the base currency defined for AM117 AM15.1
the company in the Lawson General Ledger AM15.2 AM15.3
system. AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-PO-NBR Alpha 14 AC160 AM115
Purchase Order The Purchase Order Number field is for AM117 AM15.1
Number your reference. It contains the number AM15.2 AM15.3
of the original purchase order on which AM15.4 AM19.1
this asset was included. AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-PO-RELEASE Numeric 4 AC160 AM115
Element: PO Release Used to identify a purchase order AM117 AM15.1
release (created from a Blanket or AM15.2 AM15.3
Standing order). AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-PO-CODE Alpha 4 AC160 AM115
Element: PO Code This is the purchase order code. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-MODEL-NUMBER Alpha 30 AC160 AM115
Element: Model Number This is the model number of the asset AM117 AM15.1
item. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-SERIAL-NUMBER Alpha 30 AC160 AM115
Element: Serial Number This is the serial number of the asset AM117 AM15.1
item. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-HOLD-AM Alpha 1 AC160 AM115
Element: Hold This field indicates whether to hold AM117 AM15.1
the asset in the Asset Interface file. AM15.2 AM15.3
Being held keeps items from becoming AM15.4 AM19.1
assets until they are released from AM19.2 AP115
hold. AP125 AP126
N = No AP131 AP170
Y = Yes AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date This is the creation date for the asset AM117 AM15.1
interface record. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time This is the creation time for the asset AM117 AM15.1
interface record. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-CREATOR-ID Alpha 10 AC160 AM115
Element: Creator ID This is the identifier of the person AM117 AM15.1
who created the asset interface record. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-ASSET-CATEGORY Alpha 1 AC160 AM115
Element: Category The value in this field overrides the AM117 AM15.1
category value defined for the asset in AM15.2 AM15.3
AM12.1 (Addition Template). AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-LOCATION-NAME Alpha 15 AC160 AM115
Element: Location A user-defined location name which AM117 AM15.1
represents where an asset is physically AM15.2 AM15.3
located. Locations are used to report AM15.4 AM154
asset information. AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-DIVISION Alpha 15 AC160 AM115
Element: Division A user-defined division which is used AM117 AM15.1
for reporting assets. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-ASSET-TYPE Alpha 10 AC160 AM115
Element: Asset Type An asset type represents a grouping of AM117 AM15.1
like assets. Asset types are used to AM15.2 AM15.3
group assets into reporting classes and AM15.4 AM19.1
to default common asset definition data. AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-SUB-TYPE Alpha 10 AC160 AM115
Element: Subtype An asset subtype represents a more AM117 AM15.1
detailed grouping of assets within an AM15.2 AM15.3
asset type grouping. Asset subtypes are AM15.4 AM19.1
used to group assets into reporting AM19.2 AP115
classes and allow common asset AP125 AP126
definition data to default. Subtypes AP131 AP20.1
must be unique within an asset type. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-ACCT-GRP Alpha 10 AC160 AM115
Element: Account Group AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-WORK-IN-PROC Alpha 1 AC160 AM115
Element: Work in ProcesThe value in this field overrides the AM117 AM15.1
work-in-process value defined for the AM15.2 AM15.3
asset in AM12.1 (Addition Template). AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-SIMULATED Alpha 1 AC160 AM115
Element: Simulated The value in this field overrides the AM117 AM15.1
Simulated value defined for the asset AM15.2 AM15.3
in AM12.1 (Addition Template). AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-TAX-EXEMPT Alpha 1 AC160 AM115
Element: Tax Exempt The value in this field overrides the AM117 AM15.1
tax exempt value defined for the asset AM15.2 AM15.3
in AM12.1 (Addition Template). AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-USED Alpha 1 AC160 AM115
Element: Used The value in this field overrides the AM117 AM15.1
Used value defined for the asset in AM15.2 AM15.3
AM12.1 (Addition Template). AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMI-BAR-CODE Alpha 30 AC160 AM115
Element: Bar Code This is the unique bar code assigned to AM117 AM15.1
the item. AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
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: 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 AC160 AM115
Element: Item Loc Dtl This field contains the location detail AM117 AM15.1
associated with the asset item. It can AM15.2 AM15.3
be typed or scanned in. AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
...
AMI-INV-COMPANY Numeric 4 AC160 AM115
Element: Company Identifies the AP company if the AM117 AM15.1
resource type = V. Identifies the HR AM15.2 AM15.3
company if the resource type = E. It is AM15.4 AM19.1
blank for type A, P or Q resources. AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
...
AMI-PO-AST-OBJ-ID Numeric 12 AC160 AM115
Element: Obj Id This is the object identifier. It is AM117 AM15.1
used to relate commitments or posted AM15.2 AM15.3
transactions back to the originating AM15.4 AM19.1
subsystems. Each subsystem record that AM19.2 AP115
is updated as a commitment or posted AP125 AP126
transaction is assigned an object AP131 AP20.1
identifier. The object identifier is AP20.2 AP20.3
maintained in the subsystem files and in AP20.4 AP20.5
the Activity Commitments Detail and AP20.7 AP21.1
Activity Transaction files. The object AP220 AP23.1
identifier is a unique key used to drill AP25.1 AP25.2
back from Activity Management to the AP26.1 AP27.1
subsystems. AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
AMINTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMISET1 COMPANY AC160 AM115
SEQ-NUMBER AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
...
AMISET2 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere VENDOR != Spaces AM117 AM15.1
VENDOR AM15.2 AM15.3
INVOICE AM15.4 AM19.1
SUFFIX AM19.2 AP115
DIST-SEQ-NBR AP125 AP126
SEQ-NUMBER AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
...
AMISET3 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere ACTIVITY != Spaces AM117 AM15.1
ACTIVITY AM15.2 AM15.3
ACCT-CATEGORY AM15.4 AM19.1
SEQ-NUMBER AM19.2 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
...
AMISET4 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere VENDOR != Spaces AM117 AM15.1
COMBINE And COMBINE != Spaces AM15.2 AM15.3
VENDOR AM15.4 AM19.1
INVOICE AM19.2 AP115
SUFFIX AP125 AP126
DIST-SEQ-NBR AP131 AP20.1
SEQ-NUMBER AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
...
AMISET5 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere ACTIVITY != Spaces AM117 AM15.1
COMBINE And COMBINE != Spaces AM15.2 AM15.3
ACTIVITY AM15.4 AM19.1
ACCT-CATEGORY AM19.2 AP115
SEQ-NUMBER AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
...
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)
|