APASTDTL

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 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA44.1
MA44.2 MA61.1 MA66.2 MA70.1 MA75.1 MAI1.1

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


File created: Thu Jun 09 11:07:13 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.