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

AC160     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

AM115     AM117     AM125     AM135     AM15.1    AM15.2
AM15.3    AM15.4    AM152     AM154     AM170     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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

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)                     AM115   AM117
Element: Purchase Date The date the asset item was purchased.    AM125   AM15.1
                       This purchased date can be different      AM15.2  AM15.3
                       from the in-service dates for the         AM15.4  AM170
                       depreciation books used.                  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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASI-ITEM-QUANTITY      Numeric 8                                 AM115   AM117
Element: Item Quantity The number of units that make up the      AM125   AM135
                       asset item. Each unit of an item is       AM15.1  AM15.2
                       exactly the same as every other unit of   AM15.3  AM15.4
                       the item.                                 AM154   AM170
                                                                 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

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

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

ASI-ITEM-COST-TRAN     Signed 18.2                               AM115   AM117
Item Cost              This field identifies the unit cost of    AM125   AM135
Transaction Currency   an item defined by this record in the     AM15.1  AM15.2
                       transaction currency.                     AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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

ASI-ITEM-TAX-TRAN      Signed 18.2                               AM115   AM117
Item Tax               This field identifies the unit tax        AM125   AM135
Transaction Currency   amount of an item defined by this asset   AM15.1  AM15.2
                       record in the transaction currency.       AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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

ASI-BASE-ND            Numeric 1                                 AM115   AM117
Base Number of         The number of decimal positions defined   AM125   AM135
Decimals               for the company base currency.            AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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

ASI-TRAN-ND            Numeric 1                                 AM115   AM117
Transaction Number     The number of decimal positions defined   AM125   AM15.1
of Decimals            for the transaction currency.             AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ASI-BAR-CODE           Alpha 30                                  AM115   AM117
Element: Bar Code      This file contains the bar code           AM125   AM135
                       assigned to the asset item.               AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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

ASI-ITEM-LOC-DTL       Alpha 14                                  AM115   AM117
Element: Item Loc Dtl  The field contains the asset location     AM125   AM135
                       detail.                                   AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 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

ASI-INV-DATE           Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Invoice Date  This field contains the system-generated  AM125   AM15.1
                       date of the last inventory.               AM15.2  AM15.3
                                                                 AM15.4  AM152
                                                                 AM170   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

ASI-INV-TIME           Numeric 6  (hhmmss)                       AM115   AM117
Element: Inv Time      This field contains the system-generated  AM125   AM15.1
                       time of the last inventory.               AM15.2  AM15.3
                                                                 AM15.4  AM152
                                                                 AM170   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

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

ASI-OBJ-ID             Numeric 12                                AM115   AM117
Object                 This is the object identifier. It is      AM15.1  AM15.2
Identification         used to relate commitments or posted      AM15.3  AM15.4
                       transactions back to the originating      AM20.1  AM20.3
                       subsystems. Each subsystem record that    AM21.1  AM21.3
                       is updated as a commitment or posted      AM500   AM51.1
                       transaction is assigned an object         AM551   AM97.1
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

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 Currency CoThis field indicates the asset currency.

ASI-INV-COMPANY        Numeric 4                                 AM115   AM117
Element: Company                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1

ASI-PO-AST-OBJ-ID      Numeric 12
Object
Identification

                         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
                                                                 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
                                                                 AM223   AM245
                                                                 ...

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

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

ASISET4   BAR-CODE      KeyChange                                AM115   AM117
          ASSET                                                  AM15.1  AM15.2
          SEQ-NUMBER                                             AM15.3  AM15.4
                                                                 AM152   AM153
                                                                 AM154   AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM252
                                                                 AM500   AM51.1
                                                                 AM52.1  AM551
                                                                 AM97.1

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

                         AMASTITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Activity       ACACTIVITY   Not Required

                            ASI-ACTIVITY         -> ACV-ACTIVITY

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