Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             AMMETHOD FILE

                                 Method

The Method file stores the Lawson-defined and optional user-defined methods
that asset books use to calculate depreciation, replacement cost, and
insurance values. Lawson Software supplies the following standard methods:
straight line; 125, 150, 175, and 200 percent declining balance; and sum of
the years digits. These standard methods cannot be customized. The following
kinds of methods can be user-defined: compute statements, annual percent
tables, and annual and period units of production tables.

Each record in this file should have an associated record defined in one of
the following files: Compute, Percent Table, or Units of Production Periods.


REFERENCED BY

AM04.1    AM115     AM12.1    AM120     AM125     AM145
AM15.1    AM15.2    AM15.3    AM15.4    AM154     AM180
AM185     AM192     AM20.1    AM20.2    AM20.4    AM20.7
AM20.8    AM200     AM21.1    AM21.2    AM21.4    AM21.7
AM21.8    AM255     AM280     AM281     AM285     AM295
AM40.1    AM40.2    AM500     AM551     AM580     AM90.3
AM91.3    AM98.1    AMMD.1

UPDATED BY

AM02.1    AM02.2    AM550

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AMM-METHOD           Alpha 10                                    AM02.1  AM02.2
Method               Methods are used by asset books to          AM550
                     calculate depreciation, replacement
                     cost, and insurance values. Standard
                     depreciation methods are predefined.
                     Additional methods can be user-defined
                     for the following kinds of methods:
                     compute statements, annual percent
                     tables, and annual and period units of
                     production tables. Valid predefined
                     methods are as follows:

                     SL = Straight Line.
                     200DB = 200 percent declining balance.
                     175DB = 175 percent declining balance.
                     150DB = 150 percent declining balance.
                     125DB = 125 percent declining balance.
                     SYD = Sum of the year's digits.


AMM-DESCRIPTION      Alpha 30  (Lower Case)                      AM02.1  AM02.2
Description          The description of the method.              AM200   AM550

AMM-METHOD-TYPE      Alpha 1                                     AM02.1  AM02.2
Method Type          This field identifies the kind of           AM550
                     calculation that the method defines.
                     Valid values are:

                     D = Depreciation. (Includes all
                     predefined methods.)
                     I = Insurance.
                     R = Replacement.



AMM-RECORD-TYPE      Alpha 1                                     AM02.1  AM02.2
Record Type          This field identifies the kind of           AM550
                     method record that is defined. Valid
                     values are:

                     C = Compute Statement. An associated
                     record should be defined in the Compute
                     file.

                     P = Percent Table. An associated record
                     should be defined in the Percent Table
                     file.

                     U = UOP Table. An associated record
                     should be defined in the Units of
                     Production Periods file.





AMM-METH-STATUS      Alpha 1                                     AM02.1  AM02.2
Method Status        This field identifies the status of the     AM550
                     method record. Valid values are:

                     A = Active.
                     I = Inactive.


AMM-OPT-METHOD       Alpha 10                                    AM02.1  AM02.2
Optional Method      The depreciation optimizing method          AM550
                     assigned to the record, if applicable.


AMM-TOTAL-UNITS      Signed 17.0                                 AM02.1  AM02.2
Total Units          For a units of production table method,     AM550
                     this field contains the total estimated
                     units of production.


AMM-CREATION-DATE    Numeric 8  (yyyymmdd)                       AM02.1  AM02.2
Creation Date        The system date the method record was       AM550
                     created.


AMM-CREATION-TIME    Numeric 6  (hhmmss)                         AM02.1  AM02.2
Creation Time        The system time the method record was       AM550
                     created.


AMM-CREATOR-ID       Alpha 10                                    AM02.1  AM02.2
Creator ID           The login identification of the             AM550
                     operator who created the method record.


AMM-OPT-METH-DESC    Derived
Optional Method      The description of the depreciation
Description          optimizing method assigned to the method
                     record, if assigned.


                         AMMETHOD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMMSET1   METHOD                                                 AM02.1  AM02.2
                                                                 AM04.1  AM115
                                                                 AM12.1  AM120
                                                                 AM125   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM180
                                                                 AM185   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.4  AM20.7
                                                                 AM20.8  AM200
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM21.7
                                                                 AM21.8  AM255
                                                                 AM280   AM281
                                                                 ...

AMMSET2   METHOD-TYPE   KeyChange                                AM200
          RECORD-TYPE
          METHOD

AMMSET3   METHOD-TYPE   KeyChange                                AM115   AM15.1
          METHOD                                                 AM15.2  AM15.3
                                                                 AM15.4  AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM500
                                                                 AM551   AM98.1

                         AMMETHOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amcompute      AMCOMPUTE    Not Required, Delete Cascades
                            Valid When AMM-RECORD-TYPE = "C"

                            AMM-METHOD        -> ACP-METHOD

Ammethod       AMMETHOD     Not Required
                            Valid When AMM-OPT-METHOD != Spaces

                            AMM-OPT-METHOD    -> AMM-METHOD

Amtablepct     AMTABLEPCT   Not Required, Delete Cascades
                            Valid When AMM-RECORD-TYPE = "P"

                            AMM-METHOD        -> ATB-METHOD

                         AMMETHOD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amuoppds       AMUOPPDS

                            AMM-METHOD        -> UOP-METHOD
                                                 UOP-METH-TABLE-YR