Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMMETHOD


                             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     AM117     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     AM502     AM520
AM551     AM580     AM90.3    AM91.3    AM92.1    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
Element: 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
Element: Description   The description of the method.            AM200   AM550

AMM-METHOD-TYPE        Alpha 1                                   AM02.1  AM02.2
Element: 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
Element: 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-CATEGORY-TYPE      Alpha 1                                   AM02.1  AM02.2
Element: Category Type This Field is used to indicate whether    AM550
                       the method is a Lawson defined or user
                       defined depreciation, insurance, or
                       replacement method.
                       L = Lawson
                       U = User

AMM-METH-STATUS        Alpha 1                                   AM02.1  AM02.2
Element: 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
Element: Optional MethoThe depreciation optimizing method        AM550
                       assigned to the record, if applicable.


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


AMM-SL-CALCULATION     Alpha 1                                   AM02.1  AM02.2
Element: All Flag      This field indicates the method of        AM550
                       straight line depreciation to use when
                       the method switch is SL (straight line).
                       Blank = Default, SL method switch
                       comparison and calculation using
                       remaining  asset values.
                       O = SL method switch comparison and
                       calculation using  original assets
                       values.
                       M = SL method switch comparison using
                       orig asset values, calculation based on
                       remaining asset values
                       D = Default
                       N = Not applicable

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


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


AMM-CREATOR-ID         Alpha 10                                  AM02.1  AM02.2
Element: 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
                                                                 AM117   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
                                                                 ...

AMMSET2   METHOD-TYPE   KeyChange                                AM200
          RECORD-TYPE
          METHOD

AMMSET3   METHOD-TYPE   KeyChange                                AM115   AM117
          METHOD                                                 AM125   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM500
                                                                 AM502   AM551
                                                                 AM92.1  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