Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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)