|
|
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 AM260 AM265 AM292 AM95.1 AM95.2
UPDATED BY
AM145 AM192 AM300 AM310 AM40.1 AM40.2
AM40.3 AM520 AM700 AM956
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABD-ASSET Numeric 10 AM145 AM40.1
Asset Key field. The asset number contains up AM40.2 AM956
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
ABD-BOOK Alpha 10 AM145 AM40.1
Book Key field. This field contains a AM40.2 AM520
user-defined book name. Books are used AM956
by assets for calculating depreciation,
replacement cost, and insurance values,
and for reporting.
ABD-BOOK-COST-SALE Signed 15.2 AM145 AM40.1
Book Cost of Sale This is the cost of sale for the asset AM40.2 AM956
disposal.
ABD-CST-SALE-OVRRD Signed 15.2 AM145 AM40.1
Cost of Sale This is the overriding amount for the AM40.2 AM40.3
Override book cost of sale. AM956
ABD-BOOK-PROCEEDS Signed 15.2 AM145 AM40.1
Book Proceeds This field contains the proceeds for AM40.2 AM956
the asset disposal.
ABD-PROCEEDS-OVRRD Signed 15.2 AM145 AM40.1
Proceeds Override This is the overriding amount for the AM40.2 AM40.3
book proceeds from the disposal. AM956
ABD-GAIN-LOSS Signed 15.2 AM40.1 AM40.2
Gain or Loss This field contains the gain or loss AM956
for the asset disposal.
ABD-GN-LS-OVERRIDE Signed 15.2 AM145 AM192
Gain or Loss This field contains the gain or loss AM40.1 AM40.2
Override override for the asset disposal. AM40.3 AM956
ABD-DEFER-GN-LS Signed 15.2 AM956
Deferred Gain or This field contains the deferred gain
Loss or loss for the asset disposal.
ABD-DEFER-OVERRIDE Signed 15.2 AM40.3 AM956
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 AM956
for the asset disposal.
ABD-TC-OVERRIDE Signed 15.2 AM956
Tax Credit Override This is the tax credit recapture
override for the asset disposal.
ABD-BOOK-BASIS Signed 15.2 AM145 AM40.1
Book Basis This field contains the amount on which AM40.2 AM956
the depreciation calculations for the
book are based.
Note: The depreciation basis amount can
be different for each depreciation book
used.
ABD-TRAN-ND Numeric 1 AM145 AM40.1
Transaction Number The number of decimal positions defined AM40.2 AM956
of Decimals for the transaction currency.
ABD-DSP-DEPR Signed 15.2 AM145 AM40.1
Disposal This is the depreciation expense AM40.2 AM956
Depreciation associated with the disposal.
ABD-DSP-DEPR-OVRRD Signed 15.2 AM145 AM192
Depreciation This is the depreciation expense AM40.1 AM40.2
Override override amount associated with the AM40.3 AM956
disposal.
ABD-DEPR-YTD Signed 15.2 AM145 AM40.1
Year-to-Date This is the year-to-date depreciation AM40.2 AM956
Depreciation for the disposed-of asset.
ABD-DEPR-YTD-ALLOW Signed 15.2 AM145 AM40.1
Year-to-Date Depr This is the year-to-date depreciation AM40.2 AM956
Allowance
allowance for the disposed-of asset.
ABD-DEPR-YTD-OVRRD Signed 15.2 AM145 AM40.1
Year-to-Date Depr This is the year-to-date depreciation AM40.2 AM956
Override
override for the disposed-of asset.
ABD-DEPR-LTD Signed 15.2 AM145 AM40.1
Life-to-Date This is the life-to-date depreciation AM40.2
Depreciation
for the disposed-of asset.
ABD-DEPR-LTD-ALLOW Signed 15.2 AM145 AM40.1
Life-to-Date Depr This is the life-to-date depreciation AM40.2 AM956
Allowance
allowance for the disposed-of asset.
ABD-SALVAGE-VALUE Signed 15.2 AM145 AM40.1
Salvage Value This is the salvage value of the asset, AM40.2 AM956
or value remaining, 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), 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-1YR-EXP Signed 15.2 AM700
Old First Year This is the old first year expense
Expense amount for the asset.
ABD-YR1-EXP Signed 15.2 AM145 AM40.1
New First Year This is the new first year expense AM40.2 AM700
Expense amount for the asset. It represents the AM956
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 AM40.1
Property Tax Credit This is the tax credit amount for the AM40.2 AM956
asset, if you are taking a tax credit
for used property.
ABD-TAX-CREDIT Signed 15.2 AM145 AM40.1
Tax Credit This is the tax credit amount for the AM40.2 AM956
asset.
ABD-INS-ACT-VAL Signed 15.2 AM145 AM40.1
Actual Insurance This is the actual insurance value for AM40.2 AM956
Value the asset.
ABD-INS-CMPTD-VAL Signed 15.2 AM145 AM40.1
Computed Insurance This is the computed insurance value AM40.2 AM956
Value for the asset.
ABD-RPL-CMPTD-VAL Signed 15.2 AM145 AM40.1
Computed This is the computed replacement value AM40.2 AM956
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.
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-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
ABD-AST-DIVISION Derived
Ast Division
ABD-AST-TYPE Derived
Ast Type
ABD-AST-SUBTYPE Derived
Ast Subtype
AMASTBKDSP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABDSET1 ASSET AM145 AM192
BOOK AM240 AM260
AM265 AM292
AM300 AM310
AM40.1 AM40.2
AM40.3 AM520
AM700 AM956
ABDSET2 BOOK AM95.1 AM95.2
ASSET
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
|