|
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 AP36.2
UPDATED BY
AP125 AP126 AP170 AP180 AP181 AP190
AP193 AP198 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP28.1 AP28.2 AP30.2 AP30.4
AP300 AP305 AP45.1 AP520 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.2 MA61.1
MA66.2 MA70.1 MA75.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APS-API-OBJ-ID Numeric 12 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MA70.1
MA75.1 MAI1.1
APS-DIST-SEQ-NBR Numeric 6 AP125 AP126
Element: Dist Seq Nbr A unique sequence number assigned to AP180 AP181
the distribution. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APS-ASSET-DESC Alpha 30 (Lower Case) AP125 AP126
Element: Asset DescriptThe asset description. If left blank, AP180 AP181
the invoice description defaults. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-TAG-NBR Alpha 12 AP180 AP181
Element: 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APS-ITEM-NBR Alpha 32 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-INSRV-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: In-service DatThe 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-PURCHASE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APS-MODEL-NUMBER Alpha 30 AP180 AP181
Element: 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APS-SERIAL-NUMBER Alpha 30 AP180 AP181
Element: 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APS-HOLD-AM Alpha 1 AP125 AP126
Element: 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: AP21.1 AP23.1
AP25.1 AP25.2
N = No. AP26.1 AP27.1
Y = Yes. AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APS-COMBINE Alpha 10 AP125 AP126
Element: Combine AssetsThis 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 AP21.1
the same, regardless of the invoice: AP23.1 AP25.1
template, combine code, asset AP25.2 AP26.1
description, tag number, asset group, AP27.1 AP28.1
and accounting unit. AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-ITEM-DESC Alpha 30 AP125 AP126
Element: Item DescriptiThe item description. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-ITEM-QUANTITY Numeric 8 AP125 AP126
Element: 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-ITEM-TAX-TRAN Signed 18.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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-ITEM-TAX-BASE Signed 18.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 AP21.1
AP23.1 AP28.1
AP28.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APS-ASSET-GROUP Alpha 10 AP180 AP181
Element: 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APS-ACCT-UNIT Alpha 15 AP125 AP126
Element: Acct 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP45.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA66.2
MAI1.1
APS-ASSET-TEMPLATE Alpha 10 AP125 AP126
Element: Asset TemplateThe 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 AP21.1
data items associated with a new asset. AP23.1 AP25.1
Must be a valid record in the Asset AP25.2 AP26.1
Management system. AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-ASSET Numeric 10 AP125 AP126
Element: 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 AP21.1
disposed of. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MAI1.1
APS-LOCATION-NAME Alpha 15 AP180 AP181
Element: 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 AP21.1
AP23.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APS-DIVISION Alpha 15 AP180 AP181
Element: Division A user-defined division which is used AP190 AP20.1
for reporting assets. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP28.1
AP28.2 AP30.2
AP45.1 AP520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2
APS-AU-GROUP Alpha 10 AP180 AP181
Element: 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 AP21.1
disposing of assets. Changes to AP23.1 AP28.1
accounting unit groups are dynamic, AP28.2 AP30.2
affecting all assets using the AP45.1 AP520
accounting unit group. Accounting unit API1.1 API2.1
group names are user-definable, and MA41.1 MA41.2
accounting unit groups are set up by MA41.4 MA41.7
company. MA43.2
APS-BAR-CODE Alpha 30 AP20.1 AP20.2
Element: Bar Code AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APS-ITEM-LOC-DTL Alpha 14 AP20.1 AP20.2
Element: Item Loc Dtl AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
APS-AP-DISTRIB-FL Alpha 1
Element: Ap Distrib Fl
APS-LAND-COST-FLG Alpha 1
Element: All Flag Indicates whether tax related to
distribution is a landed cost.
APASTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APSSET1 API-OBJ-ID AP125 AP126
DIST-SEQ-NBR AP170 AP193
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP300 AP305
AP36.2 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
...
|