ACCATSUMX

Account Category Summ Detail

This file contains all account categories assigned to the summary account cateogries in the category structure. This file is maintained via AC08.3 (Account Category Detail).

REFERENCED BY
AC131 AC37.1 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC45.1 AC45.4 AC46.1 AC46.2 AC50.1
AC500 AC54.1 AC540 AC56.1 AC560 AC581
AC69.1 ACAC.1 ACDR.1 AP125 AP126 AP131
AP170 AP190 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP520
API1.1 API2.1 BN150 BN66.1 BR00.2 BR00.3
BR02.3 BR10.1 BR10.3 BR122 BR123 BR40.1
BR40.3 BR40.4 BR41.1 BR41.4 BR42.1 BR420
BR43.1 BR44.1 BR46.1 BR46.2 BR46.4 BR51.1
BR51.2 BR52.1 BR70.1 BR70.2 BRIP.1 CB10.1
CB15.1 CB15.2 CB150 CB180 CB191 CB20.1
CB30.1 CB45.1 CB46.1 CB500 CB543 CB544
CB55.1 CB554 CB57.1 CB80.1 CB82.1 CX05.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 EE11.1 EE135
EE20.3 EE35.1 EE35.2 EE520 GL146 GL165
GL170 GL197 GL199 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 GL76.1 PR521
DR100 IC140 IC66.1 IC83.1 EX175 EX542
EX545 EXI2.1 EXI4.1 IFEB.1 IFGT.1 IFUC.1
LP130 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.2 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 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO28.2 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 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 PO54.5 POCP.1 POD0.1 POI3.1
POID.1 POIF.1 POIG.1 POII.1 POIJ.1 POIK.1
PR128 PR130 PR131 PR132 PR134 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
ZP530 RQ10.1 RQ10.2 RQ10.4 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
WH32.5 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 ZW130
AC01.1 AC05.1 AC06.1 AC06.2 AC07.1 AC105
AC12.1 AC127 AC16.2 AC16.3 AC16.4 AC16.7
AC16.8 AC16.9 AC19.1 AC21.5 AC22.1 AC27.1
AC34.1 AC35.1 AC36.1 AC55.1 AC61.1 AC65.1
AC65.2 AC704 ACBC.1 ACDL.1 ACDM.2 ACDM.3
ACVW.1 ATVW.1 BR01.1 BR01.2 BR03.1 BR03.2
BR03.3 BR05.1 BR05.2 BR05.3 BR05.4 BR05.5
BR12.2 BR18.1 BR18.2 BR254 BR54.1 BR54.2
BR54.3 BR54.4 BR570 BR65.1 BR65.2 BR65.3
SN02.1 AC208


