AMPUCODE – Asset Personal Use Code

System
Asset Management (AM)
Prefix
APU
Primary key
BOOK, PERSONAL-USE
Fields
16
Updated by
2 programs
Referenced by
273 programs

AMPUCODE is the Asset Personal Use Code table in Lawson Asset Management (prefix APU). It is indexed by BOOK, PERSONAL-USE (APUSET1). It is related 1:1 to AMBOOK and AMMETHOD. It is updated by AM04.1 and AM520 and referenced by AC160, AM115, AM117, AM12.1, AM12.2, AM125, AM145, AM15.1 and 265 more. The table has 16 fields, 1 index and 2 documented relations.

About AMPUCODE

The Personal Use Code file stores personal use codes, which asset books use to calculate depreciation. These records describe depreciation and tax credit calculation options, and annual depreciation limits up to twenty years. Note: The Asset Management system does not provide a method to delete records from this file.

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
APU-BOOK PK
BOOK		Alpha 10The book associated with the personal use code. A book is used by assets to calculate depreciation, replacement cost, and insurance values. Books are also used for reporting. The book name is user definable.AM04.1, AM520
APU-PERSONAL-USE PK
PERSONAL_USE		Alpha 10A personal use code defines the personal use options that asset books use to calculate depreciation, tax credits, and annual depreciation limits up to twenty years. The code is user-definable.AM04.1, AM520
APU-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The personal use code description.AM04.1, AM520
APU-QUAL-BUS-PCT
QUAL_BUS_PCT		Signed 5.2—AM04.1, AM520
APU-DEPR-RCP-OPT
DEPR_RCP_OPT		Alpha 1This field is a flag for the system to recapture depreciation if the business use percentage drops below the qualifying percentage. Valid values are:
  • Y Yes.
  • N No.
AM04.1, AM520
APU-DEPR-METH-OPT
DEPR_METH_OPT		Alpha 1This field is a system flag for the system to change the depreciation method if the business use drops below the qualifying percent. Valid values are:
  • Y Yes.
  • N No.
AM04.1, AM520
APU-DEPR-LMT-OPT
DEPR_LMT_OPT		Alpha 1This field is a system flag to indicate whether depreciation limits are defined for the personal use code. Valid values are:
  • Y Yes.
  • N No.
AM04.1, AM520
APU-OPT-DEPR-METH
OPT_DEPR_METH		Alpha 10The optional depreciation method to be used when the system changes from the primary method.AM04.1, AM520
APU-OPT-DEPR-LIFE
OPT_DEPR_LIFE		Numeric 4The optional asset life, in months, to be used if the depreciation method is switched.AM04.1, AM520
APU-TC-RECAP-OPT1
TC_RECAP_OPT1		Alpha 1This field is a system flag that indicates whether to use option 1 (the qualifying percent field) for tax credit recapture method. Valid values are:
  • N No.
  • Y Yes.
AM04.1, AM520
APU-TC-RECAP-OPT2
TC_RECAP_OPT2		Alpha 1This field is a system flag that indicates whether to use option 2 (the optional qualifying percent) for tax credit recapture method. Valid values are:
  • N No.
  • Y Yes.
AM04.1, AM520
APU-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AM04.1, AM520
APU-TC-LIMIT-OPT1
TC_LIMIT_OPT1		Signed 18.2The tax credit limit amount for the tax credit recapture option 1 method.AM04.1, AM520
APU-TC-LIMIT-OPT2
TC_LIMIT_OPT2		Signed 18.2The tax credit limit amount for the tax credit recapture option 2 method.AM04.1, AM520
APU-PST-RCVRY-DED
PST_RCVRY_DED		Alpha 1This field is a system flag that indicates whether to depreciate any remaining book value of an asset if it has not been fully depreciated over its asset life. Valid values are: deductions.
  • Y Yes. Allow post-recovery deductions.
  • N No. Do not allow post-recovery
AM04.1, AM520
APU-DEPR-LIMIT
DEPR_LIMIT		Signed 18.2 Occurs 20 Times ×20—AM04.1, AM520

Indexes (1)

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

IndexKeysFlagsConditionUsed in
APUSET1BOOK, PERSONAL-USEPrimaryAC160, AM04.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmbookAMBOOKRequiredAPU-BOOK → AMB-BOOK
AmmethodAMMETHODNot RequiredAPU-OPT-DEPR-METH → AMM-METHOD

Programs

Updated by (2)

Referenced by (273)