ACBUDDTL

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 AC00.2 AC00.3 AC02.1 AC05.2 AC05.3
AC10.1 AC220 AC27.1 AC297 AC310 AC56.1
AC560 AC65.2 AC65.1 AC82.2 AC82.3 ACBD.2
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 AC21.5
AC22.1 AC300 AC311 ACDR.1 AC08.3 AC08.7
AC527

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDT-ACTIVITY-GRP
Element: Activity Group
Alpha 15
Required key. This is the activity group for the budget information.
AC120 AC121
AC123 AC127
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 ACDR.1
BDT-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the budget information.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-BUDGET-NBR
Element: Budget Number
Numeric 3
Required key. This is the budget number uniquely defined in budget setup.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-ACCT-CATEGORY
Element: Account Category
Alpha 5
Required key. This is the account category for the budget information.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Required key. This is the budget year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
AC120 AC121
AC123 AC127
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 ACDR.1
BDT-COMPUTE-NAME
Element: Compute Name
Alpha 12
This is the name for a compute statement. You can use a compute statement to calculate the budget. Use the Compute action code and define a compute statement, consisting of data dictionary items and operation symbols. You can define compute statements in RW50.1 (Compute Statements).
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-PARAM-NAME
Element: Param Name
Alpha 12
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-MAINT-DATE
Element: Maintenance Date
Numeric 8 (yyyymmdd)
This is the date the budget was changed.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-MAINT-TIME
Element: Maintenance Time
Numeric 6 (hhmmss)
This is the time the budget was changed.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-SPREAD-CODE
Element: Spread Code
Alpha 3
A spread code is a formula for budgeting spending activity that can be set up in AC23.1 (Spread Codes). You can use a spread code to schedule spending over the life of the activity or activity group. Spread codes can be used to represent characteristic spending patterns.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-BALANCE
Element: Budget Balance
Signed 18.2
This is the annual balance of the budget for the indicated year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-BALANCE-UNIT
Element: Balance Unit
Signed 17.2
This is the units balance for the budget for the indicated year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-BEGIN-BAL
Element: Beginning Balance
Signed 18.2
This is the beginning balance for the budget for the indicated year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-BEGIN-BAL-UNIT
Element: Begin Bal Unit
Signed 15.2
This is the units balance for the budget for the indicated year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-FACTOR
Element: Factor
Alpha 15
The element that affects the budget change.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-FACTOR-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-BLANK
Element: Blank
Derived
This derived field is always blank. It is used in the Drill Around feature for column headings.
BDT-AMT-VARIANCE
Element: Amt Variance
Derived
This is the amount of the budget variance.
BDT-UNIT-VARIANCE
Element: Unit Variance
Derived
This is the number of units for the budget variance.
BDT-VARIANCE
Element: Variance
Derived
This is the percentage of variance from the budget amount.
BDT-VARIANCE-UNITS
Element: Variance Units
Derived
This is the percentage of variance from the units budget.
BDT-OVER-UNDER
Element: Over Under
Derived
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
Element: Over Under Unt
Derived
This 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
Element: Acct Cat Type
Derived
This is the account category type: cost, revenue, or accrual.
BDT-PERIOD-AMT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-PERIOD-UNIT
Element: Unit
Signed 15.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-PERIOD-FACTOR
Element: Factor
Alpha 15 Occurs 13 Times
The element that affects the budget change.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDT-PERIOD-RATE
Element: Factor Rate
Signed 14.7 Occurs 13 Times
You can type or select the rate that affects the factor. For example, you could type the inflation rate. If you select units and amounts, the rate is calculated.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1


ACBUDDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BDTSET1 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
...
AC00.1 AC00.2
AC00.3 AC02.1
AC05.2 AC05.3
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC10.1
AC120 AC121
AC123 AC127
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.1
AC21.3 AC21.4
AC21.5 AC22.1
BDTSET2 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
FISCAL-YEAR
ACCT-CATEGORY
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.1 AC21.2
AC21.3 AC21.4
AC220 AC32.1
AC37.1 AC490
AC527
BDTSET3 ACTIVITY-GRP
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
AC20.5
BDTSET4 SPREAD-CODE
ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
KeyChange
AC23.1
BDTSET6 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR*
AC121 AC123
AC127 AC130
AC165 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 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
BDTSET7 ACTIVITY-GRP
PARENT-ACTV
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
KeyChange


ACBUDDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Acbudtlbod ACBUDTLBOD Not Required, Delete Cascades
BDT-ACTIVITY-GRP->YAD-ACTIVITY-GRP
BDT-ACTIVITY->YAD-ACTIVITY
BDT-BUDGET-NBR->YAD-BUDGET-NBR
BDT-ACCT-CATEGORY->YAD-ACCT-CATEGORY
BDT-FISCAL-YEAR->YAD-FISCAL-YEAR
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


File created: Thu Jun 09 02:02:50 2016

Home
Contact Us



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