Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMASTITRIN FILE

This file contains audit asset item information related to reinstated
disposals. It contains a copy of the disposal information previously contained
in AMASTITDSP, plus reinstatment information.

UPDATED BY

AM300     AM41.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RIT-ASSET            Numeric 10                                  AM41.1
Asset Number         Key field. The asset number contains up
                     to ten numeric characters that uniquely
                      identify an asset. Assets ~$3
                     AMASTITRINSEQ-NUMBER
                     Key field. A unique number assigned to
                     each transaction in the Lawson system.

RIT-SEQ-NUMBER       Numeric 6                                   AM41.1
Record Sequence      A unique number assigned to each
Number               transaction to be transferred into the
                     Lawson system.


RIT-PROCESS-SEQ      Numeric 4                                   AM41.1
Process Seq          This is the sequence number for this
                     disposal process.

RIT-DSP-DATE         Numeric 8  (yyyymmdd)                       AM41.1
Dsp Date             This is the date of the disposal.

RIT-DSP-METHOD       Alpha 1                                     AM41.1
Dsp Method           This is the date of the disposal.
                     A = Abandoned
                     D = Donated
                     E = Exchanged
                     P = Purged
                     R = Retired
                     S = Sold
                     T = Traded
                     O = Other

RIT-DSP-QUANTITY     Numeric 10                                  AM41.1
Dsp Quantity         This is the asset quantity that was
                     disposed of.

RIT-ITEM-NBR         Alpha 32                                    AM41.1
Item Nbr             The number assigned to the asset item.
                     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.

RIT-ITEM-QUANTITY    Numeric 8                                   AM41.1
Item Quantity        The number of units that make up the
                     asset item. Each unit of an item is
                     exactly the same as every other unit of
                     the item.

RIT-ITEM-COST-BASE   Signed 15.2                                 AM41.1
Item Cost Base       This is the item cost in the base
                     currency.

RIT-ITEM-TAX-BASE    Signed 15.2                                 AM41.1
Item Tax Base        This is the tax on the item in the base
                     currency.

RIT-ITEM-COST-TRAN   Signed 15.2                                 AM41.1
Item Cost Tran       This is the item cost in the
                     transaction currency.

RIT-ITEM-TAX-TRAN    Signed 15.2                                 AM41.1
Item Tax Tran        This is the tax on the item in the
                     transaction currency.

RIT-BASE-ND          Numeric 1                                   AM41.1
Base Number Of       The number of decimal positions defined
Decimals             for the base currency.

RIT-TRAN-ND          Numeric 1                                   AM41.1
Transaction Number   The number of decimal positions defined
of Decimals          for the transaction currency.

RIT-BAR-CODE         Alpha 30                                    AM41.1
Bar Code             This field contains the bar code of the
                     item being disposed.

RIT-CREATION-DATE    Numeric 8  (yyyymmdd)                       AM41.1
Creation Date        This field contains the record creation
                     date.

RIT-CREATION-TIME    Numeric 6  (hhmmss)                         AM41.1
Creation Time        This field contains the record creation
                     time.

RIT-CREATOR-ID       Alpha 10                                    AM41.1
Creator Id           This field contains the login ID of the
                     person creating the record.

RIT-REINSTATE-DATE   Numeric 8  (yyyymmdd)                       AM41.1
Reinstate Date       This field contains the reinstatement
                     date of the disposed item.

                         AMASTITRIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RITSET1   ASSET         This index accesses information by       AM300   AM41.1
          PROCESS-SEQ   asset number and process sequence
          SEQ-NUMBER    number.
          CREATION-DATE
          CREATION-TIME

RITSET2   ASSET         This index accesses information by
          REINSTATE-DATEasset number and reinstatement date.
          PROCESS-SEQ
          SEQ-NUMBER
          CREATION-DATE
          CREATION-TIME

                         AMASTITRIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastitem      AMASTITEM    Required

                            RIT-ASSET         -> ASI-ASSET  (ASISET1)
                            RIT-SEQ-NUMBER    -> ASI-SEQ-NUMBER