|
|
AMASSETINV FILE
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
AM51.1 AM551
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITN-RUN-GROUP Alpha 15 AM51.1
Element: Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
ITN-ASSET Numeric 10 AM51.1
Element: Asset Number The asset number contains up to ten
numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
ITN-SEQ-NUMBER Numeric 6 AM51.1
Record Sequence A unique number assigned to each
Number transaction to be interfaced into the
Lawson system.
ITN-ITEM-NBR Alpha 32 AM51.1
Element: Item Number The item number of an asset composed of
different elements, but depreciated as a
common asset unit.
ITN-DESCRIPTION Alpha 30 (Lower Case) AM51.1
Element: Description This field displays the description.
ITN-PURCHASE-DATE Numeric 8 (yyyymmdd) AM51.1
Element: Purchase Date The date the asset was purchased. This
purchased date can be different from the
in-service dates for the depreciation
books used.
ITN-ITEM-QUANTITY Numeric 8 AM51.1
Element: Item Quantity 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.
ITN-ITEM-COST-BASE Signed 18.2 AM51.1
Element: Intl Amt
ITN-ITEM-TAX-BASE Signed 18.2 AM51.1
Element: Intl Amt
ITN-ITEM-COST-TRAN Signed 18.2 AM51.1
Element: Intl Amt
ITN-ITEM-TAX-TRAN Signed 18.2 AM51.1
Element: Intl Amt
ITN-BASE-ND Numeric 1 AM51.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
ITN-TRAN-ND Numeric 1 AM51.1
Account Currency The number of decimal positions defined
Code for the transaction currency.
ITN-PO-NBR Alpha 14 AM51.1
Element: PO Number 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.
ITN-PO-RELEASE Numeric 4 AM51.1
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
ITN-PO-CODE Alpha 4 AM51.1
Element: Po Code This is the purchase order code.
ITN-VENDOR Alpha 9 (Right Justified) AM51.1
Element: Vendor ID The vendor's identification code.
ITN-VENDOR-NAME Alpha 30 AM51.1
Element: Vendor Name The requester can enter the recommended
vendor's name for the requested items.
ITN-INVOICE Alpha 22 AM51.1
Element: Invoice NumberUsed to identify the invoice.
ITN-MODEL-NUMBER Alpha 30 AM51.1
Element: Model Number
ITN-SERIAL-NUMBER Alpha 30 AM51.1
Element: Serial Number This optional field is used for the
serial number of the asset.
ITN-ACTIVITY Alpha 15 AM51.1
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
ITN-ACCT-CATEGORY Alpha 5 AM51.1
Element: Account CategoAccount 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
ITN-ADD-TO-BASIS Alpha 1 AM51.1
Element: Add To Basis Indicate whether the item cost should be
added to the asset's cost basis.
ITN-COMPUTE Alpha 1 AM51.1
Element: Compute 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
ITN-BAR-CODE Alpha 30 AM51.1
Element: Bar Code This field contains the asset item bar
code number.
ITN-LOCATION-NAME Alpha 15 AM51.1
Element: Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
ITN-LOC-DTL Alpha 14 AM51.1
Element: Loc Dtl This field contains the location detail
for the item.
AMASSETINV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITNSET1 RUN-GROUP AM251 AM51.1
ASSET AM551
SEQ-NUMBER
|
