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     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
                                                                 ...