AMASTBKTRF – Asset Book Transfer

System
Asset Management (AM)
Prefix
ABT
Primary key
ASSET, PROCESS-SEQ, BOOK
Fields
90
Updated by
270 programs
Referenced by
15 programs

AMASTBKTRF is the Asset Book Transfer table in Lawson Asset Management (prefix ABT). It is indexed by ASSET, PROCESS-SEQ, BOOK (ABTSET1); alternate indexes: ABTSET2 and ABTSET3. It is related 1:1 to AMASSET, AMASSETTRF, AMASTBOOK and AMBOOK. It is updated by AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 and 262 more and referenced by AM145, AM155, AM190, AM192, AM230, AM281, AM40.1, AM40.2 and 7 more. The table has 90 fields, 3 indexes and 5 documented relations.

About AMASTBKTRF

This file contains historical asset book information related to transfers.

Fields (90)

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

Field / columnTypeDescription & valuesUpdated by
ABT-ASSET PK
ASSET
Numeric 10Key field. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM135, AM154, AM30.1, AM30.2
ABT-TO-ASSET
TO_ASSET
Numeric 10This is the to-asset for the transfer.AM135, AM154, AM30.1, AM30.2
ABT-BOOK PK
BOOK
Alpha 10Key field. This is a user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AM135, AM154, AM30.1, AM30.2, AM520
ABT-TO-BOOK
TO_BOOK
Alpha 10Key field. This is a user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AM135, AM154, AM30.1, AM30.2
ABT-PROCESS-SEQ PK
PROCESS_SEQ
Numeric 6Key field. This is the sequence number for the transfer process.AM135, AM154, AM30.1, AM30.2
ABT-BOOK-STATUS
BOOK_STATUS
Alpha 1This field indicates the status of the book. Valid values are:
  • A Active
  • I Inactive
AM135, AM154, AM30.1, AM30.2
ABT-BOOK-CURR
BOOK_CURR
Alpha 5AM135, AM154, AM30.1, AM30.2
ABT-TO-BOOK-CURR
TO_BOOK_CURR
Alpha 5AM135, AM154, AM30.1, AM30.2
ABT-BOOK-CURR-ND
BOOK_CURR_ND
Numeric 1AM135, AM154, AM30.1, AM30.2
ABT-TO-BK-CURR-ND
TO_BK_CURR_ND
Numeric 1AM135, AM154, AM30.1, AM30.2
ABT-LIFE
LIFE
Numeric 4This is the asset life in months.AM135, AM154, AM30.1, AM30.2
ABT-LIFE-REM
LIFE_REM
Signed 7.3This is the remaining life for the asset.AM135, AM154, AM30.1, AM30.2
ABT-BOOK-BASIS
BOOK_BASIS
Signed 18.2This field contains the amount on which the depreciation calculations for the book are based. Note: The depreciation basis amount can be different for each depreciation book used.AM135, AM154, AM30.1, AM30.2
ABT-FR-BOOK-BASIS
FR_BOOK_BASIS
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-BOOK-BASIS
TO_BOOK_BASIS
Signed 18.2This field contains the amount on which the depreciation calculations for the transfer-to asset book are based.AM135, AM154, AM30.1, AM30.2
ABT-METHOD
METHOD
Alpha 10This is the asset book depreciation method.AM135, AM154, AM30.1, AM30.2
ABT-METH-SWITCHED
METH_SWITCHED
Alpha 1AM135, AM154, AM30.1, AM30.2
ABT-INSRV-DATE
INSRV_DATE
Numeric 8 (yyyymmdd)This is the in-service date for the asset. Note: The in-service date can be different for each depreciation book used.AM135, AM154, AM30.1, AM30.2
ABT-METH-TABLE-YR
METH_TABLE_YR
Numeric 2This field indicates what year of its life an asset is in. Various tables use this year in their calculations.AM135, AM154, AM30.1, AM30.2
ABT-CONVENTION
CONVENTION
Alpha 2This is the in-service convention for the asset, which determines the amount of depreciation it receives in its first and last years in service. Valid values are:
  • FM Full Month
  • HM Modified Half Month
  • AD Actual Days
  • HY Half Year
  • MY Modified Half Year
  • MQ Mid Quarter
  • MM Mid Month
  • FY Full Month
  • NM Next Month
