 |
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 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 AM125 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 AM125
Asset The asset number associated with the AM135 AM15.1
asset item record. AM15.2 AM15.3
AM15.4 AM154
The asset number contains up to ten AM170 AM192
numeric characters that uniquely AM20.1 AM20.2
identify an asset. Assets are AM20.3 AM20.4
automatically numbered system-wide. The AM20.5 AM20.6
asset number does not change unless an AM21.1 AM21.2
asset is partially transferred or AM21.3 AM21.4
disposed of. AM21.5 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 AM125
Sequence Number A unique sequence number assigned to AM135 AM15.1
the asset item record. AM15.2 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 AM125
Item Number The number assigned to the asset item. AM15.1 AM15.2
The item number must be unique within an AM15.3 AM15.4
asset, but can be duplicated from asset AM170 AM20.1
to asset. AM20.2 AM20.3
AM20.4 AM20.5
An asset can be composed of more than AM20.6 AM21.1
one asset item, but the items are AM21.2 AM21.3
depreciated as a common asset unit. AM21.4 AM21.5
Items are not depreciated separately. AM21.6 AM30.1
However, items can be partially or AM500 AM51.1
separately transferred or disposed of. AM551 AM96.1
AM97.1 AM98.1
ASI-DESCRIPTION Alpha 30 (Lower Case) AM115 AM125
Description The asset item description. 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 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 AM125
Purchase Date The date the asset item was purchased. AM15.1 AM15.2
This purchased date can be different AM15.3 AM15.4
from the in-service dates for the AM170 AM20.1
depreciation books used. 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-QUANTITY Numeric 8 AM115 AM125
Item Quantity The number of units that make up the AM135 AM15.1
asset item. Each unit of an item is AM15.2 AM15.3
exactly the same as every other unit of AM15.4 AM154
the item. 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-COST-BASE Signed 15.2 AM115 AM125
Item Cost Base This field identifies the unit cost of AM135 AM15.1
Currency an item defined by this record in the AM15.2 AM15.3
company base currency. The item cost is AM15.4 AM154
multiplied by the item quantity to AM170 AM20.1
calculate the total cost amount to be AM20.2 AM20.3
added to the asset cost. AM20.4 AM20.5
AM20.6 AM21.1
The sum of the products of all AM21.2 AM21.3
associated item cost and item quantity AM21.4 AM21.5
fields must equal the total asset cost AM21.6 AM30.1
stored in the Asset file. AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-ITEM-TAX-BASE Signed 15.2 AM115 AM125
Item Tax Base This field identifies the unit tax AM135 AM15.1
Currency amount of an item defined by this asset AM15.2 AM15.3
record in the company base currency. AM15.4 AM154
This amount is multiplied by the item AM170 AM20.1
quantity to calculate the total tax AM20.2 AM20.3
amount to be added to the asset tax. The AM20.4 AM20.5
sum of the products of all associated AM20.6 AM21.1
item tax and item quantity fields must AM21.2 AM21.3
equal the total asset tax amount in the AM21.4 AM21.5
Asset file. AM21.6 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 AM125
Item Cost This field identifies the unit cost of AM135 AM15.1
Transaction Currency an item defined by this record in the AM15.2 AM15.3
transaction currency. 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 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-ITEM-TAX-TRAN Signed 15.2 AM115 AM125
Item Tax This field identifies the unit tax AM135 AM15.1
Transaction Currency amount of an item defined by this asset AM15.2 AM15.3
record in the transaction currency. 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 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-BASE-ND Numeric 1 AM115 AM125
Base Number of The number of decimal positions defined AM15.1 AM15.2
Decimals for the company base currency. 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-TRAN-ND Numeric 1 AM115 AM125
Transaction Number The number of decimal positions defined AM15.1 AM15.2
of Decimals for the transaction currency. 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-PO-NBR Alpha 14 AM115 AM125
PO Number The purchase order number field is an AM15.1 AM15.2
optional field for your reference. It is AM15.3 AM15.4
assumed to contain the original purchase AM170 AM20.1
order number on which this asset item AM20.2 AM20.3
was included. 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-RELEASE Numeric 4 AM115 AM125
PO Release Used to identify a purchase order AM15.1 AM15.2
release (created from a Blanket or AM15.3 AM15.4
Standing order). 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-CODE Alpha 4 AM115 AM125
PO Code This is the purchase order code. 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 AM30.1
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
ASI-VENDOR Alpha 9 (Right Justified) AM115 AM125
Vendor The vendor number associated with the AM15.1 AM15.2
asset item record. 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-NAME Alpha 30 AM115 AM125
Vendor Name The name of the vendor associated with AM15.1 AM15.2
the asset item. 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-INVOICE Alpha 22 AM115 AM125
Invoice The invoice number associated with the AM15.1 AM15.2
asset item. 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-SUFFIX Numeric 3 AM115 AM125
Suffix The invoice suffix number associated AM15.1 AM15.2
with the asset item record. 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 AM551
AM96.1 AM98.1
ASI-DIST-SEQ-NBR Numeric 4 AM115 AM125
Distribution The distribution sequence number AM15.1 AM15.2
Sequence Number associated with the asset item. 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-MODEL-NUMBER Alpha 30 AM115 AM125
Model Number The model number of the asset item. AM15.1 AM15.2
Represents the manufacturer identifier AM15.3 AM15.4
of an asset brand. 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-SERIAL-NUMBER Alpha 30 AM115 AM125
Serial Number This optional field is used for the AM15.1 AM15.2
serial number of the asset. The serial AM15.3 AM15.4
number represents a unique manufacturer AM170 AM20.1
identifier of an asset by model. 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-ACTIVITY Alpha 15 AM115 AM125
Activity The activity assigned to the asset item. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
Activities are the processes or AM20.2 AM20.3
procedures that produce work. Cost AM20.4 AM20.5
objects (products, services, customers, AM20.6 AM21.1
and so on) are the reasons for AM21.2 AM21.3
performing the activity. Activities and AM21.4 AM21.5
cost object activities are used AM21.6 AM30.1
synonymously in the Lawson Activity AM500 AM51.1
Management system. AM551 AM96.1
AM97.1 AM98.1
ASI-ACCT-CATEGORY Alpha 5 AM115 AM125
Account Category The account category assigned to the AM15.1 AM15.2
asset item. AM15.3 AM15.4
AM170 AM20.1
Account categories are groupings of AM20.2 AM20.3
costs, revenues, or a combination of AM20.4 AM20.5
both used for reporting and inquiries AM20.6 AM21.1
for activities in the Lawson Activity AM21.2 AM21.3
Management system. All transactions are AM21.4 AM21.5
posted to an account category within an AM21.6 AM500
activity. AM51.1 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 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 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 AM500
AM51.1 AM551
AM97.1
ASI-BAR-CODE Alpha 30 AM115 AM125
Bar Code This file contains the bar code AM135 AM15.1
assigned to the asset item. AM15.2 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-ITEM-LOC-DTL Alpha 14 AM115 AM125
Item Loc Dtl The field contains the asset location AM135 AM15.1
detail. AM15.2 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 AM125
Invoice Date This field contains the system-generated AM15.1 AM15.2
date of the last inventory. AM15.3 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 AM125
Inv Time This field contains the system-generated AM15.1 AM15.2
time of the last inventory. AM15.3 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 AM125
Inv Item Cond This field contains an assessment of AM15.1 AM15.2
the inventory item's condition. Valid AM15.3 AM15.4
values are: AM152 AM170
G = Good AM20.1 AM20.2
F = Fair AM20.3 AM20.4
D = Damaged 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-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 KeyChange
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
|