Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            AMASTITDSP FILE

                          Asset Item Disposal

This file contains historical asset item information related to disposals.

REFERENCED BY

AM245

UPDATED BY

AM145     AM300     AM40.1    AM40.2    AM956     AM192

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ADS-ASSET            Numeric 10                                  AM145   AM40.1
Asset                Key field. The asset number contains up     AM40.2  AM956
                     to ten numeric characters that uniquely
                      identify an asset. Assets are
                     automatically numbered system-wide.


ADS-SEQ-NUMBER       Numeric 6                                   AM145   AM40.1
Sequence Number      Key field. A unique number assigned to      AM40.2  AM956
                     each transaction in the Lawson system.


ADS-PROCESS-SEQ      Numeric 4                                   AM145   AM40.1
Process Sequence     This is the sequence number for this        AM40.2  AM956
                     disposal process.


ADS-DSP-DATE         Numeric 8  (yyyymmdd)                       AM145   AM40.1
Disposal Date        This is the date of the disposal.           AM40.2  AM956

ADS-DSP-METHOD       Alpha 1                                     AM145   AM40.1
Disposal Method      This is the disposal method, indicating     AM40.2  AM956
                     the way in which the asset was disposed
                     of.

                     A = Abandoned
                     D = Donated
                     E = Exchanged
                     P = Purged
                     R = Retired
                     S = Sold
                     T = Traded
                     O = Other

ADS-DSP-QUANTITY     Numeric 10                                  AM145   AM40.1
Quantity             This is the asset quantity that was         AM40.2  AM956
                     disposed of.


ADS-ITEM-NBR         Alpha 32                                    AM145   AM40.1
Item Number          The number assigned to the asset item.      AM40.2  AM956
                     The item number must be unique within an
                     asset, but can be duplicated from asset
                     to asset. The item number identifies an
                     item of an asset composed of different
                     elements but depreciated as a common
                     asset unit.


ADS-ITEM-QUANTITY    Numeric 8                                   AM145   AM40.1
Quantity             The number of units that make up the        AM40.2  AM956
                     asset item. Each unit of an item is
                     exactly the same as every other unit of
                     the item.


ADS-ITEM-COST-BASE   Signed 15.2                                 AM145   AM40.1
Item Cost Base       This is the item cost in the base           AM40.2  AM956
                     currency.


ADS-ITEM-TAX-BASE    Signed 15.2                                 AM145   AM40.1
Item Tax Base        This is the tax on the item in the base     AM40.2  AM956
                     currency.


ADS-ITEM-COST-TRAN   Signed 15.2                                 AM145   AM40.1
Item Cost Tran       This is the item cost in the                AM40.2  AM956
                     transaction currency.


ADS-ITEM-TAX-TRAN    Signed 15.2                                 AM145   AM40.1
Item Tax Tran        This is the tax on the item in the          AM40.2  AM956
                     transaction currency.


ADS-BASE-ND          Numeric 1                                   AM145   AM40.1
Base Number of       The number of decimal positions defined     AM40.2  AM956
Decimals             for the company base currency.


ADS-TRAN-ND          Numeric 1                                   AM145   AM40.1
Tran Number of       The number of decimal positions defined     AM40.2  AM956
Decimals             for the transaction currency.


                         AMASTITDSP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADSSET1   ASSET                                                  AM145   AM192
          PROCESS-SEQ                                            AM300   AM40.1
          SEQ-NUMBER                                             AM956

ADSSET2   ASSET                                                  AM245
          SEQ-NUMBER
          PROCESS-SEQ

                         AMASTITDSP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastitem      AMASTITEM    Required

                            ADS-ASSET         -> ASI-ASSET
                            ADS-SEQ-NUMBER    -> ASI-SEQ-NUMBER