AMACCOUNT

Asset Management 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
AC10.1 AC10.3 AC56.1 AC560 AC71.1 AM08.1
AM08.2 AM09.1 AM16.1 AM17.1 AP22.2


UPDATED BY
AC160 AM05.1 AM06.1 AM06.2 AM06.3 AM06.5
AM115 AM117 AM12.1 AM12.2 AM125 AM135
AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM154
AM155 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 AM22.1 AM22.2 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 AP510
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA126 MA180 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 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.
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 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
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).
...
AC160 AM05.1
AM115 AM117
AM12.1 AM12.2
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 AM22.1
AM22.2 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
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.
...
AC160 AM06.1
AM06.2 AM06.3
AM06.5 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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
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.
...
AC160 AM06.1
AM06.2 AM06.3
AM06.5 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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
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
RVL = Revalue
RVS = Surplus
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 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
AAC-ASSET-EVENT
Element: All Flag
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
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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
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.
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 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
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.
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 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
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.
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 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
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).
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 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


AMACCOUNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AACSET1 COMPANY
ACCT-GRP
ASSET-TYPE
SUB-TYPE
ACCT-TYPE
ASSET-EVENT
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM05.1 AM06.1
AM06.2 AM06.3
AM06.5 AM06.6
AM08.1 AM08.2
AM09.1 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
AM16.1 AM17.1


AMACCOUNT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amacctau AMACCTAU
AAC-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


File created: Thu Jun 09 02:04:33 2016

Home
Contact Us



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