AMACCOUNT

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.
UPDATED BY
AM05.1 AM06.1 AM06.2 AM06.3 AM06.5 AM06.6
AM115 AM117 AM12.1 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM170
AM180 AM19.1 AM19.2 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 AM30.3 AM40.1 AM40.2
AM40.3 AM40.4 AM41.1 AM41.2 AM500 AM502
AM551 AM88.7 AM92.1 AM96.1 AM98.1 AP115
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP305 API1.1 API2.1 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MAI1.1 PO136 PO190 PO300 PO520
POCP.1 POI3.1 POII.1 POIJ.1 AM205

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAC-COMPANY
Element: Company
Numeric 4
The general ledger company number used for posting journal entries for the account.
...
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
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AAC-ACCT-GRP
Element: Account Group
Alpha 10
If 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).
...
AM05.1 AM115
AM117 AM12.1
AM125 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AM30.1
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
AAC-ASSET-TYPE
Element: Asset Type
Alpha 10
If 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.
...
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 AM19.1
AM19.2 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AAC-SUB-TYPE
Element: Asset Subtype
Alpha 10
If 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.
...
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 AM19.1
AM19.2 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AAC-ACCT-TYPE
Element: Account Type
Alpha 3
This field identifies the type of account. Valid values for accounts associated with an account group are: PRO = Proceeds GAN = Gain LOS = Loss CLR = Clearing COS = Disposal Expense DGN = Deferred Gain DLS = Deferred Loss Valid values for an account associated with an asset type are: AST = Asset ACM = Accumulated Depreciation EXP = Depreciation Expense
...
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
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AAC-ASSET-EVENT
Element: All Flag
Alpha 1

1 = Additions
2 = Adjustments
3 = Transfers
4 = Disposals
5 = Re-instatements
...
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 AM19.1
AM19.2 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AAC-ACCOUNT
Element: Account
Numeric 6
This 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.
...
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
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AAC-SUB-ACCT
Element: Subaccount
Numeric 4
If you are using subaccounts, this field contains the subaccount number used for creating journal entries for an asset.
...
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
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AAC-ACTIVITY
Element: Activity
Alpha 15
This 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.
...
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
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AAC-ACCT-CATEGORY
Element: Account Category
Alpha 5
This 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).
...
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
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4


AMACCOUNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AACSET1 COMPANY
ACCT-GRP
ASSET-TYPE
SUB-TYPE
ACCT-TYPE
ASSET-EVENT
...
AM05.1 AM06.1
AM06.2 AM06.3
AM06.5 AM06.6
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM205


File created: Wed Jun 08 20:47:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.