Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMSELECT


                             AMSELECT FILE

                       Asset Processing Selection

This file contains the selection information from AM35.1 (Mass Transfer
Selection) and AM45.1 (Mass Disposal) for mass transfers and mass disposals.

UPDATED BY

AM125     AM135     AM145     AM170     AM25.1    AM35.1
AM45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AMS-SELECT-NAME        Alpha 15                                  AM25.1  AM35.1
Element: Selection NameThis is the name of the transfer or       AM45.1
                       disposal selection used to make a mass
                       transfer or mass disposal.


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

                       D = Disposal
                       T = Transfer
                       A = Adjustment

AMS-SELECT-ALL         Alpha 1                                   AM25.1  AM35.1
Element: Select All    This field indicates whether you want     AM45.1
                       to select all assets in the listing for
                       transfer or disposal.

                       N = No
                       Y = Yes

AMS-RELEASED           Alpha 1                                   AM125   AM135
Element: Released      This field indicates whether the          AM145
                       transfer or disposal is released.

                       Valid values are

                       Y = Released
                       N = Unreleased


AMS-COMPANY            Numeric 4                                 AM25.1  AM35.1
Element: Company       The company number represents an          AM45.1
                       established company and is entered on
                       all function codes.

AMS-TO-COMPANY         Numeric 4                                 AM35.1
Element: To Company    This is the company number for the
                       transfer-to asset.


AMS-LOCATION-NAME      Alpha 15                                  AM25.1  AM35.1
Element: Location Name A user-defined location name that         AM45.1
                       represents where an asset is physically
                       located. Locations are used to report
                       asset information.


AMS-TO-LOCATION        Alpha 15                                  AM35.1
Element: To Location   This is the location for the
                       transfer-to asset.


AMS-DIVISION           Alpha 15                                  AM25.1  AM35.1
Element: Division      This is the user-defined division.        AM45.1

AMS-TO-DIVISION        Alpha 15                                  AM35.1
Element: To Division   This is the division for the
                       transfer-to asset.


AMS-ASSET-TYPE         Alpha 10                                  AM25.1  AM35.1
Element: Asset Type    An asset type represents a grouping of    AM45.1
                       like assets. Asset types are used to
                       group assets into reporting classes and
                       to default common asset definition data.



AMS-TO-ASSET-TYPE      Alpha 10                                  AM35.1
Element: To Asset Type This is the asset type for the
                       transfer-to asset.


AMS-SUB-TYPE           Alpha 10                                  AM25.1  AM35.1
Element: Subtype       An asset subtype represents a more        AM45.1
                       detailed grouping of assets within an
                       asset type grouping. Asset subtypes are
                       used to group assets into reporting
                       classes and allow common asset
                       definition data to default. Subtypes
                       must be unique within an asset type.


AMS-TO-SUB-TYPE        Alpha 10                                  AM35.1
Element: To Subtype    This is the subtype for the transfer-to
                       asset.


AMS-ACCT-GRP           Alpha 10                                  AM25.1  AM35.1
Element: Account Group This is the user-defined account group    AM45.1
                       identifying the general ledger accounts
                       used to create journal entries when
                       assets are processed (added, adjusted,
                       transferred, or disposed of).


AMS-TO-ACCT-GRP        Alpha 10                                  AM35.1
Element: To Account GroThis is the account group for the
                       transfer-to asset.


AMS-ACCT-UNIT          Alpha 15                                  AM25.1  AM35.1
Element: Accounting UniThe accounting unit is a shorthand        AM45.1
                       notation representing the variable level
                       number. The accounting unit must be
                       defined in the General Ledger Names file
                       as a posting accounting unit.


AMS-TO-ACCT-UNIT       Alpha 15                                  AM35.1
Element: To Accounting This is the accounting unit for the
                       transfer-to asset. An accounting unit is
                       a shorthand notation representing the
                       variable level number. The accounting
                       unit must be defined in the General
                       Ledger Names file as a posting
                       accounting unit.


AMS-AU-GROUP           Alpha 10                                  AM25.1  AM35.1
Accounting Unit        Accounting unit groups group and          AM45.1
Group                  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.

AMS-TO-AU-GROUP        Alpha 10                                  AM35.1
To Accounting Unit
Group

AMS-ASSET-GROUP        Alpha 10                                  AM25.1  AM35.1
Element: Asset Group   An asset group allows you to group        AM45.1
                       related assets that need to depreciate
                       separately; for example, a new roof on a
                       factory building. The building is
                       depreciated over 30 years, but the new
                       roof is depreciated over 15 years. The
                       building and roof would be defined as
                       separate assets, but could be grouped
                       for reporting purposes by assigning an
                       asset group to them.


AMS-TO-ASSET-GROUP     Alpha 10                                  AM35.1
Element: To Asset GroupThis is the asset group for the
                       transfer-to asset. An asset group allows
                       you to group related assets that need to
                       depreciate separately; for example, a
                       new roof on a factory building. The
                       building is depreciated over 30 years,
                       but the new roof is depreciated over 15
                       years. The building and roof would be
                       defined as separate assets, but could be
                       grouped for reporting purposes by
                       assigning an asset group to them.


AMS-LEASE-COMPANY      Numeric 4                                 AM25.1  AM45.1
Element: Lease Company

AMS-LEASE              Alpha 19                                  AM25.1  AM45.1
Element: Lease

AMS-DEBIT-TOTAL        Signed 15.2
Element: Debit Total   This is the total debit amount for the
                       selected assets. The debit amount must
                       equal the credit amount.


AMS-CREDIT-TOTAL       Signed 15.2
Element: Credit Total  This is the total credit amount for the
                       selected assets. The credit amount must
                       equal the debit amount.


AMS-LOC-DTL            Alpha 14                                  AM25.1  AM35.1
Element: Loc Dtl       This field contains the location detail   AM45.1
                       of the selected asset items.

AMS-ENABLE-FLAG        Alpha 1                                   AM25.1  AM35.1
Element: Enable Flag   This field contains the value of the      AM45.1
                       Filter flag, which controls additional
                       selection criteria. Y means that the
                       filter is enabled; N means that the
                       filter is not in effect.
                       Y = Enabled
                       N = Disabled

AMS-PROPERTY           Alpha 1                                   AM25.1
Element: Property      This value classifies the kind of
                       property that is represented by this
                       asset type.
                       P = Personal
                       S = Stock
                       L = Land
                       R = Real
                       O = Other

AMS-ASSET-CATEGORY     Alpha 1                                   AM25.1
Element: Asset CategoryN = Non Depreciable
                       D = Depreciable

AMS-MATRIX-LIST        Alpha 12                                  AM25.1  AM35.1
Element: Attribute ListAttribute categories are selection        AM45.1
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. A attribute
                       list can then be used for reporting on
                       and processing objects.


                         AMSELECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMSSET1   SELECT-NAME                                            AM125   AM135
          SELECT-TYPE                                            AM145   AM25.1
                                                                 AM25.3  AM35.1
                                                                 AM35.3  AM45.1
                                                                 AM45.3

AMSSET2   COMPANY       Subset                                   AM170
          SELECT-TYPE   Where RELEASED = "Y"
          SELECT-NAME

                         AMSELECT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amseldtl       AMSELDTL

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