Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASSETDSP


                            AMASSETDSP FILE

                             Asset Disposal

This file contains historical asset information related to disposals. It is
updated by AM40.1 (Disposals).

REFERENCED BY

AM120     AM135     AM190     AM220     AM221     AM222
AM223     AM224     AM225     AM23.3    AM230     AM235
AM240     AM245     AM25.2    AM250     AM255     AM260
AM265     AM267     AM275     AM277     AM278     AM280
AM281     AM285     AM287     AM290     AM292     AM295
AM30.1    AM30.2    AM30.3    AM310     AM320     AM35.1
AM45.1    AM501     AM502     AM70.4    AM88.1    AM92.1
AM95.1    AM95.2    AM95.4    AM95.5    AM95.6    AMAS.1
AMBK.1    AMBL.1    AMDL.1    MX500

UPDATED BY

AM145     AM154     AM170     AM192     AM300     AM40.1
AM40.2    AM41.1    AC160     AM115     AM117     AM125
AM15.1    AM15.2    AM15.3    AM15.4    AM19.1    AM19.2
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM21.1    AM21.2    AM21.3    AM21.4    AM21.5    AM21.6
AM330     AM500     AM551     AM96.1    AM98.1    AP115
AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP220     AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP305     API1.1    API2.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    MA180     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ASD-ASSET              Numeric 10                                AM145   AM154
Element: Asset         Required. The asset number contains up    AM40.1  AM41.1
                       to ten numeric characters that uniquely
                       identify an asset. Assets are
                       automatically numbered system-wide.

ASD-DSP-STATUS         Alpha 1                                   AM145   AM154
Element: Disposal StatuThis field indicates the status of the    AM170   AM40.1
                       disposal. Valid values are:
                       R = Released
                       N = Not Released

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

ASD-DSP-METHOD         Alpha 1                                   AM145   AM154
Element: Disposal MethoThis field indicates the way in which     AM40.1
                       the asset was disposed of. Valid values
                       are:
                       A = Abandoned
                       D = Donated
                       E = Exchanged
                       P = Purged
                       R = Retired
                       S = Sold
                       T = Traded
                       O = Other

ASD-DSP-PROPERTY       Alpha 10                                  AM145   AM40.1
Element: Disposal PropeThis is the user-defined name of a
                       disposal property. It represents a kind
                       of disposed-of asset.

ASD-DSP-QUANTITY       Numeric 10                                AM145   AM154
Element: Disposal QuantThis field indicates the asset quantity   AM40.1  AM40.2
                       disposed of.

ASD-LEASE-COMPANY      Numeric 4                                 AM154   AM40.1
Element: Company       The lessor company for the disposed
                       leased asset.

ASD-LEASE              Alpha 19                                  AM154   AM40.1
Element: Lease         The lease number associated with the
                       disposed leased asset.

ASD-ASSET-GROUP        Alpha 10                                  AM154
Element: Asset Group   The asset group assigned to the
                       disposed leased asset.

ASD-FULL-PARTIAL       Alpha 1                                   AM145   AM154
Element: Full Partial  This field indicates whether the          AM40.1
                       disposal was full (including all asset
                       items) or partial (including only some
                       asset items). Valid values are:
                       F = Full
                       P = Partial

ASD-PROCEEDS-CURR      Alpha 5                                   AM145   AM40.1
Element: Proceeds CurreThis is the currency for the Proceeds
                       account.

ASD-PROCEEDS           Signed 18.2                               AM145   AM154
Element: Proceeds      This field contains the proceeds of the   AM40.1
                       sale of this asset based on the book
                       value in this record.

ASD-COST-SALE-CURR     Alpha 5                                   AM145   AM40.1
Element: Cost Sale CurrThis is the currency for the cost of
                       the sale of the asset.

ASD-COST-SALE          Signed 18.2                               AM145   AM154
Element: Cost Sale     This is the cost of the sale of the       AM40.1
                       asset.

ASD-ITEM-TOT-QTY       Numeric 10                                AM145   AM154
Element: Item Total QuaThis is the total item quantity for the   AM40.1  AM40.2
                       disposal.

ASD-IT-TOT-CSTBASE     Signed 18.2                               AM145   AM154
Element: Item Total CosThis is the total item cost in the base   AM40.1  AM40.2
                       currency.

ASD-IT-TOT-CSTTRAN     Signed 18.2                               AM145   AM154
Element: Item Total CosThis is the total item cost in the        AM40.1  AM40.2
                       transaction currency.

ASD-IT-TOT-TAXBASE     Signed 18.2                               AM145   AM154
Element: Item Total TaxThis is the total item tax in the base    AM40.1  AM40.2
                       currency.

ASD-IT-TOT-TAXTRAN     Signed 18.2                               AM145   AM154
Element: Item Total TaxThis is the total item tax in the         AM40.1  AM40.2
                       transaction currency.

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

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

ASD-CURRENCY-CODE      Alpha 5                                   AM145   AM154
Element: Currency Code This field contains the company base      AM40.1
                       currency code established in Company
                       (GL10.1 ).

ASD-ITEM-LAST-DATE     Numeric 8  (yyyymmdd)                     AM145   AM154
Element: Item Last DateThis is the last changed date for the     AM40.1
                       record.

ASD-ITEM-LAST-SEQ      Numeric 6                                 AM145   AM154
Element: Item Last SequThis is the last sequence number for      AM40.1
                       the last change to the record.

ASD-CREATION-DATE      Numeric 8  (yyyymmdd)                     AM145   AM154
Element: Creation Date This is the date that the disposal        AM40.1
                       record was created.

ASD-CREATION-TIME      Numeric 6  (hhmmss)                       AM145   AM154
Element: Creation Time This is the time the disposal record      AM40.1
                       was created.

ASD-CREATOR-ID         Alpha 10                                  AM145   AM154
Element: Creator ID    This is the ID of the person creating     AM40.1
                       the disposal record.

ASD-AST-DSP-ASSET      Derived
Element: Ast Dsp Asset This is the disposal asset.

ASD-AST-TAG-NBR        Derived
Element: Ast Tag Nbr   This is the asset tag number. A tag
                       number is a user-definable identifier
                       assigned to an asset.

ASD-AST-ASSET-GRP      Derived
Element: Ast Asset Grp This is the asset group for the
                       disposed-of asset. An asset group
                       represents a parent asset number used to
                       group assets for reporting.

ASD-AST-DESCRIP        Derived
Element: Ast Descrip   This is the asset description for the
                       disposed-of asset.


                         AMASSETDSP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASDSET1   ASSET                                                  AC160   AM115
                                                                 AM117   AM120
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  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  AM220
                                                                 ...

                         AMASSETDSP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required

                            ASD-ASSET           -> AST-ASSET

Amdspprop      AMDSPPROP    Not Required

                            ASD-DSP-PROPERTY    -> DSP-DSP-PROPERTY

                         AMASSETDSP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastbkdsp     AMASTBKDSP

                            ASD-ASSET           -> ABD-ASSET
                                                   ABD-BOOK