Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTBKRIN


                            AMASTBKRIN FILE

This file contains audit asset book information related to reinstated
disposals. It contains a copy of the disposal information contained in
AMASTBKDSP, plus reinstatement information.

REFERENCED BY

AM241

UPDATED BY

AM300     AM310     AM41.1    AM330

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RIB-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 are
                       automatically numbered system-wide.

RIB-BOOK               Alpha 10                                  AM41.1
Element: Book          Key field. This field contains a
                       user-defined book name.  Books are used
                       by assets for calculating depreciation,
                       replacement cost, and insurance values,
                       and for reporting.

RIB-BOOK-COST-SALE     Signed 15.2                               AM41.1
Element: Actual Cost   This is the cost of sale for the asset
                       disposal.

RIB-CST-SALE-OVRRD     Signed 15.2                               AM41.1
Element: Actual Sales  This is the overriding amount for the
                       book cost of sale.

RIB-BOOK-PROCEEDS      Signed 15.2                               AM41.1
Element: Price         This field contains the proceeds for
                       the asset disposal.

RIB-PROCEEDS-OVRRD     Signed 15.2                               AM41.1
Element: Price         This is the overriding amount for the
                       book proceeds from the disposal.

RIB-GAIN-LOSS          Signed 15.2                               AM41.1
Element: Gain Loss     This field contains the gain or loss
                       for the asset disposal.

RIB-GN-LS-OVERRIDE     Signed 15.2                               AM41.1
Element: Gain Loss     This field contains the gain or loss
                       override for the asset disposal.

RIB-DEFER-GN-LS        Signed 15.2                               AM41.1
Element: Gain Loss     This field contains the deferred gain
                       or loss for the asset disposal.

RIB-DEFER-OVERRIDE     Signed 15.2                               AM41.1
Element: Defer OverrideThis field contains the deferred gain
                       or loss override for the asset disposal.


RIB-TC-RECAPTURE       Signed 15.2                               AM41.1
Element: Tc Property   This is the tax credit recapture amount
                       for the asset disposal.

RIB-TC-OVERRIDE        Signed 15.2                               AM41.1
Element: Tc Property   This is the tax credit recapture
                       override for the asset disposal.

RIB-BOOK-BASIS         Signed 15.2                               AM41.1
Element: Book Basis    This field contains the book basis
                       amount on which the depreciation
                       calculations for the disposed asset are
                       based.

                       Note: The depreciation basis amount can
                       be different for each depreciation book
                       used.

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

RIB-DSP-DEPR           Signed 15.2                               AM41.1
Element: Depr Ytd      This is the depreciation expense
                       associated with the disposal.

RIB-DSP-DEPR-OVRRD     Signed 15.2                               AM41.1
Element: Depr Ytd      This is the depreciation expense
                       override amount associated with the
                       disposal.

RIB-DEPR-YTD           Signed 15.2                               AM41.1
Element: Depr Ytd      This is the year-to-date depreciation
                       for the disposed asset.

RIB-DEPR-YTD-ALLOW     Signed 15.2                               AM41.1
Element: Depr Ytd      This is the year-to-date depreciation
                       allowance for the disposed asset.

RIB-DEPR-YTD-OVRRD     Signed 15.2
Element: Depr Ytd      This is the year-to-date depreciation
                       override for the disposed asset..

RIB-DEPR-LTD           Signed 15.2                               AM41.1
Element: Depr Ytd      This is the life-to-date depreciation
                       for the disposed-of asset.

RIB-DEPR-LTD-ALLOW     Signed 15.2                               AM41.1
Element: Depr Ytd      This is the life-to-date depreciation
                       allowance for the disposed asset.

RIB-SALVAGE-VALUE      Signed 15.2                               AM41.1
Element: Actual        This is the salvage value of the asset,
                       or value remaining, at the end of the
                       asset's life. It can be zero.

                       If the depreciation method is SL
                       (Straight Line), the basis used for the
                       depreciation calculation is the asset
                       cost less this salvage value.

                       If the depreciation method is 200DB
                       (Double Declining Balance), 125DB (125%
                       Declining Balance), 150 (150% Declining
                       Balance), or 175 (175% Declining
                       Balance), the basis used for the
                       depreciation calculation is the asset
                       cost. Depreciation is taken until the
                       total amount taken is equal to the asset
                       cost less this salvage value.

