|
|
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
AC06.1 AC06.2 AC07.1 AC08.1 AC08.3 AC08.5
AC08.7 AC10.1 AC10.3 AC105 AC108 AC113
AC120 AC121 AC123 AC127 AC130 AC135
AC145 AC160 AC165 AC190 AC191 AC197
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC20.6 AC20.7 AC205 AC206 AC208 AC21.1
AC21.2 AC21.3 AC21.4 AC210 AC213 AC22.1
AC220 AC227 AC240 AC246 AC256 AC261
AC265 AC27.1 AC290 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 AC42.1
AC42.3 AC420 AC421 AC440 AC45.1 AC46.1
AC46.2 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC50.1 AC500 AC540
AC55.1 AC58.1 AC58.2 AC583 AC60.1 AC60.2
AC61.1 AC62.1 AC65.1 AC65.2 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 AC96.4 AC98.1
ACAC.1 ACBC.1 ACDL.1 ACDR.1 ACEX.1 ACVW.1
SE90.1 AM117 AM118 AM125 AM223 AM224
AM277 AP125 AP126 AP237 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP520 AR15.2
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 BR120
BR121 BR122 BR130 BR131 BR140 BR142
BR145 BR15.1 BR15.2 BR18.1 BR18.2 BR19.2
BR19.1 BR190 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.9 BR20.6 BR202 BR204 BR205
BR215 BR218 BR220 BR245 BR265 BR300
BR40.1 BR40.3 BR40.4 BR400 BR405 BR41.1
BR41.4 BR42.2 BR420 BR43.1 BR430 BR44.1
BR450 BR46.3 BR46.1 BR46.2 BR46.4 BR521
BR530 BR580 BR65.1 BR65.2 BR96.1 BRCC.1
CB10.1 CB15.1 CB15.2 CB191 CB20.1 CB30.1
CB500 EE135 EE20.3 EE35.1 EE35.2 EE520
GL100 GL122 GL146 GL165 GL170 GL197
GL199 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
MA65.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 PR05.7
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR134 PR20.4 PR30.1 PR55.1 AC112
AC12.1 AC131 AC200 AC203 AC207 AC218
AC412 AC54.1 AC580 AC581 AM190 AP131
AP170 AP193 AP211 API1.1 API2.1 AR115
AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3
AR24.1 AR29.2 AR30.1 AR34.1 AR42.1 AR42.2
AR42.7 AR43.1 AR560 AR570 AR575 AR580
ARLL.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 BN150 BR165 BR200 BR210 BR212
BRIP.1 CB180 CB80.1 CXCP.1 DR100 IC140
IC28.1 IC531 IC83.1 IFGT.1 MA180 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PA182 PO100 PO101
PO122 PO131 PO150 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.1 PO25.6
PO25.7 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 PO536 POCP.1 POI3.1 POID.1 POIE.1
POIF.1 POIJ.1 PR128 PR130 PR131 PR132
PR136 PR137 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
PR82.1 PR85.1 PRSA.1 UK102 UK330 RQ10.1
RQ10.2 RQ12.1 RQ13.1 RQ13.2 RQ140 RQ300
RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2
RQ500 RQIF.1 TA147 TP135 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH25.1 WH25.2
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 WO132 WO140
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 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 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 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
AC113 AC120
AC121 AC123
AC127 AC130
AC135 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC20.1 AC20.2
...
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 AC130
AC131 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC200 AC203
...
AAXSET4 CATEGORY-TYPE KeyChange AC05.1 AC05.3
ACCT-CATEGORY AC160 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
|
