AMMETHOD – Asset Method

System
Asset Management (AM)
Prefix
AMM
Primary key
METHOD
Fields
13
Updated by
3 programs
Referenced by
282 programs

AMMETHOD is the Asset Method table in Lawson Asset Management (prefix AMM). It is indexed by METHOD (AMMSET1); alternate indexes: AMMSET2 and AMMSET3. It is related 1:1 to AMCOMPUTE, AMMETHOD and AMTABLEPCT and 1:M to AMUOPPDS. It is updated by AM02.1, AM02.2 and AM550 and referenced by AC160, AM04.1, AM115, AM117, AM12.1, AM12.2, AM120, AM125 and 274 more. The table has 13 fields, 3 indexes and 4 documented relations.

About AMMETHOD

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.

Fields (13)

Column = COBOL field name without the AMM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AMM-METHOD PK
METHOD		Alpha 10Methods are used by asset books to 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.
AM02.1, AM02.2, AM550
AMM-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the method.AM02.1, AM02.2, AM200, AM550
AMM-METHOD-TYPE
METHOD_TYPE		Alpha 1This field identifies the kind of calculation that the method defines. Valid values are: predefined methods.)
  • D Depreciation. (Includes all
  • I Insurance.
  • R Replacement.
AM02.1, AM02.2, AM550
AMM-RECORD-TYPE
RECORD_TYPE		Alpha 1This field identifies the kind of method record that is defined. Valid values are: record should be defined in the Compute file. should be defined in the Percent Table file. should be defined in the Units of Production Periods file.
  • C Compute Statement. An associated
  • P Percent Table. An associated record
  • U UOP Table. An associated record
AM02.1, AM02.2, AM550
AMM-CATEGORY-TYPE
CATEGORY_TYPE		Alpha 1This Field is used to indicate whether the method is a Lawson defined or user defined depreciation, insurance, or replacement method.
  • L Lawson
  • U User
AM02.1, AM02.2, AM550
AMM-METH-STATUS
METH_STATUS		Alpha 1This field identifies the status of the method record. Valid values are:
  • A Active.
  • I Inactive.
AM02.1, AM02.2, AM550
AMM-OPT-METHOD
OPT_METHOD		Alpha 10The depreciation optimizing method assigned to the record, if applicable.AM02.1, AM02.2, AM550
AMM-TOTAL-UNITS
TOTAL_UNITS		Signed 17.0For a units of production table method, this field contains the total estimated units of production.AM02.1, AM02.2, AM550
AMM-SL-CALCULATION
SL_CALCULATION		Alpha 1This field indicates the method of straight line depreciation to use when the method switch is SL (straight line). comparison and calculation using remaining asset values. calculation using original assets values. orig asset values, calculation based on remaining asset values
  • Blank Default, SL method switch
  • O SL method switch comparison and
  • M SL method switch comparison using
  • D Default
  • N Not applicable
AM02.1, AM02.2, AM550
AMM-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)The system date the method record was created.AM02.1, AM02.2, AM550
AMM-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The system time the method record was created.AM02.1, AM02.2, AM550
AMM-CREATOR-ID
CREATOR_ID		Alpha 10The login identification of the operator who created the method record.AM02.1, AM02.2, AM550
AMM-OPT-METH-DESC
OPT_METH_DESC		DerivedThe description of the depreciation optimizing method assigned to the method record, if assigned.—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AMMSET1METHODPrimaryAC160, AM02.1, AM02.2, AM04.1, AM115, AM117, AM12.1, AM12.2 +22 more (list truncated in source)
AMMSET2METHOD-TYPE, RECORD-TYPE, METHODKeyChangeAM200
AMMSET3METHOD-TYPE, METHODKeyChangeAC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AmcomputeAMCOMPUTENot Required, Delete CascadesValid When AMM-RECORD-TYPE = "C"AMM-METHOD → ACP-METHOD
AmmethodAMMETHODNot RequiredValid When AMM-OPT-METHOD != SpacesAMM-OPT-METHOD → AMM-METHOD
AmtablepctAMTABLEPCTNot Required, Delete CascadesValid When AMM-RECORD-TYPE = "P"AMM-METHOD → ATB-METHOD

One to many (1) — child tables

RelationTableRulesConditionField map
AmuoppdsAMUOPPDSAMM-METHOD → UOP-METHOD, → UOP-METH-TABLE-YR

Programs

Updated by (3)

Referenced by (282)