Lawson Insight Technical Documentation


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     AM180     AM185     AM205     AM212
AM220     AM221     AM222     AM223     AM224     AM225
AM230     AM235     AM240     AM245     AM250     AM255
AM260     AM265     AM280     AM285     AM290     AM292
AM295     AM35.1    AM45.1    AM580     AM60.1    AM70.1
AM90.1    AM95.1

UPDATED BY

AM06.1    AM06.2    AM115     AM12.1    AM125     AM135
AM145     AM15.1    AM15.2    AM15.3    AM15.4    AM170
AM190     AM192     AM20.1    AM20.2    AM20.3    AM20.4
AM20.5    AM20.6    AM30.1    AM30.2    AM40.1    AM40.2
AM40.3    AM500     AM950     AM951     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           AM115   AM12.1
                     associated with the asset type record.      AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM950   AM951
                                                                 AM96.1  AM98.1

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

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

ATP-DESCRIPTION      Alpha 30  (Lower Case)                      AM06.1  AM06.2
Description          The asset type description.                 AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM950   AM96.1
                                                                 AM98.1

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

                         AMASTTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATPSET1   COMPANY                                                AM06.1  AM06.2
          ASSET-TYPE                                             AM115   AM118
          SUB-TYPE                                               AM12.1  AM120
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM185
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM205   AM212
                                                                 AM220   AM221
                                                                 AM222   AM223
                                                                 ...

                         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