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
AM145 AM153 AM190 AM221 AM223 AM245
AM25.1 AM25.3 AM250 AM266 AM41.1 AM45.1
AM45.3 AM55.1 AM70.1 AM70.3 AMAS.1 AMBD.2
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 AM22.1 AM22.2 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
AP510 API1.1 API2.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 MA126 MA180 MA278 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 MA53.1 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 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 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.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 AM330

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 AM22.2
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
AP510 API1.1
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 AM22.2
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
AP510 API1.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.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
AM22.2 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 AP510
API1.1 API2.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
AM22.2 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 AP510
API1.1 API2.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
AM22.2 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 AP510
API1.1 API2.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
AM22.2 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 AP510
API1.1 API2.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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
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 AM22.2
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
AP510 API1.1
API2.1 CX100
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 AM22.2
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
AP510 API1.1
API2.1 CX100
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 AM22.2
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
AP510 API1.1
API2.1 CX100
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
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
AM22.2 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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
ASI-GEO-TYPE
Element: Customer Code
Alpha 4
ASI-GEO-LATITUDE
Element: Gis Coordinate
Signed 12.6
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
ASI-GEO-LONGITUDE
Element: Gis Coordinate
Signed 12.6
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
ASI-GEO-ALTITUDE
Element: Gis Coordinate
Signed 12.6
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
ASI-GEO-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
ASI-GEO-TIME
Element: Sys Time
Numeric 6 (hhmmss)
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1


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
AM190 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
ASISET2 ASSET
ITEM-NBR
SEQ-NUMBER
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM153
AM170 AM19.1
AM19.2 AM190
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 AM22.2
AM225 AM30.1
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
Amastitbod AMASTITBOD Not Required, Delete Cascades
ASI-ASSET->YAU-ASSET
ASI-SEQ-NUMBER->YAU-SEQ-NUMBER
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 02:05:09 2016

Home
Contact Us



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