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
AC200 AC210 ACAC.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 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 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 EX175 EX542
EX545 IFEB.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POIG.1 POII.1 POIJ.1


UPDATED BY
AC10.1 HAXX.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.
AXX-ACTIVITY
Element: Activity
Alpha 15
Identifies the posting level activity for which override edits exist for account category detail.
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.
AXX-BILLABLE-FLAG
Element: Billable Flag
Alpha 1
This flag indicates whether an account category is billable.
Y = Billable
N = Non-billable
AXX-CAPITAL-FLAG
Element: Capitalization Flag
Alpha 1
This flag indicates whether an account category is to be capitalized.
Y = Yes
N = No
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.
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
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
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).
AXX-ACTIVE-STATUS
Element: Active Status
Alpha 1
The account category status. 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
ACTIVITY
ACCT-CATEGORY
...
AC10.1 AC10.3
AC200 AC210
ACAC.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
CB10.1 CB15.1
AXXSET2 ACTIVITY-GRP
ACCT-CATEGORY
ACTIVITY
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: Wed Jun 08 20:46:51 2016

Home
Contact Us



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