Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASSETADJ


                            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     AM190     AM192     AM225
AM30.1    AM30.2    AM30.3    AM40.1    AM40.2    AM40.3
AM40.4    AM41.1    AM41.2    AM502     AM92.1    AMDL.1

UPDATED BY

AM115     AM117     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   AM117
Element: Asset         Key field. The asset number contains up   AM125   AM15.1
                       to ten numeric characters that uniquely   AM15.2  AM15.3
                       identify an asset. Assets are             AM15.4  AM170
                       automatically numbered system-wide.       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-PROCESS-SEQ        Numeric 6                                 AM115   AM117
Element: Process SequenKey field. This is the process sequence   AM125   AM15.1
                       number for the adjustment.                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-ADJUST-STATUS      Alpha 1                                   AM115   AM117
Element: Adjustment StaThis is the adjustment status. Valid      AM125   AM15.1
                       values are:                               AM15.2  AM15.3
                       R = Released                              AM15.4  AM170
                       N = Not released.                         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-DATE        Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Adjustment DatThis is the effective date of the         AM125   AM15.1
                       adjustment.                               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-DESCRIPTION        Alpha 30  (Lower Case)                    AM115   AM117
Element: Description   This is the asset 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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-TO-DESCRIPTION     Alpha 30  (Lower Case)                    AM115   AM117
Element: To DescriptionThis is the to-asset 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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-TAG-NBR            Alpha 12                                  AM115   AM117
Element: Tag Number    The tag is a user-definable identifier    AM125   AM15.1
                       assigned to an asset.                     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-TAG-NBR         Alpha 12                                  AM115   AM117
Element: To Tag Number This is the tag for the to-asset. A tag   AM125   AM15.1
                       is a user-definable identifier assigned   AM15.2  AM15.3
                       to an asset.                              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-GROUP        Alpha 10                                  AM115   AM117
Element: Asset Group   This is the asset group that the asset    AM125   AM15.1
                       being adjusted belongs to. An asset       AM15.2  AM15.3
                       group represents a parent asset number    AM15.4  AM170
                       used to group assets for reporting.       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-GROUP     Alpha 10                                  AM115   AM117
Element: To Asset GroupThis is the asset group that the          AM125   AM15.1
                       transfer-to asset belongs to. An asset    AM15.2  AM15.3
                       group represents a parent asset number    AM15.4  AM170
                       used to group assets for reporting.       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-OBJ-ID             Numeric 12                                AM115   AM117
Element: Object ID     The object identifier is a unique key     AM125   AM15.1
                       used to attach a list of user-defined     AM15.2  AM15.3
                       attributes for the asset.                 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-CATEGORY     Alpha 1                                   AM115   AM117
Element: Asset CategoryThis field indicates the asset            AM125   AM15.1
                       category: depreciable or nondepreciable.  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-AST-CATEG       Alpha 1                                   AM115   AM117
Element: To Asset CategThis field indicates the to-asset         AM125   AM15.1
                       category: depreciable or nondepreciable.  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-SIMULATED          Alpha 1                                   AM115   AM117
Element: Simulated     This field indicates whether an asset     AM125   AM15.1
                       is simulated. Simulated assets are        AM15.2  AM15.3
                       imitative representations of assets, not  AM15.4  AM170
                       real assets.                              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-SIMULATED       Alpha 1                                   AM115   AM117
Element: To Simulated  This field indicates whether the          AM125   AM15.1
                       transfer-to asset is simulated.           AM15.2  AM15.3
                       Simulated assets are imitative            AM15.4  AM170
                       representations of assets, not real       AM20.1  AM20.2
                       assets.                                   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-WORK-IN-PROC       Alpha 1                                   AM115   AM117
Element: Work-in-ProcesThis field indicates whether the asset    AM125   AM15.1
                       is work-in-process. Work-in-process       AM15.2  AM15.3
                       assets are real but not yet complete. If  AM15.4  AM170
                       this field is Yes, the asset is on hold   AM20.1  AM20.2
                       and cannot be released.                   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-WORK-IN-PRC     Alpha 1                                   AM115   AM117
Element: To Work-in-ProThis field indicates whether the          AM125   AM15.1
                       transfer-to asset is work-in-process.     AM15.2  AM15.3
                       Work-in-process assets are real but not   AM15.4  AM170
                       yet complete. If this field is Yes, the   AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                       asset is on hold and cannot be released.  AM20.5  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   AM117
Element: Tax Exempt    This field indicates whether the asset    AM125   AM15.1
                       is tax exempt.                            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-TAX-EXEMPT      Alpha 1                                   AM115   AM117
Element: To Tax Exempt This field indicates whether the          AM125   AM15.1
                       to-asset is tax exempt.                   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-USED               Alpha 1                                   AM115   AM117
Element: Used          This field indicates whether the asset    AM125   AM15.1
                       is used.                                  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-USED            Alpha 1                                   AM115   AM117
Element: To Used       This field indicates whether the to-      AM125   AM15.1
                       asset is used.                            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-ITEM-TOT-QTY       Numeric 10                                AM115   AM117
