Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMASTITDSP FILE

                          Asset Item Disposal

This file contains historical asset item information related to disposals.

REFERENCED BY

AM245     AMDL.1

UPDATED BY

AM145     AM154     AM170     AM300     AM40.1    AM40.2
AM41.1    AM192

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

ADS-DSP-METHOD       Alpha 1                                     AM145   AM154
Disposal Method      This is the disposal method, indicating     AM40.1  AM40.2
                     the way in which the asset was disposed
                     of. Valid values are:
                     A = Abandoned
                     D = Donated
                     E = Exchanged
                     P = Purged
                     R = Retired
                     S = Sold
                     T = Traded
                     O = Other

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

ADS-ITEM-NBR         Alpha 32                                    AM145   AM154
Item Number          The number assigned to the asset item.      AM40.1  AM40.2
                     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   AM154
Quantity             The number of units that make up the        AM40.1  AM40.2
                     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   AM154
Item Cost Base       This is the item cost in the base           AM40.1  AM40.2
                     currency.

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

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

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

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

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

ADS-BAR-CODE         Alpha 30                                    AM154
Bar Code             This field contains the bar code of the
                     item being disposed.

                         AMASTITDSP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADSSET1   ASSET         This index accesses information by       AM145   AM170
          PROCESS-SEQ   asset number and process sequence        AM192   AM300
          SEQ-NUMBER    number.                                  AM40.1  AM41.1

ADSSET2   ASSET         This index accesses information by       AM245   AMDL.1
          SEQ-NUMBER    asset number and transaction sequence
          PROCESS-SEQ   number.


                         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