Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMACCOUNT


                             AMACCOUNT FILE

                                Account

The Account file stores the general ledger accounts that are used to create
journal entries when assets are processed (added, adjusted, transferred, and
disposed of) for an account group or for an asset type. Each account record
defines one general ledger account for an account group or an asset type
record.


REFERENCED BY

AM205

UPDATED BY

AC160     AM05.1    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     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

AAC-COMPANY            Numeric 4                                 AC160   AM05.1
Element: Company       The general ledger company number used    AM06.1  AM06.2
                       for posting journal entries for the       AM06.3  AM06.5
                       account.                                  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
                                                                 ...

AAC-ACCT-GRP           Alpha 10                                  AC160   AM05.1
Element: Account Group If the account is defined for an          AM115   AM117
                       account group, this field identifies the  AM12.1  AM125
                       account group. Account groups are         AM145   AM15.1
                       user-defined and identify the general     AM15.2  AM15.3
                       ledger proceeds, clearing, gain, loss,    AM15.4  AM154
                       and expense accounts that are used to     AM170   AM19.1
                       create journal entries when assets are    AM19.2  AM192
                       processed (added, adjusted, transferred,  AM20.1  AM20.2
                       or disposed of).                          AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM30.1  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM502
                                                                 AM551   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
                                                                 ...

AAC-ASSET-TYPE         Alpha 10                                  AC160   AM06.1
Element: Asset Type    If the account is defined for an asset    AM06.2  AM06.3
                       type, this field identifies the asset     AM06.5  AM115
                       type. An asset type represents a          AM117   AM12.1
                       grouping of like assets. Asset types are  AM125   AM135
                       used to group assets into reporting       AM145   AM15.1
                       classes and to default common asset       AM15.2  AM15.3
                       definition data. The account record       AM15.4  AM154
                       represents a general ledger asset,        AM170   AM180
                       accumulated depreciation, or              AM19.1  AM19.2
                       depreciation expense account for the      AM190   AM192
                       asset type.                               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
                                                                 ...

AAC-SUB-TYPE           Alpha 10                                  AC160   AM06.1
Element: Asset Subtype If the account is defined for an asset    AM06.2  AM06.3
                       subtype, this field identifies the asset  AM06.5  AM115
                       subtype. An asset subtype represents a    AM117   AM12.1
                       more detailed grouping of assets within   AM125   AM135
                       an asset type. Asset subtypes are used    AM145   AM15.1
                       to group assets into reporting classes    AM15.2  AM15.3
                       and allow common asset definition data    AM15.4  AM154
                       to default.                               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
                                                                 ...

AAC-ACCT-TYPE          Alpha 3                                   AC160   AM05.1
Element: Account Type  This field identifies the type of         AM06.1  AM06.2
                       account.                                  AM06.3  AM06.5
                                                                 AM115   AM117
                       Valid values for accounts associated      AM12.1  AM125
                       with an account group are:                AM135   AM145
                                                                 AM15.1  AM15.2
                       PRO = Proceeds                            AM15.3  AM15.4
                       GAN = Gain                                AM154   AM170
                       LOS = Loss                                AM180   AM19.1
                       CLR = Clearing                            AM19.2  AM190
                       COS = Disposal Expense                    AM192   AM20.1
                       DGN = Deferred Gain                       AM20.2  AM20.3
                       DLS = Deferred Loss                       AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                       Valid values for an account associated    AM21.2  AM21.3
                       with an asset type are:                   AM21.4  AM21.5
                                                                 AM21.6  AM230
                       AST = Asset                               AM282   AM30.1
                       ACM = Accumulated Depreciation            AM30.2  AM30.3
                       EXP = Depreciation Expense                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
                                                                 ...

AAC-ACCOUNT            Numeric 6                                 AC160   AM05.1
Element: Account       This is the account number used for       AM06.1  AM06.2
                       creating journal entries for an asset.    AM06.3  AM06.5
                                                                 AM115   AM117
                       This field, along with the accounting     AM12.1  AM125
                       unit and subaccount, make up the          AM135   AM145
                       location (account) where amounts and      AM15.1  AM15.2
                       other account information are stored.     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
                                                                 ...

AAC-SUB-ACCT           Numeric 4                                 AC160   AM05.1
Element: Subaccount    If you are using subaccounts, this        AM06.1  AM06.2
                       field contains the subaccount number      AM06.3  AM06.5
                       used for creating journal entries for an  AM115   AM117
                       asset.                                    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
                                                                 ...

AAC-ACTIVITY           Alpha 15                                  AC160   AM05.1
Element: Activity      This is the activity associated with      AM06.1  AM06.2
                       the account.                              AM06.3  AM06.5
                                                                 AM115   AM117
                       Activities are the processes or           AM12.1  AM125
                       procedures that produce work. Cost        AM135   AM145
                       objects (products, services, customers,   AM15.1  AM15.2
                       and so on) are the reasons for            AM15.3  AM15.4
                       performing the activity. Activities and   AM154   AM170
                       cost object activities are used           AM180   AM19.1
                       synonymously in the Lawson Activity       AM19.2  AM190
                       Management system. Direct costs are       AM192   AM20.1
                       posted to activities, and indirect costs  AM20.2  AM20.3
                       are allocated to activities based on      AM20.4  AM20.5
                       activity drivers.                         AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                       Activities are grouped or organized by    AM21.4  AM21.5
                       activity levels. There are two types of   AM21.6  AM230
                       activities: "posting allowed" and         AM282   AM30.1
                       "summary only." Use posting level         AM30.2  AM30.3
                       activities to budget and maintain all     AM40.1  AM40.2
                       posted transactions. Summary activities   AM40.3  AM40.4
                       or macro activities combine information   AM41.1  AM41.2
                       and balances from lower level activities  AM500   AM502
                       for reporting and inquiries.              AM551   AM88.7
                                                                 AM92.1  AM96.1
                                                                 AM98.1  AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 ...

AAC-ACCT-CATEGORY      Alpha 5                                   AC160   AM05.1
Element: Account CategoThis is the account category associated   AM06.1  AM06.2
                       with the account.                         AM06.3  AM06.5
                                                                 AM115   AM117
                       Account categories are groupings of       AM12.1  AM125
                       costs, revenues, or a combination of      AM135   AM145
                       both used for reporting and inquiries     AM15.1  AM15.2
                       for activities in the Activity            AM15.3  AM15.4
                       Management system. All transactions are   AM154   AM170
                       posted to an account category within an   AM180   AM19.1
                       activity. You can assign a specific       AM19.2  AM190
                       General Ledger account or range of        AM192   AM20.1
                       accounts (company, accounting unit,       AM20.2  AM20.3
                       account, and subaccount) that make up     AM20.4  AM20.5
                       the transactions posted to an account     AM20.6  AM21.1
                       category using AC07.1 (Account            AM21.2  AM21.3
                       Assignment).                              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
                                                                 ...

                         AMACCOUNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AACSET1   COMPANY                                                AC160   AM05.1
          ACCT-GRP                                               AM06.1  AM06.2
          ASSET-TYPE                                             AM06.3  AM06.5
          SUB-TYPE                                               AM06.6  AM115
          ACCT-TYPE                                              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
                                                                 ...