AMINTER – Asset Interface

System
Asset Management (AM)
Prefix
AMI
Primary key
COMPANY, SEQ-NUMBER
Fields
59
Updated by
246 programs
Referenced by
0 programs

AMINTER is the Asset Interface table in Lawson Asset Management (prefix AMI). It is indexed by COMPANY, SEQ-NUMBER (AMISET1); alternate indexes: AMISET2, AMISET3, AMISET4 and AMISET5. It is related 1:1 to AMTEMPLATE and 1:M to AMINTERAU. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 and 238 more. The table has 59 fields, 5 indexes and 2 documented relations.

About AMINTER

No description in the Lawson data dictionary.

Fields (59)

Column = COBOL field name without the AMI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AMI-COMPANY PK
COMPANY
Numeric 4Required key. This is the company number.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-SEQ-NUMBER PK
SEQ_NUMBER
Numeric 6Required key. The sequence number is a unique number assigned to each transaction in the Lawson system.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-ASSET-TEMPLATE
ASSET_TEMPLATE
Alpha 10This 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-VENDOR
VENDOR
Alpha 9 (Right Justified)This is the identification code for the vendor.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-INVOICE
INVOICE
Alpha 22This number identifies the invoice.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-SUFFIX
SUFFIX
Numeric 3This 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-DIST-SEQ-NBR
DIST_SEQ_NBR
Numeric 6This is a unique distribution sequence number.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ACTIVITY
ACTIVITY
Alpha 15This 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5This 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-SYSTEM
SYSTEM
Alpha 2The 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.)AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ITEM-QUANTITY
ITEM_QUANTITY
Numeric 8This 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-TAG-NBR
TAG_NBR
Alpha 12This is the user-definable tag number for the asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ASSET-GROUP
ASSET_GROUP
Alpha 10This is the asset group for the asset. An asset group represents a parent asset used to group assets for reporting.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ASSET-DESC
ASSET_DESC
Alpha 30 (Lower Case)This is the asset description.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-PURCHASE-DATE
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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-INSRV-DATE
INSRV_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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-POSTING-DATE
POSTING_DATE
Numeric 8 (yyyymmdd)The date of the transaction.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-ACCT-UNIT
ACCT_UNIT
Alpha 15This is the accounting unit for the asset. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-AU-GROUP
AU_GROUP
Alpha 10Accounting 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-DEP-EXP-ACTVTY
DEP_EXP_ACTVTY
Alpha 15This 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-DEP-ACCT-CAT
DEP_ACCT_CAT
Alpha 5This 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-COMBINE
COMBINE
Alpha 10This field indicates whether to combine items as one asset.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-ITEM-NBR
ITEM_NBR
Alpha 32The 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the item description.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-ITEM-COST-BASE
ITEM_COST_BASE
Signed 18.2This is the cost for the item in General Ledger base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ITEM-TAX-BASE
ITEM_TAX_BASE
Signed 18.2This is the tax on the item in General Ledger base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ITEM-COST-TRAN
ITEM_COST_TRAN
Signed 18.2This is the transaction associated with the item, which is in General Ledger base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ITEM-TAX-TRAN
ITEM_TAX_TRAN
Signed 18.2This is the tax transaction associated with the item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-BASE-ND
BASE_ND
Numeric 1This is the number of decimal positions defined for the company base currency.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-TRAN-ND
TRAN_ND
Numeric 1This is the defined number of decimal positions used for the transaction.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This is the base currency defined for the company in the Lawson General Ledger system.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-PO-NBR
PO_NBR
Alpha 14The Purchase Order Number field is for your reference. It contains the number of the original purchase order on which this asset was included.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-PO-RELEASE
PO_RELEASE
Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-PO-CODE
PO_CODE
Alpha 4This is the purchase order code.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-MODEL-NUMBER
MODEL_NUMBER
Alpha 30This is the model number of the asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-SERIAL-NUMBER
SERIAL_NUMBER
Alpha 30This is the serial number of the asset item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-HOLD-AM
HOLD_AM
Alpha 1This 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
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-CREATION-DATE
CREATION_DATE
Numeric 8 (yyyymmdd)This is the creation date for the asset interface record.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-CREATION-TIME
CREATION_TIME
Numeric 6 (hhmmss)This is the creation time for the asset interface record.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-CREATOR-ID
CREATOR_ID
Alpha 10This is the identifier of the person who created the asset interface record.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-ASSET-CATEGORY
ASSET_CATEGORY
Alpha 1The value in this field overrides the category value defined for the asset in AM12.1 (Addition Template).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-LOCATION-NAME
LOCATION_NAME
Alpha 15A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-DIVISION
DIVISION
Alpha 15A user-defined division which is used for reporting assets.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ASSET-TYPE
ASSET_TYPE
Alpha 10An 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-SUB-TYPE
SUB_TYPE
Alpha 10An 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.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-ACCT-GRP
ACCT_GRP
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-WORK-IN-PROC
WORK_IN_PROC
Alpha 1The value in this field overrides the work-in-process value defined for the asset in AM12.1 (Addition Template).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-SIMULATED
SIMULATED
Alpha 1The value in this field overrides the Simulated value defined for the asset in AM12.1 (Addition Template).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-TAX-EXEMPT
TAX_EXEMPT
Alpha 1The value in this field overrides the tax exempt value defined for the asset in AM12.1 (Addition Template).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-USED
USED
Alpha 1The value in this field overrides the Used value defined for the asset in AM12.1 (Addition Template).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-BAR-CODE
BAR_CODE
Alpha 30This is the unique bar code assigned to the item.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-ITEM-TYPE
ITEM_TYPE
Alpha 1This 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
AM154
AMI-PROD-CAT-CODE
PROD_CAT_CODE
Alpha 30This field contains the name of the product category, scanned from the Product Category Workbook.AM154
AMI-TEMPLATE-DESC
TEMPLATE_DESC
DerivedThis field contains the asset template description.
AMI-ASSET-BAR-CODE
ASSET_BAR_CODE
Alpha 30This field contains the asset bar code, which is the parent item bar code (that is, the first item of an asset to be scanned).AM154
AMI-ITEM-LOC-DTL
ITEM_LOC_DTL
Alpha 14This field contains the location detail associated with the asset item. It can be typed or scanned in.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +52 more (list truncated in source)
AMI-INV-COMPANY
INV_COMPANY
Numeric 4Identifies 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, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-PO-AST-OBJ-ID
PO_AST_OBJ_ID
Numeric 12This 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, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
AMI-GRANT
GRANT
Alpha 30AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AMISET1COMPANY, SEQ-NUMBERPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM154 +22 more (list truncated in source)
AMISET2COMPANY, ASSET-TEMPLATE, VENDOR, INVOICE, SUFFIX, DIST-SEQ-NBR, SEQ-NUMBERKeyChange, SubsetWhere VENDOR != SpacesAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
AMISET3COMPANY, ASSET-TEMPLATE, ACTIVITY, ACCT-CATEGORY, SEQ-NUMBERKeyChange, SubsetWhere ACTIVITY != SpacesAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
AMISET4COMPANY, ASSET-TEMPLATE, COMBINE, VENDOR, INVOICE, SUFFIX, DIST-SEQ-NBR, SEQ-NUMBERKeyChange, SubsetWhere VENDOR != Spaces And COMBINE != SpacesAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
AMISET5COMPANY, ASSET-TEMPLATE, COMBINE, ACTIVITY, ACCT-CATEGORY, SEQ-NUMBERKeyChange, SubsetWhere ACTIVITY != Spaces And COMBINE != SpacesAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmtemplateAMTEMPLATERequiredAMI-ASSET-TEMPLATEATM-ASSET-TEMPLATE

One to many (1) — child tables

RelationTableRulesConditionField map
InterfaceauditAMINTERAUAMI-COMPANYAIU-COMPANY, AMI-ASSET-TEMPLATEAIU-ASSET-TEMPLATE, AIU-DATE, AIU-TIME, AIU-ACTION, AIU-UNIQUE-I-D

Programs

Updated by (246)