AMASSETDSP FILE Asset Disposal This file contains historical asset information related to disposals. It is updated by AM40.1 (Disposals). REFERENCED BY AM115 AM125 AM135 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM240 AM245 AM255 AM260 AM265 AM292 AM30.1 AM30.2 AM500 AM95.1 AM95.2 AM96.1 AM98.1 UPDATED BY AM145 AM170 AM192 AM300 AM40.1 AM40.2 AM956 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ASD-ASSET Numeric 10 AM145 AM40.1 Asset Required. The asset number contains up AM956 to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. ASD-DSP-STATUS Alpha 1 AM145 AM170 Disposal Status This field indicates the status of the AM40.1 AM956 disposal: released or not released. N = Not Released R = Released ASD-DSP-DATE Numeric 8 (yyyymmdd) AM145 AM40.1 Disposal Date This is the date of the disposal. AM956 ASD-DSP-METHOD Alpha 1 AM145 AM40.1 Disposal Method This field indicates the way in which AM956 the asset was disposed of. 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 AM956 disposal property. It represents a kind of disposed-of asset. ASD-DSP-QUANTITY Numeric 10 AM145 AM40.1 Disposal Quantity This field indicates the asset quantity AM956 disposed of. ASD-FULL-PARTIAL Alpha 1 AM145 AM40.1 Full Partial This field indicates whether the AM956 disposal was full (including all asset items) or partial (including only some asset items). F = Full P = Partial ASD-PROCEEDS-CURR Alpha 5 AM145 AM40.1 Proceeds Currency This is the currency for the Proceeds AM956 account. ASD-PROCEEDS Signed 15.2 AM145 AM40.1 Proceeds This field contains the proceeds of the AM956 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 AM956 the sale of the asset. ASD-COST-SALE Signed 15.2 AM145 AM40.1 Cost Sale This is the cost of the sale of the AM956 asset. ASD-ITEM-TOT-QTY Numeric 10 AM145 AM40.1 Item Total Quantity This is the total item quantity for the AM40.2 AM956 disposal. ASD-IT-TOT-CSTBASE Signed 15.2 AM145 AM40.1 Item Total Cost Base This is the total item cost in the base AM40.2 AM956 currency. ASD-IT-TOT-CSTTRAN Signed 15.2 AM145 AM40.1 Item Total Cost Tran This is the total item cost in the AM40.2 AM956 transaction currency. ASD-IT-TOT-TAXBASE Signed 15.2 AM145 AM40.1 Item Total Tax Base This is the total item tax in the base AM40.2 AM956 currency. ASD-IT-TOT-TAXTRAN Signed 15.2 AM145 AM40.1 Item Total Tax Tran This is the total item tax in the AM40.2 AM956 transaction currency. ASD-BASE-ND Numeric 1 AM145 AM40.1 Base Number of The number of decimal positions defined AM956 Decimals for the company base currency. ASD-TRAN-ND Numeric 1 AM145 AM40.1 Tran Number of The number of decimal positions defined AM956 Decimals for the transaction currency. ASD-CURRENCY-CODE Alpha 5 AM145 AM40.1 Currency Code This field contains the company base AM956 currency code established in GL10.1 (Company). ASD-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM145 AM40.1 Item Last Date This is the last changed date for the AM956 item. ASD-ITEM-LAST-SEQ Numeric 6 AM145 AM40.1 Item Last Sequence This is the last sequence number for the last change to the item. ASD-CREATION-DATE Numeric 8 (yyyymmdd) AM145 AM40.1 Creation Date This is the date that the disposal AM956 record was created. ASD-CREATION-TIME Numeric 6 (hhmmss) AM145 AM40.1 Creation Time This is the time the disposal record AM956 was created. ASD-CREATOR-ID Alpha 10 AM145 AM40.1 Creator ID This is the ID of the person creating AM956 the disposal record. ASD-AST-DSP-ASSET Derived Disposal Asset This is the disposal asset. ASD-AST-TAG-NBR Derived Tag Number This is the asset tag number. A tag number is a user-definable identifier assigned to an asset. ASD-AST-ASSET-GRP Derived Asset Group 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 Description This is the asset description for the disposed-of asset. AMASSETDSP FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ASDSET1 ASSET AM115 AM125 AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM240 AM245 AM255 AM260 AM265 AM292 AM30.1 AM30.2 AM300 AM40.1 AM40.2 AM40.3 AM40.4 AM500 ... 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 |