Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APASTDTL


                             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    MA41.7    MA43.2    MA61.1    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  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
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

APS-DIST-SEQ-NBR       Numeric 4                                 AP125   AP126
Element: Number of ItemA unique sequence number assigned to      AP180   AP181
                       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  MA41.7
                                                                 MA43.2  MA61.1
                                                                 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   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  MA41.7
                                                                 MA43.2  MA61.1
                                                                 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  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
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  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
                                                                 MA41.7  MA43.2
                                                                 MA61.1  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  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
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APS-PURCHASE-DATE      Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Purchase Date                                           AP180   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  MA41.7
                                                                 MA43.2  MA61.1
                                                                 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  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
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  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
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:                               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  MA41.7
                                                                 MA43.2  MA61.1
                                                                 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  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
                                                                 MA41.7  MA43.2
                                                                 MA61.1  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  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
                                                                 MA41.7  MA43.2
                                                                 MA61.1  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  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
                                                                 MA41.7  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
                                                                 MA41.7  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
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  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
Element: Accounting UniThe 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  MA41.7
                                                                 MA43.2  MA61.1
                                                                 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  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
                                                                 MA41.7  MA43.2
                                                                 MA61.1  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  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
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APS-LOCATION-NAME      Alpha 15                                  AP180   AP181
Element: Location                                                AP190   AP20.1
                                                                 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-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  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP45.1
                                                                 AP520   MA41.2
                                                                 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  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  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 ...