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.
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.
|
|
ASI-SEQ-NUMBER Element: Sequence Number | Numeric 6 A unique sequence number assigned to
the asset item record.
|
|
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.
|
|
ASI-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The asset item description.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
ASI-BASE-ND Base Number of Decimals | Numeric 1 The number of decimal positions defined
for the company base currency.
|
|
ASI-TRAN-ND Transaction Number of Decimals | Numeric 1 The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
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.
|
|
ASI-PO-RELEASE Element: PO Release | Numeric 4 Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
ASI-PO-CODE Element: PO Code | Alpha 4 This is the purchase order code.
|
|
ASI-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor number associated with the
asset item record.
|
|
ASI-VENDOR-NAME Element: Vendor Name | Alpha 30 The name of the vendor associated with
the asset item.
|
|
ASI-INVOICE Element: Invoice | Alpha 22 The invoice number associated with the
asset item.
|
|
ASI-SUFFIX Element: Suffix | Numeric 3 The invoice suffix number associated
with the asset item record.
|
|
ASI-DIST-SEQ-NBR Distribution Sequence Number | Numeric 6 The distribution sequence number
associated with the asset item.
|
|
ASI-MODEL-NUMBER Element: Model Number | Alpha 30 The model number of the asset item.
Represents the manufacturer identifier
of an asset brand.
|
|
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.
|
|
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.
|
|
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.
|
|
ASI-CREATION-DATE Element: Creation Date | Numeric 8 (yyyymmdd) The date the asset item record was
created.
|
|
ASI-CREATION-TIME Element: Creation Time | Numeric 6 (hhmmss) The time the asset item record was
created.
|
|
ASI-CREATOR-ID Element: Creator ID | Alpha 10 This field identifies the operator that
created the asset item record.
|
|
ASI-BAR-CODE Element: Bar Code | Alpha 30 This file contains the bar code
assigned to the asset item.
|
|
ASI-ITEM-LOC-DTL Element: Item Loc Dtl | Alpha 14 The field contains the asset location
detail.
|
|
ASI-INV-DATE Element: Inv Date | Numeric 8 (yyyymmdd) This field contains the
system-generated date of the last
inventory.
|
|
ASI-INV-TIME Element: Inv Time | Numeric 6 (hhmmss) This field contains the system-generated
time of the last inventory.
|
|
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
|
|
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.
|
|
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.
|
|
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.
|
|
ASI-GRANT Element: Grant | Alpha 30
|
|
ASI-GEO-TYPE Element: Customer Code | Alpha 4
|
|
ASI-GEO-LATITUDE Element: Gis Coordinate | Signed 12.6
|
|
ASI-GEO-LONGITUDE Element: Gis Coordinate | Signed 12.6
|
|
ASI-GEO-ALTITUDE Element: Gis Coordinate | Signed 12.6
|
|
ASI-GEO-DATE Element: Date | Numeric 8 (yyyymmdd)
|
|
ASI-GEO-TIME Element: Sys Time | Numeric 6 (hhmmss)
|
|