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

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
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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

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

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

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

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




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

                         AMACCOUNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AACSET1   COMPANY                                                AM05.1  AM06.1
          ACCT-GRP                                               AM06.2  AM06.3
          ASSET-TYPE                                             AM06.5  AM115
          SUB-TYPE                                               AM117   AM12.1
          ACCT-TYPE                                              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
                                                                 AM205   AM206
                                                                 AM21.1  AM21.2
                                                                 ...