AMBOOK – Asset Book Name

System
Asset Management (AM)
Prefix
AMB
Primary key
BOOK
Fields
11
Updated by
3 programs
Referenced by
353 programs

AMBOOK is the Asset Book Name table in Lawson Asset Management (prefix AMB). It is indexed by BOOK (AMBSET1). It is related 1:M to AMBOOKTYPE, AMCALENDAR and AMCLASSDEP. It is updated by AM00.1, AM00.2 and AM88.2 and referenced by AC160, AM01.1, AM01.2, AM01.3, AM04.1, AM06.4, AM06.5, AM10.1 and 345 more. The table has 11 fields, 1 index and 3 documented relations.

About AMBOOK

The Book file stores the books that asset uses for calculating depreciation, replacement cost, and insurance values, and for reporting.

Fields (11)

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

Field / columnTypeDescription & valuesUpdated by
AMB-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.AM00.1, AM00.2, AM88.2
AMB-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the book.AM00.1, AM00.2, AM88.2
AMB-BOOK-STATUS
BOOK_STATUS		Alpha 1This field identifies the book status. Valid values are:
  • A Active.
  • I Inactive.
AM00.1, AM00.2, AM88.2
AMB-CONVENTION
CONVENTION		Alpha 2The depreciation convention assigned to the book. This value is used to determine the first and last years' depreciation amounts to take. Valid values are: full month of depreciation during the month it is placed in service. The asset does not receive any depreciation for the month in which it is disposed of. is placed in service during the first half of the month, it receives one full month of depreciation for its first month, and receives no depreciation for the month it is disposed of. If the asset is placed in service during the last half of the month, depreciation calculations begin the following month, and receives a full month of depreciation the month it is disposed of. one-half of one month's depreciation for the month it is placed in service and for the month it is disposed of. full month of depreciation the month after it is placed in service and the month it is disposed of. one-half of a year's depreciation for the first and last year it is in service. is placed in service before the midpoint of the year, it receives a full year's depreciation during its first year in service and no depreciation the year it is disposed of. If the asset is place in service after the midpoint of the year, depreciation calculations begin the following year, and the asset receives a full year's depreciation the year it is disposed of. full year's depreciation the year it is placed in service and no depreciation the year it is disposed of. depreciation for each day it is in service. one-half of one quarter's depreciation for the quarter it is placed in service and for the quarter it is disposed of.
  • FM Full Month. The asset receives a
  • HM Modified Half Month. If the asset
  • MM Mid Month. The asset receives
  • NM Next Month. The asset receives a
  • HY Half Year. The asset receives
  • MY Modified Half Year. If the asset
  • FY Full Year. The asset receives a
  • AD Actual Days. The asset receives
  • MQ Mid Quarter. The asset receives
AM00.1, AM00.2, AM88.2
AMB-METHOD-SWITCH
METHOD_SWITCH		Alpha 1This field indicates whether to switch to a second depreciation method when it is advantageous to do so.
  • N No
  • Y Yes
AM00.1, AM00.2, AM88.2
AMB-CURRENCY-CODE
CURRENCY_CODE		Alpha 5The currency code assigned to the book.AM00.1, AM00.2, AM88.2
AMB-TRAN-ND
TRAN_ND		Numeric 1The number of decimal positions defined for the book currency code.AM00.1, AM00.2, AM88.2
AMB-TRANS-HISTORY
TRANS_HISTORY		Alpha 1This field specifies whether Asset Management will track transaction history for the book. Valid values are:
  • Y Yes
  • N No
AM00.1, AM00.2, AM88.2
AMB-DEPR-TYPE-FLAG
DEPR_TYPE_FLAG		Alpha 1This field contains the depreciation type of the assets associated with the book. Valid values are:
  • A Asset
  • C Class
AM00.1, AM00.2, AM88.2
AMB-COMPUTE-NAME
COMPUTE_NAME		Alpha 12The name assigned to an arithmetic equation created in Compute Statement (RW50.1). A compute statement consists of data dictionary items and operation symbols.AM00.1, AM00.2, AM88.2
AMB-OBJ-ID
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AM00.1, AM00.2, AM88.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
AMBSET1BOOKPrimaryAC160, AM00.1, AM00.2, AM01.1, AM01.2, AM01.3, AM04.1, AM06.4 +22 more (list truncated in source)

Relations

One to many (3) — child tables

RelationTableRulesConditionField map
AmbooktypeAMBOOKTYPEAMB-BOOK → ADR-BOOK, → ADR-ASSET-TYPE, → ADR-SUB-TYPE
AmcalendarAMCALENDARAMB-BOOK → AMC-BOOK, → AMC-COMPANY, → AMC-YR-END-DATE
AmclassdepAMCLASSDEPAMB-BOOK → CLD-BOOK, → CLD-ASSET-TYPE, → CLD-SUB-TYPE, → CLD-COMPANY, → CLD-AST-ACCT-UNIT, → CLD-EXP-ACCT-UNIT, → CLD-ACM-ACCT-UNIT, → CLD-YR-END-DATE, → CLD-PERIOD

Programs

Updated by (3)

Referenced by (353)