|
|
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
|
