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

AC160     AM04.1    AM115     AM117     AM12.1    AM120
AM125     AM145     AM15.1    AM15.2    AM15.3    AM15.4
AM154     AM180     AM185     AM19.1    AM19.2    AM192
AM20.1    AM20.2    AM20.4    AM20.7    AM20.8    AM200
AM21.1    AM21.2    AM21.4    AM21.7    AM21.8    AM255
AM258     AM280     AM281     AM285     AM295     AM40.1
AM40.2    AM500     AM502     AM520     AM551     AM580
AM90.3    AM91.3    AM92.1    AM98.1    AMMD.1    AP115
AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP220     AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP305     API1.1    API2.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    MA180     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    WH20.2    WH20.7

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                                                 AC160   AM02.1
                                                                 AM02.2  AM04.1
                                                                 AM115   AM117
                                                                 AM12.1  AM120
                                                                 AM125   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM180
                                                                 AM185   AM19.1
                                                                 AM19.2  AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.4  AM20.7
                                                                 AM20.8  AM200
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM21.7
                                                                 ...

AMMSET2   METHOD-TYPE   KeyChange                                AM200
          RECORD-TYPE
          METHOD

AMMSET3   METHOD-TYPE   KeyChange                                AC160   AM115
          METHOD                                                 AM117   AM125
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM19.1  AM19.2
                                                                 AM20.1  AM20.2
                                                                 AM20.4  AM21.1
                                                                 AM21.2  AM21.4
                                                                 AM500   AM502
                                                                 AM551   AM92.1
                                                                 AM98.1  AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 ...

                         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