|
ACACCTCAT FILE
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
AC01.1 AC06.1 AC06.2 AC07.1 AC08.1 AC08.3
AC08.5 AC08.7 AC10.1 AC10.3 AC105 AC108
AC112 AC113 AC120 AC121 AC123 AC127
AC128 AC130 AC135 AC145 AC16.2 AC16.3
AC16.4 AC16.7 AC16.8 AC16.9 AC160 AC165
AC169 AC19.1 AC190 AC191 AC197 AC198
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6
AC20.7 AC200 AC203 AC205 AC206 AC207
AC208 AC21.1 AC21.2 AC21.3 AC21.4 AC210
AC213 AC218 AC22.1 AC220 AC225 AC227
AC240 AC246 AC256 AC261 AC265 AC27.1
AC29.2 AC290 AC292 AC295 AC298 AC30.1
AC30.2 AC30.3 AC30.4 AC310 AC32.1 AC34.1
AC346 AC35.1 AC36.1 AC37.1 AC40.1 AC40.4
AC400 AC401 AC41.1 AC41.4 AC410 AC412
AC42.1 AC42.3 AC420 AC421 AC440 AC45.1
AC45.4 AC46.1 AC46.2 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC500 AC527 AC54.1 AC540 AC55.1 AC56.1
AC560 AC58.1 AC58.2 AC580 AC583 AC60.1
AC60.2 AC61.1 AC62.1 AC65.1 AC65.2 AC69.1
AC71.1 AC90.1 AC90.2 AC90.4 AC90.6 AC90.8
AC91.1 AC91.2 AC92.1 AC92.2 AC92.4 AC92.6
AC93.1 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 AC96.4 AC98.1 ACAC.1 ACBC.1
ACDL.1 ACDM.2 ACDR.1 ACEX.1 ACVW.1 ATVW.1
SE90.1 AM117 AM118 AM125 AM223 AM224
AP125 AP126 AP170 AP178 AP193 AP211
AP237 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP520 AR15.2 AR15.4 AR21.2 AR21.1
AR21.3 AR237 AR239 AR250 AR257 AR27.2
AR29.1 AR29.2 AR296 AR30.5 AR30.1 AR32.1
AR33.2 AR38.5 AR39.3 AR39.4 AR42.1 AR42.2
AR42.7 AR43.1 AR502 AR503 AR55.1 AR560
AR575 AR800 AR91.1 ARLL.1 BN305 BR00.2
BR00.3 BR00.1 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 BR12.1 BR12.2 BR120
BR121 BR122 BR123 BR124 BR130 BR131
BR140 BR142 BR145 BR15.1 BR15.2 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR18.1 BR18.2 BR19.2 BR19.1 BR190
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.9
BR20.6 BR200 BR202 BR204 BR205 BR210
BR212 BR215 BR218 BR220 BR245 BR251
BR252 BR253 BR254 BR265 BR300 BR40.1
BR40.3 BR40.4 BR400 BR405 BR41.1 BR41.4
BR42.2 BR420 BR422 BR43.1 BR430 BR44.1
BR450 BR46.3 BR46.1 BR46.2 BR46.4 BR47.1
BR47.2 BR50.2 BR51.1 BR51.2 BR52.1 BR521
BR530 BR54.1 BR54.2 BR54.3 BR54.4 BR570
BR58.1 BR580 BR65.1 BR65.2 BR65.3 BR70.1
BR70.2 BR96.1 BRIP.1 CB10.1 CB15.1 CB15.2
CB150 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 EE135
EE20.3 EE35.1 EE35.2 EE520 ET540 ET700
GL100 GL122 GL146 GL165 GL170 GL197
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL50.4 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 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 LP100 LP101 LP180
LP197 LP31.1 LP80.1 MA65.1 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 POIG.1 POII.1
HS34.1 HS36.1 PR04.1 PR05.1 PR05.7 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR134 PR20.4 PR30.1 PR55.1 PW110 PW510
SB15.1 SB515 SN02.1 SNAC.1 AC12.1 AC131
AC581 AC704 AM190 AP131 AP190 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 API1.1 API2.1 AR115 AR124 AR190
AR20.1 AR24.1 AR34.1 AR570 AR580 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BN150
BN66.1 CB180 CB80.1 CB82.1 CXCP.1 ET175
ET530 ET542 ETI2.1 GL199 IFGT.1 LP130
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PA182 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO135 PO150 PO190 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 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 POCP.1 POD0.1
POI3.1 POID.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 PR35.9 PR36.1 PR37.1
PR38.1 PR45.1 PR529 PR530 PR560 PR80.1
PR82.1 PR85.1 PR89.1 UK102 UK330 UK560
RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQD0.1 RQIF.1 TA147 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 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
UPDATED BY
AC05.1 AC558
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAX-ACCT-CATEGORY Alpha 5 AC05.1 AC558
Element: Account CategoRequired. 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 Alpha 30 (Lower Case) AC05.1 AC197
Account Category This is the account category AC198 AC558
Description description.
AAX-CATEGORY-TYPE Alpha 1 AC05.1 AC558
Element: Category Type 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 Alpha 1
Element: Time Expense FT = Time
E = Expense
B = Both
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 AC01.1 AC05.1
AC05.2 AC05.3
AC06.1 AC06.2
AC07.1 AC08.1
AC08.3 AC08.5
AC08.7 AC10.1
AC10.3 AC105
AC108 AC112
AC113 AC120
AC121 AC123
AC127 AC128
AC130 AC135
AC145 AC16.2
AC16.3 AC16.4
AC16.7 AC16.8
...
AAXSET2 ACCT-CATEGORY Subset AC05.1 AC10.1
Where (ES-ACCT-CAT-FL = "Y" ) AC10.3 AC108
AC112 AC113
AC12.1 AC120
AC121 AC123
AC127 AC128
AC130 AC131
AC135 AC145
AC160 AC165
AC169 AC19.1
AC190 AC191
AC197 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
...
AAXSET4 CATEGORY-TYPE KeyChange AC05.1 AC05.3
ACCT-CATEGORY AC401 AC480
AC95.1 AC95.2
AC95.4 AC95.6
BR130 BR530
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
|