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