Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTITEM


                             AMASTITEM FILE

                               Asset Item

The Asset Item file stores asset item records. An asset item describes
detailed information about an item that makes up an asset record. One or more
asset items make up an asset, which is stored in the Asset file and is used
for depreciating and reporting on the asset. Each Asset Item file record has
one related record in the Asset file.


REFERENCED BY

AM145     AM153     AM221     AM223     AM245     AM25.1
AM25.3    AM250     AM266     AM45.1    AM45.3    AM70.1
AM70.3    AMAS.1    AMBK.1    AMDL.1    AM225     AM252
AM52.1    AM07.3

UPDATED BY

AC160     AM115     AM117     AM125     AM135     AM15.1
AM15.2    AM15.3    AM15.4    AM152     AM154     AM170
AM19.1    AM19.2    AM192     AM20.1    AM20.2    AM20.3
AM20.4    AM20.5    AM20.6    AM21.1    AM21.2    AM21.3
AM21.4    AM21.5    AM21.6    AM30.1    AM30.2    AM300
AM40.1    AM40.2    AM500     AM51.1    AM551     AM96.1
AM97.1    AM98.1    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    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
AM330

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ASI-ASSET              Numeric 10                                AC160   AM115
Element: Asset         The asset number associated with the      AM117   AM125
                       asset item record.                        AM135   AM15.1
                                                                 AM15.2  AM15.3
                       The asset number contains up to ten       AM15.4  AM154
                       numeric characters that uniquely          AM170   AM19.1
                       identify an asset. Assets are             AM19.2  AM192
                       automatically numbered system-wide. The   AM20.1  AM20.2
                       asset number does not change unless an    AM20.3  AM20.4
                       asset is partially transferred or         AM20.5  AM20.6
                       disposed of.                              AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM500   AM51.1
                                                                 AM551   AM96.1
                                                                 AM97.1  AM98.1
                                                                 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
                                                                 ...

ASI-SEQ-NUMBER         Numeric 6                                 AC160   AM115
Element: Sequence NumbeA unique sequence number assigned to      AM117   AM125
                       the asset item record.                    AM135   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM30.1  AM30.2
                                                                 AM40.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  AMDL.1
                                                                 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
                                                                 ...

ASI-ITEM-NBR           Alpha 32                                  AC160   AM115
Element: Item Number   The number assigned to the asset item.    AM117   AM125
                       The item number must be unique within an  AM15.1  AM15.2
                       asset, but can be duplicated from asset   AM15.3  AM15.4
                       to asset.                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                       An asset can be composed of more than     AM20.2  AM20.3
                       one asset item, but the items are         AM20.4  AM20.5
                       depreciated as a common asset unit.       AM20.6  AM21.1
                       Items are not depreciated separately.     AM21.2  AM21.3
                       However, items can be partially or        AM21.4  AM21.5
                       separately transferred or disposed of.    AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-DESCRIPTION        Alpha 30  (Lower Case)                    AC160   AM115
Element: Description   The asset item description.               AM117   AM125
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ITEM-PROCESS       Alpha 3
Element: Item Process  This field identifies whether the asset
                       item record is in the process of being
                       adjusted, disposed of, or transferred.
                       Valid values are:

                       ADJ = Adjustment
                       DSP = Disposal
                       TRF = Transfer



                       Blank = The asset item is not being
                       adjusted, disposed of, or transferred.

ASI-PURCHASE-DATE      Numeric 8  (yyyymmdd)                     AC160   AM115
Element: Purchase Date The date the asset item was purchased.    AM117   AM125
                       This purchased date can be different      AM15.1  AM15.2
                       from the in-service dates for the         AM15.3  AM15.4
                       depreciation books used.                  AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ITEM-QUANTITY      Numeric 8                                 AC160   AM115
Element: Item Quantity The number of units that make up the      AM117   AM125
                       asset item. Each unit of an item is       AM135   AM15.1
                       exactly the same as every other unit of   AM15.2  AM15.3
                       the item.                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ITEM-COST-BASE     Signed 18.2                               AC160   AM115
