Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             AMASTTYPE FILE

                               Asset Type

The Asset Type file stores asset types and subtypes, which represent
groupings of like assets that can be used for reporting and defaulting common
asset definition data. You must define at least one asset type. Asset types
must be unique within a general ledger company, and asset subtypes must be
unique within an asset type. Each Asset Type record has one or more Account
records, which identify the general ledger accounts used to create journal
entries when you process (add, adjust, transfer, and dispose of) assets.


REFERENCED BY

AM118     AM120     AM185     AM205     AM212     AM220
AM221     AM222     AM223     AM224     AM225     AM230
AM235     AM240     AM245     AM25.1    AM25.3    AM250
AM255     AM260     AM265     AM278     AM280     AM281
AM285     AM290     AM292     AM295     AM35.1    AM45.1
AM580     AM60.1    AM70.1    AM70.2    AM75.3    AM80.3
AM85.3    AM90.1    AM90.2    AM90.4    AM90.5    AM90.6
AM91.1    AM91.2    AM91.4    AM91.5    AM93.1    AM95.1
AM95.2    AM95.4    AM95.5    AM95.6    AMAS.1    AMDL.1

UPDATED BY

AM06.1    AM06.2    AM06.3    AM06.5    AM115     AM12.1
AM125     AM135     AM145     AM15.1    AM15.2    AM15.3
AM15.4    AM154     AM170     AM180     AM190     AM192
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM206     AM21.1    AM21.2    AM21.3    AM21.4    AM21.5
AM21.6    AM211     AM282     AM30.1    AM30.2    AM40.1
AM40.2    AM40.3    AM500     AM551     AM88.7    AM96.1
AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATP-COMPANY          Numeric 4                                   AM06.1  AM06.2
Company              The general ledger company number           AM06.3  AM06.5
                     associated with the asset type record.      AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM211
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM551
                                                                 AM88.7  AM96.1
                                                                 AM98.1

ATP-ASSET-TYPE       Alpha 10                                    AM06.1  AM06.2
Asset Type           An asset type represents a grouping of      AM06.3  AM06.5
                     like assets. Asset types are used to        AM115   AM12.1
                     group assets into reporting classes and     AM125   AM135
                     to default common asset definition data.    AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM211
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM551
                                                                 AM88.7  AM96.1
                                                                 AM98.1

ATP-SUB-TYPE         Alpha 10                                    AM06.1  AM06.2
Subtype              An asset subtype represents a more          AM06.3  AM06.5
                     detailed grouping of assets within an       AM115   AM12.1
                     asset type grouping. Asset subtypes are     AM125   AM135
                     used to group assets into reporting         AM145   AM15.1
                     classes and to default common asset         AM15.2  AM15.3
                     definition data. Subtypes must be unique    AM15.4  AM154
                     within an asset type.                       AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM211
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM551
                                                                 AM88.7  AM96.1
                                                                 AM98.1

ATP-DESCRIPTION      Alpha 30  (Lower Case)                      AM06.1  AM06.2
Description          The asset type description.                 AM06.3  AM06.5
                                                                 AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM211
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM551
                                                                 AM88.7  AM96.1
                                                                 AM98.1

ATP-PROPERTY         Alpha 1                                     AM06.1  AM06.2
Property             This value classifies the kind of           AM06.3  AM06.5
                     property that is represented by this        AM115   AM12.1
                     asset type.                                 AM125   AM135
                                                                 AM145   AM15.1
                     P = Personal                                AM15.2  AM15.3
                     R = Real                                    AM15.4  AM154
                     L = Land                                    AM170   AM180
                     S = Stock                                   AM190   AM192
                     O = Other                                   AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM211
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM551
                                                                 AM88.7  AM96.1
                                                                 AM98.1

ATP-INV-FLAG         Alpha 1                                     AM06.1  AM06.2
Inv Flag             This flag indicates whether an asset        AM06.3  AM06.5
                     should be included as part of the           AM115   AM12.1
                     physical inventory. If it is not, the       AM125   AM135
                     asset is ignored in inventories. Valid      AM145   AM15.1
                     values are:                                 AM15.2  AM15.3
                     Y = Yes                                     AM15.4  AM154
                     N = No                                      AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM211
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM551
                                                                 AM88.7  AM96.1
                                                                 AM98.1

                         AMASTTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATPSET1   COMPANY                                                AM06.1  AM06.2
          ASSET-TYPE                                             AM06.3  AM06.5
          SUB-TYPE                                               AM115   AM118
                                                                 AM12.1  AM120
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM185   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM205
                                                                 AM206   AM21.1
                                                                 ...

ATPSET2   ASSET-TYPE    KeyChange                                AM06.4  AM06.5
          SUB-TYPE                                               AM115   AM12.1
          COMPANY                                                AM15.1  AM15.2
                                                                 AM15.3  AM15.4

                         AMASTTYPE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amcontrol      AMCONTROL    Not Required

                            ATP-COMPANY       -> CTL-COMPANY

Glsystem       GLSYSTEM     Required

                            ATP-COMPANY       -> GLS-COMPANY

                         AMASTTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amaccount      AMACCOUNT    Delete Cascades

                            ATP-COMPANY       -> AAC-COMPANY
                            Spaces            -> AAC-ACCT-GRP
                            ATP-ASSET-TYPE    -> AAC-ASSET-TYPE
                            ATP-SUB-TYPE      -> AAC-SUB-TYPE
                                                 AAC-ACCT-TYPE

Amasset1       AMASSET

                            1                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amasset2       AMASSET

                            2                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amasset3       AMASSET

                            3                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amassetadj     AMASSETADJ

                            ATP-COMPANY       -> ASA-COMPANY
                            ATP-ASSET-TYPE    -> ASA-ASSET-TYPE
                            ATP-SUB-TYPE      -> ASA-SUB-TYPE
                                                 ASA-ASSET
                                                 ASA-PROCESS-SEQ

Amassetdsp     AMASSET

                            9                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amassettrf     AMASSETTRF

                            ATP-COMPANY       -> ATF-COMPANY
                            ATP-ASSET-TYPE    -> ATF-ASSET-TYPE
                            ATP-SUB-TYPE      -> ATF-SUB-TYPE
                                                 ATF-ASSET
                                                 ATF-PROCESS-SEQ

Ambooktype     AMBOOKTYPE

                            ATP-ASSET-TYPE    -> ADR-ASSET-TYPE
                                                 ADR-SUB-TYPE
                                                 ADR-BOOK

Amclassdep     AMCLASSDEP

                            ATP-ASSET-TYPE    -> CLD-ASSET-TYPE
                            ATP-SUB-TYPE      -> CLD-SUB-TYPE
                                                 CLD-BOOK
                                                 CLD-COMPANY
                                                 CLD-AST-ACCT-UNIT
                                                 CLD-EXP-ACCT-UNIT
                                                 CLD-ACM-ACCT-UNIT
                                                 CLD-YR-END-DATE
                                                 CLD-PERIOD