APASTDTL – Asset Detail

System
Accounts Payable (AP)
Prefix
APS
Primary key
API-OBJ-ID, DIST-SEQ-NBR
Fields
26
Updated by
48 programs
Referenced by
2 programs

APASTDTL is the Asset Detail table in Lawson Accounts Payable (prefix APS). It is indexed by API-OBJ-ID, DIST-SEQ-NBR (APSSET1). It is updated by AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP198 and 40 more and referenced by AP220 and AP36.2. The table has 26 fields, 1 index and 0 documented relations.

About APASTDTL

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.

Fields (26)

Column = COBOL field name without the APS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#APS-API-OBJ-ID PK
API_OBJ_ID		Numeric 12A unique identifier assigned to this record.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +31 more
#APS-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number assigned to the distribution.AP125, AP126, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +34 more
#APS-ASSET-DESC
ASSET_DESC		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 +27 more
#APS-TAG-NBR
TAG_NBR		Alpha 12The 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 +18 more
#APS-ITEM-NBR
ITEM_NBR		Alpha 32The 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 +27 more
#APS-INSRV-DATE
INSRV_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 +27 more
#APS-PURCHASE-DATE
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 +28 more
#APS-MODEL-NUMBER
MODEL_NUMBER		Alpha 30The 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 +18 more
#APS-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30The serial number of the asset. Used with the Asset Template field.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +18 more
#APS-HOLD-AM
HOLD_AM		Alpha 1This 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 +28 more
#APS-COMBINE
COMBINE		Alpha 10This 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 +27 more
#APS-ITEM-DESC
ITEM_DESC		Alpha 30The item description.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +27 more
#APS-ITEM-QUANTITY
ITEM_QUANTITY		Numeric 8The 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 +27 more
#APS-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2The tax amount associated with the asset distribution in the currency of the transaction.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +33 more
#APS-ITEM-TAX-BASE
ITEM_TAX_BASE		Signed 18.2The 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 +24 more
#APS-ASSET-GROUP
ASSET_GROUP		Alpha 10The asset group assigned to the asset distribution detail record.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +18 more
#APS-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit assigned to the asset distribution detail record.AP125, AP126, AP180, AP181, AP190, AP193, AP20.1, AP20.2 +28 more
#APS-ASSET-TEMPLATE
ASSET_TEMPLATE		Alpha 10The 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 +27 more
#APS-ASSET
ASSET		Numeric 10The 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 +27 more
#APS-LOCATION-NAME
LOCATION_NAME		Alpha 15A 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 +16 more
#APS-DIVISION
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +16 more
#APS-AU-GROUP
AU_GROUP		Alpha 10Accounting 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 +18 more
#APS-BAR-CODE
BAR_CODE		Alpha 30—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
#APS-ITEM-LOC-DTL
ITEM_LOC_DTL		Alpha 14—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
#APS-AP-DISTRIB-FL
AP_DISTRIB_FL		Alpha 1——
#APS-LAND-COST-FLG
LAND_COST_FLG		Alpha 1Indicates whether tax related to distribution is a landed cost.—

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APSSET1
  1. API-OBJ-ID
  2. DIST-SEQ-NBR
PrimaryAP125, AP126, AP170, AP193, AP198, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)

Programs

Updated by (48)

Referenced by (2)