Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMASSETADJ FILE

                            Asset Adjustment

The Asset Adjustment file is an audit file that stores records of changes
that are made to Asset file records. Each asset adjustment record describes
the before and after values of asset fields that were changed, as well as the
date and time of the change and the operator who made the changes.


REFERENCED BY

AM135     AM145     AM154     AM225     AM30.1    AM30.2
AM40.1    AM40.2    AM41.1    AMDL.1

UPDATED BY

AM115     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    AM300     AM500     AM51.1    AM551     AM96.1
AM97.1    AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ASA-ASSET            Numeric 10                                  AM115   AM125
Asset                Key field. The asset number contains up     AM15.1  AM15.2
                     to ten numeric characters that uniquely     AM15.3  AM15.4
                     identify an asset. Assets are               AM170   AM20.1
                     automatically numbered system-wide.         AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-PROCESS-SEQ      Numeric 4                                   AM115   AM125
Process Sequence     Key field. This is the process sequence     AM15.1  AM15.2
                     number for the adjustment.                  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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ADJUST-STATUS    Alpha 1                                     AM115   AM125
Adjustment Status    This is the adjustment status. Valid        AM15.1  AM15.2
                     values are:                                 AM15.3  AM15.4
                     R = Released                                AM170   AM20.1
                     N = Not released.                           AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ADJUST-DATE      Numeric 8  (yyyymmdd)                       AM115   AM125
Adjustment Date      This is the effective date of the           AM15.1  AM15.2
                     adjustment.                                 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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-DESCRIPTION      Alpha 30  (Lower Case)                      AM115   AM125
Description          This is the asset description.              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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-DESCRIPTION   Alpha 30  (Lower Case)                      AM115   AM125
To Description       This is the to-asset description.           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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TAG-NBR          Alpha 12                                    AM115   AM125
Tag Number           The tag is a user-definable identifier      AM15.1  AM15.2
                     assigned to an asset.                       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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-TAG-NBR       Alpha 12                                    AM115   AM125
To Tag Number        This is the tag for the to-asset. A tag     AM15.1  AM15.2
                     is a user-definable identifier assigned     AM15.3  AM15.4
                     to an asset.                                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
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ASSET-GROUP      Alpha 10                                    AM115   AM125
Asset Group          This is the asset group that the asset      AM15.1  AM15.2
                     being adjusted belongs to. An asset         AM15.3  AM15.4
                     group represents a parent asset number      AM170   AM20.1
                     used to group assets for reporting.         AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-ASSET-GROUP   Alpha 10                                    AM115   AM125
To Asset Group       This is the asset group that the            AM15.1  AM15.2
                     transfer-to asset belongs to. An asset      AM15.3  AM15.4
                     group represents a parent asset number      AM170   AM20.1
                     used to group assets for reporting.         AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-OBJ-ID           Numeric 12                                  AM115   AM125
Object ID            The object identifier is a unique key       AM15.1  AM15.2
                     used to attach a list of user-defined       AM15.3  AM15.4
                     attributes for the asset.                   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
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ASSET-CATEGORY   Alpha 1                                     AM115   AM125
Asset Category       This field indicates the asset              AM15.1  AM15.2
                     category: depreciable or nondepreciable.    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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-AST-CATEG     Alpha 1                                     AM115   AM125
To Asset Category    This field indicates the to-asset           AM15.1  AM15.2
                     category: depreciable or nondepreciable.    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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-SIMULATED        Alpha 1                                     AM115   AM125
Simulated            This field indicates whether an asset       AM15.1  AM15.2
                     is simulated. Simulated assets are          AM15.3  AM15.4
                     imitative representations of assets, not    AM170   AM20.1
                     real assets.                                AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-SIMULATED     Alpha 1                                     AM115   AM125
To Simulated         This field indicates whether the            AM15.1  AM15.2
                     transfer-to asset is simulated.             AM15.3  AM15.4
                     Simulated assets are imitative              AM170   AM20.1
                     representations of assets, not real         AM20.2  AM20.3
                     assets.                                     AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-WORK-IN-PROC     Alpha 1                                     AM115   AM125
