AMASSETDSP FILE
Asset Disposal
This file contains historical asset information related to disposals. It is
updated by AM40.1 (Disposals).
REFERENCED BY
AM115 AM120 AM125 AM135 AM15.1 AM15.2
AM15.3 AM15.4 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 AM222 AM223
AM224 AM225 AM23.3 AM230 AM235 AM240
AM245 AM25.2 AM250 AM255 AM260 AM265
AM275 AM277 AM278 AM280 AM281 AM285
AM290 AM292 AM295 AM30.1 AM30.2 AM320
AM35.1 AM45.1 AM500 AM551 AM70.4 AM88.1
AM95.1 AM95.2 AM95.4 AM95.5 AM95.6 AM96.1
AM98.1 AMAS.1 AMBK.1 AMBL.1 AMDL.1 MX500
UPDATED BY
AM145 AM154 AM170 AM192 AM300 AM40.1
AM40.2 AM41.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASD-ASSET Numeric 10 AM145 AM154
Asset Required. The asset number contains up AM40.1 AM41.1
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
ASD-DSP-STATUS Alpha 1 AM145 AM154
Disposal Status This field indicates the status of the AM170 AM40.1
disposal. Valid values are:
R = Released
N = Not Released
ASD-DSP-DATE Numeric 8 (yyyymmdd) AM145 AM154
Disposal Date This is the date of the disposal. AM40.1
ASD-DSP-METHOD Alpha 1 AM145 AM154
Disposal Method This field indicates the way in which AM40.1
the asset was disposed of. Valid values
are:
A = Abandoned
D = Donated
E = Exchanged
P = Purged
R = Retired
S = Sold
T = Traded
O = Other
ASD-DSP-PROPERTY Alpha 10 AM145 AM40.1
Disposal Property This is the user-defined name of a
disposal property. It represents a kind
of disposed-of asset.
ASD-DSP-QUANTITY Numeric 10 AM145 AM154
Disposal Quantity This field indicates the asset quantity AM40.1
disposed of.
ASD-LEASE-COMPANY Numeric 4 AM154 AM40.1
Lease Company The lessor company for the disposed
leased asset.
ASD-LEASE Alpha 19 AM154 AM40.1
Lease The lease number associated with the
disposed leased asset.
ASD-ASSET-GROUP Alpha 10 AM154
Asset Group The asset group assigned to the
disposed leased asset.
ASD-FULL-PARTIAL Alpha 1 AM145 AM154
Full Partial This field indicates whether the AM40.1
disposal was full (including all asset
items) or partial (including only some
asset items). Valid values are:
F = Full
P = Partial
ASD-PROCEEDS-CURR Alpha 5 AM145 AM40.1
Proceeds Currency This is the currency for the Proceeds
account.
ASD-PROCEEDS Signed 15.2 AM145 AM154
Proceeds This field contains the proceeds of the AM40.1
sale of this asset based on the book
value in this record.
ASD-COST-SALE-CURR Alpha 5 AM145 AM40.1
Cost Sale Currency This is the currency for the cost of
the sale of the asset.
ASD-COST-SALE Signed 15.2 AM145 AM154
Cost Sale This is the cost of the sale of the AM40.1
asset.
ASD-ITEM-TOT-QTY Numeric 10 AM145 AM154
Item Total Quantity This is the total item quantity for the AM40.1 AM40.2
disposal.
ASD-IT-TOT-CSTBASE Signed 15.2 AM145 AM154
Item Total Cost Base This is the total item cost in the base AM40.1 AM40.2
currency.
ASD-IT-TOT-CSTTRAN Signed 15.2 AM145 AM154
Item Total Cost Tran This is the total item cost in the AM40.1 AM40.2
transaction currency.
ASD-IT-TOT-TAXBASE Signed 15.2 AM145 AM154
Item Total Tax Base This is the total item tax in the base AM40.1 AM40.2
currency.
ASD-IT-TOT-TAXTRAN Signed 15.2 AM145 AM154
Item Total Tax Tran This is the total item tax in the AM40.1 AM40.2
transaction currency.
ASD-BASE-ND Numeric 1 AM145 AM154
Base Number of The number of decimal positions defined AM40.1
Decimals for the company base currency.
ASD-TRAN-ND Numeric 1 AM145 AM154
Tran Number of The number of decimal positions defined AM40.1
Decimals for the transaction currency.
ASD-CURRENCY-CODE Alpha 5 AM145 AM154
Currency Code This field contains the company base AM40.1
currency code established in Company
(GL10.1 ).
ASD-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM145 AM154
Item Last Date This is the last changed date for the AM40.1
record.
ASD-ITEM-LAST-SEQ Numeric 6 AM145 AM154
Item Last Sequence This is the last sequence number for AM40.1
the last change to the record.
ASD-CREATION-DATE Numeric 8 (yyyymmdd) AM145 AM154
Creation Date This is the date that the disposal AM40.1
record was created.
ASD-CREATION-TIME Numeric 6 (hhmmss) AM145 AM154
Creation Time This is the time the disposal record AM40.1
was created.
ASD-CREATOR-ID Alpha 10 AM145 AM154
Creator ID This is the ID of the person creating AM40.1
the disposal record.
ASD-AST-DSP-ASSET Derived
Ast Dsp Asset This is the disposal asset.
ASD-AST-TAG-NBR Derived
Ast Tag Nbr This is the asset tag number. A tag
number is a user-definable identifier
assigned to an asset.
ASD-AST-ASSET-GRP Derived
Ast Asset Grp 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 Derived
Ast Descrip This is the asset description for the
disposed-of asset.
AMASSETDSP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASDSET1 ASSET AM115 AM120
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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
AM222 AM223
AM224 AM225
...
AMASSETDSP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastbkdsp AMASTBKDSP
ASD-ASSET -> ABD-ASSET
ABD-BOOK
|
