Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
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     AM282     AM30.1    AM30.2
AM40.1    AM40.2    AM40.3    AM500     AM551     AM88.7
AM96.1    AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AAC-COMPANY          Numeric 4                                   AM05.1  AM06.1
Company              The general ledger company number used      AM06.2  AM06.3
                     for posting journal entries for the         AM06.5  AM115
                     account.                                    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   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

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

AAC-ASSET-TYPE       Alpha 10                                    AM06.1  AM06.2
Asset Type           If the account is defined for an asset      AM06.3  AM06.5
                     type, this field identifies the asset       AM115   AM12.1
                     type. An asset type represents a            AM125   AM135
                     grouping of like assets. Asset types are    AM145   AM15.1
                     used to group assets into reporting         AM15.2  AM15.3
                     classes and to default common asset         AM15.4  AM154
                     definition data. The account record         AM170   AM180
                     represents a general ledger asset,          AM190   AM192
                     accumulated depreciation, or                AM20.1  AM20.2
                     depreciation expense account for the        AM20.3  AM20.4
                     asset type.                                 AM20.5  AM20.6
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM211
                                                                 AM282   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM551
                                                                 AM88.7  AM96.1
                                                                 AM98.1

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

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



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

AAC-SUB-ACCT         Numeric 4                                   AM05.1  AM06.1
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    AM12.1  AM125
                     asset.                                      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   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

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




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

AACSET2   ACCT-GRP      KeyChange
          COMPANY
          ASSET-TYPE
          SUB-TYPE
          ACCT-TYPE

AACSET3   ASSET-TYPE    KeyChange
          SUB-TYPE
          COMPANY
          ACCT-GRP
          ACCT-TYPE