AMASTITADJ FILE
Asset Item Adjustment
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.
REFERENCED BY
AM225
UPDATED BY
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM170
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM300 AM500 AM957 AM96.1 AM97.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIA-ASSET Numeric 10 AM115 AM15.1
Asset Key field. This is the asset for the AM15.2 AM15.3
asset item adjustment. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-SEQ-NUMBER Numeric 6 AM115 AM15.1
Sequence Number Key field. The sequence number is a AM15.2 AM15.3
unique number assigned to each AM15.4 AM20.1
transaction in the Lawson system. AM20.3 AM500
AM957 AM97.1
AIA-PROCESS-SEQ Numeric 4 AM115 AM15.1
Process Sequence Key field. This is the sequence number AM15.2 AM15.3
for the adjustment process. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ITEM-NBR Alpha 32 AM115 AM15.1
Item Number The number assigned to the asset item. AM15.2 AM15.3
The item number must be unique within an AM15.4 AM20.1
asset, but can be duplicated from asset AM20.3 AM500
to asset. An item is part of an asset AM957 AM97.1
composed of different elements, but
depreciated as a common asset unit.
AIA-TO-ITEM-NBR Alpha 32 AM115 AM15.1
To Item Number The number assigned to the asset item AM15.2 AM15.3
for the transfer-to asset. The item AM15.4 AM20.1
number must be unique within an AM20.3 AM500
asset, but can be duplicated from asset AM957 AM97.1
to asset.
AIA-DESCRIPTION Alpha 30 (Lower Case) AM115 AM15.1
Description This is the item description. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-DESCRIPTION Alpha 30 (Lower Case) AM115 AM15.1
To Description This is the item description for the AM15.2 AM15.3
to-asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-PURCHASE-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
Purchase Date The date the asset was purchased. This AM15.2 AM15.3
purchased date can be different from the AM15.4 AM20.1
in-service dates for the depreciation AM20.3 AM500
books used. AM957 AM97.1
AIA-TO-PURCH-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
To Purchase Date This is the purchase date for the AM15.2 AM15.3
transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ITEM-QUANTITY Numeric 8 AM115 AM15.1
Item Quantity The number of units that make up the AM15.2 AM15.3
asset item. Each unit of an item is AM15.4 AM20.1
exactly the same as every other unit of AM20.3 AM500
the item. AM957 AM97.1
AIA-TO-IT-QUANTITY Numeric 8 AM115 AM15.1
To Item Quantity This is the item quantity for the AM15.2 AM15.3
to-asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ITEM-COST-BASE Signed 15.2 AM115 AM15.1
Item Cost Base This is the item cost in the base AM15.2 AM15.3
Currency currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-IT-CST-BASE Signed 15.2 AM115 AM15.1
To Item Cost Base This is the item cost in the base AM15.2 AM15.3
Currency currency for the transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ITEM-TAX-BASE Signed 15.2 AM115 AM15.1
Item Tax Base This is the item tax in the base AM15.2 AM15.3
Currency currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-IT-TAX-BASE Signed 15.2 AM115 AM15.1
To Item Tax Base This is the item tax in the base AM15.2 AM15.3
Currency currency for the transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ITEM-COST-TRAN Signed 15.2 AM115 AM15.1
Item Cost This is the item cost in the AM15.2 AM15.3
Transaction Currency transaction currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-IT-CST-TRAN Signed 15.2 AM115 AM15.1
To Item Cost Tran This is the to-asset item cost in the AM15.2 AM15.3
Currency transaction currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ITEM-TAX-TRAN Signed 15.2 AM115 AM15.1
Item Tax This is the item tax in the base AM15.2 AM15.3
Transaction Currency currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-IT-TAX-TRAN Signed 15.2 AM115 AM15.1
To Item Tax Tran This is the to-asset item tax in the AM15.2 AM15.3
Currency transaction currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-BASE-ND Numeric 1 AM115 AM15.1
Base Number of The number of decimal positions defined AM15.2 AM15.3
Decimals for the company base currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TRAN-ND Numeric 1 AM115 AM15.1
Transaction Number The number of decimal positions defined AM15.2 AM15.3
of Decimals for the transaction currency. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-PO-NBR Alpha 14 AM115 AM15.1
PO Number The Purchase Order Number field is an AM15.2 AM15.3
optional field for your reference. It AM15.4 AM20.1
contains the number of the original AM20.3 AM500
purchase order on which this asset was AM957 AM97.1
included.
AIA-TO-PO-NBR Alpha 14 AM115 AM15.1
To PO Number This is the purchase order number for AM15.2 AM15.3
the transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-PO-RELEASE Numeric 6 AM115 AM15.1
PO Release Used to identify a purchase order AM15.2 AM15.3
release (created from a Blanket or AM15.4 AM20.1
Standing order). AM20.3 AM500
AM97.1
AIA-TO-PO-RELEASE Numeric 4 AM115 AM15.1
To PO Release This is the PO Release Number for the AM15.2 AM15.3
to-asset, used to identify a purchase AM15.4 AM20.1
order release (created from a Blanket or AM20.3 AM500
Standing order). AM97.1
AIA-PO-CODE Alpha 4 AM115 AM15.1
PO Code This is the purchase order code. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM500
AM97.1
AIA-TO-PO-CODE Alpha 4 AM115 AM15.1
To PO Code This is the purchase order code for the AM15.2 AM15.3
to-asset. AM15.4 AM20.1
AM20.3 AM500
AM97.1
AIA-VENDOR Alpha 9 AM115 AM15.1
Vendor The vendor's identification code. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-VENDOR Alpha 9 AM115 AM15.1
To Vendor This is the vendor code for the AM15.2 AM15.3
transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-VENDOR-NAME Alpha 30 AM115 AM15.1
Vendor Name This is the vendor name for the asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-VENDOR-NAME Alpha 30 AM115 AM15.1
To Vendor Name This is the vendor name for the AM15.2 AM15.3
transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-INVOICE Alpha 22 AM115 AM15.1
Invoice Used to identify the invoice. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-INVOICE Alpha 22 AM115 AM15.1
To Invoice This is the invoice identifier for the AM15.2 AM15.3
transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-SUFFIX Numeric 3 AM115 AM15.1
Suffix This is the suffix for the invoice. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-DIST-SEQ-NBR Numeric 4 AM115 AM15.1
Distribution A unique sequence number. AM15.2 AM15.3
Sequence Number AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-MODEL-NUMBER Alpha 30 AM115 AM15.1
Model Number This is the model number for the asset AM15.2 AM15.3
item. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-MODEL-NBR Alpha 30 AM115 AM15.1
To Model Number This is the model number for the AM15.2 AM15.3
to-asset item. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-SERIAL-NUMBER Alpha 30 AM115 AM15.1
Serial Number This is the serial number of the asset AM15.2 AM15.3
item. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-TO-SERIAL-NBR Alpha 30 AM115 AM15.1
To Serial Number This is the serial number of the AM15.2 AM15.3
to-asset item. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ACTIVITY Alpha 15 AM115 AM15.1
Activity This is the activity for the asset AM15.2 AM15.3
being adjusted. Activities are the AM15.4 AM20.1
processes or procedures that produce AM20.3 AM500
work. Cost objects (products, services, AM957 AM97.1
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.
AIA-TO-ACTIVITY Alpha 15 AM115 AM15.1
To Activity This is the activity for the AM15.2 AM15.3
transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AIA-ACCT-CATEGORY Alpha 5 AM115 AM15.1
Account Category This is the account category for the AM15.2 AM15.3
asset being adjusted. Account categories AM15.4 AM20.1
are groupings of costs, revenues, or a AM20.3 AM500
combination of both used for reporting AM957 AM97.1
and inquiries for activities in the
Activity Management system. All
transactions are posted to an account
category within an activity.
AIA-TO-ACCT-CAT Alpha 5 AM115 AM15.1
To Account Category This is the account category for the AM15.2 AM15.3
transfer-to asset. AM15.4 AM20.1
AM20.3 AM500
AM957 AM97.1
AMASTITADJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIASET1 ASSET AM115 AM15.1
PROCESS-SEQ AM15.2 AM15.3
SEQ-NUMBER AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM225 AM300
AM500 AM957
AM96.1 AM97.1
AM98.1
AMASTITADJ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastitem AMASTITEM Required
AIA-ASSET -> ASI-ASSET
AIA-SEQ-NUMBER -> ASI-SEQ-NUMBER
|