AMASTBKADJ – Asset Book Adjustment

System
Asset Management (AM)
Prefix
ABA
Primary key
ASSET, PROCESS-SEQ, BOOK
Fields
76
Updated by
268 programs
Referenced by
17 programs

AMASTBKADJ is the Asset Book Adjustment table in Lawson Asset Management (prefix ABA). It is indexed by ASSET, PROCESS-SEQ, BOOK (ABASET1); alternate indexes: ABASET2. It is related 1:1 to AMASSET, AMASSETADJ, AMASTBOOK and AMBOOK. It is updated by AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 and 260 more and referenced by AM135, AM145, AM154, AM155, AM190, AM192, AM225, AM30.1 and 9 more. The table has 76 fields, 2 indexes and 4 documented relations.

About AMASTBKADJ

The Asset Book Adjustment file is an audit file that stores records of changes that are made to Asset Book file records. Each asset book adjustment record describes the before and after values of asset book fields that were changed, as well as the date and time of the change and the operator who made the changes.

Fields (76)

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

Field / columnTypeDescription & valuesUpdated by
ABA-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.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-BOOK PK
BOOK		Alpha 10Key field. A user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-PROCESS-SEQ PK
PROCESS_SEQ		Numeric 6Key field. This is the process sequence number for the asset book adjustment.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-ADJUST-DATE
ADJUST_DATE		Numeric 8 (yyyymmdd)This is the effective date for the adjustment.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-COMPUTE
COMPUTE		Alpha 1This option determines how an adjustment affects depreciation in the period of adjustment, in prior periods of the same year, and in future years. Valid values are: year-to-date depreciation taken and the annual amount that should be taken based on the change is spread over the remaining depreciation periods in the current year. year-to-date depreciation taken and the amount that should be taken based on the change is charged to the current depreciation period. adjustment date is allocated over the assets remaining life. No current period adjustment is applicable and no annual limits are applied to the current year depreciation calculation.
  • N Any difference between the
  • Y Any difference between the
  • P The net asset value as of the
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-BOOK-STATUS
BOOK_STATUS		Alpha 1This field indicates the book status. Valid values are:
  • A Active
  • I Inactive
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-BOOK-STATUS
TO_BOOK_STATUS		Alpha 1This is the book status for the transfer-to asset. Valid values are:
  • A Active
  • I Inactive
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-LIFE
LIFE		Numeric 4This is the asset life in months.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-LIFE
TO_LIFE		Numeric 4This is the life in months for the transfer-to asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-LIFE-REM
LIFE_REM		Signed 7.3This is the asset life remaining in months.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-LIFE-REM
TO_LIFE_REM		Signed 7.3This is the asset life remaining in months for the transfer-to asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-BOOK-BASIS
BOOK_BASIS		Signed 18.2This field contains the amount on which the depreciation calculations are based. Note: The depreciation basis amount can be different for each depreciation book.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-BOOK-BASIS
TO_BOOK_BASIS		Signed 18.2This field contains the amount on which depreciation calculations for the to-asset are based. Note: The depreciation basis amount can be different for each depreciation book.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-METHOD
METHOD		Alpha 10This is the method. It can be a predefined or a user-defined method.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-METHOD
TO_METHOD		Alpha 10This is the method for the to-asset. It can be a predefined or a user-defined method.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-METH-SWITCHED
METH_SWITCHED		Alpha 1This is the switch used to indicate when the Asset Management system has switched the depreciation method. It remains blank until the switch occurs. The system then fills in an asterisk ("*"). Valid values are: # = (Blank); the switch is not in use. has been switched to the optimizing method.
  • * (Asterisk); the depreciation method
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-METH-SWITCH
TO_METH_SWITCH		Alpha 1This field indicates for the to-asset whether the Asset Management system has switched the depreciation method. It remains blank until the switch occurs; then the system fills in an asterisk in the field.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-INSRV-DATE
INSRV_DATE		Numeric 8 (yyyymmdd)The book in-service date for the asset. Note: The in-service date can be different for each depreciation book used.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-INSRV-DATE
TO_INSRV_DATE		Numeric 8 (yyyymmdd)The book in-service date for the to-asset. Note: The in-service date can be different for each depreciation book.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-METH-TABLE-YR
METH_TABLE_YR		Numeric 2This field indicates what year of its life the asset is in.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-METH-TBL-YR
TO_METH_TBL_YR		Numeric 2This field indicates what year of its the to-asset is in.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-CONVENTION
CONVENTION		Alpha 2This is the convention for depreciation calculation. Valid values are: 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. Modified Half Month = If the asset is placed in service during the first half of the month, it receives one full month of depreciation for its first month. In this case, it receives no depreciation for the month in which it is disposed of. If the asset is placed in service during the last half of the month, depreciation calculations begin the following month. In this case, the asset receives a full month during the month in which it is disposed of. of one month's depreciation for the month in which it is placed in service, and one-half of one month's depreciation for the month in which it is disposed of. month of depreciation in the month after it is placed in service and one full month of depreciation in the month it is disposed of. year's depreciation the year it is placed in service and no depreciation the year it is disposed of. of a year's depreciation for the first year and the year it is disposed of. Modified Half Year = If the asset is in service before the middle of the year, it receives a full year's depreciation during its first year, and no depreciation during the year it is disposed of. If the asset is placed in service after the midpoint of the year, depreciation begins the following year, and the asset receives a full year's depreciation during the year it is disposed of. one-half of one quarter's depreciation for the quarter in which it is placed in service, and one-half of one quarter's depreciation for the quarter in which it is disposed of. depreciation for each day it is in service during the fiscal year, beginning with the in-service date.
  • Full Month The asset receives a full
  • Mid Month The asset receives one-half
  • Next Month The asset receives one full
  • Full Year The asset receives a full
  • Half Year The asset receives one half
  • Mid Quarter The asset receives
  • Actual Days The asset receives
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-CONVENTION
TO_CONVENTION		Alpha 2This is the convention for depreciation calculation for the to-asset . Valid values are: 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. Modified Half Month = If the asset is placed in service during the first half of the month, it receives one full month of depreciation for its first month. In this case, it receives no depreciation for the month in which it is disposed of. If the asset is placed in service during the last half of the month, depreciation calculations begin the following month. In this case, the asset receives a full month during the month in which it is disposed of. of one months depreciation for the month in which it is placed in service, and one-half of one month's depreciation for the month in which it is disposed of. month of depreciation in the month after it is placed in service and one full month of depreciation in the month it is disposed of. year's depreciation the year it is placed in service and no depreciation the year it is disposed of. of a year's depreciation for the first year and the year it is disposed of. Modified Half Year = If the asset is in service before the middle of the year, it receives a full year's depreciation during its first year, and no depreciation during the year it is disposed of. If the asset is placed in service after the midpoint of the year, depreciation begins the following year, and the asset receives a full year's depreciation during the year it is disposed of. one-half of one quarter's depreciation for the quarter in which it is placed in service, and one-half of one quarter's depreciation for the quarter in which it is disposed of. depreciation for each day it is in service during the fiscal year, beginning with the in-service date.
  • Full Month The asset receives a full
  • Mid Month The asset receives one-half
  • Next Month The asset receives one full
  • Full Year The asset receives a full
  • Half Year The asset receives one half
  • Mid Quarter The asset receives
  • Actual Days The asset receives
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-DEPR-STARTDATE
DEPR_STARTDATE		Numeric 8 (yyyymmdd)This is the date with which depreciation calculation begins.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-LIFE-YEARS
LIFE_YEARS		Signed 5.2This is the asset life in years.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-LIFE-YEARS
TO_LIFE_YEARS		Signed 5.2This is the to-asset life in years.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-STATUS-CP-CALC
STATUS_CP_CALC		Alpha 1This field indicates whether depreciation has been calculated for the current period.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-LIFE-CP
LIFE_CP		Signed 5.3This field indicates the portion of the asset life for the current period.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-DEPR-CP
DEPR_CP		Signed 18.2This is the current period depreciation amount for the book. This amount includes only the business use, not the personal use, portion of the depreciation.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-DEPR-YTD
TO_DEPR_YTD		Signed 18.2This is the year-to-date depreciation amount for the to-asset book. This amount includes only the business use, not the personal use, portion of the depreciation.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-DEPR-YTD-OVRRD
DEPR_YTD_OVRRD		Signed 18.2This is the depreciation year-to-date override amount.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-DP-YTD-OVRD
TO_DP_YTD_OVRD		Signed 18.2This is the depreciation year-to-date override amount for the transfer-to asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-DEPR-LTD
TO_DEPR_LTD		Signed 18.2This is the life-to-date depreciation amount for the to-asset book. This amount includes only the business use, not the personal use, portion of the depreciation.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-LAST-CLOSE
LAST_CLOSE		Signed 18.2This is the last closed balance for the asset book.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-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. 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 other
  • L Last. This is the last in-service
  • C Completely Depreciated. The asset no
  • P Post Recovery. The system will
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-INACT-CHG-DATE
INACT_CHG_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-INACT-YTD
INACT_YTD		Signed 5.3This is the number of inactive months for the book year-to-date.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-INACT-LTD
INACT_LTD		Signed 7.3This is the number of inactive months for the book life-to-date.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-SALVAGE-VALUE
SALVAGE_VALUE		Signed 18.2This is the book 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), 125DB (125% Declining Balance), 150DB (150% Declining Balance), or 175DB (175% Declining Balance), the basis used for the depreciation calculation is the asset cost. Depreciation is taken until the total amount is equal to the asset cost less this salvage value.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-SALV-VALUE
TO_SALV_VALUE		Signed 18.2This is the salvage value for the to-asset at the end of the asset's life. It can be zero.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-BUS-PERCENT
BUS_PERCENT		Signed 5.2This is the business use percentage for the asset. If the percentage is less than 100%, this is the value to be used during depreciation calculations. If this field is left blank in the asset record, the system defaults 100%.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-BUS-PERCENT
TO_BUS_PERCENT		Signed 5.2This is the business use percentage for the to-asset. If the percentage is less than 100%, this is the value to be used during depreciation calculations. If this field is left blank in the asset record, the system defaults 100%.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-PERSONAL-USE
PERSONAL_USE		Alpha 10Personal use is a name for depreciation limits defined to account for the personal use of an asset. A personal use code defines the personal use options that asset books use to calculate depreciation, tax credits, and annual depreciation limits for up to 20 years. The code is user-definable.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-PERSONL-USE
TO_PERSONL_USE		Alpha 10This is the personal use code for the to-asset. Personal use is a name for depreciation limits defined to account for the personal use of an asset. A personal use code defines the personal use options that asset books use to calculate depreciation, tax credits, and annual depreciation limits for up to 20 years. The code is user-definable.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-YR1-EXP
YR1_EXP		Signed 18.2This is the new 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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-YR1-EXP
TO_YR1_EXP		Signed 18.2This is the new 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.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TC-TABLE
TC_TABLE		Alpha 10This is a user-defined tax credit table for the asset that 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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-TC-TABLE
TO_TC_TABLE		Alpha 10This is a user-defined tax credit table for the to-asset that 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, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TC-PROPERTY
TC_PROPERTY		Signed 18.2If you are taking the tax credit for used property, this field contains the amount that qualifies for the tax credit.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-TC-PROPERTY
TO_TC_PROPERTY		Signed 18.2If you are taking the tax credit for used property for the to-asset, this field contains the amount that qualifies for the tax credit.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TAX-CREDIT
TAX_CREDIT		Signed 18.2This is the amount of tax credit taken for the asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-TAX-CREDIT
TO_TAX_CREDIT		Signed 18.2This is the amount of tax credit taken for the to-asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-INS-METHOD
INS_METHOD		Alpha 10This is the method used to compute the insurance value of the asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-INS-METHOD
TO_INS_METHOD		Alpha 10This is the method used to compute the insurance value of the to-asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-INS-ACT-VAL
INS_ACT_VAL		Signed 18.2This is the actual insurance value of the asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-INS-ACT-VAL
TO_INS_ACT_VAL		Signed 18.2This is the actual insurance value of the to-asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-INS-CMPTD-VAL
INS_CMPTD_VAL		Signed 18.2This is the insurance value as computed by the insurance method.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-INS-CMPTD
TO_INS_CMPTD		Signed 18.2This is the insurance value for the transfer-to asset, as computed by the insurance method.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-RPL-METHOD
RPL_METHOD		Alpha 10This is the method to use in computing the replacement value for the asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-RPL-METHOD
TO_RPL_METHOD		Alpha 10This is the method to use in computing the replacement value for the transfer-to asset.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-RPL-CMPTD-VAL
RPL_CMPTD_VAL		Signed 18.2This is the replacement value for the asset, computed by the replacement method.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-TO-RPL-CMPTD
TO_RPL_CMPTD		Signed 18.2This is the replacement value for the to-asset, computed by the replacement method.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-DSP-YTD
DSP_YTD		Signed 5.3—AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ABA-BOOK-CURRENCY
BOOK_CURRENCY		DerivedThis is the currency for the book.—
ABA-AST-TAG-NBR
AST_TAG_NBR		DerivedThis is the asset tag, a user-defined identifier.—
ABA-AST-ASSET-GRP
AST_ASSET_GRP		DerivedThis is the asset group to which the asset belongs.—
ABA-AST-DESCRIP
AST_DESCRIP		DerivedThis is the asset description.—
ABA-ADJ-CREAT-DATE
ADJ_CREAT_DATE		DerivedThis is the adjustment creation date.—
ABA-ADJ-CREAT-TIME
ADJ_CREAT_TIME		DerivedThis is the time the adjustment was created.—
ABA-ADJ-CREATOR-ID
ADJ_CREATOR_ID		DerivedThis is the ID of the person who created the adjustment.—

Indexes (2)

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

IndexKeysFlagsConditionUsed in
ABASET1ASSET, PROCESS-SEQ, BOOKPrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABASET2ASSET, BOOK, PROCESS-SEQAM225, AM310, AMDL.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot RequiredValid When ABA-ASSET != ZeroesABA-ASSET → AST-ASSET
AmassetadjAMASSETADJNot RequiredABA-ASSET → ASA-ASSET, ABA-PROCESS-SEQ → ASA-PROCESS-SEQ
AmastbookAMASTBOOKRequiredABA-ASSET → ASB-ASSET, ABA-BOOK → ASB-BOOK
AmbookAMBOOKNot RequiredABA-BOOK → AMB-BOOK

Programs

Updated by (268)

Referenced by (17)