|
ACBUDDTL FILE
Activity Budget
This file contains activity budget information from the AC20 (Activity
Budget) forms. It includes activity group, activity, budget number, beginning
balance, account category, fiscal year, spread code, compute name, as well as
maintenance time and date.
REFERENCED BY
AC00.1 AC08.3 AC08.7 AC10.1 AC21.1 AC21.2
AC21.3 AC21.4 AC220 AC420 AC527 AC56.1
AC560 AC65.2 AC65.1 ACDL.1 ACTA.1 SNAC.1
AC130 AC32.1 AC37.1 AC490 AC23.1 AC165
BR12.2 BR130 BR165 BR530 BR65.1 BR65.2
BR65.3
UPDATED BY
AC120 AC121 AC123 AC127 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC22.1
AC300 AC310 ACDR.1 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDT-ACTIVITY-GRP Alpha 15 AC120 AC121
Element: Activity GroupRequired key. This is the activity AC123 AC127
group for the budget information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
ACDR.1 SB515
BDT-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Required key. This is the activity for AC127 AC20.1
the budget information. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number Required key. This is the budget number AC127 AC20.1
uniquely defined in budget setup. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoRequired key. This is the account AC127 AC20.1
category for the budget information. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year Required key. This is the budget year. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-PARENT-ACTV Alpha 15 AC120 AC121
Element: Parent Actv The parent activity field contains the AC123 AC127
activity name of the member parent. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
ACDR.1 SB515
BDT-COMPUTE-NAME Alpha 12 AC121 AC123
Element: Compute Name This is the name for a compute AC127 AC20.1
statement. You can use a compute AC20.2 AC20.3
statement to calculate the budget. Use AC20.4 AC20.5
the Compute action code and define a AC20.6 AC20.7
compute statement, consisting of data AC22.1 ACDR.1
dictionary items and operation symbols. SB515
You can define compute statements in
RW50.1 (Compute Statements).
BDT-PARAM-NAME Alpha 12 AC121 AC123
Element: Param Name AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Maintenance DaThis is the date the budget was AC127 AC20.1
changed. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Maintenance TiThis is the time the budget was AC127 AC20.1
changed. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-SPREAD-CODE Alpha 3 AC121 AC123
Element: Spread Code A spread code is a formula for AC127 AC20.1
budgeting spending activity that can be AC20.2 AC20.3
set up in AC23.1 (Spread Codes). You can AC20.4 AC20.5
use a spread code to schedule spending AC20.6 AC20.7
over the life of the activity or AC22.1 ACDR.1
activity group. Spread codes can be used SB515
to represent characteristic spending
patterns.
BDT-BALANCE Signed 18.2 AC121 AC123
Element: Budget BalanceThis is the annual balance of the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Balance Unit This is the units balance for the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-BEGIN-BAL Signed 18.2 AC121 AC123
Element: Beginning BalaThis is the beginning balance for the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-BEGIN-BAL-UNIT Signed 15.2 AC121 AC123
Element: Begin Bal UnitThis is the units balance for the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-FACTOR Alpha 15 AC121 AC123
Element: Factor The element that affects the budget AC127 AC20.1
change. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-FACTOR-RATE Signed 14.7 AC121 AC123
Element: Curr Rate The currency rate. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
BDT-AMT-VARIANCE Derived
Element: Amt Variance This is the amount of the budget
variance.
BDT-UNIT-VARIANCE Derived
Element: Unit Variance This is the number of units for the
budget variance.
BDT-VARIANCE Derived
Element: Variance This is the percentage of variance from
the budget amount.
BDT-VARIANCE-UNITS Derived
Element: Variance UnitsThis is the percentage of variance from
the units budget.
BDT-OVER-UNDER Derived
Element: Over Under This field indicates whether there is a
variance, either over or under, the
budgeted amount. If there is no
variance, the field is blank.
BDT-OVER-UNDER-UNT Derived
Element: Over Under UntThis field indicates whether there is a
variance, either over or under, the
budgeted number of units. If there is no
variance, the field is blank.
BDT-ACCT-CAT-TYPE Derived
Element: Acct Cat Type This is the account category type:
cost, revenue, or accrual.
BDT-PERIOD-AMT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-PERIOD-UNIT Signed 15.2 Occurs 13 Times AC121 AC123
Element: Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-PERIOD-FACTOR Alpha 15 Occurs 13 Times AC121 AC123
Element: Factor The element that affects the budget AC127 AC20.1
change. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDT-PERIOD-RATE Signed 14.7 Occurs 13 Times AC121 AC123
Element: Factor Rate You can type or select the rate that AC127 AC20.1
affects the factor. For example, you AC20.2 AC20.3
could type the inflation rate. AC20.4 AC20.5
AC20.6 AC20.7
If you select units and amounts, the AC22.1 ACDR.1
rate is calculated. SB515
ACBUDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BDTSET1 ACTIVITY-GRP AC00.1 AC08.3
ACTIVITY AC08.7 AC10.1
BUDGET-NBR AC120 AC121
ACCT-CATEGORY AC123 AC127
FISCAL-YEAR AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.1
AC21.2 AC21.3
AC21.4 AC22.1
AC220 AC300
AC310 AC420
AC527 AC56.1
AC560 AC65.2
ACDL.1 ACDR.1
...
BDTSET2 ACTIVITY-GRP AC121 AC123
ACTIVITY AC130 AC20.1
BUDGET-NBR AC20.2 AC20.3
FISCAL-YEAR AC20.4 AC20.5
ACCT-CATEGORY AC20.6 AC20.7
AC21.4 AC220
AC32.1 AC37.1
AC490 AC527
BDTSET3 ACTIVITY-GRP AC20.5
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
BDTSET4 SPREAD-CODE KeyChange AC23.1
ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
BDTSET6 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
BUDGET-NBR AC165 AC20.1
ACCT-CATEGORY AC20.2 AC20.3
FISCAL-YEAR* AC20.4 AC20.5
AC20.6 AC20.7
AC21.1 AC22.1
AC32.1 AC37.1
AC490 AC65.1
AC65.2 ACDR.1
ACTA.1 BR12.2
BR130 BR165
BR530 BR65.1
BR65.2 BR65.3
SB515
BDTSET7 ACTIVITY-GRP KeyChange
PARENT-ACTV
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
ACBUDDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
BDT-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
BDT-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
BDT-ACTIVITY-GRP -> ACV-ACTIVITY-GRP
BDT-ACTIVITY -> ACV-ACTIVITY
Acbudhdr ACBUDHDR Required
BDT-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
BDT-ACTIVITY -> BDH-ACTIVITY
BDT-BUDGET-NBR -> BDH-BUDGET-NBR
Accuamt ACCUAMT Not Required
BDT-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
BDT-ACTIVITY -> ACU-ACTIVITY
BDH-CURRENCY-CODE -> ACU-CURRENCY-CODE
BDT-BUDGET-NBR -> ACU-BUDGET-NBR
BDT-FISCAL-YEAR -> ACU-FISCAL-YEAR
BDT-ACCT-CATEGORY -> ACU-ACCT-CATEGORY
Acmaster ACMASTER Not Required
BDT-ACTIVITY-GRP -> MST-ACTIVITY-GRP
BDT-ACTIVITY -> MST-ACTIVITY
BDT-ACCT-CATEGORY -> MST-ACCT-CATEGORY
BDT-FISCAL-YEAR -> MST-FISCAL-YEAR
Acspread ACSPREAD Not Required
BDT-SPREAD-CODE -> SPR-SPREAD-CODE
|