AMASTITEM

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
AM153 AM266 AMAS.1 AMBK.1 AMDL.1 AM252


UPDATED BY
AC160 AM07.3 AM115 AM117 AM125 AM135
AM145 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 AM22.1
AM221 AM223 AM225 AM245 AM25.1 AM25.3
AM250 AM30.1 AM30.2 AM300 AM330 AM40.1
AM40.2 AM45.1 AM45.3 AM500 AM51.1 AM52.1
AM551 AM70.1 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 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC140 IC66.1 IC83.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO28.2 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIF.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASI-ASSET
Element: Asset
Numeric 10
The asset number associated with the asset item record. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. The asset number does not change unless an asset is partially transferred or disposed of.
...
AC160 AM115
AM117 AM125
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
AM22.1 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 CX100
ASI-SEQ-NUMBER
Element: Sequence Number
Numeric 6
A unique sequence number assigned to the asset item record.
...
AC160 AM115
AM117 AM125
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
AM22.1 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 CX100
ASI-ITEM-NBR
Element: Item Number
Alpha 32
The number assigned to the asset item. The item number must be unique within an asset, but can be duplicated from asset to asset. An asset can be composed of more than one asset item, but the items are depreciated as a common asset unit. Items are not depreciated separately. However, items can be partially or separately transferred or disposed of.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The asset item description.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-ITEM-PROCESS
Element: Item Process
Alpha 3
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.
AM135 AM154
AM30.1 AM30.2
ASI-PURCHASE-DATE
Element: Purchase Date
Numeric 8 (yyyymmdd)
The date the asset item was purchased. This purchased date can be different from the in-service dates for the depreciation books used.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-ITEM-QUANTITY
Element: Item Quantity
Numeric 8
The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
ASI-ITEM-COST-BASE
Item Cost Base
Currency
Signed 18.2
This field identifies the unit cost of an item defined by this record in the company base currency. The item cost is multiplied by the item quantity to calculate the total cost amount to be added to the asset cost. The sum of the products of all associated item cost and item quantity fields must equal the total asset cost stored in the Asset file.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
ASI-ITEM-TAX-BASE
Item Tax Base
Currency
Signed 18.2
This field identifies the unit tax amount of an item defined by this asset record in the company base currency. This amount is multiplied by the item quantity to calculate the total tax amount to be added to the asset tax. The sum of the products of all associated item tax and item quantity fields must equal the total asset tax amount in the Asset file.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
ASI-ITEM-COST-TRAN
Item Cost
Transaction Currency
Signed 18.2
This field identifies the unit cost of an item defined by this record in the transaction currency.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
ASI-ITEM-TAX-TRAN
Item Tax
Transaction Currency
Signed 18.2
This field identifies the unit tax amount of an item defined by this asset record in the transaction currency.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
ASI-BASE-ND
Base Number of
Decimals
Numeric 1
The number of decimal positions defined for the company base currency.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-TRAN-ND
Transaction Number
of Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-PO-NBR
Element: PO Number
Alpha 14
The purchase order number field is an optional field for your reference. It is assumed to contain the original purchase order number on which this asset item was included.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-PO-RELEASE
Element: PO Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-PO-CODE
Element: PO Code
Alpha 4
This is the purchase order code.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor number associated with the asset item record.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-VENDOR-NAME
Element: Vendor Name
Alpha 30
The name of the vendor associated with the asset item.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-INVOICE
Element: Invoice
Alpha 22
The invoice number associated with the asset item.
...
AC160 AM115
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
ASI-SUFFIX
Element: Suffix
Numeric 3
The invoice suffix number associated with the asset item record.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-DIST-SEQ-NBR
Distribution
Sequence Number
Numeric 6
The distribution sequence number associated with the asset item.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-MODEL-NUMBER
Element: Model Number
Alpha 30
The model number of the asset item. Represents the manufacturer identifier of an asset brand.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-SERIAL-NUMBER
Element: Serial Number
Alpha 30
This optional field is used for the serial number of the asset. The serial number represents a unique manufacturer identifier of an asset by model.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-ACTIVITY
Element: Activity
Alpha 15
The activity assigned to the asset item. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-ACCT-CATEGORY
Element: Account Category
Alpha 5
The account category assigned to the asset item. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
The date the asset item record was created.
...
AC160 AM115
AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
ASI-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
The time the asset item record was created.
...
AC160 AM115
AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
ASI-CREATOR-ID
Element: Creator ID
Alpha 10
This field identifies the operator that created the asset item record.
...
AC160 AM115
AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
ASI-BAR-CODE
Element: Bar Code
Alpha 30
This file contains the bar code assigned to the asset item.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-ITEM-LOC-DTL
Element: Item Loc Dtl
Alpha 14
The field contains the asset location detail.
...
AC160 AM115
AM117 AM125
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
ASI-INV-DATE
Element: Inv Date
Numeric 8 (yyyymmdd)
This field contains the system-generated date of the last inventory.
...
AC160 AM115
AM117 AM125
AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM152
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
AM22.1 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 CX100
CX20.1 CX20.2
ASI-INV-TIME
Element: Inv Time
Numeric 6 (hhmmss)
This field contains the system-generated time of the last inventory.
...
AC160 AM115
AM117 AM125
AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM152
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
AM22.1 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 CX100
CX20.1 CX20.2
ASI-INV-ITEM-COND
Element: Inv Item Cond
Alpha 1
This field contains an assessment of the inventory item's condition. Valid values are: G = Good F = Fair D = Damaged
...
AC160 AM115
AM117 AM125
AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM152
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
AM22.1 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 CX100
CX20.1 CX20.2
ASI-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object 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.
...
AC160 AM115
AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
ASI-TAG
Element: Tag
Derived
The user-defined tag number assigned to the associated asset record.
ASI-ASSET-GRP
Element: Asset Group
Derived
The asset group assigned to the associated asset record. Represents a parent number used for report grouping.
ASI-GL-CURR-CODE
Element: Gl Curr Code
Derived
This field indicates the asset currency.
ASI-INV-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
...
AC160 AM115
AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
ASI-PO-AST-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object 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.
...
AC160 AM115
AM117 AM135
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
ASI-GRANT
Element: Grant
Alpha 30
...
AC160 AM115
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 AM22.1
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220


AMASTITEM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASISET1 ASSET
SEQ-NUMBER
...
AC160 AM115
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 AM22.1
ASISET2 ASSET
ITEM-NBR
SEQ-NUMBER
KeyChange
AM153 AM20.3
AM21.3 AM22.1
AM225 AM40.1
AM40.2
ASISET3 SERIAL-NUMBER
ASSET
SEQ-NUMBER
KeyChange
AM40.1
ASISET4 BAR-CODE
ASSET
SEQ-NUMBER
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM152
AM153 AM154
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM22.1 AM252
AM500 AM51.1
AM52.1 AM551
AM97.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
ASISET5 ITEM-LOC-DTL
ASSET
SEQ-NUMBER
KeyChange
AM07.3
ASISET6 PO-AST-OBJ-ID
KeyChange, Subset
WherePO-AST-OBJ-ID !=Zeroes


AMASTITEM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:05:49 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.