 |
Lawson Insight Technical Documentation |
|
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 AM125 AM145 AM153 AM221 AM223
AM245 AM25.1 AM25.3 AM250 AM266 AM45.1
AM45.3 AM70.1 AM70.3 AMAS.1 AMBK.1 AMDL.1
AM225 AM252 AM52.1 AM07.3
UPDATED BY
AM115 AM135 AM15.1 AM15.2 AM15.3 AM15.4
AM152 AM154 AM170 AM192 AM20.1 AM20.2
AM20.3 AM20.4 AM20.5 AM20.6 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM30.1 AM30.2
AM300 AM40.1 AM40.2 AM500 AM51.1 AM551
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
AM154 AM170
The asset number contains up to ten AM192 AM20.1
numeric characters that uniquely AM20.2 AM20.3
identify an asset. Assets are AM20.4 AM20.5
automatically numbered system-wide. The AM20.6 AM21.1
asset number does not change unless an AM21.2 AM21.3
asset is partially transferred or AM21.4 AM21.5
disposed of. AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
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
AM154 AM170
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1 AMDL.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 AM21.1 AM21.2
one asset item, but the items are AM21.3 AM21.4
depreciated as a common asset unit. AM21.5 AM21.6
Items are not depreciated separately. AM30.1 AM500
However, items can be partially or AM51.1 AM551
separately transferred or disposed of. AM96.1 AM97.1
AM98.1
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-ITEM-PROCESS Alpha 3
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
DSP = Disposal
TRF = Transfer
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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 AM154 AM170
the item. AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 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 AM154 AM170
multiplied by the item quantity to AM20.1 AM20.2
calculate the total cost amount to be AM20.3 AM20.4
added to the asset cost. AM20.5 AM20.6
AM21.1 AM21.2
The sum of the products of all AM21.3 AM21.4
associated item cost and item quantity AM21.5 AM21.6
fields must equal the total asset cost AM30.1 AM30.2
stored in the Asset file. AM40.1 AM40.2
AM500 AM51.1
AM551 AM96.1
AM97.1 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. AM154 AM170
This amount is multiplied by the item AM20.1 AM20.2
quantity to calculate the total tax AM20.3 AM20.4
amount to be added to the asset tax. The AM20.5 AM20.6
sum of the products of all associated AM21.1 AM21.2
item tax and item quantity fields must AM21.3 AM21.4
equal the total asset tax amount in the AM21.5 AM21.6
Asset file. AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 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. AM154 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
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 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. AM154 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
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-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 AM170
Standing order). AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-VENDOR Alpha 9 (Right Justified) 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM551 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM500
AM51.1 AM551
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, AM21.1 AM21.2
and so on) are the reasons for AM21.3 AM21.4
performing the activity. Activities and AM21.5 AM21.6
cost object activities are used AM30.1 AM500
synonymously in the Lawson Activity AM51.1 AM551
Management system. AM96.1 AM97.1
AM98.1
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 AM21.1 AM21.2
for activities in the Lawson Activity AM21.3 AM21.4
Management system. All transactions are AM21.5 AM21.6
posted to an account category within an AM500 AM51.1
activity. AM551 AM96.1
AM97.1 AM98.1
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
AM154 AM20.1
AM20.3 AM21.1
AM21.3 AM30.1
AM30.2 AM40.1
AM500 AM51.1
AM551 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
AM154 AM20.1
AM20.3 AM21.1
AM21.3 AM30.1
AM30.2 AM40.1
AM500 AM51.1
AM551 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
AM154 AM20.1
AM20.3 AM21.1
AM21.3 AM30.1
AM30.2 AM40.1
AM500 AM51.1
AM551 AM97.1
ASI-BAR-CODE Alpha 30 AM115 AM15.1
Bar Code This file contains the bar code AM15.2 AM15.3
assigned to the asset item. AM15.4 AM154
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 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-ITEM-LOC-DTL Alpha 14 AM115 AM135
Item Loc Dtl The field contains the asset location AM15.1 AM15.2
detail. AM15.3 AM15.4
AM154 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
AM30.1 AM30.2
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
ASI-INV-DATE Numeric 8 (yyyymmdd) AM115 AM15.1
Invoice Date This field contains the system-generated AM15.2 AM15.3
date of the last inventory. AM15.4 AM152
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 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-INV-TIME Numeric 6 (hhmmss) AM115 AM15.1
Inv Time This field contains the system-generated AM15.2 AM15.3
time of the last inventory. AM15.4 AM152
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 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-INV-ITEM-COND Alpha 1 AM115 AM15.1
Inv Item Cond This field contains an assessment of AM15.2 AM15.3
the inventory item's condition. Valid AM15.4 AM152
values are: AM170 AM20.1
G = Good AM20.2 AM20.3
F = Fair AM20.4 AM20.5
D = Damaged AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-OBJ-ID Numeric 12 AM115 AM15.1
Object This is the object identifier. It is AM15.2 AM15.3
Identification used to relate commitments or posted AM15.4 AM20.1
transactions back to the originating AM20.3 AM21.1
subsystems. Each subsystem record that AM21.3 AM500
is updated as a commitment or posted AM51.1 AM551
transaction is assigned an object AM97.1
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.
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.
ASI-GL-CURR-CODE Derived
GL Currency Code This field indicates the asset currency.
AMASTITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASISET1 ASSET AC160 AM115
SEQ-NUMBER AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM152
AM153 AM154
AM170 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM221 AM223
AM245 AM25.1
...
ASISET2 ASSET KeyChange AM20.3 AM21.3
ITEM-NBR AM225
SEQ-NUMBER
ASISET3 SERIAL-NUMBER
ASSET
SEQ-NUMBER
ASISET4 BAR-CODE KeyChange AM115 AM15.1
ASSET AM15.2 AM15.3
SEQ-NUMBER AM15.4 AM152
AM153 AM154
AM20.1 AM20.3
AM21.1 AM21.3
AM252 AM500
AM51.1 AM52.1
AM551 AM97.1
ASISET5 ITEM-LOC-DTL KeyChange AM07.3
ASSET
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
Amlocdtl AMLOCDTL Not Required
AST-LOCATION-NAME -> LOD-LOCATION-NAME
ASI-ITEM-LOC-DTL -> LOD-LOC-DTL
Apinvoice APINVOICE Not Required
AST-COMPANY -> API-COMPANY
ASI-VENDOR -> API-VENDOR
ASI-INVOICE -> API-INVOICE
ASI-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Glsystem GLSYSTEM Required
AST-COMPANY -> GLS-COMPANY
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
|