AMASTBOOK – Asset Book

System
Asset Management (AM)
Prefix
ASB
Primary key
ASSET, BOOK
Fields
70
Updated by
291 programs
Referenced by
40 programs

AMASTBOOK is the Asset Book table in Lawson Asset Management (prefix ASB). It is indexed by ASSET, BOOK (ASBSET1); alternate indexes: ASBSET2, ASBSET3, ASBSET4 and ASBSET5. It is related 1:1 to AMASSET, AMASTBKDSP, AMASTTYPE, AMBOOK, AMCALENDAR, AMDIVISION, AMLOCATION and AMMETHOD and 1:M to AMASTBKADJ, AMASTBKTRF, AMBKHIST, AMBKTRANS, AMCLASSDEP, AMTRANS and AMTYPALLOC. It is updated by AC160, AM115, AM117, AM120, AM125, AM135, AM145, AM15.1 and 283 more and referenced by AM00.1, AM00.2, AM01.1, AM01.2, AM01.3, AM04.1, AM06.4, AM06.5 and 32 more. The table has 70 fields, 5 indexes and 15 documented relations.

About AMASTBOOK

The Asset Book file stores the asset book records used to depreciate assets. Each asset book record describes the depreciation parameters needed to depreciate an asset, based on a specific depreciation book assigned to the asset. Each Asset file record may have one or more related records in the Asset Book file, one for each book assigned to the asset.

Fields (70)

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

Field / columnTypeDescription & valuesUpdated by
ASB-ASSET PK
ASSET
Numeric 10The asset number associated with the asset book record. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-BOOK PK
BOOK
Alpha 10A book name assigned to the asset. Books are user-defined and are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-BOOK-STATUS
BOOK_STATUS
Alpha 1This field identifies the status of the book. Valid values are:
  • A Active
  • I Inactive
AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-LIFE
LIFE
Numeric 4The life value of the asset, expressed in months. Note: The asset life can be different for each depreciation book used.AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-LIFE-REM
LIFE_REM
Signed 7.3The asset life remaining, expressed in months. This value represents the number of months the Asset Management system will continue to depreciate the asset.AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-BOOK-BASIS
BOOK_BASIS
Signed 18.2The amount on which the depreciation calculations are based. Note: The depreciation basis amount can be different for each depreciation book used.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-METHOD
METHOD
Alpha 10The method the book uses to calculate depreciation for the asset. 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 values are:
  • 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.
AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-METH-SWITCHED
METH_SWITCHED
Alpha 1This field indicates whether the Asset Management system has switched the depreciation method to the optimizing method. Valid values are:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-INSRV-DATE
INSRV_DATE
Numeric 8 (yyyymmdd)The date the asset was placed in service. Note: The in-service date can be different for each depreciation book used.AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-METH-TABLE-YR
METH_TABLE_YR
Numeric 2The year the asset was placed in service.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-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: Note: See data file text for the Method file for more information on each convention.
  • FM Full Month.
  • HM Modified Half Month.
  • MM Mid Month.
  • NM Next Month.
  • HY Half Year.
  • MY Modified Half Year.
  • FY Full Year.
  • AD Actual Days.
  • MQ Mid Quarter.
AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-STARTDATE
DEPR_STARTDATE
Numeric 8 (yyyymmdd)The date depreciation calculations began or will begin for the asset.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-LIFE-YEARS
LIFE_YEARS
Signed 5.2The total life value of the asset, expressed in years. This value is calculated by dividing the Life value by 12.AC160, AM115, AM117, AM120, AM125, AM135, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-STATUS-CP-CALC
STATUS_CP_CALC
Alpha 1This field indicates whether depreciation has been calculated for the current period.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-LIFE-CP
LIFE_CP
Signed 5.3This is the current period portion of the asset life.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-TRAN-ND
TRAN_ND
Numeric 1The number of decimal positions defined for the transaction currency.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-CP
DEPR_CP
Signed 18.2This is the current period depreciation for this book. This amount includes only the business use, not the personal use, portion of the depreciationAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-CP-ALLOW
DEPR_CP_ALLOW
Signed 18.2This is the current period depreciation allowed for the book. This amount is equivalent to the full depreciation, including business and personal use.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-YTD
DEPR_YTD
Signed 18.2This is the year-to-date depreciation amount for the book. This amount includes only the business use, not the personal use, portion of the depreciation.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-YTD-ALLOW
DEPR_YTD_ALLOW
Signed 18.2This is the year-to-date depreciation allowed for the book. This amount is equivalent to the full depreciation, including business and personal use.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-YTD-OVRRD
DEPR_YTD_OVRRD
Signed 18.2This is the year-to-date depreciation override amount.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-LTD
DEPR_LTD
Signed 18.2This is the life-to-date depreciation amount for the book. This amount includes only the business use, not the personal use, portion of the depreciation.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-DEPR-LTD-ALLOW
DEPR_LTD_ALLOW
Signed 18.2This is the life-to-date depreciation allowed for the book. This amount is equivalent to the full depreciation, including business and personal use.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-LAST-CLOSE
LAST_CLOSE
Signed 18.2This is the balance in the last-closed period for this book.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-FIRST-LAST-FL
FIRST_LAST_FL
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. other than the first or last. year for the asset. no longer participates in depreciation calculations. continue 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
  • L Last. This is the last in-service
  • C Completely Depreciated. The asset
  • P Post Recovery. The system will
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-INACT-YTD
INACT_YTD
Signed 5.3This is the number of inactive months for the book year-to-date.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-INACT-LTD
INACT_LTD
Signed 7.3This is the number of inactive months for the book life-to-date.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-SALVAGE-VALUE
SALVAGE_VALUE
Signed 18.2The salvage value of the asset at the end of the asset's life. It can be zero. If the depreciation method is STL (Straight Line), the basis used for the depreciation calculation is the asset cost less this salvage value. If the depreciation method is DDB (Double Declining Balance), 150 (150% Declining Balance), or 175 (175% Declining Balance), the basis used for the depreciation calculation is the asset cost. Depreciation will be taken until the total amount taken is equal to the asset cost less this salvage value.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-BUS-PERCENT
BUS_PERCENT
Signed 5.2The business percent usage of the asset. If this value is less than 100 percent, the value is used in depreciation calculations.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-PERSONAL-USE
PERSONAL_USE
Alpha 10The personal use code assigned to the asset. A 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.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-YR1-EXP
YR1_EXP
Signed 18.2This is the new first year expense amount. It represents the amount to expense for the First Year Expense option. This U.S. tax option allows you to expense and not depreciate a total dollar amount for the assets of each eligible company.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-TC-TABLE
TC_TABLE
Alpha 10A user-defined tax credit table, which defines tax credit percentages and annual tax credit recapture percentages for up to twenty years. Asset books use tax credit tables to calculate tax credits.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-TC-PROPERTY
TC_PROPERTY
Signed 18.2If you are taking a tax credit for used property, this field contains the amount that qualifies for the credit.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-TAX-CREDIT
TAX_CREDIT
Signed 18.2This is the amount of tax credit taken for this asset.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-INS-METHOD
INS_METHOD
Alpha 10The method used to calculate insurance values for the asset.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-INS-ACT-VAL
INS_ACT_VAL
Signed 18.2The actual insurance value of the asset.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-INS-CMPTD-VAL
INS_CMPTD_VAL
Signed 18.2The calculated insurance value for the asset.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-RPL-METHOD
RPL_METHOD
Alpha 10The method used to calculate replacement values for the asset.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-RPL-CMPTD-VAL
RPL_CMPTD_VAL
Signed 18.2The calculated replacement value for the asset.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ASB-CREATION-DATE
CREATION_DATE
Numeric 8 (yyyymmdd)The date the asset book record was created.AC160, AM115, AM117, AM125, AM145, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-CREATION-TIME
CREATION_TIME
Numeric 6 (hhmmss)The time the asset book record was created.AC160, AM115, AM117, AM125, AM145, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-CREATOR-ID
CREATOR_ID
Alpha 10This field identifies the operator who created the asset book record.AC160, AM115, AM117, AM125, AM145, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASB-BOOK-DESC
BOOK_DESC
DerivedThe book description.
ASB-BOOK-VALUE
BOOK_VALUE
DerivedThe book value is calculated as follows: Book Basis - Life-to-date Depreciation.
ASB-SALVAGE-PCT
SALVAGE_PCT
DerivedSalvage percentage is calculated as follows: Salvage Value / Book Basis.
ASB-BK-YR-END-DATE
BK_YR_END_DATE
DerivedThe last date of the fiscal year.
ASB-BK-YR-BEG-DATE
BK_YR_BEG_DATE
DerivedThe first date of the fiscal year.
ASB-BK-PD-PER-YR
BK_PD_PER_YR
DerivedThe number of periods defined for the fiscal year.
ASB-BK-DEPR-PD-CLS
BK_DEPR_PD_CLS
DerivedThis field identifies the number of depreciation periods that are closed in the fiscal year.
ASB-BK-PD-CLOSE-DT
BK_PD_CLOSE_DT
DerivedThe last date of the current period.
ASB-BK-PD-CURR-DT
BK_PD_CURR_DT
DerivedThis field identifies the closing date of the current period.
ASB-BK-REQ
BK_REQ
DerivedThis field indicates whether the book is a required book to be used by all new assets being added.
ASB-BK-POSTING
BK_POSTING
DerivedThis field identifies whether the book is a posting book that posts journal entries to the general ledger.
ASB-BK-BOOK-STATUS
BK_BOOK_STATUS
DerivedThe status of the book.
ASB-BK-CURRENCY-CD
BK_CURRENCY_CD
DerivedThe currency code assigned to the book.
ASB-BK-METH-SWITCH
BK_METH_SWITCH
DerivedThis field identifies whether the depreciation method can be switched for the book.
ASB-BK-DEPR-TYPE
BK_DEPR_TYPE
DerivedThis field allows for a drill-around to AMBOOK to diplay the values in the DEPR-TYPE-FLAG (Asset or Class).
ASB-BK-HISTORY
BK_HISTORY
Derived
ASB-TAG
TAG
DerivedThe tag number assigned to the asset.
ASB-ASSET-GRP
ASSET_GRP
DerivedThe asset group assigned to the asset.
ASB-DEPR-YTD-OVER
DEPR_YTD_OVER
DerivedThe word "OVERRIDE" displays if there is a year-to-date depreciation override amount.
ASB-AST-DESC
AST_DESC
DerivedThis is the asset description.
ASB-AST-STATUS
AST_STATUS
DerivedThis is the asset status.
ASB-AST-LOCATION
AST_LOCATION
Derived
ASB-AST-DIVISION
AST_DIVISION
Derived
ASB-AST-TYPE
AST_TYPE
Derived
ASB-AST-SUBTYPE
AST_SUBTYPE
Derived
ASB-DSP-YTD
DSP_YTD
Signed 5.3This is the number of months that the asset has been disposed in the current year. This field gets cleared when the year rolls over.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASB-RVL-LTD
RVL_LTD
Signed 18.2AM155
ASB-RVL-DATE
RVL_DATE
Numeric 8 (yyyymmdd)AM155

