AMASTBKDSP

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 AM267 AM287
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 AC160
AM115 AM117 AM125 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM21.1 AM21.2 AM21.3
AM21.4 AM21.5 AM21.6 AM22.1 AM22.2 AM330
AM500 AM551 AM96.1 AM98.1 AP115 AP125
AP126 AP131 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
AP510 API1.1 API2.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 MA126 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABD-ASSET
Element: Asset
Numeric 10
Key field. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.
AM145 AM154
AM40.1 AM40.2
ABD-BOOK
Element: Book
Alpha 10
Key field. This field contains a user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.
AM145 AM154
AM40.1 AM40.2
AM520
ABD-BOOK-COST-SALE
Element: Book Cost of Sale
Signed 18.2
This is the cost of sale for the asset disposal.
AM145 AM154
AM40.1 AM40.2
AM40.3
ABD-CST-SALE-OVRRD
Cost of Sale
Override
Signed 18.2
This is the overriding amount for the book cost of sale.
AM145 AM154
AM40.1 AM40.2
ABD-BOOK-PROCEEDS
Element: Book Proceeds
Signed 18.2
This field contains the proceeds for the asset disposal.
AM145 AM154
AM40.1 AM40.2
AM40.3
ABD-PROCEEDS-OVRRD
Element: Proceeds Override
Signed 18.2
This is the overriding amount for the book proceeds from the disposal.
AM145 AM154
AM40.1 AM40.2
ABD-GAIN-LOSS
Element: Gain or Loss
Signed 18.2
This field contains the gain or loss for the asset disposal.
AM40.1 AM40.2
ABD-GN-LS-OVERRIDE
Gain or Loss
Override
Signed 18.2
This field contains the gain or loss override for the asset disposal.
AM145 AM154
AM192 AM40.1
AM40.2 AM40.3
ABD-DEFER-GN-LS
Deferred Gain or
Loss
Signed 18.2
This field contains the deferred gain or loss for the asset disposal.
ABD-DEFER-OVERRIDE
Deferred Gain or
Loss Override
Signed 18.2
This field contains the deferred gain or loss override for the asset disposal.
AM40.3
ABD-TC-RECAPTURE
Element: Tax Credit Recapture
Signed 18.2
This is the tax credit recapture amount for the asset disposal.
AM40.1 AM40.2
AM40.3
ABD-TC-OVERRIDE
Element: Tax Credit Override
Signed 18.2
This is the tax credit recapture override for the asset disposal.
ABD-BOOK-BASIS
Element: Book Basis
Signed 18.2
This field contains the amount on which the depreciation calculations for the disposed asset are based. Note: The depreciation basis amount can be different for each depreciation book used.
AM145 AM154
AM40.1 AM40.2
ABD-TRAN-ND
Transaction Number
of Decimals
Numeric 1
The number of decimal positions defined for the transaction currency.
AM145 AM154
AM40.1 AM40.2
ABD-DSP-DEPR
Disposal
Depreciation
Signed 18.2
This is the depreciation expense associated with the disposal.
AM145 AM154
AM40.1 AM40.2
ABD-DSP-DEPR-OVRRD
Depreciation
Override
Signed 18.2
This is the depreciation expense override amount associated with the disposal.
AM145 AM154
AM192 AM40.1
AM40.2 AM40.3
ABD-DEPR-YTD
Year-to-Date
Depreciation
Signed 18.2
This is the year-to-date depreciation for the disposed asset.
AM145 AM154
AM40.1 AM40.2
ABD-DEPR-YTD-ALLOW
Year-to-Date Depr
Allowance
Signed 18.2
This is the year-to-date depreciation allowance for the disposed asset.
AM145 AM154
AM40.1 AM40.2
ABD-DEPR-YTD-OVRRD
Year-to-Date Depr
Override
Signed 18.2
This is the year-to-date depreciation override for the disposed asset.
AM145 AM154
AM40.1 AM40.2
ABD-DEPR-LTD
Life-to-Date
Depreciation
Signed 18.2
This is the life-to-date depreciation for the disposed-of asset.
AM145 AM154
AM40.1 AM40.2
ABD-DEPR-LTD-ALLOW
Life-to-Date Depr
Allowance
Signed 18.2
This is the life-to-date depreciation allowance for the disposed asset.
AM145 AM154
AM40.1 AM40.2
ABD-SALVAGE-VALUE
Element: Salvage Value
Signed 18.2
This is the salvage value of the asset, 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.
AM145 AM154
AM40.1 AM40.2
ABD-YR1-EXP
Element: First Year Expense
Signed 18.2
This is the new first year expense 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.
AM145 AM154
AM40.1 AM40.2
ABD-TC-PROPERTY
Element: Property Tax Credit
Signed 18.2
This is the tax credit amount for the asset, if you are taking a tax credit for used property.
AM145 AM154
AM40.1 AM40.2
ABD-TAX-CREDIT
Element: Tax Credit
Signed 18.2
This is the tax credit amount for the asset.
AM145 AM154
AM40.1 AM40.2
ABD-INS-ACT-VAL
Actual Insurance
Value
Signed 18.2
This is the actual insurance value for the asset.
AM145 AM154
AM40.1 AM40.2
ABD-INS-CMPTD-VAL
Computed Insurance
Value
Signed 18.2
This is the computed insurance value for the asset.
AM145 AM154
AM40.1 AM40.2
ABD-RPL-CMPTD-VAL
Computed
Replacement Value
Signed 18.2
This is the computed replacement value for the asset.
AM145 AM154
AM40.1 AM40.2
ABD-NEW-AST-BASIS
Element: New Asset Basis
Signed 18.2
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
Element: Cash Paid
Signed 18.2
This is the amount of cash paid in the asset disposal.
ABD-OLD-AST-ADJ-BS
Old Asset Adjusted
Basis
Signed 18.2
This is the adjusted basis for the old asset.
ABD-AMT-REALIZED
Element: Amount Realized
Signed 18.2
This is the amount realized through the disposal.
ABD-AMT-GIVEN-UP
Element: Amount Given Up
Signed 18.2
This is the amount of depreciation given up as a result of the disposal.
ABD-NEW-AST-ADJ-BS
New Asset Adjusted
Basis
Signed 18.2
If the disposal is a partial disposal, a new asset must be defined. This is the adjusted basis for the new asset.
ABD-NEW-ASSET
Element: New Asset
Numeric 10
If the disposal is a partial disposal, a new asset must be defined. This is the new asset number.
ABD-AST-DSP-ASSET
Element: Disposal Asset
Derived
This is the number of the disposed-of asset.
ABD-AST-ASSET-GRP
Element: Asset Group
Derived
This is the asset group for the new asset.
ABD-AST-TAG-NBR
Element: Tag Number
Derived
This is the tag for the new asset.
ABD-AST-DESCRIP
Element: Asset Description
Derived
This is the new asset description.
ABD-ASD-DSP-DATE
Element: Disposal Date
Derived
This is the effective date for the asset disposal.
ABD-ASD-FULL-PART
Element: Full or Partial
Derived
This field indicates whether the disposal is a full or partial disposal.
ABD-ASD-DSP-METH
Element: Disposal Method
Derived
This is the way in which the asset was disposed of.
ABD-ASD-DSP-PROP
Element: Disposal Property
Derived
This is the user-defined name of a disposal property. It represents a kind of disposed-of asset.
ABD-BOOK-CURRENCY
Element: Book Currency
Derived
This is the currency for the book.
ABD-DSP-CREAT-DATE
Element: Creation Date
Derived
This is the creation date for the disposal.
ABD-DSP-CREAT-TIME
Element: Creation Time
Derived
This is the creation time for the disposal.
ABD-DSP-CREATOR-ID
Element: Creator ID
Derived
This is the ID of the person who created the disposal.
ABD-AMB-DESC
Element: Description
Derived
This is the description of the book.
ABD-ASB-BOOK-BASIS
Element: Book Basis
Derived
This field contains the amount on which the depreciation calculations for the book are based.
ABD-ASB-METHOD
Element: Method
Derived
This is the asset book depreciation method.
ABD-ASB-LIFE
Element: Life
Derived
This is the life of the asset.
ABD-ASB-LIFE-REM
Element: Life Remaining
Derived
This is the remaining life for the asset.
ABD-ASB-INSRV-DATE
Element: In Service Date
Derived
This is the in-service date for the asset.
ABD-ASB-CONVENTION
Element: Convention
Derived
This is the in-service convention for the asset.
ABD-DSP-OVERRIDE
Element: Disposal Override
Derived
The word "OVERRIDE" displays if the disposal amount has been overridden.
ABD-PROC-OVERRIDE
Element: Proceeds Override
Derived
The word "OVERRIDE" displays if the proceeds amount has been overridden.
ABD-COS-OVERRIDE
Cost of Sales
Override
Derived
The word "OVERRIDE" displays if the expense amount has been overridden.
ABD-DEFR-OVERRIDE
Deferred Gain or
Loss Override
Derived
The word "OVERRIDE" displays if the deferred gain or loss amount has been overridden.
ABD-TCRECAP-OVERRD
Tax Credit
Recapture Override
Derived
The word "OVERRIDE" displays if the tax credit recapture amount has been overridden.
ABD-CALC-DEPR-LTD
Element: Calc Depr Ltd
Derived
This is the life-to-date calculated depreciation
ABD-DSP-NET-VALUE
Element: Disposal Net Value
Derived
The Disposal Net Value is calculated as follows: Book Basis - Life-to-Date Depreciation.
ABD-AST-LOCATION
Element: Ast Location
Derived
This is the location associated with the asset.
ABD-AST-DIVISION
Element: Ast Division
Derived
This is the division associated with the asset.
ABD-AST-TYPE
Element: Ast Type
Derived
This is the type associated with the asset.
ABD-AST-SUBTYPE
Element: Ast Subtype
Derived
This is the subtype associated with the asset.


AMASTBKDSP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABDSET1 ASSET
BOOK
...
AC160 AM115
AM117 AM125
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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
AM22.1 AM22.2
AM240 AM255
ABDSET2 BOOK
ASSET
AM95.1 AM95.2
AM95.4 AM95.5
AM95.6


AMASTBKDSP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:04:58 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.