AMASSETDSP

Asset Disposal

This file contains historical asset information related to disposals. It is updated by AM40.1 (Disposals).

REFERENCED BY
AM120 AM135 AM155 AM190 AM220 AM221
AM222 AM223 AM224 AM225 AM23.3 AM230
AM235 AM240 AM245 AM25.2 AM250 AM255
AM260 AM265 AM267 AM275 AM277 AM278
AM280 AM281 AM285 AM287 AM290 AM292
AM295 AM30.1 AM30.2 AM30.3 AM310 AM320
AM35.1 AM45.1 AM501 AM502 AM70.4 AM88.1
AM92.1 AM95.1 AM95.2 AM95.4 AM95.5 AM95.6
AMAS.1 AMBK.1 AMBL.1 AMDL.1 MX500


UPDATED BY
AM145 AM154 AM170 AM192 AM300 AM40.1
AM40.2 AM41.1 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
ASD-ASSET
Element: Asset
Numeric 10
Required. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.
AM145 AM154
AM40.1 AM41.1
ASD-DSP-STATUS
Element: Disposal Status
Alpha 1
This field indicates the status of the disposal. Valid values are: R = Released N = Not Released
AM145 AM154
AM170 AM40.1
ASD-DSP-DATE
Element: Disposal Date
Numeric 8 (yyyymmdd)
This is the date of the disposal.
AM145 AM154
AM40.1
ASD-DSP-METHOD
Element: Disposal Method
Alpha 1
This field indicates the way in which the asset was disposed of. Valid values are: A = Abandoned D = Donated E = Exchanged P = Purged R = Retired S = Sold T = Traded O = Other
AM145 AM154
AM40.1
ASD-DSP-PROPERTY
Element: Disposal Property
Alpha 10
This is the user-defined name of a disposal property. It represents a kind of disposed-of asset.
AM145 AM40.1
ASD-DSP-QUANTITY
Element: Disposal Quantity
Numeric 10
This field indicates the asset quantity disposed of.
AM145 AM154
AM40.1 AM40.2
ASD-LEASE-COMPANY
Element: Company
Numeric 4
The lessor company for the disposed leased asset.
AM154 AM40.1
ASD-LEASE
Element: Lease
Alpha 19
The lease number associated with the disposed leased asset.
AM154 AM40.1
ASD-ASSET-GROUP
Element: Asset Group
Alpha 10
The asset group assigned to the disposed leased asset.
AM145 AM154
AM40.1
ASD-FULL-PARTIAL
Element: Full Partial
Alpha 1
This field indicates whether the disposal was full (including all asset items) or partial (including only some asset items). Valid values are: F = Full P = Partial
AM145 AM154
AM40.1
ASD-PROCEEDS-CURR
Element: Proceeds Currency
Alpha 5
This is the currency for the Proceeds account.
AM145 AM40.1
ASD-PROCEEDS
Element: Proceeds
Signed 18.2
This field contains the proceeds of the sale of this asset based on the book value in this record.
AM145 AM154
AM40.1
ASD-COST-SALE-CURR
Element: Cost Sale Currency
Alpha 5
This is the currency for the cost of the sale of the asset.
AM145 AM40.1
ASD-COST-SALE
Element: Cost Sale
Signed 18.2
This is the cost of the sale of the asset.
AM145 AM154
AM40.1
ASD-ITEM-TOT-QTY
Element: Item Total Quantity
Numeric 10
This is the total item quantity for the disposal.
AM145 AM154
AM40.1 AM40.2
ASD-IT-TOT-CSTBASE
Element: Item Total Cost Base
Signed 18.2
This is the total item cost in the base currency.
AM145 AM154
AM40.1 AM40.2
ASD-IT-TOT-CSTTRAN
Element: Item Total Cost Tran
Signed 18.2
This is the total item cost in the transaction currency.
AM145 AM154
AM40.1 AM40.2
ASD-IT-TOT-TAXBASE
Element: Item Total Tax Base
Signed 18.2
This is the total item tax in the base currency.
AM145 AM154
AM40.1 AM40.2
ASD-IT-TOT-TAXTRAN
Element: Item Total Tax Tran
Signed 18.2
This is the total item tax in the transaction currency.
AM145 AM154
AM40.1 AM40.2
ASD-BASE-ND
Base Number of
Decimals
Numeric 1
The number of decimal positions defined for the company base currency.
AM145 AM154
AM40.1
ASD-TRAN-ND
Tran Number of
Decimals
Numeric 1
The number of decimal positions defined for the transaction currency.
AM145 AM154
AM40.1
ASD-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AM145 AM154
AM40.1
ASD-ITEM-LAST-DATE
Element: Item Last Date
Numeric 8 (yyyymmdd)
This is the last changed date for the record.
AM145 AM154
AM40.1
ASD-ITEM-LAST-SEQ
Element: Item Last Sequence
Numeric 6
This is the last sequence number for the last change to the record.
AM145 AM154
AM40.1
ASD-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date that the disposal record was created.
AM145 AM154
AM40.1
ASD-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
This is the time the disposal record was created.
AM145 AM154
AM40.1
ASD-CREATOR-ID
Element: Creator ID
Alpha 10
This is the ID of the person creating the disposal record.
AM145 AM154
AM40.1
ASD-AST-DSP-ASSET
Element: Ast Dsp Asset
Derived
This is the disposal asset.
ASD-AST-TAG-NBR
Element: Ast Tag Nbr
Derived
This is the asset tag number. A tag number is a user-definable identifier assigned to an asset.
ASD-AST-ASSET-GRP
Element: Ast Asset Grp
Derived
This is the asset group for the disposed-of asset. An asset group represents a parent asset number used to group assets for reporting.
ASD-AST-DESCRIP
Element: Ast Descrip
Derived
This is the asset description for the disposed-of asset.


AMASSETDSP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASDSET1 ASSET
...
AC160 AM115
AM117 AM120
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 AM170
AM19.1 AM19.2
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


AMASSETDSP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
ASD-ASSET->AST-ASSET
Amdspprop AMDSPPROP Not Required
ASD-DSP-PROPERTY->DSP-DSP-PROPERTY


AMASSETDSP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amastbkdsp AMASTBKDSP
ASD-ASSET->ABD-ASSET
  ABD-BOOK


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

Home
Contact Us



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