ACACCTCATX

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
AC112 AC113 AC121 AC123 AC128 AC130
AC131 AC135 AC145 AC147 AC160 AC165
AC169 AC190 AC191 AC196 AC197 AC198
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6
AC20.7 AC200 AC203 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC247
AC261 AC265 AC290 AC295 AC297 AC298
AC30.4 AC310 AC311 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
AC69.1 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
AP131 AP170 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP211 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP520 API1.1 API2.1 BR00.2 BR00.3 BR02.3
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 BR44.1 BR450 BR46.1
BR46.2 BR46.4 BR51.1 BR51.2 BR52.1 BR521
BR530 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
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 EE11.1 EE135
EE20.3 EE35.1 EE35.2 EE520 GL146 GL165
GL170 GL197 GL299 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 GL76.1 DR100
IC140 IC66.1 IC83.1 EX175 EX542 EX545
IFEB.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.2 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 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO26.2 PO26.3
PO26.4 PO26.5 PO26.6 PO26.7 PO26.9 PO27.2
PO28.2 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 POIG.1 POII.1
POIJ.1 POIK.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.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 ZW130 AC12.1
AC127 AC19.1 AC21.5 AC22.1 AC61.1 AC704
BR01.1 BR01.2 BR03.1 BR03.2 BR03.3 BR05.1
BR05.2 BR05.3 BR05.4 BR05.5 BR54.1 BR54.2
BR54.3 BR54.4 BR570 HAXX.1


UPDATED BY
AC06.1 AC06.2 AC10.1 AC105 AC108 AC110
AC120 AC206 AC300 AC560 BR430

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AXX-ACTIVITY-GRP
Element: Activity Group
Alpha 15
Required. This is the activity group for the account category.
AC06.1 AC06.2
AC105 AC110
AC120 AC560
AXX-ACTIVITY
Element: Activity
Alpha 15
Identifies the posting level activity for which override edits exist for account category detail.
AC06.1 AC06.2
AC105 AC110
AC120 AC560
AXX-ACCT-CATEGORY
Element: Account Category
Alpha 5
Account categories are groupings of 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.
AC06.1 AC06.2
AC105
AXX-BILLABLE-FLAG
Element: Billable Flag
Alpha 1
This flag indicates whether an account category is billable.
Y = Billable
N = Non-billable
AC06.1 AC06.2
AC105
AXX-CAPITAL-FLAG
Element: Capitalization Flag
Alpha 1
This flag indicates whether an account category is to be capitalized.
Y = Yes
N = No
AC06.1 AC06.2
AC105
AXX-MARK-UP-PCT
Element: Mark-up Percent
Signed 5.2
This field indicates the percentage of 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.
AC06.1 AC06.2
AC105
AXX-REVENUE-FLAG
Element: Revenue Flag
Alpha 1
This flag identifies whether an activity/account category is eligible for revenue recognition.
Y = Yes
N = No
AC06.1 AC06.2
AC105
AXX-TM-FLAG
Element: Tm Flag
Alpha 1
This flag indicates whether this account category represents time (labor) or materials for T&M processing.
M = Materials
T = Time
AC06.1 AC06.2
AC105
AXX-SUM-ACCT-CAT
Summary Account
Category
Alpha 5
Identifies the summary account category the detail account category is assigned to in the category structure (lowest summary level account category in the structure).
AC06.1 AC06.2
AC105 AC108
AXX-ACTIVE-STATUS
Element: Active Status
Alpha 1
The account category status. Valid values are "A" Active and "I" Inactive.
A = Active
I = Inactive
AC06.1 AC06.2
AC105


ACACCTCATX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AXXSET1 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
...
AC06.1 AC06.2
AC10.1 AC10.3
AC105 AC108
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC127
AC128 AC130
AC131 AC135
AC145 AC147
AC160 AC165
AC169 AC19.1
AC190 AC191
AC196 AC197
AC198 AC20.1
AXXSET2 ACTIVITY-GRP
ACCT-CATEGORY
ACTIVITY
AC108
AXXSET4 ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
AXXSET6 ACTIVITY
ACTIVITY-GRP
ACCT-CATEGORY
AC10.1 HAXX.1


ACACCTCATX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:03:35 2016

Home
Contact Us



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