UPDATED BY
AC08.2 AC08.3 AC08.4 AC08.5 AC08.7 AC10.1
AC108 AC112 AC113 AC120 AC121 AC123
AC128 AC130 AC135 AC145 AC147 AC160
AC165 AC169 AC190 AC191 AC196 AC197
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC247
AC256 AC261 AC265 AC290 AC295 AC297
AC298 AC30.3 AC310 AC311 AC32.1 AC346
AC400 AC401 AC410 AC412 AC420 AC421
AC440 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC527 AC558 AC580
AC583 AC708 AC90.1 AC90.2 AC90.4 AC90.6
AC90.8 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 AC97.1 AC97.2 AC97.4
AC97.6 SE90.1 AP211 ARLL.1 BR120 BR121
BR130 BR131 BR140 BR142 BR145 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR19.2 BR190 BR20.9 BR200 BR202
BR204 BR205 BR210 BR212 BR215 BR220
BR245 BR251 BR252 BR253 BR265 BR300
BR400 BR405 BR422 BR430 BR450 BR521
BR530 BR580 GL299 MX123 MX202 MX223
MX500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRX-STRUCTURE
Element: Structure
Alpha 15
The name of the category structure.
AC08.3 AC08.4
AC08.5 AC558
SRX-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
AC08.3 AC08.5
AC08.7 AC108
AC558
SRX-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both 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. Valid account category types are: cost revenue accrual pass thru
AC08.3 AC08.5
AC558
SRX-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the detail account category. Valid values include: A - Active I - Inactive
A = Active
I = Inactive
AC08.3 AC08.5
AC558
SRX-BILLABLE-FLAG
Element: Billable
Alpha 1
This flag indicates whether an account category is billable. The default is No.
Y = Yes
N = No
AC08.3 AC08.5
AC558
SRX-CAPITAL-FLAG
Element: Capital Flag
Alpha 1
This flag indicates whether an account category is to be capitalized.
Y = Yes
N = No
AC08.3 AC08.5
AC558
SRX-REVENUE-FLAG
Element: Revenue Flag
Alpha 1
This flag identifies whether an account category is eligible for revenue recognition.
Y = Yes
N = No
AC08.3 AC08.5
AC558
SRX-TM-FLAG
Element: Tm Flag
Alpha 1
This flag indicates whether this account category represents time (labor) or materials for T&M processing.
M = Materials
T = Time
AC08.3 AC08.5
AC558
SRX-MARK-UP-PCT
Element: Mark Up Pct
Signed 5.2
This field indicates the percentage of markup for billing. If an account category is billable, a markup percentage can be established. A rate scheudled is for labor transactions only. Markup percentages will increase teh cost amount by the percentage entered.
AC08.3 AC08.5
AC558
SRX-NEW-SUM-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
AC08.7 AC108
SRX-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.
AC08.7 AC108
SRX-UPD-USR-ID
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
AC08.7 AC108
SRX-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AC08.3 AC08.4
AC08.5 AC558
AC708


ACCATSUMX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRXSET1 STRUCTURE
ACCT-CATEGORY
...
AC01.1 AC05.1
AC06.1 AC06.2
AC07.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.7
AC10.1 AC10.3
AC105 AC108
AC112 AC113
AC12.1 AC120
AC121 AC123
AC127 AC128
AC130 AC131
AC135 AC145
AC147 AC16.2
AC16.3 AC16.4
SRXSET2 STRUCTURE
SUM-ACCT-CAT
ACCT-CATEGORY
KeyChange
...
AC08.1 AC08.3
AC08.5 AC08.6
AC08.7 AC108
AC208 AC295
AC297 AC400
AC410 AC420
AC480 AC494
AC708 AC90.1
AC90.2 AC90.4
AC90.6 AC90.8
AC92.1 AC92.2
AC92.4 AC92.6
AC94.1 AC94.2
AC94.4 AC94.6
AC97.2 ACBC.1
SRXSET3 OBJ-ID
STRUCTURE
ACCT-CATEGORY
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC16.3
AC16.4 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
SRXSET4 ACCT-CATEGORY
STRUCTURE
SUM-ACCT-CAT
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC16.3
AC16.8 AC16.9
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220


ACCATSUMX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
SRX-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Accatsum ACCATSUM Required
SRX-STRUCTURE->SRS-STRUCTURE
SRX-SUM-ACCT-CAT->SRS-SUM-ACCT-CAT
Structure STRUCTURE Required
SRX-STRUCTURE->SRE-STRUCTURE


ACCATSUMX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
SRX-ACCT-CATEGORY->AXX-ACCT-CATEGORY
  AXX-ACTIVITY-GRP
  AXX-ACTIVITY
Accatmxval ACCATMXVAL
SRX-OBJ-ID->AJB-OBJ-ID
  AJB-MATRIX-CAT
Accatmxvdt ACCATMXVDT
SRX-OBJ-ID->MXB-OBJ-ID
  MXB-MATRIX-CAT
  MXB-EFFECTIVE-DATE
Mxlistmbr MXLISTMBR
"ACCAT"->MLM-OBJ-TYPE
SRX-OBJ-ID->MLM-OBJ-ID
  MLM-MATRIX-LIST
Sum Act Detail ACCATSUM
SRX-STRUCTURE->SRS-STRUCTURE
  SRS-SUM-ACCT-CAT


File created: Thu Jun 09 11:03:58 2016

Home
Contact Us



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