Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTTYPE


                             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     AM235
AM240     AM245     AM25.1    AM25.3    AM250     AM255
AM260     AM265     AM267     AM278     AM280     AM281
AM285     AM287     AM290     AM292     AM295     AM35.1
AM41.2    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    AM214

UPDATED BY

AM06.1    AM06.2    AM06.3    AM06.5    AM115     AM117
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     AM230     AM282     AM30.1
AM30.2    AM40.1    AM40.2    AM40.3    AM500     AM502
AM551     AM700     AM88.7    AM92.1    AM96.1    AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATP-COMPANY            Numeric 4                                 AM06.1  AM06.2
Element: Company       The general ledger company number         AM06.3  AM06.5
                       associated with the asset type record.    AM115   AM117
                                                                 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   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ATP-ASSET-TYPE         Alpha 10                                  AM06.1  AM06.2
Element: Asset Type    An asset type represents a grouping of    AM06.3  AM06.5
                       like assets. Asset types are used to      AM115   AM117
                       group assets into reporting classes and   AM12.1  AM125
                       to default common asset definition data.  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   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ATP-SUB-TYPE           Alpha 10                                  AM06.1  AM06.2
Element: Subtype       An asset subtype represents a more        AM06.3  AM06.5
                       detailed grouping of assets within an     AM115   AM117
                       asset type grouping. Asset subtypes are   AM12.1  AM125
                       used to group assets into reporting       AM135   AM145
                       classes and to default common asset       AM15.1  AM15.2
                       definition data. Subtypes must be unique  AM15.3  AM15.4
                       within an asset type.                     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   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ATP-DESCRIPTION        Alpha 30  (Lower Case)                    AM06.1  AM06.2
Element: Description   The asset type description.               AM06.3  AM06.5
                                                                 AM115   AM117
                                                                 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   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ATP-PROPERTY           Alpha 1                                   AM06.1  AM06.2
Element: Property      This value classifies the kind of         AM06.3  AM06.5
                       property that is represented by this      AM115   AM117
                       asset type.                               AM12.1  AM125
                       P = Personal                              AM135   AM145
                       R = Real                                  AM15.1  AM15.2
                       L = Land                                  AM15.3  AM15.4
                       S = Stock                                 AM154   AM170
                       O = Other                                 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   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ATP-INV-FLAG           Alpha 1                                   AM06.1  AM06.2
Element: Inv Flag      This flag indicates whether an asset      AM06.3  AM06.5
                       should be included as part of the         AM115   AM117
                       physical inventory. If it is not, the     AM12.1  AM125
                       asset is ignored in inventories. Valid    AM135   AM145
                       values are:                               AM15.1  AM15.2
                       Y = Yes                                   AM15.3  AM15.4
                       N = No                                    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   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ATP-DEP-EXP-ALLOC      Alpha 1                                   AM06.1  AM06.2
Element: Dep Exp Alloc This field indicates whether the asset    AM06.3  AM06.5
                       type allows depreciation expense to ve    AM115   AM117
                       allocated to multiple accounting units.   AM12.1  AM125
                       Valid values are:                         AM135   AM145
                       N = No (the default)                      AM15.1  AM15.2
                       Y = Yes                                   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   AM230
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   AM700
                                                                 AM88.7  AM92.1
                                                                 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                                               AM06.6  AM115
                                                                 AM117   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
                                                                 ...

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

                         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

Amtypalloc     AMTYPALLOC

                            ATP-COMPANY       -> ALL-COMPANY
                            ATP-ASSET-TYPE    -> ALL-ASSET-TYPE
                            ATP-SUB-TYPE      -> ALL-SUB-TYPE
                                                 ALL-START-DATE
                                                 ALL-SEQUENCE-NBR