 |
Lawson Insight Technical Documentation |
|
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 AMDL.1
UPDATED BY
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM170
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM21.1 AM21.2 AM21.3 AM21.4 AM21.5 AM21.6
AM300 AM500 AM51.1 AM551 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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
to asset. An item is part of an asset AM21.3 AM500
composed of different elements, but AM51.1 AM551
depreciated as a common asset unit. AM97.1
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 AM21.1
asset, but can be duplicated from asset AM21.3 AM500
to asset. AM51.1 AM551
AM97.1
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
books used. AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
the item. AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
purchase order on which this asset was AM21.3 AM500
included. AM51.1 AM551
AM97.1
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 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-PO-RELEASE Numeric 4 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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
Standing order). AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-VENDOR Alpha 9 (Right Justified) AM115 AM15.1
Vendor The vendor's identification code. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-TO-VENDOR Alpha 9 (Right Justified) 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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
work. Cost objects (products, services, AM21.3 AM500
customers, and so on) are the reasons AM51.1 AM551
for performing the activity. Activities AM97.1
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 AM21.1
AM21.3 AM500
AM51.1 AM551
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 AM21.1
combination of both used for reporting AM21.3 AM500
and inquiries for activities in the AM51.1 AM551
Activity Management system. All AM97.1
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 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-ITEM-LOC-DTL Alpha 14 AM115 AM15.1
Item Loc Dtl This field contains the location detail AM15.2 AM15.3
for the item. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-TO-ITM-LOC-DTL Alpha 14 AM115 AM15.1
To Itm Loc Dtl This field contains the new location AM15.2 AM15.3
detail for the item. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-BAR-CODE Alpha 30 AM115 AM15.1
Bar Code This field contains the bar code AM15.2 AM15.3
assigned to the asset item. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-TO-BAR-CODE Alpha 30 AM115 AM15.1
To Bar Code This field contains the new bar code AM15.2 AM15.3
assigned to the asset item. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-INV-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
Invoice Date This is the system-generated date for AM15.2 AM15.3
the last date the inventory was made. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-TO-INV-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
To Inv Date This is the new system-generated AM15.2 AM15.3
inventory date. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-INV-TIME Numeric 6 (hhmmss) AM115 AM15.1
Inv Time This is the last system-generated AM15.2 AM15.3
inventory time. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-TO-INV-TIME Numeric 6 (hhmmss) AM115 AM15.1
To Inv Time This is the new system-generated AM15.2 AM15.3
inventory time. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1
AIA-INV-ITEM-COND Alpha 1 AM115 AM15.1
Inv Item Cond This field contains the assessed AM15.2 AM15.3
condition of the item before the item AM15.4 AM20.1
was adjusted. Valid values are: AM20.3 AM21.1
G = Good AM21.3 AM500
F = Fair AM51.1 AM551
D = Damaged AM97.1
AIA-TO-INV-IT-COND Alpha 1 AM115 AM15.1
To Inv It Cond Ths is the new assessed condition of the AM15.2 AM15.3
item. Valid values are: AM15.4 AM20.1
G = Good AM20.3 AM21.1
F = Fair AM21.3 AM500
D = Damaged AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM225 AM300
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
AIASET2 ASSET AMDL.1
SEQ-NUMBER
PROCESS-SEQ
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
|