Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTITRIN


                            AMASTITRIN FILE

                        Asset Item Reinstatement

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         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
Element: Seq Number    A unique number assigned to each
                       transaction to be interfaced into the
                       Lawson system.

RIT-PROCESS-SEQ        Numeric 6                                 AM41.1
Element: Seq Number    This is the sequence number for this
                       disposal process.

RIT-DSP-DATE           Numeric 8  (yyyymmdd)                     AM41.1
Element: Dsp 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          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 18.2                               AM41.1
Element: Intl Amt      This is the item cost in the base
                       currency.

RIT-ITEM-TAX-BASE      Signed 18.2                               AM41.1
Element: Intl Amt      This is the tax on the item in the base
                       currency.

RIT-ITEM-COST-TRAN     Signed 18.2                               AM41.1
Element: Intl Amt      This is the item cost in the
                       transaction currency.

RIT-ITEM-TAX-TRAN      Signed 18.2                               AM41.1
Element: Intl Amt      This is the tax on the item in the
                       transaction currency.

RIT-BASE-ND            Numeric 1                                 AM41.1
Element: Base Nd       The number of decimal positions defined
                       for the base currency.

RIT-TRAN-ND            Numeric 1                                 AM41.1
Element: Acct Nd       The number of decimal positions defined
                       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: Creation Date This field contains the record creation
                       date.

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

RIT-CREATOR-ID         Alpha 10                                  AM41.1
Element: Operator      This field contains the login ID of the
                       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                                                  AM300   AM330
          PROCESS-SEQ                                            AM41.1
          SEQ-NUMBER
          CREATION-DATE
          CREATION-TIME

RITSET2   ASSET
          REINSTATE-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