Lawson Insight Technical Documentation |
|
AMASTITEM
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 AM117 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 AM117
Element: Asset The asset number associated with the AM125 AM135
asset item record. AM15.1 AM15.2
AM15.3 AM15.4
The asset number contains up to ten AM154 AM170
numeric characters that uniquely AM192 AM20.1
identify an asset. Assets are AM20.2 AM20.3
automatically numbered system-wide. The AM20.4 AM20.5
asset number does not change unless an AM20.6 AM21.1
asset is partially transferred or AM21.2 AM21.3
disposed of. 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-SEQ-NUMBER Numeric 6 AM115 AM117
Element: Sequence NumbeA unique sequence number assigned to AM125 AM135
the asset item record. AM15.1 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 AM117
Element: Item Number The number assigned to the asset item. AM125 AM15.1
The item number must be unique within an AM15.2 AM15.3
asset, but can be duplicated from asset AM15.4 AM170
to asset. AM20.1 AM20.2
AM20.3 AM20.4
An asset can be composed of more than AM20.5 AM20.6
one asset item, but the items are AM21.1 AM21.2
depreciated as a common asset unit. AM21.3 AM21.4
Items are not depreciated separately. AM21.5 AM21.6
However, items can be partially or AM30.1 AM500
separately transferred or disposed of. AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-DESCRIPTION Alpha 30 (Lower Case) AM115 AM117
Element: Description The asset item description. AM125 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
Element: 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 AM117
Element: Purchase Date The date the asset item was purchased. AM125 AM15.1
This purchased date can be different AM15.2 AM15.3
from the in-service dates for the AM15.4 AM170
depreciation books used. 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-QUANTITY Numeric 8 AM115 AM117
Element: Item Quantity The number of units that make up the AM125 AM135
asset item. Each unit of an item is AM15.1 AM15.2
exactly the same as every other unit of AM15.3 AM15.4
the item. 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-COST-BASE Signed 18.2 AM115 AM117
Item Cost Base This field identifies the unit cost of AM125 AM135
Currency an item defined by this record in the AM15.1 AM15.2
company base currency. The item cost is AM15.3 AM15.4
multiplied by the item quantity to AM154 AM170
calculate the total cost amount to be AM20.1 AM20.2
added to the asset cost. AM20.3 AM20.4
AM20.5 AM20.6
The sum of the products of all AM21.1 AM21.2
associated item cost and item quantity AM21.3 AM21.4
fields must equal the total asset cost AM21.5 AM21.6
stored in the Asset file. AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
ASI-ITEM-TAX-BASE Signed 18.2 AM115 AM117
Item Tax Base This field identifies the unit tax AM125 AM135
Currency amount of an item defined by this asset AM15.1 AM15.2
record in the company base currency. AM15.3 AM15.4
This amount is multiplied by the item AM154 AM170
quantity to calculate the total tax AM20.1 AM20.2
amount to be added to the asset tax. The AM20.3 AM20.4
sum of the products of all associated AM20.5 AM20.6
item tax and item quantity fields must AM21.1 AM21.2
equal the total asset tax amount in the AM21.3 AM21.4
Asset file. 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-TRAN Signed 18.2 AM115 AM117
Item Cost This field identifies the unit cost of AM125 AM135
Transaction Currency an item defined by this record in the AM15.1 AM15.2
transaction currency. 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
AM40.1 AM40.2
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
ASI-ITEM-TAX-TRAN Signed 18.2 AM115 AM117
Item Tax This field identifies the unit tax AM125 AM135
Transaction Currency amount of an item defined by this asset AM15.1 AM15.2
record in the transaction currency. 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
AM40.1 AM40.2
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
ASI-BASE-ND Numeric 1 AM115 AM117
Base Number of The number of decimal positions defined AM125 AM135
Decimals for the company base currency. AM15.1 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-TRAN-ND Numeric 1 AM115 AM117
Transaction Number The number of decimal positions defined AM125 AM15.1
of Decimals for the transaction currency. 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-PO-NBR Alpha 14 AM115 AM117
Element: PO Number The purchase order number field is an AM125 AM15.1
optional field for your reference. It is AM15.2 AM15.3
assumed to contain the original purchase AM15.4 AM170
order number on which this asset item AM20.1 AM20.2
was included. 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-RELEASE Numeric 4 AM115 AM117
Element: PO Release Used to identify a purchase order AM125 AM15.1
release (created from a Blanket or AM15.2 AM15.3
Standing order). 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-CODE Alpha 4 AM115 AM117
Element: PO Code This is the purchase order code. AM125 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 AM117
Element: Vendor The vendor number associated with the AM125 AM15.1
asset item record. 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-NAME Alpha 30 AM115 AM117
Element: Vendor Name The name of the vendor associated with AM125 AM15.1
the asset item. 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-INVOICE Alpha 22 AM115 AM117
Element: Invoice The invoice number associated with the AM125 AM15.1
asset item. 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-SUFFIX Numeric 3 AM115 AM117
Element: Suffix The invoice suffix number associated AM125 AM15.1
with the asset item record. 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-DIST-SEQ-NBR Numeric 4 AM115 AM117
Distribution The distribution sequence number AM125 AM15.1
Sequence Number associated with the asset item. 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-MODEL-NUMBER Alpha 30 AM115 AM117
Element: Model Number The model number of the asset item. AM125 AM15.1
Represents the manufacturer identifier AM15.2 AM15.3
of an asset brand. 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-SERIAL-NUMBER Alpha 30 AM115 AM117
Element: Serial Number This optional field is used for the AM125 AM15.1
serial number of the asset. The serial AM15.2 AM15.3
number represents a unique manufacturer AM15.4 AM170
identifier of an asset by model. 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-ACTIVITY Alpha 15 AM115 AM117
Element: Activity The activity assigned to the asset item. AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM170
Activities are the processes or AM20.1 AM20.2
procedures that produce work. Cost AM20.3 AM20.4
objects (products, services, customers, AM20.5 AM20.6
and so on) are the reasons for AM21.1 AM21.2
performing the activity. Activities and AM21.3 AM21.4
cost object activities are used AM21.5 AM21.6
synonymously in the Lawson Activity AM30.1 AM500
Management system. AM51.1 AM551
AM96.1 AM97.1
AM98.1
ASI-ACCT-CATEGORY Alpha 5 AM115 AM117
Element: Account CategoThe account category assigned to the AM125 AM15.1
asset item. AM15.2 AM15.3
AM15.4 AM170
Account categories are groupings of AM20.1 AM20.2
costs, revenues, or a combination of AM20.3 AM20.4
both used for reporting and inquiries AM20.5 AM20.6
for activities in the Lawson Activity AM21.1 AM21.2
Management system. All transactions are AM21.3 AM21.4
posted to an account category within an AM21.5 AM21.6
activity. AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
ASI-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Creation Date The date the asset item record was AM135 AM15.1
created. AM15.2 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 AM117
Element: Creation Time The time the asset item record was AM135 AM15.1
created. AM15.2 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 AM117
Element: Creator ID This field identifies the operator that AM135 AM15.1
created the asset item record. AM15.2 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 AM117
Element: Bar Code This file contains the bar code AM125 AM135
assigned to the asset item. AM15.1 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 AM117
Element: Item Loc Dtl The field contains the asset location AM125 AM135
detail. AM15.1 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 AM117
Element: Invoice Date This field contains the system-generated AM125 AM15.1
date of the last inventory. AM15.2 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 AM117
Element: Inv Time This field contains the system-generated AM125 AM15.1
time of the last inventory. AM15.2 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 AM117
Element: Inv Item Cond This field contains an assessment of AM125 AM15.1
the inventory item's condition. Valid AM15.2 AM15.3
values are: AM15.4 AM152
G = Good AM170 AM20.1
F = Fair AM20.2 AM20.3
D = Damaged 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-OBJ-ID Numeric 12 AM115 AM117
Object This is the object identifier. It is AM15.1 AM15.2
Identification used to relate commitments or posted AM15.3 AM15.4
transactions back to the originating AM20.1 AM20.3
subsystems. Each subsystem record that AM21.1 AM21.3
is updated as a commitment or posted AM500 AM51.1
transaction is assigned an object AM551 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
Element: Tag The user-defined tag number assigned to
the associated asset record.
ASI-ASSET-GRP Derived
Element: Asset Group The asset group assigned to the
associated asset record. Represents a
parent number used for report grouping.
ASI-GL-CURR-CODE Derived
Element: GL Currency CoThis field indicates the asset currency.
ASI-INV-COMPANY Numeric 4 AM115 AM117
Element: Company AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
ASI-PO-AST-OBJ-ID Numeric 12
Object
Identification
AMASTITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASISET1 ASSET AC160 AM115
SEQ-NUMBER AM117 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
...
ASISET2 ASSET KeyChange AM153 AM20.3
ITEM-NBR AM21.3 AM225
SEQ-NUMBER AM40.1
ASISET3 SERIAL-NUMBER KeyChange AM40.1
ASSET
SEQ-NUMBER
ASISET4 BAR-CODE KeyChange AM115 AM117
ASSET AM15.1 AM15.2
SEQ-NUMBER AM15.3 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
Apinvoice2 APINVOICE Required
ASI-INV-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
|