Element: Item Total QuaThis is the total item quantity.          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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

ASA-IT-TOT-CSTBASE     Signed 18.2                               AM115   AM117
Element: Item Total CosThis is the total item cost in the base   AM125   AM15.1
                       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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

ASA-IT-TOT-TAXBASE     Signed 18.2                               AM115   AM117
Element: Item Total TaxThis is the total item tax in the base    AM125   AM15.1
                       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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

ASA-IT-TOT-CSTTRAN     Signed 18.2                               AM115   AM117
Element: Item Total CosThis is the total item cost in the        AM125   AM15.1
                       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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

ASA-IT-TOT-TAXTRAN     Signed 18.2                               AM115   AM117
Element: Item Total TaxThis is the total item tax in the         AM125   AM15.1
                       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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

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

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

ASA-TO-TRAN-ND         Numeric 1                                 AM115   AM117
To Tran Number of      This is the number of decimal positions   AM125   AM15.1
Decimals               defined for the to-asset transaction      AM15.2  AM15.3
                       currency.                                 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-CURRENCY-CODE      Alpha 5                                   AM115   AM117
Element: Currency Code This field contains the company base      AM125   AM15.1
                       currency code established in Company      AM15.2  AM15.3
                       (GL10.1 ).                                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-CURR-CODE       Alpha 5                                   AM115   AM117
