ACACCTCATX FILE
Account Category Detail
This file includes detailed information on account categories from AC06.1
(Account Category Assignment). It includes the activity group and activity to
which each account category is assigned; the account category class, defined
in AC06.2 (Account Category Class); as well as All Activities, Billable,
Capitalization, and Error Suspense Account Category flags, and a mark-up
percentage.
REFERENCED BY
AC07.1 AC121 AC123 AC127 AC130 AC160
AC165 AC170 AC190 AC198 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC206 AC261 AC27.1
AC295 AC297 AC30.1 AC30.2 AC30.3 AC30.4
AC32.1 AC40.1 AC40.4 AC400 AC401 AC41.1
AC41.4 AC42.1 AC45.1 AC473 AC480 AC490
AC494 AC50.1 AC500 AC530 AC54.1 AC54.3
AC540 AC550 AC58.1 AC61.1 AC65.1 AC65.2
AC66.1 AC70.1 AC70.4 AC720 AC750 AC90.1
AC90.2 AC90.4 AC90.6 AC90.8 AC92.1 AC92.2
AC92.4 AC92.6 AC93.2 AC93.3 AC93.4 AC93.5
AC94.1 AC94.2 AC94.4 AC94.6 AC95.1 AC95.2
AC95.4 AC95.6 AC97.1 AC97.2 AC97.4 AC97.6
ACAC.1 ACVW.1 SE90.1 BR00.2 BR00.3 BR05.1
BR05.2 BR05.3 BR05.4 BR05.5 BR10.1 BR120
BR121 BR21.1 BR40.1 BR40.3 BR41.1 BR42.1
BR420 BR430 BR44.1 BR44.2 BR44.3 BR65.1
BR65.2 BRCC.1 GL199 AC00.1 AC420 AC05.1
HCAC.1 HAXX.1 AC196
UPDATED BY
AC06.1 AC105 AC110 AC120 AC300 AC310
AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AXX-ACTIVITY-GRP Alpha 15 AC06.1 AC105
Activity Group Required. This is the activity group AC110 AC120
for the account category.
AXX-ACTIVITY Alpha 15 AC06.1 AC105
Activity Required. This is the activity for the AC110
account category.
If all activities within the activity
group have the same account categories,
use Yes in the All Activities field.
AXX-ACCT-CATEGORY Alpha 5 AC06.1 AC105
Account Category Account categories are groupings of AC110
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson 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).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
The error suspense account category is
automatically assigned to all
activities.
AXX-ALL-ACT-FLAG Alpha 1 AC06.1 AC105
All Activities Flag Use Yes to assign account categories to AC110
all activities in the activity group.
With this option, the Activity field
must be blank.
Use No to assign account categories not
to all activities in the activity group
but only to a specific activity. This is
the default. With this option, the
Activity field must contain the name of
a particular activity.
AXX-BILLABLE-FLAG Alpha 1 AC06.1 AC105
Billable Flag This flag indicates whether an account AC110
category is billable. The default is No.
Y = Billable
N = Non-billable
AXX-CAPITAL-FLAG Alpha 1 AC06.1 AC105
Capitalization Flag This flag indicates whether an account AC110
category is to be capitalized.
Y = Yes
N = No
AXX-ACCT-CAT-CLASS Alpha 5 AC06.1 AC105
Account Category Optional. This must be a valid account AC110 BR120
Class category class. Account category classes BR121 BR21.1
are defined in AC06.2 (Account Category BR420
Class).
AXX-ES-ACCT-CAT-FL Alpha 1 AC06.1 AC105
Error Suspense This field defines the error suspense AC110
Accnt Cat Flag account category. Only one account
category can be flagged as error
suspense using Yes.
Y = Yes
N = No
AXX-MARK-UP-PCT Signed 5.2 AC06.1 AC105
Mark-up Percent This field indicates the percentage of AC110
markup for billing. If an account
category is billable, a mark-up
percentage can be established. A rate
schedule is for labor transactions only.
Mark-up percentages will increase the
amount by the percent entered.
AXX-FRINGE-PCT Signed 5.2
Fringe Pct
AXX-REVENUE-FLAG Alpha 1 AC06.1 AC105
Revenue Flag
AXX-ASSET-TEMPLATE Alpha 10 AC06.1
Asset Template A user-defined asset template
identifies general asset creation
parameters that you can use to quickly
add assets with minimal keying. Using a
template lets you default many data
items associated with a new asset.
You can use an asset template to
process quick asset additions in AM20.1
(Quick Addition) and to create assets
and asset books from Accounts Payable
and Activity Management interface
information. Asset templates are
required if you define new assets as a
result of transactions interfaced from
the Lawson Purchase Order or Accounts
Payable systems.
ACACCTCATX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AXXSET1 ACTIVITY-GRP AC06.1 AC07.1
ACTIVITY AC10.1 AC10.3
ACCT-CATEGORY AC105 AC110
AC120 AC121
AC123 AC127
AC130 AC160
AC165 AC170
AC190 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC206
AC261 AC27.1
AC295 AC297
AC30.1 AC30.2
AC30.3 AC30.4
...
AXXSET2 ACTIVITY-GRP AC00.1 AC20.5
ACCT-CATEGORY AC206 AC310
ACTIVITY AC420
AXXSET3 ACTIVITY-GRP Subset ACAC.1
ACCT-CATEGORY Where (ALL-ACT-FLAG = "Y" )
ACTIVITY
AXXSET4 ACCT-CATEGORY AC05.1 AC550
ACTIVITY-GRP AC750
ACTIVITY
AXXSET5 ACCT-CAT-CLASSKeyChange AC06.2 AC550
ACTIVITY-GRP AC750
ACTIVITY
ACCT-CATEGORY
AXXSET6 ACTIVITY AC10.1 HCAC.1
ACTIVITY-GRP HAXX.1
ACCT-CATEGORY
AXXSET7 ACCT-CAT-CLASSKeyChange
ACCT-CATEGORY
ACTIVITY
ACTIVITY-GRP
AXXSET8 ACTIVITY-GRP Subset AC06.1 AC196
ACTIVITY Where (ES-ACCT-CAT-FL != "Y" )
ACCT-CATEGORY
ACACCTCATX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
AXX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acacctclss ACACCTCLSS Not Required
AXX-ACCT-CAT-CLASS -> AXA-ACCT-CAT-CLASS
Acactgrp ACACTGRP Required
AXX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Not Required
AXX-ACTIVITY -> ACV-ACTIVITY
Acamcode ACAMCODE Not Required
AXX-ACTIVITY -> MCD-ACTIVITY
AXX-ACCT-CATEGORY -> MCD-ACCT-CATEGORY
Acbudhdr ACBUDHDR Not Required
AXX-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
AXX-ACTIVITY -> BDH-ACTIVITY
ACV-ACTIVE-BUD -> BDH-BUDGET-NBR
ACACCTCATX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbrdndtl ACBRDNDTL
AXX-ACTIVITY-GRP -> BRD-ACTIVITY-GRP
AXX-ACTIVITY -> BRD-ACTIVITY
AXX-ACCT-CATEGORY -> BRD-ACCT-CATEGORY
BRD-BURDEN-CD
BRD-POOL-NBR
Acbuddtl ACBUDDTL
AXX-ACTIVITY-GRP -> BDT-ACTIVITY-GRP
AXX-ACTIVITY -> BDT-ACTIVITY
ACV-ACTIVE-BUD -> BDT-BUDGET-NBR
AXX-ACCT-CATEGORY -> BDT-ACCT-CATEGORY
BDT-FISCAL-YEAR
Accommit ACCOMMIT
AXX-ACTIVITY-GRP -> MIT-ACTIVITY-GRP
AXX-ACTIVITY -> MIT-ACTIVITY
AXX-ACCT-CATEGORY -> MIT-ACCT-CATEGORY
MIT-FISCAL-YEAR
MIT-PERIOD
MIT-SYSTEM
MIT-COMPANY
MIT-CURRENCY-CODE
Accommitx ACCOMMITX
AXX-ACTIVITY-GRP -> MIX-ACTIVITY-GRP
AXX-ACTIVITY -> MIX-ACTIVITY
AXX-ACCT-CATEGORY -> MIX-ACCT-CATEGORY
MIX-FISCAL-YEAR
MIX-PERIOD
MIX-SYSTEM
MIX-COMPANY
MIX-CURRENCY-CODE
MIX-ATN-OBJ-ID
Acglacct ACGLACCT
AXX-ACTIVITY-GRP -> AGA-ACTIVITY-GRP
AXX-ACTIVITY -> AGA-ACTIVITY
AXX-ACCT-CATEGORY -> AGA-ACCT-CATEGORY
AGA-SEQ-NUMBER
Acmaster ACMASTER
AXX-ACTIVITY-GRP -> MST-ACTIVITY-GRP
AXX-ACTIVITY -> MST-ACTIVITY
AXX-ACCT-CATEGORY -> MST-ACCT-CATEGORY
MST-FISCAL-YEAR
Acmasterx ACMASTERX
AXX-ACTIVITY-GRP -> MSX-ACTIVITY-GRP
AXX-ACTIVITY -> MSX-ACTIVITY
AXX-ACCT-CATEGORY -> MSX-ACCT-CATEGORY
MSX-FISCAL-YEAR
MSX-PERIOD
|
