 |
Lawson Insight Technical Documentation |
|
AMASTBOOK FILE
Asset Book
REFERENCED BY
AM220 AM222 AM225 AM240 AM255 AM260
AM265 AM266 AM267 AM278 AM280 AM281
AM285 AM287 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
AM30.3 AM300 AM310 AM40.1 AM40.2 AM40.3
AM40.4 AM41.1 AM41.2 AM500 AM520 AM551
AM580 AM60.1 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASB-ASSET Numeric 10 AM115 AM125
Asset The asset number contains up to ten AM135 AM145
numeric characters that uniquely AM15.1 AM15.2
identify an asset. Assets are AM15.3 AM15.4
automatically numbered system-wide. 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
AM96.1 AM98.1
ASB-BOOK Alpha 10 AM115 AM120
Book A user-defined book name. Books are AM125 AM15.1
used by assets for calculating AM15.2 AM15.3
depreciation, replacement cost, and AM15.4 AM170
insurance values, and for reporting. 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
AM520 AM551
AM96.1 AM98.1
ASB-BOOK-STATUS Alpha 1 AM115 AM120
Book Status A = Active AM125 AM15.1
I = Inactive AM15.2 AM15.3
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-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 AM125
Book Basis The GL BOOK basis field contains the AM135 AM145
amount on which the depreciation AM15.1 AM15.2
calculations are based. AM15.3 AM15.4
AM154 AM170
Note: The depreciation basis amount AM192 AM20.1
can be different for each depreciation AM20.2 AM20.3
book used. 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 AM125
Method Switched This field indicates whether the Asset AM15.1 AM15.2
Management system has switched the AM15.3 AM15.4
depreciation method to the optimizing AM170 AM180
method. Valid values are: AM20.1 AM20.2
AM20.3 AM20.4
N = No. AM20.5 AM20.6
Y = Yes. AM21.1 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 FM = Full Month AM125 AM15.1
HM = Modified Half Month AM15.2 AM15.3
AD = Actual Days AM15.4 AM170
HY = Half Year AM20.1 AM20.2
MY = Modified Half Year AM20.3 AM20.4
MQ = Mid Quarter AM20.5 AM20.6
MM = Mid Month AM21.1 AM21.2
FY = Full Year AM21.3 AM21.4
NM = Next Month AM21.5 AM21.6
AM30.1 AM500
AM551 AM96.1
AM98.1
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 AM125
Calc Status Current This field indicates whether AM15.1 AM15.2
Period depreciation has been calculated for the AM15.3 AM15.4
current period. AM170 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 AM125
Current Period Life This is the current period portion of AM15.1 AM15.2
the asset life. AM15.3 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 AM125
Transaction Number The number of decimal positions defined AM135 AM145
of Decimals for the transaction currency. AM15.1 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 AM125
Current Period AM135 AM145
Depreciation AM15.1 AM15.2
AM15.3 AM15.4
AM154 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 AM125
Current Period Depr AM135 AM15.1
Allowed AM15.2 AM15.3
AM15.4 AM154
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
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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 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 AM125
Last Close This is the balance in the last-closed AM135 AM15.1
period for this book. AM15.2 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 AM125
Inactive This is the number of inactive months AM15.1 AM15.2
Year-to-Date for the book year-to-date. AM15.3 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 AM125
Inactive This is the number of inactive months AM15.1 AM15.2
Life-to-Date for the book life-to-date. AM15.3 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 AM125
Salvage Value The salvage value of the asset at the AM135 AM145
end of the asset's life. It can be zero. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
If the depreciation method is STL AM192 AM20.1
(Straight Line), the basis used for the AM20.2 AM20.3
depreciation calculation is the asset AM20.4 AM20.5
cost less this salvage value. AM20.6 AM21.1
AM21.2 AM21.3
If the depreciation method is DDB AM21.4 AM21.5
(Double Declining Balance), 150 (150% AM21.6 AM30.1
Declining Balance), or 175 (175% AM30.2 AM40.1
Declining Balance), the basis used for AM40.2 AM500
the depreciation calculation is the AM551 AM96.1
asset cost. Depreciation will be taken AM98.1
until the total amount taken is equal to
the asset cost less this salvage value.
ASB-BUS-PERCENT Signed 5.2 AM115 AM125
Business Percent AM15.1 AM15.2
AM15.3 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-PERSONAL-USE Alpha 10 AM115 AM125
Personal Use The personal use code assigned to the AM15.1 AM15.2
asset. A personal use code defines the AM15.3 AM15.4
personal use options that asset books AM170 AM20.1
use to calculate depreciation, tax AM20.2 AM20.3
credits, and annual depreciation limits AM20.4 AM20.5
up to twenty years. The code is user AM20.6 AM21.1
definable. AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM500 AM551
AM96.1 AM98.1
ASB-YR1-EXP Signed 15.2 AM115 AM125
First Year Expense This is the new first year expense AM135 AM145
amount. It represents the amount to AM15.1 AM15.2
expense for the First Year Expense AM15.3 AM15.4
option. This U.S. tax option allows you AM154 AM170
to expense and not depreciate a total AM192 AM20.1
dollar amount for the assets of each AM20.2 AM20.3
eligible company. 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-TC-TABLE Alpha 10 AM115 AM125
Tax Credit Table A user-defined tax credit table, which AM15.1 AM15.2
defines tax credit percentages and AM15.3 AM15.4
annual tax credit recapture percentages AM170 AM20.1
for up to twenty years. Asset books use AM20.2 AM20.3
tax credit tables to calculate tax AM20.4 AM20.5
credits. AM20.6 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 AM125
Tax Credit Property If you are taking a tax credit for used AM135 AM145
property, this field contains the amount AM15.1 AM15.2
that qualifies for the credit. 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-TAX-CREDIT Signed 15.2 AM115 AM125
Tax Credit This is the amount of tax credit taken AM135 AM145
for this asset. AM15.1 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 AM125
Insurance Method The method used to calculate insurance AM15.1 AM15.2
values for the asset. AM15.3 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 AM125
Insurance Actual The actual insurance value of the AM135 AM145
Value asset. AM15.1 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 AM125
Insurance Computed The calculated insurance value for the AM135 AM145
Value asset. AM15.1 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 AM125
Replacement Method The method used to calculate AM15.1 AM15.2
replacement values for the asset. AM15.3 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 AM125
Replacement The calculated replacement value for AM135 AM145
Computed Value the asset. AM15.1 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) AM115 AM125
Creation Date This is the date that this line was AM145 AM15.1
added to the requisition. AM15.2 AM15.3
AM15.4 AM154
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM40.1 AM40.2
AM500 AM551
AM98.1
ASB-CREATION-TIME Numeric 6 (hhmmss) AM115 AM125
Creation Time The creation time. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM40.1 AM40.2
AM500 AM551
AM98.1
ASB-CREATOR-ID Alpha 10 AM115 AM125
Creator ID AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM40.1 AM40.2
AM500 AM551
AM98.1
ASB-BOOK-DESC Derived
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
ASB-BK-YR-BEG-DATE Derived
Book Year-Begin Date
ASB-BK-PD-PER-YR Derived
Book Periods Per
Year
ASB-BK-DEPR-PD-CLS Derived
Book Depreciation
Period Close
ASB-BK-PD-CLOSE-DT Derived
Book Period Close
Date
ASB-BK-PD-CURR-DT Derived
Book Current Period
Close Date
ASB-BK-REQ Derived
Book Required
ASB-BK-POSTING Derived
Posting Book
ASB-BK-BOOK-STATUS Derived
Book Status
ASB-BK-CURRENCY-CD Derived
Currency Code
ASB-BK-METH-SWITCH Derived
Method Switch
ASB-BK-DEPR-TYPE Derived
Bk Depr Type
ASB-BK-HISTORY Derived
Bk History
ASB-TAG Derived
Tag The tag number assigned to the asset.
ASB-ASSET-GRP Derived
Asset Group
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
ASB-AST-STATUS Derived
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 AM125
Dsp Ytd This is the number of months that the AM15.1 AM15.2
asset has been disposed in the current AM15.3 AM15.4
year. This field gets cleared when the AM170 AM190
year rolls over. 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 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
AM145 AM220
AM260 AM267
AM278 AM285
AM287 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
Amclassdep AMCLASSDEP
AST-COMPANY -> CLD-COMPANY
ASB-BOOK -> CLD-BOOK
AST-ASSET-TYPE -> CLD-ASSET-TYPE
AST-SUB-TYPE -> CLD-SUB-TYPE
CLD-AST-ACCT-UNIT
CLD-EXP-ACCT-UNIT
CLD-ACM-ACCT-UNIT
CLD-YR-END-DATE
CLD-PERIOD
Amtrans AMTRANS
ASB-ASSET -> AMT-ASSET
"R" -> AMT-TRANS-STATUS
AMC-COMPANY -> AMT-COMPANY
ASB-BOOK -> AMT-BOOK
AMT-SEQ-NUMBER
Amtypalloc AMTYPALLOC
AST-COMPANY -> ALL-COMPANY
AST-ASSET-TYPE -> ALL-ASSET-TYPE
AST-SUB-TYPE -> ALL-SUB-TYPE
ALL-START-DATE
ALL-SEQUENCE-NBR
|