Work-in-Process      This field indicates whether the asset      AM15.1  AM15.2
                     is work-in-process. Work-in-process         AM15.3  AM15.4
                     assets are real but not yet complete. If    AM170   AM20.1
                     this field is Yes, the asset is on hold     AM20.2  AM20.3
                     and cannot be released.                     AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-WORK-IN-PRC   Alpha 1                                     AM115   AM125
To Work-in-Process   This field indicates whether the            AM15.1  AM15.2
                     transfer-to asset is work-in-process.       AM15.3  AM15.4
                     Work-in-process assets are real but not     AM170   AM20.1
                     yet complete. If this field is Yes, the     AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                     asset is on hold and cannot be released.    AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TAX-EXEMPT       Alpha 1                                     AM115   AM125
Tax Exempt           This field indicates whether the asset      AM15.1  AM15.2
                     is tax exempt.                              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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-TAX-EXEMPT    Alpha 1                                     AM115   AM125
To Tax Exempt        This field indicates whether the            AM15.1  AM15.2
                     to-asset is tax exempt.                     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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-USED             Alpha 1                                     AM115   AM125
Used                 This field indicates whether the asset      AM15.1  AM15.2
                     is used.                                    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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-USED          Alpha 1                                     AM115   AM125
To Used              This field indicates whether the to-        AM15.1  AM15.2
                     asset is used.                              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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ITEM-TOT-QTY     Numeric 10                                  AM115   AM125
Item Total Quantity  This is the total item quantity.            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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-IT-TOT-QTY    Numeric 10                                  AM115   AM125
To Item Total        This is the total item quantity for the     AM15.1  AM15.2
Quantity             to-asset.                                   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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASA-IT-TOT-CSTBASE   Signed 15.2                                 AM115   AM125
Item Total Cost Base This is the total item cost in the base     AM15.1  AM15.2
                     currency.                                   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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-IT-TOTCSTBS   Signed 15.2                                 AM115   AM125
To Item Total Cost   This is the total item cost for the         AM15.1  AM15.2
Base                 to-asset in the base currency.              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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASA-IT-TOT-TAXBASE   Signed 15.2                                 AM115   AM125
Item Total Tax Base  This is the total item tax in the base      AM15.1  AM15.2
                     currency.                                   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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-IT-TOTTAXBS   Signed 15.2                                 AM115   AM125
To Item Total Tax    This is the total item tax for the          AM15.1  AM15.2
Base                 to-asset in the base currency.              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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASA-IT-TOT-CSTTRAN   Signed 15.2                                 AM115   AM125
Item Total Cost Tran This is the total item cost in the          AM15.1  AM15.2
                     transaction currency.                       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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-IT-TOTCSTTR   Signed 15.2                                 AM115   AM125
To Item Total Cost   This is the total item cost for the to-     AM15.1  AM15.2
Tran                 asset in the transaction currency.          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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASA-IT-TOT-TAXTRAN   Signed 15.2                                 AM115   AM125
Item Total Tax Tran  This is the total item tax in the           AM15.1  AM15.2
                     transaction currency.                       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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-IT-TOTTAXTR   Signed 15.2                                 AM115   AM125
To Item Total Tax    This is the total item tax for the          AM15.1  AM15.2
Tran                 to-asset in the transaction currency.       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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASA-BASE-ND          Numeric 1                                   AM115   AM125
Base Number of       The number of decimal positions defined     AM15.1  AM15.2
Decimals             for the company base currency.              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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TRAN-ND          Numeric 1                                   AM115   AM125
Tran Number of       This is the number of decimal positions     AM15.1  AM15.2
Decimals             defined for the transaction currency.       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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-TRAN-ND       Numeric 1                                   AM115   AM125
To Tran Number of    This is the number of decimal positions     AM15.1  AM15.2
Decimals             defined for the to-asset transaction        AM15.3  AM15.4
                     currency.                                   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
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-CURRENCY-CODE    Alpha 5                                     AM115   AM125
Currency Code        This field contains the company base        AM15.1  AM15.2
                     currency code established in Company        AM15.3  AM15.4
                     (GL10.1 ).                                  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
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-CURR-CODE     Alpha 5                                     AM115   AM125
To Currency Code     This is the company base currency code,     AM15.1  AM15.2
                     established in GL10.1 (Company).            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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ITEM-LAST-DATE   Numeric 8  (yyyymmdd)                       AM115   AM125
