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     AM206     AM211
AM212     AM220     AM221     AM222     AM223     AM224
AM225     AM235     AM240     AM245     AM25.1    AM25.3
AM250     AM255     AM258     AM260     AM265     AM267
AM278     AM280     AM281     AM285     AM287     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    AM214

UPDATED BY

AC160     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
AM19.1    AM19.2    AM190     AM192     AM20.1    AM20.2
AM20.3    AM20.4    AM20.5    AM20.6    AM21.1    AM21.2
AM21.3    AM21.4    AM21.5    AM21.6    AM230     AM282
AM30.1    AM30.2    AM30.3    AM40.1    AM40.2    AM40.3
AM40.4    AM41.1    AM41.2    AM500     AM502     AM551
AM700     AM88.7    AM92.1    AM96.1    AM98.1    AP115
AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP220     AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP305     API1.1    API2.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    MA180     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATP-COMPANY            Numeric 4                                 AC160   AM06.1
Element: Company       The general ledger company number         AM06.2  AM06.3
                       associated with the asset type record.    AM06.5  AM115
                                                                 AM117   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM88.7  AM92.1
                                                                 AM96.1  AM98.1
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 ...

ATP-ASSET-TYPE         Alpha 10                                  AC160   AM06.1
Element: Asset Type    An asset type represents a grouping of    AM06.2  AM06.3
                       like assets. Asset types are used to      AM06.5  AM115
                       group assets into reporting classes and   AM117   AM12.1
                       to default common asset definition data.  AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM88.7  AM92.1
                                                                 AM96.1  AM98.1
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 ...

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

ATP-DESCRIPTION        Alpha 30  (Lower Case)                    AC160   AM06.1
Element: Description   The asset type description.               AM06.2  AM06.3
                                                                 AM06.5  AM115
                                                                 AM117   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM88.7  AM92.1
                                                                 AM96.1  AM98.1
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 ...

ATP-PROPERTY           Alpha 1                                   AC160   AM06.1
Element: Property      This value classifies the kind of         AM06.2  AM06.3
                       property that is represented by this      AM06.5  AM115
                       asset type.                               AM117   AM12.1
                       P = Personal                              AM125   AM135
                       R = Real                                  AM145   AM15.1
                       L = Land                                  AM15.2  AM15.3
                       S = Stock                                 AM15.4  AM154
                       O = Other                                 AM170   AM180
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM88.7  AM92.1
                                                                 AM96.1  AM98.1
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 ...

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

ATP-DEP-EXP-ALLOC      Alpha 1                                   AC160   AM06.1
Element: Dep Exp Alloc This field indicates whether the asset    AM06.2  AM06.3
                       type allows depreciation expense to ve    AM06.5  AM115
                       allocated to multiple accounting units.   AM117   AM12.1
                       Valid values are:                         AM125   AM135
                       N = No (the default)                      AM145   AM15.1
                       Y = Yes                                   AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM502   AM551
                                                                 AM700   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1  AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 ...

                         AMASTTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

ATPSET2   ASSET-TYPE    KeyChange                                AC160   AM06.4
          SUB-TYPE                                               AM06.5  AM115
          COMPANY                                                AM117   AM12.1
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM19.1  AM19.2
                                                                 AM206   AM211
                                                                 AM212   AM214
                                                                 AM265   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 ...

                         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