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 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| APS-API-OBJ-ID Element: API Object ID | Numeric 12 A unique identifier assigned to this record. |
|||||||||||||||||||||||||||||
| APS-DIST-SEQ-NBR Element: Dist Seq Nbr | Numeric 6 A unique sequence number assigned to the distribution. |
|||||||||||||||||||||||||||||
| APS-ASSET-DESC Element: Asset Description | Alpha 30 (Lower Case) The asset description. If left blank, the invoice description defaults. |
|||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| APS-MODEL-NUMBER Element: Model Number | Alpha 30 The model number assigned to the asset. Used with the Asset Template field. |
|
||||||||||||||||||||||||||||
| APS-SERIAL-NUMBER Element: Serial Number | Alpha 30 The serial number of the asset. Used with the Asset Template field. |
|
||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| APS-ITEM-DESC Element: Item Description | Alpha 30 The item description. |
|||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| APS-ITEM-TAX-BASE Tax Amount - Base Currency | Signed 18.2 The tax amount associated with the asset distribution in the company base currency. |
|
||||||||||||||||||||||||||||
| APS-ASSET-GROUP Element: Asset Group | Alpha 10 The asset group assigned to the asset distribution detail record. |
|
||||||||||||||||||||||||||||
| APS-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit assigned to the asset distribution detail record. |
|||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| 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. |
|||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| APS-DIVISION Element: Division | Alpha 15 A user-defined division which is used for reporting assets. |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| APS-BAR-CODE Element: Bar Code | Alpha 30 |
|
||||||||||||||||||||||||||||
| APS-ITEM-LOC-DTL Element: Item Loc Dtl | Alpha 14 |
|
||||||||||||||||||||||||||||
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
|---|---|---|---|---|---|---|---|---|---|
| APSSET1 |
API-OBJ-ID DIST-SEQ-NBR |
|
|||||||
All trademarks and registered trademarks are the property of their
respective owners.