Item Cost Base         This field identifies the unit cost of    AM117   AM125
Currency               an item defined by this record in the     AM135   AM15.1
                       company base currency. The item cost is   AM15.2  AM15.3
                       multiplied by the item quantity to        AM15.4  AM154
                       calculate the total cost amount to be     AM170   AM19.1
                       added to the asset cost.                  AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                       The sum of the products of all            AM20.4  AM20.5
                       associated item cost and item quantity    AM20.6  AM21.1
                       fields must equal the total asset cost    AM21.2  AM21.3
                       stored in the Asset file.                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ITEM-TAX-BASE      Signed 18.2                               AC160   AM115
Item Tax Base          This field identifies the unit tax        AM117   AM125
Currency               amount of an item defined by this asset   AM135   AM15.1
                       record in the company base currency.      AM15.2  AM15.3
                       This amount is multiplied by the item     AM15.4  AM154
                       quantity to calculate the total tax       AM170   AM19.1
                       amount to be added to the asset tax. The  AM19.2  AM20.1
                       sum of the products of all associated     AM20.2  AM20.3
                       item tax and item quantity fields must    AM20.4  AM20.5
                       equal the total asset tax amount in the   AM20.6  AM21.1
                       Asset file.                               AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ITEM-COST-TRAN     Signed 18.2                               AC160   AM115
Item Cost              This field identifies the unit cost of    AM117   AM125
Transaction Currency   an item defined by this record in the     AM135   AM15.1
                       transaction currency.                     AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ITEM-TAX-TRAN      Signed 18.2                               AC160   AM115
Item Tax               This field identifies the unit tax        AM117   AM125
Transaction Currency   amount of an item defined by this asset   AM135   AM15.1
                       record in the transaction currency.       AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-BASE-ND            Numeric 1                                 AC160   AM115
Base Number of         The number of decimal positions defined   AM117   AM125
Decimals               for the company base currency.            AM135   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-TRAN-ND            Numeric 1                                 AC160   AM115
Transaction Number     The number of decimals assigned to a      AM117   AM125
of Decimals            particular account as determined by the   AM15.1  AM15.2
                       account currency.                         AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-PO-NBR             Alpha 14                                  AC160   AM115
Element: PO Number     The purchase order number field is an     AM117   AM125
                       optional field for your reference. It is  AM15.1  AM15.2
                       assumed to contain the original purchase  AM15.3  AM15.4
                       order number on which this asset item     AM170   AM19.1
                       was included.                             AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-PO-RELEASE         Numeric 4                                 AC160   AM115
Element: PO Release    Used to identify a purchase order         AM117   AM125
                       release (created from a Blanket or        AM15.1  AM15.2
                       Standing order).                          AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-PO-CODE            Alpha 4                                   AC160   AM115
Element: PO Code       This is the purchase order code.          AM117   AM125
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-VENDOR             Alpha 9  (Right Justified)                AC160   AM115
Element: Vendor        The vendor number associated with the     AM117   AM125
                       asset item record.                        AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-VENDOR-NAME        Alpha 30                                  AC160   AM115
Element: Vendor Name   The name of the vendor associated with    AM117   AM125
                       the asset item.                           AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-INVOICE            Alpha 22                                  AC160   AM115
Element: Invoice       The invoice number associated with the    AM117   AM125
                       asset item.                               AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-SUFFIX             Numeric 3                                 AC160   AM115
Element: Suffix        The invoice suffix number associated      AM117   AM125
                       with the asset item record.               AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-DIST-SEQ-NBR       Numeric 6                                 AC160   AM115
Distribution           The distribution sequence number          AM117   AM125
Sequence Number        associated with the asset item.           AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-MODEL-NUMBER       Alpha 30                                  AC160   AM115
Element: Model Number  The model number of the asset item.       AM117   AM125
                       Represents the manufacturer identifier    AM15.1  AM15.2
                       of an asset brand.                        AM15.3  AM15.4
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-SERIAL-NUMBER      Alpha 30                                  AC160   AM115
Element: Serial Number This optional field is used for the       AM117   AM125
                       serial number of the asset. The serial    AM15.1  AM15.2
                       number represents a unique manufacturer   AM15.3  AM15.4
                       identifier of an asset by model.          AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ACTIVITY           Alpha 15                                  AC160   AM115
