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 AC12.1 AC121 AC123 AC127
AC128 AC130 AC131 AC135 AC145 AC147
AC160 AC165 AC169 AC19.1 AC190 AC191
AC196 AC197 AC198 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC200 AC203
AC206 AC207 AC21.5 AC210 AC213 AC218
AC22.1 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
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 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 AP510 AP520 API1.1 API2.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 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 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 EX175 EX542 EX545 IFEB.1 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 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 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.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 HAXX.1


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

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
AC105 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 02:02:29 2016

Home
Contact Us



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