ACACCTCAT

Activity Account Categories

This file contains information on account categories from AC05.1 (Account Categories). In addition to the account category identifier, this file includes description and the category type. Use the Error suspense tab to identify the error suspense account category identifier.

REFERENCED BY
ACVW.1 AM117 AM118 AM125 AM223 AM224
AP178 AP237 AR15.2 AR15.4 BN305 GL100
GL122 GL50.4 HAXX.1 HR11.1 HR11.2 HR511
GL00.1 GL00.3 GL02.1 GL02.2 GL02.3 GL124
GL13.1 GL14.2 GL160 GL20.2 GL60.1 MX123
MX202 MX223 MX500 LP03.1 LP03.2 LP03.3
LP03.4 LP03.5 LP03.6 LP100 LP101 LP102
LP103 LP131 LP180 LP197 LP31.1 LP80.1
PA02.1 PA100 PA102 PA115 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
HS34.1 HS36.1 PR04.1 PR05.1 PR05.7 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR20.4 PR30.1 PR55.1 SN02.1 SNAC.1


UPDATED BY
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
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
GL93.2 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 PR134 AM190 AP190 BN150 BN66.1
CB180 CB80.1 CB82.1 GL199 PR521 EXI2.1
EXI4.1 IFGT.1 IFUC.1 LP130 LP140 PA182
POIF.1 PR128 PR130 PR131 PR132 PR135
PR136 PR137 PR140 PR189 PR195 PR197
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR37.1 PR38.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 PR85.1 PR89.1 UK102 UK330 UK560
TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAX-ACCT-CATEGORY
Element: Account Category
Alpha 5
Required. Account categories are groupings of costs, revenues, or accruals used for reporting and inquiries for activities in Project Accounting. 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.
AAX-DESCRIPTION
Account Category
Description
Alpha 30 (Lower Case)
This is the account category description.
AAX-CATEGORY-TYPE
Element: Category Type
Alpha 1
Required. This field defines the account category type: revenue, cost, accrual, or pass thru.
R = Revenue
A = Accrual
C = Cost
P = Pass Thru
AAX-TIME-EXP-FLAG
Element: Time Expense Flag
Alpha 1

T = Time
E = Expense
B = Both
AAX-ES-ACCT-CAT-FL
Error Suspense Acct
Category
Alpha 1
This is the error suspense account category flag. "Yes" identifies one account category as the error suspense account category.
Y = Yes
N = No


ACACCTCAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAXSET1 ACCT-CATEGORY
...
AC10.1 AC10.3
AC200 AC210
ACAC.1 ACVW.1
AM117 AM118
AM125 AM223
AM224 AP125
AP126 AP131
AP170 AP178
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP211 AP23.1
AP237 AP25.1
AP25.2 AP26.1
AAXSET2 ACCT-CATEGORY
Subset
Where(ES-ACCT-CAT-FL ="Y")
...
AC10.1 AC10.3
AC200 AC210
ACAC.1 AM190
AP125 AP126
AP131 AP170
AP190 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
AAXSET4 CATEGORY-TYPE
ACCT-CATEGORY
KeyChange


ACACCTCAT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
AAX-ACCT-CATEGORY->AXX-ACCT-CATEGORY (AXXSET4)
  AXX-ACTIVITY-GRP
  AXX-ACTIVITY


File created: Wed Jun 08 20:46:51 2016

Home
Contact Us



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