Element: Activity      The activity assigned to the asset item.  AM117   AM125
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                       Activities are the processes or           AM170   AM19.1
                       procedures that produce work. Cost        AM19.2  AM20.1
                       objects (products, services, customers,   AM20.2  AM20.3
                       and so on) are the reasons for            AM20.4  AM20.5
                       performing the activity. Activities and   AM20.6  AM21.1
                       cost object activities are used           AM21.2  AM21.3
                       synonymously in the Lawson Activity       AM21.4  AM21.5
                       Management system.                        AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ACCT-CATEGORY      Alpha 5                                   AC160   AM115
Element: Account CategoThe account category assigned to the      AM117   AM125
                       asset item.                               AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                       Account categories are groupings of       AM170   AM19.1
                       costs, revenues, or a combination of      AM19.2  AM20.1
                       both used for reporting and inquiries     AM20.2  AM20.3
                       for activities in the Lawson Activity     AM20.4  AM20.5
                       Management system. All transactions are   AM20.6  AM21.1
                       posted to an account category within an   AM21.2  AM21.3
                       activity.                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-CREATION-DATE      Numeric 8  (yyyymmdd)                     AC160   AM115
Element: Creation Date The date the asset item record was        AM117   AM135
                       created.                                  AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  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
                                                                 ...

ASI-CREATION-TIME      Numeric 6  (hhmmss)                       AC160   AM115
Element: Creation Time The time the asset item record was        AM117   AM135
                       created.                                  AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  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
                                                                 ...

ASI-CREATOR-ID         Alpha 10                                  AC160   AM115
Element: Creator ID    This field identifies the operator that   AM117   AM135
                       created the asset item record.            AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  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
                                                                 ...

ASI-BAR-CODE           Alpha 30                                  AC160   AM115
Element: Bar Code      This file contains the bar code           AM117   AM125
                       assigned to the asset item.               AM135   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-ITEM-LOC-DTL       Alpha 14                                  AC160   AM115
Element: Item Loc Dtl  The field contains the asset location     AM117   AM125
                       detail.                                   AM135   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1  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
                                                                 ...

ASI-INV-DATE           Numeric 8  (yyyymmdd)                     AC160   AM115
Element: Inv Date      This field contains the                   AM117   AM125
                       system-generated date of the last         AM15.1  AM15.2
                       inventory.                                AM15.3  AM15.4
                                                                 AM152   AM170
                                                                 AM19.1  AM19.2
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM51.1
                                                                 AM551   AM96.1
                                                                 AM97.1  AM98.1
                                                                 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
                                                                 ...

ASI-INV-TIME           Numeric 6  (hhmmss)                       AC160   AM115
Element: Inv Time      This field contains the system-generated  AM117   AM125
                       time of the last inventory.               AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM152   AM170
                                                                 AM19.1  AM19.2
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM51.1
                                                                 AM551   AM96.1
                                                                 AM97.1  AM98.1
                                                                 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
                                                                 ...

ASI-INV-ITEM-COND      Alpha 1                                   AC160   AM115
Element: Inv Item Cond This field contains an assessment of      AM117   AM125
                       the inventory item's condition. Valid     AM15.1  AM15.2
                       values are:                               AM15.3  AM15.4
                       G = Good                                  AM152   AM170
                       F = Fair                                  AM19.1  AM19.2
                       D = Damaged                               AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM51.1
                                                                 AM551   AM96.1
                                                                 AM97.1  AM98.1
                                                                 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
                                                                 ...

ASI-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  AM20.1
                       is updated as a commitment or posted      AM20.3  AM21.1
                       transaction is assigned an object         AM21.3  AM500
                       identifier. The object identifier is      AM51.1  AM551
                       maintained in the subsystem files and in  AM97.1  AP115
                       the Activity Commitments Detail and       AP125   AP126
                       Activity Transaction files. The object    AP131   AP20.1
                       identifier is a unique key used to drill  AP20.2  AP20.3
                       back from Activity Management to the      AP20.4  AP20.5
                       subsystems.                               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
                                                                 ...

