Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              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    AM10.1    AM115
AM12.1    AM120     AM125     AM135     AM145     AM15.1
AM15.2    AM15.3    AM15.4    AM170     AM180     AM185
AM190     AM192     AM195     AM20.1    AM20.2    AM20.3
AM20.4    AM20.5    AM20.6    AM20.7    AM20.8    AM200
AM205     AM210     AM212     AM220     AM222     AM225
AM230     AM240     AM255     AM260     AM265     AM270
AM275     AM277     AM280     AM285     AM290     AM292
AM295     AM30.1    AM30.2    AM30.3    AM310     AM40.1
AM40.2    AM40.3    AM40.4    AM500     AM520     AM580
AM60.1    AM75.1    AM80.1    AM85.1    AM90.1    AM95.1
AM96.1    AM98.1    AM99.1

UPDATED BY

AM00.1    AM00.2    AM953

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


AMB-DESCRIPTION      Alpha 30  (Lower Case)                      AM00.1  AM00.2
Book Description     The description of the book.                AM953

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

                     A = Active.
                     I = Inactive.


AMB-CONVENTION       Alpha 2                                     AM00.1  AM00.2
Convention           The depreciation convention assigned to     AM953
                     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
Method Switch        This field indicates whether to switch      AM953
                     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
Currency Code        The currency code assigned to the book.     AM953

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


                         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
                                                                 AM10.1  AM115
                                                                 AM12.1  AM120
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM185
                                                                 AM190   AM192
                                                                 AM195   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM20.7
                                                                 ...

                         AMBOOK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amcalendar     AMCALENDAR

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