AMASTITADJ – Asset Item Adjustment

System
Asset Management (AM)
Prefix
AIA
Primary key
ASSET, PROCESS-SEQ, SEQ-NUMBER
Fields
55
Updated by
266 programs
Referenced by
2 programs

AMASTITADJ is the Asset Item Adjustment table in Lawson Asset Management (prefix AIA). It is indexed by ASSET, PROCESS-SEQ, SEQ-NUMBER (AIASET1); alternate indexes: AIASET2. It is related 1:1 to AMASSETADJ and AMASTITEM. It is updated by AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 and 258 more and referenced by AM225 and AMDL.1. The table has 55 fields, 2 indexes and 2 documented relations.

About AMASTITADJ

The Asset Item Adjustment file is an audit file that stores records of changes that are made to Asset Item file records. Each asset item adjustment record describes the before and after values of asset item fields that were changed, as well as the date and time of the change and the operator who made the changes.

Fields (55)

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

Field / columnTypeDescription & valuesUpdated by
AIA-ASSET PK
ASSET		Numeric 10Key field. This is the asset for the asset item adjustment.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6Key field. The sequence number is a unique number assigned to each transaction in the Lawson system.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-PROCESS-SEQ PK
PROCESS_SEQ		Numeric 6Key field. This is the sequence number for the adjustment process.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-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 item is part of an asset composed of different elements, but depreciated as a common asset unit.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-ITEM-NBR
TO_ITEM_NBR		Alpha 32The number assigned to the asset item for the transfer-to asset. The item number must be unique within an asset, but can be duplicated from asset to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the item description.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-DESCRIPTION
TO_DESCRIPTION		Alpha 30 (Lower Case)This is the item description for the to-asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-PURCHASE-DATE
PURCHASE_DATE		Numeric 8 (yyyymmdd)The date the asset was purchased. This purchased date can be different from the in-service dates for the depreciation books used.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-PURCH-DATE
TO_PURCH_DATE		Numeric 8 (yyyymmdd)This is the purchase date for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-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, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-IT-QUANTITY
TO_IT_QUANTITY		Numeric 8This is the item quantity for the to-asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-ITEM-COST-BASE
ITEM_COST_BASE		Signed 18.2This is the item cost in the base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-IT-CST-BASE
TO_IT_CST_BASE		Signed 18.2This is the item cost in the base currency for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-ITEM-TAX-BASE
ITEM_TAX_BASE		Signed 18.2This is the item tax in the base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-IT-TAX-BASE
TO_IT_TAX_BASE		Signed 18.2This is the item tax in the base currency for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-ITEM-COST-TRAN
ITEM_COST_TRAN		Signed 18.2This is the item cost in the transaction currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-IT-CST-TRAN
TO_IT_CST_TRAN		Signed 18.2This is the to-asset item cost in the transaction currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2This is the item tax in the base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-IT-TAX-TRAN
TO_IT_TAX_TRAN		Signed 18.2This is the to-asset item tax in the transaction currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-PO-NBR
PO_NBR		Alpha 14The Purchase Order Number field is an optional field for your reference. It contains the number of the original purchase order on which this asset was included.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-PO-NBR
TO_PO_NBR		Alpha 14This is the purchase order number for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-PO-RELEASE
TO_PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-PO-CODE
TO_PO_CODE		Alpha 4This is the purchase order code.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-VENDOR
TO_VENDOR		Alpha 9 (Right Justified)This is the vendor code for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-VENDOR-NAME
VENDOR_NAME		Alpha 30This is the vendor name for the asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-VENDOR-NAME
TO_VENDOR_NAME		Alpha 30This is the vendor name for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-INVOICE
INVOICE		Alpha 22Used to identify the invoice.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-INVOICE
TO_INVOICE		Alpha 22This is the invoice identifier for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-SUFFIX
SUFFIX		Numeric 3This is the suffix for the invoice.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-DIST-SEQ-NBR
DIST_SEQ_NBR		Numeric 6A unique sequence number.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-MODEL-NUMBER
MODEL_NUMBER		Alpha 30This is the model number for the asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-MODEL-NBR
TO_MODEL_NBR		Alpha 30This is the model number for the to-asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30This is the serial number of the asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-SERIAL-NBR
TO_SERIAL_NBR		Alpha 30This is the serial number of the to-asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-ACTIVITY
ACTIVITY		Alpha 15This is the activity for the asset being adjusted. 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. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-ACTIVITY
TO_ACTIVITY		Alpha 15This is the activity for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5This is the account category for the asset being adjusted. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-ACCT-CAT
TO_ACCT_CAT		Alpha 5This is the account category for the transfer-to asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-ITEM-LOC-DTL
ITEM_LOC_DTL		Alpha 14This field contains the location detail for the item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-ITM-LOC-DTL
TO_ITM_LOC_DTL		Alpha 14This field contains the new location detail for the item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-BAR-CODE
BAR_CODE		Alpha 30This field contains the bar code assigned to the asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-BAR-CODE
TO_BAR_CODE		Alpha 30This field contains the new bar code assigned to the asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-INV-DATE
INV_DATE		Numeric 8 (yyyymmdd)This is the system-generated date for the last date the inventory was made.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-INV-DATE
TO_INV_DATE		Numeric 8 (yyyymmdd)This is the new system-generated inventory date.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-INV-TIME
INV_TIME		Numeric 6 (hhmmss)This is the last system-generated inventory time.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-INV-TIME
TO_INV_TIME		Numeric 6 (hhmmss)This is the new system-generated inventory time.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-INV-ITEM-COND
INV_ITEM_COND		Alpha 1This field contains the assessed condition of the item before the item was adjusted. Valid values are:
  • G Good
  • F Fair
  • D Damaged
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-INV-IT-COND
TO_INV_IT_COND		Alpha 1Ths is the new assessed condition of the item. Valid values are:
  • G Good
  • F Fair
  • D Damaged
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-GRANT
GRANT		Alpha 30—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AIA-TO-GRANT
TO_GRANT		Alpha 30—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AIASET1ASSET, PROCESS-SEQ, SEQ-NUMBERPrimaryAC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +22 more (list truncated in source)
AIASET2ASSET, SEQ-NUMBER, PROCESS-SEQAMDL.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmassetadjAMASSETADJRequiredAIA-ASSET → ASA-ASSET, AIA-PROCESS-SEQ → ASA-PROCESS-SEQ
AmastitemAMASTITEMRequiredAIA-ASSET → ASI-ASSET, AIA-SEQ-NUMBER → ASI-SEQ-NUMBER

Programs

Updated by (266)

Referenced by (2)