AMASTITEM – Asset Item

System
Asset Management (AM)
Prefix
ASI
Primary key
ASSET, SEQ-NUMBER
Fields
46
Updated by
274 programs
Referenced by
24 programs

AMASTITEM is the Asset Item table in Lawson Asset Management (prefix ASI). It is indexed by ASSET, SEQ-NUMBER (ASISET1); alternate indexes: ASISET2, ASISET3, ASISET4, ASISET5 and ASISET6. It is related 1:1 to ACACTIVITY, AMASSET, AMASTITBOD, AMLOCDTL, APINVOICE and GLSYSTEM and 1:M to AMASTITADJ and AMASTITTRF. It is updated by AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 and 266 more and referenced by AM07.3, AM145, AM153, AM190, AM221, AM223, AM225, AM245 and 16 more. The table has 46 fields, 6 indexes and 9 documented relations.

About AMASTITEM

The Asset Item file stores asset item records. An asset item describes detailed information about an item that makes up an asset record. One or more asset items make up an asset, which is stored in the Asset file and is used for depreciating and reporting on the asset. Each Asset Item file record has one related record in the Asset file.

Fields (46)

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

Field / columnTypeDescription & valuesUpdated by
ASI-ASSET PK
ASSET		Numeric 10The asset number associated with the asset item record. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. The asset number does not change unless an asset is partially transferred or disposed of.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique sequence number assigned to the asset item record.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-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. An asset can be composed of more than one asset item, but the items are depreciated as a common asset unit. Items are not depreciated separately. However, items can be partially or separately transferred or disposed of.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The asset item description.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ITEM-PROCESS
ITEM_PROCESS		Alpha 3This field identifies whether the asset item record is in the process of being adjusted, disposed of, or transferred. Valid values are: adjusted, disposed of, or transferred.
  • ADJ Adjustment
  • DSP Disposal
  • TRF Transfer
  • Blank The asset item is not being
AM135, AM154, AM30.1, AM30.2
ASI-PURCHASE-DATE
PURCHASE_DATE		Numeric 8 (yyyymmdd)The date the asset item was purchased. This purchased date can be different from the in-service dates for the depreciation books used.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-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.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ITEM-COST-BASE
ITEM_COST_BASE		Signed 18.2This field identifies the unit cost of an item defined by this record in the company base currency. The item cost is multiplied by the item quantity to calculate the total cost amount to be added to the asset cost. The sum of the products of all associated item cost and item quantity fields must equal the total asset cost stored in the Asset file.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ITEM-TAX-BASE
ITEM_TAX_BASE		Signed 18.2This field identifies the unit tax amount of an item defined by this asset record in the company base currency. This amount is multiplied by the item quantity to calculate the total tax amount to be added to the asset tax. The sum of the products of all associated item tax and item quantity fields must equal the total asset tax amount in the Asset file.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ITEM-COST-TRAN
ITEM_COST_TRAN		Signed 18.2This field identifies the unit cost of an item defined by this record in the transaction currency.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2This field identifies the unit tax amount of an item defined by this asset record in the transaction currency.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-PO-NBR
PO_NBR		Alpha 14The purchase order number field is an optional field for your reference. It is assumed to contain the original purchase order number on which this asset item was included.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor number associated with the asset item record.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-VENDOR-NAME
VENDOR_NAME		Alpha 30The name of the vendor associated with the asset item.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-INVOICE
INVOICE		Alpha 22The invoice number associated with the asset item.AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-SUFFIX
SUFFIX		Numeric 3The invoice suffix number associated with the asset item record.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-DIST-SEQ-NBR
DIST_SEQ_NBR		Numeric 6The distribution sequence number associated with the asset item.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-MODEL-NUMBER
MODEL_NUMBER		Alpha 30The model number of the asset item. Represents the manufacturer identifier of an asset brand.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30This optional field is used for the serial number of the asset. The serial number represents a unique manufacturer identifier of an asset by model.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ACTIVITY
ACTIVITY		Alpha 15The activity assigned to the asset item. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The account category assigned to the asset item. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)The date the asset item record was created.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The time the asset item record was created.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-CREATOR-ID
CREATOR_ID		Alpha 10This field identifies the operator that created the asset item record.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-BAR-CODE
BAR_CODE		Alpha 30This file contains the bar code assigned to the asset item.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-ITEM-LOC-DTL
ITEM_LOC_DTL		Alpha 14The field contains the asset location detail.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-INV-DATE
INV_DATE		Numeric 8 (yyyymmdd)This field contains the system-generated date of the last inventory.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-INV-TIME
INV_TIME		Numeric 6 (hhmmss)This field contains the system-generated time of the last inventory.AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-INV-ITEM-COND
INV_ITEM_COND		Alpha 1This field contains an assessment of the inventory item's condition. Valid values are:
  • G Good
  • F Fair
  • D Damaged
AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
ASI-OBJ-ID
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-TAG
TAG		DerivedThe user-defined tag number assigned to the associated asset record.—
ASI-ASSET-GRP
ASSET_GRP		DerivedThe asset group assigned to the associated asset record. Represents a parent number used for report grouping.—
ASI-GL-CURR-CODE
GL_CURR_CODE		DerivedThis field indicates the asset currency.—
ASI-INV-COMPANY
INV_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-PO-AST-OBJ-ID
PO_AST_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-GRANT
GRANT		Alpha 30—AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
ASI-GEO-TYPE
GEO_TYPE		Alpha 4——
ASI-GEO-LATITUDE
GEO_LATITUDE		Signed 12.6—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
ASI-GEO-LONGITUDE
GEO_LONGITUDE		Signed 12.6—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
ASI-GEO-ALTITUDE
GEO_ALTITUDE		Signed 12.6—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
ASI-GEO-DATE
GEO_DATE		Numeric 8 (yyyymmdd)—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
ASI-GEO-TIME
GEO_TIME		Numeric 6 (hhmmss)—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)

Indexes (6)

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

IndexKeysFlagsConditionUsed in
ASISET1ASSET, SEQ-NUMBERPrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ASISET2ASSET, ITEM-NBR, SEQ-NUMBERKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM153 +22 more (list truncated in source)
ASISET3SERIAL-NUMBER, ASSET, SEQ-NUMBERKeyChangeAM40.1
ASISET4BAR-CODE, ASSET, SEQ-NUMBERKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM152 +22 more (list truncated in source)
ASISET5ITEM-LOC-DTL, ASSET, SEQ-NUMBERKeyChangeAM07.3
ASISET6PO-AST-OBJ-IDKeyChange, SubsetWhere PO-AST-OBJ-ID != Zeroes—

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
ActivityACACTIVITYNot RequiredASI-ACTIVITY → ACV-ACTIVITY (ACVSET1)
AmassetAMASSETNot RequiredASI-ASSET → AST-ASSET
AmastitbodAMASTITBODNot Required, Delete CascadesASI-ASSET → YAU-ASSET, ASI-SEQ-NUMBER → YAU-SEQ-NUMBER
AmlocdtlAMLOCDTLNot RequiredAST-LOCATION-NAME → LOD-LOCATION-NAME, ASI-ITEM-LOC-DTL → LOD-LOC-DTL
ApinvoiceAPINVOICENot RequiredAST-COMPANY → API-COMPANY, ASI-VENDOR → API-VENDOR, ASI-INVOICE → API-INVOICE, ASI-SUFFIX → API-SUFFIX, Zeroes → API-CANCEL-SEQ
Apinvoice2APINVOICERequiredASI-INV-COMPANY → API-COMPANY, ASI-VENDOR → API-VENDOR, ASI-INVOICE → API-INVOICE, ASI-SUFFIX → API-SUFFIX, Zeroes → API-CANCEL-SEQ
GlsystemGLSYSTEMRequiredAST-COMPANY → GLS-COMPANY

One to many (2) — child tables

RelationTableRulesConditionField map
AmastitadjAMASTITADJASI-ASSET → AIA-ASSET, → AIA-PROCESS-SEQ, → AIA-SEQ-NUMBER
AmastittrfAMASTITTRFASI-ASSET → ITR-ASSET, → ITR-PROCESS-SEQ, → ITR-SEQ-NUMBER

Programs

Updated by (274)

Referenced by (24)