Lawson Insight Technical Documentation


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     AM700

UPDATED BY

AM05.1    AM06.1    AM06.2    AM115     AM12.1    AM125
AM135     AM145     AM15.1    AM15.2    AM15.3    AM15.4
AM170     AM190     AM192     AM20.1    AM20.2    AM20.3
AM20.4    AM20.5    AM20.6    AM30.1    AM30.2    AM40.1
AM40.2    AM40.3    AM500     AM950     AM951     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  AM115
                     for posting journal entries for the         AM12.1  AM125
                     account.                                    AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM950
                                                                 AM951   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    AM135   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,      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).                            AM30.1  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM950
                                                                 AM951   AM96.1
                                                                 AM98.1

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

AAC-SUB-TYPE         Alpha 10                                    AM06.1  AM06.2
Asset Subtype        If the account is defined for an asset      AM115   AM12.1
                     subtype, this field identifies the asset    AM125   AM135
                     subtype. An asset subtype represents a      AM145   AM15.1
                     more detailed grouping of assets within     AM15.2  AM15.3
                     an asset type. Asset subtypes are used      AM15.4  AM170
                     to group assets into reporting classes      AM190   AM192
                     and allow common asset definition data      AM20.1  AM20.2
                     to default.                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM950   AM951
                                                                 AM96.1  AM98.1

AAC-ACCT-TYPE        Alpha 3                                     AM05.1  AM06.1
Account Type         This field identifies the type of           AM06.2  AM115
                     account.                                    AM12.1  AM125
                                                                 AM135   AM145
                     Valid values for accounts associated        AM15.1  AM15.2
                     with an account group are:                  AM15.3  AM15.4
                                                                 AM170   AM190
                     PRO = Proceeds                              AM192   AM20.1
                     GAN = Gain                                  AM20.2  AM20.3
                     LOS = Loss                                  AM20.4  AM20.5
                     CLR = Clearing                              AM20.6  AM30.1
                     COS = Disposal Expense                      AM30.2  AM40.1
                     DGN = Deferred Gain                         AM40.2  AM40.3
                     DLS = Deferred Loss                         AM500   AM950
                                                                 AM951   AM96.1
                     Valid values for an account associated      AM98.1
                     with an asset type are:

                     AST = Asset
                     ACM = Accumulated Depreciation
                     EXP = Depreciation Expense




AAC-ACCT-UNIT        Alpha 15
Accounting Unit      This is the accounting unit used for
                     creating journal entries for an asset.

                     The accounting unit is a shorthand
                     notation representing the variable level
                     number. The accounting unit must be
                     defined in the General Ledger Names file
                     as a posting accounting unit.



AAC-ACCOUNT          Numeric 6                                   AM05.1  AM06.1
Account              This is the account number used for         AM06.2  AM115
                     creating journal entries for an asset.      AM12.1  AM125
                                                                 AM135   AM145
                     This field, along with the accounting       AM15.1  AM15.2
                     unit and subaccount, make up the            AM15.3  AM15.4
                     location (account) where amounts and        AM170   AM190
                     other account information are stored.       AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM950
                                                                 AM951   AM96.1
                                                                 AM98.1

AAC-SUB-ACCT         Numeric 4                                   AM05.1  AM06.1
Subaccount           If you are using subaccounts, this          AM06.2  AM115
                     field contains the subaccount number        AM12.1  AM125
                     used for creating journal entries for an    AM135   AM145
                     asset.                                      AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM500   AM950
                                                                 AM951   AM96.1
                                                                 AM98.1

AAC-ACTIVITY         Alpha 15                                    AM05.1  AM06.1
Activity             This is the activity associated with        AM06.2  AM115
                     the account.                                AM12.1  AM125
                                                                 AM135   AM145
                     Activities are the processes or             AM15.1  AM15.2
                     procedures that produce work. Cost          AM15.3  AM15.4
                     objects (products, services, customers,     AM170   AM190
                     and so on) are the reasons for              AM192   AM20.1
                     performing the activity. Activities and     AM20.2  AM20.3
                     cost object activities are used             AM20.4  AM20.5
                     synonymously in the Lawson Activity         AM20.6  AM30.1
                     Management system. Direct costs are         AM30.2  AM40.1
                     posted to activities, and indirect costs    AM40.2  AM40.3
                     are allocated to activities based on        AM500   AM950
                     activity drivers.                           AM951   AM96.1
                                                                 AM98.1
                     Activities are grouped or organized by
                     activity levels. There are two types of
                     activities: "posting allowed" and
                     "summary only." Use posting level
                     activities to budget and maintain all
                     posted transactions. Summary activities
                     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  AM115
                     with the account.                           AM12.1  AM125
                                                                 AM135   AM145
                     Account categories are groupings of         AM15.1  AM15.2
                     costs, revenues, or a combination of        AM15.3  AM15.4
                     both used for reporting and inquiries       AM170   AM190
                     for activities in the Activity              AM192   AM20.1
                     Management system. All transactions are     AM20.2  AM20.3
                     posted to an account category within an     AM20.4  AM20.5
                     activity. You can assign a specific         AM20.6  AM30.1
                     General Ledger account or range of          AM30.2  AM40.1
                     accounts (company, accounting unit,         AM40.2  AM40.3
                     account, and subaccount) that make up       AM500   AM950
                     the transactions posted to an account       AM96.1  AM98.1
                     category using AC07.1 (Account
                     Assignment).



                         AMACCOUNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AACSET1   COMPANY                                                AM05.1  AM06.1
          ACCT-GRP                                               AM06.2  AM115
          ASSET-TYPE                                             AM12.1  AM125
          SUB-TYPE                                               AM135   AM145
          ACCT-TYPE                                              AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM205
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM700   AM951
                                                                 ...