Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTITDSP


                            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     AM330

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADS-ASSET              Numeric 10                                AM145   AM154
Element: 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
Element: Sequence NumbeKey field. A unique number assigned to    AM40.1  AM40.2
                       each transaction in the Lawson system.    AMDL.1

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

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

ADS-DSP-METHOD         Alpha 1                                   AM145   AM154
Element: Disposal MethoThis 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
Element: Quantity      This is the asset quantity that was       AM40.2
                       disposed of.

ADS-ITEM-NBR           Alpha 32                                  AM145   AM154
Element: 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
Element: 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
Element: Item Cost BaseThis is the item cost in the base         AM40.1  AM40.2
                       currency.

ADS-ITEM-TAX-BASE      Signed 15.2                               AM145   AM154
Element: 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
Element: Item Cost TranThis is the item cost in the              AM40.1  AM40.2
                       transaction currency.

ADS-ITEM-TAX-TRAN      Signed 15.2                               AM145   AM154
Element: 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
Element: 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.                                  AM330   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