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
AMBK.1


UPDATED BY
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 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PO136 PO190
PO300 PO520 POCP.1 POI3.1 POII.1 POIJ.1
AM145 AM153 AM221 AM223 AM245 AM25.1
AM25.3 AM250 AM266 AM330 AM45.1 AM45.3
AM70.1 AMAS.1 AMDL.1 AM225 AM252 AM52.1
AM07.3

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.
...
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 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 MA41.1
MA41.2 MA41.4
ASI-SEQ-NUMBER
Element: Sequence Number
Numeric 6
A unique sequence number assigned to the asset item record.
...
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 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 MA41.1
MA41.2 MA41.4
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The asset item description.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
ASI-BASE-ND
Base Number of
Decimals
Numeric 1
The number of decimal positions defined for the company base currency.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-TRAN-ND
Transaction Number
of Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-PO-RELEASE
Element: PO Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-PO-CODE
Element: PO Code
Alpha 4
This is the purchase order code.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor number associated with the asset item record.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-VENDOR-NAME
Element: Vendor Name
Alpha 30
The name of the vendor associated with the asset item.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-INVOICE
Element: Invoice
Alpha 22
The invoice number associated with the asset item.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
ASI-SUFFIX
Element: Suffix
Numeric 3
The invoice suffix number associated with the asset item record.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-DIST-SEQ-NBR
Distribution
Sequence Number
Numeric 6
The distribution sequence number associated with the asset item.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-MODEL-NUMBER
Element: Model Number
Alpha 30
The model number of the asset item. Represents the manufacturer identifier of an asset brand.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
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.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
The date the asset item record was created.
...
AM115 AM117
AM135 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
ASI-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
The time the asset item record was created.
...
AM115 AM117
AM135 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
ASI-CREATOR-ID
Element: Creator ID
Alpha 10
This field identifies the operator that created the asset item record.
...
AM115 AM117
AM135 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
ASI-BAR-CODE
Element: Bar Code
Alpha 30
This file contains the bar code assigned to the asset item.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-ITEM-LOC-DTL
Element: Item Loc Dtl
Alpha 14
The field contains the asset location detail.
...
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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ASI-INV-DATE
Element: Inv Date
Numeric 8 (yyyymmdd)
This field contains the system-generated date of the last inventory.
...
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 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
ASI-INV-TIME
Element: Inv Time
Numeric 6 (hhmmss)
This field contains the system-generated time of the last inventory.
...
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 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
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
...
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 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
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.
...
AM115 AM117
AM135 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.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.
...
AM115 AM117
AM135 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.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.
...
AM115 AM117
AM135 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
ASI-GRANT
Element: Grant
Alpha 30
...
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
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
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
SEQ-NUMBER
...
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
AM221 AM223
ASISET2 ASSET
ITEM-NBR
SEQ-NUMBER
KeyChange
AM153 AM20.3
AM21.3 AM225
AM40.1 AM40.2
ASISET3 SERIAL-NUMBER
ASSET
SEQ-NUMBER
KeyChange
AM40.1
ASISET4 BAR-CODE
ASSET
SEQ-NUMBER
KeyChange
...
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 AM252
AM500 AM51.1
AM52.1 AM551
AM97.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
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: Wed Jun 08 20:47:07 2016

Home
Contact Us



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