AMACCOUNT – Asset Management Account

System
Asset Management (AM)
Prefix
AAC
Primary key
COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT
Fields
10
Updated by
291 programs
Referenced by
11 programs

AMACCOUNT is the Asset Management Account table in Lawson Asset Management (prefix AAC). It is indexed by COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT (AACSET1). It is related 1:M to AMACCTAU. It is updated by AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 and 283 more and referenced by AC10.1, AC10.3, AC56.1, AC560, AC71.1, AM08.1, AM08.2, AM09.1 and 3 more. The table has 10 fields, 1 index and 1 documented relation.

About AMACCOUNT

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.

Fields (10)

Column = COBOL field name without the AAC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AAC-COMPANY PK
COMPANY		Numeric 4The general ledger company number used for posting journal entries for the account.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
AAC-ACCT-GRP PK
ACCT_GRP		Alpha 10If the account is defined for an account group, this field identifies the account group. Account groups are user-defined and identify the general ledger proceeds, clearing, gain, loss, and expense accounts that are used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of).AC160, AM05.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 +52 more (list truncated in source)
AAC-ASSET-TYPE PK
ASSET_TYPE		Alpha 10If the account is defined for an asset type, this field identifies the asset type. An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data. The account record represents a general ledger asset, accumulated depreciation, or depreciation expense account for the asset type.AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
AAC-SUB-TYPE PK
SUB_TYPE		Alpha 10If the account is defined for an asset subtype, this field identifies the asset subtype. An asset subtype represents a more detailed grouping of assets within an asset type. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default.AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
AAC-ACCT-TYPE PK
ACCT_TYPE		Alpha 3This field identifies the type of account. Valid values for accounts associated with an account group are: Valid values for an account associated with an asset type are:
  • PRO Proceeds
  • GAN Gain
  • LOS Loss
  • CLR Clearing
  • COS Disposal Expense
  • DGN Deferred Gain
  • DLS Deferred Loss
  • AST Asset
  • ACM Accumulated Depreciation
  • EXP Depreciation Expense
  • RVL Revalue
  • RVS Surplus
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
AAC-ASSET-EVENT PK
ASSET_EVENT		Alpha 1—
  • 1 Additions
  • 2 Adjustments
  • 3 Transfers
  • 4 Disposals
  • 5 Re-instatements
AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
AAC-ACCOUNT
ACCOUNT		Numeric 6This is the account number used for creating journal entries for an asset. This field, along with the accounting unit and subaccount, make up the location (account) where amounts and other account information are stored.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
AAC-SUB-ACCT
SUB_ACCT		Numeric 4If you are using subaccounts, this field contains the subaccount number used for creating journal entries for an asset.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
AAC-ACTIVITY
ACTIVITY		Alpha 15This is the activity associated with the account. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. 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.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
AAC-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5This is the account category associated with the account. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment).AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AACSET1COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENTPrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AmacctauAMACCTAUAAC-COMPANY → AAA-COMPANY, AAC-ACCT-GRP → AAA-ACCT-GRP, AAC-ASSET-TYPE → AAA-ASSET-TYPE, AAC-SUB-TYPE → AAA-SUB-TYPE, AAC-ACCT-TYPE → AAA-ACCT-TYPE, AAC-ASSET-EVENT → AAA-ASSET-EVENT, → AAA-ACTION, → AAA-DATE, → AAA-TIME, → AAA-UNIQUE-I-D

Programs

Updated by (291)

Referenced by (11)