Lawson Insight Technical Documentation |
|
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
AC160 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 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 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAC-COMPANY Numeric 4 AC160 AM05.1
Element: Company The general ledger company number used AM06.1 AM06.2
for posting journal entries for the AM06.3 AM06.5
account. 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
...
AAC-ACCT-GRP Alpha 10 AC160 AM05.1
Element: Account Group If the account is defined for an AM115 AM117
account group, this field identifies the AM12.1 AM125
account group. Account groups are AM145 AM15.1
user-defined and identify the general AM15.2 AM15.3
ledger proceeds, clearing, gain, loss, AM15.4 AM154
and expense accounts that are used to AM170 AM19.1
create journal entries when assets are AM19.2 AM192
processed (added, adjusted, transferred, AM20.1 AM20.2
or disposed of). 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
...
AAC-ASSET-TYPE Alpha 10 AC160 AM06.1
Element: Asset Type If the account is defined for an asset AM06.2 AM06.3
type, this field identifies the asset AM06.5 AM115
type. An asset type represents a AM117 AM12.1
grouping of like assets. Asset types are AM125 AM135
used to group assets into reporting AM145 AM15.1
classes and to default common asset AM15.2 AM15.3
definition data. The account record AM15.4 AM154
represents a general ledger asset, AM170 AM180
accumulated depreciation, or AM19.1 AM19.2
depreciation expense account for the AM190 AM192
asset type. 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-TYPE Alpha 10 AC160 AM06.1
Element: Asset Subtype If the account is defined for an asset AM06.2 AM06.3
subtype, this field identifies the asset AM06.5 AM115
subtype. An asset subtype represents a AM117 AM12.1
more detailed grouping of assets within AM125 AM135
an asset type. Asset subtypes are used AM145 AM15.1
to group assets into reporting classes AM15.2 AM15.3
and allow common asset definition data AM15.4 AM154
to default. 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-TYPE Alpha 3 AC160 AM05.1
Element: Account Type This field identifies the type of AM06.1 AM06.2
account. AM06.3 AM06.5
AM115 AM117
Valid values for accounts associated AM12.1 AM125
with an account group are: AM135 AM145
AM15.1 AM15.2
PRO = Proceeds AM15.3 AM15.4
GAN = Gain AM154 AM170
LOS = Loss AM180 AM19.1
CLR = Clearing AM19.2 AM190
COS = Disposal Expense AM192 AM20.1
DGN = Deferred Gain AM20.2 AM20.3
DLS = Deferred Loss AM20.4 AM20.5
AM20.6 AM21.1
Valid values for an account associated AM21.2 AM21.3
with an asset type are: AM21.4 AM21.5
AM21.6 AM230
AST = Asset AM282 AM30.1
ACM = Accumulated Depreciation AM30.2 AM30.3
EXP = Depreciation Expense 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
...
AAC-ACCOUNT Numeric 6 AC160 AM05.1
Element: Account This is the account number used for AM06.1 AM06.2
creating journal entries for an asset. AM06.3 AM06.5
AM115 AM117
This field, along with the accounting AM12.1 AM125
unit and subaccount, make up the AM135 AM145
location (account) where amounts and AM15.1 AM15.2
other account information are stored. 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
...
AAC-SUB-ACCT Numeric 4 AC160 AM05.1
Element: Subaccount If you are using subaccounts, this AM06.1 AM06.2
field contains the subaccount number AM06.3 AM06.5
used for creating journal entries for an AM115 AM117
asset. 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
...
AAC-ACTIVITY Alpha 15 AC160 AM05.1
Element: Activity This is the activity associated with AM06.1 AM06.2
the account. AM06.3 AM06.5
AM115 AM117
Activities are the processes or AM12.1 AM125
procedures that produce work. Cost AM135 AM145
objects (products, services, customers, AM15.1 AM15.2
and so on) are the reasons for AM15.3 AM15.4
performing the activity. Activities and AM154 AM170
cost object activities are used AM180 AM19.1
synonymously in the Lawson Activity AM19.2 AM190
Management system. Direct costs are AM192 AM20.1
posted to activities, and indirect costs AM20.2 AM20.3
are allocated to activities based on AM20.4 AM20.5
activity drivers. AM20.6 AM21.1
AM21.2 AM21.3
Activities are grouped or organized by AM21.4 AM21.5
activity levels. There are two types of AM21.6 AM230
activities: "posting allowed" and AM282 AM30.1
"summary only." Use posting level AM30.2 AM30.3
activities to budget and maintain all AM40.1 AM40.2
posted transactions. Summary activities AM40.3 AM40.4
or macro activities combine information AM41.1 AM41.2
and balances from lower level activities AM500 AM502
for reporting and inquiries. AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
...
AAC-ACCT-CATEGORY Alpha 5 AC160 AM05.1
Element: Account CategoThis is the account category associated AM06.1 AM06.2
with the account. AM06.3 AM06.5
AM115 AM117
Account categories are groupings of AM12.1 AM125
costs, revenues, or a combination of AM135 AM145
both used for reporting and inquiries AM15.1 AM15.2
for activities in the Activity AM15.3 AM15.4
Management system. All transactions are AM154 AM170
posted to an account category within an AM180 AM19.1
activity. You can assign a specific AM19.2 AM190
General Ledger account or range of AM192 AM20.1
accounts (company, accounting unit, AM20.2 AM20.3
account, and subaccount) that make up AM20.4 AM20.5
the transactions posted to an account AM20.6 AM21.1
category using AC07.1 (Account AM21.2 AM21.3
Assignment). 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
...
AMACCOUNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AACSET1 COMPANY AC160 AM05.1
ACCT-GRP AM06.1 AM06.2
ASSET-TYPE AM06.3 AM06.5
SUB-TYPE AM06.6 AM115
ACCT-TYPE 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
...
|