AMRECALC – No description in the Lawson data dictionary

System
Asset Management (AM)
Prefix
AMR
Primary key
COMPANY, ASSET, BOOK, CREATION-DATE, CREATION-TIME
Fields
27
Updated by
1 program
Referenced by
1 program

AMRECALC is a Lawson Asset Management table (prefix AMR); no description in the lawson data dictionary. It is indexed by COMPANY, ASSET, BOOK, CREATION-DATE, CREATION-TIME (AMRSET1). It is updated by AM580 and referenced by AM258. The table has 27 fields, 1 index and 0 documented relations.

About AMRECALC

No description in the Lawson data dictionary.

Fields (27)

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

Field / columnTypeDescription & valuesUpdated by
AMR-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AM580
AMR-ASSET PK
ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM580
AMR-BOOK PK
BOOK		Alpha 10A user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AM580
AMR-CREATION-DATE PK
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.AM580
AMR-CREATION-TIME PK
CREATION_TIME		Numeric 6 (hhmmss)The creation time.AM580
AMR-DEPR-YTD-FL
DEPR_YTD_FL		Alpha 1—
  • Y Yes
  • N No
AM580
AMR-FR-DEPR-YTD
FR_DEPR_YTD		Signed 18.2—AM580
AMR-TO-DEPR-YTD
TO_DEPR_YTD		Signed 18.2—AM580
AMR-FR-YTD-ALLOW
FR_YTD_ALLOW		Signed 18.2—AM580
AMR-TO-YTD-ALLOW
TO_YTD_ALLOW		Signed 18.2—AM580
AMR-DEPR-LTD-FL
DEPR_LTD_FL		Alpha 1—
  • Y Yes
  • N No
AM580
AMR-FR-DEPR-LTD
FR_DEPR_LTD		Signed 18.2—AM580
AMR-TO-DEPR-LTD
TO_DEPR_LTD		Signed 18.2—AM580
AMR-FR-LTD-ALLOW
FR_LTD_ALLOW		Signed 18.2—AM580
AMR-TO-LTD-ALLOW
TO_LTD_ALLOW		Signed 18.2—AM580
AMR-LIFE-REM-FL
LIFE_REM_FL		Alpha 1—
  • Y Yes
  • N No
AM580
AMR-FR-LIFE-REM
FR_LIFE_REM		Signed 7.3—AM580
AMR-TO-LIFE-REM
TO_LIFE_REM		Signed 7.3—AM580
AMR-METH-TBL-YR-FL
METH_TBL_YR_FL		Alpha 1—
  • Y Yes
  • N No
AM580
AMR-FR-METH-TBL-YR
FR_METH_TBL_YR		Numeric 2—AM580
AMR-TO-METH-TBL-YR
TO_METH_TBL_YR		Numeric 2—AM580
AMR-DEPR-STDT-FL
DEPR_STDT_FL		Alpha 1—
  • Y Yes
  • N No
AM580
AMR-FR-DEPR-STDT
FR_DEPR_STDT		Numeric 8 (yyyymmdd)—AM580
AMR-TO-DEPR-STDT
TO_DEPR_STDT		Numeric 8 (yyyymmdd)—AM580
AMR-FR-FIRST-LAST
FR_FIRST_LAST		Alpha 1This field is an internal, system-maintained value used to control depreciation calculations during the first and last years of an asset's life. Valid values are: year for the asset. than the first or last. year for the asset. longer participates in depreciation calculations. to depreciate the asset beyond the original asset life.
  • F First. This is the first in-service
  • M Middle. The asset is in a year other
  • L Last. This is the last in-service
  • C Completely Depreciated. The asset no
  • P Post Recovery. The system continues
AM580
AMR-TO-FIRST-LAST
TO_FIRST_LAST		Alpha 1This field is an internal, system-maintained value used to control depreciation calculations during the first and last years of an asset's life. Valid values are: year for the asset. than the first or last. year for the asset. longer participates in depreciation calculations. to depreciate the asset beyond the original asset life.
  • F First. This is the first in-service
  • M Middle. The asset is in a year other
  • L Last. This is the last in-service
  • C Completely Depreciated. The asset no
  • P Post Recovery. The system continues
AM580
AMR-CREATOR-ID
CREATOR_ID		Alpha 10This field is used to store the login id of the person who entered the record.AM580

Indexes (1)

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

IndexKeysFlagsConditionUsed in
AMRSET1COMPANY, ASSET, BOOK, CREATION-DATE, CREATION-TIMEPrimaryAM258

Programs

Updated by (1)

Referenced by (1)