AMASSETINV – Asset Item Adj Interface

System: Asset Management (AM)
Prefix: ITN
Primary key: RUN-GROUP, ASSET, SEQ-NUMBER
Fields: 29
Updated by: 4 programs
Referenced by: 1 program

AMASSETINV is the Asset Item Adj Interface table in Lawson Asset Management (prefix ITN). It is indexed by RUN-GROUP, ASSET, SEQ-NUMBER (ITNSET1); alternate indexes: ITNSET2. It is updated by AC10.3, AC160, AM51.1 and AM551 and referenced by AM251. The table has 29 fields, 2 indexes and 0 documented relations.

About AMASSETINV

This is Asset Item Adjustment Interface file used to adjust existing assets. This file must be run and be keyed by Run Group, Asset Number, and Sequence. This file is processed by AM51.

Fields (29)

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

Field / column	Type	Description & values	Updated by
`ITN-RUN-GROUP` PK RUN_GROUP	Alpha 15	Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.	AC10.3, AC160, AM51.1
`ITN-ASSET` PK ASSET	Numeric 10	The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.	AC10.3, AC160, AM51.1
`ITN-SEQ-NUMBER` PK SEQ_NUMBER	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	AC10.3, AC160, AM51.1
`ITN-ITEM-NBR` ITEM_NBR	Alpha 32	This field contains the item identifier.	AC10.3, AC160, AM51.1
`ITN-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	AC10.3, AC160, AM51.1
`ITN-PURCHASE-DATE` PURCHASE_DATE	Numeric 8 (yyyymmdd)	The date the asset was purchased. This purchased date can be different from the in-service dates for the depreciation books used.	AC10.3, AC160, AM51.1
`ITN-ITEM-QUANTITY` 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.	AC10.3, AC160, AM51.1
`ITN-ITEM-COST-BASE` ITEM_COST_BASE	Signed 18.2	—	AC10.3, AC160, AM51.1
`ITN-ITEM-TAX-BASE` ITEM_TAX_BASE	Signed 18.2	—	AC10.3, AC160, AM51.1
`ITN-ITEM-COST-TRAN` ITEM_COST_TRAN	Signed 18.2	—	AC10.3, AC160, AM51.1
`ITN-ITEM-TAX-TRAN` ITEM_TAX_TRAN	Signed 18.2	—	AC10.3, AC160, AM51.1
`ITN-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	AC10.3, AC160, AM51.1
`ITN-TRAN-ND` TRAN_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AC10.3, AC160, AM51.1
`ITN-PO-NBR` PO_NBR	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 was included.	AC10.3, AC160, AM51.1
`ITN-PO-RELEASE` PO_RELEASE	Numeric 4	Used to identify a purchase order release (created from a Blanket or Standing order).	AC10.3, AC160, AM51.1
`ITN-PO-CODE` PO_CODE	Alpha 4	This is the purchase order code.	AC10.3, AC160, AM51.1
`ITN-VENDOR` VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	AC10.3, AC160, AM51.1
`ITN-VENDOR-NAME` VENDOR_NAME	Alpha 30	The requester can enter the recommended vendor's name for the requested items.	AC10.3, AC160, AM51.1
`ITN-INVOICE` INVOICE	Alpha 22	Used to identify the invoice.	AC10.3, AC160, AM51.1
`ITN-MODEL-NUMBER` MODEL_NUMBER	Alpha 30	—	AC10.3, AC160, AM51.1
`ITN-SERIAL-NUMBER` SERIAL_NUMBER	Alpha 30	This optional field is used for the serial number of the asset.	AC10.3, AC160, AM51.1
`ITN-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC10.3, AC160, AM51.1
`ITN-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the 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 using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	AC10.3, AC160, AM51.1
`ITN-ADD-TO-BASIS` ADD_TO_BASIS	Alpha 1	Indicate whether the item cost should be added to the asset's cost basis.	AC10.3, AC160, AM51.1
`ITN-COMPUTE` COMPUTE	Alpha 1	Select Yes to assign the entire catch-up depreciation amount to the current period when you are adding an asset with an in-service date in a previous period or year. If you select No, the catch-up depreciation is spread over the remaining periods in the year. Valid options are: `Y` Yes `N` No	AC10.3, AC160, AM51.1
`ITN-BAR-CODE` BAR_CODE	Alpha 30	This field contains the asset item bar code number.	AC10.3, AC160, AM51.1
`ITN-LOCATION-NAME` LOCATION_NAME	Alpha 15	A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.	AC10.3, AC160, AM51.1
`ITN-LOC-DTL` LOC_DTL	Alpha 14	This field contains the location detail for the item.	AC10.3, AC160, AM51.1
`ITN-GRANT` GRANT	Alpha 30	—	AC10.3, AC160, AM51.1

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`ITNSET1`	`RUN-GROUP`, `ASSET`, `SEQ-NUMBER`	Primary		AM251, AM51.1, AM551
`ITNSET2`	`ASSET`, `SEQ-NUMBER`, `RUN-GROUP`			AM551

AMASSETINV – Asset Item Adj Interface

About AMASSETINV

Fields (29)

Indexes (2)

Programs

Updated by (4)

Referenced by (1)