|
ACBRDNDTL FILE
REFERENCED BY
AC190 AC197 AC261 BR04.1 AC60.1 AC62.1
UPDATED BY
AC105 AC110 AC120 AC300 AC310 AC61.1
AC00.1 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRD-ACTIVITY-GRP Alpha 15 AC105 AC110
Element: Activity Grp The activity group is the overall AC120 AC61.1
project.
BRD-ACTIVITY Alpha 15 AC105 AC110
Element: Activity Activities are the processes or AC120 AC61.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
BRD-ACCT-CATEGORY Alpha 5 AC105 AC61.1
Element: Acct Category 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
BRD-BURDEN-CD Alpha 5 AC105 AC61.1
Element: Burden Cd
BRD-POOL-NBR Numeric 3 AC105 AC61.1
Element: Pool Nbr
ACBRDNDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRDSET1 ACTIVITY-GRP AC00.1 AC10.1
ACTIVITY AC105 AC110
ACCT-CATEGORY AC120 AC190
BURDEN-CD AC197 AC261
POOL-NBR AC300 AC310
AC61.1 BR04.1
BRDSET2 BURDEN-CD AC60.1 AC62.1
POOL-NBR
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
ACBRDNDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
BRD-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acacctcatx ACACCTCATX Required
BRD-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
BRD-ACTIVITY -> AXX-ACTIVITY
BRD-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
BRD-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
BRD-ACTIVITY -> ACV-ACTIVITY
Acbrdnhdr ACBRDNHDR Required
BRD-BURDEN-CD -> BRH-BURDEN-CD
Acbrdnpool ACBRDNPOOL Required
BRD-BURDEN-CD -> BPL-BURDEN-CD
BRD-POOL-NBR -> BPL-POOL-NBR
|