|
ACCTRCATGX FILE
REFERENCED BY
AC112 AC113 AC12.1 AC120 AC121 AC123
AC135 AC145 AC160 AC165 AC190 AC191
AC197 AC198 AC200 AC203 AC206 AC207
AC210 AC213 AC218 AC220 AC240 AC246
AC261 AC265 AC290 AC295 AC298 AC346
AC40.1 AC40.4 AC400 AC401 AC41.1 AC41.4
AC410 AC412 AC42.1 AC420 AC421 AC440
AC45.1 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC50.1 AC500 AC54.1
AC540 ACAC.1 AP211 BR00.1 BR00.2 BR02.3
BR120 BR121 BR122 BR130 BR131 BR140
BR142 BR145 BR165 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.3 BR40.4
BR400 BR405 BR420 BR430 BR450 BR46.1
BR46.2 BR46.4 BR521 BR530 BR580 BR218
UPDATED BY
AC300 AC310 BR18.1 BR18.2 BR18.3 AC10.1
BR10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCX-CONTRACT Alpha 10 BR18.1 BR18.2
Element: Contract Activity Management contract. BR18.3
BCX-CTR-CAT-GRP Alpha 5 BR120 BR121
Element: Ctr Cat Grp BR122 BR18.1
BR18.2 BR18.3
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
BCX-ACCT-CATEGORY Alpha 5 BR18.1 BR18.2
Element: Account CategoAccount 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
ACCTRCATGX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCXSET1 CONTRACT AC10.1 AC112
ACCT-CATEGORY AC113 AC12.1
AC120 AC121
AC123 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC246 AC261
AC265 AC290
AC295 AC298
...
BCXSET2 CTR-CAT-GRP KeyChange
ACCT-CATEGORY
CONTRACT
BCXSET3 CONTRACT KeyChange BR120 BR121
CTR-CAT-GRP BR122 BR18.1
ACCT-CATEGORY BR18.3 BR19.1
BR190 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR218 BR420
BR521
ACCTRCATGX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
BCX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Accntract ACCNTRACT Required
BCX-CONTRACT -> CNT-CONTRACT
Acctrcatg ACCTRCATG Required
BCX-CTR-CAT-GRP -> BCG-CTR-CAT-GRP
BCX-CONTRACT -> BCG-CONTRACT
|