Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMBOOK


                              AMBOOK FILE

                            Asset Book Name

The Book file stores the books that asset uses for calculating depreciation,
replacement cost, and insurance values, and for reporting.

REFERENCED BY

AM01.1    AM01.2    AM01.3    AM04.1    AM06.4    AM06.5
AM10.1    AM115     AM12.1    AM120     AM125     AM135
AM145     AM15.1    AM15.2    AM15.3    AM15.4    AM154
AM170     AM180     AM185     AM190     AM192     AM195
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM20.7    AM20.8    AM200     AM205     AM21.1    AM21.2
AM21.3    AM21.4    AM21.5    AM21.6    AM21.7    AM21.8
AM210     AM212     AM214     AM220     AM222     AM225
AM230     AM240     AM241     AM255     AM260     AM265
AM266     AM267     AM270     AM275     AM277     AM278
AM280     AM281     AM282     AM285     AM287     AM290
AM292     AM295     AM30.1    AM30.2    AM30.3    AM310
AM320     AM40.1    AM40.2    AM40.3    AM40.4    AM41.1
AM41.2    AM500     AM501     AM520     AM551     AM580
AM60.1    AM75.1    AM80.1    AM85.1    AM90.1    AM90.4
AM90.5    AM90.6    AM91.1    AM91.4    AM91.5    AM93.1
AM95.1    AM95.4    AM95.5    AM95.6    AM96.1    AM98.1
AM99.1    AMAS.1    AMBK.1    RQIA.1

UPDATED BY

AM00.1    AM00.2    AM88.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AMB-BOOK               Alpha 10                                  AM00.1  AM00.2
Element: Book          A user-defined book name. Books are       AM88.2
                       used by assets for calculating
                       depreciation, replacement cost, and
                       insurance values, and for reporting.

AMB-DESCRIPTION        Alpha 30  (Lower Case)                    AM00.1  AM00.2
Element: Book DescriptiThe description of the book.              AM88.2

AMB-BOOK-STATUS        Alpha 1                                   AM00.1  AM00.2
Element: Book Status   This field identifies the book status.    AM88.2
                       Valid values are:

                       A = Active.
                       I = Inactive.

AMB-CONVENTION         Alpha 2                                   AM00.1  AM00.2
Element: Convention    The depreciation convention assigned to   AM88.2
                       the book. This value is used to
                       determine the first and last years'
                       depreciation amounts to take. Valid
                       values are:

                       FM = Full Month. The asset receives a
                       full month of depreciation during the
                       month it is placed in service. The asset
                       does not receive any depreciation for
                       the month in which it is disposed of.

                       HM = Modified Half Month. If the asset
                       is placed in service during the first
                       half of the month, it receives one full
                       month of depreciation for its first
                       month, and receives no depreciation for
                       the month it is disposed of. If the
                       asset is placed in service during the
                       last half of the month, depreciation
                       calculations begin the following month,
                       and receives a full month of
                       depreciation the month it is disposed
                       of.

                       MM = Mid Month. The asset receives
                       one-half of one month's depreciation for
                       the month it is placed in service and
                       for the month it is disposed of.

                       NM = Next Month. The asset receives a
                       full month of depreciation the month
                       after it is placed in service and the
                       month it is disposed of.

                       HY = Half Year. The asset receives
                       one-half of a year's depreciation for
                       the first and last year it is in
                       service.

                       MY = Modified Half Year. If the asset
                       is placed in service before the midpoint
                       of the year, it receives a full year's
                       depreciation during its first year in
                       service and no depreciation the year it
                       is disposed of. If the asset is place in
                       service after the midpoint of the year,
                       depreciation calculations begin the
                       following year, and the asset receives a
                       full year's depreciation the year it is
                       disposed of.

                       FY = Full Year. The asset receives a
                       full year's depreciation the year it is
                       placed in service and no depreciation
                       the year it is disposed of.

                       AD = Actual Days. The asset receives
                       depreciation for each day it is in
                       service.

                       MQ = Mid Quarter. The asset receives
                       one-half of one quarter's depreciation
                       for the quarter it is placed in service
                       and for the quarter it is disposed of.

AMB-METHOD-SWITCH      Alpha 1                                   AM00.1  AM00.2
Element: Method Switch This field indicates whether to switch    AM88.2
                       to a second depreciation method when it
                       is advantageous to do so.
                       N = No
                       Y = Yes

AMB-CURRENCY-CODE      Alpha 5                                   AM00.1  AM00.2
Element: Currency Code The currency code assigned to the book.   AM88.2

AMB-TRAN-ND            Numeric 1                                 AM00.1  AM00.2
Transaction Number     The number of decimal positions defined   AM88.2
of Decimals            for the book currency code.

AMB-TRANS-HISTORY      Alpha 1                                   AM00.1  AM00.2
Element: Depreciation HThis field specifies whether Asset        AM88.2
                       Management will track transaction
                       history for the book.  Valid values are:

                       Y = Yes
                       N = No

AMB-DEPR-TYPE-FLAG     Alpha 1                                   AM00.1  AM00.2
Element: Depr Type FlagThis field contains the depreciation      AM88.2
                       type of the assets associated with the
                       book.

                       Valid values are:

                       A = Asset
                       C = Class

AMB-COMPUTE-NAME       Alpha 12                                  AM00.1  AM00.2
Element: Name User                                               AM88.2

AMB-OBJ-ID             Numeric 12                                AM00.1  AM00.2
Object                 This is the object identifier. It is      AM88.2
Identification         used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

                         AMBOOK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMBSET1   BOOK                                                   AM00.1  AM00.2
                                                                 AM01.1  AM01.2
                                                                 AM01.3  AM04.1
                                                                 AM06.4  AM06.5
                                                                 AM10.1  AM115
                                                                 AM12.1  AM120
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM185   AM190
                                                                 AM192   AM195
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 ...

                         AMBOOK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambooktype     AMBOOKTYPE

                            AMB-BOOK    -> ADR-BOOK
                                           ADR-ASSET-TYPE
                                           ADR-SUB-TYPE

Amcalendar     AMCALENDAR

                            AMB-BOOK    -> AMC-BOOK
                                           AMC-COMPANY
                                           AMC-YR-END-DATE

Amclassdep     AMCLASSDEP

                            AMB-BOOK    -> CLD-BOOK
                                           CLD-ASSET-TYPE
                                           CLD-SUB-TYPE
                                           CLD-COMPANY
                                           CLD-AST-ACCT-UNIT
                                           CLD-EXP-ACCT-UNIT
                                           CLD-ACM-ACCT-UNIT
                                           CLD-YR-END-DATE
                                           CLD-PERIOD