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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2 SET3
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 SET2
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AMMSET1
  1. METHOD
PrimaryAC160, AM02.1, AM02.2, AM04.1, AM115, AM117, AM12.1, AM12.2 +22 more (list truncated in source)
AMMSET2
  1. METHOD-TYPE
  2. RECORD-TYPE
  3. METHOD
KeyChangeAM200
AMMSET3
  1. METHOD-TYPE
  2. METHOD
KeyChangeAC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AMCOMPUTEAMMETHODAMTABLEPCTAMUOPPDSAMMETHOD

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 != Spaces
AMM-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
AmuoppdsAMUOPPDS
AMM-METHOD→UOP-METHOD
—→UOP-METH-TABLE-YR

Programs

Updated by (3)

Referenced by (282)