Item Last Date       This is the last adjustment date for        AM15.1  AM15.2
                     the item.                                   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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-IT-LAST-DT    Numeric 8  (yyyymmdd)                       AM115   AM125
To Item Last Date    This is the last adjustment date for        AM15.1  AM15.2
                     the item for the to-asset.                  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  AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASA-COMPANY          Numeric 4                                   AM115   AM125
Company              The company number represents an            AM15.1  AM15.2
                     established company and is entered on       AM15.3  AM15.4
                     all function codes.                         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
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-COMPANY       Numeric 4                                   AM115   AM125
To Company           This is the company number to which         AM15.1  AM15.2
                     this line is to be posted.                  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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-LOCATION-NAME    Alpha 15                                    AM115   AM125
Location Name        A user-defined location name which          AM15.1  AM15.2
                     represents where an asset is physically     AM15.3  AM15.4
                     located.                                    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
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-LOCATION      Alpha 15                                    AM115   AM125
To Location          This is the location for the to-asset.      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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-DIVISION         Alpha 15                                    AM115   AM125
Division             A user-defined division which is used       AM15.1  AM15.2
                     for reporting assets.                       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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-DIVISION      Alpha 15                                    AM115   AM125
To Division          This is the division for the to-asset.      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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ASSET-TYPE       Alpha 10                                    AM115   AM125
Asset Type           An asset type represents a grouping of      AM15.1  AM15.2
                     like assets. Asset types are used to        AM15.3  AM15.4
                     group assets into reporting classes and     AM170   AM20.1
                     to default common asset definition data.    AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-ASSET-TYPE    Alpha 10                                    AM115   AM125
To Asset Type        This is the asset type for the              AM15.1  AM15.2
                     to-asset. An asset type represents a        AM15.3  AM15.4
                     grouping of like assets. Asset types are    AM170   AM20.1
                     used to group assets into reporting         AM20.2  AM20.3
                     classes and to default common asset         AM20.4  AM20.5
                     definition data.                            AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-SUB-TYPE         Alpha 10                                    AM115   AM125
Asset Subtype        An asset subtype represents a more          AM15.1  AM15.2
                     detailed grouping of assets within an       AM15.3  AM15.4
                     asset type grouping. Asset subtypes are     AM170   AM20.1
                     used to group assets into reporting         AM20.2  AM20.3
                     classes and allow common asset              AM20.4  AM20.5
                     definition data to default. Subtypes        AM20.6  AM21.1
                     must be unique within an asset type.        AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-SUB-TYPE      Alpha 10                                    AM115   AM125
To Subtype           This is the subtype for the to-asset.       AM15.1  AM15.2
                     An asset subtype represents a more          AM15.3  AM15.4
                     detailed grouping of assets within an       AM170   AM20.1
                     asset type grouping. Asset subtypes are     AM20.2  AM20.3
                     used to group assets into reporting         AM20.4  AM20.5
                     classes and allow common asset              AM20.6  AM21.1
                     definition data to default. Subtypes        AM21.2  AM21.3
                     must be unique within an asset type.        AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ACCT-GRP         Alpha 10                                    AM115   AM125
Account Group        A user-defined account group which          AM15.1  AM15.2
                     identifies the general ledger accounts      AM15.3  AM15.4
                     that are used to create journal entries     AM170   AM20.1
                     when assets are processed (added,           AM20.2  AM20.3
                     adjusted, transferred, or disposed of).     AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-ACCT-GRP      Alpha 10                                    AM115   AM125
To Account Group     This is the account group for the           AM15.1  AM15.2
                     to-asset. An account group is a             AM15.3  AM15.4
                     user-defined group that identifies the      AM170   AM20.1
                     general ledger accounts used to create      AM20.2  AM20.3
                     journal entries when assets are             AM20.4  AM20.5
                     processed (added, adjusted, transferred,    AM20.6  AM21.1
                     or disposed of).                            AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ACCT-UNIT        Alpha 15                                    AM115   AM125
Accounting Unit      The accounting unit is a shorthand          AM15.1  AM15.2
                     notation representing the variable level    AM15.3  AM15.4
                     number. When used in the General Ledger     AM170   AM20.1
                     Account Master file, the accounting unit    AM20.2  AM20.3
                     must be defined in the General Ledger       AM20.4  AM20.5
                     Names file as a posting accounting unit.    AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-ACCT-UNIT     Alpha 15                                    AM115   AM125
