AMASTITDSP – Asset Item Disposal

System
Asset Management (AM)
Prefix
ADS
Primary key
ASSET, PROCESS-SEQ, SEQ-NUMBER
Fields
15
Updated by
270 programs
Referenced by
2 programs

AMASTITDSP is the Asset Item Disposal table in Lawson Asset Management (prefix ADS). It is indexed by ASSET, PROCESS-SEQ, SEQ-NUMBER (ADSSET1); alternate indexes: ADSSET2. It is related 1:1 to AMASTITEM. It is updated by AC160, AM115, AM117, AM125, AM145, AM15.1, AM15.2, AM15.3 and 262 more and referenced by AM245 and AMDL.1. The table has 15 fields, 2 indexes and 1 documented relation.

About AMASTITDSP

This file contains historical asset item information related to disposals.

Fields (15)

Column = COBOL field name without the ADS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ADS-ASSET PK
ASSET		Numeric 10Key field. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM145, AM154, AM40.1, AM40.2
ADS-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6Key field. A unique number assigned to each transaction in the Lawson system.AM145, AM154, AM40.1, AM40.2, AMDL.1
ADS-PROCESS-SEQ PK
PROCESS_SEQ		Numeric 6This is the sequence number for this disposal process.AM145, AM154, AM40.1, AM40.2
ADS-DSP-DATE
DSP_DATE		Numeric 8 (yyyymmdd)This is the date of the disposal.AM145, AM154, AM40.1, AM40.2
ADS-DSP-METHOD
DSP_METHOD		Alpha 1This is the disposal method, indicating 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, AM40.2
ADS-DSP-QUANTITY
DSP_QUANTITY		Numeric 10This is the asset quantity that was disposed of.AM145, AM154, AM40.2
ADS-ITEM-NBR
ITEM_NBR		Alpha 32The number assigned to the asset item. The item number must be unique within an asset, but can be duplicated from asset to asset. The item number identifies an item of an asset composed of different elements but depreciated as a common asset unit.AM145, AM154, AM40.1, AM40.2
ADS-ITEM-QUANTITY
ITEM_QUANTITY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.AM145, AM154, AM40.1, AM40.2
ADS-ITEM-COST-BASE
ITEM_COST_BASE		Signed 18.2This is the item cost in the base currency.AM145, AM154, AM40.1, AM40.2
ADS-ITEM-TAX-BASE
ITEM_TAX_BASE		Signed 18.2This is the tax on the item in the base currency.AM145, AM154, AM40.1, AM40.2
ADS-ITEM-COST-TRAN
ITEM_COST_TRAN		Signed 18.2This is the item cost in the transaction currency.AM145, AM154, AM40.1, AM40.2
ADS-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2This is the tax on the item in the transaction currency.AM145, AM154, AM40.1, AM40.2
ADS-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the base currency.AM145, AM154, AM40.1, AM40.2
ADS-TRAN-ND
TRAN_ND		Numeric 1The number of decimal positions defined for the transaction currency.AM145, AM154, AM40.1, AM40.2
ADS-BAR-CODE
BAR_CODE		Alpha 30This field contains the bar code of the item being disposed.AM154

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ADSSET1ASSET, PROCESS-SEQ, SEQ-NUMBERPrimaryAC160, AM115, AM117, AM125, AM145, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
ADSSET2ASSET, SEQ-NUMBER, PROCESS-SEQAM245, AM40.2, AMDL.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmastitemAMASTITEMRequiredADS-ASSET → ASI-ASSET, ADS-SEQ-NUMBER → ASI-SEQ-NUMBER

Programs

Updated by (270)

Referenced by (2)