RIB-YR1-EXP            Signed 15.2                               AM41.1
Element: To Yr1 Exp    This is the new first year expense
                       amount for the asset. It represents the
                       amount to expense for the First Year
                       Expense option. This U.S. tax option
                       allows you to expense and not depreciate
                       a total dollar amount for the assets of
                       each eligible company.

RIB-TC-PROPERTY        Signed 15.2                               AM41.1
Element: Tc Property   This is the tax credit amount for the
                       asset, if you are taking a tax credit
                       for used property.

RIB-TAX-CREDIT         Signed 15.2                               AM41.1
Element: Auto Credits  This is the tax credit amount for the
                       asset.

RIB-INS-ACT-VAL        Signed 15.2                               AM41.1
Element: Actual        This is the actual insurance value for
                       the asset.

RIB-INS-CMPTD-VAL      Signed 15.2                               AM41.1
Element: To Rpl Cmptd  This is the computed replacement value
                       for the asset.

RIB-RPL-CMPTD-VAL      Signed 15.2                               AM41.1
Element: To Rpl Cmptd  This is the computed replacement value
                       for the asset.

RIB-NEW-AST-BASIS      Signed 15.2                               AM41.1
Element: Book Basis    If the disposal was a partial disposal,
                       a new asset was defined. This field
                       contains the new asset basis, or the
                       amount on which depreciation
                       calculations for the new asset are
                       based.

RIB-CASH-PAID          Signed 15.2                               AM41.1
Element: Current Cash  This is the amount of cash paid in the
                       asset disposal.

RIB-OLD-AST-ADJ-BS     Signed 15.2                               AM41.1
Element: Book Basis    This is the adjusted basis for the old
                       asset.

RIB-AMT-REALIZED       Signed 15.2                               AM41.1
Element: Adj Amt       This is the amount realized through the
                       disposal.

RIB-AMT-GIVEN-UP       Signed 15.2                               AM41.1
Element: Adj Amt       This is the amount of depreciation
                       given up as a result of the disposal.

RIB-NEW-AST-ADJ-BS     Signed 15.2                               AM41.1
Element: Book Basis    If the disposal was a partial disposal,
                       a new asset was defined. This is the
                       adjusted basis for the new asset.

RIB-NEW-ASSET          Numeric 10                                AM41.1
Element: Asset Number  If the disposal was partial disposal, a
                       new asset was defined. This is the new
                       asset number.

RIB-AST-DSP-ASSET      Derived
Element: Ast Dsp Asset This is the number of the disposed-of
                       asset.

RIB-AST-ASSET-GRP      Derived
Element: Ast Asset Grp This is the asset group for the new
                       asset.

RIB-AST-TAG-NBR        Derived
Element: Ast Tag Nbr   This is the tag for the new asset.

RIB-AST-DESCRIP        Derived
Element: Ast Descrip   This is the new asset description.

RIB-ASD-DSP-DATE       Derived
Element: Asd Dsp Date  This is the effective date for the
                       asset disposal.

RIB-ASD-FULL-PART      Derived
Element: Asd Full Part This field indicates whether the
                       disposal was a full or partial disposal.


RIB-ASD-DSP-METH       Derived
Element: Asd Dsp Meth  This is the way in which the asset was
                       disposed of.

RIB-ASD-DSP-PROP       Derived
Element: Asd Dsp Prop  This is the user-defined name of a
                       disposal property. It represents a kind
                       of disposed-of asset.

RIB-BOOK-CURRENCY      Derived
Element: Book Currency This is the currency for the book.

RIB-DSP-CREAT-DATE     Derived
Element: Dsp Creat DateThis is the creation date for the
                       disposal.

RIB-DSP-CREAT-TIME     Derived
Element: Dsp Creat TimeThis is the creation time for the
                       disposal.

RIB-DSP-CREATOR-ID     Derived
Element: Dsp Creator IdThis is the ID of the person who
                       created the disposal.

