AMASSETDSP FILE
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
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
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 API1.1 API2.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASD-ASSET Numeric 10 AM145 AM154
Element: 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
Element: Disposal StatuThis 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
Element: Disposal Date This is the date of the disposal. AM40.1
ASD-DSP-METHOD Alpha 1 AM145 AM154
Element: Disposal MethoThis 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
Element: Disposal PropeThis is the user-defined name of a
disposal property. It represents a kind
of disposed-of asset.
ASD-DSP-QUANTITY Numeric 10 AM145 AM154
Element: Disposal QuantThis field indicates the asset quantity AM40.1 AM40.2
disposed of.
ASD-LEASE-COMPANY Numeric 4 AM154 AM40.1
Element: Company The lessor company for the disposed
leased asset.
ASD-LEASE Alpha 19 AM154 AM40.1
Element: Lease The lease number associated with the
disposed leased asset.
ASD-ASSET-GROUP Alpha 10 AM154
Element: Asset Group The asset group assigned to the
disposed leased asset.
ASD-FULL-PARTIAL Alpha 1 AM145 AM154
Element: 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
Element: Proceeds CurreThis is the currency for the Proceeds
account.
ASD-PROCEEDS Signed 18.2 AM145 AM154
Element: 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
Element: Cost Sale CurrThis is the currency for the cost of
the sale of the asset.
ASD-COST-SALE Signed 18.2 AM145 AM154
Element: Cost Sale This is the cost of the sale of the AM40.1
asset.
ASD-ITEM-TOT-QTY Numeric 10 AM145 AM154
Element: Item Total QuaThis is the total item quantity for the AM40.1 AM40.2
disposal.
ASD-IT-TOT-CSTBASE Signed 18.2 AM145 AM154
Element: Item Total CosThis is the total item cost in the base AM40.1 AM40.2
currency.
ASD-IT-TOT-CSTTRAN Signed 18.2 AM145 AM154
Element: Item Total CosThis is the total item cost in the AM40.1 AM40.2
transaction currency.
ASD-IT-TOT-TAXBASE Signed 18.2 AM145 AM154
Element: Item Total TaxThis is the total item tax in the base AM40.1 AM40.2
currency.
ASD-IT-TOT-TAXTRAN Signed 18.2 AM145 AM154
Element: Item Total TaxThis 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
Element: 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
Element: Item Last DateThis is the last changed date for the AM40.1
record.
ASD-ITEM-LAST-SEQ Numeric 6 AM145 AM154
Element: Item Last SequThis is the last sequence number for AM40.1
the last change to the record.
ASD-CREATION-DATE Numeric 8 (yyyymmdd) AM145 AM154
Element: Creation Date This is the date that the disposal AM40.1
record was created.
ASD-CREATION-TIME Numeric 6 (hhmmss) AM145 AM154
Element: Creation Time This is the time the disposal record AM40.1
was created.
ASD-CREATOR-ID Alpha 10 AM145 AM154
Element: Creator ID This is the ID of the person creating AM40.1
the disposal record.
ASD-AST-DSP-ASSET Derived
Element: Ast Dsp Asset This is the disposal asset.
ASD-AST-TAG-NBR Derived
Element: 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
Element: 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
Element: 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 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 AM220
...
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
|