AM135, AM154, AM30.1, AM30.2
ABT-DEPR-STARTDATE
DEPR_STARTDATE
Numeric 8 (yyyymmdd)This is the date from which depreciation calculation begins.AM135, AM154, AM30.1, AM30.2
ABT-LIFE-YEARS
LIFE_YEARS
Signed 5.2This is the asset life in years.AM135, AM154, AM30.1, AM30.2
ABT-STATUS-CP-CALC
STATUS_CP_CALC
Alpha 1This field indicates whether depreciation has been calculated for the current period.AM135, AM154, AM30.1, AM30.2
ABT-LIFE-CP
LIFE_CP
Signed 5.3This is the portion of the asset life for the current period.AM135, AM154, AM30.1, AM30.2
ABT-TRAN-ND
TRAN_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AM135, AM154, AM30.1, AM30.2
ABT-TO-TRAN-ND
TO_TRAN_ND
Numeric 1The number of decimal positions defined for the To-Book transaction currency.AM135, AM154, AM30.1, AM30.2
ABT-DEPR-CP
DEPR_CP
Signed 18.2This is the depreciation amount for the current period for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-DEPR-CP
FR_DEPR_CP
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-DEPR-CP
TO_DEPR_CP
Signed 18.2This is the current period depreciation amount for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-DEPR-CP-ALLOW
DEPR_CP_ALLOW
Signed 18.2This is the depreciation allowed for the from-asset in the current period.AM135, AM154, AM30.1, AM30.2
ABT-FR-DP-CP-ALLOW
FR_DP_CP_ALLOW
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-DP-CP-ALLOW
TO_DP_CP_ALLOW
Signed 18.2This is the depreciation allowed in the current period for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-DEPR-YTD
DEPR_YTD
Signed 18.2This is the year-to-date depreciation for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-DEPR-YTD
FR_DEPR_YTD
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-DEPR-YTD
TO_DEPR_YTD
Signed 18.2This is the year-to-date depreciation for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-DEPR-YTD-ALLOW
DEPR_YTD_ALLOW
Signed 18.2This is the year-to-date depreciation allowance for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-DP-YTD-ALLO
FR_DP_YTD_ALLO
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-DP-YTD-ALLO
TO_DP_YTD_ALLO
Signed 18.2This is the year-to-date depreciation allowance for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-DEPR-YTD-OVRRD
DEPR_YTD_OVRRD
Signed 18.2This is the year-to-date depreciation override amount for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-DP-YTD-OVRD
FR_DP_YTD_OVRD
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-DP-YTD-OVRD
TO_DP_YTD_OVRD
Signed 18.2This is the year-to-date depreciation override amount for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-DEPR-LTD
DEPR_LTD
Signed 18.2This is the life-to-date depreciation for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-DEPR-LTD
FR_DEPR_LTD
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-DEPR-LTD
TO_DEPR_LTD
Signed 18.2This is the life-to-date depreciation for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-DEPR-LTD-ALLOW
DEPR_LTD_ALLOW
Signed 18.2This is the life-to-date depreciation allowance for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-DP-LTD-ALLO
FR_DP_LTD_ALLO
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-DP-LTD-ALLO
TO_DP_LTD_ALLO
Signed 18.2This is the life-to-date depreciation allowance for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-LAST-CLOSE
LAST_CLOSE
Signed 18.2This is the last closed balance for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-LAST-CLOSE
FR_LAST_CLOSE
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-LAST-CLOSE
TO_LAST_CLOSE
Signed 18.2This is the last closed balance for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-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. 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
AM135, AM154, AM30.1, AM30.2
ABT-INACT-YTD
INACT_YTD
Signed 5.3This is the length of time an asset has been inactive year-to-date.AM135, AM154, AM30.1, AM30.2
ABT-INACT-LTD
INACT_LTD
Signed 7.3This is the time an asset has been inactive life-to-date.AM135, AM154, AM30.1, AM30.2
ABT-SALVAGE-VALUE
SALVAGE_VALUE
Signed 18.2This is the salvage value of the from-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 200DB (Double Declining Balance), 125 (125% Declining Balance), 150 (150% Declining Balance), or 175 (175% Declining Balance), the basis used for the depreciation calculation is the asset cost. Depreciation is taken until the total amount taken is equal to the asset cost less this salvage value.AM135, AM154, AM30.1, AM30.2
ABT-FR-SALV-VALUE
FR_SALV_VALUE
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-SALV-VALUE
TO_SALV_VALUE
Signed 18.2This is the salvage value for the to-asset. If the depreciation method is Straight Line, the basis used for the depreciation calculation is the asset cost less this salvage value. If the depreciation method is 200DB (Double Declining Balance), 125 (125% Declining Balance), 150 (150% Declining Balance), or 175 (175% Declining Balance), the basis used for the depreciation calculation is the asset cost. Depreciation is taken until the total amount taken is equal to the asset cost less this salvage value.AM135, AM154, AM30.1, AM30.2
ABT-BUS-PERCENT
BUS_PERCENT
Signed 5.2This is the business use percentage for the asset.AM135, AM154, AM30.1, AM30.2
ABT-PERSONAL-USE
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.AM135, AM154, AM30.1, AM30.2
ABT-YR1-EXP
YR1_EXP
Signed 18.2This is the new first year expense for the from-asset. 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.AM135, AM154, AM30.1, AM30.2
ABT-FR-YR1-EXP
FR_YR1_EXP
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-YR1-EXP
TO_YR1_EXP
Signed 18.2This is the new first year expense for the to-asset. This is the first year expense amount for the to-asset for the First Year Expense option. This U.S. tax option allows you to expense and not depreciate a total amount for the assets of each eligible company.AM135, AM154, AM30.1, AM30.2
ABT-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.AM135, AM154, AM30.1, AM30.2
ABT-TC-PROPERTY
TC_PROPERTY
Signed 18.2This is the tax credit amount for the from-asset, if you are taking a tax credit for used property.AM135, AM154, AM30.1, AM30.2
ABT-FR-TC-PROPERTY
FR_TC_PROPERTY
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-TC-PROPERTY
TO_TC_PROPERTY
Signed 18.2This is the tax credit amount for the to-asset, if you are taking a tax credit for used property.AM135, AM154, AM30.1, AM30.2
ABT-TAX-CREDIT
TAX_CREDIT
Signed 18.2This is the tax credit amount for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-TAX-CREDIT
FR_TAX_CREDIT
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-TAX-CREDIT
TO_TAX_CREDIT
Signed 18.2This is the tax credit amount for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-INS-METHOD
INS_METHOD
Alpha 10This is the insurance method for the asset.AM135, AM154, AM30.1, AM30.2
ABT-INS-ACT-VAL
INS_ACT_VAL
Signed 18.2This is the actual insurance value for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-INS-ACT-VAL
FR_INS_ACT_VAL
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-INS-ACT-VAL
TO_INS_ACT_VAL
Signed 18.2This is the actual insurance value for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-INS-CMPTD-VAL
INS_CMPTD_VAL
Signed 18.2This is the computed insurance value for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-INS-CMPTD
FR_INS_CMPTD
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-INS-CMPTD
TO_INS_CMPTD
Signed 18.2This is the computed insurance value for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-RPL-METHOD
RPL_METHOD
Alpha 10This is the replacement method for the asset.AM135, AM154, AM30.1, AM30.2
ABT-RPL-CMPTD-VAL
RPL_CMPTD_VAL
Signed 18.2This is the computed replacement value for the from-asset.AM135, AM154, AM30.1, AM30.2
ABT-FR-RPL-CMPTD
FR_RPL_CMPTD
Signed 18.2AM135, AM154, AM30.1, AM30.2
ABT-TO-RPL-CMPTD
TO_RPL_CMPTD
Signed 18.2This is the computed replacement value for the to-asset.AM135, AM154, AM30.1, AM30.2
ABT-TRF-TRF-DATE
TRF_TRF_DATE
DerivedThis is the date of the transfer.
ABT-TRF-FULL-PART
TRF_FULL_PART
DerivedThis field shows whether the transfer is a full transfer (including all items) or a partial transfer (including only some items).
ABT-TRF-TRF-TYPE
TRF_TRF_TYPE
DerivedThis field indicates the type of the transfer.
ABT-AST-TAG-NBR
AST_TAG_NBR
DerivedThis is the tag, a user-definable identifier, for the asset.
ABT-TO-AST-TAG
TO_AST_TAG
DerivedThis is the tag for the to-asset.
ABT-AST-ASSET-GRP
AST_ASSET_GRP
DerivedThis is the asset group for the from-asset.
ABT-TO-AST-GROUP
TO_AST_GROUP
DerivedThis is the asset group for the to-asset.
ABT-BOOK-CURRENCY
BOOK_CURRENCY
DerivedThis is the currency for the book.
ABT-TRF-CREAT-DATE
TRF_CREAT_DATE
DerivedThis is the date the transfer was created.
ABT-TRF-CREAT-TIME
TRF_CREAT_TIME
DerivedThis is the time the transfer was created.
ABT-TRF-CREATOR-ID
TRF_CREATOR_ID
DerivedThis is the ID of the person who created the transfer.

Indexes (3)

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

IndexKeysFlagsConditionUsed in
ABTSET1ASSET, PROCESS-SEQ, BOOKPrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABTSET2ASSET, BOOK, PROCESS-SEQAM230, AM281, AM310, AMDL.1
ABTSET3ASSET, PROCESS-SEQ, TO-BOOK, BOOKAM230, AM30.1

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot RequiredABT-ASSETAST-ASSET
AmassettrfAMASSETTRFNot RequiredABT-ASSETATF-ASSET, ABT-PROCESS-SEQATF-PROCESS-SEQ
AmastbookAMASTBOOKRequiredABT-ASSETASB-ASSET, ABT-BOOKASB-BOOK
AmbookAMBOOKNot RequiredABT-BOOKAMB-BOOK
To BookAMBOOKNot RequiredABT-TO-BOOKAMB-BOOK

Programs

Updated by (270)

Referenced by (15)