|
|
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 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 AM520 AM551 AM580
AM90.3 AM91.3 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-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-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
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
...
AMMSET2 METHOD-TYPE KeyChange AM200
RECORD-TYPE
METHOD
AMMSET3 METHOD-TYPE KeyChange AM115 AM125
METHOD AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM551
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
|
