AMASSETINV

Asset Item Adj Interface

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.

REFERENCED BY
AM251


UPDATED BY
AC10.3 AC160 AM51.1 AM551

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITN-RUN-GROUP
Element: 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
Element: 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
Element: 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
Element: Item
Alpha 32
This field contains the item identifier.
AC10.3 AC160
AM51.1
ITN-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AC10.3 AC160
AM51.1
ITN-PURCHASE-DATE
Element: 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
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.
AC10.3 AC160
AM51.1
ITN-ITEM-COST-BASE
Element: Intl Amt
Signed 18.2
AC10.3 AC160
AM51.1
ITN-ITEM-TAX-BASE
Element: Intl Amt
Signed 18.2
AC10.3 AC160
AM51.1
ITN-ITEM-COST-TRAN
Element: Intl Amt
Signed 18.2
AC10.3 AC160
AM51.1
ITN-ITEM-TAX-TRAN
Element: Intl Amt
Signed 18.2
AC10.3 AC160
AM51.1
ITN-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
AC10.3 AC160
AM51.1
ITN-TRAN-ND
Element: Acct 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
Element: 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
Element: 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
Element: Po Code
Alpha 4
This is the purchase order code.
AC10.3 AC160
AM51.1
ITN-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AC10.3 AC160
AM51.1
ITN-VENDOR-NAME
Element: Vendor Name
Alpha 30
The requester can enter the recommended vendor's name for the requested items.
AC10.3 AC160
AM51.1
ITN-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
AC10.3 AC160
AM51.1
ITN-MODEL-NUMBER
Element: Model Number
Alpha 30
AC10.3 AC160
AM51.1
ITN-SERIAL-NUMBER
Element: Serial Number
Alpha 30
This optional field is used for the serial number of the asset.
AC10.3 AC160
AM51.1
ITN-ACTIVITY
Element: 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
Element: 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
Element: 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
Element: 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
Element: Bar Code
Alpha 30
This field contains the asset item bar code number.
AC10.3 AC160
AM51.1
ITN-LOCATION-NAME
Element: 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
Element: Loc Dtl
Alpha 14
This field contains the location detail for the item.
AC10.3 AC160
AM51.1
ITN-GRANT
Element: Grant
Alpha 30
AC10.3 AC160
AM51.1


AMASSETINV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITNSET1 RUN-GROUP
ASSET
SEQ-NUMBER
AM251 AM51.1
AM551
ITNSET2 ASSET
SEQ-NUMBER
RUN-GROUP
AM551


File created: Thu Jun 09 02:04:52 2016

Home
Contact Us



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