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