ASI-TAG                Derived
Element: Tag           The user-defined tag number assigned to
                       the associated asset record.


ASI-ASSET-GRP          Derived
Element: Asset Group   The asset group assigned to the
                       associated asset record. Represents a
                       parent number used for report grouping.


ASI-GL-CURR-CODE       Derived
Element: Gl Curr Code  This field indicates the asset currency.

ASI-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  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  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
                                                                 ...

ASI-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  AM20.1
                       is updated as a commitment or posted      AM20.3  AM21.1
                       transaction is assigned an object         AM21.3  AM500
                       identifier. The object identifier is      AM51.1  AM551
                       maintained in the subsystem files and in  AM97.1  AP115
                       the Activity Commitments Detail and       AP125   AP126
                       Activity Transaction files. The object    AP131   AP20.1
                       identifier is a unique key used to drill  AP20.2  AP20.3
                       back from Activity Management to the      AP20.4  AP20.5
                       subsystems.                               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
                                                                 ...

                         AMASTITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASISET1   ASSET                                                  AC160   AM115
          SEQ-NUMBER                                             AM117   AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM152   AM153
                                                                 AM154   AM170
                                                                 AM19.1  AM19.2
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM221
                                                                 ...

ASISET2   ASSET         KeyChange                                AM153   AM20.3
          ITEM-NBR                                               AM21.3  AM225
          SEQ-NUMBER                                             AM40.1  AM40.2

ASISET3   SERIAL-NUMBER KeyChange                                AM40.1
          ASSET
          SEQ-NUMBER

ASISET4   BAR-CODE      KeyChange                                AC160   AM115
          ASSET                                                  AM117   AM15.1
          SEQ-NUMBER                                             AM15.2  AM15.3
                                                                 AM15.4  AM152
                                                                 AM153   AM154
                                                                 AM19.1  AM19.2
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM252   AM500
                                                                 AM51.1  AM52.1
                                                                 AM551   AM97.1
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 ...

ASISET5   ITEM-LOC-DTL  KeyChange                                AM07.3
          ASSET
          SEQ-NUMBER

ASISET6   PO-AST-OBJ-ID KeyChange, Subset
                        Where PO-AST-OBJ-ID != Zeroes

                         AMASTITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Activity       ACACTIVITY   Not Required

                            ASI-ACTIVITY         -> ACV-ACTIVITY  (ACVSET1)

Amasset        AMASSET      Not Required

                            ASI-ASSET            -> AST-ASSET

Amlocdtl       AMLOCDTL     Not Required

                            AST-LOCATION-NAME    -> LOD-LOCATION-NAME
                            ASI-ITEM-LOC-DTL     -> LOD-LOC-DTL

Apinvoice      APINVOICE    Not Required

                            AST-COMPANY          -> API-COMPANY
                            ASI-VENDOR           -> API-VENDOR
                            ASI-INVOICE          -> API-INVOICE
                            ASI-SUFFIX           -> API-SUFFIX
                            Zeroes               -> API-CANCEL-SEQ

Apinvoice2     APINVOICE    Required

                            ASI-INV-COMPANY      -> API-COMPANY
                            ASI-VENDOR           -> API-VENDOR
                            ASI-INVOICE          -> API-INVOICE
                            ASI-SUFFIX           -> API-SUFFIX
                            Zeroes               -> API-CANCEL-SEQ

Glsystem       GLSYSTEM     Required

                            AST-COMPANY          -> GLS-COMPANY

                         AMASTITEM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastitadj     AMASTITADJ

                            ASI-ASSET            -> AIA-ASSET
                                                    AIA-PROCESS-SEQ
                                                    AIA-SEQ-NUMBER

Amastittrf     AMASTITTRF

                            ASI-ASSET            -> ITR-ASSET
                                                    ITR-PROCESS-SEQ
                                                    ITR-SEQ-NUMBER