AMASTITEM FILE
Asset Item
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.
REFERENCED BY
AC160 AM145 AM221 AM223 AM245 AM250
AM70.1 AM70.3 AM957 AM225
UPDATED BY
AM115 AM135 AM15.1 AM15.2 AM15.3 AM15.4
AM170 AM192 AM20.1 AM20.2 AM20.3 AM20.4
AM20.5 AM20.6 AM30.1 AM30.2 AM300 AM40.1
AM40.2 AM500 AM951 AM952 AM956 AM96.1
AM97.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASI-ASSET Numeric 10 AM115 AM135
Asset The asset number associated with the AM15.1 AM15.2
asset item record. AM15.3 AM15.4
AM170 AM192
The asset number contains up to ten AM20.1 AM20.2
numeric characters that uniquely AM20.3 AM20.4
identify an asset. Assets are AM20.5 AM20.6
automatically numbered system-wide. The AM30.1 AM30.2
asset number does not change unless an AM40.1 AM40.2
asset is partially transferred or AM500 AM951
disposed of. AM952 AM956
AM96.1 AM97.1
AM98.1
ASI-SEQ-NUMBER Numeric 6 AM115 AM135
Sequence Number A unique sequence number assigned to AM15.1 AM15.2
the asset item record. AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM30.2
AM500 AM951
AM952 AM956
AM96.1 AM97.1
AM98.1
ASI-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 AM170
asset, but can be duplicated from asset AM20.1 AM20.2
to asset. AM20.3 AM20.4
AM20.5 AM20.6
An asset can be composed of more than AM30.1 AM500
one asset item, but the items are AM951 AM952
depreciated as a common asset unit. AM956 AM96.1
Items are not depreciated separately. AM97.1 AM98.1
However, items can be partially or
separately transferred or disposed of.
ASI-DESCRIPTION Alpha 30 (Lower Case) AM115 AM15.1
Description The asset item description. AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-ITEM-PROCESS Alpha 3 AM952 AM956
Item Process This field identifies whether the asset
item record is in the process of being
adjusted, disposed of, or transferred.
Valid values are:
ADJ = Adjustment. The asset item is
currently in the adjustment process.
DSP = Disposal. The asset item is
currently in the adjustment process.
TRF = Transfer. The asset item is
currently in the transfer process.
Blank = The asset item is not being
adjusted, disposed of, or transferred.
ASI-PURCHASE-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
Purchase Date The date the asset item was purchased. AM15.2 AM15.3
This purchased date can be different AM15.4 AM170
from the in-service dates for the AM20.1 AM20.2
depreciation books used. AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-ITEM-QUANTITY Numeric 8 AM115 AM135
Item Quantity The number of units that make up the AM15.1 AM15.2
asset item. Each unit of an item is AM15.3 AM15.4
exactly the same as every other unit of AM170 AM20.1
the item. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-ITEM-COST-BASE Signed 15.2 AM115 AM135
Item Cost Base This field identifies the unit cost of AM15.1 AM15.2
Currency an item defined by this record in the AM15.3 AM15.4
company base currency. The item cost is AM170 AM20.1
multiplied by the item quantity to AM20.2 AM20.3
calculate the total cost amount to be AM20.4 AM20.5
added to the asset cost. AM20.6 AM30.1
AM30.2 AM40.1
The sum of the products of all AM40.2 AM500
associated item cost and item quantity AM951 AM956
fields must equal the total asset cost AM96.1 AM97.1
stored in the Asset file. AM98.1
ASI-ITEM-TAX-BASE Signed 15.2 AM115 AM135
Item Tax Base This field identifies the unit tax AM15.1 AM15.2
Currency amount of an item defined by this asset AM15.3 AM15.4
record in the company base currency. AM170 AM20.1
This amount is multiplied by the item AM20.2 AM20.3
quantity to calculate the total tax AM20.4 AM20.5
amount to be added to the asset tax. The AM20.6 AM30.1
sum of the products of all associated AM30.2 AM40.1
item tax and item quantity fields must AM40.2 AM500
equal the total asset tax amount in the AM951 AM952
Asset file. AM956 AM96.1
AM97.1 AM98.1
ASI-ITEM-COST-TRAN Signed 15.2 AM115 AM135
Item Cost This field identifies the unit cost of AM15.1 AM15.2
Transaction Currency an item defined by this record in the AM15.3 AM15.4
transaction currency. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-ITEM-TAX-TRAN Signed 15.2 AM115 AM135
Item Tax This field identifies the unit tax AM15.1 AM15.2
Transaction Currency amount of an item defined by this asset AM15.3 AM15.4
record in the transaction currency. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-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 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-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 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-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 is AM15.4 AM170
assumed to contain the original purchase AM20.1 AM20.2
order number on which this asset item AM20.3 AM20.4
was included. AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-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 AM170
Standing order). AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM96.1 AM97.1
AM98.1
ASI-PO-CODE Alpha 4 AM115 AM15.1
PO Code This is the purchase order code. AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM96.1 AM97.1
AM98.1
ASI-VENDOR Alpha 9 AM115 AM15.1
Vendor The vendor number associated with the AM15.2 AM15.3
asset item record. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-VENDOR-NAME Alpha 30 AM115 AM15.1
Vendor Name The name of the vendor associated with AM15.2 AM15.3
the asset item. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-INVOICE Alpha 22 AM115 AM15.1
Invoice The invoice number associated with the AM15.2 AM15.3
asset item. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM956 AM96.1
AM97.1 AM98.1
ASI-SUFFIX Numeric 3 AM115 AM15.1
Suffix The invoice suffix number associated AM15.2 AM15.3
with the asset item record. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM96.1 AM98.1
ASI-DIST-SEQ-NBR Numeric 4 AM115 AM15.1
Distribution The distribution sequence number AM15.2 AM15.3
Sequence Number associated with the asset item. AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM956
AM96.1 AM97.1
AM98.1
ASI-MODEL-NUMBER Alpha 30 AM115 AM15.1
Model Number The model number of the asset item. AM15.2 AM15.3
Represents the manufacturer identifier AM15.4 AM170
of an asset brand. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM96.1 AM97.1
AM98.1
ASI-SERIAL-NUMBER Alpha 30 AM115 AM15.1
Serial Number This optional field is used for the AM15.2 AM15.3
serial number of the asset. The serial AM15.4 AM170
number represents a unique manufacturer AM20.1 AM20.2
identifier of an asset by model. AM20.3 AM20.4
AM20.5 AM20.6
AM30.1 AM500
AM951 AM952
AM96.1 AM97.1
AM98.1
ASI-ACTIVITY Alpha 15 AM115 AM15.1
Activity The activity assigned to the asset item. AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
Activities are the processes or AM20.3 AM20.4
procedures that produce work. Cost AM20.5 AM20.6
objects (products, services, customers, AM30.1 AM500
and so on) are the reasons for AM96.1 AM97.1
performing the activity. Activities and AM98.1
cost object activities are used
synonymously in the Lawson Activity
Management system.
ASI-ACCT-CATEGORY Alpha 5 AM115 AM15.1
Account Category The account category assigned to the AM15.2 AM15.3
asset item. AM15.4 AM170
AM20.1 AM20.2
Account categories are groupings of AM20.3 AM20.4
costs, revenues, or a combination of AM20.5 AM20.6
both used for reporting and inquiries AM500 AM96.1
for activities in the Lawson Activity AM97.1 AM98.1
Management system. All transactions are
posted to an account category within an
activity.
ASI-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM135
Creation Date The date the asset item record was AM15.1 AM15.2
created. AM15.3 AM15.4
AM20.1 AM20.3
AM30.1 AM30.2
AM40.1 AM500
AM951 AM952
AM956 AM97.1
ASI-CREATION-TIME Numeric 6 (hhmmss) AM115 AM135
Creation Time The time the asset item record was AM15.1 AM15.2
created. AM15.3 AM15.4
AM20.1 AM20.3
AM30.1 AM30.2
AM40.1 AM500
AM951 AM952
AM956 AM97.1
ASI-CREATOR-ID Alpha 10 AM115 AM135
Creator ID This field identifies the operator that AM15.1 AM15.2
created the asset item record. AM15.3 AM15.4
AM20.1 AM20.3
AM30.1 AM30.2
AM40.1 AM500
AM951 AM952
AM956 AM97.1
ASI-TAG Derived
Tag The user-defined tag number assigned to
the associated asset record.
ASI-ASSET-GRP Derived
Asset Group The asset group assigned to the
associated asset record. Represents a
parent number used for report grouping.
AMASTITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASISET1 ASSET AC160 AM115
SEQ-NUMBER AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM221 AM223
AM245 AM250
AM30.1 AM30.2
AM300 AM40.1
AM40.2 AM500
AM70.1 AM70.3
AM952 AM956
...
ASISET2 ASSET KeyChange AM20.3 AM225
ITEM-NBR
SEQ-NUMBER
AMASTITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Activity ACACTIVITY Not Required
ASI-ACTIVITY -> ACV-ACTIVITY
Amasset AMASSET Not Required
ASI-ASSET -> AST-ASSET
Apinvoice APINVOICE Not Required
AST-COMPANY -> API-COMPANY
ASI-VENDOR -> API-VENDOR
ASI-INVOICE -> API-INVOICE
ASI-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
AMASTITEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastitadj AMASTITADJ
ASI-ASSET -> AIA-ASSET
AIA-PROCESS-SEQ
AIA-SEQ-NUMBER
Amastittrf AMASTITTRF
ASI-ASSET -> ITR-ASSET
ITR-PROCESS-SEQ
ITR-SEQ-NUMBER
|