RIB-AMB-DESC           Derived
Element: Amb Desc      This is the description of the book.

RIB-ASB-BOOK-BASIS     Derived
Element: Asb Book BasisThis field contains the amount on which
                       the depreciation calculations for the
                       book are based.

RIB-ASB-METHOD         Derived
Element: Asb Method    This is the asset book depreciation
                       method.

RIB-ASB-LIFE           Derived
Element: Asb Life      This is the life of the asset.

RIB-ASB-LIFE-REM       Derived
Element: Asb Life Rem  This is the remaining life for the
                       asset.

RIB-ASB-INSRV-DATE     Derived
Element: Asb Insrv DateThis is the in-service date for the
                       asset.

RIB-ASB-CONVENTION     Derived
Element: Asb ConventionThis is the in-service convention for
                       the asset.

RIB-DSP-OVERRIDE       Derived
Element: Dsp Override  The word "OVERRIDE" displays if the
                       disposal amount has been overridden.

RIB-PROC-OVERRIDE      Derived
Element: Proc Override The word "OVERRIDE" displays if the
                       proceeds amount has been overridden.

RIB-COS-OVERRIDE       Derived
Element: Cos Override  The word "OVERRIDE" displays if the
                       expense amount has been overridden.

RIB-DEFR-OVERRIDE      Derived
Element: Defr Override The word "OVERRIDE" displays if the
                       deferred gain or loss amount has been
                       overridden.

RIB-TCRECAP-OVERRD     Derived
Element: Tcrecap OverrdThe word "OVERRIDE" displays if the tax
                       credit recapture amount has been
                       overridden.

RIB-CALC-DEPR-LTD      Derived
Element: Calc Depr Ltd This is the life-to-date calculated
                       depreciation

RIB-DSP-NET-VALUE      Derived
Element: Dsp Net Value The Disposal Net Value is calculated as
                       follows: Book Basis - Life-to-Date
                       Depreciation.

RIB-AST-LOCATION       Derived
Element: Ast Location  This is the location associated with
                       the asset.

RIB-AST-DIVISION       Derived
Element: Ast Division  This is the division associated with
                       the asset.

RIB-AST-TYPE           Derived
Element: Ast Type      This is the type associated with the
                       asset.

RIB-AST-SUBTYPE        Derived
Element: Ast Subtype   This is the subtype associated with the
                       asset.

RIB-CREATION-DATE      Numeric 8  (yyyymmdd)                     AM41.1
Element: Date          This is the record creation date

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

RIB-CREATOR-ID         Alpha 10                                  AM41.1
Authorization          This is the login ID of the person
Identification         creating the record.

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

                         AMASTBKRIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RIBSET1   ASSET         This index accesses information by       AM241   AM300
          BOOK          asset and book.                          AM330
          CREATION-DATE KeyChange
          CREATION-TIME

RIBSET2   BOOK          This index accesses information by book  AM310
          ASSET         and asset.
          CREATION-DATE
          CREATION-TIME

RIBSET3   ASSET         This index accesses information by       AM41.1
          REINSTATE-DATEasset and reinstatement date.
          BOOK
          CREATION-DATE
          CREATION-TIME

                         AMASTBKRIN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required
                            Valid When RIB-ASSET != Zeroes

                            RIB-ASSET            -> AST-ASSET

Amassetrin     AMASSETRIN   Not Required

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

Amastbook      AMASTBOOK    Not Required

                            RIB-ASSET            -> ASB-ASSET
                            RIB-BOOK             -> ASB-BOOK

Amasttype      AMASTTYPE    Not Required

                            AST-COMPANY          -> ATP-COMPANY
                            AST-ASSET-TYPE       -> ATP-ASSET-TYPE
                            AST-SUB-TYPE         -> ATP-SUB-TYPE

Ambook         AMBOOK       Not Required

                            RIB-BOOK             -> AMB-BOOK

Amdivision     AMDIVISION   Not Required

                            AST-DIVISION         -> DIV-DIVISION

Amlocation     AMLOCATION   Not Required

                            AST-LOCATION-NAME    -> LOC-LOCATION-NAME