Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMSELDTL


                             AMSELDTL FILE

                         Asset Selection Detail

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


REFERENCED BY

AM125     AM135     AM145

UPDATED BY

AM25.1    AM35.1    AM45.1    AM170

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SLD-SELECT-NAME        Alpha 15                                  AM25.1  AM35.1
Element: Selection NameThis is the name of the selection for     AM45.1
                       the mass transfer or disposal.


SLD-SELECT-TYPE        Alpha 1                                   AM25.1  AM35.1
Element: Selection TypeThis is the selection type: disposal or   AM45.1
                       transfer.

                       D = Disposal
                       T = Transfer
                       A = Adjustment

SLD-INCL-EXCL-AST      Alpha 1                                   AM25.1  AM35.1
Include or Exclude     This field indicates whether to include   AM45.1
Asset                  (I) assets or exclude (E) them from the
                       selection.

                       I = Include
                       E = Exclude

SLD-ASSET              Numeric 10                                AM25.1  AM35.1
Element: Asset         This is the asset being transferred or    AM45.1
                       disposed of. The asset number contains
                       up to ten numeric characters that
                       uniquely identify an asset. Assets are
                       automatically numbered system-wide.


SLD-TAG-NBR            Alpha 12                                  AM25.1  AM35.1
Element: Tag           The tag is a user-definable identifier
                       assigned to an asset.


SLD-TO-TAG-NBR         Alpha 12                                  AM35.1
Element: To Tag        This is the tag number for the
                       transfer-to asset.


                         AMSELDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SLDSET1   SELECT-NAME                                            AM125   AM135
          SELECT-TYPE                                            AM145   AM170
          ASSET                                                  AM25.1  AM25.3
                                                                 AM35.1  AM35.3
                                                                 AM45.1  AM45.3

                         AMSELDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amassset       AMASSET      Required

                            SLD-ASSET          -> AST-ASSET

Amselect       AMSELECT     Required

                            SLD-SELECT-NAME    -> AMS-SELECT-NAME
                            SLD-SELECT-TYPE    -> AMS-SELECT-TYPE