To Accounting Unit   This is the accounting unit for the         AM15.1  AM15.2
                     to-asset. The accounting unit must be       AM15.3  AM15.4
                     defined in the General Ledger Names file    AM170   AM20.1
                     as a posting accounting unit.               AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-AU-GROUP         Alpha 10                                    AM115   AM125
Accounting Unit      Accounting unit groups group and            AM15.1  AM15.2
Group                identify the accounting units to use        AM15.3  AM15.4
                     when you create journal entries for         AM170   AM20.1
                     adding, adjusting, transferring, or         AM20.2  AM20.3
                     disposing of assets. Changes to             AM20.4  AM20.5
                     accounting unit groups are dynamic,         AM20.6  AM21.1
                     affecting all assets using the              AM21.2  AM21.3
                     accounting unit group. Accounting unit      AM21.4  AM21.5
                     group names are user-definable, and         AM21.6  AM500
                     accounting unit groups are set up by        AM551   AM96.1
                     company.                                    AM98.1

ASA-TO-AU-GROUP      Alpha 10                                    AM115   AM125
To Accounting Unit   This is the accounting unit group for       AM15.1  AM15.2
Group                the to-asset. Accounting unit groups        AM15.3  AM15.4
                     group and identify the accounting units     AM170   AM20.1
                     to use when you create journal entries      AM20.2  AM20.3
                     for adding, adjusting, transferring, or     AM20.4  AM20.5
                     disposing of assets. Changes to             AM20.6  AM21.1
                     accounting unit groups are dynamic,         AM21.2  AM21.3
                     affecting all assets using the              AM21.4  AM21.5
                     accounting unit group. Accounting unit      AM21.6  AM500
                     group names are user-definable, and         AM551   AM96.1
                     accounting unit groups are set up by        AM98.1
                     company.


ASA-DEP-EXP-ACTVTY   Alpha 15                                    AM115   AM125
Depr Expense         This is the override depreciation           AM15.1  AM15.2
Activity             expense activity, which overrides any       AM15.3  AM15.4
                     depreciation expense activity set up on     AM170   AM20.1
                     AM06.1 (Type). This is the depreciation     AM20.2  AM20.3
                     expense activity used for posting.          AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-DEP-EXP-ATY   Alpha 15                                    AM115   AM125
To Depr Expense      This is the override depreciation           AM15.1  AM15.2
Activity             expense activity for the to-asset. It       AM15.3  AM15.4
                     overrides any depreciation expense          AM170   AM20.1
                     activity set up on AM06.1 (Type). This      AM20.2  AM20.3
                     is the depreciation expense activity        AM20.4  AM20.5
                     used for posting to the adjusted asset.     AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-DEP-ACCT-CAT     Alpha 5                                     AM115   AM125
Depr Expense Acct    This is the override depreciation           AM15.1  AM15.2
Category             expense account category, which             AM15.3  AM15.4
                     overrides any depreciation expense          AM170   AM20.1
                     account category set up on AM06.1           AM20.2  AM20.3
                     (Type). This is the depreciation            AM20.4  AM20.5
                     expense account category used for           AM20.6  AM21.1
                     posting.                                    AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-TO-DEP-ACCTCAT   Alpha 5                                     AM115   AM125
To Depr Expense      This is the override depreciation           AM15.1  AM15.2
Acct Category        expense account category. It overrides      AM15.3  AM15.4
                     any depreciation expense account            AM170   AM20.1
                     category set up on AM06.1 (Type). This      AM20.2  AM20.3
                     is the depreciation expense account         AM20.4  AM20.5
                     category used for posting to the            AM20.6  AM21.1
                     adjusted asset.                             AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-ORIG-CO          Numeric 4                                   AM115   AM125
Original Company     This field contains the original            AM15.1  AM15.2
                     company number when the asset record is     AM15.3  AM15.4
                     added to this file. This field is never     AM170   AM20.1
                     changed after being added.                  AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-CREATION-DATE    Numeric 8  (yyyymmdd)                       AM115   AM125
