Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASSETRIN


                            AMASSETRIN FILE

                          Asset Reinstatement

This file contains audit information related to reinstated disposed assets. It
is updated by Reinstate Disposed Assets (AM41.1). The file contains a copy of
the disposal information previously contained in AMASSETDSP, plus
reinstatement information.

REFERENCED BY

AM241

UPDATED BY

AM170     AM300     AM41.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

RIN-DSP-STATUS         Alpha 1                                   AM170   AM41.1
Element: Dsp Status    This field indicates the status of the
                       disposal. Valid values are:
                       R = Released
                       N = Not Released

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

RIN-DSP-METHOD         Alpha 1                                   AM41.1
Element: Dsp Method    This field indicates 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

RIN-DSP-PROPERTY       Alpha 10                                  AM41.1
Element: Dsp Property  This is the user-defined name of a
                       disposal property. It represents a kind
                       of disposed-of asset.

RIN-DSP-QUANTITY       Numeric 10                                AM41.1
Element: Item Tot Qty  This field indicates the asset quantity
                       disposed of.

RIN-LEASE-COMPANY      Numeric 4                                 AM41.1
Element: Company       The lessor company for the disposed
                       leased asset.

RIN-LEASE              Alpha 19                                  AM41.1
Element: Lease         The lease number associated with the
                       disposed leased asset.

RIN-ASSET-GROUP        Alpha 10                                  AM41.1
Element: Asset Group   The asset group assigned to the
                       disposed leased asset.

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

RIN-PROCEEDS-CURR      Alpha 5                                   AM41.1
Element: Proceeds Curr This is the currency for the Proceeds
                       account.

RIN-PROCEEDS           Signed 18.2                               AM41.1
Element: Intl Amt      This field contains the proceeds of the
                       sale of this asset based on the book
                       value in this record.

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

RIN-COST-SALE          Signed 18.2                               AM41.1
Element: Intl Amt      This is the cost of the sale of the
                       asset.

RIN-ITEM-TOT-QTY       Numeric 10                                AM41.1
Element: Item Tot Qty  This is the total item quantity for the
                       disposal.

RIN-IT-TOT-CSTBASE     Signed 18.2                               AM41.1
Element: Intl Amt      This is the total item cost in the base
                       currency.

RIN-IT-TOT-CSTTRAN     Signed 18.2                               AM41.1
Element: Intl Amt      This is the total item cost in the
                       transaction currency.

RIN-IT-TOT-TAXBASE     Signed 18.2                               AM41.1
Element: Intl Amt      This is the total item tax in the base
                       currency.

RIN-IT-TOT-TAXTRAN     Signed 18.2                               AM41.1
Element: Intl Amt      This is the total item tax in the
                       transaction currency.

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

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

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

RIN-ITEM-LAST-DATE     Numeric 8  (yyyymmdd)                     AM41.1
Element: Item Last DateThis is the last changed date for the
                       record.

RIN-ITEM-LAST-SEQ      Numeric 6                                 AM41.1
Record Sequence        This is the last sequence number for
Number                 the last change to the record.

RIN-CREATION-DATE      Numeric 8  (yyyymmdd)                     AM41.1
Element: Creation Date This is the date that the disposal
                       record was created.

RIN-CREATION-TIME      Numeric 6  (hhmmss)                       AM41.1
Element: Creation Time This is the time the disposal record
                       was created.

RIN-CREATOR-ID         Alpha 10                                  AM41.1
Element: Operator Code This is the ID of the person creating
                       the disposal record.

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

RIN-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.

RIN-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.

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

RIN-REINSTATE-DATE     Numeric 8  (yyyymmdd)                     AM41.1
Element: Reinstate DateThis is the reinstatement date of the
                       asset.

RIN-COMPANY            Numeric 4                                 AM41.1
Element: Company       This is the company the asset is
                       associated with.

                         AMASSETRIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RINSET1   ASSET         This index accesses the reinstatement    AM170   AM300
          CREATION-DATE information by asset.                    AM41.1
          CREATION-TIME

RINSET2   COMPANY       This index accesses the reinstatement    AM241
          ASSET         information by company.
          CREATION-DATE
          CREATION-TIME

                         AMASSETRIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required

                            RIN-ASSET             -> AST-ASSET

Amassetdsp     AMASSETDSP   Not Required

                            RIN-ASSET             -> ASD-ASSET

                         AMASSETRIN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastbkrin     AMASTBKRIN

                            RIN-ASSET             -> RIB-ASSET
                            RIN-REINSTATE-DATE    -> RIB-REINSTATE-DATE
                                                     RIB-BOOK
                                                     RIB-CREATION-DATE
                                                     RIB-CREATION-TIME

Amastitrin     AMASTITRIN

                            RIN-ASSET             -> RIT-ASSET
                            RIN-REINSTATE-DATE    -> RIT-REINSTATE-DATE
                                                     RIT-PROCESS-SEQ
                                                     RIT-SEQ-NUMBER
                                                     RIT-CREATION-DATE
                                                     RIT-CREATION-TIME