 |
Lawson Insight Technical Documentation |
|
APASTDTL FILE
Asset Detail
The Asset Detail file contains detailed asset information for each Invoice
Distribution Header file record that has an asset number or asset template
assigned. Asset detail records are passed to the Asset Management Interface
file.
REFERENCED BY
AP220
UPDATED BY
AP170 AP180 AP181 AP190 AP193 AP198
AP28.1 AP28.2 AP30.2 AP30.4 AP300 AP305
AP32.2 AP45.1 AP520 API1.1 API2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APS-API-OBJ-ID Numeric 12 AP170 AP180
API Object ID A unique identifier assigned to this AP181 AP190
record. AP193 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
APS-DIST-SEQ-NBR Numeric 4 AP180 AP181
Distribution A unique sequence number assigned to AP190 AP193
Sequence Number the distribution. AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1
APS-ASSET-DESC Alpha 30 (Lower Case) AP180 AP181
Asset Description The asset description. If left blank, AP190 AP193
the invoice description defaults. AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1
APS-TAG-NBR Alpha 12 AP180 AP181
Tag Number The tag number assigned to the asset. AP190 AP193
Represents a short name for a part of an AP28.1 AP28.2
asset. AP30.2 AP45.1
AP520 API1.1
API2.1
APS-ITEM-NBR Alpha 32 AP180 AP181
Item Number The item number assigned to the asset. AP190 AP193
Represents one element of an asset that AP28.1 AP28.2
is made up of multiple elements, but is AP30.2 AP45.1
depreciated as a common asset unit. AP520 API1.1
API2.1
APS-INSRV-DATE Numeric 8 (yyyymmdd) AP180 AP181
In-service Date The date the asset was placed in AP190 AP193
service. If left blank, the invoice or AP28.1 AP28.2
purchase date defaults. The in service AP30.2 AP45.1
date must be greater than or equal to AP520 API1.1
the invoice or purchase date. API2.1
APS-PURCHASE-DATE Numeric 8 (yyyymmdd) AP180 AP181
Purchase Date The date the asset was purchased. This AP190 AP193
purchased date can be different from the AP28.1 AP28.2
in-service dates for the depreciation AP30.2 AP45.1
books used. AP520 API1.1
API2.1
APS-MODEL-NUMBER Alpha 30 AP180 AP181
Model Number The model number assigned to the asset. AP190 AP193
Used with the Asset Template field. AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1
APS-SERIAL-NUMBER Alpha 30 AP180 AP181
Serial Number The serial number of the asset. Used AP190 AP193
with the Asset Template field. AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1
APS-HOLD-AM Alpha 1 AP180 AP181
Hold Asset This field indicates whether to hold AP190 AP193
the asset in the Asset Interface file. AP28.1 AP28.2
Being held keeps items from becoming AP30.2 AP45.1
assets until they are released from AP520 API1.1
hold. Used for combining assets. Valid API2.1
values are:
N = No.
Y = Yes.
APS-COMBINE Alpha 10 AP180 AP181
Combine Assets This field indicates whether to combine AP190 AP193
items as one asset. AP28.1 AP28.2
AP30.2 AP45.1
To combine distribution records into AP520 API1.1
one asset, the following fields must be API2.1
the same, regardless of the invoice:
template, combine code, asset
description, tag number, asset group,
and accounting unit.
APS-ITEM-DESC Alpha 30 AP180 AP181
Item Description The item description. AP190 AP193
AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1
APS-ITEM-QUANTITY Numeric 8 AP180 AP181
Item Quantity The number of units that make up the AP190 AP193
asset item. Each unit of an item is AP28.1 AP28.2
exactly the same as every other unit of AP30.2 AP45.1
the item. AP520 API1.1
API2.1
APS-ITEM-TAX-TRAN Signed 15.2 AP180 AP181
Tax Amount - Trans The tax amount associated with the AP190 AP193
Currency asset distribution in the currency of AP28.1 AP28.2
the transaction. AP30.2 AP45.1
AP520 API1.1
API2.1
APS-ITEM-TAX-BASE Signed 15.2 AP180 AP181
Tax Amount - Base The tax amount associated with the AP190 AP193
Currency asset distribution in the company base AP28.1 AP28.2
currency. AP45.1 AP520
API1.1 API2.1
APS-ASSET-GROUP Alpha 10 AP180 AP181
Asset Group The asset group assigned to the asset AP190 AP193
distribution detail record. AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1
APS-ACCT-UNIT Alpha 15 AP180 AP181
Accounting Unit The accounting unit assigned to the AP190 AP193
asset distribution detail record. AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1
APS-ASSET-TEMPLATE Alpha 10 AP180 AP181
Asset Template The asset template assigned to the AP190 AP28.1
asset distribution record. Templates AP28.2 AP30.2
identify the required information needed AP45.1 AP520
to create asset records. Using a API1.1 API2.1
template lets you default many of the
data items associated with a new asset.
Must be a valid record in the Asset
Management system.
APS-ASSET Numeric 10 AP180 AP181
Asset The asset number assigned to the asset AP190 AP28.1
distribution detail record. Assets are AP28.2 AP30.2
automatically numbered system-wide. The AP45.1 AP520
asset number does not change unless an API1.1 API2.1
asset is partially transferred or
disposed of.
APS-LOCATION-NAME Alpha 15 AP180 AP181
Location A user-defined location name which AP190 AP28.1
represents where an asset is physically AP28.2 AP30.2
located. Locations are used to report AP45.1 AP520
asset information.
APS-DIVISION Alpha 15 AP180 AP181
Division A user-defined division which is used AP190 AP28.1
for reporting assets. AP28.2 AP30.2
AP45.1 AP520
APS-AU-GROUP Alpha 10 AP180 AP181
Au Group Accounting unit groups group and AP190 AP28.1
identify the accounting units to use AP28.2 AP30.2
when you create journal entries for AP45.1 AP520
adding, adjusting, transferring, or API1.1 API2.1
disposing of assets. Changes to
accounting unit groups are dynamic,
affecting all assets using the
accounting unit group. Accounting unit
group names are user-definable, and
accounting unit groups are set up by
company.
APASTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APSSET1 API-OBJ-ID This index is used to send records to AP170 AP193
DIST-SEQ-NBR the asset management interface file. AP198 AP220
AP30.2 AP30.4
AP300 AP305
AP32.2 API1.1
API2.1
|