ACACCTCAT FILE
Activity Account Categories
This file contains information on account categories from AC05.1 (Account
Categories). In addition to the account category identifier and description,
this file includes the category type and status of the account category, as
well as an error suspense account category flag.
REFERENCED BY
AC06.1 AC07.1 AC08.1 AC10.1 AC10.3 AC105
AC110 AC120 AC121 AC123 AC127 AC130
AC135 AC160 AC165 AC170 AC176 AC190
AC191 AC192 AC196 AC198 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.7 AC205 AC206
AC207 AC208 AC21.1 AC21.2 AC21.3 AC21.4
AC210 AC213 AC220 AC227 AC240 AC256
AC258 AC261 AC265 AC27.1 AC290 AC295
AC297 AC298 AC30.1 AC30.3 AC30.4 AC310
AC32.1 AC34.1 AC35.1 AC36.1 AC40.1 AC40.4
AC400 AC401 AC41.1 AC41.4 AC410 AC42.1
AC42.3 AC420 AC421 AC440 AC45.1 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC50.1 AC500 AC530 AC54.1 AC54.3
AC540 AC541 AC542 AC55.1 AC550 AC58.1
AC60.1 AC60.2 AC61.1 AC62.1 AC65.1 AC65.2
AC66.1 AC70.1 AC70.4 AC70.6 AC90.1 AC90.2
AC90.4 AC90.6 AC90.8 AC91.1 AC91.2 AC92.1
AC92.2 AC92.4 AC92.6 AC93.2 AC93.3 AC93.4
AC93.5 AC94.1 AC94.2 AC94.4 AC94.6 AC95.1
AC95.2 AC95.4 AC95.6 AC96.1 AC97.1 AC97.2
AC97.4 AC97.6 AC98.1 ACAC.1 ACBC.1 ACDL.1
ACDR.1 ACEX.1 ACVW.1 DA233 DA240 GR240
SE90.1 AM115 AM118 AM125 AM223 AM224
AM277 AM85.1 AR15.2 BR00.2 BR00.3 BR01.1
BR01.2 BR01.3 BR03.1 BR03.2 BR03.3 BR05.1
BR05.2 BR05.3 BR05.4 BR05.5 BR10.1 BR10.3
BR12.1 BR120 BR130 BR131 BR142 BR20.6
BR200 BR202 BR204 BR205 BR21.1 BR220
BR265 BR40.1 BR40.3 BR40.4 BR400 BR405
BR41.1 BR42.1 BR430 BR450 BR65.1 BR65.2
BRCC.1 BRIP.1 GL100 GL122 HAXX.1 HR11.1
HR11.2 HR511 HR650 GL00.1 GL00.3 GL02.1
GL02.2 GL02.3 GL124 GL13.1 GL14.2 GL160
GL20.2 GL60.1 PA02.1 PA100 PA102 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 POII.1 HS34.1 HS36.1 PR04.1 PR05.1
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR134 PR20.4 PR30.1 PR55.1 AP125
AP126 AP131 AP170 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP32.2
AP520 API1.1 API2.1 AR115 AR124 AR190
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7
AR43.1 AR560 AR570 AR575 AR580 BN150
BN66.1 CB10.1 CB180 CB191 CB20.1 CB30.1
CB500 CB80.1 EE135 EE35.1 EE35.2 EE520
GL199 HCOP.2 IC28.1 IFGT.1 MA180 MA41.2
MA43.2 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.3 MA67.1 MA67.2 MA70.1
MAI1.1 PO100 PO101 PO122 PO131 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 POIE.1 POIF.1 POIJ.1 PR128 PR130
PR131 PR132 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 PR36.1 PR37.1 PR38.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
PR85.1 PR89.1 PRSA.1 UK102 UK330 RQ10.1
RQ10.2 TA147 UK120 WH20.2 WH20.7
UPDATED BY
AC05.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAX-ACCT-CATEGORY Alpha 5 AC05.1
Account Category Required. Account categories are
groupings of costs, revenues, or
accruals used for reporting and
inquiries for activities in the Activity
Management system. 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 Alpha 30 (Lower Case) AC05.1 AC198
Account Category This is the account category
Description description.
AAX-CATEGORY-TYPE Alpha 1 AC05.1
Category Type Required. This field defines the
account category type: revenue, cost, or
accrual.
R = Revenue
A = Accrual
C = Cost
P = Pass Thru
F = Fee
AAX-TIME-EXP-FLAG Alpha 1
Time Exp Flag T = Time
E = Expense
B = Both
AAX-ACTIVE-FLAG Alpha 1 AC05.1
Active Flag Required. This field tells whether an
account category is active or inactive.
Only active account categories can be
assigned to activities in AC06.1
(Account Category Assignment).
The default is Active.
A = Active
I = Inactive
AAX-ES-ACCT-CAT-FL Alpha 1 AC05.1
Error Suspense Acct This is the error suspense account
Category 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 AC05.1 AC06.1
AC07.1 AC08.1
AC10.1 AC10.3
AC105 AC110
AC120 AC121
AC123 AC127
AC130 AC135
AC160 AC165
AC170 AC176
AC190 AC191
AC192 AC196
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.7 AC205
...
AAXSET2 ACCT-CATEGORY Subset AC05.1 AC06.1
Where (ES-ACCT-CAT-FL = "Y" ) AC190 AC191
AC196 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC541 AC542
ACAC.1 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
...
AAXSET4 CATEGORY-TYPE AC05.1 AC160
ACCT-CATEGORY AC401 AC480
BR130
ACACCTCAT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
AAX-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
AXX-ACTIVITY-GRP
AXX-ACTIVITY
|
