AMSELDTL – Asset Selection Detail

System
Asset Management (AM)
Prefix
SLD
Primary key
SELECT-NAME, SELECT-TYPE, ASSET
Fields
6
Updated by
5 programs
Referenced by
4 programs

AMSELDTL is the Asset Selection Detail table in Lawson Asset Management (prefix SLD). It is indexed by SELECT-NAME, SELECT-TYPE, ASSET (SLDSET1). It is related 1:1 to AMASSET and AMSELECT. It is updated by AM170, AM25.1, AM35.1, AM45.1 and AM55.1 and referenced by AM125, AM135, AM145 and AM155. The table has 6 fields, 1 index and 2 documented relations.

About AMSELDTL

This file contains detailed selection information for mass transfer and disposal selections. The file is updated by AM35.1 (Mass Transfer Selection) and AM45.1 (Mass Disposal Selection).

Fields (6)

Column = COBOL field name without the SLD- 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
#SLD-SELECT-NAME PK
SELECT_NAME		Alpha 15This is the name of the selection for the mass transfer or disposal.AM25.1, AM35.1, AM45.1, AM55.1
#SLD-SELECT-TYPE PK
SELECT_TYPE		Alpha 1This is the selection type: disposal or transfer.
  • D Disposal
  • T Transfer
  • A Adjustment
  • M Multicurrency Transfer
AM25.1, AM35.1, AM45.1, AM55.1
#SLD-INCL-EXCL-AST
INCL_EXCL_AST		Alpha 1This field indicates whether to include (I) assets or exclude (E) them from the selection.
  • I Include
  • E Exclude
AM25.1, AM35.1, AM45.1, AM55.1
#SLD-ASSET PK
ASSET		Numeric 10This is the asset being transferred or disposed of. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM25.1, AM35.1, AM45.1, AM55.1
#SLD-TAG-NBR
TAG_NBR		Alpha 12The tag is a user-definable identifier assigned to an asset.AM25.1, AM35.1, AM55.1
#SLD-TO-TAG-NBR
TO_TAG_NBR		Alpha 12This is the tag number for the transfer-to asset.AM35.1

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
SLDSET1
  1. SELECT-NAME
  2. SELECT-TYPE
  3. ASSET
PrimaryAM125, AM135, AM145, AM155, AM170, AM25.1, AM25.3, AM35.1 +4 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AMASSETAMSELECTAMSELDTL

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmasssetAMASSETRequired
SLD-ASSET→AST-ASSET
AmselectAMSELECTRequired
SLD-SELECT-NAME→AMS-SELECT-NAME
SLD-SELECT-TYPE→AMS-SELECT-TYPE

Programs

Updated by (5)

Referenced by (4)