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.
UPDATED BY
AC10.3 AM51.1 AM551 AM251

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 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 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 AM51.1
ITN-ITEM-NBR
Element: Item
Alpha 32
This field contains the item identifier.
AC10.3 AM51.1
ITN-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AC10.3 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 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 AM51.1
ITN-ITEM-COST-BASE
Element: Intl Amt
Signed 18.2
AC10.3 AM51.1
ITN-ITEM-TAX-BASE
Element: Intl Amt
Signed 18.2
AC10.3 AM51.1
ITN-ITEM-COST-TRAN
Element: Intl Amt
Signed 18.2
AC10.3 AM51.1
ITN-ITEM-TAX-TRAN
Element: Intl Amt
Signed 18.2
AC10.3 AM51.1
ITN-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
AC10.3 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 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 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 AM51.1
ITN-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
AC10.3 AM51.1
ITN-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AC10.3 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 AM51.1
ITN-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
AC10.3 AM51.1
ITN-MODEL-NUMBER
Element: Model Number
Alpha 30
AC10.3 AM51.1
ITN-SERIAL-NUMBER
Element: Serial Number
Alpha 30
This optional field is used for the serial number of the asset.
AC10.3 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 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 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 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 AM51.1
ITN-BAR-CODE
Element: Bar Code
Alpha 30
This field contains the asset item bar code number.
AC10.3 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 AM51.1
ITN-LOC-DTL
Element: Loc Dtl
Alpha 14
This field contains the location detail for the item.
AC10.3 AM51.1
ITN-GRANT
Element: Grant
Alpha 30
AC10.3 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: Wed Jun 08 20:47:03 2016

Home
Contact Us



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