|
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 AC128 AC130 AC131 AC135 AC145
AC160 AC165 AC169 AC19.1 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 AC22.1 AC220
AC225 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 AC45.4
AC46.1 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC50.1 AC500 AC527
AC54.1 AC540 AC56.1 AC580 AC581 AC583
AC61.1 AC69.1 AC704 AC90.1 AC90.2 AC90.4
AC90.6 AC90.8 AC92.1 AC92.2 AC92.4 AC92.6
AC93.4 AC93.5 AC94.1 AC94.2 AC94.4 AC94.6
AC95.1 AC95.2 AC95.4 AC95.6 ACAC.1 ACDR.1
AP125 AP126 AP170 AP193 AP211 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP520 AR237
AR239 AR257 AR296 AR32.1 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 BR123
BR130 BR131 BR140 BR142 BR145 BR151
BR152 BR153 BR154 BR155 BR156 BR157
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
BR251 BR252 BR253 BR265 BR300 BR40.1
BR40.3 BR40.4 BR400 BR405 BR41.1 BR41.4
BR420 BR422 BR43.1 BR430 BR44.1 BR450
BR46.1 BR46.2 BR46.4 BR51.1 BR51.2 BR52.1
BR521 BR530 BR54.1 BR54.2 BR54.3 BR54.4
BR570 BR580 BR70.1 BR70.2 CB10.1 CB15.1
CB15.2 CB150 CB191 CB20.1 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 CB55.1 CB554
EE135 EE20.3 EE35.1 EE35.2 EE520 ET540
ET542 ET700 GL146 GL165 GL170 GL197
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 POIG.1 PW110 PW510 SB515
HAXX.1
UPDATED BY
AC06.1 AC06.2 AC105 AC110 AC120 AC300
AC310 AC560 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 AC560
AXX-ACTIVITY Alpha 15 AC06.1 AC06.2
Element: Activity Identifies the posting level activity AC105 AC110
for which override edits exist for AC120 AC560
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 Project
Accounting application. 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 AC105
account 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
AC128 AC130
AC131 AC135
AC145 AC160
AC165 AC169
AC19.1 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
...
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
|