Indexes (5)

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

IndexKeysFlagsConditionUsed in
ASBSET1ASSET, BOOKPrimaryAC160, AM115, AM117, AM120, AM125, AM135, AM145, AM15.1 +22 more (list truncated in source)
ASBSET2BOOK, ASSETAM00.1, AM00.2, AM01.1, AM01.2, AM01.3, AM04.1, AM06.4, AM06.5 +22 more (list truncated in source)
ASBSET3CONVENTION, ASSET, BOOKKeyChangeAMCV.1
ASBSET4METHOD, ASSET, BOOKKeyChangeAMMD.1
ASBSET5LIFE, ASSET, BOOKKeyChangeAMLF.1

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot RequiredASB-ASSETAST-ASSET
AmastbkdspAMASTBKDSPNot RequiredASB-ASSETABD-ASSET, ASB-BOOKABD-BOOK
AmasttypeAMASTTYPENot RequiredAST-COMPANYATP-COMPANY, AST-ASSET-TYPEATP-ASSET-TYPE, AST-SUB-TYPEATP-SUB-TYPE
AmbookAMBOOKRequiredASB-BOOKAMB-BOOK
AmcalendarAMCALENDARNot RequiredASB-BOOKAMC-BOOK, AST-COMPANYAMC-COMPANY
AmdivisionAMDIVISIONNot RequiredAST-DIVISIONDIV-DIVISION
AmlocationAMLOCATIONNot RequiredAST-LOCATION-NAMELOC-LOCATION-NAME
AmmethodAMMETHODRequiredASB-METHODAMM-METHOD

One to many (7) — child tables

RelationTableRulesConditionField map
AmastbkadjAMASTBKADJASB-ASSETABA-ASSET, ASB-BOOKABA-BOOK, ABA-PROCESS-SEQ
AmastbktrfAMASTBKTRFASB-ASSETABT-ASSET, ASB-BOOKABT-BOOK, ABT-PROCESS-SEQ
AmbkhistAMBKHISTASB-ASSETABH-ASSET, ASB-BOOKABH-BOOK, ABH-COMPANY, ABH-YR-END-DATE
AmbktransAMBKTRANSASB-ASSETABK-ASSET, ASB-BOOKABK-BOOK, AMC-COMPANYABK-COMPANY, ABK-TRANS-STATUS, ABK-SEQ-NUMBER
AmclassdepAMCLASSDEPAST-COMPANYCLD-COMPANY, ASB-BOOKCLD-BOOK, AST-ASSET-TYPECLD-ASSET-TYPE, AST-SUB-TYPECLD-SUB-TYPE, CLD-AST-ACCT-UNIT, CLD-EXP-ACCT-UNIT, CLD-ACM-ACCT-UNIT, CLD-YR-END-DATE, CLD-PERIOD
AmtransAMTRANSASB-ASSETAMT-ASSET, "R"AMT-TRANS-STATUS, AMC-COMPANYAMT-COMPANY, ASB-BOOKAMT-BOOK, AMT-SEQ-NUMBER
AmtypallocAMTYPALLOCAST-COMPANYALL-COMPANY, AST-ASSET-TYPEALL-ASSET-TYPE, AST-SUB-TYPEALL-SUB-TYPE, ALL-START-DATE, ALL-SEQUENCE-NBR

Programs

Updated by (291)

Referenced by (40)