Creation Date        This is the date this adjustment was        AM15.1  AM15.2
                     created.                                    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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-CREATION-TIME    Numeric 6  (hhmmss)                         AM115   AM125
Creation Time        The creation time.                          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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-CREATOR-ID       Alpha 10                                    AM115   AM125
Creator ID           This is the identifier of the person        AM15.1  AM15.2
                     who created this adjustment.                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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-LEASE-COMPANY    Numeric 4                                   AM115   AM15.1
Lease Company                                                    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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-LEASE            Alpha 19                                    AM115   AM15.1
Lease                                                            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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-CLASSIFICATION   Alpha 1                                     AM115   AM125
Classification                                                   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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-CLASS-TO         Alpha 1                                     AM115   AM125
Class To                                                         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  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

ASA-INV-FLAG         Alpha 1                                     AM115   AM15.1
Inv Flag             This required flag denotes whether an       AM15.2  AM15.3
                     asset should be part of a physical          AM15.4  AM170
                     inventory.  It defaults fro Type, but       AM20.1  AM20.2
                     may be overridden on Addition and           AM20.3  AM20.4
                     Adjustment.                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-TO-INV-FLAG      Alpha 1                                     AM115   AM15.1
To Inv Flag          This is the "To" inventory flag field,      AM15.2  AM15.3
                     denoting whether the asset will be part     AM15.4  AM170
                     of the inventory after the adjustment.      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   AM551
                                                                 AM96.1  AM98.1

ASA-ASSET-OWNER      Alpha 10                                    AM115   AM15.1
Asset Owner          This is the individual responsible for      AM15.2  AM15.3
                     the asset, for asset tracking and           AM15.4  AM170
                     management purposes.                        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   AM551
                                                                 AM96.1  AM98.1

ASA-TO-ASSET-OWNER   Alpha 10                                    AM115   AM15.1
To Asset Owner       This is the new asset owner, if the         AM15.2  AM15.3
                     asset owner is changed in the adjustment    AM15.4  AM170
                     process.                                    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   AM551
                                                                 AM96.1  AM98.1

                         AMASSETADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASASET1   ASSET                                                  AM115   AM125
          PROCESS-SEQ                                            AM135   AM145
                                                                 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
                                                                 AM225   AM30.1
                                                                 AM30.2  AM300
                                                                 AM40.1  AM40.2
                                                                 AM41.1  AM500
                                                                 ...

ASASET2   COMPANY       Subset                                   AM225
          ASSET         Where ADJUST-STATUS = "R"
          PROCESS-SEQ

ASASET3   LOCATION-NAME Subset
          ASSET         Where ADJUST-STATUS = "R"
          PROCESS-SEQ

ASASET4   DIVISION      Subset
          ASSET         Where ADJUST-STATUS = "R"
          PROCESS-SEQ

ASASET5   COMPANY       Subset
          ASSET-TYPE    Where ADJUST-STATUS = "R"
          SUB-TYPE
          ASSET
          PROCESS-SEQ

ASASET7   ASSET         Subset                                   AM115   AM15.1
                        Where ADJUST-STATUS = "N"                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
                                                                 AM225   AM500
                                                                 AM51.1  AM551
                                                                 AM96.1  AM97.1
                                                                 AM98.1

                         AMASSETADJ FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required

                            ASA-ASSET            -> AST-ASSET

Amasttype      AMASTTYPE    Not Required

                            ASA-COMPANY          -> ATP-COMPANY
                            ASA-ASSET-TYPE       -> ATP-ASSET-TYPE
                            ASA-SUB-TYPE         -> ATP-SUB-TYPE

Amcontrol      AMCONTROL    Not Required

                            ASA-COMPANY          -> CTL-COMPANY

Amcontrolto    AMCONTROL    Not Required

                            ASA-TO-COMPANY       -> CTL-COMPANY

Amdivision     AMDIVISION   Not Required

                            ASA-DIVISION         -> DIV-DIVISION

Amlocation     AMLOCATION   Not Required

                            ASA-LOCATION-NAME    -> LOC-LOCATION-NAME

                         AMASSETADJ FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastbkadj     AMASTBKADJ

                            ASA-ASSET            -> ABA-ASSET
                            ASA-PROCESS-SEQ      -> ABA-PROCESS-SEQ
                                                    ABA-BOOK