Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTITRIN


                            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    AM330

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RIT-ASSET              Numeric 10                                AM41.1
Element: 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
Element: Sequence NumbeThis is the sequence number for this
                       disposal process.

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

RIT-DSP-METHOD         Alpha 1                                   AM41.1
Element: 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
Element: Item Tot Qty  This is the asset quantity that was
                       disposed of.

RIT-ITEM-NBR           Alpha 32                                  AM41.1
Element: Item Number   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
Element: 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
Element: Actual Cost   This is the item cost in the base
                       currency.

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

RIT-ITEM-COST-TRAN     Signed 15.2                               AM41.1
Element: Actual Cost   This is the item cost in the
                       transaction currency.

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

RIT-BASE-ND            Numeric 1                                 AM41.1
Account Currency       The number of decimal positions defined
Code                   for the base currency.

RIT-TRAN-ND            Numeric 1                                 AM41.1
Account Currency       The number of decimal positions defined
Code                   for the transaction currency.

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

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

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

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

RIT-REINSTATE-DATE     Numeric 8  (yyyymmdd)                     AM41.1
Element: Reinstate DateThis 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   AM330
          PROCESS-SEQ   asset number and process sequence        AM41.1
          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