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