|
|
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 AC113 AC120 AC121 AC123 AC127
AC130 AC131 AC135 AC160 AC165 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.2 AC30.3
AC30.4 AC310 AC32.1 AC34.1 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 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC50.1 AC500
AC530 AC54.1 AC54.3 AC540 AC542 AC55.1
AC550 AC58.1 AC60.1 AC60.2 AC61.1 AC62.1
AC65.1 AC65.2 AC66.1 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 SE90.1 AM115 AM118 AM125
AM223 AM224 AM277 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 BR124 BR130 BR131
BR142 BR153 BR154 BR155 BR157 BR20.6
BR200 BR202 BR204 BR205 BR21.1 BR220
BR251 BR252 BR253 BR254 BR265 BR40.1
BR40.3 BR40.4 BR400 BR405 BR41.1 BR41.4
BR42.1 BR43.1 BR430 BR450 BR47.1 BR47.2
BR50.2 BR51.1 BR51.2 BR52.1 BR521 BR530
BR54.1 BR54.2 BR54.3 BR54.4 BR58.1 BR65.1
BR65.2 BRCC.1 BRIP.1 BRPI.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 PR05.7 PR110 PR113 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR134 PR20.4
PR30.1 PR55.1 AC541 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
CXCP.1 EE135 EE35.1 EE35.2 EE520 GL199
HCOP.2 DR100 IC140 IC28.1 IC531 IC83.1
IFGT.1 MA180 MA41.2 MA41.7 MA43.1 MA43.2
MA43.3 MA43.9 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 PO100 PO101
PO122 PO131 PO135 PO150 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.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 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 PR36.1 PR37.1 PR38.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 PR85.1 PR89.1
PRSA.1 UK102 UK330 UK560 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ140 RQ300
RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2
RQ500 RQD0.1 RQIE.1 RQIF.1 TA147 UK120
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAX-ACCT-CATEGORY Alpha 5 AC05.1
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 AC198
Account Category This is the account category
Description description.
AAX-CATEGORY-TYPE Alpha 1 AC05.1
Element: 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
Element: Time Exp Flag T = Time
E = Expense
B = Both
AAX-ACTIVE-FLAG Alpha 1 AC05.1
Element: 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
AC113 AC120
AC121 AC123
AC127 AC130
AC131 AC135
AC160 AC165
AC176 AC190
AC191 AC192
AC196 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
...
AAXSET2 ACCT-CATEGORY Subset AC05.1 AC06.1
Where (ES-ACCT-CAT-FL = "Y" ) AC131 AC190
AC191 AC196
AC198 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.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
...
AAXSET4 CATEGORY-TYPE AC05.1 AC160
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
|
