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
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    AM21.1    AM21.2    AM21.3    AM21.4    AM21.5
AM21.6    AM230     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
Element: 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  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM230
                                                                 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
Element: 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
Element: 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
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   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
Element: 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
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   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
Element: 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  AM21.1
                       DLS = Deferred Loss                       AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                       Valid values for an account associated    AM21.6  AM230
                       with an asset type are:                   AM282   AM30.1
                                                                 AM30.2  AM40.1
                       AST = Asset                               AM40.2  AM40.3
                       ACM = Accumulated Depreciation            AM500   AM551
                       EXP = Depreciation Expense                AM88.7  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
                                                                 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  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM230
                                                                 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
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  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  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM230
                                                                 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
Element: 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  AM21.1
                       are allocated to activities based on      AM21.2  AM21.3
                       activity drivers.                         AM21.4  AM21.5
                                                                 AM21.6  AM230
                       Activities are grouped or organized by    AM282   AM30.1
                       activity levels. There are two types of   AM30.2  AM40.1
                       activities: "posting allowed" and         AM40.2  AM40.3
                       "summary only." Use posting level         AM500   AM551
                       activities to budget and maintain all     AM88.7  AM96.1
                       posted transactions. Summary activities   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
Element: Account CategoThis 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  AM21.1
                       account, and subaccount) that make up     AM21.2  AM21.3
                       the transactions posted to an account     AM21.4  AM21.5
                       category using AC07.1 (Account            AM21.6  AM230
                       Assignment).                              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  AM06.6
          SUB-TYPE                                               AM115   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   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