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