AMASSETDSP

Asset Disposal

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

REFERENCED BY
AM120 AM135 AM190 AM220 AM221 AM222
AM223 AM224 AM225 AM23.3 AM230 AM235
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 AMBL.1 MX500
AMAS.1 AMBK.1 AMDL.1


UPDATED BY
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 AM240 AM300 AM330
AM40.1 AM40.2 AM41.1 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 API1.1 API2.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC140 IC66.1
IC83.1 MA180 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 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 PO100
PO101 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO28.2 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
RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIF.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 ZW130

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.
AM154
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
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 AM22.1


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 11:05:33 2016

Home
Contact Us



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