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 AMAS.1 AMBK.1
AMBL.1 MX500


UPDATED BY
AM145 AM154 AM170 AM192 AM300 AM40.1
AM40.2 AM41.1 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 AM240
AM330 AM500 AM551 AM96.1 AM98.1 AMDL.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 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POII.1 POIJ.1

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
...
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
AM220 AM221


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: Wed Jun 08 20:47:03 2016

Home
Contact Us



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