Element: To Currency CoThis is the company base currency code,   AM125   AM15.1
                       established in GL10.1 (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-ITEM-LAST-DATE     Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Item Last DateThis is the last adjustment date for      AM125   AM15.1
                       the 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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

ASA-COMPANY            Numeric 4                                 AM115   AM117
Element: Company       Identifies the AP company if the          AM125   AM15.1
                       resource type = V.  Identifies the HR     AM15.2  AM15.3
                       company if the resource type = E.  It is  AM15.4  AM170
                       blank for type A, P or Q resources.       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   AM117
Element: To Company    This is the company number to which       AM125   AM15.1
                       this line is to be posted.                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-LOCATION-NAME      Alpha 15                                  AM115   AM117
Element: Location Name A user-defined location name which        AM125   AM15.1
                       represents where an asset is physically   AM15.2  AM15.3
                       located.                                  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-LOCATION        Alpha 15                                  AM115   AM117
Element: To Location   This is the location for the to-asset.    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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-DIVISION           Alpha 15                                  AM115   AM117
Element: Division      A user-defined division which is used     AM125   AM15.1
                       for reporting assets.                     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-DIVISION        Alpha 15                                  AM115   AM117
Element: To Division   This is the division for the to-asset.    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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-ASSET-TYPE         Alpha 10                                  AM115   AM117
Element: Asset Type    An asset type represents a grouping of    AM125   AM15.1
                       like assets. Asset types are used to      AM15.2  AM15.3
                       group assets into reporting classes and   AM15.4  AM170
                       to default common asset definition data.  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-TYPE      Alpha 10                                  AM115   AM117
Element: To Asset Type This is the asset type for the            AM125   AM15.1
                       to-asset. An asset type represents a      AM15.2  AM15.3
                       grouping of like assets. Asset types are  AM15.4  AM170
                       used to group assets into reporting       AM20.1  AM20.2
                       classes and to default common asset       AM20.3  AM20.4
                       definition data.                          AM20.5  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   AM117
Element: Asset Subtype An asset subtype represents a more        AM125   AM15.1
                       detailed grouping of assets within an     AM15.2  AM15.3
                       asset type grouping. Asset subtypes are   AM15.4  AM170
                       used to group assets into reporting       AM20.1  AM20.2
                       classes and allow common asset            AM20.3  AM20.4
                       definition data to default. Subtypes      AM20.5  AM20.6
                       must be unique within an asset type.      AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

ASA-ACCT-GRP           Alpha 10                                  AM115   AM117
Element: Account Group A user-defined account group which        AM125   AM15.1
                       identifies the general ledger accounts    AM15.2  AM15.3
                       that are used to create journal entries   AM15.4  AM170
                       when assets are processed (added,         AM20.1  AM20.2
                       adjusted, transferred, or disposed of).   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-ACCT-GRP        Alpha 10                                  AM115   AM117
Element: To Account GroThis is the account group for the         AM125   AM15.1
                       to-asset. An account group is a           AM15.2  AM15.3
                       user-defined group that identifies the    AM15.4  AM170
                       general ledger accounts used to create    AM20.1  AM20.2
                       journal entries when assets are           AM20.3  AM20.4
                       processed (added, adjusted, transferred,  AM20.5  AM20.6
                       or disposed of).                          AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

ASA-ACCT-UNIT          Alpha 15                                  AM115   AM117
Element: Accounting UniThe accounting unit is a shorthand        AM125   AM15.1
                       notation representing the variable level  AM15.2  AM15.3
                       number. When used in the General Ledger   AM15.4  AM170
                       Account Master file, the accounting unit  AM20.1  AM20.2
                       must be defined in the General Ledger     AM20.3  AM20.4
                       Names file as a posting accounting unit.  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-UNIT       Alpha 15                                  AM115   AM117
Element: To Accounting This is the accounting unit for the       AM125   AM15.1
                       to-asset. The accounting unit must be     AM15.2  AM15.3
                       defined in the General Ledger Names file  AM15.4  AM170
                       as a posting accounting unit.             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-AU-GROUP           Alpha 10                                  AM115   AM117
Accounting Unit        Accounting unit groups group and          AM125   AM15.1
Group                  identify the accounting units to use      AM15.2  AM15.3
                       when you create journal entries for       AM15.4  AM170
                       adding, adjusting, transferring, or       AM20.1  AM20.2
                       disposing of assets. Changes to           AM20.3  AM20.4
                       accounting unit groups are dynamic,       AM20.5  AM20.6
                       affecting all assets using the            AM21.1  AM21.2
                       accounting unit group. Accounting unit    AM21.3  AM21.4
                       group names are user-definable, and       AM21.5  AM21.6
                       accounting unit groups are set up by      AM500   AM551
                       company.                                  AM96.1  AM98.1

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


ASA-DEP-EXP-ACTVTY     Alpha 15                                  AM115   AM117
Depr Expense           This is the override depreciation         AM125   AM15.1
Activity               expense activity, which overrides any     AM15.2  AM15.3
                       depreciation expense activity set up on   AM15.4  AM170
                       AM06.1 (Type). This is the depreciation   AM20.1  AM20.2
                       expense activity used for posting.        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-DEP-EXP-ATY     Alpha 15                                  AM115   AM117
To Depr Expense        This is the override depreciation         AM125   AM15.1
Activity               expense activity for the to-asset. It     AM15.2  AM15.3
                       overrides any depreciation expense        AM15.4  AM170
                       activity set up on AM06.1 (Type). This    AM20.1  AM20.2
                       is the depreciation expense activity      AM20.3  AM20.4
                       used for posting to the adjusted asset.   AM20.5  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   AM117
Depr Expense Acct      This is the override depreciation         AM125   AM15.1
Category               expense account category, which           AM15.2  AM15.3
                       overrides any depreciation expense        AM15.4  AM170
                       account category set up on AM06.1         AM20.1  AM20.2
                       (Type). This is the depreciation          AM20.3  AM20.4
                       expense account category used for         AM20.5  AM20.6
                       posting.                                  AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

ASA-ORIG-CO            Numeric 4                                 AM115   AM117
Element: Original CompaThis field contains the original          AM125   AM15.1
                       company number when the asset record is   AM15.2  AM15.3
                       added to this file. This field is never   AM15.4  AM170
                       changed after being added.                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-DATE      Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Creation Date This is the date this adjustment was      AM125   AM15.1
                       created.                                  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-CREATION-TIME      Numeric 6  (hhmmss)                       AM115   AM117
Element: Creation Time The creation time.                        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
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

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

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

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

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

ASA-INV-FLAG           Alpha 1                                   AM115   AM117
Element: Inv Flag      This required flag denotes whether an     AM15.1  AM15.2
                       asset should be part of a physical        AM15.3  AM15.4
                       inventory.  It defaults fro Type, but     AM170   AM20.1
                       may be overridden on Addition and         AM20.2  AM20.3
                       Adjustment.                               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-INV-FLAG        Alpha 1                                   AM115   AM117
Element: To Inv Flag   This is the "To" inventory flag field,    AM15.1  AM15.2
                       denoting whether the asset will be part   AM15.3  AM15.4
                       of the inventory after the adjustment.    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-OWNER        Alpha 10                                  AM115   AM117
Element: Asset Owner   This is the individual responsible for    AM15.1  AM15.2
                       the asset, for asset tracking and         AM15.3  AM15.4
                       management purposes.                      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-ASSET-OWNER     Alpha 10                                  AM115   AM117
Element: To Asset OwnerThis is the new asset owner, if the       AM15.1  AM15.2
                       asset owner is changed in the adjustment  AM15.3  AM15.4
                       process.                                  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

                         AMASSETADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASASET1   ASSET                                                  AM115   AM117
          PROCESS-SEQ                                            AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM190
                                                                 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  AM225
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM300
                                                                 ...

ASASET2   COMPANY       Subset                                   AM225   AM300
          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   AM117
                        Where ADJUST-STATUS = "N"                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
                                                                 AM225   AM500
                                                                 AM502   AM51.1
                                                                 AM551   AM92.1
                                                                 AM96.1  AM97.1
                                                                 AM98.1

ASASET8   COMPANY       Subset                                   AM125
          ASSET         Where ADJUST-STATUS = "N"
          PROCESS-SEQ

                         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

Amastitadj     AMASTITADJ

                            ASA-ASSET            -> AIA-ASSET
                            ASA-PROCESS-SEQ      -> AIA-PROCESS-SEQ
                                                    AIA-SEQ-NUMBER