This file contains asset information interfaced into the Asset Management
system from Activity Management, Accounts Payable, or a handheld (HHT)
terminal. AC160 (Asset Interface) interfaces asset information from Activity
Management. Various Accounts Payable programs interface asset information
from Accounts Payable when invoices containing assets are released. The
handheld terminal file (x-AMADD.txt) is imported into this file using the
importdb utility.
You can view and adjust interfaced asset information in the AM15 forms: AM15.1
(Single Invoice Interface), AM15.2 (Combine Invoice Interface), AM15.3 (Single
Activity Interface), and AM15.4 (Combine Activity Interface). AM115
(Mass Additions) updates Asset Management with adjustments to the interfaced
asset information.
UPDATED BY
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
AMI-COMPANY
Element: Company | Numeric 4
Required key. This is the company
number.
|
|
AMI-SEQ-NUMBER
Element: Sequence Number | Numeric 6
Required key. The sequence number is a
unique number assigned to each
transaction in the Lawson system.
|
|
AMI-ASSET-TEMPLATE
Element: Template | Alpha 10
This field contains the asset template
used to create the asset. Templates
default the required information needed
to create asset records. Asset templates
are defined in the Asset Management
application, but they can be associated
with a purchase order and invoice
during the procurement process (in RQ,
PO, or AP), or with an activity and
account category in the Activity
Management application, or with a
scanned asset during the scanning
process.
The template is a way to create assets
with very little keying; using a
template lets you default many of the
data items associated with a new asset.
An asset template is required when you
define a new asset as the result of
transactions from the Lawson Purchase
Order or Accounts Payable systems.
|
|
AMI-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
This is the identification code for the
vendor.
|
|
AMI-INVOICE
Element: Invoice | Alpha 22
This number identifies the invoice.
|
|
AMI-SUFFIX
Element: Suffix | Numeric 3
This is the suffix for the invoice. It
represents the occurrence value of the
invoice. The suffix can be used to
identify the recurrence value of a
recurring invoice.
|
|
AMI-DIST-SEQ-NBR
Distribution
Sequence Number | Numeric 6
This is a unique distribution sequence
number.
|
|
AMI-ACTIVITY
Element: Activity | Alpha 15
This is the activity asset from the
Activity Management system. Activities
and cost object activities are used
synonymously in the Lawson Activity
Management system. Direct costs are
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
|
|
AMI-ACCT-CATEGORY
Element: Account Category | Alpha 5
This is the account category associated
with an activity from the Activity
Management system. 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. You can
assign a specific General Ledger account
or range of accounts (company,
accounting unit, account, and
subaccount) that make up the
transactions posted to an account
category.
|
|
AMI-SYSTEM
Element: System | Alpha 2
The system code is a two-character code
representing an application used within
the Lawson system. (i.e.: GL = General
Ledger, AC = Activity Management, AM =
Asset Management, AP = Accounts Payable,
etc.)
|
|
AMI-ITEM-QUANTITY
Element: Item Quantity | Numeric 8
This is the number of units that make
up the asset item. Each unit of an item
must be exactly the same as every other
unit of the item.
|
|
AMI-TAG-NBR
Element: Tag | Alpha 12
This is the user-definable tag number
for the asset item.
|
|
AMI-ASSET-GROUP
Element: Asset Group | Alpha 10
This is the asset group for the asset.
An asset group represents a parent asset
used to group assets for reporting.
|
|
AMI-ASSET-DESC
Element: Asset Description | Alpha 30 (Lower Case)
This is the asset description.
|
|
AMI-PURCHASE-DATE
Element: Purchase Date | Numeric 8 (yyyymmdd)
This is the date the asset was
purchased. The purchase date can be
different from the in-service dates for
the depreciation books.
|
|
AMI-INSRV-DATE
Element: In-Service Date | Numeric 8 (yyyymmdd)
This is the in-service date for the
asset.
Note: The in-service date can be
different for each depreciation book
used.
|
|
AMI-POSTING-DATE
Element: Trans Date | Numeric 8 (yyyymmdd)
The date of the transaction.
|
|
AMI-ACCT-UNIT
Element: Accounting Unit | Alpha 15
This is the accounting unit for the
asset. The accounting unit must be
defined in the General Ledger Names file
as a posting accounting unit.
|
|
AMI-AU-GROUP
Accounting Unit
Group | Alpha 10
Accounting unit groups group and
identify the accounting units to use
when you create journal entries for
adding, adjusting, transferring, or
disposing of assets. Changes to
accounting unit groups are dynamic,
affecting all assets using the
accounting unit group. Accounting unit
group names are user-definable, and
accounting unit groups are set up by
company.
|
|
AMI-DEP-EXP-ACTVTY
Depreciation
Expense Activity | Alpha 15
This is the override depreciation
expense activity, which overrides any
depreciation expense activity set up for
an asset template on AM12.1 (Addition
Template). This is the depreciation
expense activity used for posting.
|
|
AMI-DEP-ACCT-CAT
Depr Expense
Account Category | Alpha 5
This is the override depreciation
expense account category, which
overrides any depreciation expense
account category set up for an asset
template on AM12.1 (Addition Template).
This is the depreciation expense account
used for posting.
|
|
AMI-COMBINE
Element: Combine | Alpha 10
This field indicates whether to combine
items as one asset.
|
|
AMI-ITEM-NBR
Element: Item Number | Alpha 32
The user-defined number assigned to the
asset item. The item number must be
unique within an asset, but can be
duplicated from asset to asset.
|
|
AMI-DESCRIPTION
Element: Item Description | Alpha 30 (Lower Case)
This is the item description.
|
|
AMI-ITEM-COST-BASE
Item Cost Base
Currency | Signed 18.2
This is the cost for the item in
General Ledger base currency.
|
|
AMI-ITEM-TAX-BASE
Item Tax Base
Currency | Signed 18.2
This is the tax on the item in General
Ledger base currency.
|
|
AMI-ITEM-COST-TRAN
Item Cost
Transaction Currency | Signed 18.2
This is the transaction associated with
the item, which is in General Ledger
base currency.
|
|
AMI-ITEM-TAX-TRAN
Item Tax
Transaction Currency | Signed 18.2
This is the tax transaction associated
with the item.
|
|
AMI-BASE-ND
Base Number of
Decimals | Numeric 1
This is the number of decimal positions
defined for the company base currency.
|
|
AMI-TRAN-ND
Transaction Number
of Decimals | Numeric 1
This is the defined number of decimal
positions used for the transaction.
|
|
AMI-CURRENCY-CODE
Element: Currency Code | Alpha 5
This is the base currency defined for
the company in the Lawson General Ledger
system.
|
|
AMI-PO-NBR
Purchase Order
Number | Alpha 14
The Purchase Order Number field is for
your reference. It contains the number
of the original purchase order on which
this asset was included.
|
|
AMI-PO-RELEASE
Element: PO Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
AMI-PO-CODE
Element: PO Code | Alpha 4
This is the purchase order code.
|
|
AMI-MODEL-NUMBER
Element: Model Number | Alpha 30
This is the model number of the asset
item.
|
|
AMI-SERIAL-NUMBER
Element: Serial Number | Alpha 30
This is the serial number of the asset
item.
|
|
AMI-HOLD-AM
Element: Hold | Alpha 1
This field indicates whether to hold
the asset in the Asset Interface file.
Being held keeps items from becoming
assets until they are released from
hold.
N = No
Y = Yes |
|
AMI-CREATION-DATE
Element: Creation Date | Numeric 8 (yyyymmdd)
This is the creation date for the asset
interface record.
|
|
AMI-CREATION-TIME
Element: Creation Time | Numeric 6 (hhmmss)
This is the creation time for the asset
interface record.
|
|
AMI-CREATOR-ID
Element: Creator ID | Alpha 10
This is the identifier of the person
who created the asset interface record.
|
|
AMI-ASSET-CATEGORY
Element: Category | Alpha 1
The value in this field overrides the
category value defined for the asset in
AM12.1 (Addition Template).
|
|
AMI-LOCATION-NAME
Element: Location | Alpha 15
A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
|
|
AMI-DIVISION
Element: Division | Alpha 15
A user-defined division which is used
for reporting assets.
|
|
AMI-ASSET-TYPE
Element: Asset Type | Alpha 10
An asset type represents a grouping of
like assets. Asset types are used to
group assets into reporting classes and
to default common asset definition data.
|
|
AMI-SUB-TYPE
Element: Subtype | Alpha 10
An asset subtype represents a more
detailed grouping of assets within an
asset type grouping. Asset subtypes are
used to group assets into reporting
classes and allow common asset
definition data to default. Subtypes
must be unique within an asset type.
|
|
AMI-ACCT-GRP
Element: Account Group | Alpha 10
|
|
AMI-WORK-IN-PROC
Element: Work in Process | Alpha 1
The value in this field overrides the
work-in-process value defined for the
asset in AM12.1 (Addition Template).
|
|
AMI-SIMULATED
Element: Simulated | Alpha 1
The value in this field overrides the
Simulated value defined for the asset
in AM12.1 (Addition Template).
|
|
AMI-TAX-EXEMPT
Element: Tax Exempt | Alpha 1
The value in this field overrides the
tax exempt value defined for the asset
in AM12.1 (Addition Template).
|
|
AMI-USED
Element: Used | Alpha 1
The value in this field overrides the
Used value defined for the asset in
AM12.1 (Addition Template).
|
|
AMI-BAR-CODE
Element: Bar Code | Alpha 30
This is the unique bar code assigned to
the item.
|
|
AMI-ITEM-TYPE
Element: Item Type | Alpha 1
This field is used for bar-coded items
to indicate whether the item being
scanned is a parent item (that is, the
first or only item to be scanned for the
asset) or a child item (that is the
second or more of several items scanned
for an asset). Valid values are:
P = Parent
C = Child
|
|
AMI-PROD-CAT-CODE
Element: Prod Cat Code | Alpha 30
This field contains the name of the
product category, scanned from the
Product Category Workbook.
|
|
AMI-TEMPLATE-DESC
Element: Template Desc | Derived
This field contains the asset template
description.
|
|
AMI-ASSET-BAR-CODE
Element: Bar Code | Alpha 30
This field contains the asset bar code,
which is the parent item bar code (that
is, the first item of an asset to be
scanned).
|
|
AMI-ITEM-LOC-DTL
Element: Item Loc Dtl | Alpha 14
This field contains the location detail
associated with the asset item. It can
be typed or scanned in.
|
|
AMI-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.
|
|
AMI-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.
|
|
AMI-GRANT
Element: Grant | Alpha 30
|
|
