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
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
AC160 AM115 AM117 AM125 AM135 AM15.1
AM15.2 AM15.3 AM15.4 AM152 AM154 AM170
AM19.1 AM19.2 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 AP115 AP125 AP126 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 API1.1 API2.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POID.1
POII.1 POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
AM330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASI-ASSET Numeric 10 AC160 AM115
Element: Asset The asset number associated with the AM117 AM125
asset item record. AM135 AM15.1
AM15.2 AM15.3
The asset number contains up to ten AM15.4 AM154
numeric characters that uniquely AM170 AM19.1
identify an asset. Assets are AM19.2 AM192
automatically numbered system-wide. The AM20.1 AM20.2
asset number does not change unless an AM20.3 AM20.4
asset is partially transferred or AM20.5 AM20.6
disposed of. 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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
...
ASI-SEQ-NUMBER Numeric 6 AC160 AM115
Element: Sequence NumbeA unique sequence number assigned to AM117 AM125
the asset item record. AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1 AMDL.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
...
ASI-ITEM-NBR Alpha 32 AC160 AM115
Element: Item Number The number assigned to the asset item. AM117 AM125
The item number must be unique within an AM15.1 AM15.2
asset, but can be duplicated from asset AM15.3 AM15.4
to asset. AM170 AM19.1
AM19.2 AM20.1
An asset can be composed of more than AM20.2 AM20.3
one asset item, but the items are AM20.4 AM20.5
depreciated as a common asset unit. AM20.6 AM21.1
Items are not depreciated separately. AM21.2 AM21.3
However, items can be partially or AM21.4 AM21.5
separately transferred or disposed of. AM21.6 AM30.1
AM30.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Element: Description The asset item description. AM117 AM125
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
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) AC160 AM115
Element: Purchase Date The date the asset item was purchased. AM117 AM125
This purchased date can be different AM15.1 AM15.2
from the in-service dates for the AM15.3 AM15.4
depreciation books used. AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-ITEM-QUANTITY Numeric 8 AC160 AM115
Element: Item Quantity The number of units that make up the AM117 AM125
asset item. Each unit of an item is AM135 AM15.1
exactly the same as every other unit of AM15.2 AM15.3
the item. AM15.4 AM154
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
...
ASI-ITEM-COST-BASE Signed 18.2 AC160 AM115
Item Cost Base This field identifies the unit cost of AM117 AM125
Currency an item defined by this record in the AM135 AM15.1
company base currency. The item cost is AM15.2 AM15.3
multiplied by the item quantity to AM15.4 AM154
calculate the total cost amount to be AM170 AM19.1
added to the asset cost. AM19.2 AM20.1
AM20.2 AM20.3
The sum of the products of all AM20.4 AM20.5
associated item cost and item quantity AM20.6 AM21.1
fields must equal the total asset cost AM21.2 AM21.3
stored in the Asset file. AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM40.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
...
ASI-ITEM-TAX-BASE Signed 18.2 AC160 AM115
Item Tax Base This field identifies the unit tax AM117 AM125
Currency amount of an item defined by this asset AM135 AM15.1
record in the company base currency. AM15.2 AM15.3
This amount is multiplied by the item AM15.4 AM154
quantity to calculate the total tax AM170 AM19.1
amount to be added to the asset tax. The AM19.2 AM20.1
sum of the products of all associated AM20.2 AM20.3
item tax and item quantity fields must AM20.4 AM20.5
equal the total asset tax amount in the AM20.6 AM21.1
Asset file. 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
...
ASI-ITEM-COST-TRAN Signed 18.2 AC160 AM115
Item Cost This field identifies the unit cost of AM117 AM125
Transaction Currency an item defined by this record in the AM135 AM15.1
transaction currency. AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
...
ASI-ITEM-TAX-TRAN Signed 18.2 AC160 AM115
Item Tax This field identifies the unit tax AM117 AM125
Transaction Currency amount of an item defined by this asset AM135 AM15.1
record in the transaction currency. AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
...
ASI-BASE-ND Numeric 1 AC160 AM115
Base Number of The number of decimal positions defined AM117 AM125
Decimals for the company base currency. AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
...
ASI-TRAN-ND Numeric 1 AC160 AM115
Transaction Number The number of decimals assigned to a AM117 AM125
of Decimals particular account as determined by the AM15.1 AM15.2
account currency. AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-PO-NBR Alpha 14 AC160 AM115
Element: PO Number The purchase order number field is an AM117 AM125
optional field for your reference. It is AM15.1 AM15.2
assumed to contain the original purchase AM15.3 AM15.4
order number on which this asset item AM170 AM19.1
was included. AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-PO-RELEASE Numeric 4 AC160 AM115
Element: PO Release Used to identify a purchase order AM117 AM125
release (created from a Blanket or AM15.1 AM15.2
Standing order). AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-PO-CODE Alpha 4 AC160 AM115
Element: PO Code This is the purchase order code. AM117 AM125
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Vendor The vendor number associated with the AM117 AM125
asset item record. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-VENDOR-NAME Alpha 30 AC160 AM115
Element: Vendor Name The name of the vendor associated with AM117 AM125
the asset item. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-INVOICE Alpha 22 AC160 AM115
Element: Invoice The invoice number associated with the AM117 AM125
asset item. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-SUFFIX Numeric 3 AC160 AM115
Element: Suffix The invoice suffix number associated AM117 AM125
with the asset item record. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-DIST-SEQ-NBR Numeric 6 AC160 AM115
Distribution The distribution sequence number AM117 AM125
Sequence Number associated with the asset item. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-MODEL-NUMBER Alpha 30 AC160 AM115
Element: Model Number The model number of the asset item. AM117 AM125
Represents the manufacturer identifier AM15.1 AM15.2
of an asset brand. AM15.3 AM15.4
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-SERIAL-NUMBER Alpha 30 AC160 AM115
Element: Serial Number This optional field is used for the AM117 AM125
serial number of the asset. The serial AM15.1 AM15.2
number represents a unique manufacturer AM15.3 AM15.4
identifier of an asset by model. AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-ACTIVITY Alpha 15 AC160 AM115
Element: Activity The activity assigned to the asset item. AM117 AM125
AM15.1 AM15.2
AM15.3 AM15.4
Activities are the processes or AM170 AM19.1
procedures that produce work. Cost AM19.2 AM20.1
objects (products, services, customers, AM20.2 AM20.3
and so on) are the reasons for AM20.4 AM20.5
performing the activity. Activities and AM20.6 AM21.1
cost object activities are used AM21.2 AM21.3
synonymously in the Lawson Activity AM21.4 AM21.5
Management system. AM21.6 AM30.1
AM30.2 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
...
ASI-ACCT-CATEGORY Alpha 5 AC160 AM115
Element: Account CategoThe account category assigned to the AM117 AM125
asset item. AM15.1 AM15.2
AM15.3 AM15.4
Account categories are groupings of AM170 AM19.1
costs, revenues, or a combination of AM19.2 AM20.1
both used for reporting and inquiries AM20.2 AM20.3
for activities in the Lawson Activity AM20.4 AM20.5
Management system. All transactions are AM20.6 AM21.1
posted to an account category within an AM21.2 AM21.3
activity. AM21.4 AM21.5
AM21.6 AM500
AM51.1 AM551
AM96.1 AM97.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
...
ASI-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date The date the asset item record was AM117 AM135
created. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM30.1
AM30.2 AM500
AM51.1 AM551
AM97.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
...
ASI-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time The time the asset item record was AM117 AM135
created. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM30.1
AM30.2 AM500
AM51.1 AM551
AM97.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
...
ASI-CREATOR-ID Alpha 10 AC160 AM115
Element: Creator ID This field identifies the operator that AM117 AM135
created the asset item record. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM30.1
AM30.2 AM500
AM51.1 AM551
AM97.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
...
ASI-BAR-CODE Alpha 30 AC160 AM115
Element: Bar Code This file contains the bar code AM117 AM125
assigned to the asset item. AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
...
ASI-ITEM-LOC-DTL Alpha 14 AC160 AM115
Element: Item Loc Dtl The field contains the asset location AM117 AM125
detail. AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
...
ASI-INV-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Inv Date This field contains the AM117 AM125
system-generated date of the last AM15.1 AM15.2
inventory. AM15.3 AM15.4
AM152 AM170
AM19.1 AM19.2
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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
ASI-INV-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Inv Time This field contains the system-generated AM117 AM125
time of the last inventory. AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM170
AM19.1 AM19.2
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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
ASI-INV-ITEM-COND Alpha 1 AC160 AM115
Element: Inv Item Cond This field contains an assessment of AM117 AM125
the inventory item's condition. Valid AM15.1 AM15.2
values are: AM15.3 AM15.4
G = Good AM152 AM170
F = Fair AM19.1 AM19.2
D = Damaged 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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
...
ASI-OBJ-ID Numeric 12 AC160 AM115
Element: Obj Id This is the object identifier. It is AM117 AM15.1
used to relate commitments or posted AM15.2 AM15.3
transactions back to the originating AM15.4 AM19.1
subsystems. Each subsystem record that AM19.2 AM20.1
is updated as a commitment or posted AM20.3 AM21.1
transaction is assigned an object AM21.3 AM500
identifier. The object identifier is AM51.1 AM551
maintained in the subsystem files and in AM97.1 AP115
the Activity Commitments Detail and AP125 AP126
Activity Transaction files. The object AP131 AP20.1
identifier is a unique key used to drill AP20.2 AP20.3
back from Activity Management to the AP20.4 AP20.5
subsystems. AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
...
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 Curr Code This field indicates the asset currency.
ASI-INV-COMPANY Numeric 4 AC160 AM115
Element: Company Identifies the AP company if the AM117 AM15.1
resource type = V. Identifies the HR AM15.2 AM15.3
company if the resource type = E. It is AM15.4 AM19.1
blank for type A, P or Q resources. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
...
ASI-PO-AST-OBJ-ID Numeric 12 AC160 AM115
Element: Obj Id This is the object identifier. It is AM117 AM15.1
used to relate commitments or posted AM15.2 AM15.3
transactions back to the originating AM15.4 AM19.1
subsystems. Each subsystem record that AM19.2 AM20.1
is updated as a commitment or posted AM20.3 AM21.1
transaction is assigned an object AM21.3 AM500
identifier. The object identifier is AM51.1 AM551
maintained in the subsystem files and in AM97.1 AP115
the Activity Commitments Detail and AP125 AP126
Activity Transaction files. The object AP131 AP20.1
identifier is a unique key used to drill AP20.2 AP20.3
back from Activity Management to the AP20.4 AP20.5
subsystems. AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
...
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
AM19.1 AM19.2
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
...
ASISET2 ASSET KeyChange AM153 AM20.3
ITEM-NBR AM21.3 AM225
SEQ-NUMBER AM40.1 AM40.2
ASISET3 SERIAL-NUMBER KeyChange AM40.1
ASSET
SEQ-NUMBER
ASISET4 BAR-CODE KeyChange AC160 AM115
ASSET AM117 AM15.1
SEQ-NUMBER AM15.2 AM15.3
AM15.4 AM152
AM153 AM154
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM252 AM500
AM51.1 AM52.1
AM551 AM97.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
...
ASISET5 ITEM-LOC-DTL KeyChange AM07.3
ASSET
SEQ-NUMBER
ASISET6 PO-AST-OBJ-ID KeyChange, Subset
Where PO-AST-OBJ-ID != Zeroes
AMASTITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Activity ACACTIVITY Not Required
ASI-ACTIVITY -> ACV-ACTIVITY (ACVSET1)
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
|