|
|
ACACCTCATX FILE
Account Category Detail
This file includes detailed override information on account categories from
AC06.1 (Override Account Categories). This form (AC06) and file are only
utilized if the parameters assigned to the category structure need to be
overridden. The records can only be added for posting level activities. This
file allows override on account category status (to inactivate), Billing,
Revenue, T&M, Captialization, and markup percentages.
REFERENCED BY
AC108 AC112 AC113 AC12.1 AC121 AC123
AC127 AC130 AC131 AC135 AC145 AC160
AC165 AC190 AC191 AC197 AC198 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC240 AC246 AC261 AC265
AC290 AC295 AC298 AC30.4 AC346 AC40.1
AC40.4 AC400 AC401 AC41.1 AC41.4 AC410
AC412 AC42.1 AC420 AC421 AC440 AC45.1
AC46.1 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC50.1 AC500 AC54.1
AC540 AC580 AC581 AC583 AC60.1 AC61.1
ACAC.1 ACDR.1 AP125 AP126 AP211 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP520 BR00.1
BR00.2 BR00.3 BR01.1 BR01.2 BR02.3 BR03.1
BR03.2 BR03.3 BR05.1 BR05.2 BR05.3 BR05.4
BR05.5 BR10.1 BR10.3 BR120 BR121 BR122
BR130 BR131 BR140 BR142 BR145 BR165
BR19.1 BR190 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.6 BR200 BR202 BR204 BR205
BR210 BR212 BR215 BR220 BR245 BR265
BR300 BR40.1 BR40.3 BR40.4 BR400 BR405
BR41.1 BR41.4 BR42.2 BR420 BR43.1 BR430
BR44.1 BR450 BR46.1 BR46.2 BR46.4 BR521
BR530 BR580 CB10.1 CB15.1 CB15.2 CB191
CB20.1 CB30.1 CB500 EE135 EE20.3 EE35.1
EE35.2 EE520 GL146 GL165 GL170 GL197
GL199 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 MA65.1 HAXX.1
UPDATED BY
AC06.1 AC06.2 AC105 AC110 AC120 AC300
AC310 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AXX-ACTIVITY-GRP Alpha 15 AC06.1 AC06.2
Element: Activity GroupRequired. This is the activity group AC105 AC110
for the account category. AC120
AXX-ACTIVITY Alpha 15 AC06.1 AC06.2
Element: Activity Identifies the posting level activity AC105 AC110
for which override edits exist for AC120
account category detail.
AXX-ACCT-CATEGORY Alpha 5 AC06.1 AC06.2
Element: Account CategoAccount categories are groupings of AC105
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-BILLABLE-FLAG Alpha 1 AC06.1 AC06.2
Element: Billable Flag This flag indicates whether an account AC105
category is billable.
Y = Billable
N = Non-billable
AXX-CAPITAL-FLAG Alpha 1 AC06.1 AC06.2
Element: CapitalizationThis flag indicates whether an account AC105
category is to be capitalized.
Y = Yes
N = No
AXX-MARK-UP-PCT Signed 5.2 AC06.1 AC06.2
Element: Mark-up PercenThis field indicates the percentage of AC105
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-REVENUE-FLAG Alpha 1 AC06.1 AC06.2
Element: Revenue Flag This flag identifies whether an AC105
activity/account category is eligible
for revenue recognition.
Y = Yes
N = No
AXX-TM-FLAG Alpha 1 AC06.1 AC06.2
Element: Tm Flag This flag indicates whether this account AC105
category represents time (labor) or
materials for T&M processing.
M = Materials
T = Time
AXX-SUM-ACCT-CAT Alpha 5 AC06.1 AC06.2
Summary Account Identifies the summary account category AC105
Category the detail account category is assigned
to in the category structure (lowest
summary level account category in the
structure).
AXX-ACTIVE-STATUS Alpha 1 AC06.1 AC06.2
Element: Active Status The account category status. AC105
Valid values are "A" Active and "I"
Inactive.
A = Active
I = Inactive
ACACCTCATX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AXXSET1 ACTIVITY-GRP AC06.1 AC06.2
ACTIVITY AC10.1 AC10.3
ACCT-CATEGORY AC105 AC108
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC127
AC130 AC131
AC135 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
...
AXXSET2 ACTIVITY-GRP AC310
ACCT-CATEGORY
ACTIVITY
AXXSET4 ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
AXXSET6 ACTIVITY AC10.1 HAXX.1
ACTIVITY-GRP
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
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
Accatsum ACCATSUM Required
ACV-STRUCTURE -> SRS-STRUCTURE
AXX-SUM-ACCT-CAT -> SRS-SUM-ACCT-CAT
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
Actrans Commit ACTRANS
AXX-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
AXX-ACTIVITY -> ATN-ACTIVITY
AXX-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
ATN-POSTING-DATE
ATN-OBJ-ID
Actrans Posted ACTRANS
AXX-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
AXX-ACTIVITY -> ATN-ACTIVITY
AXX-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
ATN-POSTING-DATE
ATN-OBJ-ID
Actrans Releas ACTRANS
AXX-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
AXX-ACTIVITY -> ATN-ACTIVITY
AXX-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
ATN-POSTING-DATE
ATN-OBJ-ID
|
