AMASTBKDSP FILE
Asset Book Disposal
This file contains historical asset book information related to disposals
from AM40.1 (Disposals), AM40.2 (Items), and AM40.3 (Gain or Loss).
REFERENCED BY
AM240 AM255 AM260 AM265 AM292 AMDL.1
AM95.1 AM95.2 AM95.4 AM95.5 AM95.6
UPDATED BY
AM145 AM154 AM170 AM192 AM300 AM310
AM40.1 AM40.2 AM40.3 AM41.1 AM520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABD-ASSET Numeric 10 AM145 AM154
Asset Key field. The asset number contains up AM40.1 AM40.2
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
ABD-BOOK Alpha 10 AM145 AM154
Book Key field. This field contains a AM40.1 AM40.2
user-defined book name. Books are used AM520
by assets for calculating depreciation,
replacement cost, and insurance values,
and for reporting.
ABD-BOOK-COST-SALE Signed 15.2 AM145 AM154
Book Cost of Sale This is the cost of sale for the asset AM40.1 AM40.2
disposal.
ABD-CST-SALE-OVRRD Signed 15.2 AM145 AM154
Cost of Sale This is the overriding amount for the AM40.1 AM40.2
Override book cost of sale. AM40.3
ABD-BOOK-PROCEEDS Signed 15.2 AM145 AM154
Book Proceeds This field contains the proceeds for AM40.1 AM40.2
the asset disposal.
ABD-PROCEEDS-OVRRD Signed 15.2 AM145 AM154
Proceeds Override This is the overriding amount for the AM40.1 AM40.2
book proceeds from the disposal. AM40.3
ABD-GAIN-LOSS Signed 15.2 AM40.1 AM40.2
Gain or Loss This field contains the gain or loss
for the asset disposal.
ABD-GN-LS-OVERRIDE Signed 15.2 AM145 AM154
Gain or Loss This field contains the gain or loss AM192 AM40.1
Override override for the asset disposal. AM40.2 AM40.3
ABD-DEFER-GN-LS Signed 15.2
Deferred Gain or This field contains the deferred gain
Loss or loss for the asset disposal.
ABD-DEFER-OVERRIDE Signed 15.2 AM40.3
Deferred Gain or This field contains the deferred gain
Loss Override or loss override for the asset disposal.
ABD-TC-RECAPTURE Signed 15.2 AM40.1 AM40.2
Tax Credit Recapture This is the tax credit recapture amount AM40.3
for the asset disposal.
ABD-TC-OVERRIDE Signed 15.2
Tax Credit Override This is the tax credit recapture
override for the asset disposal.
ABD-BOOK-BASIS Signed 15.2 AM145 AM154
Book Basis This field contains the amount on which AM40.1 AM40.2
the depreciation calculations for the
disposed asset are based.
Note: The depreciation basis amount can
be different for each depreciation book
used.
ABD-TRAN-ND Numeric 1 AM145 AM154
Transaction Number The number of decimal positions defined AM40.1 AM40.2
of Decimals for the transaction currency.
ABD-DSP-DEPR Signed 15.2 AM145 AM154
Disposal This is the depreciation expense AM40.1 AM40.2
Depreciation associated with the disposal.
ABD-DSP-DEPR-OVRRD Signed 15.2 AM145 AM154
Depreciation This is the depreciation expense AM192 AM40.1
Override override amount associated with the AM40.2 AM40.3
disposal.
ABD-DEPR-YTD Signed 15.2 AM145 AM154
Year-to-Date This is the year-to-date depreciation AM40.1 AM40.2
Depreciation for the disposed asset.
ABD-DEPR-YTD-ALLOW Signed 15.2 AM145 AM154
Year-to-Date Depr This is the year-to-date depreciation AM40.1 AM40.2
Allowance allowance for the disposed asset.
ABD-DEPR-YTD-OVRRD Signed 15.2 AM145 AM154
Year-to-Date Depr This is the year-to-date depreciation AM40.1 AM40.2
Override override for the disposed asset.
ABD-DEPR-LTD Signed 15.2 AM145 AM154
Life-to-Date This is the life-to-date depreciation AM40.1 AM40.2
Depreciation for the disposed-of asset.
ABD-DEPR-LTD-ALLOW Signed 15.2 AM145 AM154
Life-to-Date Depr This is the life-to-date depreciation AM40.1 AM40.2
Allowance allowance for the disposed asset.
ABD-SALVAGE-VALUE Signed 15.2 AM145 AM154
Salvage Value This is the salvage value of the asset, AM40.1 AM40.2
or value remaining, at the end of the
asset's life. It can be zero.
If the depreciation method is SL
(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), 125DB (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.
ABD-YR1-EXP Signed 15.2 AM145 AM154
First Year Expense This is the new first year expense AM40.1 AM40.2
amount for the 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.
ABD-TC-PROPERTY Signed 15.2 AM145 AM154
Property Tax Credit This is the tax credit amount for the AM40.1 AM40.2
asset, if you are taking a tax credit
for used property.
ABD-TAX-CREDIT Signed 15.2 AM145 AM154
Tax Credit This is the tax credit amount for the AM40.1 AM40.2
asset.
ABD-INS-ACT-VAL Signed 15.2 AM145 AM154
Actual Insurance This is the actual insurance value for AM40.1 AM40.2
Value the asset.
ABD-INS-CMPTD-VAL Signed 15.2 AM145 AM154
Computed Insurance This is the computed insurance value AM40.1 AM40.2
Value for the asset.
ABD-RPL-CMPTD-VAL Signed 15.2 AM145 AM154
Computed This is the computed replacement value AM40.1 AM40.2
Replacement Value for the asset.
ABD-NEW-AST-BASIS Signed 15.2
New Asset Basis If the disposal is a partial disposal,
a new asset must be defined. This field
contains the new asset basis, or the
amount on which depreciation
calculations for the new asset are
based.
ABD-CASH-PAID Signed 15.2
Cash Paid This is the amount of cash paid in the
asset disposal.
ABD-OLD-AST-ADJ-BS Signed 15.2
Old Asset Adjusted This is the adjusted basis for the old
Basis asset.
ABD-AMT-REALIZED Signed 15.2
Amount Realized This is the amount realized through the
disposal.
ABD-AMT-GIVEN-UP Signed 15.2
Amount Given Up This is the amount of depreciation
given up as a result of the disposal.
ABD-NEW-AST-ADJ-BS Signed 15.2
New Asset Adjusted If the disposal is a partial disposal,
Basis a new asset must be defined. This is the
adjusted basis for the new asset.
ABD-NEW-ASSET Numeric 10
New Asset If the disposal is a partial disposal,
a new asset must be defined. This is the
new asset number.
ABD-AST-DSP-ASSET Derived
Disposal Asset This is the number of the disposed-of
asset.
ABD-AST-ASSET-GRP Derived
Asset Group This is the asset group for the new
asset.
ABD-AST-TAG-NBR Derived
Tag Number This is the tag for the new asset.
ABD-AST-DESCRIP Derived
Asset Description This is the new asset description.
ABD-ASD-DSP-DATE Derived
Disposal Date This is the effective date for the
asset disposal.
ABD-ASD-FULL-PART Derived
Full or Partial This field indicates whether the
disposal is a full or partial disposal.
ABD-ASD-DSP-METH Derived
Disposal Method This is the way in which the asset was
disposed of.
ABD-ASD-DSP-PROP Derived
Disposal Property This is the user-defined name of a
disposal property. It represents a kind
of disposed-of asset.
ABD-BOOK-CURRENCY Derived
Book Currency This is the currency for the book.
ABD-DSP-CREAT-DATE Derived
Creation Date This is the creation date for the
disposal.
ABD-DSP-CREAT-TIME Derived
Creation Time This is the creation time for the
disposal.
ABD-DSP-CREATOR-ID Derived
Creator ID This is the ID of the person who
created the disposal.
ABD-AMB-DESC Derived
Description This is the description of the book.
ABD-ASB-BOOK-BASIS Derived
Book Basis This field contains the amount on which
the depreciation calculations for the
book are based.
ABD-ASB-METHOD Derived
Method This is the asset book depreciation
method.
ABD-ASB-LIFE Derived
Life This is the life of the asset.
ABD-ASB-LIFE-REM Derived
Life Remaining This is the remaining life for the
asset.
ABD-ASB-INSRV-DATE Derived
In Service Date This is the in-service date for the
asset.
ABD-ASB-CONVENTION Derived
Convention This is the in-service convention for
the asset.
ABD-DSP-OVERRIDE Derived
Disposal Override The word "OVERRIDE" displays if the
disposal amount has been overridden.
ABD-PROC-OVERRIDE Derived
Proceeds Override The word "OVERRIDE" displays if the
proceeds amount has been overridden.
ABD-COS-OVERRIDE Derived
Cost of Sales The word "OVERRIDE" displays if the
Override expense amount has been overridden.
ABD-DEFR-OVERRIDE Derived
Deferred Gain or The word "OVERRIDE" displays if the
Loss Override deferred gain or loss amount has been
overridden.
ABD-TCRECAP-OVERRD Derived
Tax Credit The word "OVERRIDE" displays if the tax
Recapture Override credit recapture amount has been
overridden.
ABD-CALC-DEPR-LTD Derived
Calc Depr Ltd This is the life-to-date calculated
depreciation
ABD-DSP-NET-VALUE Derived
Disposal Net Value The Disposal Net Value is calculated as
follows: Book Basis - Life-to-Date
Depreciation.
ABD-AST-LOCATION Derived
Ast Location This is the location associated with
the asset.
ABD-AST-DIVISION Derived
Ast Division This is the division associated with
the asset.
ABD-AST-TYPE Derived
Ast Type This is the type associated with the
asset.
ABD-AST-SUBTYPE Derived
Ast Subtype This is the subtype associated with the
asset.
AMASTBKDSP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABDSET1 ASSET This index accesses information by AM145 AM154
BOOK asset and book. AM170 AM192
AM240 AM255
AM260 AM265
AM292 AM300
AM310 AM40.1
AM40.2 AM40.3
AM41.1 AM520
AMDL.1
ABDSET2 BOOK This index accesses information by book AM95.1 AM95.2
ASSET and asset. AM95.4 AM95.5
AM95.6
AMASTBKDSP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
Valid When ABD-ASSET != Zeroes
ABD-ASSET -> AST-ASSET
Amassetdsp AMASSETDSP Not Required
ABD-ASSET -> ASD-ASSET
Amastbook AMASTBOOK Not Required
ABD-ASSET -> ASB-ASSET
ABD-BOOK -> ASB-BOOK
Amasttype AMASTTYPE Not Required
AST-COMPANY -> ATP-COMPANY
AST-ASSET-TYPE -> ATP-ASSET-TYPE
AST-SUB-TYPE -> ATP-SUB-TYPE
Ambook AMBOOK Not Required
ABD-BOOK -> AMB-BOOK
Amdivision AMDIVISION Not Required
AST-DIVISION -> DIV-DIVISION
Amlocation AMLOCATION Not Required
AST-LOCATION-NAME -> LOC-LOCATION-NAME
|
