Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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    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     AM220     AM222     AM225     AM230
AM240     AM241     AM255     AM260     AM265     AM266
AM270     AM275     AM277     AM278     AM280     AM281
AM282     AM285     AM290     AM292     AM295     AM30.1
AM30.2    AM30.3    AM310     AM320     AM40.1    AM40.2
AM40.3    AM40.4    AM41.1    AM41.2    AM500     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

UPDATED BY

AM00.1    AM00.2    AM88.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AMB-BOOK             Alpha 10                                    AM00.1  AM00.2
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
Book Description     The description of the book.                AM88.2

AMB-BOOK-STATUS      Alpha 1                                     AM00.1  AM00.2
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
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
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
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
Transaction History  This 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
Depr Type Flag       This field contains the depreciation        AM115   AM15.1
                     type of the assets associated with the      AM15.2  AM15.3
                     book.                                       AM15.4  AM170
                                                                 AM20.1  AM20.2
                     Valid values are:                           AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                     A = Asset                                   AM21.1  AM21.2
                     C = Class                                   AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM88.2  AM96.1
                                                                 AM98.1

AMB-COMPUTE-NAME     Alpha 12                                    AM00.1  AM00.2
Compute Statement    The name assigned to an arithmetic          AM88.2
Name                 equation created in Compute Statement
                     (RW50.1).  A compute statement consists
                     of data dictionary items and operation
                     symbols.

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