 |
Lawson Insight Technical Documentation |
|
AMASTBOOK FILE
Asset Book
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.
REFERENCED BY
AM220 AM222 AM225 AM240 AM255 AM260
AM265 AM266 AM278 AM280 AM281 AM285
AM290 AM292 AM295 AM320 AM90.1 AM90.2
AM90.4 AM90.5 AM91.1 AM91.2 AM91.4 AM91.5
AMAS.1 AMDL.1 AM00.1 AM00.2 AM01.1 AM01.2
AM01.3 AM04.1 AM06.4 AM06.5 AM88.2 AMCV.1
AMMD.1 AMLF.1
UPDATED BY
AM115 AM120 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM154 AM170 AM180
AM185 AM190 AM192 AM195 AM20.1 AM20.2
AM20.3 AM20.4 AM20.5 AM20.6 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM30.1 AM30.2
AM300 AM310 AM40.1 AM40.2 AM40.3 AM41.1
AM500 AM520 AM551 AM580 AM60.1 AM96.1
AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASB-ASSET Numeric 10 AM115 AM135
Asset The asset number associated with the AM145 AM15.1
asset book record. AM15.2 AM15.3
AM15.4 AM154
The asset number contains up to ten AM170 AM20.1
numeric characters that uniquely AM20.2 AM20.3
identify an asset. Assets are AM20.4 AM20.5
automatically numbered system-wide. AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM551 AM96.1
AM98.1
ASB-BOOK Alpha 10 AM115 AM120
Book A book name assigned to the asset. AM15.1 AM15.2
Books are user-defined and are used by AM15.3 AM15.4
assets for calculating depreciation, AM170 AM20.1
replacement cost, and insurance values, AM20.2 AM20.3
and for reporting. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM520
AM551 AM96.1
AM98.1
ASB-BOOK-STATUS Alpha 1 AM115 AM120
Book Status This field identifies the status of the AM125 AM15.1
book. Valid values are: AM15.2 AM15.3
A = Active AM15.4 AM170
I = Inactive AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-LIFE Numeric 4 AM115 AM120
Life The life value of the asset, expressed AM125 AM15.1
in months. AM15.2 AM15.3
AM15.4 AM170
Note: The asset life can be different AM180 AM20.1
for each depreciation book used. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM280
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-LIFE-REM Signed 7.3 AM115 AM120
Life Remaining The asset life remaining, expressed in AM125 AM15.1
months. This value represents the number AM15.2 AM15.3
of months the Asset Management system AM15.4 AM170
will continue to depreciate the asset. AM180 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM280
AM30.1 AM500
AM551 AM580
AM96.1 AM98.1
ASB-BOOK-BASIS Signed 15.2 AM115 AM135
Book Basis The amount on which the depreciation AM145 AM15.1
calculations are based. AM15.2 AM15.3
AM15.4 AM154
Note: The depreciation basis amount AM170 AM192
can be different for each depreciation AM20.1 AM20.2
book used. AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM551 AM96.1
AM98.1
ASB-METHOD Alpha 10 AM115 AM120
Method The method the book uses to calculate AM125 AM15.1
depreciation for the asset. Standard AM15.2 AM15.3
depreciation methods are predefined. AM15.4 AM170
Additional methods can be user defined AM20.1 AM20.2
for the following kinds of methods: AM20.3 AM20.4
compute statements, annual percent AM20.5 AM20.6
tables, and annual and period units of AM21.1 AM21.2
production tables. Valid predefined AM21.3 AM21.4
values are: AM21.5 AM21.6
AM30.1 AM500
SL = Straight Line. AM551 AM96.1
200DB = 200 percent declining balance. AM98.1
175DB = 175 percent declining balance.
150DB = 150 percent declining balance.
125DB = 125 percent declining balance.
SYD = Sum of the year's digits.
ASB-METH-SWITCHED Alpha 1 AM115 AM15.1
Method Switched This field indicates whether the Asset AM15.2 AM15.3
Management system has switched the AM15.4 AM170
depreciation method to the optimizing AM180 AM20.1
method. Valid values are: AM20.2 AM20.3
AM20.4 AM20.5
N = No. AM20.6 AM21.1
Y = Yes. AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
AM96.1 AM98.1
ASB-INSRV-DATE Numeric 8 (yyyymmdd) AM115 AM120
In Service Date The date the asset was placed in AM125 AM15.1
service. AM15.2 AM15.3
AM15.4 AM170
Note: The in-service date can be AM20.1 AM20.2
different for each depreciation book AM20.3 AM20.4
used. AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-METH-TABLE-YR Numeric 2 AM115 AM125
Method Table Year The year the asset was placed in AM15.1 AM15.2
service. AM15.3 AM15.4
AM170 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM580
AM96.1 AM98.1
ASB-CONVENTION Alpha 2 AM115 AM120
Convention The depreciation convention assigned to AM125 AM15.1
the book. This value is used to AM15.2 AM15.3
determine the first and last years' AM15.4 AM170
depreciation amounts to take. Valid AM20.1 AM20.2
values are: AM20.3 AM20.4
AM20.5 AM20.6
FM = Full Month. AM21.1 AM21.2
HM = Modified Half Month. AM21.3 AM21.4
MM = Mid Month. AM21.5 AM21.6
NM = Next Month. AM30.1 AM500
HY = Half Year. AM551 AM96.1
MY = Modified Half Year. AM98.1
FY = Full Year.
AD = Actual Days.
MQ = Mid Quarter.
Note: See data file text for the Method
file for more information on each
convention.
ASB-DEPR-STARTDATE Numeric 8 (yyyymmdd) AM115 AM125
Depreciation Start The date depreciation calculations AM15.1 AM15.2
Date began or will begin for the asset. AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM580
AM96.1 AM98.1
ASB-LIFE-YEARS Signed 5.2 AM115 AM120
Life Years The total life value of the asset, AM125 AM15.1
expressed in years. This value is AM15.2 AM15.3
calculated by dividing the Life value by AM15.4 AM170
12. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-STATUS-CP-CALC Alpha 1 AM115 AM15.1
Calc Status Current This field indicates whether AM15.2 AM15.3
Period depreciation has been calculated for the AM15.4 AM170
current period. AM180 AM190
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-LIFE-CP Signed 5.3 AM115 AM15.1
Current Period Life This is the current period portion of AM15.2 AM15.3
the asset life. AM15.4 AM170
AM180 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM280
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-TRAN-ND Numeric 1 AM115 AM135
Transaction Number The number of decimal positions defined AM145 AM15.1
of Decimals for the transaction currency. AM15.2 AM15.3
AM15.4 AM154
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM551 AM580
AM96.1 AM98.1
ASB-DEPR-CP Signed 15.2 AM115 AM135
Current Period This is the current period depreciation AM145 AM15.1
Depreciation for this book. This amount includes only AM15.2 AM15.3
the business use, not the personal use, AM15.4 AM154
portion of the depreciation AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM280 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM96.1 AM98.1
ASB-DEPR-CP-ALLOW Signed 15.2 AM115 AM135
Current Period Depr This is the current period depreciation AM15.1 AM15.2
Allowed allowed for the book. This amount is AM15.3 AM15.4
equivalent to the full depreciation, AM154 AM170
including business and personal use. AM180 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM280
AM30.1 AM30.2
AM40.1 AM500
AM551 AM96.1
AM98.1
ASB-DEPR-YTD Signed 15.2 AM115 AM125
Year-to-Date This is the year-to-date depreciation AM135 AM145
Depreciation amount for the book. This amount AM15.1 AM15.2
includes only the business use, not the AM15.3 AM15.4
personal use, portion of the AM154 AM170
depreciation. AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM41.1 AM500
AM551 AM580
AM96.1 AM98.1
ASB-DEPR-YTD-ALLOW Signed 15.2 AM115 AM125
Year-to-Date Depr This is the year-to-date depreciation AM135 AM145
Allowed allowed for the book. This amount is AM15.1 AM15.2
equivalent to the full depreciation, AM15.3 AM15.4
including business and personal use. AM154 AM170
AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM551 AM96.1
AM98.1
ASB-DEPR-YTD-OVRRD Signed 15.2 AM115 AM125
Year-to-Date Depr This is the year-to-date depreciation AM135 AM145
Override override amount. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM551
AM60.1 AM96.1
AM98.1
ASB-DEPR-LTD Signed 15.2 AM115 AM125
Life-to-Date This is the life-to-date depreciation AM135 AM145
Depreciation amount for the book. This amount AM15.1 AM15.2
includes only the business use, not the AM15.3 AM15.4
personal use, portion of the AM154 AM170
depreciation. AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM41.1
AM500 AM551
AM580 AM96.1
AM98.1
ASB-DEPR-LTD-ALLOW Signed 15.2 AM115 AM125
Life-to-Date Depr This is the life-to-date depreciation AM135 AM145
Allowed allowed for the book. This amount is AM15.1 AM15.2
equivalent to the full depreciation, AM15.3 AM15.4
including business and personal use. AM154 AM170
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ASB-LAST-CLOSE Signed 15.2 AM115 AM135
Last Close This is the balance in the last-closed AM15.1 AM15.2
period for this book. AM15.3 AM15.4
AM154 AM170
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM500 AM551
AM96.1 AM98.1
ASB-FIRST-LAST-FL Alpha 1 AM115 AM125
First or Last Flag This field is an internal, AM15.1 AM15.2
system-maintained value used to control AM15.3 AM15.4
depreciation calculations during the AM170 AM190
first and last years of an asset's life. AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
Valid values are: AM20.5 AM20.6
AM21.1 AM21.2
F = First. This is the first in-service AM21.3 AM21.4
year for the asset. AM21.5 AM21.6
AM30.1 AM500
M = Middle. The asset is in a year AM551 AM580
other than the first or last. AM96.1 AM98.1
L = Last. This is the last in-service
year for the asset.
C = Completely Depreciated. The asset
no longer participates in depreciation
calculations.
P = Post Recovery. The system will
continue to depreciate the asset beyond
the original asset life.
ASB-INACT-YTD Signed 5.3 AM115 AM15.1
Inactive This is the number of inactive months AM15.2 AM15.3
Year-to-Date for the book year-to-date. AM15.4 AM170
AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
AM96.1 AM98.1
ASB-INACT-LTD Signed 7.3 AM115 AM15.1
Inactive This is the number of inactive months AM15.2 AM15.3
Life-to-Date for the book life-to-date. AM15.4 AM170
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-SALVAGE-VALUE Signed 15.2 AM115 AM135
Salvage Value The salvage value of the asset at the AM145 AM15.1
end of the asset's life. It can be zero. AM15.2 AM15.3
AM15.4 AM154
AM170 AM192
If the depreciation method is STL AM20.1 AM20.2
(Straight Line), the basis used for the AM20.3 AM20.4
depreciation calculation is the asset AM20.5 AM20.6
cost less this salvage value. AM21.1 AM21.2
AM21.3 AM21.4
If the depreciation method is DDB AM21.5 AM21.6
(Double Declining Balance), 150 (150% AM30.1 AM30.2
Declining Balance), or 175 (175% AM40.1 AM40.2
Declining Balance), the basis used for AM500 AM551
the depreciation calculation is the AM96.1 AM98.1
asset cost. Depreciation will be taken
until the total amount taken is equal to
the asset cost less this salvage value.
ASB-BUS-PERCENT Signed 5.2 AM115 AM15.1
Business Percent The business percent usage of the AM15.2 AM15.3
asset. If this value is less than 100 AM15.4 AM170
percent, the value is used in AM20.1 AM20.2
depreciation calculations. AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-PERSONAL-USE Alpha 10 AM115 AM15.1
Personal Use The personal use code assigned to the AM15.2 AM15.3
asset. A personal use code defines the AM15.4 AM170
personal use options that asset books AM20.1 AM20.2
use to calculate depreciation, tax AM20.3 AM20.4
credits, and annual depreciation limits AM20.5 AM20.6
up to twenty years. The code is user AM21.1 AM21.2
definable. AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-YR1-EXP Signed 15.2 AM115 AM135
First Year Expense This is the new first year expense AM145 AM15.1
amount. It represents the amount to AM15.2 AM15.3
expense for the First Year Expense AM15.4 AM154
option. This U.S. tax option allows you AM170 AM192
to expense and not depreciate a total AM20.1 AM20.2
dollar amount for the assets of each AM20.3 AM20.4
eligible company. AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ASB-TC-TABLE Alpha 10 AM115 AM15.1
Tax Credit Table A user-defined tax credit table, which AM15.2 AM15.3
defines tax credit percentages and AM15.4 AM170
annual tax credit recapture percentages AM20.1 AM20.2
for up to twenty years. Asset books use AM20.3 AM20.4
tax credit tables to calculate tax AM20.5 AM20.6
credits. AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-TC-PROPERTY Signed 15.2 AM115 AM135
Tax Credit Property If you are taking a tax credit for used AM145 AM15.1
property, this field contains the amount AM15.2 AM15.3
that qualifies for the credit. AM15.4 AM154
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ASB-TAX-CREDIT Signed 15.2 AM115 AM135
Tax Credit This is the amount of tax credit taken AM145 AM15.1
for this asset. AM15.2 AM15.3
AM15.4 AM154
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ASB-INS-METHOD Alpha 10 AM115 AM15.1
Insurance Method The method used to calculate insurance AM15.2 AM15.3
values for the asset. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-INS-ACT-VAL Signed 15.2 AM115 AM135
Insurance Actual The actual insurance value of the AM145 AM15.1
Value asset. AM15.2 AM15.3
AM15.4 AM154
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ASB-INS-CMPTD-VAL Signed 15.2 AM115 AM135
Insurance Computed The calculated insurance value for the AM145 AM15.1
Value asset. AM15.2 AM15.3
AM15.4 AM154
AM170 AM185
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM551 AM96.1
AM98.1
ASB-RPL-METHOD Alpha 10 AM115 AM15.1
Replacement Method The method used to calculate AM15.2 AM15.3
replacement values for the asset. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
ASB-RPL-CMPTD-VAL Signed 15.2 AM115 AM135
Replacement The calculated replacement value for AM145 AM15.1
Computed Value the asset. AM15.2 AM15.3
AM15.4 AM154
AM170 AM185
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM551 AM96.1
AM98.1
ASB-CREATION-DATE Numeric 8 (yyyymmdd) AM145 AM154
Creation Date The date the asset book record was AM40.1 AM40.2
created.
ASB-CREATION-TIME Numeric 6 (hhmmss) AM145 AM154
Creation Time The time the asset book record was AM40.1 AM40.2
created.
ASB-CREATOR-ID Alpha 10 AM145 AM154
Creator ID This field identifies the operator who AM40.1 AM40.2
created the asset book record.
ASB-BOOK-DESC Derived
Book Description The book description.
ASB-BOOK-VALUE Derived
Book Value The book value is calculated as
follows: Book Basis - Life-to-date
Depreciation.
ASB-SALVAGE-PCT Derived
Salvage Percentage Salvage percentage is calculated as
follows: Salvage Value / Book Basis.
ASB-BK-YR-END-DATE Derived
Book Year-End Date The last date of the fiscal year.
ASB-BK-YR-BEG-DATE Derived
Book Year-Begin Date The first date of the fiscal year.
ASB-BK-PD-PER-YR Derived
Book Periods Per The number of periods defined for the
Year fiscal year.
ASB-BK-DEPR-PD-CLS Derived
Book Depreciation This field identifies the number of
Period Close depreciation periods that are closed in
the fiscal year.
ASB-BK-PD-CLOSE-DT Derived
Book Period Close The last date of the current period.
Date
ASB-BK-PD-CURR-DT Derived
Book Current Period This field identifies the closing date
Close Date of the current period.
ASB-BK-REQ Derived
Book Required This field indicates whether the book
is a required book to be used by all new
assets being added.
ASB-BK-POSTING Derived
Posting Book This field identifies whether the book
is a posting book that posts journal
entries to the general ledger.
ASB-BK-BOOK-STATUS Derived
Book Status The status of the book.
ASB-BK-CURRENCY-CD Derived
Currency Code The currency code assigned to the book.
ASB-BK-METH-SWITCH Derived
Method Switch This field identifies whether the
depreciation method can be switched for
the book.
ASB-BK-DEPR-TYPE Derived
Bk Depr Type This field allows for a drill-around to
AMBOOK to diplay the values in the
DEPR-TYPE-FLAG (Asset or Class).
ASB-BK-HISTORY Derived
Bk History
ASB-TAG Derived
Tag The tag number assigned to the asset.
ASB-ASSET-GRP Derived
Asset Group The asset group assigned to the asset.
ASB-DEPR-YTD-OVER Derived
Year-to-Date Deprec The word "OVERRIDE" displays if there
Override is a year-to-date depreciation override
amount.
ASB-AST-DESC Derived
Asset Description This is the asset description.
ASB-AST-STATUS Derived
Asset Status This is the asset status.
ASB-AST-LOCATION Derived
Ast Location
ASB-AST-DIVISION Derived
Ast Division
ASB-AST-TYPE Derived
Ast Type
ASB-AST-SUBTYPE Derived
Ast Subtype
ASB-DSP-YTD Signed 5.3 AM115 AM15.1
Dsp Ytd This is the number of months that the AM15.2 AM15.3
asset has been disposed in the current AM15.4 AM170
year. This field gets cleared when the AM190 AM195
year rolls over. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
AMASTBOOK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASBSET1 ASSET AM115 AM120
BOOK AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM185 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM220 AM222
...
ASBSET2 BOOK AM00.1 AM00.2
ASSET AM01.1 AM01.2
AM01.3 AM04.1
AM06.4 AM06.5
AM120 AM135
AM220 AM260
AM278 AM285
AM310 AM520
AM60.1 AM88.2
AM90.1 AM90.2
AM90.4 AM90.5
AM91.1 AM91.2
AM91.4 AM91.5
ASBSET3 CONVENTION KeyChange AMCV.1
ASSET
BOOK
ASBSET4 METHOD KeyChange AMMD.1
ASSET
BOOK
ASBSET5 LIFE KeyChange AMLF.1
ASSET
BOOK
AMASTBOOK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
ASB-ASSET -> AST-ASSET
Amastbkdsp AMASTBKDSP Not Required
ASB-ASSET -> ABD-ASSET
ASB-BOOK -> ABD-BOOK
Amasttype AMASTTYPE Not Required
AST-COMPANY -> ATP-COMPANY
AST-ASSET-TYPE -> ATP-ASSET-TYPE
AST-SUB-TYPE -> ATP-SUB-TYPE
Ambook AMBOOK Required
ASB-BOOK -> AMB-BOOK
Amcalendar AMCALENDAR Not Required
ASB-BOOK -> AMC-BOOK
AST-COMPANY -> AMC-COMPANY
Amdivision AMDIVISION Not Required
AST-DIVISION -> DIV-DIVISION
Amlocation AMLOCATION Not Required
AST-LOCATION-NAME -> LOC-LOCATION-NAME
Ammethod AMMETHOD Required
ASB-METHOD -> AMM-METHOD
AMASTBOOK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastbkadj AMASTBKADJ
ASB-ASSET -> ABA-ASSET
ASB-BOOK -> ABA-BOOK
ABA-PROCESS-SEQ
Amastbktrf AMASTBKTRF
ASB-ASSET -> ABT-ASSET
ASB-BOOK -> ABT-BOOK
ABT-PROCESS-SEQ
Ambkhist AMBKHIST
ASB-ASSET -> ABH-ASSET
ASB-BOOK -> ABH-BOOK
ABH-YR-END-DATE
Ambktrans AMBKTRANS
ASB-ASSET -> ABK-ASSET
ASB-BOOK -> ABK-BOOK
AMC-COMPANY -> ABK-COMPANY
ABK-TRANS-STATUS
ABK-SEQ-NUMBER
Amtrans AMTRANS
ASB-ASSET -> AMT-ASSET
"R" -> AMT-TRANS-STATUS
AMC-COMPANY -> AMT-COMPANY
ASB-BOOK -> AMT-BOOK
AMT-SEQ-NUMBER
|