|
|
ACCATSUMX FILE
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
AC05.1 AC06.1 AC06.2 AC07.1 AC10.1 AC10.3
AC105 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 AC206 AC207 AC210
AC213 AC218 AC220 AC240 AC246 AC261
AC265 AC27.1 AC290 AC295 AC298 AC30.1
AC30.2 AC30.3 AC30.4 AC32.1 AC346 AC37.1
AC40.1 AC40.4 AC400 AC401 AC41.1 AC41.4
AC410 AC412 AC42.1 AC420 AC421 AC440
AC45.1 AC46.1 AC46.2 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC500 AC54.1 AC540 AC580 AC581 AC583
AC60.1 AC61.1 AC65.1 AC65.2 AC90.1 AC90.2
AC90.4 AC90.6 AC90.8 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.2 AC95.4 AC95.6
ACAC.1 ACBC.1 ACDL.1 ACDM.3 ACDR.1 ACVW.1
SE90.1 AP125 AP126 AP131 AP170 AP193
AP211 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP520 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 BR00.1 BR00.2 BR00.3 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 BR120
BR121 BR122 BR130 BR131 BR140 BR142
BR145 BR165 BR18.1 BR18.2 BR19.1 BR190
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.6
BR200 BR202 BR204 BR205 BR210 BR212
BR215 BR220 BR245 BR265 BR300 BR40.1
BR40.3 BR40.4 BR400 BR405 BR41.1 BR41.4
BR42.1 BR42.2 BR420 BR43.1 BR430 BR44.1
BR450 BR46.1 BR46.2 BR46.4 BR521 BR530
BR580 BR65.1 BR65.2 BRCC.1 BRIP.1 CB10.1
CB15.1 CB15.2 CB180 CB191 CB20.1 CB30.1
CB500 CB80.1 CXCP.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 DR100 IC140 IC28.1 IC531
IC83.1 IFGT.1 MA180 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA65.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
POII.1 POIJ.1 PR128 PR130 PR131 PR132
PR134 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 AC208
UPDATED BY
AC08.3 AC08.4 AC08.5 AC08.7 AC08.2 AC108
AC558
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRX-STRUCTURE Alpha 15 AC08.3 AC08.4
Element: Structure The name of the category structure. AC08.5 AC558
SRX-SUM-ACCT-CAT Alpha 5 AC08.3 AC08.5
Element: Sum Acct Cat The name of the summary account AC08.7 AC108
category. AC558
SRX-ACCT-CATEGORY Alpha 5 AC08.3 AC08.5
Element: Account CategoAccount categories are groupings of AC558
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
SRX-ACTIVE-STATUS Alpha 1 AC08.3 AC08.5
Element: Status The status of the detail account AC558
category. Valid values include:
A - Active
I - Inactive
A = Active
I = Inactive
SRX-BILLABLE-FLAG Alpha 1 AC08.3 AC08.5
Element: Billable IndicThis flag indicates whether an account AC558
category is billable. The default is
No.
Y = Yes
N = No
SRX-CAPITAL-FLAG Alpha 1 AC08.3 AC08.5
Element: Capital Flag This flag indicates whether an account AC558
category is to be capitalized.
Y = Yes
N = No
SRX-REVENUE-FLAG Alpha 1 AC08.3 AC08.5
Element: Revenue Flag This flag identifies whether an account AC558
category is eligible for revenue
recognition.
Y = Yes
N = No
SRX-TM-FLAG Alpha 1 AC08.3 AC08.5
Element: Tm Flag This flag indicates whether this account AC558
category represents time (labor) or
materials for T&M processing.
M = Materials
T = Time
SRX-MARK-UP-PCT Signed 5.2 AC08.3 AC08.5
Element: Markup percentThis field indicates the percentage of AC558
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.
SRX-NEW-SUM-CAT Alpha 5 AC08.7 AC108
Element: Sum Acct Cat
SRX-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC08.7 AC108
Element: Effective DateThe date a vendor's prices will be in
effect.
SRX-UPD-USR-ID Alpha 10 AC08.7 AC108
Element: Operator Code
ACCATSUMX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRXSET1 STRUCTURE AC05.1 AC06.1
ACCT-CATEGORY 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
AC130 AC131
AC135 AC145
AC160 AC165
AC190 AC191
AC197 AC198
...
SRXSET2 STRUCTURE KeyChange AC08.1 AC08.3
SUM-ACCT-CAT AC08.6 AC08.7
ACCT-CATEGORY AC108 AC208
ACBC.1 BR18.2
ACCATSUMX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
SRX-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
AXX-ACTIVITY-GRP
AXX-ACTIVITY
Sum Act Detail ACCATSUM
SRX-STRUCTURE -> SRS-STRUCTURE
SRS-SUM-ACCT-CAT
|
